Full Text
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