Response to the following problem:
The City of Grafton's records reflected the following budget and actual data for the General Fund for the fiscal year ended June 30, 2012.
1. Estimated revenues:
Taxes (Property) ............. $3,000,000
Licenses and permits ............ 800,000
Intergovernmental revenues ..... 300,000
Miscellaneous revenues .......... 200,000
2. Revenues:
Taxes (Property) ............... $3,000,000
Licenses and permits ............ 801,320
Intergovernmental revenues ..... 293,000
Miscellaneous revenues .......... 198,000
3. Appropriations:
General government ............. $ 900,000
Public safety ...................... 2,000,000
Health and welfare ............... 1,400,000
4. Expenditures of 2012 appropriations:
General government ............... $ 880,000
Public safety ......................... 1,949,000
Health and welfare .................. 1,398,000
5. Encumbrances of 2012 appropriations, outstanding as of June 30, 2012.
General government .................... $18,000
Public safety .............................. 50,000
6. Transfer to debt service fund:
Budget ................................... $600,000
Actual ...................................... 600,000
7. Budget revisions approved by the city council:
Estimated revenues:
Decrease intergovernmental revenues ... $10,000
Decrease miscellaneous revenues ............ 3,000
Appropriations:
Decrease general government ................... 2,000
8. Total fund balance at July 1, 2011, was $1,038,000.
Required:
Use the Excel file provided to prepare a budgetary comparision schedule for the City of Grafton for the fiscal year ended June 30, 2012. Include outstanding encumbrances with expenditures. Use the formula feature (e.g., sum, =, etc.) of Excel to calculate the amounts in cells shaded blue.