1. a. Which expense type had the highest unfavorable variance (in dollars)?

b. Which department had the highest unfavorable variance in that expense type?

c. Which expense type had the highest favorable variance (in dollars)?

d. Which department had the highest favorable variance in that expense type?

e. Which department had the highest percentage variance?

f. Which type of expense was most over or under budget in that department?

g. Which expense type had the highest percentage variance?

h. Which department was most over or under budget in that expense type?

G15 X for A B C D E G H J K 1 2 Budget 6.7% 3 4 Expense type 5 Athletics expense 6 Capital expenditures 7 Classroom supplies and materials 8 Food costs 9 Housing Assistance 10 Other expenses 11 Outside services 12 Professional services 13 Repairs and maintenance 14 Technology expenses 15 Transportation costs 16 Travel costs Actual $225,000 $4,515,000 $9,500,000 $1,305,000 $425,000 $3,760,000 $4,780,000 $2,100,000 $2,816,000 $611,500 $272,500 $75,500 $30,385,500 Variance $ $240,106 $4,165,396 $9,648,308 $1,373,230 $450,362 $3,619,536 $5,022,812 $2,261,894 $2,809,269 $561,960 $276,498 $82,407 $30,961,777 Variance % (15,106) (100,396) (148,308) (68,230) (25,362) 140,464 (242,812) (161,894) 6,731 49,540 (3,998) (6,907) 576,277 2.2% 1.6% 5.2% 6.0% 3.7% 5.1% 7.7% 0.2% 8.1% 1.5% 9.1% 1.9% 17 18 19 20 21 Budget 2 3 4 Expense type 5 Athletics expense 6 Capital expenditures 7 Classroom supplies and materials 8 Food costs 9 Housing Assistance 10 Other expenses 11 Outside services 2 Professional services 13 Repairs and maintenance 14 Technology expenses 15 Transportation costs 16 Travel costs 17 18 19 PO Actual $225,000 $4,515,000 $9,500,000 $1,305,000 $425,000 $3,760,000 $4,780,000 $2,100,000 $2,816,000 $611,500 $272,500 $75,500 $30,385,500 Variances $240,106 $4,165,396 $9,648,308 $1,373,230 $450,362 $3,619,536 $5,022,812 $2,261,894 $2,809,269 $561,960 $276,498 $82,407 $30,961,777 Variance % (15,106) (100,396) (148,308) (68,230) (25,362) 140,464 (242,812) (161,894) 6,731 49,540 (3,998) (6,907) 576,277 6.7% 2.2% 1.6% 5.2% 6.0% 3.7% 5.1% 7.7% 0.2% 8.1% 1.5% 9.1% 1.9%