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.
Estimated revenues:
|
Taxes (Property)
|
$3,000,000
|
|
Licenses and permits
|
800,000
|
|
Intergovernmental revenues
|
300,000
|
|
Miscellaneous revenues
|
200,000
|
Revenues:
|
Taxes (Property)
|
$3,000,000
|
|
Licenses and permits
|
801,320
|
|
Intergovernmental revenues
|
293,000
|
|
Miscellaneous revenues
|
198,000
|
Appropriations:
|
General government
|
$ 900,000
|
|
Public safety
|
2,000,000
|
|
Health and welfare
|
1,400,000
|
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 comparisons 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.