The following transactions occurred during the 2023 fiscal year for the City of Evergreen. For budgetary purposes, the city reports encumbrances in the Expenditures section of its budgetary comparison schedule for the General Fund but excludes expenditures chargeable to a prior year's appropriation 1. The budget prepared for the fiscal year 2023 was as follows: $2,006, een 381,800 406,000 71,080 2,864,000 Estimated Revenues: Taxes Licenses and permits Intergovernmental revenue Miscellaneous revenues Total estimated revenues Appropriations: General government Public safety Public works Health and welfare Miscellaneous Total appropriations Estimated Other Financing Uses: Estimated other financing uses transfers out Budgeted increase in fund balance 489,900 904, 9ee 668,900 618,900 95,000 2.777.600 22.900 63,500 $ 2. Encumbrances issued against the appropriations during the year were as follows: General government Public safety Public works Health and welfare Miscellaneous Total $ 67,800 259,000 481,800 168,910 80,000 $975,910 3. The current year's tax levy of $2,076,100 was recorded; uncollectibles were estimated to be $74.000. 4. Tax collections of the current year's levy totaled $1,468,000. The City also collected $141,000 in taxes from the prior year's levy in the first 60 days after year-end. (These delinquent collections had been anticipated prior to year-end.) 5. Personnel costs during the year were charged to the following appropriations in the amounts indicated. Encumbrances were not recorded for personnel costs. Because no liabilities currently exist for withholdings, you may ignore any FICA or federal or state income tax withholdings. (Expenditures charged to Miscellaneous should be treated as General Government expenses in the governmental activities general journal at the government-wide level.) General government Public safety Public works Health and welfare Miscellaneous Credit to Vouchers Payable $ 420,000 644, see 263,800 448,000 12, eee $1,787,000 6. Invoices for all items ordered during the prior year were received and approved for payment in the amount of $14,650. Encumbrances had been recorded in the prior year for these items in the amount of $14,090. The amount chargeable to each year's appropriations should be charged to the Public Safety appropriation 7. Invoices were received and approved for payment for items ordered in documents recorded as encumbrances in Transaction (2) of this problem. The following appropriations were affected. General government Public safety Public works Health and welfare Miscellaneous Actual Liability $ 61,700 245,200 369,880 139,600 8e, eee $895,500 Estimated Liability $ 61,200 249,900 366, eee 139, 100 88,888 $896,200 8. Revenue other than taxes collected during the year consisted of licenses and permits, $382,900; intergovernmental revenue, $409,900; and $75,900 of miscellaneous revenues. For purposes of accounting for these revenues at the government-wide level, the intergovernmental revenues were operating grants and contributions for the Public Safety function, Miscellaneous revenues are not identifiable with any function and therefore, are recorded as General Revenues at the government-wide level. 9. A transfer of $22.900 was made to the debt service fund for principal and interest payments. 10. Payments on Vouchers Payable totaled $2,514,000. Additional information follows. The General Fund Fund Balance- Unassigned account had a credit balance of $105,900 as of December 31, 2022, no entries have been made in the Fund Balance-Unassigned account during 2023 Answer is not complete. CITY OF EVERGREEN Appropriations/Encumbrances/Expenditures Ledger Encumbrances Expenditures Appropriations Available Credit Balance Debit Balance Debit Credit Transaction Account Description Balance 489,900 1 489,900 422.900 2,900 2 67,000 General Government Budget Authorization Encumbrances issued Payroll Invoices approved for payment 67,000 420,000 420,000 5 (58,800) 481,700 7 61,700 904,900 259,000 259.000 1 2 5 6 Public Safety Budget Authorization Encumbrances issued Payroll Invoices for items ordered Invoices approved for payment 904,900 645.900 1,900 1,340 644,000 560 644,000 844,560 245.200 889.780 7 (243,860) Public Works Budget Authorization 668,900 068.900 1 7 245.200 889,760 (243,860) payment 1 668,900 Public Works Budget Authorization Encumbrances issued Payroll Invoices approved for payment 401.000 2 5 401,000 668,900 267 900 4,900 263,000 263.000 632.000 7 369,000 (364.100) 618,900 1 2 5 Health and Welfare Budget Authorization Encumbranoes issued Payroll Invoices approved for payment 168,910 168,910 618.900 449.990 1,990 448,000 448,000 7 139,600 587,600 (137,610) 95,000 1 2 5 Miscellaneous Budget Authorization Encumbrances issued Payroll Invoices approved for payment 80.000 B0.000 95,000 15,000 3.000 12,000 12,000 80,000 7 92,000 (77000) b. Prepare a budgetary comparison schedule for the General Fund of the City of Evergreen for the fiscal year ending December 31, 2023. (Input all amounts as positive values.) Answer is not complete. CITY OF EVERGREEN General Fund Budgetary Comparison Schedule For the Year Ended December 31, 2023 Budget (Original and Final) Actual Variance with Final Budget Over (Under) $ Revenues: Taxes Licenses and Permits Intergovernmental Revenue Miscellaneous oOOO 2,006,000 381,000 406,000 71,000 2,002,100S 382,900 409,900 75,900 (3,900) 1,900 3,900 4,900 0 6,800 2,864,000 2,870,800 Total Revenues Expenditures (Budget Basis): General Government Public Safety Public Works Health and Welfare Miscellaneous OOOO 489,900 904.900 668,900 618,900 95,000 OOOOO (489,900) (904,900) (668,900) (618,900) (95,000) Intergovernmental Revenue Miscellaneous 406,000 71,000 409,900 75,900 3,900 4,900 0 2,864,000 2,870,800 6,800 Total Revenues Expenditures (Budget Basis): General Government Public Safety Public Works Health and Welfare Miscellaneous OOO 489,900 904,900 668,900 618,900 95,000 (489,900) (904,900) (668,900) (618,900) (95,000) 0 (2,777,600) (86,400) 0 0 Total Expenditures Excess of Revenues Over Expenditures Other Financing Usos: Interfund Transfers Out Increase in Encumbrances Outstanding Increase in Fund Balances Fund Balances, 1/1 Fund Balances, 12/31 2,777,600 86,400 22,900 0 63,500 22,900 0 (63,500) 0 s 0