Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Complete Business Statistics

Authors: Amir Aczel, Jayavel Sounderpandian

7th Edition

9780071077903, 73373605, 71077901, 9780073373607, 77239695, 978-0077239695

Students also viewed these Accounting questions

Question

What is the formula to calculate the mth Fibonacci number?

Answered: 1 week ago