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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more