1 City of Little Lake 2 Budgeted Expenditures (hypothetical) 3 For Year Ended December 31, 2016 4 5 Expenditure (Item Class) 6 Advertising Budget Actual $ 68,515 7 Athletics expense $ 39,541 8 Bonds and debt-related expenditures $3,29,14,557 9 Books $ 26,884 10 Dues and subscriptions $ 1,95,976 11 Education-related $ 3,65,991 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 $5,34,67,889 $ SSSSSS 93,56,421 $ 70,09,650 $ 4,17,840 $ 35,51,672 $ 20,150 $ 6,50,884 $ 3,00,400 20 21 22 Total expenditures 2016 Variance Variance $ % 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 proosed with answering the questions until you have asked for assistance from your instructor Using the pivot table you created for Requirement 1 for Little Lake, what was the total spending for Lite Lake in 2013? OA $187.916,802 OB. $173,607,086 OC. $228.888,942 OD $186,373,768 Using the pivot table you created for Requirement 2 for Little Lake, how much was spent in General Government in 2013? A. $45,280,049 B. $127,996,444 OC. $107,474,101 OD. $14,640,309 Using the pivot table you created for Requirement 2 for Little Lake, how much was spent in Public Works in 2013? OA. $14,640,309 B. $51,262,380 C. $45,280,049 OD. $127,996,444 Using the niunt thin Using the pivot table you created for Requirement 3 for Little Lake, how much in expenditures did Little Lake have in professional services expense in 2013? OA. $5,483,526 B. $28,881,676 OC. $20,025 OD. $4,243,142 Using the budgeted worksheet results from requirement 4 for Little Lake, what was the variance expressed as a percentage for books? OA. -8.98% OB. -3.33% OC. -5.43% OD. 12.75% Using the budgeted worksheet results from requirement 4 for Little Lake, what was the dollar amount of the variance for technology expense? OA. $(5,040) OB. $(602) OC. $13,642 OD. $(13,614)