The city of grafton’s records reflected the following budget and actual data for the general fund for the fiscal year ended june 30, 2017. schedule of revenu, expenditures, and changes in fund balance budget and actual genera fund

3–15.   The City of Grafton’s records reflected the following budget and actual data for the General Fund for the fiscal year ended June 30, 2017.  1.Estimated revenues: Taxes (Property)$3,213,000Licenses and permits790,000Intergovernmental revenues310,000Miscellaneous revenues200,000 2.Revenues: Taxes (Property)$3,216,000Licenses and permits792,000Intergovernmental revenues299,000Miscellaneous revenues195,000 3.Appropriations: General government$ 920,000Public safety2,090,000Health and welfare1,400,000 4.Expenditures: General government$ 880,000Public safety2,005,000Health and welfare1,398,000 5.Encumbrances outstanding as of June 30, 2016: General government$33,000Public safety82,000 6.Page 82Transfer to debt service fund: Budget$120,000Actual120,000 7.Budget revisions approved by the city council: Estimated revenues: Decrease intergovernmental revenues$10,000Decrease miscellaneous revenues3,000Appropriations: Decrease general government2,000 8.Total fund balance at July 1, 2016, was $720,000. Required: Use the Excel file provided to prepare a budgetary comparison schedule for the City of Grafton for the fiscal year ended June 30, 2017. Include outstanding encumbrances with expenditures. Use the formula feature (e.g., sum, =, etc.) of Excel to calculate the amounts in cells shaded blue.

I have most of the work done, but my totals aren’t coming out.  I really need someone who knows government accounting.