A B C D E F G City of Sunnyview 2 Budgeted Expenditures (hypothetical) 3 For Year Ended December 31, 2016 2016 Variance Variance 5 Expenditure (Item Class) Budget Actual $ 6 Advertising 71,425 7 Athletics expense 36,500 Bonds and debt-related expenditures 6,880,425 9 Books 21,900 10 Dues and subscriptions 135,600 11 Education-related 325,678 12 Miscellaneous line item 48,952.663 13 Professional services expense 5 16,885,990 14 Property, plant and equipment 30,500,640 15 Rental expense 402.570 16 Repairs and maintenance expense 5 6,988,512 17 Supplies expense 20,684 18 Technology expense 645,815 19 Utilities expense 320,970 20 Total expenditures $ 112,189,372 21Using the pivot table you created for Requirement 1 for Sunnyview, what was the total spending for Sunnyview in 251 E? O A. $154,122,515 1:) 5. $152,545,551 @ c. $155,555,515 1:) 5. $155,552,125 Using the pivot table you created for Requirement 2fer Sunnyview, how much was spent in General Gmremment in 2016'? Q A. $115,271,145 {j 5. $21,147,515 ('31 c. $152,545,255 O 5. $55,555,555 Using the pivot table you created for Requirement 2for Sunnyview, how much was spent in Public Works in 2016? O A. $33,693,066 O B. $21,147,510 O 0. $41,283,065 O D. $119,277,143 Using the pivot table you created for Requirement 3 for Sunnyview, how much in expenditures did Sunnyview have in professional services expense in 2015'? O A. $19,367 0 B. $35,792,330 O 0. $20,370,734 O D. $16,885,990 Using the budgeted worksheet results from requirement 4 for Sunnyview, what was the variance expressed as a percentage for books? O A. -3.44% O B. - 1.50% O C. - 15.40% O D. -6.32% Using the budgeted worksheet results from requirement 4 for Sunnyview, how many variances had a red diamond? O A. 9 O B. None OC. 8 OD. 5