1 City of Little Lake 2 Budgeted Expenditures (hypothetical) 3 For Year Ended December 31, 2016 4 5 Expenditure (Item Class) 6 Advertising 7 Athletics expense Budget Actual $ 68,515 $ 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 $ 5,34,67,889 13 Professional services expense $ 93,56,421 14 Property, plant and equipment $ 70,09,650 15 Rental expense $ 4,17,840 16 Repairs and maintenance expense $ 35,51,672 17 Supplies expense $ 20,150 18 Technology expense $ 6,50,884 19 Utilities expense $ 3,00,400 20 Total expenditures $ 10,83,86,370 21 22 2016 Varia 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 ques 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 Little Lake in 20137 OA $187.916,802 OB. $173,097,086 OC. $228.888.9421 OD. $100,373,788 Using the pivot table you created for Requirement 2 for Little Lake, how much was spent in General Government in 2013? OA $45.280049 OB $127.900 444 OC. $107,474,101 OD $14,640,300 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 OB. $51,262,380 OC. $45,280,049 OD. $127,996,444 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? A. $5,483,526 B. $28,881,676 C. $20,025 OD. $4,243,1421 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) B. $(602) C. $13,642 OD. $(13,614)