Poste Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A4 A B D E F H G 1 City of Little Lake 2 Budgeted Expenditures (hypothetical) 3 For Year Ended December 31, 2016 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 22 23 24 25 26 27 28 29 30 31 Budget $ 68,515 $ 39,541 $ 32,914,557 $ 26,884 $ 195,976 S 365,991 $ 53,467,889 $ 9,356,421 $ 7,009,650 $ 417,840 $ 3,551,672 $ 20,150 $ 650,884 $ 300,400 $ 108,386,370 Using the pivot table you created for Requirement 2 for Little Lake, how much was spent in Public Works in 2013? A. $51,262,380 B. $127,996,444 C. $45,280,049 OD. $14,640,309 Using the pivot table you created for Requirement 3 for Little Lake, how much was supplies expense in 2013? O A. $20,025 B. $89,133 C. $17.730 D. $5,483,526 Using the budgeted worksheet results from requirement 4 for Little Lake, what was the variance expressed as a percentage for bonds and debt-related expeditures? A-898% OB-3.33% OC.-5.43% OD. 12.75% Using the budgeted worksheet results from requirement 4 for Lito Lake, what was the dollar amount of the variance for technology expertse? OAS(5,040) OB. S(13.614) OC. (602) OD. $13,642 Poste Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A4 A B D E F H G 1 City of Little Lake 2 Budgeted Expenditures (hypothetical) 3 For Year Ended December 31, 2016 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 22 23 24 25 26 27 28 29 30 31 Budget $ 68,515 $ 39,541 $ 32,914,557 $ 26,884 $ 195,976 S 365,991 $ 53,467,889 $ 9,356,421 $ 7,009,650 $ 417,840 $ 3,551,672 $ 20,150 $ 650,884 $ 300,400 $ 108,386,370 Using the pivot table you created for Requirement 2 for Little Lake, how much was spent in Public Works in 2013? A. $51,262,380 B. $127,996,444 C. $45,280,049 OD. $14,640,309 Using the pivot table you created for Requirement 3 for Little Lake, how much was supplies expense in 2013? O A. $20,025 B. $89,133 C. $17.730 D. $5,483,526 Using the budgeted worksheet results from requirement 4 for Little Lake, what was the variance expressed as a percentage for bonds and debt-related expeditures? A-898% OB-3.33% OC.-5.43% OD. 12.75% Using the budgeted worksheet results from requirement 4 for Lito Lake, what was the dollar amount of the variance for technology expertse? OAS(5,040) OB. S(13.614) OC. (602) OD. $13,642
