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 $-$

$\backslash$table$[[$Budget and Actual: General Fund,$($Non$-$GAAP Budgetary Basis$),,],[$For The Year Ended December $31,2020,,,,],[,$Budgeted Amounts,$\backslash$table$[[$Actual Amounts$],[$Budgetary Basis$]],\backslash$table$[[$Variance with Final$],[$Budget$]]],[$REVENUES$,$Original,Final$],[$Property Taxes,$3,220,000,$$$,3,220,000,3,225,500,5,500],[$Licenses and permits,$790,000,,790,000,792,000,2,000],[$Miscellaneous$,200,000,,200,000,212,000,12,000],[$TOTAL REVENUES,$4,520,000,,4,510,000,4,259,400,(250,600)]]$

EXPENDITURES AND ENCUMBRANCES

$\backslash$table$[[$EXPENDITURES AND ENCUMBRANCES$],[$Current$],[$General Government$],[$Public Safety$],[$Health and Welfare,,,,$=],[$TOTAL EXPENDITURES,$-,=,-],[$OTHER FINANCING SOURCES $($USES$)$:$],[$Transfers $($to$)$ other funds,,,,$-],[$TOTAL OTHER FINANCING SOURCES $($USES$),=,-,-],[$Excess of revenues and other sources over,$]]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,2024$:

Estimated revenues:

Taxes $($property$)$

$$3,220,000$

Licenses and permits

$790,000$

Intergovernmental revenues

$310,000$

Miscellaneous revenues

$200,000$

Revenues:

Taxes $($property$)$

$$3,225,500$

Licenses and permits

$792,000$

Intergovernmental revenues

$299,000$

Miscellaneous revenues

$212,000$

Appropriations:

General government

$$920,000$

Public safety

$2,090,000$

Health and welfare

$1,400,000$

Expenditures:

General government

$$878,000$

Public safety

$2,005,000$

Health and welfare

$1,399,000$

Encumbrances outstanding as of June $30,2019$:

General government

$$33,000$

Public safety

$82,000$

Transfer to debt service fund:

Budget

$$120,000$

Actual

$120,000$

Budget revisions approved by the city council:

Estimated revenues:

Decrease intergovernmental revenues

$$10,000$

Increase miscellaneous revenues

$3,000$

Appropriations:

Decrease general government

Total fund balance at July $1,2023,$ was $$695,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,2024.$ Include outstanding encumbrances with expenditures.

Show all imagesShow all images