Answered step by step
Verified Expert Solution
Question
1 Approved Answer
answer the following on excel, not sure if mine is right so far CITY OF Grafton Schedule of Revenues, Expenditures and Changes in Fund Balance
answer the following on excel, not sure if mine is right so far
CITY OF Grafton
Schedule of Revenues, Expenditures and Changes in Fund Balance
tableBudget and Actual: General Fund,NonGAAP Budgetary BasisFor The Year Ended December Budgeted Amounts,tableActual AmountsBudgetary BasistableVariance with FinalBudgetREVENUESOriginal,FinalProperty Taxes,$Licenses and permits,MiscellaneousTOTAL REVENUES,
EXPENDITURES AND ENCUMBRANCES
tableEXPENDITURES AND ENCUMBRANCESCurrentGeneral GovernmentPublic SafetyHealth and Welfare,,,,TOTAL EXPENDITURES,OTHER FINANCING SOURCES USES:Transfers to other funds,,,,TOTAL OTHER FINANCING SOURCES USESExcess of revenues and other sources over, The City of Grafton's records reflected the following budget and actual data for the General Fund for the fiscal year ended June
:
Estimated revenues:
Taxes property
$
Licenses and permits
Intergovernmental revenues
Miscellaneous revenues
Revenues:
Taxes property
$
Licenses and permits
Intergovernmental revenues
Miscellaneous revenues
Appropriations:
General government
$
Public safety
Health and welfare
Expenditures:
General government
$
Public safety
Health and welfare
Encumbrances outstanding as of June :
General government
$
Public safety
Transfer to debt service fund:
Budget
$
Actual
Budget revisions approved by the city council:
Estimated revenues:
Decrease intergovernmental revenues
$
Increase miscellaneous revenues
Appropriations:
Decrease general government
Total fund balance at July was $
Required: Use the Excel file provided to prepare a Budgetary Comparison Schedule for the City of Grafton for the fiscal year ended
June Include outstanding encumbrances with expenditures.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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