Page 5 - City of DWG FY 2022-23 BUDGET

City of Dalworthington Gardens
FY 22/23 Proposed Budget
Fund Balance Recap

Committed Assigned Restricted Restricted Restricted Restricted Restricted Restricted Restricted Restricted Restricted Restricted
110 111 140 TOTAL 112 207 141 142 150 145 115 118 143 180 185 208 120
General Gas CDBG General Fire Truck Vol Fire 2017 Bond 2017 Bond Court Court Street Enterprise
Fund Reserve Capital Fund Fund Fund Streets City Hall Debt Grant Fund Security Automation (Sales Tax) PRFDC CCPD Seizure Fund
Fund Balance Projected for FY 21/22 1,772,884
Less committed capital funds (22,000)

Fund Balance Projected for FY 21/22 Adjusted
for Committed Capital 1,750,884 650,891 0 2,401,775 50,298 1,907 854,446 324,775 49,883 (0) 43,949 96,492 160,430 653,074 25,756 4,169 621,543

Budgeted Revenue 3,741,917 133,435 3,000 3,878,352 26,065 5,400 13,885 593,516 370,593 1,200 10,051 10,120 155,176 156,213 312,563 - 2,186,725

Budgeted Expenses 4,330,632 - 3,000 4,330,632 - 5,000 177,845 918,291 367,244 1,200 613 14,592 87,958 204,063 291,864 - 2,186,725

Budget Revenue Over (Under) Expenses (588,716) 133,435 - (452,280) 26,065 400 (163,960) (324,775) 3,349 - 9,438 (4,472) 67,218 (47,850) 20,699 - (0)

Fund Balance Projected for FY 22/23 1,162,168 784,326 0 1,949,495 76,364 2,307 690,485 0 53,232 (0) 53,387 92,020 227,648 605,224 46,455 4,169 621,543

OPERATING RESERVE CALCULATION RECONCILATION TO WORKING CAPITAL
Non-Spendable (prepaids) (25,598) Adjustment for changes to OPEB and pension (non-WC) 1,000
Un-assigned Fund Balance 1,923,897 Working Capital 622,543
Budgeted Expenses 4,330,632 Operating Budget (less capital and transfers) 2,058,177
Less non-operating expenses (762,903) Operating Budget per day 5,639
Budgeted operating expenses 3,567,729 Operating Days of Working Capital 110
Operating Budget per day 9,775
Operating Days of Fund Balance 197