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 revenues, expenditures and changes in fund balance, budget and actual general 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.
9 years ago
5
- Grant proposal writing and evaluation planning
- Cost Accounting Homework
- BSA 310 (Business Systems) (Version-7) Week 2 Complete A+ Graded
- Devry Busn 278 Budgeting and Forecasting Final Exam
- Bella Lugosi holdings, INC has collected the following operating information below for its current month’s activity. Using the information, prepare a flexible budget analysis to determine how well BLH performed in terms of cost control.
- 2 pages
- A genetic condition is found that affects 10% of adults in the U.S. population
- 3 and 1/2 pages essay
- ASAP
- When you click on a template