Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please explain this to me. I am thoroughly confused 3-15. The City of Grafton's records reflected the following budget and actual data for the General
please explain this to me. I am thoroughly confused 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 2,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 fea- ture (e.g., sum, =, etc.) of Excel to calculate the amounts in cells shaded blue. AutoSD N de 13.mplate(1) Computy Mode Formulas Data Review View Help File Home Insert Draw Page Layout BB 5 Budget and actual General Fund For The Year Ended December 2017 Actual Amount luar las Variance with Final 7 REVENUES 8 Property Taxes Use formulas for Shaded areas 11 c us 12 TOTAL REVENUES 14 EXPENDITURES AND ENCUMBRANCES 15 Current 16 en Covement 17 PCS 19 TOTAL EXIT NOUS 21 REVENUES OVER (UNDER EXPENDITURES 22 OMER FRANCNO SOURCES USES) 24 TOTAL OTHER FRUNONOURCES USES 20 under expenditures and one uses 27 FUND BALANCE Begring of Year 28 FUND BALANCE End of Year 29 Exercise 1-15
please explain this to me. I am thoroughly confused
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