Document Douglas_doc_dc9454e963

CITY OF DOUGLAS BUDGET SUMMARY FISCAL YEAR: 2024 TRANSFERS IN TRANSFERS OUT BALANCE W/O CONTINGENCY CONTINGENCY BALANCE WITH CONTINGENCY TARGERT RESERVE AMOUNT Projected 2023 2024 2023 2024 2024 2024 JUNE 30TH 2024 JUNE 30TH FUND NUMBER AND TITLE Ending Balance PY ORIG BDGT PROJECTED PY ORIG BDGT PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED GENERAL FUND GENERAL GOVERNMENT 100 NON DEPARTMENTAL 567,445 588,475 101 CITY COUNCIL 33,298 33,798 102 ADMIN SERVICES 616,944 836,322 103 IT 274,824 431,939 106 PLANNING/DEVELOPMENT 410,432 592,182 110 PUBLIC SERVICE CONTRACTS 1,276,400 1,407,100 TOTAL GENERAL GOVERNMENT 3,179,343 3,889,816 POLICE DEPARTMENT 201 ADMINISTRATION 264,961 291,923 202 PATROL 2,070,460 2,402,404 105 MUNICIPAL COURT 87,844 97,160 TOTAL POLICE DEPARTMENT 2,423,265 2,791,487 PUBLIC WORKS 301 ADMINISTRATION 278,862 328,525 302 SHOP 400,196 439,229 304 PARKS 693,123 773,603 305 STREETS/ALLEYS 698,018 781,143 306 CEMETERY 357,943 385,699 307 SWIM POOL 173,500 185,500 TOTAL PUBLIC WORKS 2,601,642 2,893,699 TOTAL OPERATING 7,765,863 9,863,456 8,204,250 9,575,002 4,000 5TH CENT SALES TAX 4,000,000 4,500,000 110 COMMUNITY SERVICE CONTRACTS 522,000 644,050 998 CAPITAL TRANSFERS 3,751,617 TOTAL CAPITAL/COMM SERVICE TOTAL GENERAL FUND 39,457,008 11,765,863 14,363,456 8,726,250 10,219,052 4,000 3,751,617 39,853,795 200,000 39,653,795 15,000,000 IMPACT ASSISTANCE FUND 1,581,669 5,000 - - - 1,581,669 - - - TOTAL IMPACT ASSISTANCE FUND 1,581,669 5,000 - - - - 1,581,669 - - REVENUE EXPENDITURES Tab 19 Page 1 ---PAGE BREAK--- CITY OF DOUGLAS BUDGET SUMMARY FISCAL YEAR: 2024 TRANSFERS IN TRANSFERS OUT BALANCE W/O CONTINGENCY CONTINGENCY BALANCE WITH CONTINGENCY TARGERT RESERVE AMOUNT Projected 2023 2024 2023 2024 2024 2024 JUNE 30TH 2024 JUNE 30TH FUND NUMBER AND TITLE Ending Balance PY ORIG BDGT PROJECTED PY ORIG BDGT PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED REVENUE EXPENDITURES POLICE SPECIAL PROJECTS FUND 130 ASSET SEIZURE 1,255 804 K9 PROGRAM 20,000 20,000 820 RURAL VIOLEN CRIME RECUCTION 100,129 100,129 821 HIGHWAY SAFETY TRAFFIC ENFORCEMENT 11,730 7,769 11,730 7,769 830 SRO PROGRAM 93,512 84,560 112,817 113,033 28,473 831 OJJDP-UNDERAGE ENFORCEMENT 4,314 8,603 4,314 8,603 838 BULLET PROOF VEST 1,425 1,344 2,850 2,688 1,344 TOTAL POLICE SPECIAL PROJECTS 36,573 130,981 202,405 152,966 232,222 29,817 36,573 36,573 - - ENTERPRISE FUNDS WATER FUND 400 ADMINISTRATION 1,264,432 1,158,051 401 TREATMENT 543,301 456,265 CAPITAL 108,000 127,000 402 DISTRIBUTION/MAINTNCE 506,600 562,889 CAPITAL 400,000 47,450 403 CUSTOMER SERVICES 98,750 113,857 CAPITAL 15,000 840 WATER MAIN REPLACEMENTS 1,499,250 3,042,000 856 WATER IMPROVEMENTS 774,000 999,000 50,000 PLANT INVESTMENT FEES 2,750 31,250 TOTAL OPERATING 7,632,900 2,986,500 3,147,000 2,413,083 2,291,062 5,955,000 2,533,838 2,533,838 2,000,000 TOTAL REPLACEMENT 2,668,104 2,750 31,250 2,781,250 4,230,450 5,955,000 4,423,904 50,000 4,373,904 2,000,000 TOTAL WATER FUND 10,301,004 2,989,250 3,178,250 5,194,333 6,521,512 5,955,000 5,955,000 6,957,742 50,000 6,907,742 4,000,000 SEWER FUND 500 ADMINISTRATION 448,841 149,891 501 TREATMENT 486,662 451,981 CAPITAL 34,000 82,000 502 COLLECTION 457,786 483,728 CAPITAL 10,000 41,250 850 WASTEWATER TREATMENT PLANT REHAB 354,000 1,203,000 852 SEWER MAIN REPLACEMENTS 1,455,000 1,251,000 2,995,000 820,000 50,000 PLANT INVESTMENT FEES 1,000 12,500 - TOTAL OPERATING 270,672 1,564,900 1,618,200 1,393,289 1,085,600 675,000 128,272 128,272 1,000,000 TOTAL REPLACEMENT 2,012,241 1,100 1,467,500 1,649,000 4,321,250 1,495,000 653,491 50,000 603,491 1,000,000 TOTAL SEWER FUND 2,282,913 1,566,000 3,085,700 3,042,289 5,406,850 1,495,000 675,000 781,763 50,000 731,763 2,000,000 Tab 19 Page 2 ---PAGE BREAK--- CITY OF DOUGLAS BUDGET SUMMARY FISCAL YEAR: 2024 TRANSFERS IN TRANSFERS OUT BALANCE W/O CONTINGENCY CONTINGENCY BALANCE WITH CONTINGENCY TARGERT RESERVE AMOUNT Projected 2023 2024 2023 2024 2024 2024 JUNE 30TH 2024 JUNE 30TH FUND NUMBER AND TITLE Ending Balance PY ORIG BDGT PROJECTED PY ORIG BDGT PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED REVENUE EXPENDITURES SANITATION FUND TOTAL OPERATING 277,947 1,367,750 1,410,000 1,528,168 1,528,168 70,000 89,779 89,779 200,000 TOTAL REPLACEMENT 547,363 125 1,250 26,000 26,000 70,000 592,613 25,000 567,613 250,000 TOTAL SANITATION FUND 825,310 1,367,875 1,411,250 1,554,168 1,554,168 70,000 70,000 682,392 25,000 657,392 450,000 LANDFILL FUND TOTAL OPERATING 1,052,068 1,025,000 1,062,000 1,096,309 1,305,579 740,000 68,489 68,489 500,000 TOTAL REPLACEMENT 520,118 - 750,000 691,500 740,000 568,618 50,000 518,618 500,000 TOTAL LANDFILL FUND 1,572,186 1,025,000 1,062,000 1,846,309 1,997,079 740,000 740,000 637,107 50,000 587,107 1,000,000 EMPLOYEE HEALTH CARE FUND TOTAL OPERATING 84,997 1,530,500 1,675,900 1,475,000 1,553,900 206,997 206,997 TOTAL REPLACEMENT 997,000 - - 997,000 997,000 TOTAL EMPLOYEE HEALTH CARE FUND 1,081,997 1,530,500 1,675,900 1,475,000 1,553,900 - - 1,203,997 1,203,997 CAPITAL PROJECT FUNDS 40 CAPITAL IMP RESERVE FUND 355,861 2,900 10,475 - 366,336 366,336 41 ECONOMIC DEVELOPMENT 354,018 1,900 7,785 50,000 140,500 1,875,000 2,096,303 1,675,000 421,303 42 BROWNFIELD GRANT - 76,685 1,010,177 76,685 1,010,177 - - 47 GENERAL FUND EQUIPMENT RESERVE 121,915 1,000 213,082 645,500 536,559 12,974 12,974 50 FIRE EQUIPMENT FUND 586,558 1,550 5,500 250,000 250,000 250,000 592,058 592,058 53 CLG PROJECTS 5,851 3,990 7,000 5,851 5,851 54 TRAIN CAR RESTORATION 38,119 - 35,000 40,000 25,000 23,119 23,119 55 POOL IMPROVEMENTS FUND 278,322 3,400 195,000 500,000 250,000 28,322 28,322 56 STREET IMPROVEMENT FUND 15,897,905 76,600 360,000 5,712,750 7,231,000 1,545,110 10,572,015 10,572,015 57 CAPITAL IMP - PUBLIC FACILITIES 3,355,347 25,200 31,500 210,000 1,529,000 1,857,847 1,857,847 65 PARK IMPROVEMENT FUND 3,607,317 19,000 72,500 864,150 1,372,300 2,307,517 2,307,517 - - TOTAL CAPITAL PROJECT FUNDS 24,601,213 212,225 1,497,937 7,613,667 12,718,477 4,481,669 - 17,862,342 1,675,000 16,187,342 9,000,000 TRUST & AGENCY FUNDS 90 PERPETUAL CARE FUND 182,417 3,750 7,000 - 4,000 185,417 185,417 92 HISTORIC CMSN FUND 21,871 - 3,650 1,800 1,800 21,871 21,871 96 UTILITY DEPOSIT FUND 94,508 - - 94,508 94,508 TOTAL TRUST & AGENCY FUNDS 298,796 3,750 7,000 3,650 1,800 1,800 4,000 301,796 301,796 GRAND TOTAL - ALL FUNDS 82,038,669 20,596,444 26,483,898 29,608,632 40,205,060 12,777,286 12,777,286 68,317,507 2,050,000 66,267,507 50,000,000 Tab 19 Page 3 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 1 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title GENERAL FUND GENERAL - REVENUE 10-4100-0160 GAIN ON INVESTMENTS .00 .00 86,220- 371,346- 10-4100-1101 REIMBURSEMENT - CCSD 73,076 .00 59,007 61,903 10-4100-1107 OTHER 10,000 5,000 1,922 47,336 10-4100-1108 COPY FEES/VIN CHECKS 5,000 5,000 4,150 6,014 10-4100-1109 REIMBURSEMENTS .00 80,000 91,189 85,492 10-4100-1112 CONTRIBUTIONS 14,500 14,000 .00 14,993 10-4100-1115 LEASES/RENT 6,200 6,200 3,575 6,625 10-4100-1120 FINES/FORFEITS 22,500 25,000 13,903 26,970 10-4100-1140 INTEREST INCOME 1,015,000 350,000 591,080 536,819 10-4100-1145 GAIN ON SALE OF FIXED ASSETS .00 .00 .00 33,932 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI 30,000 30,000 .00 15,532 10-4100-1211 LICENSES - LIQUOR 21,300 20,000 19,100 20,240 10-4100-1230 LICENSES - TRANSIENT MERCHANT .00 .00 200 .00 10-4100-1241 LICENSES - CONTRACTORS 15,000 15,000 13,399 15,981 10-4100-1250 BUILDING PERMITS 21,750 30,000 18,162 23,546 10-4100-1261 PLANNING FEES 2,000 2,000 1,495 1,890 10-4100-1320 PROPERTY TAX - CURRENT 464,500 450,000 365,958 471,185 10-4100-1321 PROPERTY TAX - PRIOR YEARS 2,000 1,000 604 3,718 10-4100-1322 PROPERTY TAX - AUTO 183,900 175,000 142,087 189,279 10-4100-1323 PROPERTY TAX - INTEREST 2,100 1,000 2,827 1,537 10-4100-1324 PROPERTY TAX - HANDLING FEES 3,000- 2,500- 2,555- 3,328- 10-4100-1330 FRANCHISE FEES - RMP 225,000 225,000 179,580 222,640 10-4100-1331 FRANCHISE FEES - CABLE TV 10,000 14,000 7,340 11,306 10-4100-1332 FRANCHISE FEES - SOURCE GAS 36,000 35,000 19,716 33,556 10-4100-1333 FRANCHISE FEES - TELEPHONE 6,300 7,500 5,230 7,046 10-4100-1420 MANAGEMENT FEES - LANDFILL 105,375 104,857 78,643 114,723 10-4100-1421 MANAGEMENT FEES - WATER 295,051 272,629 204,472 263,863 10-4100-1422 MANAGEMENT FEES - SEWER 144,891 136,314 102,236 157,174 10-4100-1423 MANAGEMENT FEES - SANITATION 145,945 104,857 78,643 82,019 10-4100-1430 WEED MOWING CHARGES .00 .00 .00 620 10-4100-1431 PEST CONTROL 14,700 14,500 14,752 14,700 10-4100-1432 PROPERTY TAX - WEED CONTROL 39,000 35,000 45,975 34,718 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 2 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 10-4100-1510 CEMETERY - BURIALS 15,000 15,000 11,550 23,700 10-4100-1522 CEMETERY - LOT SALES 7,500 7,500 7,700 7,600 10-4100-1650 POOL - USER FEES 22,000 20,000 .00 28,992 10-4100-3110 STATE SUPPLEMENTAL DISTR 459,295 200,000 295,120 200,159 10-4100-3111 SEVERENCE TAX - 2% 228,573 225,000 57,143 229,873 10-4100-3112 MINERAL ROYALTIES 325,000 300,000 222,596 322,872 10-4100-3241 SALES TAX - STATE 5,500,000 4,500,000 6,816,697 5,908,597 10-4100-3245 SALES TAX - LOCAL OPTION 4,500,000 4,000,000 5,566,946 4,843,771 10-4100-3250 LOTTERY 48,000 45,000 48,635 103,922 10-4100-3257 GAS TAX 240,000 230,000 188,416 265,577 10-4100-3258 SPECIAL FUELS 65,000 65,000 52,363 66,802 10-4100-3262 CIGARETTE TAX 45,000 45,000 32,567 43,873 10-4100-3374 SLIB .00 .00 467,822 507,055 10-4100-4288 ARPA Funds .00 .00 .00 553,236 Total GENERAL - REVENUE: 14,363,456 11,808,857 15,744,024 15,236,712 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 3 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title OPERATING TRANSFERS - IN 10-4998-1854 OPERATING - CARE 4,000 750 3,266 1,659 Total OPERATING TRANSFERS - IN: 4,000 750 3,266 1,659 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 4 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title GENERAL GOVT - NON DEPARTMENTL 10-5100-0150 REPLACEMENT RESERVE 300,000 300,000 225,000 300,000 10-5100-1021 EMPLOYEE BENEFITS - SCL 50 50 31 49 10-5100-1023 EMPLOYEE BENEFITS - HEALTH INS 27,225 23,847 .00 .00 Budget notes: ~2024 Retiree coverage 10-5100-1025 EMPLOYEE BENEFITS - COMP .00 .00 .00 .00 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 2,750 2,750 2,555 5,310 Budget notes: ~2024 Flu, hepatitus & tetanus shots $500, Fitness benefit $1,750; Employee assistance $500 10-5100-2101 POSTAGE/FREIGHT 6,000 6,000 5,239 6,649 10-5100-2115 PUBLISHING/ADVERTISING 41,200 35,000 21,332 28,996 Budget notes: ~2024 Legal notices, Position vacancies, Advertising $35,000; Promotion information advertising (UPI-10, UPI-11, UPI-09, WCC-07, PNPR-05, ASC-04, ASC-08, ACS-01, ASC-02, ASC-05) $6,200 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 200 200 30 232 Budget notes: Municipal code citator; LSO session laws 10-5100-2122 TRAINING/DEVELOPMENT 27,500 5,000 .00 .00 Budget notes: ~2024 Professional development (BHO-02) $20,000; CPR training $7,500 10-5100-2123 MEALS/LODGING/TRAVEL 500 .00 .00 .00 Budget notes: ~2024 Evaluate existing xeriscape (PNPR-03) $500 10-5100-2131 UTILITY SERVICES - ELECTRICITY 80,000 80,000 55,404 80,777 Budget notes: Street lights; Area lights; City Hall; Old City Hall; Sirens; Bridge lighting; Crosswalks; Windriver crosswalk light 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 2,500 3,000 1,753 2,835 Budget notes: City Hall; Old City Hall 10-5100-2133 UTILITY SERVICES - NATURAL GAS 6,200 3,500 4,694 3,970 Budget notes: ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 5 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title City Hall; Old City Hall 10-5100-2134 TELECOMMUNICATIONS 10,000 .00 8,797 11,268 Budget notes: ~2024 Phone services $9,100; Cell phone $900 10-5100-2141 EQUIPMENT - RENT 215 200 207 192 Budget notes: Postage equipment 10-5100-2151 LEGAL 40,000 50,000 25,401 28,254 10-5100-2152 ACCOUNTING/AUDITING 75,000 55,000 40,000 47,750 Budget notes: ~2024 Audit (Single audit) $60,000; GASB Valuation $10,000; Consulting $5,000 10-5100-2155 REPAIRS/MAINTENANCE 5,000 5,000 3,927 27,088 10-5100-2156 MAINTENANCE AGREEMENT 6,980 6,700 5,771 10,778 Budget notes: ~2024 Elevator $2,500; Copier $2,500: Laser fische $1,560; Fire alarm monitoring $420 10-5100-2157 INSURANCE 94,250 88,000 61,500 92,231 Budget notes: ~2024 Property & casualty $61,000; Liability $32,350; Clerk & Treasurer's bonds $500; Fuel tansk fee $400 10-5100-2158 MISC CONTRACTUAL SERVICES 588,050 57,650 338,484 50,210 Budget notes: ~2024 Codification-Municode $2,500; Drug alcohol testing $4,000; Custodial services $26,400; Municode web site hosting fee $900; ACT $25,000; Cultural programming (UPI-09) $12,500; Public transportation (WCC-07) $1,750; Community facility feasibility (FUN-08) $20,000; Visual arts program (UPI-08) $15,000; EDA grant - EWC expansion $480,000 10-5100-2166 COLLECTION FEES 75 100 68 .00 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE 300 250 259 937 10-5100-3201 OFFICE SUPPLIES 12,000 12,000 8,968 10,732 Budget notes: ~2024 Stationary; Envelopes; General office supplies; Data processing supplies- paper, printer cartridges, toner, DVD/CD's; etc. 10-5100-3210 OPERATING SUPPLIES 20,580 10,000 13,912 9,351 Budget notes: ~2024 Cleaning & paper products; Light bulbs; Recording fees; ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 6 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title Name plates & plaques; Flags; First aid supplies; Garden supplies; Pool car repairs/maintenance supplies; Digital camera supplies; Coins; Car plates; Repair parts - Public facilities; Property taxes- Old City Hall & Meadow Acres; TEAM $2,580; Shirts/Sweatshirts-Employee $3,750; Promotion materials: Xeriscape (PNPR-05) $250, Enjoy nature responsibly (PNPR-09) $250, Sustaining limited resources (PNPR-10) $250; Property beautification awards (FUN-01) $500 10-5100-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 786 .00 10-5100-3230 REFRESHMENT SUPPLIES 14,400 4,000 2,286 863 Budget notes: ~2024 Coffee supplies, general/meeting refreshments $2,000; Team meetings/recognitions $7,400; Community picnics (BC-11) $5,000 10-5100-3235 FUEL 1,500 105,000 121,663 131,467 10-5100-4345 INVESTMENT FEES .00 .00 .00 6,333 10-5100-7601 CLAIMS AGAINST CITY 5,000 5,000 .00 .00 10-5100-7606 UNEMPLOYMENT CLAIMS 1,000 1,000 .00 .00 10-5100-9000 CONTINGENCY 200,000 .00 .00 .00 Budget notes: ~2024 IT equipment (incl PD specific) $7,500 Total GENERAL GOVT - NON DEPARTMENTL: 1,568,475 859,247 948,064 856,271 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 7 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title GENERAL GOVT - CITY COUNCIL 10-5101-1001 SALARIES/WAGES - REGULAR 18,000 18,000 12,000 18,000 10-5101-1021 EMPLOYEE BENEFITS - SCL 1,377 1,377 918 1,377 10-5101-1025 EMPLOYEE BENEFITS - COMP 421 421 281 459 10-5101-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 8,000 8,000 8,027 8,099 Budget notes: ~2024 WY Assoc of Municipalities 10-5101-2122 TRAINING/DEVELOPMENT 2,500 2,500 895 240 Budget notes: ~2024 WAM Summer $1,250; WAM Winter $1,250 10-5101-2123 MEALS/LODGING/TRAVEL 3,000 2,500 1,472 1,324 Budget notes: ~2024 WAM Summer $1,250; WAM Winter $1,250; Misc $500 10-5101-3210 OPERATING SUPPLIES 500 500 33 .00 Budget notes: ~2024 Shirts $500 Total GENERAL GOVT - CITY COUNCIL: 33,798 33,298 23,626 29,499 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 8 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title GENERAL GOVT - ADMIN SERVICES 10-5102-1001 SALARIES/WAGES - REGULAR 474,423 453,397 292,846 344,936 Budget notes: ~2024 City Administrator; Admin Services Director/Treasurer; City Clerk; Accounting Clerk II; Accounting Clerk I; Team & Comm Liaison 10-5102-1002 SALARIES/WAGES - OVERTIME 1,500 1,500 .00 20 10-5102-1005 SALARIES/WAGES - LONGEVITY 1,294 1,156 1,156 1,108 10-5102-1006 SALARIES/WAGES - ALLOWANCES 2,100 2,100 1,400 12,924 10-5102-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 8,180 1,964 666 10-5102-1021 EMPLOYEE BENEFITS - SCL 37,254 36,192 24,523 27,156 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS 157,617 157,210 87,674 126,750 10-5102-1025 EMPLOYEE BENEFITS - COMP 12,462 12,074 7,732 9,885 10-5102-1026 EMPLOYEE BENEFITS - COMP 7,661 6,771 5,025 6,607 10-5102-1029 EMPLOYEE BENEFITS - WY 83,776 80,198 49,584 58,988 10-5102-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 3,310 2,000 1,694 739 Budget notes: ~2024 WY Assoc of Municipal Clerks & Treasurers $200; International Institutte of Municipal Clerks $200; Society for Human Resourse Managers $400; Government Finance Offcers Assoc $400; ARMA $400; GOSCMA $200; ICMA $1,080; Misc $430 10-5102-2122 TRAINING/DEVELOPMENT 10,000 3,600 2,235 3,123 Budget notes: ~2024 WAM Summer $750; WAM Winter $750; WAM Fall $500; WAMCAT $2,400; Caselle training $1,200; International Institute of Municipal Clerks $250; Athenian Dialogues $225; Tuition reimbursement $2,282; ICMA $900; WY/GOSCMA $500; Misc $243 10-5102-2123 MEALS/LODGING/TRAVEL 10,600 5,500 3,483 3,125 Budget notes: ~2024 WAM Summer $2,100; WAM Winter $2,100; WAM Fall 1,200; WAMCAT $500; Caselle traiinings $700; ICMA $3,000; WY/GOSCMA $700; Misc $300 10-5102-2158 MISC CONTRACTUAL SERVICES .00 .00 .00 6,886 10-5102-3210 OPERATING SUPPLIES 250 250 233 550 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 1,000 1,000 119 536 Total GENERAL GOVT - ADMIN SERVICES: 803,247 771,128 479,668 603,999 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 9 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title GENERAL GOVT - IT 10-5103-1001 SALARIES/WAGES - REGULAR .00 82,939 .00 91,319 10-5103-1005 SALARIES/WAGES - LONGEVITY .00 .00 .00 461 10-5103-1006 SALARIES/WAGES - ALLOWANCES .00 .00 .00 600 10-5103-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,002 .00 790 10-5103-1021 EMPLOYEE BENEFITS - SCL .00 6,421 .00 7,197 10-5103-1023 EMPLOYEE BENEFITS - HEALTH INS .00 26,088 .00 15,193 10-5103-1025 EMPLOYEE BENEFITS - COMP .00 2,156 .00 2,666 10-5103-1029 EMPLOYEE BENEFITS - WY .00 14,265 .00 10,328 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 3,500 1,614 1,370 10-5103-2155 REPAIRS/MAINTENANCE 7,600 .00 .00 .00 10-5103-2156 MAINTENANCE AGREEMENT 38,500 38,120 27,298 26,837 Budget notes: ~2024 Caselle $18,300; Veeam $3,400; Vmware $3,400; Civic Plus $6,000; MVI Laser $1,500; Connect Wise $600; GotoMeeting $300; WatchGuardSupport $4,000; Paraben phone forensic $1,000 10-5103-2158 MISC CONTRACTUAL SERVICES 189,064 45,500 105,858 39,733 Budget notes: ~2024 Microsoft Office 365 $23,736; Net motion $1,200; Creative Cloud $1,020; Design software $1,000; Visionary fiber $2,508; Sophos AV $3,600; Darktrace SAAS $18,000; Darktrace $15,000 Technical services agreement $100,000; Technical services agreement overtime $14,000; Consulting support $9,000 10-5103-3210 OPERATING SUPPLIES 2,400 800 10 .00 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 194,375 54,000 19,091 9,771 Budget notes: ~2024 Workstations (19) $28.000; Laptops $6,000; Laptops/Tablets $3,000; Tablets-MDT $28,700; Docking stations (2 in car, 2 desk) $3,000; Evidence NAS Storage $10,000; Monitors $3,425; Printers $3,750; Network equipment $25,000; Bluray printer/copier $3,500; Quantum tape drive backup $25,000; NAS Storage Server $20,000; AV upgrades (EIN-03) $15,000; Interactive engagement program $20,000 Total GENERAL GOVT - IT: 431,939 274,791 153,871 206,265 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 10 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title GENERAL GOVT - MUNICIPAL COURT 10-5105-1001 SALARIES/WAGES - REGULAR 55,076 48,295 38,715 49,108 Budget notes: ~2024 Municipal Court Judge; Municipal Court Clerk-75% 10-5105-1002 SALARIES/WAGES - OVERTIME .00 .00 .00 37 10-5105-1005 SALARIES/WAGES - LONGEVITY 499 481 481 463 10-5105-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 2,456 .00 780 10-5105-1021 EMPLOYEE BENEFITS - SCL 4,380 4,027 3,080 3,961 10-5105-1023 EMPLOYEE BENEFITS - HEALTH INS 7,648 7,615 5,084 7,606 10-5105-1025 EMPLOYEE BENEFITS - COMP 1,432 1,256 1,019 1,430 10-5105-1026 EMPLOYEE BENEFITS - COMP 1,683 1,412 1,071 1,388 10-5105-1029 EMPLOYEE BENEFITS - WY 7,237 6,071 4,604 5,976 10-5105-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 195 160 .00 300 Budget notes: ~2024 WY Municipal Court Judges Conference $150; WY Peace Officer Assoc Membership $45 10-5105-2122 TRAINING/DEVELOPMENT 420 400 .00 409 Budget notes: ~2024 Records Training (multiple) 10-5105-2123 MEALS/LODGING/TRAVEL 540 860 .00 .00 Budget notes: ~2024 Municiple Court Judges Conference 10-5105-2151 LEGAL 14,000 14,000 10,301 10,857 10-5105-2156 MAINTENANCE AGREEMENT 2,400 2,580 198 .00 Budget notes: ~2024 NCIC License and Full Court Software Maintenance 10-5105-2162 COURT SURCHARGES 750 .00 .00 550 10-5105-2166 COLLECTION FEES .00 .00 .00 .00 10-5105-2175 REFUNDS/REIMBURSEMENT EXPENSE 250 250 20 38 10-5105-3210 OPERATING SUPPLIES 500 500 .00 119 Budget notes: ~2024 Court Receipts, label machine supplies, boxes, business cards 10-5105-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 .00 9,800 10-5105-3233 UNIFORMS/CARE 150 150 .00 .00 Budget notes: ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 11 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title ~2024 Robe Cleaning; Department Polos (Clerk) Total GENERAL GOVT - MUNICIPAL COURT: 97,160 90,513 64,573 92,822 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 12 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title GENERAL GOVT - 10-5106-1001 SALARIES/WAGES - REGULAR 288,151 245,424 192,162 237,986 Budget notes: ~2024 Director; Building Official; Planning Technician; Code Complaince (32 Hrs/wk) 10-5106-1002 SALARIES/WAGES - OVERTIME .00 .00 .00 7 10-5106-1005 SALARIES/WAGES - LONGEVITY 944 825 849 753 10-5106-1006 SALARIES/WAGES - ALLOWANCES 900 900 600 900 10-5106-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 4,796 .00 .00 10-5106-1021 EMPLOYEE BENEFITS - SCL 22,817 19,822 15,221 18,870 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS 37,189 36,901 24,079 36,252 10-5106-1025 EMPLOYEE BENEFITS - COMP 7,540 6,551 5,034 6,807 10-5106-1026 EMPLOYEE BENEFITS - COMP 8,265 7,164 5,352 7,023 10-5106-1029 EMPLOYEE BENEFITS - WY 41,296 35,049 25,843 33,912 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 1,550 1,480 1,027 1,177 Budget notes: ~2024 Alliance for Historic Wyoming $100; National Alliance of Preservation Commissions: (Staff/Commission) $100; International Code Council $145; Wyoming Conference of Building Officials $50; American Planning Association (Director) $350; Wyoming Planning Association (Director, Planning Tech, P&Z Commission) $360; American Association of Code Enforcement $75.; ICC Certification Renewal $150; Wyoming Historical Society $70; Misc $150 10-5106-2122 TRAINING/DEVELOPMENT 2,500 2,735 1,106 726 Budget notes: ~2024 May Include: Max of $2,500. Wyoming Conference of Building Officials (fall/spring) – Casper, WY $350; Western Planner Conference – Anchorage, AK (Director) $600; American Planning Association – Minneapolis, MN (Director) $835; ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 13 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title Rocky Mountain Land Use Institute- Denver, CO (Virtual) (Director) $600; Wyoming Planning Association - Fall: (Director/1 Staff) – In WY (location unknown) $350; ICC Conference Colorado Chapter - Denver $400; Building Official Certification Exams (3 exams at $145 each) $435; Misc $150 10-5106-2123 MEALS/LODGING/TRAVEL 6,000 1,910 1,333 707 Budget notes: ~2024 May include: Max of $6,000. Wyoming Conference of Building Officials (fall/spring) – Casper, WY $400; Western Planner Conference – Anchorage, AK (Director) $2,430; American Planning Association – Minneapolis, MN (Director) $1,975; Rocky Mountain Land Use Institute – Denver, CO (Virtual) (Director) $830; Wyoming Planning Association - Spring:( Director/1 Staff/1 Commissioner) – Riverton, WY $765; Wyoming Planning Association - Fall:( Director/1 Staff) – In WY (location unknown) $1,080; International Conference of Building Officials – Denver, CO $1,200; Misc $150 10-5106-2134 TELECOMMUNICATIONS 1,250 1,250 798 1,198 Budget notes: ~2024 Cell Phone 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY 10,000 10,000 7,103 9,999 Budget notes: ~2024 General City engineering services 10-5106-2155 REPAIRS/MAINTENANCE 1,000 1,000 .00 .00 Budget notes: ~2024 Equipment repairs and maintenance 10-5106-2156 MAINTENANCE AGREEMENT 3,150 2,700 843 2,014 Budget notes: ~2024 ESRI ArcMap $1,650; Copier $600; Plotter $900 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 14 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 10-5106-2158 MISC CONTRACTUAL SERVICES 72,000 32,000 580 3,857 Budget notes: ~2024 Mapserver $7,000; Comprehensive Plan Update $60,000; Housing baseline measurement (FUN-03) $5,000 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE 750 750 1,143 25 10-5106-3210 OPERATING SUPPLIES 6,600 6,350 925 4,133 Budget notes: ~2024 Office supplies, notary, printing, advertising (FUN-03), vehicle parts & maintenance, records storage, misc. $4,000.00; Filing Fees $1,000.00; Public Relations - KKTY: 50 count 30 second ads (FUN-02) $1,000.00; Public Relations - Douglas Budget: 2 ads per year $600.00 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 1,000 1,000 .00 895 10-5106-3235 FUEL 2,000 2,000 260 520 Total GENERAL GOVT - 514,902 420,607 284,257 367,761 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 15 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title COMMUNITY SERVICE CONTRACTS 10-5110-8701 COMM PLA 100,000 .00 .00 .00 10-5110-8702 COMM CLUB/GEN 60,000 60,000 40,000 60,000 10-5110-8703 COMM RCREATN 30,000 30,000 30,000 30,000 10-5110-8705 COMM COUNTRY 30,000 30,000 12,500 30,000 10-5110-8707 COMM DVL 5,000 5,000 3,750 5,000 10-5110-8709 COMM 20,000 20,000 15,000 15,000 10-5110-8714 COMM ENTERPRIS 85,000 75,000 37,500 75,000 10-5110-8723 COMM HOCKEY 24,000 24,000 .00 24,000 10-5110-8734 COMM PEAK 85,000 85,000 53,313 80,680 10-5110-8746 COMM & GIRLS 25,000 25,000 16,667 22,500 10-5110-8750 COMM ADVOC 4,000 4,000 2,000 4,000 10-5110-8753 COMM SRVC BLK .00 10,000 .00 7,000 10-5110-8755 COMM HANDS 20,000 .00 .00 .00 10-5110-8757 COMM SERV-KINGS PORTION 25,000 20,000 16,727 20,000 10-5110-8759 COMM SRVC CENTER 20,000 20,000 .00 15,000 10-5110-8763 COMM SRVC 35,250 .00 .00 .00 Budget notes: ~2024 Bike skills facility (UPI-03) $25,500 10-5110-9000 CONTINGENCY 10,000 .00 .00 .00 Budget notes: ~2024 Community Service Block Grant $10,000 Total COMMUNITY SERVICE CONTRACTS: 578,250 408,000 227,457 388,180 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 16 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PUBLIC SERVICE CONTRACTS 10-5111-8744 COMM 407,100 370,900 323,640 362,898 10-5111-8760 COMM SRVC JUSTICE 1,000,000 905,500 551,329 628,920 Total PUBLIC SERVICE CONTRACTS: 1,407,100 1,276,400 874,969 991,818 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 17 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title POLICE DEPT - ADMINISTRATION 10-5201-1001 SALARIES/WAGES - REGULAR 175,335 154,343 119,449 184,625 Budget notes: ~2024 Chief of Police; Administrative Assistant; Municipal Court/Records Clerk - 25%; Juvenile Diversion 10-5201-1002 SALARIES/WAGES - OVERTIME 100 100 463 30 10-5201-1005 SALARIES/WAGES - LONGEVITY 250 160 160 893 10-5201-1006 SALARIES/WAGES - ALLOWANCES 900 900 600 900 10-5201-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 2,869 .00 1,550 10-5201-1021 EMPLOYEE BENEFITS - SCL 13,552 12,151 9,259 14,579 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS 39,358 39,209 45,432 79,719 10-5201-1025 EMPLOYEE BENEFITS - COMP 4,928 4,444 3,491 5,950 10-5201-1026 EMPLOYEE BENEFITS - COMP 561 471 357 3,303 10-5201-1029 EMPLOYEE BENEFITS - WY 30,175 26,564 19,524 28,274 10-5201-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 680 1,180 715 1,075 Budget notes: ~2024 WY Sheriffs & Chiefs $250; Rocky Mountain Information Network Intelligence Service $100; nternational Association of Chiefs of Police $190 ; WY Peace Officers Assoc $10; FBI NA $105; Misc $25 10-5201-2122 TRAINING/DEVELOPMENT 1,480 680 694 1,494 Budget notes: ~2024 WY Peace Officers Association $195; Leadership Conference-Casper $185; Law Enforcement Coordinating Council - Cheyenne $100; Administrative training $200 WASCOP Leadership Conference - $185; IACP Convention $500; FBI LEEDA PIO Training (Teya) $115 10-5201-2123 MEALS/LODGING/TRAVEL 3,810 1,195 506 449 Budget notes: ~2024 WY Assn of Sheriffs & Chiefs $310; WY Association of Chiefs of Police (President 2024) $400; ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 18 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title IACP Convention (Oct 13 - 18) $2,400; FBI LEEDA PIO Training $700 10-5201-2131 UTILITY SERVICES - ELECTRICITY 2,000 2,000 1,056 1,171 10-5201-2134 TELECOMMUNICATIONS 494 494 360 480 Budget notes: ~2024 Vehicle Connectivity for GPS 10-5201-2155 REPAIRS/MAINTENANCE 250 250 .00 .00 Budget notes: ~2024 Radio; Sirens; Chief's vehicle mantenance 10-5201-2156 MAINTENANCE AGREEMENT 1,200 1,200 769 920 Budget notes: ~2024 Copier Maintenance and supplies 10-5201-2158 MISC CONTRACTUAL SERVICES 4,550 5,500 1,790 5,264 Budget notes: ~2024 physicals, juvenile diversion & medical clearance exams $2,000; Employee Assistance Program $1,500, Vehicle Wash, $1,050 10-5201-2161 INCARCERATION CONTRACT 2,500 2,000 1,448 1,403 10-5201-3210 OPERATING SUPPLIES 8,550 3,300 896 3,033 Budget notes: ~2024 SRO camps; Notary expenses; Juvenile Diversion; Public relations; Hosted training supplies; Materials for Citizens Academy (ASC-02) 10-5201-3233 UNIFORMS/CARE 600 600 .00 166 Budget notes: ~2024 Uniform replacement of worn out items 10-5201-3235 FUEL 650 850 298 539 Total POLICE DEPT - ADMINISTRATION: 291,923 260,460 207,266 335,814 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 19 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title POLICE DEPT - PATROL 10-5202-1001 SALARIES/WAGES - REGULAR 1,345,245 1,141,146 802,938 987,261 Budget notes: ~2024 Lieutenant Sergeant SRO; Investigator; K9 Officer; Patrol Officer - 11; CommunityService Officer; Patrol Part-Time (24 Hrs/month) 10-5202-1002 SALARIES/WAGES - OVERTIME 65,000 50,000 62,288 98,216 10-5202-1005 SALARIES/WAGES - LONGEVITY 2,359 2,731 2,179 3,097 10-5202-1006 SALARIES/WAGES - ALLOWANCES 600 600 400 6,600 10-5202-1007 SALARIES/WAGES-INCENTIVE/BONUS 4,455 29,943 .00 915 10-5202-1021 EMPLOYEE BENEFITS - SCL 109,547 94,654 64,121 86,610 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS 406,212 432,031 256,087 358,991 10-5202-1025 EMPLOYEE BENEFITS - COMP 36,743 31,598 22,515 31,760 10-5202-1026 EMPLOYEE BENEFITS - COMP 14,330 12,889 8,571 13,365 10-5202-1029 EMPLOYEE BENEFITS - WY 241,076 203,688 135,471 177,564 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 1,154 954 360 405 Budget notes: ~2024 FBI National Academy Association $105; WY Peace Officers Association $160; WY Investigators Association $50; International Association of Chiefs of Police $190; National Association School Resource Officers $400; Association of Property & Evidence $130; Justice Clearinghouse $119 10-5202-2122 TRAINING/DEVELOPMENT 18,000 18,835 11,413 9,342 Budget notes: ~2024 May include: Max of $18,000. Defensive Edge AR 15 Armorer – WLEA (Sgts Cowardin and Toman) Glock Armorers Course – WLEA (Sgts Cowardin and Toman) Defensive Edge Shotgun Armorer – WLEA (Sgt. Cowardin) Cellebrite End User Training – Dwyer (contingent if not covered under grant, $5835) FLETC Introduction to Digital Evidence Analysis – Georgia (Officer Dwyer) FLETC Digital Evidence Acquisition Specialist Training – Georgia (Officer Dwyer) Crime Scene Management Course – Casper (Officers Boonstra and Byler) Instructor Development – WLEA (Sgt. Toman and Officer Dowd) Reid Interview and Interrogation – Denver, Colorado (2 Officers) Standardized Field Sobriety Test Instructor – Alpharetta, GA. (Officer Knight) Basic Hostage Negotiations – WLEA (Officer Reiter) Taser Instructor Course – Location TBD (1 Officer) FLETC Use of Force Instructor – WLEA (1 Officer) Midwest Counter Drug Training, labs-Fentanyl hazards and handling – Grand Junction, CO. (Ofc. ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 20 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title Dwyer) RMHIDTA Overdose Death Investigations – Denver, CO. (Officer Dwyer) Wyoming DCI Basic (TBD 2024) – Riverton, WY. (Officers Knight and Boonstra). FBI Law Enforcement Executive Supervisor Leadership Institute – Greeley, CO. (Sgts Cowardin, Toman) Def Tech Less than Lethal Instructor Recertification – TBD (Officer Jones) RMHIDTA Drug ID and – Denver, CO. (Officer Voigt) WPOA Conference – TBD (2 Officers) Desert Snow Interdiction – Casper, WY (2 Officers) Street Crimes Police Training Seminar – Colorado Springs, CO. (2 Officers) NASRO Conference – TBD (SRO’s Kelley and Evans) WASCOP Leadership Conference – TBD 2024 Casper, WY. (Matthews, Leman, Cowardin, Toman) PATC Basic Criminal Investigations – TBD (Officer Boonstra) Midwest Counterdrug Training, interdiction and patrol tactics – TBD (2 Officers) RMHIDTA Law Enforcement on the stand – Billings, MT. (2 Officers) Crisis Intervention Team training – TBD (2 Officers) RMHIDTA Basic Drug Investigators Course – Billings, MT. (2 Officers) Community Service Officer Training – TBD (CSO Byler) K9 Handler Training and Recertification – TBD (Officer Knight) Various Trainings in and out of state as they arise Peace Officer Basic – TBD WLEA (1 Officer) IACP Conference – San Diego, CA. (Matthews) Total $26,700 Tuition reiimbursement requested from three officers total $10,200. Recommend allocating $1,500 a pirece for a total of $4,500 in tuition reimbursement Defensive Edge AR 15 Armorer – WLEA (Sgts Cowardin and Toman) Glock Armorers Course – WLEA (Sgts Cowardin and Toman) Defensive Edge Shotgun Armorer – WLEA (Sgt. Cowardin) Cellebrite End User Training – Dwyer (contingent if not covered under grant, $5835) FLETC Introduction to Digital Evidence Analysis – Georgia (Officer Dwyer) FLETC Digital Evidence Acquisition Specialist Training – Georgia (Officer Dwyer) Crime Scene Management Course – Casper (Officers Boonstra and Byler) Instructor Development – WLEA (Sgt. Toman and Officer Dowd) Reid Interview and Interrogation – Denver, Colorado (2 Officers) Standardized Field Sobriety Test Instructor – Alpharetta, GA. (Officer Knight) Basic Hostage Negotiations – WLEA (Officer Reiter) Taser Instructor Course – Location TBD (1 Officer) FLETC Use of Force Instructor – WLEA (1 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 21 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 10-5202-2123 MEALS/LODGING/TRAVEL 16,000 15,815 14,088 6,287 Budget notes: ~2024 May include: Max $16,000. FLETC Introduction to Digital Evidence Analysis – Georgia (Officer Dwyer) $1,200; FLETC Digital Evidence Acquisition Specialist Training – Georgia (Officer Dwyer) $,477; Crime Scene Management Course – Casper (Officers Boonstra and Byler) $100 ; Reid Interview and Interrogation – Denver, Colorado (2 Officers) $760; Standardized Field Sobriety Test Instructor – Alpharetta, GA. (Officer Knight) $750; Taser Instructor Course – Location TBD (1 Officer) $400; Midwest Counter Drug Training, labs-Fentanyl hazards and handling – Grand Junction, CO. (Ofc. Dwyer) $125; RMHIDTA Overdose Death Investigations – Denver, CO. (Officer Dwyer) $160; Wyoming DCI Basic (TBD 2024) – Riverton, WY. (Officers Knight and Boonstra) $700; FBI Law Enforcement Executive Supervisor Leadership Institute – Greeley, CO. (Sgts Cowardin, Toman) $1,000; Def Tech Less than Lethal Instructor Recertification – TBD (Officer Jones) $750; RMHIDTA Drug ID and – Denver, CO. (Officer Voigt) $400; WPOA Conference – TBD (2 Officers) $600; Desert Snow Interdiction – Casper, WY (2 Officers) $100; Street Crimes Police Training Seminar – Colorado Springs, CO. (2 Officers) $800; NASRO Conference – TBD (SRO’s Kelley and Evans) $3,000; PATC Basic Criminal Investigations – TBD (Officer Boonstra) $800; Midwest Counterdrug Training, interdiction and patrol tactics – TBD (2 Officers) $400; RMHIDTA Law Enforcement on the stand – Billings, MT. (2 Officers) $250 ; Crisis Intervention Team training – TBD (2 Officers) $500; RMHIDTA Basic Drug Investigators Course – Billings, MT. (2 Officers) $850; Community Service Officer Training – TBD (CSO Byler) $500; K9 Handler Training and Recertification – TBD (Officer Knight) $1,000; Various Trainings in and out of state as they arise $3,000; IACP Conference – San Diego, CA (Matthews) $2,400 10-5202-2134 TELECOMMUNICATIONS 18,390 18,390 12,896 16,180 Budget notes: ~2024 Tablets - 19 $9,444; Cell Phones 18 - $8,946 10-5202-2155 REPAIRS/MAINTENANCE 8,000 8,000 2,168 5,646 Budget notes: ~2024 Radar;Video Systems; Electronic Equipment; Vehicles 10-5202-2156 MAINTENANCE AGREEMENT 13,838 15,037 3,265 10,387 Budget notes: ~2024 E-Citation $4,930; Radio Contract $4,000; DigiTicket/Spillman Interface $995; Lexis Nexis Information $1,800, Leads Online, $2113 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 22 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 10-5202-2158 MISC CONTRACTUAL SERVICES 4,372 4,100 801 2,329 Budget notes: ~2024 Wrecker calls, medical, forensic, mental health, polygraphs, blood draws - DUI for arrests & investigation, Interpreter service, Locksmith services; $1,225; Radar calibration $1,275, Decommission Patrol vehicles - $2472 10-5202-3201 OFFICE SUPPLIES 300 300 .00 49 Budget notes: ~2024 Misc project supplies; Community Outreach program; Officer Notebooks; Misc 10-5202-3210 OPERATING SUPPLIES 39,600 34,000 25,763 29,170 Budget notes: ~2024 Ammunition - rifle, shotgun & pistol (duty & practice); Ammunition for Peace Officer Basic ($992 per officer); weapons maintenance supplies; Range supplies (targets, safety glasses, etc.); OC Spray; Patrol vehicle repair parts & tires; Narcotics identification kits; Batteries for equipment & radios; latex/vinyl gloves; Pocket statutes; WY Criminal & Traffic Law Manuals; Warning books & other forms; Citation paper; Business cards; Community Service Officer supplies (cat food, gloves, Rompun, animal traps, etc.); Evidence collection supplies, K9 associated equipment handlers supplies, vet care cost, leads, etc.) 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 13,206 8,656 .00 9,122 Budget notes: ~2024 Radar Units $3,100; Glock 17 9mm Pistol with weapon light - $583; FN15 rifle with Trijicon sight $1,423; Portable Speed Trailer ($8,100 delivered); Forensic software $10,900 10-5202-3233 UNIFORMS/CARE 18,500 19,673 13,215 13,475 Budget notes: ~2024 Complete uniform - new officers & replacement uniforms & unservicable items; Outer vest carriers, added 3% inflation/transportation cost Complete uniform - new officers & replacement uniforms & unservicable items; Outer vest carriers, added 3% inflation/transportation cost (Recommend a boot allowance reimbursement to officers @ $100) 10-5202-3235 FUEL 16,995 16,995 9,184 13,248 Budget notes: ~2024 Patrol Vehicles Total POLICE DEPT - PATROL: 2,393,922 2,160,035 1,447,723 1,880,017 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 23 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 24 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PUBLIC WORKS - ADMINISTRATION 10-5301-1001 SALARIES/WAGES - REGULAR 183,794 161,561 124,336 154,736 Budget notes: ~2024 Director; Secretary 10-5301-1002 SALARIES/WAGES - OVERTIME .00 .00 .00 9 10-5301-1005 SALARIES/WAGES - LONGEVITY 1,402 1,354 1,354 1,306 10-5301-1006 SALARIES/WAGES - ALLOWANCES 900 900 600 900 10-5301-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 5,107 1,781 582 10-5301-1021 EMPLOYEE BENEFITS - SCL 14,296 12,950 9,825 12,089 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS 36,951 36,790 24,388 36,553 10-5301-1025 EMPLOYEE BENEFITS - COMP 4,859 4,355 3,330 4,475 10-5301-1029 EMPLOYEE BENEFITS - WY 31,613 27,789 20,298 26,616 10-5301-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 315 576 232 225 Budget notes: ~2024 American Public Works Association $235, American Notary Law $80 10-5301-2122 TRAINING/DEVELOPMENT 665 550 350 204 Budget notes: ~2024 WGGA Conference $275 Solid Waste Conference $390 10-5301-2123 MEALS/LODGING/TRAVEL 600 600 256 .00 Budget notes: ~2024 Wy Solid Waste & Recycling Conference $600 10-5301-2131 UTILITY SERVICES - ELECTRICITY 10,700 10,700 5,777 8,539 Budget notes: ~2024 Public Works Building, Cold Storage, Annex Building 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 5,000 5,000 3,266 4,876 Budget notes: ~2024 Public Works Building, Annex Building 10-5301-2133 UTILITY SERVICES - NATURAL GAS 9,500 9,500 12,254 9,308 Budget notes: ~2024 Public Works Building, Annex Building 10-5301-2134 TELECOMMUNICATIONS 650 500 622 600 Budget notes: ~2024 In/Out of State service; Fax; Cell Phone - 1 10-5301-2153 ARCHITECT/ENGINEERING/SURVEING 2,000 1,000 .00 963 Budget notes: ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 25 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title ~2024 Misc, Engineering 10-5301-2155 REPAIRS/MAINTENANCE 1,500 1,500 1,460 185 Budget notes: ~2024 Electrical, AC, Heating & Plumbing, Telephone, Radios, Building up keep,etc. 10-5301-2156 MAINTENANCE AGREEMENT 400 2,750 2,650 2,650 Budget notes: ~2024 IKON Copier $400 10-5301-3210 OPERATING SUPPLIES 7,400 2,200 1,856 1,240 Budget notes: ~2024 Office supplies, Cleaning Supplies CPR & First Aid training for all Public Works employees - $3000 10-5301-3230 REFRESHMENT SUPPLIES 1,250 750 481 342 Budget notes: ~2024 Coffee, Creamer, Tea, Sugar, Etc. PW summer BBQ - $500 10-5301-3235 FUEL 1,500 1,000 285 542 Total PUBLIC WORKS - ADMINISTRATION: 315,295 287,432 215,401 266,939 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 26 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PUBLIC WORKS - SHOP 10-5302-1001 SALARIES/WAGES - REGULAR 230,300 210,894 188,059 201,720 10-5302-1002 SALARIES/WAGES - OVERTIME 500 500 84 .00 10-5302-1005 SALARIES/WAGES - LONGEVITY 741 1,375 1,375 1,303 10-5302-1006 SALARIES/WAGES-ALLOWANCE 600 600 400 600 10-5302-1007 SALARIES/WAGES-INCENTIVE/BONUS 452 7,454 .00 .00 10-5302-1021 EMPLOYEE BENEFITS - SCL 17,853 17,646 15,253 16,252 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS 88,154 72,271 48,195 72,253 10-5302-1025 EMPLOYEE BENEFITS - COMP 6,056 5,708 4,938 5,783 10-5302-1026 EMPLOYEE BENEFITS - COMP .00 9,066 9,324 8,627 10-5302-1029 EMPLOYEE BENEFITS - WY 39,698 36,360 26,083 34,696 10-5302-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 4,350 4,200 4,145 3,190 Budget notes: ~2024 Online vehicle repair information (All Data) $1,500. Diesel laptop Subscription truck and off highway $1,900 Diagnostic scan tool subscription (OTC) $950. 10-5302-2122 TRAINING/DEVELOPMENT 2,400 300 570 .00 Budget notes: ~2024 Online Training 300. 10-5302-2141 EQUIPMENT RENT 200 200 .00 .00 Budget notes: ~2024 Misc. tools or equipment $200 10-5302-2155 REPAIRS/MAINTENANCE 2,500 4,375 932 6,680 Budget notes: ~2024 Air compressor motor& preventive maintenance wiring $1,150; Annual vehicle lifts inspection $425 10-5302-3210 OPERATING SUPPLIES 16,000 14,000 9,633 13,195 Budget notes: ~2024 test equipment; Fasteners, bolts, washers, screws, rivets, etc; Misc electrical Cleaning supplies: Shop manuals: Welding Supplies: Abrasives: Batteries Test Equipment: Fasteners, Botlts, Washers, Screws, Nuts, Rivets, ETC Misc. Electrical repair supplies; Misc. types of tape; Fire extinguisher - vehicles; Adhesives, sealant; Oxygen & acetylene cylinder refills; Coveralls; Safety apparel; Fittings, pipe, air, fuel; Lights & bulbs for vehicles & shop; Metal for misc. repairs; Tires & tubes for shop equipment; Hoses of all types; Tire ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 27 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title repair supplies; Repair parts for shop vehicle & equipment; Misc types of filters for all city vehicles & equipment, Safety Eqipment/ Boots, Gloves, Hardhats And Safety Glasses 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 13,925 13,150 8,002 12,000 Budget notes: ~2024 J-Pro Professional With fault guidance and Repair Diagnostic Toolbox $8,425.00 Socket sets, wrench sets and Misc. for secondary work station $1000.00 Topside Creeper For Extensive Underhood Repairs $500 Hand Tools, Drill Bits, Hammers $4,000. 10-5302-3235 FUEL 1,500 2,000 669 1,317 Budget notes: ~2024 Fuel for the shop vehicle and equipment 10-5302-3237 OIL/LUBE/FLUIDS 14,000 12,500 8,789 51,185 Budget notes: ~2024 Grease, gear lubes, ATF motor oils, hydraulic oils, C-3 fluids, etc. for all city vehicles & equipment Total PUBLIC WORKS - SHOP: 439,229 412,599 326,451 428,800 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 28 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PUBLIC WORKS - PARKS 10-5304-1001 SALARIES/WAGES - REGULAR 257,700 228,978 178,497 219,342 10-5304-1002 SALARIES/WAGES - OVERTIME 2,000 2,000 142 746 10-5304-1004 SALARIES/WAGES - TEMPORARY 84,000 60,833 12,996 19,948 10-5304-1005 SALARIES/WAGES - LONGEVITY 1,111 1,003 1,003 896 10-5304-1006 SALARIES/WAGES - ALLOWANCES 300 300 200 300 10-5304-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 8,479 1,781 .00 10-5304-1021 EMPLOYEE BENEFITS - SCL 26,431 23,102 14,950 18,486 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS 116,920 116,774 77,865 116,757 10-5304-1025 EMPLOYEE BENEFITS - COMP 8,983 7,773 5,060 6,844 10-5304-1026 EMPLOYEE BENEFITS - COMP .00 .00 524 27 10-5304-1029 EMPLOYEE BENEFITS - WY 44,668 39,728 28,628 37,855 10-5304-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 750 750 531 325 Budget notes: ~2024 WY Growers & Groundskeepers Association $250; WY Mosquito Management Association $250; WY Recreation & Parks Association $50; Wyoming one call locates $200 10-5304-2122 TRAINING/DEVELOPMENT 1,900 1,900 975 1,585 Budget notes: ~2024 WY Growers & Groundskeepers Association $1,000; WY Mosquito Management Association conference $100; Wy Recreation & Parks Association $175; Wyo weed management association pesticide re-certification $375; ISA Certification $250 10-5304-2123 MEALS/LODGING/TRAVEL 1,500 1,500 .00 .00 Budget notes: ~2024 WY Mosquito Management Association conference - $1,000; WY Recreation & Parks $500 10-5304-2131 UTILITY SERVICES - ELECTRICITY 20,000 18,000 13,793 19,705 Budget notes: ~2024 Parks, Public Restrooms; Sprinkler Systems; Ball Fields - Lights; Parking Lots; Tennis Courts 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 95,000 95,000 71,153 90,471 Budget notes: ~2024 Public Restrooms; Sprinkler Systems; City Parks 10-5304-2133 NATURAL GAS, PROPANE 500 .00 239 .00 Budget notes: ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 29 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title ~2024 Jackalope Square fire pit 10-5304-2141 EQUIPMENT - RENT 1,000 1,000 .00 75 Budget notes: ~2024 Trencher, seeder, cement equipment, hammer drill, roto rooter Misc. rental 10-5304-2155 REPAIRS/MAINTENANCE 5,000 5,000 450 3,518 Budget notes: ~2024 Electric motors; Pump; Electric outages; Lighting repairs; Motors; Etc 10-5304-2156 MAINTENANCE AGREEMENT 7,340 7,340 1,175 1,175 Budget notes: ~2024 Weathertrak Control $1,440; Outdoor warning system $5,900 10-5304-2158 MISC CONTRACTUAL SERVICES 45,000 35,000 26,350 17,960 Budget notes: ~2024 Tree Trimming $25,000; 50/50 program $10,000; Crushing concrete/asphalt $10,000 10-5304-3210 OPERATING SUPPLIES 45,000 45,000 24,967 43,021 Budget notes: ~2024 Signs, grass seed, wood preservative, cleaning materials, garbage bags, concrete ready mix, chainsaws, electric motors, pumps, gravel, nuts, bolts, paints, sprinkler heads, valves, water lines, small tools, equipment parts & supplies, tires, landfill fees, etc $25,000; Fertilizer& herbacides $10,000; Mosquito control chemicals $10,000; Safety appare (lBoots, Gloves, Safety vests, PPE) $2,000 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 2,500 3,500 2,891 970 Budget notes: ~2024 Misc $1,000; Trimmers and blowers $1,500 10-5304-3235 FUEL 10,000 10,000 3,071 5,216 Budget notes: Pickups; Trucks; Mowers; Trimmers; Tractors; Chain saws ~2024 Pickups; Trucks; Mowers; Trimmers; Tractors; Chain saws Total PUBLIC WORKS - PARKS: 777,603 712,960 467,243 605,222 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 30 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PUBLIC WORKS - STREETS/ALLEYS 10-5305-1001 SALARIES/WAGES - REGULAR 314,029 284,933 229,035 273,612 10-5305-1002 SALARIES/WAGES - OVERTIME 4,000 4,000 4,200 2,475 10-5305-1004 SALARIES/WAGES - TEMPORARY 16,800 12,167 .00 .00 10-5305-1005 SALARIES/WAGES - LONGEVITY 1,273 1,650 1,650 1,519 10-5305-1006 SALARIES/WAGES - ALLOWANCES 300 300 175 300 10-5305-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 10,329 1,382 1,456 10-5305-1021 EMPLOYEE BENEFITS - SCL 25,765 24,064 18,161 21,461 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS 127,118 101,235 66,445 101,257 10-5305-1025 EMPLOYEE BENEFITS - COMP 8,757 7,757 6,148 7,934 10-5305-1026 EMPLOYEE BENEFITS - COMP .00 790 699 775 10-5305-1029 EMPLOYEE BENEFITS - WY 54,701 49,696 35,907 47,464 10-5305-2122 TRAINING/DEVELOPMENT 2,400 790 .00 475 Budget notes: ~2024 Transportation & Safety Congress $390; Misc $400 10-5305-2155 REPAIRS/MAINTENANCE 60,000 60,000 24,067 21,249 Budget notes: Engine, drive train & two way radios; Asphalt-Deteriorating streets & some alleys ~2024 Asphalt-Deteriorating streets & some alleys $60,000 10-5305-2158 MISC CONTRACTUAL SERVICES 64,700 59,700 52,813 42,182 Budget notes: ~2024 Street striping $15,000; Dust suppressant for graveled City streets $14,000; Inspection of bucket truck $700; Crushing asphalt $24,000; Tree trimming $5,000; Misc $6,000 10-5305-3210 OPERATING SUPPLIES 73,900 71,900 65,273 72,644 Budget notes: ~2024 Crack sealing material $17,000; Dump truck tire chains $1,200 Signs; Sign posts, Sweeper brooms; Delineator posts; Traffic control materials; Tools; Paint; Chemicals; Asphalt mix; Concrete mix; Gravel; Snow plow/grader blades; Cutting edges; Material for fabrication; Safety/ operational materials; Vehicles/equipment repair parts; Tires; Ice ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 31 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title slicer, cold weather asphalt patch material, additional asphalt mix for large repair of streets; Christmas decorations; Landfill disposal costs; Misc $53,700 Misc. Safety equipment Boots, gloves vests and glasses. $2000 10-5305-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 2,400 .00 .00 .00 Budget notes: ~2024 Gas powered pole pruner $1200 2- Weed Eaters $1200 10-5305-3235 FUEL 25,000 25,000 8,299 13,520 Total PUBLIC WORKS - STREETS/ALLEYS: 781,143 714,311 514,256 608,322 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 32 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PUBLIC WORKS - CEMETERY 10-5306-1001 SALARIES/WAGES - REGULAR 161,031 142,822 111,944 139,677 10-5306-1002 SALARIES/WAGES - OVERTIME 1,500 1,500 560 1,853 10-5306-1004 SALARIES/WAGES - TEMPORARY 16,800 12,167 .00 2,867 10-5306-1005 SALARIES/WAGES - LONGEVITY 1,221 1,161 1,161 1,101 10-5306-1006 SALARIES/WAGES - ALLOWANCES 300 300 200 300 10-5306-1007 SALARIES/WAGES-INCENTIVE/BONUS 449 8,627 1,964 1,082 10-5306-1021 EMPLOYEE BENEFITS - SCL 13,899 11,920 8,991 11,317 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS 65,032 64,942 43,304 64,942 10-5306-1025 EMPLOYEE BENEFITS - COMP 4,712 4,211 3,012 4,172 10-5306-1026 EMPLOYEE BENEFITS - COMP .00 1,018 1,656 1,010 10-5306-1029 EMPLOYEE BENEFITS - WY 27,955 24,823 18,081 24,343 10-5306-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 100 100 100 100 Budget notes: ~2024 WY Growers & Groundskeepers Association $100 10-5306-2122 TRAINING/DEVELOPMENT 400 400 350 300 Budget notes: ~2024 WY Growers & Groundskeepers Association conference $400 10-5306-2131 UTILITY SERVICES - ELECTRICITY 3,500 3,500 2,388 2,758 Budget notes: ~2024 Cemetery building & sprinkler systems 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 60,000 60,000 42,222 54,013 Budget notes: ~2024 Cemetery & building 10-5306-2133 UTILITY SERVICES - NATURAL GAS 1,600 1,500 1,813 1,494 Budget notes: ~2024 Cemetery shop 10-5306-2134 TELECOMMUNICATIONS 1,000 1,000 520 607 Budget notes: ~2024 Phone, Internet 10-5306-2141 EQUIPMENT - RENT 200 200 .00 .00 Budget notes: ~2024 Cement equipment; Hammer drills 10-5306-2155 REPAIRS/MAINTENANCE 1,500 1,500 60 299 Budget notes: ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 33 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title ~2024 Electric motors; Pump; Electric outages & repair; Motors; Controllers 10-5306-2156 MAINTENANCE AGREEMENT 1,000 1,000 905 905 Budget notes: ~2024 Weathertrak Control 10-5306-2158 MISC CONTRACTUAL SERVICES 8,500 8,500 7,000 7,435 Budget notes: ~2024 Tree trimming $7,000; Columbarium engraving $1,500 10-5306-3210 OPERATING SUPPLIES 11,500 11,500 6,336 8,386 Budget notes: ~2024 Electric motors; Sand; Gravel; Points; Sprinkler heads; Valves; Water lines; Pumps; Small tools; Landfill Fees; Misc parts/supplies $6,500; Fertilizer $2,500; Herbicide $2,500; Safety apparel (Boots, Gloves, Safety vests, PPE) $600 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 1,000 1,000 150 669 Budget notes: ~2024 Trimmers & blowers; misc 10-5306-3235 FUEL 2,500 2,500 976 1,315 Budget notes: ~2024 Fuel for Mowers, weedeaters, backhoe, compressor, and trucks. 10-5306-6540 LAND .00 1,000 .00 250 Total PUBLIC WORKS - CEMETERY: 385,699 367,191 253,691 331,193 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 34 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PUBLIC WORKS - SWIM POOL 10-5307-2131 UTILITY SERVICES - ELECTRICITY 7,000 7,000 4,558 6,533 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB 13,000 13,000 3,098 12,719 10-5307-2133 UTILITY SERVICES - NATURAL GAS 10,000 6,000 4,003 11,572 10-5307-2134 TELECOMMUNICATIONS 1,500 1,500 459 972 Budget notes: ~2024 Phone and internet service 10-5307-2155 REPAIRS/MAINTENANCE 5,000 5,000 .00 4,652 Budget notes: ~2024 Boiler cleaning, Electrical repairs, Misc. 10-5307-2158 MISC CONTRACTUAL SERVICES 134,500 128,500 75,312 103,986 Budget notes: ~2024 Recreation District $126,000; Slide maintenance $8,000; Misc $500 10-5307-3210 OPERATING SUPPLIES 12,000 10,000 4,147 12,418 Budget notes: ~2024 Pool Chemicals, Cleaners, Parts, Paint and antifreeze 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 2,500 2,500 .00 576 Budget notes: ~2024 Loungers; Umbrellas; Misc Total PUBLIC WORKS - SWIM POOL: 185,500 173,500 91,577 153,427 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 35 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title OPERATING TRANSFERS - OUT 10-5998-4308 TRANSFER TO GF EQUIP RESERVE .00 300,000 225,000 .00 10-5998-4309 TRANSFER TO GF EQUIP FRM 500,000 .00 .00 .00 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ 29,817 26,742 20,057 800 10-5998-4332 TRANSFER TO SEWER 820,000 .00 .00 .00 10-5998-4339 TRANSFER TO HEALTH INS RESERVE .00 100,000 75,000 100,000 10-5998-4341 TRANSFER TO ECONOMIC DEVELOPME 1,875,000 50,000 37,500 .00 10-5998-4350 TRANSFER TO FIRE EQUIPMENT 250,000 250,000 187,500 100,000 10-5998-4353 TRANSFER TO CLG GRANT .00 3,010 2,258 4,300 10-5998-4354 TRANSFER TO TRAIN CAR RESTORAT 25,000 35,000 26,250 25,000 10-5998-4355 TRANSFER TO POOL IMPROVEMENT 250,000 195,000 146,250 162,500 10-5998-4356 TRANSFER TO STREET IMPROVEMENT .00 3,000,000 2,250,000 5,900,000 10-5998-4357 TRANSFER TO PUBLIC FACILITIES .00 .00 .00 218,000 10-5998-4365 TRANSFER TO PARK IMPROVEMENTS .00 860,000 645,000 291,342 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN 1,800 3,650 2,738 3,800 Total OPERATING TRANSFERS - OUT: 3,751,617 4,823,402 3,617,552 6,805,742 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 36 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title IMPACT ASSISTANCE FUND IMPACT ASSISTANCE - REVENUE 11-4110-1140 INTEREST INCOME .00 5,000 10,535 6,540 Total IMPACT ASSISTANCE - REVENUE: .00 5,000 10,535 6,540 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 37 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title IMPACT ASSISTANCE - EXPENDITUR 11-5110-4347 TRANSFER TO EQUIPMENT RESERVE 36,559 .00 .00 .00 11-5110-4356 TRANSFER TO STREET IMPROVEMENT 1,545,110 .00 .00 .00 Total IMPACT ASSISTANCE - EXPENDITUR: 1,581,669 .00 .00 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 38 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title POLICE SPECIAL PROJECTS FUND K9 PROGRAM 13-4804-1560 DONATIONS .00 20,000 27,500 .00 Total K9 PROGRAM: .00 20,000 27,500 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 39 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title RURAL VIOLENT CRIME GRANT-REV 13-4820-4294 RURAL VIOLENT CRIME REDUCTION 100,129 .00 .00 .00 Total RURAL VIOLENT CRIME GRANT-REV: 100,129 .00 .00 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 40 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title HIGHWAY SAFETY TRAFFIC - REVEN 13-4821-4289 DOT/WDOT 7,769 7,767 2,275 3,194 Total HIGHWAY SAFETY TRAFFIC - REVEN: 7,769 7,767 2,275 3,194 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 41 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SRO PROGRAM - REVENUE 13-4830-1001 REIMBURSEMENT-CCSD#1-SRO 28,473 25,317 .00 .00 13-4830-4283 FED BUREAU JUSTICE ADMIN - SRO 56,087 50,635 15,273 .00 13-4830-5510 TRANSFER FROM GENERAL FUND 28,473 25,317 .00 .00 Total SRO PROGRAM - REVENUE: 113,033 101,269 15,273 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 42 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title OJJDP-UNDERAGE ENFRC - REVENUE 13-4831-3270 WY DEPARTMENT OF HEALTH 8,603 8,606 2,034 6,779 Total OJJDP-UNDERAGE ENFRC - REVENUE: 8,603 8,606 2,034 6,779 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 43 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title BULLET PROOF VEST - REVENUE 13-4838-4281 FED BUREAU JUSTICE ADMIN - BJA 1,344 1,425 1,613 800 13-4838-5510 TRANSFER FROM GENERAL FUND 1,344 1,425 20,057 800 Total BULLET PROOF VEST - REVENUE: 2,688 2,850 21,669 1,600 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 44 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title ASSET SEIZURE 13-5130-3210 OPERATING SUPPLIES .00 1,255 405 389 Total ASSET SEIZURE: .00 1,255 405 389 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 45 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title K9 PROGRAM 13-5804-6547 EQUIPMENT/FURNITURE .00 20,000 6,750 .00 Total K9 PROGRAM: .00 20,000 6,750 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 46 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title RURAL VIOLENT CRIME REDUCTION 13-5820-1001 SALARIES/WAGES - REGULAR 26,986 .00 .00 .00 13-5820-1021 EMPLOYEES BENEFITS - SCL 2,064 .00 .00 .00 13-5820-1023 EMPLOYEE BENEFITS - HEALTH INS 701 .00 .00 .00 13-5820-1025 EMPLOYEE BENEFITS - COMP 702 .00 .00 .00 13-5820-1029 EMPLOYEE BENEFITS - WY 4,642 .00 .00 .00 13-5820-2122 TRAINING/DEVELOPMENT 9,084 .00 .00 .00 13-5820-3220 EQUIPMENT/TOOLS NON CAPITALIZE 21,950 .00 .00 .00 13-5820-6547 EQUIPMENT/FURNITURE 34,000 .00 .00 .00 Total RURAL VIOLENT CRIME REDUCTION: 100,129 .00 .00 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 47 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title HIGHWAY SAFETY TRAFFIC ENFORCE 13-5821-1001 SALARIES/WAGES - REGULAR 6,095 6,095 2,217 1,962 Budget notes: ~2024 Highway traffic safety DUI/Occupant Protection OT 13-5821-1021 EMPLOYEE BENEFITS - SCL 467 466 227 150 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS .00 .00 690 461 13-5821-1025 EMPLOYEE BENEFITS - COMP 159 158 77 56 13-5821-1029 EMPLOYEE BENEFITS - WY 1,048 1,048 512 337 Total HIGHWAY SAFETY TRAFFIC ENFORCE: 7,769 7,767 3,723 2,966 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 48 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SCHOOL RESOURCE OFFICER 13-5830-1001 SALARIES/WAGES - REGULAR 66,219 56,067 23,062 .00 13-5830-1002 SALARIES/WAGES - OVERTIME 2,500 2,500 555 .00 13-5830-1005 SALARIES/WAGES - LONGEVITY 131 .00 107 .00 13-5830-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,201 .00 .00 13-5830-1021 EMPLOYEE BENEFITS - SCL 5,267 4,572 1,815 .00 13-5830-1023 EMPLOYEE BENEFITS - HEALTH INS 25,736 25,731 10,723 .00 13-5830-1025 EMPLOYEE BENEFITS - COMP 1,790 1,554 617 .00 13-5830-1029 EMPLOYEE BENEFITS - WY 11,390 9,644 3,804 .00 Total SCHOOL RESOURCE OFFICER 113,033 101,269 40,682 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 49 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title OJJDP-UNDERAGE ENFORCEMENT 13-5831-1001 SALARIES/WAGES - REGULAR 6,750 6,750 1,283 2,372 Budget notes: ~2024 Underage Drinking Enforcement OT 13-5831-1021 EMPLOYEE BENEFITS - SCL 516 518 98 181 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS .00 .00 253 562 13-5831-1025 EMPLOYEE BENEFITS - COMP 176 175 33 70 13-5831-1029 EMPLOYEE BENEFITS - WY 1,161 1,163 221 408 13-5831-2158 MISC CONTRACTUAL SERVICES .00 .00 320 991 13-5831-3210 OPERATING SUPPLIES .00 .00 150 669 Total OJJDP-UNDERAGE ENFORCEMENT: 8,603 8,606 2,358 5,253 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 50 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title BULLET PROOF VEST PROTECTION 13-5838-3233 UNIFORMS/CARE 2,688 2,850 3,763 1,600 Budget notes: ~2024 Five officers due new vest (expire this year). Total BULLET PROOF VEST PROTECTION: 2,688 2,850 3,763 1,600 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 51 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title WATER FUND WATER - REVENUE 31-4310-0160 GAIN ON INVESTMENTS .00 .00 43,110- 209,369- 31-4310-1107 OTHER 1,500 1,500 1,373 1,512 31-4310-1140 INTEREST INCOME 260,000 105,000 149,794 161,764 31-4310-1704 USER CHARGES 2,800,000 2,800,000 2,028,027 2,566,395 31-4310-1705 UTILITY SERVICE FEES 20,000 15,000 15,940 25,818 31-4310-1706 WATER PLANT INVESTMENT FEES 31,250 2,750 30,750 39,900 Budget notes: To replacement reserve 31-4310-1707 UTILITY LATE FEES 15,500 15,000 11,460 15,660 31-4310-1710 BULK WATER 50,000 50,000 55,986 85,675 Total WATER - REVENUE: 3,178,250 2,989,250 2,250,221 2,687,354 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 52 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title WATER - ADMINISTRATION 31-5400-1150 DEPRECIATION 850,000 1,000,000 750,000 485,000 31-5400-2158 MISC CONTRACTUAL SERVICES 12,000 10,000 8,921 10,041 31-5400-2166 COLLECTION FEES 500 250 486 375 31-5400-2175 REFUNDS/REIMBURSEMENT EXPENSE 500 500 .00 35 31-5400-4345 INVESTMENT FEES .00 .00 .00 3,167 31-5400-4347 MANAGEMENT FEES 295,051 272,629 204,472 263,863 31-5400-9000 CONTINGENCY 50,000 .00 .00 .00 Total WATER - ADMINISTRATION: 1,208,051 1,283,379 963,878 762,480 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 53 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title WATER - TREATMENT 31-5401-0150 REPLACEMENT RESERVE-SAND FILTE 75,000 75,000 56,250 75,000 Budget notes: ~2024 Reserve for filter sand replacement. filters need re-sanded every 10 years Reserve for filter sand replacement. filters need re-sanded approx. every 10 years 31-5401-0153 REPLACEMENT RESERVE-SMW REHA .00 15,000 11,250 15,000 31-5401-1001 SALARIES/WAGES - REGULAR 115,856 103,328 79,986 101,302 31-5401-1002 SALARIES/WAGES - OVERTIME 6,000 6,000 2,554 6,079 31-5401-1005 SALARIES/WAGES - LONGEVITY 678 643 643 607 31-5401-1006 SALARIES/WAGES - ALLOWANCES .00 300 200 300 31-5401-1007 SALARIES/WAGES-INCENTIVE/BONUS 2,526 5,739 .00 .00 31-5401-1021 EMPLOYEE BENEFITS - SCL 9,620 9,063 6,528 8,469 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS 39,102 39,041 26,017 39,020 31-5401-1025 EMPLOYEE BENEFITS - COMP 3,204 2,932 2,168 3,075 31-5401-1026 EMPLOYEE BENEFITS - COMP .00 2,067 1,668 2,026 31-5401-1029 EMPLOYEE BENEFITS - WY 20,959 18,804 13,445 18,470 31-5401-2122 TRAINING/DEVELOPMENT 2,570 2,570 1,208 338 Budget notes: ~2024 WY Water Quality & Pollution Control conference $520; WY Rural Water conference $600; Ken Keri Study course $200; Misc $1,000; Self Contained Breathing Apparatus Fit test & training $250; Misc. Professional development 31-5401-2123 MEALS/LODGING/TRAVEL 800 .00 .00 .00 Budget notes: ~2024 Meals, lodging and travel expenses for training-only for out of town/multi-day training 31-5401-2131 UTILITY SERVICES - ELECTRICITY 58,000 55,000 35,370 54,408 Budget notes: ~2024 Water treatment plant; Sheep Mountain Well; Spring flow control building 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 12,000 7,500 6,814 7,775 Budget notes: ~2024 Water treatment plant & irrigation system 31-5401-2133 UTILITY SERVICES - NATURAL GAS 7,500 6,000 6,346 5,548 Budget notes: ~2024 Water treatment plant ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 54 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 31-5401-2134 TELECOMMUNICATIONS 200 200 79 170 Budget notes: ~2024 Plant Operator/Septic disposal Cell phone 50%; Water system alarm dialer 31-5401-2140 RENT - LAND/BUILDINGS 12,000 12,000 10,197 10,184 Budget notes: ~2024 Road lease Barber ranch; Radio repeater lease-Spring Line 31-5401-2153 ARCHITECT, ENG, SURVEY 4,500 2,000 747 1,593 Budget notes: ~2024 Minor surveying, site mapping and misc. engineering services $2,500; Grant applications $2,000 31-5401-2155 REPAIRS/MAINTENANCE 45,000 23,000 20,927 6,519 Budget notes: ~2024 Motors; Pumps; Valves; Process control and SCADA equipment; Vehicles & misc other equipment $45,000 31-5401-2156 MAINTENANCE AGREEMENT 10,000 9,000 .00 7,350 Budget notes: Calibrate & inspect meters ~2024 Service agreement for calibration and maintenance of process meters for WTP 31-5401-2158 MISC CONTRACTUAL SERVICES 40,000 39,000 11,668 12,639 Budget notes: ~2024 Laboratory services for water analysis associated with water treatment and quality; Annual alignment and service of pumps and motors; Diagnostics and troubleshooting of process control equipment and SCADA system; Service and diagnostics for hydraulic control valves $40,000 31-5401-3210 OPERATING SUPPLIES 40,000 25,000 19,713 30,149 Budget notes: ~2024 Chemicals for water treatment; Misc. small repair parts and supplies; Landfill fees; Misc small hand and power tools; Replacement probes, reagents for laboratory analysis; Misc operating and cleaning supplies; Misc. PPE; Safety steel toed boots $200 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 24,550 23,800 14,795 8,236 Budget notes: ~2024 Portable colorimeter $750; Weed trimmer $800; Forks, bucket, leveler for track loader $15,000; Chemical feed equipment $8,000 31-5401-3235 FUEL 1,200 2,000 368 708 31-5401-6542 TO BLDG 24,000 22,000 .00 16,454 Budget notes: ~2024 Replace doors at SM Well, CB Booster and WTP $24,000 31-5401-6544 OTHER THAN BLDG 55,000 83,000 64,795 661,975 Budget notes: ~2024 Replace gate access controller LBES $30,000; Downhole pressure transducer $25,000 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 55 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 31-5401-6547 EQUIPMENT/FURNITURE 15,500 48,000 55,500 .00 Budget notes: ~2024 SCBA storage cabinet $5,500; Valve exerciser $10,000 31-5401-6548 VEHICLES 32,500 20,000 .00 .00 Budget notes: ~2024 Replace unit 180, 2007 Dodge Dakota 50% $32,500-rebudget from last year Total WATER - TREATMENT: 658,265 657,987 449,236 1,093,391 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 56 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title WATER - DISTRIBUTION/MAINTNCE 31-5402-0150 REPLACEMENT RESERVE 30,000 30,000 22,500 30,000 31-5402-1001 SALARIES/WAGES - REGULAR 236,420 185,051 146,173 177,305 31-5402-1002 SALARIES/WAGES - OVERTIME 7,500 7,500 3,665 4,280 31-5402-1004 SALARIES/WAGES - TEMPORARY 4,200 3,042 .00 .00 31-5402-1005 SALARIES/WAGES - LONGEVITY 879 727 727 668 31-5402-1006 SALARIES & WAGES - ALLOWANCES 300 300 200 300 31-5402-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 4,252 .00 .00 31-5402-1021 EMPLOYEE BENEFITS - SCL 19,101 15,397 11,555 13,995 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS 91,093 75,074 60,586 75,061 31-5402-1025 EMPLOYEE BENEFITS - COMP 6,492 5,233 3,920 5,185 31-5402-1026 EMPLOYEE BENEFITS - COMP .00 .00 .00 .00 31-5402-1029 EMPLOYEE BENEFITS - WY 41,954 33,119 24,138 31,233 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 1,700 1,700 1,183 1,266 31-5402-2122 TRAINING/DEVELOPMENT 2,400 2,450 394 2,225 31-5402-2131 UTILITY SERVICES - ELECTRICITY 17,000 13,500 11,432 16,607 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 30,000 30,000 18,803 27,901 31-5402-2133 UTILITY SERVICES - NATURAL GAS 1,300 1,300 1,678 1,177 31-5402-2134 TELECOMMUNICATIONS 200 350 133 197 31-5402-2141 EQUIPMENT - RENT 400 400 200 .00 31-5402-2153 ARCHITECT/ENGINEERING/SURVEY 2,000 2,000 1,249 1,190 31-5402-2155 REPAIRS/MAINTENANCE 30,000 30,000 16,113 17,483 31-5402-2156 MAINTENANCE AGREEMENT 1,100 1,095 .00 1,095 31-5402-2158 MISC CONTRACTUAL SERVICES 13,000 13,000 12,000 4,000 Budget notes: ~2024 Crushing Asphalt $ 12,000; Misc. $1,000 31-5402-3210 OPERATING SUPPLIES 45,000 40,000 37,278 40,920 31-5402-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 3,500 9,500 7,828 .00 Budget notes: ~2024 Tuff Box Computer $3,500 31-5402-3235 FUEL 7,000 7,000 2,877 4,755 31-5402-4310 LEASE PAYMENTS - OPERATING 350 350 658 313 31-5402-6542 TO BLDG .00 .00 .00 .00 31-5402-6544 OTHER THAN BLDG 200,000 200,000 .00 3,494 Budget notes: ~2024 Sheep Mountain tan liner (rebudget) $200,000 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 57 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 31-5402-6547 EQUIPMENT/FURNITURE 16,450 .00 .00 .00 Budget notes: ~2024 Jackhammer for Backhoe - 50% $10,250; Hydraulic Cooling System (#177) $6,200 31-5402-6548 VEHICLES 31,000 .00 .00 .00 Budget notes: ~2024 Replace Unit# 176 50% Total WATER - DISTRIBUTION/MAINTNCE: 840,339 712,340 385,289 460,650 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 58 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title WATER - CUSTOMER SERVICES 31-5403-1001 SALARIES/WAGES - REGULAR 58,672 50,891 40,222 49,977 31-5403-1005 SALARIES/WAGES - LONGEVITY 569 545 545 521 31-5403-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 3,313 1,781 874 31-5403-1021 EMPLOYEE BENEFITS - SCL 4,532 4,188 3,147 3,778 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS 252 219 184 271 31-5403-1025 EMPLOYEE BENEFITS - COMP 1,540 1,377 1,106 1,459 31-5403-1029 EMPLOYEE BENEFITS - WY 10,092 8,753 6,397 8,596 31-5403-2134 TELECOMMUNICATIONS 200 220 40 208 31-5403-2155 REPAIRS/MAINTENANCE 1,500 1,500 .00 1,437 31-5403-2156 MAINTENANCE AGREEMENT 2,500 2,500 .00 250 31-5403-3210 OPERATING SUPPLIES 2,000 2,000 1,700 1,972 31-5403-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 30,000 25,000 29,122 18,889 31-5403-3235 FUEL 2,000 2,000 340 522 31-5403-6547 EQUIPMENT 15,000 .00 .00 .00 Budget notes: ~2024 Replace Hand Held Total WATER - CUSTOMER SERVICES: 128,857 102,506 84,585 88,754 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 59 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title WATER MAIN REPLACEMENTS 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY 387,000 296,250 102,657 113,207 Budget notes: ~2024 Teton Way $32,000; Clearfield Booster Station $125,000; N 4th Center to Cedar $62,000; Adams St. Richards to Fetterman $100,000; S 2nd St. & 3rd St $68,000 31-5840-6544 OTHER THAN BLDG 2,655,000 1,993,000 501,953 696,435 Budget notes: ~2024 Teton Way $190,000; Clearfield Booster Station (2 year project- Total $1,500,000) $900,000; N 4th St. Center to Cedar $400,000; Adams St. Richards to Fetterman $690,000; 2nd & 3rd $475,000 Total WATER MAIN REPLACEMENTS: 3,042,000 2,289,250 604,610 809,642 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 60 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title LITTLE BOX ELDER SPRING REHAB 31-5855-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 .00 6,139 Total LITTLE BOX ELDER SPRING REHAB: .00 .00 .00 6,139 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 61 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title WATER IMPROVEMENTS 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY 139,000 674,000 258,424 55,556 Budget notes: ~2024 Clearwell cleaning and disinfection (5 year cycle) $8,000; Raw water system design $45,000; Dredging creek below Little Boxelder Spring $16,000; Heating system piping replacement $70,000 31-5856-2158 MISC CONTRACTUAL 25,000 25,000 .00 .00 Budget notes: ~2024 Permitting and ROW acquisition for Sheep Mountain Well #2 pipeline $25,000 31-5856-6544 OTHER THAN BLDG 835,000 75,000 70,000 .00 Budget notes: ~2024 Clearwell cleaning and disinfection (5 year cycle) $75,000; Dredging creek below Little Boxelder Spring $85,000; Heating system piping replacement $675,000 Total WATER IMPROVEMENTS: 999,000 774,000 328,424 55,556 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 62 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SEWER FUND SEWER - REVENUE 32-4320-0160 GAIN ON INVESTMENTS .00 .00 18,476- 89,730- 32-4320-1107 OTHER 1,200 1,000 1,123 1,237 32-4320-1140 INTEREST INCOME 77,000 39,000 56,820 69,565 32-4320-1704 USER CHARGES 1,375,000 1,375,000 986,136 1,325,475 32-4320-1706 SEWER PLANT INVESTMENT FEES 12,500 1,100 11,220 6,600 Budget notes: To replacement reserve 32-4320-1751 SEPTIC WASTE DISP FEES 165,000 150,000 122,400 249,975 Total SEWER - REVENUE: 1,630,700 1,566,100 1,159,224 1,563,123 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 63 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SEWER LINE REPLACEMENTS - REV 32-4852-4288 APRA 1,455,000 .00 .00 .00 32-4852-5513 TRANSFER FROM GENERAL FUND 820,000 .00 .00 .00 Total SEWER LINE REPLACEMENTS - REV: 2,275,000 .00 .00 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 64 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SEWER - ADMINISTRATION 32-5500-1150 DEPRECIATION .00 322,000 241,500 290,000 32-5500-2158 MISC CONTRACTUAL SERVICES 5,000 .00 5,760 6,485 32-5500-4345 INVESTMENT FEES .00 .00 .00 1,357 32-5500-4347 MANAGEMENT FEES 144,891 136,314 102,236 157,174 32-5500-9000 CONTINGENCY 50,000 .00 .00 .00 Total SEWER - ADMINISTRATION: 199,891 458,314 349,496 455,016 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 65 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SEWER - TREATMENT 32-5501-0150 SLUDGE REMOVAL RESERVE .00 85,000 63,750 85,000 Budget notes: ~2024 Removal of sewage sludge in WWTP lagoons, every 5-7 years Removal of sewage sludge in WWTP lagoons, every 5-7 years 32-5501-1001 SALARIES/WAGES - REGULAR 107,068 94,254 72,736 91,042 Budget notes: ~2024 Water/Wastewater Plant Supervisor 50%; Treatment Plant Operator 32-5501-1002 SALARIES/WAGES - OVERTIME 5,000 5,000 2,088 1,980 32-5501-1005 SALARIES/WAGES - LONGEVITY 428 392 392 356 32-5501-1006 SALARIES/WAGES - ALLOWANCES 300 300 200 300 32-5501-1007 SALARIES/WAGES-INCENTIVE/BONUS 858 3,324 .00 .00 32-5501-1021 EMPLOYEE BENEFITS - SCL 8,724 7,993 5,847 7,258 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS 39,064 39,002 25,990 38,975 32-5501-1025 EMPLOYEE BENEFITS - COMP 2,943 2,657 1,961 2,660 32-5501-1026 EMPLOYEE BENEFITS - COMP .00 829 726 813 32-5501-1029 EMPLOYEE BENEFITS - WY 19,276 17,072 12,161 16,000 32-5501-2122 TRAINING/DEVELOPMENT 2,570 2,570 614 169 Budget notes: ~2024 WY Water Quality & Pollution Control conference $520; WY Rural Water conference $600; Ken Keri Study course $200; Misc $1,000; Self Contained Breathing Apparatus Fit test & training $250; Misc. Professional developement 32-5501-2123 MEALS/LODGING/TRAVEL 800 .00 .00 .00 Budget notes: ~2024 Meals, lodging and travel expenses for training-only for out of town/multi-day training 32-5501-2131 UTILITY SERVICES - ELECTRICITY 80,000 80,000 38,401 54,412 Budget notes: ~2024 Utility for Wastewater Treatment Plant 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 75,000 63,000 51,695 71,247 Budget notes: ~2024 Water, Sewer, Sanitation for Wastewater Treatment Plant, and Septic Waste Facility 32-5501-2134 TELECOMMUNICATIONS 1,700 1,700 1,319 1,365 Budget notes: ~2024 Landline service for Wastewater Plant and Middle School lift station alarm dialer ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 66 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 32-5501-2153 ARCHITECT/ENGINEERING/SURVEY 4,500 2,000 .00 2,588 Budget notes: ~2024 Minor surveying, site mapping and misc. engineering services $2,500. Grant applications $2,000 32-5501-2155 REPAIRS/MAINTENANCE 30,000 30,000 14,480 24,318 Budget notes: ~2024 Motors; Pumps; Valves; SCADA control equipment; Blowers; Electrical equipment; Vehicles & Misc other equipment $30,000 32-5501-2158 MISC CONTRACTUAL SERVICES 20,000 10,000 8,171 9,622 Budget notes: ~2024 Laboratory services for water analysis associated with wastewater treatment; Annual maintenance of blower motors; Diagnostics and troubleshooting of process control equipment and SCADA system 32-5501-3210 OPERATING SUPPLIES 40,000 25,000 26,563 29,832 Budget notes: ~2024 Chemicals for wastewater treatment; Misc. small repair parts and supplies; Landfill fees; Misc small hand and power tools; Replacement probes, reagents for laboratory analysis Add to 2024: Safety steel toed boots 1 pair each $200; Misc. PPE 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 12,550 20,500 16,498 .00 Budget notes: ~2024 Chlorine emergency repair kit $4,000; Chemical feed equipment $7,000; Weed trimmer $800; Portable colorimeter $750 32-5501-3235 FUEL 1,200 1,200 368 708 32-5501-6544 OTHER THAN BLDG 49,500 14,000 7,350 12,584 Budget notes: ~2024 Replace blower #1 and #2 motors $30,000; Replace sewage lift pump blower building $4,500; Replace blower room cooling unit $15,000 32-5501-6548 VEHICLES 32,500 20,000 .00 .00 Budget notes: ~2024 Replace unit 180, 2007 Dodge Dakota 50% $32,500-rebudget from last year Total SEWER - TREATMENT: 533,981 525,793 351,309 451,230 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 67 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SEWER - COLLECTION 32-5502-0150 REPLACEMENT RESERVE .00 30,000 22,500 30,000 32-5502-1001 SALARIES/WAGES - REGULAR 223,219 191,325 149,439 181,844 32-5502-1002 SALARIES/WAGES - OVERTIME 4,500 4,500 5,167 6,916 32-5502-1004 SALARIES/WAGES - TEMPORARY 4,200 3,042 .00 .00 32-5502-1005 SALARIES/WAGES - LONGEVITY 2,483 935 935 852 32-5502-1006 SALARIES & WAGES - ALLOWANCES 300 300 200 300 32-5502-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 6,450 .00 .00 32-5502-1021 EMPLOYEE BENEFITS - SCL 17,985 15,831 11,865 14,457 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS 91,036 90,881 60,597 90,859 32-5502-1025 EMPLOYEE BENEFITS - COMP 6,112 5,327 4,049 5,394 32-5502-1029 EMPLOYEE BENEFITS - WY 39,168 33,682 24,934 32,467 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 1,700 1,700 1,183 1,266 32-5502-2122 TRAINING/DEVELOPMENT 1,825 1,825 394 1,040 32-5502-2123 MEALS/LODGING/TRAVEL .00 .00 .00 .00 32-5502-2131 UTILITY SERVICES - ELECTRICITY 12,000 12,000 6,852 9,863 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 350 350 190 284 32-5502-2133 UTILITY SERVICES - NATURAL GAS 2,500 1,800 2,676 2,505 32-5502-2134 TELECOMMUNICATIONS 1,000 715 642 959 32-5502-2153 ARCHITECT/ENGINEERING/SURVEY 2,500 2,500 1,249 960 Budget notes: ~2024 Misc, engineering 32-5502-2155 REPAIRS/MAINTENANCE 15,000 15,000 .00 11,644 32-5502-2158 MISC CONTRACTUAL SERVICES 13,000 13,000 12,000 4,000 32-5502-3210 OPERATING SUPPLIES 35,000 30,000 16,825 20,914 Budget notes: ~2024 Manhole sections; PVC Pipe; Wyes; Saddles; Fernco's; Couplings; Rings; Lids; Concrete; Asphalt; Road base; Sack Crete; Barricades; Safety fencing; Coveralls; Gloves; Antibiotic wipes; Tires; Vactor hose and cleaning heads; Utility billing card stock; Daily operating supplies; Pea rock backfill; Lift station degreaser deodorizer; Root intrusion killing agent: Saftey Equipment 32-5502-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 3,500 .00 .00 .00 Budget notes: ~2024 Tuff Box Computer $3,500 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 68 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 32-5502-3235 FUEL 6,000 7,000 2,877 4,755 32-5502-4310 LEASE PAYMENTS - OPERATING 350 300 .00 285 32-5502-6542 TO BLDG .00 10,000 .00 .00 32-5502-6547 EQUIPMENT/FURNITURE 10,250 .00 .00 .00 Budget notes: ~2024 $10,250.00 50% Jackhammer for Backhoe 32-5502-6548 VEHICLES 31,000 .00 .00 .00 Budget notes: ~2024 Replace Unit #176 50% Total SEWER - COLLECTION: 524,978 478,463 324,572 421,563 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 69 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title WASTEWATER PLANT REHAB 32-5850-2153 ARCHITECT/ENGINEERING/SURVEY 157,000 46,000 33,550 .00 Budget notes: ~2024 Cell bypass rehabilitation and sluice gate replacement $157,000 32-5850-6544 OTHER THAN BLDG 1,046,000 308,000 .00 .00 Budget notes: ~2024 Cell bypass rehabilitation and sluice gate installation $1,046,000 Total WASTEWATER PLANT REHAB: 1,203,000 354,000 33,550 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 70 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SEWER MAIN REPLACEMENTS 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY 410,000 417,500 108,756 179,142 Budget notes: ~2024 S 2nd St & 3rd St. $78,000; Middle School Lift Station( 67% Funded) $300,000; Birch St. Realignment $32,000 32-5852-6544 OTHER THAN BLDG 2,585,000 983,000 418,122 1,263,855 Budget notes: ~2024 S 2nd & 3rd St. $500,000; Middle School Lift Station (67% Funded) $1,900,000; Birch St. Realignment $185,000 Total SEWER MAIN REPLACEMENTS: 2,995,000 1,400,500 526,879 1,442,997 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 71 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SANITATION FUND SANITATION - REVENUE 33-4330-1140 INTEREST INCOME 25,000 7,000 12,359 10,118 33-4330-1704 USER CHARGES 1,385,000 1,375,000 1,041,438 1,319,577 33-4330-1709 SANITATION ACTIVATION FEE 1,250 125 .00 36,300 Budget notes: To replacement reserve Total SANITATION - REVENUE: 1,411,250 1,382,125 1,053,797 1,365,995 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 72 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title SANITATION 33-5600-0150 REPLACEMENT RESERVE .00 50,000 37,500 50,000 33-5600-1001 SALARIES/WAGES - REGULAR 157,271 146,366 120,763 143,609 33-5600-1002 SALARIES/WAGES - OVERTIME 600 600 19 264 33-5600-1005 SALARIES/WAGES - LONGEVITY 978 1,427 1,427 1,367 33-5600-1006 SALARIES/WAGES - ALLOWANCES 300 300 175 300 33-5600-1007 SALARIES/WAGES-INCENTIVE/BONUS 864 9,017 3,253 1,664 33-5600-1021 EMPLOYEE BENEFITS - SCL 12,271 12,237 9,744 11,431 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS 65,016 64,957 42,219 64,945 33-5600-1025 EMPLOYEE BENEFITS - COMP 4,148 3,977 3,267 4,182 33-5600-1026 EMPLOYEE BENEFITS - COMP .00 1,859 1,481 1,824 33-5600-1029 EMPLOYEE BENEFITS - WY 27,154 25,278 17,887 24,746 33-5600-1150 DEPRECIATION 70,000 68,000 51,000 41,000 33-5600-2155 REPAIRS/MAINTENANCE 4,200 4,200 3,105 .00 Budget notes: ~2024 Mas. Valves $700; Lifting Cylinder and Swivel $1,000; Packer Cylinder $2 000; Misc $500 33-5600-2158 MISC CONTRACTUAL SERVICES 1,003,000 1,000,000 576,841 851,023 Budget notes: ~2024 Utility billing mailing service $3,000; Landfill fees $1,000,000 33-5600-3210 OPERATING SUPPLIES 30,000 27,000 21,016 54,490 Budget notes: ~2024 Cost of cleaning chemicals; Paint for dumpsters; Other misc parts & materials; Tires and supplies to keep the trucks & equipment in good condition; Signs; Misc recycling operating supplies; Dumpster signs; Safety equipment; Utility billing card stock; Repair parts for Safety equipment Boots, gloves ext. $1000 New note- Raise by $2,000 for cost of new dumpsters. 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 30,000 29,700 26,980 50,458 Budget notes: ~2024 Dumpsters $30,000 33-5600-3235 FUEL 22,000 22,000 6,682 11,301 33-5600-4347 MANAGEMENT FEES 145,945 104,857 78,643 82,019 33-5600-6548 VEHICLES .00 .00 .00 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 73 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 33-5600-9000 CONTINGENCY 25,000 .00 .00 .00 Total SANITATION: 1,598,747 1,571,775 1,002,000 1,394,624 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 74 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title LANDFILL FUND LANDFILL - REVENUE 34-4340-1107 OTHER .00 .00 935 10,315 34-4340-1140 INTEREST INCOME 62,000 25,000 31,664 30,166 34-4340-1704 USER CHARGES 1,000,000 1,000,000 740,264 1,128,448 Total LANDFILL - REVENUE: 1,062,000 1,025,000 772,863 1,168,929 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 75 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title LANDFILL 34-5340-1001 SALARIES/WAGES - REGULAR 248,273 212,413 170,034 205,853 Budget notes: ~2024 Supervisor; Landfill Operator-2; Landfill Attendant-Part time-2 34-5340-1002 SALARIES/WAGES - OVERTIME 1,500 1,500 474 597 34-5340-1005 SALARIES/WAGES - LONGEVITY 1,230 1,747 1,747 1,550 34-5340-1006 SALARIES/WAGES - ALLOWANCES 600 600 400 600 34-5340-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 7,537 923 607 34-5340-1021 EMPLOYEE BENEFITS - SCL 20,056 17,849 13,822 16,708 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS 78,031 77,888 49,774 77,872 34-5340-1025 EMPLOYEE BENEFITS - COMP 6,562 5,817 4,513 5,942 34-5340-1026 EMPLOYEE BENEFITS - COMP 9,785 8,739 6,803 8,809 34-5340-1029 EMPLOYEE BENEFITS - WY 33,176 28,054 19,929 26,655 34-5340-1150 DEPRECIATION 140,000 65,000 48,750 155,000 34-5340-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 250 .00 .00 34-5340-2122 TRAINING/DEVELOPMENT 800 800 700 .00 Budget notes: ~2024 WY Solid Waste & Recycling conference 34-5340-2123 MEALS/LODGING/TRAVEL 1,000 1,000 270 .00 34-5340-2131 UTILITY SERVICES - ELECTRICITY 10,000 9,000 4,489 7,195 34-5340-2133 UTILITY SERVICES - NATURAL GAS 11,500 9,000 10,468 9,428 34-5340-2134 TELECOMMUNICATIONS 250 250 .00 5 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY 1,000 1,000 .00 .00 34-5340-2155 REPAIRS/MAINTENANCE 15,000 15,000 2,683 14,834 34-5340-2156 MAINTENANCE AGREEMENT 11,500 9,000 4,059 4,405 Budget notes: ~2024 Cost to test and calibrate scales--5000. Paradigm--5000. Waste oil heater--1500. 34-5340-2158 MISC CONTRACTUAL SERVICES 510,000 465,000 280,329 375,956 Budget notes: ~2024 Landfill fees-$320,000- increase of $5 per ton Jan 2024 Wood grinding-$50,000 Contract hauling-$130,000- due to new contract and fuel surcharge Crush asphalt-$10,000 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 76 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title 34-5340-2166 COLLECTION FEES 300 300 .00 21 34-5340-3210 OPERATING SUPPLIES 50,000 40,000 28,284 32,907 Budget notes: ~2024 Safety equipment ( boots, gloves, vests, eyeware) $2,000; Signs, Paint, Tools, Welding supplies, Bottled water, Additives for fuel, Equipment & building cleaning materials, Safety equipment & supplies, Grass seed, Gravel, Parts, tires & supplies for vehicle & equipment, Cutting edges, Repair parts for dozer & scraper & misc $30,000 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 20,000 2,500 50 1,270 Budget notes: ~2024 Dumpsters-- 20,000. 34-5340-3235 FUEL 25,000 20,000 11,952 23,749 34-5340-4343 DEBT PAYMENT - PRINCIPAL 13,141 13,141 13,141 13,141 34-5340-4347 MANAGEMENT FEES 105,375 104,857 78,643 114,723 34-5340-6547 EQUIPMENT/FURNITURE 10,500 .00 .00 .00 Budget notes: ~2024 Desk $1,000;Air compressor$4,500; Tool box $5,000 34-5340-9000 CONTINGENCY 550,000 .00 .00 .00 Budget notes: ~2024 General $50,000; Pave road $500,000 Total LANDFILL: 1,874,579 1,118,242 752,235 1,097,829 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 77 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title LANDFILL - CAPITAL 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY 40,000 50,000 13,537 29,085 34-5895-2158 MISC CONTRACTUAL SERVICES .00 .00 14,000 .00 34-5895-6542 BUILDINGS/IMPROVEMENTS 50,000 .00 .00 .00 Budget notes: ~2024 Replacing the overhead door openers an all doors $50,000 34-5895-6544 OTHER THAN BLDG .00 200,000 .00 .00 Budget notes: ~2024 Pave roads $500,000 34-5895-6547 EQUIPMENT/FURNITURE 81,500 .00 .00 13,191 Budget notes: ~2024 Angle blade for loader $24,000; Ready line $7,500; Water tanker $50,000 Total LANDFILL - CAPITAL: 171,500 250,000 27,537 42,276 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 78 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title EMPLOYEE HEALTH CARE FUND EMPLOYEE HEALTH CARE - REVENUE 39-4390-0110 STOP LOSS REIMBURSEMENTS 100,000 50,000 274,697 208,649 39-4390-0111 INSURANCE PREMIUMS 553,900 375,000 365,483 501,310 39-4390-0112 INSURANCE ASSESSMENTS 1,000,000 1,100,000 590,105 902,990 39-4390-0113 COBRA PAYMENTS .00 .00 .00 777 39-4390-1140 INTEREST INCOME 22,000 5,500 12,061 8,799 39-4390-5510 TRANSFER FROM GENERAL FUND .00 .00 75,000 100,000 Total EMPLOYEE HEALTH CARE - REVENUE: 1,675,900 1,530,500 1,317,345 1,722,525 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 79 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title EMPLOYEE HEALTH CARE 39-5390-0150 REPLACEMENT RESERVE .00 100,000 75,000 100,000 39-5390-1023 EMPLOYEE - HLTH INS PREM 459,600 275,000 344,758 415,158 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 1,000,000 1,100,000 1,123,298 1,372,852 39-5390-1058 HEALTH CARE - FEE 94,300 100,000 70,679 90,265 Total EMPLOYEE HEALTH CARE: 1,553,900 1,575,000 1,613,735 1,978,275 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 80 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title CAPITAL IMP RESERVE FUND CAPITAL IMP RESERVE - REVENUE 40-4400-1140 INTEREST INCOME 10,475 2,900 5,120 5,065 Total CAPITAL IMP RESERVE - REVENUE: 10,475 2,900 5,120 5,065 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 81 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title ECONOMIC DEVELOPMENT ECONOMIC DEVELOPMENT 41-4410-1140 INTEREST INCOME 7,785 1,900 4,385 3,973 41-4410-5510 TRANSFER FROM GENERAL FUND 1,875,000 50,000 37,500 .00 Total ECONOMIC DEVELOPMENT: 1,882,785 51,900 41,885 3,973 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 82 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title ECONOMIC DEVELOPMENT 41-5410-2115 PUBLISHING/ADVERTISING 10,000 .00 .00 .00 Budget notes: ~2024 Marketing plan (PSE-04) $10,000 41-5410-2122 TRAINING/DEVELOPMENT 75,000 .00 .00 .00 Budget notes: ~2024 Economic networking & management activities (PSE-02) $75,000 41-5410-2158 MISC CONTRACTUAL SERVICES 55,000 50,000 .00 8,541 Budget notes: ~2024 Identify community wants/needs (PSE-03) $25,000; Facade (UPI-01) $30,000 41-5410-3210 OPERATING SUPPLIES 500 .00 .00 .00 Budget notes: ~2024 Recording replat (PSE-13) $250; Mechanism to obtain properties (PSE-08) $250 41-5410-9000 CONTINGENCY 1,675,000 .00 .00 .00 Budget notes: ~2024 Incentive program business development (PSE-05) $100,000; Incenitvize expansion local businesses (PSE-06) $50,000; Recruit new companies (PSE-07) $25,000; Business property or developable land (PSE-10) $500,000; Land bank (PSE-11) $300,000; Facilitate Development (UPI-04) $750,000 Total ECONOMIC DEVELOPMENT: 1,815,500 50,000 .00 8,541 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 83 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title BROWNFIELD GRANT BROWNFIELD HAZARDOUS - REVENUE 42-4870-4281 EPA 6,032 34,680 20,787 41,276 Total BROWNFIELD HAZARDOUS - REVENUE: 6,032 34,680 20,787 41,276 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 84 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title BROWNFIELD PETROLEUM - REVENUE 42-4871-4281 EPA 4,145 42,005 11,152 23,238 Total BROWNFIELD PETROLEUM - REVENUE: 4,145 42,005 11,152 23,238 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 85 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title NEW FRONTIER INITIATIV 42-4872-4281 EPA 1,000,000 .00 .00 .00 Total NEW FRONTIER INITIATIV: 1,000,000 .00 .00 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 86 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title BROWNFIELD HAZARDOUS 42-5870-2123 MEALS/LODGING/TRAVEL 1,108 1,968 1,042 .00 42-5870-2158 MISC CONTRACTUAL SERVICES 4,925 32,712 3,243 41,276 Total BROWNFIELD HAZARDOUS: 6,032 34,680 4,285 41,276 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 87 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title BROWNFIELD PETROLEUM 42-5871-2123 MEALS/LODGING/TRAVEL 1,108 1,968 1,042 .00 42-5871-2158 MISC CONTRACTUAL SERVICES 3,037 40,037 25,294 23,238 Total BROWNFIELD PETROLEUM: 4,145 42,005 26,336 23,238 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 88 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title NEW FRONTIER INITIATIV 42-5872-2158 MISC CONTRACTUAL SERVICES 1,000,000 .00 .00 .00 Total NEW FRONTIER INITIATIV: 1,000,000 .00 .00 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 89 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title GENERAL FUND EQUIPMENT RESERVE GENERAL FUND EQUIP RES-REVENUE 47-4470-1140 INTEREST INCOME .00 1,000 40 1,912 47-4470-5510 TRANSFER FROM GENERAL FUND 500,000 300,000 225,000 .00 47-4470-5511 TRANSFER FROM IMPACT ASSISTANC 36,559 .00 .00 .00 Total GENERAL FUND EQUIP RES-REVENUE: 536,559 301,000 225,040 1,912 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 90 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title GENERAL FUND EQUIPMENT RESERVE 47-5470-6547 EQUIPMENT/FURNITURE 250,807 167,296 136,918 166,728 Budget notes: ~2024 Spayer-airless-walk behind $7,500; Electronic message board $100,000; Asphalt Grinder attachment for the skid steer $16,000; Community Club: Irrigation software/satellite upgrade $22,000; Golf equipment lift $10,000; Topdresser $20,000; Upfit patrol cars $97,307 47-5470-6548 VEHICLES 436,263 193,642 145,601 .00 Budget notes: ~2024 Patrol Car (#221, 222 & 236& rebudget) $188,263; Parks Pickup #10 $45,000; Day Cab Truck/tractor For Dump Trailer $90,000; Planning Car#102 $35,000 Total GENERAL FUND EQUIPMENT RESERVE: 687,070 360,938 282,519 166,728 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 91 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title CAPITAL PROJ FIRE EQUIP FUND FIRE EQUIPMENT - REVENUE 50-4500-1140 INTEREST INCOME 5,500 1,550 5,744 1,578 50-4500-5510 TRANSFER FROM GENERAL FUND 250,000 250,000 187,500 100,000 Total FIRE EQUIPMENT - REVENUE: 255,500 251,550 193,244 101,578 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 92 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title FIRE EQUIPMENT 50-5500-6548 BUILDINGS 250,000 250,000 .00 .00 Total FIRE EQUIPMENT: 250,000 250,000 .00 .00 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 93 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title CPTL PROJ - CLG PROJECTS HISTORIC DISTRICT - REVENUE 53-4809-3973 CERTIFIED LOCAL GOVERNMENT .00 3,990 2,460 1,740 53-4809-5510 TRANSFER FROM GENERAL FUND .00 3,010 2,258 4,300 Total HISTORIC DISTRICT - REVENUE: .00 7,000 4,718 6,040 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 94 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title HISTORIC DISTRICT 53-5809-2158 MISC CONTRACTUAL SERVICES .00 7,000 4,000 3,000 Total HISTORIC DISTRICT: .00 7,000 4,000 3,000 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 95 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title TRAIN CAR RESTORATION TRAIN CAR RESTORATION 54-4540-5510 TRANSFER FROM GENERAL FUND 25,000 35,000 26,250 25,000 Total TRAIN CAR RESTORATION: 25,000 35,000 26,250 25,000 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 96 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title TRAIN CAR RESTORATION 54-5540-2155 REPAIRS/MAINTENANCE 40,000 35,000 .00 25,860 Budget notes: ~2024 Caboose and day car Painting and repairs $30,000. Misc. $5,000. Painting light poles $5,000 Total TRAIN CAR RESTORATION: 40,000 35,000 .00 25,860 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 97 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title POOL IMPROVEMENTS FUND POOL IMPROVEMENTS - REVENUE 55-4550-1140 INTEREST INCOME .00 3,400 3,899 4,961 55-4550-5510 TRANSFER FROM GENERAL FUND 250,000 195,000 146,250 162,500 Total POOL IMPROVEMENTS - REVENUE: 250,000 198,400 150,149 167,461 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 98 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title POOL IMPROVEMENTS 55-5550-2153 ARCHITECT/ENGINEERING/SURVEY 50,000 10,000 1,530 .00 Budget notes: ~2024 Pool renovations $35,000 Pool upgrades $15,000 55-5550-6544 OTHER THAN BLDG 200,000 185,000 .00 148,734 Budget notes: ~2024 Replace main pool boiler $50,000; Pool renovations $150,000 55-5550-9000 CONTINGENCY 250,000 .00 .00 .00 Budget notes: ~2024 Kiddie pool & small slide $250,000 Total POOL IMPROVEMENTS: 500,000 195,000 1,530 148,734 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 99 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title STREET IMPROVEMENT FUND STREET IMPROVEMENTS-REVENUE 56-4560-1140 INTEREST INCOME 360,000 76,600 118,807 128,978 56-4560-5510 TRANSFER FROM GENERAL FUND .00 3,000,000 2,250,000 5,900,000 56-4560-5511 TRANSFER FROM IMPACT ASSISTANC 1,545,110 .00 .00 .00 Total STREET IMPROVEMENTS-REVENUE: 1,905,110 3,076,600 2,368,807 6,028,978 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 100 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title STREET IMPROVEMENTS 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY 879,500 603,250 174,892 247,459 Budget notes: ~2024 N. 4th - $354,000; Richards St. Sidewalk (TAP Grant) $200,000; Adams. S. 2nd & S.3rd St. - $187,000; Teton Way - $75,000; Mobility hazards (WCC-03) $10,000; Design streetscape (UPI-05) $50,000; Sidewalks (WCC-06) $1,000; Pedistrian lighting (WCC-04) $2,500 56-5560-2158 MISC CONTRACTUAL SERVICES 70,000 60,000 22,810 48,365 Budget notes: ~2024 Sidewalk - regular & rehab (WCC-06) $35,000; Install street pans $35,000 56-5560-6540 LAND .00 .00 .00 40,814 56-5560-6544 OTHER THAN BLDG 5,861,500 5,049,500 1,237,731 2,161,822 Budget notes: ~2024 N. 4th Center to Antelope Bridge $2,450,000; Richards St. sidewalk from 5th to Mesa (tap grant) $1,200,000; Adams St mill and overlay $1,000,000; Slurry seal - $250,000; Parking lot (depot) $640,000; Birch - $200,000; Sidewalks (WCC-06) $9,000; Pedistrian lighting (WCC-04) $22,500; Mobility hazards (WCC-03) $90,000 56-5560-6547 EQUIPMENT/FURNITURE 20,000 .00 .00 .00 Budget notes: ~2024 Mobile message board $20,000 56-5560-9000 CONTINGENCY .00 .00 .00 .00 Total STREET IMPROVEMENTS: 6,831,000 5,712,750 1,435,434 2,498,460 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 101 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title CAPITAL IMP -PUBLIC FACILITIES CAPITAL IMP - FACILITIES REV 57-4570-1140 INTEREST INCOME 31,500 25,200 22,297 28,703 57-4570-5510 TRANSFER FROM GENERAL FUND .00 .00 .00 218,000 Total CAPITAL IMP - FACILITIES REV: 31,500 25,200 22,297 246,703 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 102 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title CAPITAL IMP -FACILITIES 57-5570-2153 ARCHITECT/ENGINEERING/SURVEY 70,000 .00 .00 .00 Budget notes: ~2024 Salt sand building-$20,000; Water/sewer John Lampert subdivison tie in $50,000 57-5570-6542 BUILDINGS/IMPROVEMENTS 297,700 210,000 32,055 .00 Budget notes: ~2024 Replace electric service to the Annexx building, $28,000; Remove Fuel Tanks - $20,000; Change the Annex electric service to $31,000; Old City Hall Misc. $10,000; City Hall facade (FUN-05) $200,000; Windows - Helping Hands $8,700 57-5570-6544 OTHER THAN BLDG 420,000 .00 143,915- 185,331 Budget notes: ~2024 Asphalt sand storage lot-$20,000; 30'x40' Salt Sand Building $ 200,000; City Hall xeriscape (PNPR-04) $200,000 57-5570-6547 EQUIPMENT/FURNITURE 100,000 .00 .00 .00 Budget notes: ~2024 Electronic messaging signs(EIN-02) $100,000 57-5570-9000 CONTINGENCY 650,000 .00 .00 .00 Budget notes: ~2024 Extension to John Lampert $650,000 Total CAPITAL IMP -FACILITIES: 1,537,700 210,000 111,860- 185,331 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 103 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title CAPTL PROJ-PARK FUND PARK - REVE 65-4650-0160 GAIN ON INVESTMENTS .00 .00 6,159- 29,965- 65-4650-1140 INTEREST INCOME 72,500 19,000 24,472 26,657 65-4650-3370 WY BUSINESS COUNCIL .00 .00 .00 11,000 65-4650-5510 TRANSFER FROM GENERAL FUND .00 860,000 645,000 291,342 Total PARK - REVE: 72,500 879,000 663,314 299,034 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 104 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PARK IMPROVEMENTS 65-5650-2153 ARCHITECT, ENG, SURVEY 77,000 131,750 44,870 15,000 Budget notes: ~2024 Misc $10,000 Heritage Trail - Keith Rider Park $30,000 Fishing platforms construction Phase 1 $17,000 Interactive feature (UPI-06) $20,000 65-5650-4345 INVESTMENT FEES 500 500 .00 452 65-5650-6542 BUILDINGS/IMPROVEMENTS 18,800 11,500 9,088 .00 Budget notes: ~2024 Cemetery shop lights $5,000 Replace gutters on Cemetery office. $3000 Programable door locks for restrooms - 12 at $900 - $10,800 65-5650-6544 OTHER THAN BLDG 876,000 730,500 48,323 173,247 Budget notes: ~2024 Parks: Bike path trees $50,000; Renovate tennis court -Keith Rider $40,000; Community Club: Extend/Repair cart paths $30,000; Extension- Heritage Trail- Keith Rider Park $150,000; Construction of fishing platforms Phase 1 $211,000; DCC: Greens covers $10,000, Level tee boxes $25,000 ; Replace Preakness (middle) Shelter Washington park $85,000; Parks and pathways concrete replacement/ repair $35,000; Benches and trash containers, pickle ball ct., lower KR pond, Bartling, Interpretive center $10,000; Interactive feature (UPI-06) $180,000; Xeriscape Jackalope park (PNPR-04) $50,000 65-5650-9000 CONTINGENCY 350,000 .00 .00 .00 Budget notes: ~2024 Riverside Park irrigation replacement and path lighting $350,000 Total PARK IMPROVEMENTS: 1,322,300 874,250 102,281 188,699 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 105 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PERPETUAL CARE FUND PERPETUAL CARE - REVENUE 90-4900-0156 PROCEEDS FROM LOT SALES 3,000 3,000 3,250 3,875 90-4900-1140 INTEREST INCOME 4,000 750 3,266 1,659 Total PERPETUAL CARE - REVENUE: 7,000 3,750 6,516 5,534 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 106 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title PERPETUAL CARE 90-5900-5510 TRANSFER TO GENERAL FUND 4,000 750 3,266 1,659 Total PERPETUAL CARE: 4,000 750 3,266 1,659 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 107 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title HISTORIC CMSN FUND HISTORIC CMSN - REVENU 92-4920-5510 TRANSFER FROM GENERAL FUND 1,800 3,650 2,738 3,800 Total HISTORIC CMSN - REVENU: 1,800 3,650 2,738 3,800 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 108 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title HISTORIC PRESERVATION 92-5920-2158 MISC CONTRACTUAL SERVICES 1,800 3,650 .00 276 Budget notes: ~2024 Training: National Alliance of Preservation Commissions Registration ($500), General Other (online, local) ($500) $1,000.00; Headset Microphones X10 @ $30 each $300.00; Pioneer Cemetery/Childs Trail Improvements $500.00 Total HISTORIC PRESERVATION 1,800 3,650 .00 276 ---PAGE BREAK--- CITY OF DOUGLAS Budget Worksheet - 2024 Approval Page: 109 Periods: 07/22-03/23 Jun 01, 2023 06:33PM FY 24 FY 23 FY 23 YTD FY 22 Budget Budget Actual - Mar Actual Account Number Account Title UTILITY DEPOSIT FUND UTILITY DEPOSITS - REVENUE 96-4960-1140 INTEREST INCOME .00 .00 1,449 1,780 Total UTILITY DEPOSITS - REVENUE: .00 .00 1,449 1,780