This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the

Check Figures Requirement 1: Cell D5 $183,982,129 Requirement 2: Cell B7 $41,283,065 Requirement 3: Cell $26,788 D16 Requirement 4: Cell D7 : $(1,577) B E TI G A 1 City of Sunnyview 2 Budgeted Expenditures (hypothetical) 3 For Year Ended December 31, 2016 4 2016 Variance $ Variance % Actual 5 Expenditure (Item Class) 6 Advertising 7 Athletics expense 8 Bonds and debt-related expenditures 9 Books 10 Dues and subscriptions 11 Education-related 12 Miscellaneous line item 13 Professional services expense 14 Property, plant and equipment 15 Rental expense 16 Repairs and maintenance expense 17 Supplies expense 18 Technology expense 19 Utilities expense 20 Total expenditures 21 Budget $ 71,425 $ 36,500 $ 6,880,425 $ 21,900 $ 135,600 $ 325,678 $ 48,952,663 $ 16,885,990 $ 30,500,640 $ 402,570 $ 6,988,512 $ 20,684 $ 645,815 $ 320,970 $ 112,189,372 Using the pivot table you created for Requirement 1 for Sunnyview, what was the total spending for Sunnyview in 2016? O A. $174,122,819 B. $137,943,091 OC. $156,556,916 D. $183,982,129 Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in General Government in 2016? O A. $119,277,143 B. $21,147,610 C. $102,348,273 OD. $33,698,066 Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in Public Works in 2016? O A. $33,698,066 O B. $21,147,610 OC. $41,283,065 OD. $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 2016? O A. $19,367 OB. $36,792,330 O c. $20,370,734 OD. $16,885,990 Using the budgeted worksheet results from requirement 4 for Sunnyview, what was the variance expressed as a percentage for books? OA. -3.44% OB. - 1.50% O C. - 15.40% OD. -6.32% Using the budgeted worksheet results from requirement 4 for Sunnyview, how many variances had a red diamond? OA. 9 OB. None OC. 8 OD. 5 Check Figures Requirement 1: Cell D5 $183,982,129 Requirement 2: Cell B7 $41,283,065 Requirement 3: Cell $26,788 D16 Requirement 4: Cell D7 : $(1,577) B E TI G A 1 City of Sunnyview 2 Budgeted Expenditures (hypothetical) 3 For Year Ended December 31, 2016 4 2016 Variance $ Variance % Actual 5 Expenditure (Item Class) 6 Advertising 7 Athletics expense 8 Bonds and debt-related expenditures 9 Books 10 Dues and subscriptions 11 Education-related 12 Miscellaneous line item 13 Professional services expense 14 Property, plant and equipment 15 Rental expense 16 Repairs and maintenance expense 17 Supplies expense 18 Technology expense 19 Utilities expense 20 Total expenditures 21 Budget $ 71,425 $ 36,500 $ 6,880,425 $ 21,900 $ 135,600 $ 325,678 $ 48,952,663 $ 16,885,990 $ 30,500,640 $ 402,570 $ 6,988,512 $ 20,684 $ 645,815 $ 320,970 $ 112,189,372 Using the pivot table you created for Requirement 1 for Sunnyview, what was the total spending for Sunnyview in 2016? O A. $174,122,819 B. $137,943,091 OC. $156,556,916 D. $183,982,129 Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in General Government in 2016? O A. $119,277,143 B. $21,147,610 C. $102,348,273 OD. $33,698,066 Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in Public Works in 2016? O A. $33,698,066 O B. $21,147,610 OC. $41,283,065 OD. $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 2016? O A. $19,367 OB. $36,792,330 O c. $20,370,734 OD. $16,885,990 Using the budgeted worksheet results from requirement 4 for Sunnyview, what was the variance expressed as a percentage for books? OA. -3.44% OB. - 1.50% O C. - 15.40% OD. -6.32% Using the budgeted worksheet results from requirement 4 for Sunnyview, how many variances had a red diamond? OA. 9 OB. None OC. 8 OD. 5