Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The City of Graftons records reflected the following budget and actual data for the General Fund for the fiscal year ended June 30, 2012. 1.

The City of Graftons records reflected the following budget and actual data for the General Fund for the fiscal year ended June 30, 2012. 1. Estimated revenues: Taxes (Property) . $3,000,000 Licenses and permits 800,000 Intergovernmental revenues .. 300,000 Miscellaneous revenues . 200,000 2. Revenues: Taxes (Property) $3,000,000 Licenses and permits 801,320 Intergovernmental revenues .. 293,000 Miscellaneous revenues . 198,000 3. Appropriations: General government . $ 900,000 Public safety . 2,000,000 Health and welfare 1,400,000 4. Expenditures of 2012 appropriations: General government $ 880,000 Public safety . 1,949,000 Health and welfare 1,398,000 5. Encumbrances of 2012 appropriations, outstanding as of June 30, 2012. General government .. $18,000 Public safety 50,000 6. Transfer to debt service fund: Budget .. $600,000 Actual .. 600,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, 2011, was $1,038,000. Required: Use the Excel file provided to prepare a budgetary comparision schedule for the City of Grafton for the fiscal year ended June 30, 2012. Include outstanding encumbrances with expenditures. Use the formula feature (e.g., sum, =, etc.) of Excel to calculate the amounts in cells shaded blue.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Bookkeeping And Auditing A Career Guide

Authors: Harry Watts

1st Edition

1639878106, 1639878106

More Books

Students also viewed these Accounting questions