Page 55 - City of DWG FY 2022-23 BUDGET

120 - ENTERPRISE FUND 2020-21 2021-22 2021-22 2022-23 Variance Variance

FY 22/23 FY 22/23
% Proposed Proposed Proposed
VARIANCE
FY 21/22 Amended YTD Actual + Actual + Projected % of Proposed Budget vs Budget Budget
v
ACTUAL Amended FY 21/22 vs s
Budget Budget Projected vs Amended Budget Budget Actual plus FY 21/22 FY 21/22
Budget
Actual +
Projected Amended
Account Number Account Description Projected Budget
40.6205 Mat/Supplies: Legal Notices - - - - - 0% - 0% - -
40.6215 Mat/Supplies: Office Supplies - - - 44 44 0% 13 28% (32) 13

40.6230 Mat/Supplies: Office Equipment 3,482 1,050 1,050 2,051 1,001 195% 50 2% (2,001) (1,000)

40.6235 Mat/Supplies: Records Mgmt - 800 800 - (800) 0% 400 0% 400 (400)

40.6240 Mat/Supplies: Printing 4,566 4,700 4,700 4,642 (58) 99% 5,222 112% 580 522

40.6245 Mat/Supplies: Postage 5,237 5,350 5,350 5,001 (349) 93% 5,580 112% 579 230

40.6250 Mat/Supplies: Water Systems 9,733 5,520 5,217 5,217 - 100% 1,300 25% (3,917) (3,917)

40.6275 Mat/Supplies: Equipment 1,204 - 303 803 500 265% - 0% (803) (303)
40.6276 Mat/Supplies: Furnishings 566 1,136 636 636 0 100% - 0% (636) (636)

40.6300 Mat/Supplies: Uniforms 1,661 2,468 2,468 2,641 173 107% 2,659 101% 18 192

40.6315 Mat/Supplies: Other 6 198 198 160 (38) 81% 308 192% 148 110

40.6350 Mat/Supplies: Fuel 3,595 4,705 3,705 4,380 675 118% 6,751 154% 2,371 3,046

40.6400 Mat/Supplies: Tools & Supplies 2,724 1,950 1,950 3,505 1,555 180% 1,303 37% (2,203) (648)

40.6410 Mat/Supplies: Weed & Pest Control 60 75 75 91 16 122% 98 107% 6 23

40.6450 Mat/Supplies: Testing Supplies 1,265 600 2,600 2,881 281 111% 7,500 260% 4,619 4,900
40.6499 Mat/Supplies: Cost O/H Recovery 5,631 4,741 6,021 9,165 3,144 152% 5,958 65% (3,207) (63)

Total Materials & Supplies $ 39,729 $ 33,292 $ 35,073 41,218 $ 6,146 118% $ 37,140 90% $ (4,079) $ 2,067
40.6500 Utilities:Electricity 18,454 19,308 19,308 14,580 (4,729) 76% 16,419 113% 1,839 (2,889)
40.6505 Utilities:Gas - 86 86 109 23 113 103% 3 27

40.6510 Utilities:Telephone 1,188 1,200 1,035 841 (194) 81% 300 36% (541) (735)
40.6515 Utilities:Water & Sewer 114 114 136 22 115 85% (21) 1

40.6520 Utilities: Mobile Data 972 1,200 1,248 1,009 (239) 81% 1,092 108% 83 (156)
40.6599 Utilities: Cost O/H Recovery 15,080 13,916 13,916 11,297 (2,618) 81% 11,655 103% 358 (2,260)

Total Utilities $ 35,694 $ 35,824 $ 35,707 27,972 $ (7,734) 78% $ 29,694 106% $ 1,722 $ (6,013)

40.6805 Maintenance:Vehicles 4,282 1,852 1,852 1,485 (367) 80% 1,887 127% 402 35

40.6810 Maintenance:Blgs/Ground/Park 20 - 1,393 2,622 1,230 188% 7,589 289% 4,967 6,196

40.6825 Maintenance:Equipment 1,423 1,820 1,820 1,847 27 101% 5,300 287% 3,453 3,480

40.6900 Maintenance:Water Tank 5,440 1,100 2,607 3,511 904 135% 7,825 223% 4,314 5,218
40.6905 Maintenance:Water Pumps/Motors 3,834 7,000 7,000 7,000 - 100% 7,000 100% - -

40.6910 Maintenance:Water Distribution 23,327 105,000 70,650 99,887 29,237 141% 62,000 62% (37,887) (8,650)
40.6925 Maintenance:Sewer Collection 3,173 - 42,450 42,914 464 101% 40,000 93% (2,914) (2,450)
40.6999 Maintenance:Cost O/H Recovery 3,725 1,702 1,702 2,638 935 155% 2,575 98% (63) 872

Total Maintenance $ 45,224 $ 118,474 $ 129,474 161,904 $ 32,430 125% $ 134,176 83% $ (27,728) $ 4,701

40.7015 Consultants:Legal-Regular 2,483 3,000 3,000 3,000 - 100% 1,605 54% (1,395) (1,395)

40.7025 Consultants: Auditor 6,984 7,384 7,384 7,384 - 100% 7,400 100% 16 16

40.7030 Consultants:Engineer-Regular 6,178 1,000 58,122 60,920 2,798 105% 3,000 5% (57,920) (55,122)
40.7095 Consultants:Other - - - 2,082 2,082 0% - 0% (2,082) -

Total Consultants $ 15,646 $ 11,384 $ 68,506 73,386 $ 4,880 107% $ 12,005 16% $ (61,381) $ (56,501)