Page 4 - City of DWG FY 2022-23 BUDGET
P. 4

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
   1   2   3   4   5   6   7   8   9