University of Nevada School of Medicine Creating a Self-Supporting Budget Training

1. LOGGING IN TO THE UNSOM BUDGET SYSTEM Click on these buttons to advance tutorial Follow the red number sequence when there are more than one buttons to click 1 University of Nevada School of MedicineCreating a Self-Supporting Budget Training http://www.medicine.nevada.edu/budget/ Click on the above hyperlink to go to the UNSOM Web Site

2. LOGGING IN TO THE UNSOM BUDGET SYSTEM University of Nevada School of MedicineCreating a Self-Supporting Budget Training Budgeting Module (new)

3. THE UNSOM BUDGET SYSTEM 3 1 2 Login University of Nevada School of MedicineCreating a Self-Supporting Budget Training Enter your username and password here and click on login

4. THE UNSOM BUDGET SYSTEM University Budget University of Nevada School of MedicineCreating a Self-Supporting Budget Training

5. THE UNSOM BUDGET SYSTEM University of Nevada School of MedicineCreating a Self-Supporting Budget Training FAMILY & COMMUNITY MED-PHARM1

6. THE UNSOM BUDGET SYSTEM University of Nevada School of MedicineCreating a Self-Supporting Budget Training CAMPUS PHARMACY 1 REIMBURSE

7. University of Nevada School of MedicineCreating a Self-Supporting Budget Expenditure 4 3 2 1 $127,500.00 $120,000.00

8. THE UNSOM BUDGET SYSTEM University of Nevada School of MedicineCreating a Self-Supporting Budget Training Save Enter the desired information in the appropriate field and click on the SAVE button

9. University of Nevada School of MedicineCreating a Self-Supporting Budget 1 Verify YTD Exp in CAIS 2 3 YR Weighted Average Advance Slide 3

10. THE UNSOM BUDGET SYSTEM Reports University of Nevada School of MedicineCreating a Self-Supporting Budget Training

11. THE UNSOM BUDGET SYSTEM University of Nevada School of MedicineCreating a Self-Supporting Budget Training

12. THE UNSOM BUDGET SYSTEM University of Nevada School of MedicineCreating a Self-Supporting Budget Training View

13. FY14 – Prof Salary Projection University of Nevada School of MedicineCreating a Self-Supporting Budget Advance Slide

14. University of Nevada School of MedicineCreating a Self-Supporting Budget Training CAIS Opening Balance 1 This field is auto-calculated 120,000 127,500 2 3 Advance Slide

15. 1 43,900 43,900 2 118,630 118,628 University of Nevada School of MedicineCreating a Self-Supporting Budget Training These amounts come from the UNSOM Salary Budget System. Objects 11, 14 and 16 must match the CAIS CPL. This field is auto-calculated This field is auto-populated from Form 2 - Oper 3 (49,875) (79,884) This field is auto-calculated Advance Slide 4

16. University of Nevada School of MedicineCreating a Self-Supporting Budget Training 1 3011 Enter the object/sub-object in the field to the left. The object title will auto-populate. Then enter FY13 and FY14 amounts from the Budget System. 2 Advance Slide

17. FY13 CAIS YTD EXPENDITURE DETAIL University of Nevada School of MedicineCreating a Self-Supporting Budget BACK

18. FY13 Opening Balance University of Nevada School of MedicineCreating a Self-Supporting Budget BACK

19. FY13 Revenue Projection FY10 REVENUE TIMES 20% FY13 BUDGETED REVENUE FY12 REVENUE TIMES 50% FY11 REVENUE TIMES 30% University of Nevada School of MedicineCreating a Self-Supporting Budget =IF(ROUND((143552.06*0.5)+(148676.51*0.3)+(157838.45*0.2),-2)>120000,120000 FY13 revenue was calculated using a three year weighted average, limited to the FY13 revenue budget BACK

20. FY14 Revenue Projection FY13 PROJ REVENUE TIMES 50% FY12 REVENUE TIMES 30% FY11 REVENUE TIMES 20% FY14 BUDGETED REVENUE University of Nevada School of MedicineCreating a Self-Supporting Budget =IF(ROUND((120000*0.5)+(143552.06*0.3)+(148676.51*0.2),-2)>127500,127500 FY14 revenue was calculated using a three year weighted average, limited to $127,500 BACK

21. FY13 Operating Expense Projections FY10 EXPENSE TIMES 20% FY11 EXPENSE TIMES 30% FY12 EXPENSE TIMES 50% University of Nevada School of MedicineCreating a Self-Supporting Budget 3011 – Supplies Lab =ROUND( (300*0.2) + (600*0.3) + (1267*0.5) ,-1) 3030 – Postage =ROUND( (706*0.2) + (649*0.3) + (136*0.5) ,-1) 3086 – Telephone Long Dist =ROUND( (142*0.2) + (121*0.3) + (98*0.5) ,-1) FY13 Expense Budgets that were calculated using a three year weighted average BACK

22. University of Nevada School of MedicineCreating a Self-Supporting Budget BACK

23. University of Nevada School of MedicineCreating a Self-Supporting Budget BACK

24. University of Nevada School of MedicineCreating a Self-Supporting Budget 1 2 SHOW UNSOM REPORT SHOW CAIS REPORT BACK 3

25. University of Nevada School of MedicineCreating a Self-Supporting Budget BACK

26. University of Nevada School of MedicineCreating a Self-Supporting Budget BACK

27. FY14 – UNSOM BUDGET SYSTEM - Prof Salary Projection University of Nevada School of MedicineCreating a Self-Supporting Budget BACK

28. FY14 CAIS CPL – Prof Salary Projection University of Nevada School of MedicineCreating a Self-Supporting Budget BACK

29. This concludes our presentation. Budget due dates are included below. Call Dane Apalategui at 682-8808 if you have any questions. Thank You University of Nevada School of MedicineCreating a Self-Supporting Budget BUDGET DUE DATES: Administrative Budgets due to UNSOM B & F April 12, 2013 Basic Sciences Budgets due to UNSOM B & F April 19, 2013 Clinical Sciences Budgets due to UNSOM B & F May 01, 2013