(Operating expense work sheet)
From the following data, prepared as of August 30, 2004, prepare an operating expense work sheet to be used in the fiscal year 2005 budget of the Streets and Parkways Department of Bacchus City.

Rest Object of Prior-Year Current-Year Year-to-Date of Year Code Expenditure Actual Budget Actual Est. Act.
Contractual Services 320 ~~ Vehicle and equip- $18,450 $20,000 $15,000 $6,000 ment maintenance 330 Communication 1,200 1,200 800 400 340 _— Rentals 648 800 600 200 365 — Utilities 1,146 1,200 952 300 370 ~—-T elephone 240 240 180 80 380 Professional services 300 500 350 a Supplies and Materials 410 Office supplies 214 200 158 42 415 ~~ Auto and truck 286 300 200 100 418 Equipment supplies 1,614 1,500 1,250 400 420 Asphalt 3,847 4,000 3,000 1,500 425 Fuel 1,206 1,200 860 300 430 Emergency supplies 152 200 50 100 440 Tools 876 1,000 800 200 450 Miscellaneous 136 100 ge) —
Additional information:
1. Because of the crew expected to be added in 2005, the budgeted vehicle and equipment maintenance, equipment supplies, tools, and fuel expenditures are to be increased by 15 percent in 2005.
. The budget for professional services is to be decreased by 20 percent.
3. The budgets for communications and miscellaneous supplies and materials should remain at their present levels.

4. An inflation factor of 8 percent should be applied to the fiscal year 2004 budget for the remaining items.
5. For this department, professional services consist largely of tree surgery and medical expenses for minor injuries of work crews.

Transcribed Image Text:

Code Object of Expenditure Prior-Year Current-Year Year-to-Date Actual Budget Actual Rest of Year Est. Act. Contractual Services 320 Vehicle and equip- $18,450 $20,000 $15,000 $6,000 ment maintenance 330 Communication 1,200 1,200 800 400 340 Rentals 648 800 600 200 365 Utilities 1,146 1,200 952 300 370 Telephone 240 240 180 80 380 Professional services 300 500 350 Supplies and Materials 410 Office supplies 214 200 158 42 415 Auto and truck 286 300 200 100 418 Equipment supplies 1,614 1,500 1,250 400 420 Asphalt 3,847 4,000 3,000 1,500 425 Fuel 1,206 1,200 860 300 430 Emergency supplies 152 200 50 100 440 Tools 876 1,000 800 200 450 Miscellaneous 136 100 75