Data Set A
This is a generalized fictious data set to utilize in responding to the questions on the other tabs.
FY 2019
Actuals FY 2020
Actuals FY 2021
Actuals FY 2022
Forecast FY 2023
Forecast FY 2024
Forecast
Sources
Sales and Services
Conference/Event Revenue 2,598,399 2,720,570 2,790,475 2,960,293 301,733 271,811
Transportation 1,095,493 776,444 1,098,299 989,435 985,485 1,537,149
Merchandise Sales 17,809 17,008 15,255 14,556 11,901 115,444
Early A
ival 99,794 71,741 65,167 124,188 274,948 529,728
Misc Income 41,326 46,336 56,661 48,634 50,151 40,464
Food Sales 45,894,244 45,992,119 42,101,009 41,102,699 39,106,517 38,113,590
Summer Fees 476,513 531,390 566,958 193,675 824,090 896,120
Autumn Fees 37,312,264 39,195,526 40,980,667 54,142,742 55,785,706 58,949,973
Spring Fees 36,367,696 38,176,935 39,931,126 52,934,957 48,116,337 45,694,599
Health Services 2,266,363 2,187,496 2,328,306 2,113,077 1,375,306 903,637
Rec Center 1,139,163 1,106,549 1,306,970 1,624,270 1,913,756 3,164,403
Counseling 415,050 421,200 444,113 403,525 450,220 428,500
Fees 20,277,350 24,343,450 16,540,325 17,372,250 24,422,065 11,957,000
General Funds
General Fund Support 10,054,058 10,055,113 10,164,061 14,088,941 15,192,990 17,193,554
Internal Space Rental
Space Rental 1,318,768 1,573,629 1,387,481 1,248,916 939,837 1,171,813
Transfers In
Transfers In 1,520,321 1,564,007 1,534,581 2,498,772 3,324,036 3,766,761
Total Sources 160,894,611 168,779,513 161,311,454 191,860,930 193,075,078 184,734,546
Uses
Personnel
Staff 22,740,465 22,857,572 23,114,170 25,768,522 29,315,744 32,279,332
Overtime 6,018,935 6,126,590 5,690,195 4,913,228 3,013,801 1,112,233
Student Wages 3,428,960 3,219,151 3,078,855 2,968,512 2,511,139 2,449,140
Temporary 1,547,798 1,628,009 1,417,445 1,121,165 980,100 631,914
Benefits
Employee Benefits Budget Pool 4,645,166 4,628,347 4,778,778 4,795,330 4,889,339 4,950,012
Supplies and Services
Cost of Sales 1,018,451 1,086,711 1,204,312 2,313,054 2,532,437 2,421,060
Supplies 23,607,356 28,252,335 26,172,897 35,250,671 33,139,755 36,467,908
Communications 431,128 442,607 420,418 452,430 391,984 425,565
Utilities 7,506,116 6,895,994 6,521,586 10,129,259 11,034,091 12,962,079
Equipment 136,740 128,781 195,673 201,232 260,763 395,893
Repairs 721,863 1,279,627 1,605,809 1,821,927 1,621,336 2,754,725
Rentals 105,340 79,547 78,726 75,331 96,854 88,051
Travel 246,983 281,901 227,001 189,821 231,156 238,085
Services 1,919,323 2,440,833 1,794,421 2,342,033 3,909,275 3,607,566
Marketing 11,334,958 12,239,680 16,451,521 17,735,008 17,699,051 19,005,734
Other Expenses 1,028,880 1,005,876 1,109,285 1,182,453 888,688 1,372,882
Scholarships 222,565 233,794 256,587 213,625 155,152 150,500
University Overhead
University Overhead Bdgt Pool 4,772,812 5,015,007 5,232,752 6,676,013 6,704,926 7,094,383
Admin Expenses
Websites (1,355) 0 0 8 8,885 (5,897)
Security Access 8,859,663 8,781,865 9,198,429 11,719,561 11,720,374 12,218,050
Transfers Out
Debt Service 34,844,401 37,017,104 40,948,257 40,926,599 40,904,942 40,582,050
Capital Projects 9,000,000 6,500,000 8,640,000 17,000,000 21,600,000 15,000,000
Total Uses 144,136,548 150,141,331 158,137,117 187,595,782 193,459,792 196,050,765
Net Margin 16,758,063 18,638,182 3,174,337 4,265,148 (384,714) (11,316,219)
Ending Equity Balance 21,384,499 40,022,681 43,197,018 47,462,166 47,077,452 35,761,233
Q1 Trend Analysis-Concerns
1. From Data Set A, please provide a visual representation showing the trends you see in the data that are most concerning to you.
Please be prepared to describe your analysis, questions, and/or assumptions you made in reviewing this information.
Q2 Trend Analysis-Positives
2. From Data Set A, please provide a visual representation showing the trends you see in the data that highlight what is going well.
Please be prepared to describe your analysis, questions, and/or assumptions you made in reviewing this information.
Q3 Briefing
3. From the analysis you completed in Q1 & Q2, provide an Executive Summary that will be provided to Senior Leadership.
Q4 Headcount Change
4. How has staffing headcount by category changed from 2017 to 2018?
Headcount Student Employees Executive/ administrative and managerial staff Other professional staff Non-professional staff Headcount Student Employees Executive/ administrative and managerial staff Non-professional staff Other professional staff
2018 3918 272 303 879 2017 3774 224 855 322
Answer:
Student Employees Executive/ administrative and managerial staff Other professional staff Non-professional staff 3918 272 303 879 Student Employees Executive/ administrative and managerial staff Non-professional staff Other professional staff 3774 224 855 322
Q5 General Analysis
5. For this data, please provide a data analysis visualization and description.
Level Job Title Balancing Unit Spend Category Position Type Pay Rate Per CA Salary Cu
FY FTE
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 20.63 Hr 42,910 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.50 Hr 38,480 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 19.04 Hr 39,603 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 21.07 Hr 43,826 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 20.11 Hr 41,829 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.27 Hr 15,936 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 21.07 Hr 43,826 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.33 Hr 38,126 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.27 Hr 38,002 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.50 Hr 38,480 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.00 Hr 37,440 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.27 Hr 38,002 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 20.39 Hr 42,411 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.27 Hr 37,491 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 17.50 Hr 36,400 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 22.35 Hr 46,488 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 19.88 Hr 36,237 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 19.45 Hr 40,456 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.56 Hr 38,605 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 20.74 Hr 43,139 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 19.26 Hr 40,061 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.15 Hr 37,752 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 20.09 Hr 41,787 1.00
Department B Assistant Chef - 0505 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Seasonal (Seasonal) 18.50 Hr 38,480 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 19.25 Hr 32,032 1.00
Department A Assistant Chef - 0505 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 18.33 Hr 38,126 1.00
Department A Assistant Director-Food Svcs - 0735 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 60,000.00 Yr 60,000 1.00
Department A Assistant Director-Food Svcs - 0735 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 85,000.00 Yr 85,000 1.00
Department A Assistant Director-Food Svcs - 0735 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 70,000.00 Yr 70,000 1.00
Department A Assistant Director-Food Svcs - 0735 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 69,000.00 Yr 69,000 1.00
Department A Assistant Director-Food Svcs - 0735 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 68,000.00 Yr 68,000 1.00
Department A Assistant Director-Food Svcs - 0735 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 85,100.00 Yr 85,100 1.00
Department A Assistant Director-Food Svcs - 0735 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 67,700.00 Yr 67,700 1.00
Department A Assoc Dir-Res&Dining,Food Svc - 2276 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 88,200.00 Yr 88,200 1.00
Department A Assoc Dir-Res&Dining,Food Svc - 2276 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 110,350.00 Yr 110,350 1.00
Department A Assoc Dir-Res&Dining,Food Svc - 2276 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 97,000.00 Yr 97,000 1.00
Department A Assoc Dir-Res&Dining,Food Svc - 2276 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 100,000.00 Yr 100,000 1.00
Department A Business Manager XXXXXXXXXX BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 62,000.00 Yr 62,000 1.00
Department A Business Manager XXXXXXXXXX BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 93,005.00 Yr 93,005 1.00
Department A Catering Operations Assistant - 2787 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Classified Civil Service Base Regular >=50% Regular 20.32 Hr 42,266 1.00
Department A Catering Sales Manager - 2788 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 47,210.00 Yr 47,210 1.00
Department A Catering Sales Manager - 2788 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 53,900.00 Yr 53,900 1.00
Department A Chef - 2841 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 51,500.00 Yr 51,500 1.00
Department A Chef - 2841 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 52,300.00 Yr 52,300 1.00
Department A Chef - 2841 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 50,600.00 Yr 50,600 1.00
Department A Chef - 2841 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 55,000.00 Yr 55,000 1.00
Department A Chef - 2841 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 53,000.00 Yr 53,000 1.00
Department A Chef - 2841 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 59,000.00 Yr 59,000 1.00
Department B Chef - 2841 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 67,000.00 Yr 67,000 1.00
Department A Chef - 2841 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Unclassified Base Regular >=50% Regular 54,000.00 Yr 54,000 1.00
Department A Delivery Worker XXXXXXXXXX BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Classified Civil Service Base Regular >=50% Regular 15.00 Hr 26,168 1.00
Department A Delivery Worker XXXXXXXXXX BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Classified Civil Service Base Regular >=50% Regular 15.45 Hr 32,136 1.00
Department B Dining Utility Worker - 4262 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Classified Civil Service Base Regular >=50% Regular 17.81 Hr 37,045 1.00
Department B Dining Utility Worker - 4262 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Classified Civil Service Base Regular >=50% Regular 15.87 Hr 33,010 1.00
Department B Dining Utility Worker - 4262 BL1504 Student Life Traditions Dining Earnings SC XXXXXXXXXXSalaries Classified Civil Service Base Regular >=50% Regular 15.00 Hr 16,606 1.00
Department A Dining Utility Worker - 4262 BL1611 Student Life Dining Services Earnings SC XXXXXXXXXXSalaries Classified Civil Service