Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
excel file not actually provided 3-15. The City of Grafton's records reflected the following budget and actual data for the General Fund for the fiscal
excel file not actually provided 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,000 Licenses and permits 790,000 Intergovernmental revenues 310,000 Miscellaneous revenues 200,000 2. Revenues: Taxes (Property) $3,216,000 Licenses and permits 792,000 Intergovernmental revenues 299,000 Miscellaneous revenues 195,000 3. Appropriations: General government $ 920,000 Public safety 2,090,000 Health and welfare 1,400,000 4. Expenditures: General government $ 880,000 Public safety 2,005,000 Health and welfare 1,398,000 5. Encumbrances outstanding as of June 30, 2016: General government $33,000 Public safety 82,000 6. Transfer to debt service fund: Budget $120,000 Actual 120,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 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 fea- ture (e.g., sum, =, etc.) of Excel to calculate the amounts in cells shaded blue. 2.000
excel file not actually provided
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started