the city of grafton s records reflected the following budget and 362588

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.