X Township's City Budget Report Variance reported by Department Department Budgeted Amount $ Actual Amount $ Variance (in dollars) Variance (in percent) Schools $ 12,360,000 00 $ 12,547,310 38 Office of Planning, Development, and Management $ 10,875,000 00 $ 10,946,293 47 Information Technology $ 1,550,000 00 $ 1,739,606 05 Traffic and Parking $ 950,000 00 $ 881,421 36 Police Department $ 735,000 00 $ 744,834 54 Communications Department $ 700,000 00 $ 782,045 11 Recreation and Youth $ 670,000 00 $ 651,034 17 Legal Department $ 587,500 00 $ 607,647 85 Fire Department $ 510,000 00 $ 550,400 23 Board of Health $ 357,500 00 $ 417,415 15 Public Libraries $ 347,500 00 $ 329,920 82 Personnel Department $ 202,500 00 $ 206,781 72 Office of the Mayor $ 176,500 00 $ 124,345 77 Arts Council $ 171,000 00 $ 187,124 91 Council on Aging $ 128,000 00 $ 174,733 27 City Clerk's Office $ 65,000 00 $ 70,862 48 X Township's City Budget Report Variance reported by Expenses Expense Type Budgeted Amount $ Actual Amount $ Variance (in dollars) Variance (in percent) Classroom supplies and materials $ 9,500,000 00 $ 9,648,308 19 Outside services $ 4,780,000 00 $ 5,022,811 95 Capital expenditures $ 4,515,000 00 $ 4,615,395 83 Other expenses $ 3,760,000 00 $ 3,619,535 74 Repairs and maintenance $ 2,816,000 00 $ 2,809,268 86 Professional services $ 2,100,000 00 $ 2,261,893 61 Food costs $ 1,305,000 00 $ 1,373,230 04 Technology expenses $ 611,500 00 $ 561,960 48 Housing Assistance $ 425,000 00 $ 450,361 75 Transportation costs $ 272,500 00 $ 276,498 24 Athletics expense $ 225,000 00 $ 240,105 54 Travel costs $ 75,500 00 $ 82,407 05 please first find variance reports in dollars and percentage then answer the following questions A) a Which department experienced the greatest variance between budgeted and actual cost (in dollars) b Which expense type in that department accounted for the largest share of the variance B) a Which expense type had the highest unfavorable variance (in dollars) b Which department had the highest unfavorable variance in that expense type c Which expense type had the highest favorable variance (in dollars) d Which department had the highest favorable variance in that expense type C) a Which department had the highest percentage variance b Which type of expense was most over or under budget in that department c Which expense type had the highest percentage variance d Which department was most over or under budget in that expense type D) Schools had the largest budget Does it appear that the budget dollars were well managed Explain your answer

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 20, 2024

X Township's City Budget Report Variance reported by Department Department Budgeted Amount $ Actual Amount $ Variance (in dollars) Variance (in percent) Schools $ 12,360,000.00

X Township's City
Budget Report Variance reported by Department
Department	Budgeted Amount $	Actual Amount $	Variance (in dollars)	Variance (in percent)
Schools	$ 12,360,000.00	$ 12,547,310.38	?	?
Office of Planning, Development, and Management	$ 10,875,000.00	$ 10,946,293.47	?	?
Information Technology	$ 1,550,000.00	$ 1,739,606.05	?	?
Traffic and Parking	$ 950,000.00	$ 881,421.36	?	?
Police Department	$ 735,000.00	$ 744,834.54	?	?
Communications Department	$ 700,000.00	$ 782,045.11	?	?
Recreation and Youth	$ 670,000.00	$ 651,034.17	?	?
Legal Department	$ 587,500.00	$ 607,647.85	?	?
Fire Department	$ 510,000.00	$ 550,400.23	?	?
Board of Health	$ 357,500.00	$ 417,415.15	?	?
Public Libraries	$ 347,500.00	$ 329,920.82	?	?
Personnel Department	$ 202,500.00	$ 206,781.72	?	?
Office of the Mayor	$ 176,500.00	$ 124,345.77	?	?
Arts Council	$ 171,000.00	$ 187,124.91	?	?
Council on Aging	$ 128,000.00	$ 174,733.27	?	?
City Clerk's Office	$ 65,000.00	$ 70,862.48	?	?

X Township's City
Budget Report Variance reported by Expenses
Expense Type	Budgeted Amount $	Actual Amount $	Variance (in dollars)	Variance (in percent)
Classroom supplies and materials	$ 9,500,000.00	$ 9,648,308.19	?	?
Outside services	$ 4,780,000.00	$ 5,022,811.95	?	?
Capital expenditures	$ 4,515,000.00	$ 4,615,395.83	?	?
Other expenses	$ 3,760,000.00	$ 3,619,535.74	?	?
Repairs and maintenance	$ 2,816,000.00	$ 2,809,268.86	?	?
Professional services	$ 2,100,000.00	$ 2,261,893.61	?	?
Food costs	$ 1,305,000.00	$ 1,373,230.04	?	?
Technology expenses	$ 611,500.00	$ 561,960.48	?	?
Housing Assistance	$ 425,000.00	$ 450,361.75	?	?
Transportation costs	$ 272,500.00	$ 276,498.24	?	?
Athletics expense	$ 225,000.00	$ 240,105.54	?	?
Travel costs	$ 75,500.00	$ 82,407.05	?	?

please first find variance reports in dollars and percentage then answer the following questions: A) a.Which department experienced the greatest variance between budgeted and actual cost (in dollars)? b.Which expense type in that department accounted for the largest share of the variance? B) a.Which expense type had the highest unfavorable variance (in dollars)? b.Which department had the highest unfavorable variance in that expense type? c.Which expense type had the highest favorable variance (in dollars)? d.Which department had the highest favorable variance in that expense type? C) a.Which department had the highest percentage variance? b.Which type of expense was most over or under budget in that department? c.Which expense type had the highest percentage variance? d.Which department was most over or under budget in that expense type? D). Schools had the largest budget. Does it appear that the budget dollars were well managed? Explain your answer.