RecordWell Data

2022 Budget

City of Westminster · Oconee County · meeting of Sep 21, 2023 · Budget documents

Open the original document More from City of Westminster

Text

Extracted automatically from the original. Tables and formatting may not survive; the original document is authoritative.

Gateway to the Mountain Lakes Region City of Westminster Budget FY2022 Summary of All funds Gateway to the Mountain Lakes Region Transfer Summary • $496,296 Utility Fund Transfer to General Fund (6.6% gross revenue transfer) • $154,314 General Fund Transfer to Youth Recreation • $76,487 General Fund Transfer to Solid Waste • $62,600 Htax Transfer to General Fund • $111,621 Htax Transfer to Youth Recreation Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 1 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual REVENUES 100 ADMINISTRATION 00400 PROPERTY TAXES 40000 PROPERTY TAXES 496,872 459,122 475,372 475,000 475,000 480,500 1.16 40001 DELIQUENT TAXES 30,000 22,495 31,973 30,000 30,000 32,000 6.67 40002 VEHICLE TAXES 65,000 69,674 61,713 65,000 65,000 68,000 4.62 40003 HOMESTEAD EXPT. STATE 54,000 53,801 54,339 54,000 54,000 54,000 0.00 40004 MERCHANTS INVT. TAX 6,300 6,323 6,323 6,300 6,300 6,300 0.00 40005 WATERCRAFT TAX 0 0 588 0 0 800 0.00 00400 TOTAL PROPERTY TAXES 611,415 652,172 630,308 630,300 630,300 641,600 1.79 00401 INTERGOVENMENTAL REV 40102 AID TO SUBDIVISION 56,000 59,435 45,103 56,000 56,000 56,000 0.00 40103 STATE ACCOM. TAX 4,000 0 3,746 4,000 4,000 4,000 0.00 40105 TRANSPORTATION NETWORK ACT 0 4 19,460 0 0 0 0.00 00401 TOTAL INTERGOVENMENTAL REV 59,439 60,000 68,309 60,000 60,000 60,000 0.00 00402 LICENSE, PERMITS, & FEES 40200 BUSINESS LICENSE 70,000 87,115 93,430 81,182 70,000 81,182 0.00 40202 TELECOM. TAX MASC 6,500 5,688 7,404 6,500 6,500 6,500 0.00 40203 BROKER TAX MASC 4,500 4,053 4,151 5,000 5,000 5,000 0.00 40205 INSURANCE TAX 180,000 22,373 48,536 210,000 210,000 210,000 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 2 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 40214 CELL TOWER RENT 26,700 26,200 24,475 26,700 26,700 26,700 0.00 40215 FACILITY RENTAL 6,000 6,605 7,912 6,330 6,000 6,330 0.00 40216 FOIA REQUEST FEES 0 143 20 30 30 30 0.00 00402 TOTAL LICENSE, PERMITS, & FEES 152,177 293,700 185,928 335,742 324,230 335,742 0.00 00404 PYMT IN LIEU OF TAX & FRAN FEE 40400 PAYMENT IN LIEU OF TAX 3,500 1,780 1,639 3,500 3,500 3,500 0.00 40401 FRANCHISE FEES 56,000 55,441 44,934 55,000 50,000 55,000 0.00 40402 WUD FRANCISE FEE 432,927 432,927 412,588 495,106 329,632 496,296 0.24 00404 TOTAL PYMT IN LIEU OF TAX & FRAN FEE 490,148 492,427 459,161 553,606 383,132 554,796 0.21 00405 INTEREST INCOME 40500 INTEREST INCOME 1,000 0 262 1,000 1,000 1,000 0.00 00405 TOTAL INTEREST INCOME 0 1,000 262 1,000 1,000 1,000 0.00 00406 GRANT INCOME 40602 STATE GRANTS 125,000 125,000 86,179 0 0 0 0.00 ** Generator grant (other half of rev from grant in 20 fund) ** 00406 TOTAL GRANT INCOME 125,000 125,000 86,179 0 0 0 0.00 00407 MISCELLANEOUS & OTHER 40700 SERVICE CHARGES 60 0 0 60 60 60 0.00 40701 PROCEEDS FROM BORROWING 0 0 0 0 0 0 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 3 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 40703 SALE OF EQUIP/MATERIAL/SCRAP 25 0 0 25 25 25 0.00 40707 MISCELLANEOUS REV 16,600 112 0 10,000 10,000 10,000 0.00 40708 INTERFUND TRANSFER 0 0 0 0 0 0 0.00 40734 COURT ORDERED RESTITUTION 2,000 2,050 720 2,000 2,000 2,000 0.00 40735 INSURANCE PAID CLAIMS 1,516 1,516 1,717 0 0 0 0.00 40736 GHS FACILITY REIMBURSEMENT 4,200 4,200 3,500 4,200 4,200 4,200 0.00 40737 REFUNDS/REIMBURSEMENTS 8,226 23,869 16,310 1,000 1,000 10,000 900.00 00407 TOTAL MISCELLANEOUS & OTHER 31,747 32,627 22,247 17,285 17,285 26,285 52.07 100 TOTAL ADMINISTRATION 1,469,926 1,656,926 1,452,394 1,597,933 1,415,947 1,619,423 1.34 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 4 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 200 FIRE DEPARTMENT 00401 INTERGOVENMENTAL REV 40101 COUNTY ALLOCATION 285,000 285,000 285,000 285,000 0 285,000 0.00 00401 TOTAL INTERGOVENMENTAL REV 285,000 285,000 285,000 285,000 0 285,000 0.00 00405 INTEREST INCOME 40500 INTEREST INCOME 200 215 99 200 0 200 0.00 00405 TOTAL INTEREST INCOME 215 200 99 200 0 200 0.00 00407 MISCELLANEOUS & OTHER 40707 MISCELLANEOUS REV 0 0 5 0 0 0 0.00 40716 FIRE PREVENTION 350 0 0 300 0 0 (100.00) 40737 REFUNDS/REIMBURSEMENTS 0 0 1,372 0 0 1,000 0.00 00407 TOTAL MISCELLANEOUS & OTHER 0 350 1,377 300 0 1,000 233.33 200 TOTAL FIRE DEPARTMENT 285,215 285,550 286,476 285,500 0 286,200 0.25 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 5 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 300 POLICE 00403 FINES & FORFEITURES 40300 POLICE FINES 35,000 25,303 21,257 30,000 0 31,000 3.33 40302 DRUG SEIZURES 13,000 0 0 13,000 0 0 (100.00) 00403 TOTAL FINES & FORFEITURES 25,303 48,000 21,257 43,000 0 31,000 (27.91) 00405 INTEREST INCOME 40500 INTEREST INCOME 3 9 7 3 0 0 (100.00) 00405 TOTAL INTEREST INCOME 9 3 7 3 0 0 (100.00) 00407 MISCELLANEOUS & OTHER 40704 POLICE FUND 1,200 1,470 7,162 1,500 0 2,000 33.33 00407 TOTAL MISCELLANEOUS & OTHER 1,470 1,200 7,162 1,500 0 2,000 33.33 300 TOTAL POLICE 26,782 49,203 28,426 44,503 0 33,000 (25.85) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 6 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 500 CODES 00402 LICENSE, PERMITS, & FEES 40211 SIGN PERMIT FEES 0 250 20 200 200 200 0.00 40212 ZONING HEARINGS 75 150 330 150 150 150 0.00 00402 TOTAL LICENSE, PERMITS, & FEES 400 75 350 350 350 350 0.00 500 TOTAL CODES 400 75 350 350 350 350 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 7 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 700 NON DEPARTMENTAL 00407 MISCELLANEOUS & OTHER 40730 HTAX TRANSFER 61,000 16,000 50,000 106,000 106,000 62,600 (40.94) 00407 TOTAL MISCELLANEOUS & OTHER 16,000 61,000 50,000 106,000 106,000 62,600 (40.94) 700 TOTAL NON DEPARTMENTAL 16,000 61,000 50,000 106,000 106,000 62,600 (40.94) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 8 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual TOTAL REVENUES 1,798,323 2,052,754 1,817,646 2,034,286 1,522,297 2,001,573 (1.61) EXPENDITURES 100 ADMINISTRATION 00100 PERSONAL SERVICES 05100 SALARIES 91,990 91,907 92,047 93,827 92,432 96,257 2.59 05102 MAYOR/COUNCIL SALARIES 14,300 14,300 14,300 14,300 14,300 14,300 0.00 05103 ANNUAL BONUS 1,500 0 1,470 1,590 1,560 1,560 (1.89) 05104 SOCIAL SECURITY 7,038 7,947 8,164 7,177 7,071 7,364 2.61 05105 RETIREMENT CONTRIBUTIONS 14,314 15,658 15,584 14,600 14,383 14,978 2.59 05106 HEALTH INSURANCE CONTRIBUTIONS 10,401 18,828 11,307 10,401 6,095 9,095 (12.56) 05107 WORKERS COMPENSATION 2,000 2,000 2,000 2,000 2,000 2,000 0.00 05108 EMPLOYEE BONDING 5,000 3,750 3,750 5,000 5,000 5,000 0.00 05112 UNEMPLOYEMENT INSURANCE REIMBU 250 0 154 0 0 0 0.00 05114 VEHICLE ALLOWANCE 2,500 1,923 2,508 2,500 2,500 4,200 68.00 00100 TOTAL PERSONAL SERVICES 156,313 149,293 151,284 151,395 145,341 154,754 2.22 00200 COMMODITIES 05200 POSTAGE 1,800 1,055 1,051 1,200 1,200 1,200 0.00 05202 OFFICE SUPPLIES 6,700 5,755 5,093 4,500 4,500 4,500 0.00 05209 JANITORIAL SUPPLIES 350 350 16 350 350 350 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 9 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05210 MISCELLANEOUS 2,400 2,313 1,988 2,400 2,400 2,400 0.00 05211 SERVICE FEES 2,700 2,527 2,570 2,000 2,000 2,000 0.00 05212 EQUIPMENT PURCHASED 0 0 3,057 3,000 3,000 3,000 0.00 05214 PRINTING 200 0 0 200 200 200 0.00 05215 BUILDING MAINT. 1,400 1,196 321 500 500 500 0.00 00200 TOTAL COMMODITIES 13,196 15,550 14,096 14,150 14,150 14,150 0.00 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 1,300 799 559 1,000 1,000 1,000 0.00 05301 TELEPHONES 3,000 2,807 1,987 3,000 3,000 3,000 0.00 05302 TRAVEL AND TRAINING 9,200 5,009 676 9,200 9,200 9,200 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 7,000 6,621 2,836 4,000 4,000 7,000 75.00 05306 ADVERTISING 1,000 502 582 1,000 1,000 1,000 0.00 05308 OFFICE EQUIP/RENTAL/LEASE 1,500 1,141 1,491 1,100 1,100 1,100 0.00 05310 MISCELLANEOUS 7,000 10,330 6,716 3,000 3,000 3,000 0.00 05313 UTILITIES PURCH FROM WUD 9,000 8,854 7,352 9,000 9,000 9,000 0.00 05319 PROFESSIONAL SERVICES 25,000 22,065 23,000 25,000 25,000 19,500 (22.00) 05320 MEDICAL PROFESS. SERVICES 100 0 48 100 100 100 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 10 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05321 COMPUTER MAINTENANCE 5,000 4,292 3,644 5,000 5,000 5,000 0.00 05323 VEHICLE & PROPERTY INSURANCE 62,000 72,241 0 62,000 62,000 62,000 0.00 05328 CUSTOMER REFUNDS 250 350 418 250 250 250 0.00 05336 SC SALES TAX 400 0 165 400 400 400 0.00 05352 JANITORIAL EXPENSE 1,200 1,223 1,085 1,200 1,200 1,200 0.00 05358 EQUIPMENT REPAIR & MAINT. 100 0 0 100 100 100 0.00 05362 MUNICIPAL COURT 21,000 19,860 17,037 21,000 21,000 21,000 0.00 05365 CONTRACTUAL SERVICES 37,000 38,154 23,128 32,000 32,000 55,750 74.22 ** SERVER UPGRADES $10,000, SECURITY CAMERA'S $3750 ** 05368 INTERFUND TRANSFER 0 0 83,679 0 0 0 0.00 05372 ELECTION EXPENSE 1,920 1,920 0 1,000 1,000 1,000 0.00 05378 PRINTING 500 0 0 500 500 500 0.00 05379 LEGAL SERVICES 30,000 12,670 18,753 30,000 30,000 45,000 50.00 ** ADDITIONAL LEGAL FEES ** 05383 PUBLIC RELATIONS/PROMOTIONS 2,000 0 433 2,000 2,000 0 (100.00) 05387 HALL ST PROPERTY PURCHASE 0 0 0 40,000 40,000 0 (100.00) 00300 TOTAL CONTRACTUAL SERVICES 208,838 225,470 193,589 251,850 251,850 246,100 (2.28) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 11 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 100 TOTAL ADMINISTRATION 378,347 390,313 358,969 417,395 411,341 415,004 (0.57) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 12 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 200 FIRE DEPARTMENT 00100 PERSONAL SERVICES 05100 SALARIES 187,664 201,505 151,153 195,969 196,478 191,171 (2.45) ** Vacant position budgeted for 9months ** 05101 OVERTIME 16,000 15,222 12,468 16,000 16,000 16,000 0.00 05103 ANNUAL BONUS 1,510 1,000 1,410 1,440 1,470 1,470 2.08 05104 SOCIAL SECURITY 16,248 16,778 12,903 15,956 16,066 15,680 (1.73) 05105 RETIREMENT CONTRIBUTIONS 38,739 40,958 31,558 38,050 38,306 37,386 (1.75) 05106 HEALTH INSURANCE CONTRIBUTIONS 48,972 22,829 16,221 21,154 32,174 32,174 52.09 05107 WORKERS COMPENSATION 25,000 19,000 16,126 25,000 25,000 25,000 0.00 05109 PART TIME EMPLOYEES 24,720 8,303 9,397 12,608 13,520 18,000 42.77 ** 1st place to look to balance if needed ** 05110 VOLUNTEER FIREFIGHTERS BONUS 6,000 6,000 0 6,000 6,000 6,000 0.00 00100 TOTAL PERSONAL SERVICES 331,595 364,853 251,236 332,177 345,014 342,881 3.22 00200 COMMODITIES 05201 FUEL 10,000 5,978 3,995 10,237 10,000 10,000 (2.32) 05202 OFFICE SUPPLIES 2,500 1,578 2,262 2,500 2,500 2,500 0.00 05204 BUNKER / PPE GEAR 2,000 4,642 0 5,000 5,000 5,000 0.00 05205 AWARDS / FLOWERS 600 585 0 600 600 600 0.00 05207 VEHICLE SUPPLIES / PARTS 2,000 999 175 3,000 3,000 3,000 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 13 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05208 UNIFORMS 5,000 2,195 1,278 6,000 7,000 6,000 0.00 05209 JANITORIAL SUPPLIES 2,000 1,275 490 2,000 2,000 2,000 0.00 05210 MISCELLANEOUS 1,000 544 1,000 1,000 1,000 1,000 0.00 05212 EQUIPMENT PURCHASED 5,000 576 2,489 8,000 8,000 7,000 (12.50) 05222 SUPPLIES 2,500 296 559 2,500 2,500 2,500 0.00 00200 TOTAL COMMODITIES 18,668 32,600 12,248 40,837 41,600 39,600 (3.03) 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 1,200 1,157 1,435 2,500 2,500 2,500 0.00 05301 TELEPHONES 5,400 5,354 4,057 4,000 4,000 4,000 0.00 05302 TRAVEL AND TRAINING 4,000 2,584 2,005 5,000 5,000 4,000 (20.00) 05303 RADIO/PAGER REPAIR 500 0 0 500 500 500 0.00 05304 VEHICLE MAINTENANCE 18,000 6,788 8,541 16,075 18,000 16,000 (0.47) 05305 MEMBERSHIPS & SUBSCRIPTIONS 3,000 557 869 2,000 2,000 2,000 0.00 05306 ADVERTISING 300 0 0 300 300 300 0.00 05309 FIRE EXTINGUISHER 200 85 125 200 200 200 0.00 05310 MISCELLANEOUS 1,000 0 29 1,000 1,000 1,000 0.00 05313 UTILITIES PURCH FROM WUD 40,000 32,483 24,123 40,000 40,000 35,000 (12.50) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 14 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05314 UTILITIES PURCH FROM OTHER 4,200 3,963 3,737 4,200 4,200 4,200 0.00 05319 PROFESSIONAL SERVICES 200 0 0 200 200 200 0.00 05320 MEDICAL PROFESS. SERVICES 1,200 608 719 1,200 2,200 1,200 0.00 05322 CABLE 700 678 572 900 900 900 0.00 05325 SECURITY MONITORING 500 0 0 500 500 500 0.00 05354 FIRE PREVENTION 1,500 1,294 1,432 1,500 1,500 1,500 0.00 05355 BUNKER GEAR REPAIR 500 0 0 500 500 500 0.00 05358 EQUIPMENT REPAIR & MAINT. 5,000 3,084 1,044 5,000 5,000 5,000 0.00 05365 CONTRACTUAL SERVICES 2,000 520 1,456 3,000 6,000 3,000 0.00 ** CONTRACT OUT HOSE TESTING ** 00300 TOTAL CONTRACTUAL SERVICES 59,155 89,400 50,144 88,575 94,500 82,500 (6.86) 00600 CAPITAL OUTLAY 05604 OPEN 0 0 0 0 43,000 0 0.00 05623 RADIO/PAGERS 4,275 4,085 2,562 4,275 4,275 4,275 0.00 05624 BUNKER/PPE GEAR 5,000 2,494 0 5,000 5,000 5,000 0.00 00600 TOTAL CAPITAL OUTLAY 6,579 9,275 2,562 9,275 52,275 9,275 0.00 200 TOTAL FIRE DEPARTMENT 415,997 496,128 316,190 470,864 533,389 474,256 0.72 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 15 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 300 POLICE 00100 PERSONAL SERVICES 05100 SALARIES 267,488 252,663 270,964 362,370 356,191 349,994 (3.42) ** Vacancy budgeted 9 months of salary ** 05101 OVERTIME 17,000 15,025 15,709 20,000 20,000 20,000 0.00 05103 ANNUAL BONUS 1,150 830 1,250 1,380 1,530 1,530 10.87 05104 SOCIAL SECURITY 20,463 19,113 20,088 27,722 27,249 26,775 (3.42) 05105 RETIREMENT CONTRIBUTIONS 48,790 48,795 52,289 66,097 64,970 63,840 (3.41) 05106 HEALTH INSURANCE CONTRIBUTIONS 64,976 54,963 49,862 80,038 78,639 78,639 (1.75) 05107 WORKERS COMPENSATION 30,000 19,000 16,126 30,000 30,000 30,000 0.00 00100 TOTAL PERSONAL SERVICES 410,389 449,867 426,288 587,607 578,579 570,778 (2.86) 00200 COMMODITIES 05201 FUEL 30,000 16,787 14,897 27,000 27,000 25,000 (7.41) 05202 OFFICE SUPPLIES 2,000 1,492 6,746 8,000 2,000 2,000 (75.00) 05206 VEHICLE MAINT/REPAIR 15,000 13,528 12,930 18,000 18,000 18,000 0.00 05208 UNIFORMS 3,000 1,860 328 3,000 3,000 3,000 0.00 05210 MISCELLANEOUS 500 386 132 500 500 500 0.00 05215 BUILDING MAINT. 1,000 903 520 1,000 1,000 1,000 0.00 05222 SUPPLIES 6,000 5,056 3,216 6,000 6,000 6,000 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 16 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05224 POLICE K9 1,500 1,269 920 1,500 1,500 1,500 0.00 05226 DRUG SEIZURE EXPENSE 2,500 3,191 0 3,000 0 0 (100.00) 00200 TOTAL COMMODITIES 44,472 61,500 39,689 68,000 59,000 57,000 (16.18) 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 2,500 1,598 1,197 2,500 2,500 2,500 0.00 05301 TELEPHONES 4,300 2,807 1,987 4,300 4,300 3,300 (23.26) 05302 TRAVEL AND TRAINING 3,000 2,942 2,179 3,000 3,000 3,000 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 645 300 295 645 645 645 0.00 05306 ADVERTISING 500 11 250 500 500 500 0.00 05307 PUBLIC RELATIONS 500 0 0 500 500 500 0.00 05311 RADAR CERTIFICATION 400 0 240 400 400 400 0.00 05313 UTILITIES PURCH FROM WUD 14,000 11,360 9,390 14,000 14,000 12,200 (12.86) 05315 POLICE FUND 1,000 768 6,652 1,000 1,000 1,000 0.00 05318 SOFTWARE 2,700 3,144 3,146 3,500 3,500 3,500 0.00 05319 PROFESSIONAL SERVICES 2,500 2,274 1,040 2,500 2,500 2,500 0.00 05320 MEDICAL PROFESS. SERVICES 2,000 1,447 189 2,000 2,000 2,000 0.00 05352 JANITORIAL EXPENSE 1,042 900 750 1,042 1,042 1,042 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 17 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05357 EQUIPMENT RENTAL/LEASE 500 0 0 500 500 500 0.00 05358 EQUIPMENT REPAIR & MAINT. 1,800 1,721 0 1,800 1,800 1,800 0.00 05359 EQUIPMENT PURCHASE 1,400 1,244 0 1,400 1,400 1,400 0.00 05373 JUVENILE DETENTION 3,000 1,643 0 3,000 3,000 3,000 0.00 00300 TOTAL CONTRACTUAL SERVICES 32,159 41,787 27,315 42,587 42,587 39,787 (6.57) 00600 CAPITAL OUTLAY 05637 OTHER EQUIPMENT 15,700 7,150 0 2,400 100,000 0 (100.00) 00600 TOTAL CAPITAL OUTLAY 7,150 15,700 0 2,400 100,000 0 (100.00) 300 TOTAL POLICE 494,170 568,854 493,292 700,594 780,166 667,565 (4.71) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 18 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 500 CODES 00100 PERSONAL SERVICES 05100 SALARIES 0 0 0 0 34,000 17,000 0.00 05103 ANNUAL BONUS 0 0 0 0 100 100 0.00 05104 SOCIAL SECURITY 0 0 0 0 2,601 1,301 0.00 05105 RETIREMENT CONTRIBUTIONS 0 0 0 0 6,202 3,101 0.00 05106 HEALTH INSURANCE CONTRIBUTIONS 0 0 0 0 0 6,095 0.00 00100 TOTAL PERSONAL SERVICES 0 0 0 0 42,903 27,597 0.00 00200 COMMODITIES 05201 FUEL 300 238 48 600 600 1,000 66.67 05202 OFFICE SUPPLIES 500 10 182 500 500 800 60.00 05206 VEHICLE MAINT/REPAIR 250 0 38 250 250 250 0.00 05210 MISCELLANEOUS 1,000 815 576 1,000 1,000 1,000 0.00 05214 PRINTING 500 0 43 500 500 500 0.00 00200 TOTAL COMMODITIES 1,063 2,550 887 2,850 2,850 3,550 24.56 00300 CONTRACTUAL SERVICES 05367 ZONING/COMP PLAN 0 0 0 0 0 40,000 0.00 05385 CODE SERVICES CONTRACT 23,000 19,379 12,902 23,000 23,000 0 (100.00) 05386 ABATEMENT EXPENSES 5,000 0 0 5,000 5,000 10,000 100.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 19 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 00300 TOTAL CONTRACTUAL SERVICES 19,379 28,000 12,902 28,000 28,000 50,000 78.57 500 TOTAL CODES 20,442 30,550 13,789 30,850 73,753 81,147 163.04 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 20 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 600 PUBLIC WORKS 00200 COMMODITIES 05201 FUEL 2,500 1,344 682 1,000 1,000 1,000 0.00 05202 OFFICE SUPPLIES 1,500 1,188 383 1,000 1,000 1,000 0.00 05206 VEHICLE MAINT/REPAIR 0 0 0 0 1,500 1,500 0.00 05209 JANITORIAL SUPPLIES 400 381 397 400 400 400 0.00 05210 MISCELLANEOUS 1,000 151 240 1,000 1,000 1,000 0.00 05215 BUILDING MAINT. 10,000 3,179 4,752 5,000 5,000 10,000 100.00 05216 MATERIALS - MAINT. 4,000 3,437 3,371 4,000 4,000 4,000 0.00 05222 SUPPLIES 1,500 1,410 2,001 2,000 2,000 2,000 0.00 05223 TOOLS 1,000 722 561 1,000 1,000 1,000 0.00 00200 TOTAL COMMODITIES 11,812 21,900 12,387 15,400 16,900 21,900 42.21 00300 CONTRACTUAL SERVICES 05313 UTILITIES PURCH FROM WUD 14,000 13,143 9,063 14,000 14,000 14,000 0.00 05316 RAILROAD PROPERTY RENTAL 800 798 811 900 900 900 0.00 05325 SECURITY MONITORING 2,000 565 480 2,000 2,000 2,000 0.00 05352 JANITORIAL EXPENSE 1,122 1,090 1,128 900 1,500 1,500 66.67 05357 EQUIPMENT RENTAL/LEASE 1,000 0 0 500 500 500 0.00 05358 EQUIPMENT REPAIR & MAINT. 500 88 7 500 500 500 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 21 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05360 HAND POWER / HYDRAULIC TOOLS 1,000 0 449 500 500 500 0.00 05363 R.O.W. MAINTENANCE 45,000 46,277 35,594 45,000 45,000 45,000 0.00 05364 MOSQUITO SPRAYING 8,000 6,251 2,860 8,000 8,000 8,000 0.00 05365 CONTRACTUAL SERVICES 20,000 6,561 1,055 2,500 2,500 2,500 0.00 00300 TOTAL CONTRACTUAL SERVICES 74,773 93,422 51,447 74,800 75,400 75,400 0.80 00600 CAPITAL OUTLAY 05636 BUILDING/OTHER IMPROVEMENTS 0 0 23,927 50,000 70,000 20,000 (60.00) ** POLICE ROOF, RILEY STREET, PRK LOT ** 00600 TOTAL CAPITAL OUTLAY 0 0 23,927 50,000 70,000 20,000 (60.00) 600 TOTAL PUBLIC WORKS 86,585 115,322 87,761 140,200 162,300 117,300 (16.33) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 22 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 700 NON DEPARTMENTAL 00100 PERSONAL SERVICES 05113 PAYROLL ADJUSTMENTS 0 0 0 0 0 15,000 0.00 00100 TOTAL PERSONAL SERVICES 0 0 0 0 0 15,000 0.00 00200 COMMODITIES 05222 SUPPLIES 500 0 0 500 500 500 0.00 00200 TOTAL COMMODITIES 0 500 0 500 500 500 0.00 00300 CONTRACTUAL SERVICES 05377 SOLID WASTE TRANSFER 61,867 61,867 86,392 86,392 93,843 76,487 (11.47) 05384 TRANSFER TO YOUTH RECREATION 210,000 210,000 187,491 187,491 185,000 154,314 (17.70) 00300 TOTAL CONTRACTUAL SERVICES 271,867 271,867 273,883 273,883 278,843 230,801 (15.73) 700 TOTAL NON DEPARTMENTAL 271,867 272,367 273,883 274,383 279,343 246,301 (10.23) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 23 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual TOTAL EXPENDITURES 1,667,408 1,873,534 1,543,884 2,034,286 2,240,292 2,001,573 (1.61) TOTAL FUND SURPLUS (DEFICIT) 130,915 179,220 273,762 0 (717,995) 0 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 24 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual REVENUES 150 UTILITY ADMINISTRATION 00405 INTEREST INCOME 40500 INTEREST INCOME 500 1,363 475 500 500 500 0.00 00405 TOTAL INTEREST INCOME 1,363 500 475 500 500 500 0.00 00407 MISCELLANEOUS & OTHER 40700 SERVICE CHARGES 50,000 46,655 45,576 50,000 50,000 50,000 0.00 40701 PROCEEDS FROM BORROWING 414,556 192,976 18,545 0 0 488,000 0.00 40707 MISCELLANEOUS REV 60,000 0 0 60,000 60,000 60,000 0.00 40710 PENALTIES 60,000 59,091 60,254 60,000 60,000 60,000 0.00 40712 DEBT SET OFF FEES 500 525 750 500 500 500 0.00 40723 AMI FEES 297,000 297,304 274,281 296,268 85,104 308,119 4.00 40737 REFUNDS/REIMBURSEMENTS 30,352 38,691 11,367 30,000 30,000 30,000 0.00 00407 TOTAL MISCELLANEOUS & OTHER 635,242 912,408 410,773 496,768 285,604 996,619 100.62 00412 OTHER REVENUE 41200 GRANTS 0 0 0 15,425 15,425 0 (100.00) ** Generators (other half of rev in 10 fund) ** 00412 TOTAL OTHER REVENUE 0 0 0 15,425 15,425 0 (100.00) 150 TOTAL UTILITY ADMINISTRATION 636,605 912,908 411,248 512,693 301,529 997,119 94.49 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 25 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 250 ELECTRIC 00407 MISCELLANEOUS & OTHER 40703 SALE OF EQUIP/MATERIAL/SCRAP 5,000 15,088 18,673 5,000 0 10,000 100.00 40707 MISCELLANEOUS REV 100 325 500 100 0 500 400.00 40711 POLE RENTAL FEES 400 386 5,039 300 0 5,000 0.00 40737 REFUNDS/REIMBURSEMENTS 0 21,727 12,619 0 0 2,500 0.00 00407 TOTAL MISCELLANEOUS & OTHER 37,526 5,500 36,831 5,400 0 18,000 233.33 00408 ELECTRIC 40800 COMMERCIAL ELECTRIC 1,635,609 1,520,270 1,340,837 1,651,700 0 1,720,000 4.14 40801 RESIDENTIAL ELECTRIC 2,201,303 2,012,930 1,901,044 2,100,000 0 2,175,000 3.57 40803 COMMERCIAL ELE NTX 330,000 294,680 235,013 360,000 0 360,000 0.00 40804 TEMP POWER/UNDERGRND PW 500 0 810 500 0 25,000 0.00 00408 TOTAL ELECTRIC 3,827,880 4,167,412 3,477,704 4,112,200 0 4,280,000 4.08 250 TOTAL ELECTRIC 3,865,406 4,172,912 3,514,535 4,117,600 0 4,298,000 4.38 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 26 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 350 WATER 00407 MISCELLANEOUS & OTHER 40703 SALE OF EQUIP/MATERIAL/SCRAP 2,100 0 5,645 2,000 2,000 3,000 50.00 40737 REFUNDS/REIMBURSEMENTS 14,375 14,375 3,844 0 0 5,000 0.00 00407 TOTAL MISCELLANEOUS & OTHER 14,375 16,475 9,489 2,000 2,000 8,000 300.00 00409 WATER 40900 WATER SALES 1,865,837 1,997,297 1,767,721 1,860,932 0 1,900,000 2.10 40901 WATER TAPS 15,000 21,006 34,055 15,000 0 30,000 100.00 40902 DHEC 13,700 13,805 12,752 14,000 0 15,000 7.14 00409 TOTAL WATER 2,032,108 1,894,537 1,814,528 1,889,932 0 1,945,000 2.91 350 TOTAL WATER 2,046,483 1,911,012 1,824,017 1,891,932 2,000 1,953,000 3.23 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 27 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 450 SEWER 00407 MISCELLANEOUS & OTHER 40703 SALE OF EQUIP/MATERIAL/SCRAP 0 0 0 0 2,500 2,500 0.00 40739 BEACON MILL PROJECT 0 309,780 83,679 0 0 0 0.00 40740 SEWER PROJECT FUND 0 0 0 0 0 0 0.00 00407 TOTAL MISCELLANEOUS & OTHER 309,780 0 83,679 0 2,500 2,500 0.00 00410 SEWER 41000 SEWER SALES 625,231 615,171 588,349 620,000 0 714,240 15.20 41001 SEWER TAPS 2,000 (1,000) 2,000 2,000 0 5,000 150.00 00410 TOTAL SEWER 614,171 627,231 590,349 622,000 0 719,240 15.63 450 TOTAL SEWER 923,951 627,231 674,028 622,000 2,500 721,740 16.04 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 28 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 550 WATER PLANT 00407 MISCELLANEOUS & OTHER 40735 INSURANCE PAID CLAIMS 0 0 8,445 0 0 2,500 0.00 40737 REFUNDS/REIMBURSEMENTS 0 107 899 0 0 1,000 0.00 00407 TOTAL MISCELLANEOUS & OTHER 107 0 9,344 0 0 3,500 0.00 550 TOTAL WATER PLANT 107 0 9,344 0 0 3,500 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 29 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual TOTAL REVENUES 7,472,552 7,624,063 6,433,172 7,144,225 306,029 7,973,359 11.61 EXPENDITURES 150 UTILITY ADMINISTRATION 00100 PERSONAL SERVICES 05100 SALARIES 192,206 193,634 118,338 196,046 194,648 217,518 10.95 ** Half of Codes salary is budgeted here ** 05101 OVERTIME 1,500 960 1,328 1,000 1,000 1,000 0.00 05103 ANNUAL BONUS 900 900 990 990 1,080 1,080 9.09 05104 SOCIAL SECURITY 14,705 14,029 8,431 14,997 14,891 16,642 10.97 05105 RETIREMENT CONTRIBUTIONS 29,908 30,578 18,620 30,505 30,606 34,304 12.45 05106 HEALTH INSURANCE CONTRIBUTIONS 36,490 37,242 21,721 36,489 30,288 36,383 (0.29) 05107 WORKERS COMPENSATION 4,862 4,862 4,500 6,000 6,000 6,000 0.00 05108 EMPLOYEE BONDING 700 590 590 700 700 700 0.00 05114 VEHICLE ALLOWANCE 2,500 1,923 700 2,500 2,500 4,200 68.00 00100 TOTAL PERSONAL SERVICES 284,718 283,771 175,218 289,227 281,713 317,827 9.89 00200 COMMODITIES 05200 POSTAGE 2,000 1,108 1,100 1,500 1,500 1,500 0.00 05201 FUEL 5,000 2,750 2,644 5,000 5,000 5,000 0.00 05202 OFFICE SUPPLIES 8,000 7,476 3,867 6,000 6,000 6,000 0.00 05205 AWARDS / FLOWERS 150 83 42 150 150 150 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 30 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05206 VEHICLE MAINT/REPAIR 4,000 2,354 2,792 3,000 3,000 3,000 0.00 05208 UNIFORMS 4,000 3,758 2,931 4,000 4,000 4,000 0.00 05209 JANITORIAL SUPPLIES 900 827 535 900 900 900 0.00 05210 MISCELLANEOUS 2,000 1,506 562 1,500 1,500 1,500 0.00 05211 SERVICE FEES 14,000 29,649 32,329 20,000 20,000 20,000 0.00 05212 EQUIPMENT PURCHASED 0 0 2,038 2,000 0 2,000 0.00 05215 BUILDING MAINT. 500 549 0 500 500 500 0.00 05216 MATERIALS - MAINT. 100 0 10 100 100 100 0.00 05222 SUPPLIES 1,500 954 111 1,500 1,500 1,500 0.00 05223 TOOLS 50 0 13 50 50 50 0.00 05227 BANK RECON ADJUSTMENT 0 (781) 70 0 0 0 0.00 00200 TOTAL COMMODITIES 50,233 42,200 49,044 46,200 44,200 46,200 0.00 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 2,200 1,598 1,118 2,200 2,200 2,200 0.00 05301 TELEPHONES 5,000 3,444 2,464 3,500 3,500 3,500 0.00 05302 TRAVEL AND TRAINING 2,200 1,843 0 2,200 2,200 2,200 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 3,000 2,092 1,858 3,000 3,000 3,000 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 31 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05306 ADVERTISING 200 906 157 200 200 200 0.00 05308 OFFICE EQUIP/RENTAL/LEASE 2,000 1,141 1,521 2,000 2,000 2,000 0.00 05310 MISCELLANEOUS 8,000 2,754 1,155 8,000 8,000 8,000 0.00 05313 UTILITIES PURCH FROM WUD 9,000 8,291 6,604 9,000 9,000 9,000 0.00 05319 PROFESSIONAL SERVICES 50,000 28,665 23,800 50,000 50,000 20,000 (60.00) 05320 MEDICAL PROFESS. SERVICES 250 47 94 250 250 250 0.00 05321 COMPUTER MAINTENANCE 7,500 7,335 5,619 7,500 7,500 7,500 0.00 05323 VEHICLE & PROPERTY INSURANCE 65,000 73,382 124 65,000 65,000 65,000 0.00 05326 FRANCHISE FEE 432,927 432,927 453,847 495,106 329,632 496,296 0.24 05327 ONLINE UTILITY EXCHANGE 1,000 993 787 1,000 1,000 1,000 0.00 05336 SC SALES TAX 1,400 476 409 1,000 1,000 1,000 0.00 05352 JANITORIAL EXPENSE 3,000 2,819 2,442 3,000 3,000 3,000 0.00 05358 EQUIPMENT REPAIR & MAINT. 500 0 318 500 500 500 0.00 05365 CONTRACTUAL SERVICES 61,100 65,094 58,301 61,000 61,000 60,000 (1.64) 05375 RECORDS CHECK 50 0 0 50 50 50 0.00 05379 LEGAL SERVICES 0 0 0 0 0 20,000 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 32 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 00300 TOTAL CONTRACTUAL SERVICES 633,807 654,327 560,618 714,506 549,032 704,696 (1.37) 00600 CAPITAL OUTLAY 05601 VEHICLES/EQUIPMENT 0 0 0 0 0 488,000 0.00 ** UD Truck $40K, Skid Steet $110K Bucket Truck 125K ** 05604 OPEN 0 0 27,749 30,000 30,000 80,000 166.67 ** RILEY STREET DEMO/SHOP IMPROVEMENTS ** 00600 TOTAL CAPITAL OUTLAY 0 0 27,749 30,000 30,000 568,000 0.00 150 TOTAL UTILITY ADMINISTRATION 968,758 980,298 812,629 1,079,933 904,945 1,636,723 51.56 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 33 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 250 ELECTRIC 00100 PERSONAL SERVICES 05100 SALARIES 169,925 167,156 159,548 174,632 194,511 260,291 49.05 ** tree person added to crew Taylor and Cory at $52,000 ** 05101 OVERTIME 15,000 19,529 11,292 15,000 12,000 12,000 (20.00) 05103 ANNUAL BONUS 610 610 1,050 670 670 770 14.93 05104 SOCIAL SECURITY 12,864 13,580 12,555 13,259 14,881 19,913 50.18 05105 RETIREMENT CONTRIBUTIONS 26,441 29,048 26,583 26,930 30,266 40,502 50.40 05106 HEALTH INSURANCE CONTRIBUTIONS 36,174 31,432 23,573 36,174 44,066 44,066 21.82 05107 WORKERS COMPENSATION 18,000 18,000 13,252 25,000 25,000 25,000 0.00 00100 TOTAL PERSONAL SERVICES 279,355 279,014 247,853 291,665 321,394 402,542 38.02 00200 COMMODITIES 05201 FUEL 15,000 13,569 11,450 12,000 12,000 15,000 25.00 05202 OFFICE SUPPLIES 2,000 1,057 507 2,000 2,000 2,000 0.00 05206 VEHICLE MAINT/REPAIR 20,000 13,716 10,051 19,000 19,000 19,000 0.00 05208 UNIFORMS 5,000 4,860 3,720 5,000 5,000 5,000 0.00 05209 JANITORIAL SUPPLIES 500 69 179 500 500 500 0.00 05210 MISCELLANEOUS 200 181 130 200 200 200 0.00 05212 EQUIPMENT PURCHASED 0 0 1,019 1,000 1,000 1,000 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 34 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05216 MATERIALS - MAINT. 67,500 57,359 119,882 165,000 165,000 165,000 0.00 05217 MATERIALS - EXTENSION 2,000 1,071 0 2,000 2,000 2,000 0.00 05222 SUPPLIES 1,000 326 163 1,000 1,000 1,000 0.00 05223 TOOLS 1,200 903 1,723 1,200 20,000 20,000 0.00 05232 MATERIAL/SCRAP RECOVERY 0 0 0 0 0 13,000 0.00 00200 TOTAL COMMODITIES 93,111 114,400 148,824 208,900 227,700 243,700 16.66 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 3,500 4,153 3,796 3,500 3,500 3,500 0.00 05301 TELEPHONES 1,900 1,958 1,350 1,900 1,900 1,900 0.00 05302 TRAVEL AND TRAINING 8,000 6,919 4,351 8,000 8,000 10,000 25.00 05310 MISCELLANEOUS 3,200 2,581 975 3,200 3,200 3,200 0.00 05313 UTILITIES PURCH FROM WUD 5,000 4,322 3,411 5,000 5,000 5,000 0.00 05319 PROFESSIONAL SERVICES 74,000 53,400 44,100 49,000 49,000 49,000 0.00 05320 MEDICAL PROFESS. SERVICES 500 144 177 500 500 500 0.00 05338 ROW LIABILITIES 2,000 2,512 0 2,000 2,000 2,000 0.00 05340 ENERGY PURCHASED 2,442,543 2,194,109 1,624,753 2,333,387 2,333,387 2,335,000 0.07 05352 JANITORIAL EXPENSE 100 0 0 100 100 100 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 35 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05358 EQUIPMENT REPAIR & MAINT. 5,000 5,413 0 5,000 5,000 5,000 0.00 05360 HAND POWER / HYDRAULIC TOOLS 5,000 4,992 5,471 5,000 5,000 5,000 0.00 05361 HEAVY DUTY EQUIP RENT/LEASE 1,000 756 3,209 1,000 1,000 1,000 0.00 05365 CONTRACTUAL SERVICES 67,500 40,645 171,922 215,000 50,000 83,280 (61.27) ** temp person for tree trimmer at $16phr ** 05371 CUT LINES 1,500 0 0 1,500 1,500 1,500 0.00 00300 TOTAL CONTRACTUAL SERVICES 2,321,904 2,620,743 1,863,515 2,634,087 2,469,087 2,505,980 (4.86) 00600 CAPITAL OUTLAY 05604 OPEN 24,027 24,027 0 0 40,000 0 0.00 05608 TRANSFORMERS 6,500 2,481 44,712 10,000 30,000 40,000 300.00 05632 RECONDUCTOR TO RAW WATER STATI 0 0 0 0 2,500 2,500 0.00 05633 TRANSFORMER INSTALLATION 100,000 100,000 323,922 420,690 160,000 160,000 (61.97) 05634 PAINT DECORATIVE LIGHTS ON MAI 0 0 0 0 2,500 2,500 0.00 05637 OTHER EQUIPMENT 102,000 96,556 0 0 9,400 9,400 0.00 05639 WESTMINSTER CROSSING PROJECT 31,317 31,305 0 0 0 25,000 0.00 05642 SUBSTATION REPAIRS 119,424 0 42,258 0 25,000 37,500 0.00 00600 TOTAL CAPITAL OUTLAY 254,369 383,268 410,892 430,690 269,400 276,900 (35.71) 250 TOTAL ELECTRIC 2,948,739 3,397,425 2,671,084 3,565,342 3,287,581 3,429,122 (3.82) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 36 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 350 WATER 00100 PERSONAL SERVICES 05100 SALARIES 173,207 173,850 113,863 129,000 128,302 164,148 27.25 ** New position added Inspector/Locator ** 05101 OVERTIME 12,000 13,623 11,937 12,000 12,000 12,000 0.00 05103 ANNUAL BONUS 1,300 1,300 1,410 1,110 1,200 1,300 17.12 05104 SOCIAL SECURITY 13,251 13,315 8,958 9,869 9,816 12,558 27.25 05105 RETIREMENT CONTRIBUTIONS 26,951 29,171 19,574 20,073 19,964 25,542 27.25 05106 HEALTH INSURANCE CONTRIBUTIONS 31,378 41,303 24,512 23,376 29,415 41,604 77.98 05107 WORKERS COMPENSATION 5,205 5,205 6,930 23,500 23,500 25,000 6.38 00100 TOTAL PERSONAL SERVICES 277,767 263,292 187,184 218,928 224,197 282,152 28.88 00200 COMMODITIES 05201 FUEL 13,000 12,495 10,360 16,000 16,000 16,000 0.00 05202 OFFICE SUPPLIES 2,000 1,891 1,262 1,500 1,500 1,500 0.00 05206 VEHICLE MAINT/REPAIR 25,000 20,278 23,544 30,000 25,000 25,000 (16.67) 05208 UNIFORMS 7,500 7,042 5,761 5,500 5,500 5,500 0.00 05209 JANITORIAL SUPPLIES 500 69 179 500 500 500 0.00 05210 MISCELLANEOUS 250 87 0 250 200 200 (20.00) 05212 EQUIPMENT PURCHASED 3,000 0 1,529 1,500 6,500 6,500 333.33 ** Motor tapping machine ** Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 37 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05215 BUILDING MAINT. 2,000 2,040 0 3,000 2,000 3,000 0.00 05216 MATERIALS - MAINT. 130,000 138,537 120,606 120,000 140,000 140,000 16.67 05217 MATERIALS - EXTENSION 0 0 2,074 10,000 2,500 10,000 0.00 05222 SUPPLIES 2,000 1,962 2,845 3,000 3,000 3,000 0.00 05223 TOOLS 3,500 2,868 3,340 3,500 3,500 3,500 0.00 05232 MATERIAL/SCRAP RECOVERY 0 0 0 0 0 3,000 0.00 00200 TOTAL COMMODITIES 187,269 188,750 171,500 194,750 206,200 217,700 11.78 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 3,500 3,354 2,188 3,300 3,300 3,300 0.00 05301 TELEPHONES 2,200 1,958 1,350 2,200 2,200 2,200 0.00 05302 TRAVEL AND TRAINING 2,500 2,229 1,245 2,500 2,500 2,500 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 200 0 30 200 200 200 0.00 05306 ADVERTISING 100 0 0 300 300 300 0.00 05310 MISCELLANEOUS 100 55 484 100 100 100 0.00 05313 UTILITIES PURCH FROM WUD 33,000 29,160 21,188 33,000 30,000 30,000 (9.09) 05319 PROFESSIONAL SERVICES 13,000 2,400 6,000 12,000 10,000 10,000 (16.67) 05320 MEDICAL PROFESS. SERVICES 450 189 94 400 400 400 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 38 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05339 PURCHASED WATER 2,000 1,134 8,936 1,500 2,500 2,500 66.67 05341 ASPHALT/PAVING 20,000 23,895 30,225 20,000 40,000 40,000 100.00 05350 PUMP STATION MAINT/REPAIR 22,500 20,920 4,634 15,000 15,000 15,000 0.00 05351 ELEVATED TANK MAINT. 45,000 42,689 44,638 45,000 45,000 45,000 0.00 05353 HYDRANT MAINTENANCE 500 266 0 1,000 20,000 20,000 0.00 05358 EQUIPMENT REPAIR & MAINT. 15,000 9,580 14,458 15,000 15,000 15,000 0.00 05360 HAND POWER / HYDRAULIC TOOLS 2,000 376 1,930 2,000 2,000 2,000 0.00 05361 HEAVY DUTY EQUIP RENT/LEASE 5,000 367 3,104 3,500 3,500 3,500 0.00 05365 CONTRACTUAL SERVICES 70,000 59,740 12,844 20,000 18,000 20,000 0.00 05371 CUT LINES 2,500 1,789 5,625 2,500 2,500 2,500 0.00 00300 TOTAL CONTRACTUAL SERVICES 200,101 239,550 158,973 179,500 212,500 214,500 19.50 00600 CAPITAL OUTLAY 05637 OTHER EQUIPMENT 48,000 2,798 14,059 15,425 10,000 10,000 (35.17) 00600 TOTAL CAPITAL OUTLAY 2,798 48,000 14,059 15,425 10,000 10,000 (35.17) 350 TOTAL WATER 667,935 739,592 531,716 608,603 652,897 724,352 19.02 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 39 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 450 SEWER 00100 PERSONAL SERVICES 05100 SALARIES 81,990 87,801 75,384 83,820 87,400 89,148 6.36 05101 OVERTIME 10,000 14,024 10,913 13,000 13,000 13,000 0.00 05103 ANNUAL BONUS 390 1,610 720 450 450 450 0.00 05104 SOCIAL SECURITY 6,273 7,186 6,057 6,412 6,687 6,820 6.36 05105 RETIREMENT CONTRIBUTIONS 12,758 16,038 15,477 13,042 13,600 13,872 6.36 05106 HEALTH INSURANCE CONTRIBUTIONS 28,533 26,589 18,834 23,819 27,002 27,002 13.36 05107 WORKERS COMPENSATION 4,126 4,126 6,743 10,000 10,000 10,000 0.00 00100 TOTAL PERSONAL SERVICES 157,374 144,070 134,128 150,543 158,139 160,292 6.48 00200 COMMODITIES 05201 FUEL 13,000 12,351 10,075 15,000 15,000 15,000 0.00 05202 OFFICE SUPPLIES 1,000 741 297 1,000 1,000 1,000 0.00 05203 RADIO/PAGERS 1,000 0 64 1,000 10,000 10,000 900.00 05206 VEHICLE MAINT/REPAIR 12,000 8,255 7,154 10,500 10,500 10,500 0.00 05208 UNIFORMS 6,000 5,353 4,713 5,000 5,000 5,000 0.00 05209 JANITORIAL SUPPLIES 400 49 179 300 300 300 0.00 05210 MISCELLANEOUS 100 28 85 100 100 100 0.00 05212 EQUIPMENT PURCHASED 0 0 1,529 1,500 1,500 1,500 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 40 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05216 MATERIALS - MAINT. 12,000 10,318 6,935 10,000 10,000 10,000 0.00 05222 SUPPLIES 2,000 962 1,820 2,000 2,000 2,000 0.00 05223 TOOLS 2,000 1,264 613 2,000 2,000 2,000 0.00 05232 MATERIAL/SCRAP RECOVERY 0 0 0 0 0 3,000 0.00 00200 TOTAL COMMODITIES 39,321 49,500 33,464 48,400 57,400 60,400 24.79 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 1,500 957 761 1,500 1,500 1,500 0.00 05301 TELEPHONES 2,000 1,958 1,350 2,000 2,000 2,000 0.00 05302 TRAVEL AND TRAINING 2,500 55 396 1,000 1,000 1,000 0.00 05310 MISCELLANEOUS 350 99 1,426 300 300 300 0.00 05313 UTILITIES PURCH FROM WUD 3,000 4,086 3,211 3,000 3,000 3,000 0.00 05319 PROFESSIONAL SERVICES 2,000 0 0 1,000 1,000 1,000 0.00 05320 MEDICAL PROFESS. SERVICES 500 264 304 500 500 500 0.00 05329 OCONEE COUNTY SEWER BILL 564,000 560,233 401,886 564,000 564,000 564,000 0.00 05341 ASPHALT/PAVING 4,000 3,664 4,000 4,000 24,000 24,000 500.00 05357 EQUIPMENT RENTAL/LEASE 5,000 1,754 123 3,000 3,000 3,000 0.00 05358 EQUIPMENT REPAIR & MAINT. 15,000 4,129 8,707 15,000 15,000 15,000 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 41 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05360 HAND POWER / HYDRAULIC TOOLS 1,000 0 601 1,000 1,000 1,000 0.00 05365 CONTRACTUAL SERVICES 16,000 13,691 19,613 25,000 20,000 35,000 40.00 00300 TOTAL CONTRACTUAL SERVICES 590,890 616,850 442,378 621,300 636,300 651,300 4.83 00600 CAPITAL OUTLAY 05612 FLOW METERS 0 0 0 0 15,000 30,350 0.00 05641 BEACON MILL PROJECT 142,780 142,780 111,572 0 0 0 0.00 00600 TOTAL CAPITAL OUTLAY 142,780 142,780 111,572 0 15,000 30,350 0.00 450 TOTAL SEWER 930,365 953,200 721,542 820,243 866,839 902,342 10.01 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 42 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 550 WATER PLANT 00100 PERSONAL SERVICES 05100 SALARIES 131,743 121,956 107,122 130,135 128,927 135,810 4.36 05101 OVERTIME 4,000 3,374 2,816 5,000 5,000 5,000 0.00 05103 ANNUAL BONUS 870 670 1,660 1,020 950 950 (6.86) 05104 SOCIAL SECURITY 14,791 10,902 8,998 13,398 11,393 12,685 (5.32) 05105 RETIREMENT CONTRIBUTIONS 30,084 22,774 18,796 24,310 23,174 25,800 6.13 05106 HEALTH INSURANCE CONTRIBUTIONS 23,376 17,628 12,592 15,865 15,110 15,110 (4.76) 05107 WORKERS COMPENSATION 5,500 4,500 4,000 5,500 5,500 5,500 0.00 05109 PART TIME EMPLOYEES 23,594 21,233 10,862 45,000 20,000 30,000 (33.33) 00100 TOTAL PERSONAL SERVICES 203,037 233,958 166,846 240,228 210,054 230,855 (3.90) 00200 COMMODITIES 05200 POSTAGE 1,750 696 936 1,750 1,750 1,750 0.00 05201 FUEL 4,500 3,069 1,560 4,500 4,500 4,500 0.00 05202 OFFICE SUPPLIES 3,000 2,930 1,968 3,000 3,000 3,000 0.00 05206 VEHICLE MAINT/REPAIR 2,500 86 787 2,500 2,500 2,500 0.00 05208 UNIFORMS 1,000 932 360 1,000 1,000 1,000 0.00 05209 JANITORIAL SUPPLIES 1,000 1,017 938 1,000 1,100 1,100 10.00 05210 MISCELLANEOUS 250 250 18 250 250 250 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 43 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05213 CHEMICALS 42,500 34,704 19,129 40,550 30,550 30,550 (24.66) 05215 BUILDING MAINT. 42,000 40,969 31,627 32,473 42,473 42,500 30.88 05222 SUPPLIES 500 577 465 500 500 500 0.00 05232 MATERIAL/SCRAP RECOVERY 0 0 0 0 0 1,000 0.00 00200 TOTAL COMMODITIES 85,230 99,000 57,788 87,523 87,623 88,650 1.29 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 4,000 3,728 3,300 2,500 3,000 3,000 20.00 05301 TELEPHONES 2,300 2,382 1,668 2,300 1,800 1,800 (21.74) 05302 TRAVEL AND TRAINING 4,000 4,645 1,941 5,000 5,000 5,000 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 1,300 2,023 1,528 1,800 1,800 1,800 0.00 05313 UTILITIES PURCH FROM WUD 267,500 266,157 195,507 132,500 132,500 132,500 0.00 05314 UTILITIES PURCH FROM OTHER 20,000 12,257 10,813 20,000 16,000 16,000 (20.00) 05319 PROFESSIONAL SERVICES 27,000 120 15,349 57,238 50,000 50,000 (12.65) 05320 MEDICAL PROFESS. SERVICES 650 94 47 650 650 650 0.00 05342 H2O QUALITY REPORT 350 0 0 350 0 0 (100.00) 05343 WATER SAMPLING 11,500 5,287 3,760 11,500 11,500 11,500 0.00 05344 DHEC/INTERAL FEES 16,000 15,105 15,105 16,000 16,000 16,000 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 44 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05345 LAB EXPENSE 32,430 33,543 26,064 32,430 32,500 32,500 0.22 05347 WASTE HANDLING 5,000 5,106 1,290 5,000 5,000 5,000 0.00 05348 GENERATOR 8,000 3,537 329 8,000 8,000 8,000 0.00 05349 SCADA MAINTENANCE 3,500 3,441 1,625 4,200 4,500 4,500 7.14 05350 PUMP STATION MAINT/REPAIR 1,000 1,000 990 1,000 1,000 1,000 0.00 05352 JANITORIAL EXPENSE 43 12 0 43 0 0 (100.00) 05358 EQUIPMENT REPAIR & MAINT. 35,000 31,765 102,524 105,028 110,817 53,500 (49.06) 05365 CONTRACTUAL SERVICES 34,100 28,479 32,577 34,100 40,000 40,000 17.30 00300 TOTAL CONTRACTUAL SERVICES 418,681 473,673 414,417 439,639 440,067 382,750 (12.94) 00600 CAPITAL OUTLAY 05636 BUILDING/OTHER IMPROVEMENTS 414,556 156,760 92,060 0 0 0 0.00 05637 OTHER EQUIPMENT 55,500 48,758 0 0 0 57,500 0.00 ** Sludge pump, backwash pump, filterbed replace ** 00600 TOTAL CAPITAL OUTLAY 205,518 470,056 92,060 0 0 57,500 0.00 550 TOTAL WATER PLANT 912,466 1,276,687 731,111 767,390 737,744 759,755 (0.99) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 45 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 650 NON DEPARTMENTAL 00700 DEBT SERVICE 05706 2014 UTILITY REV BOND PRINCIPA 285,674 285,720 243,261 292,489 292,489 292,489 0.00 05711 2014 UTILITY BOND REV INTEREST 17,040 16,993 9,001 10,225 10,225 10,225 0.00 05715 LEASE/PURCHASE 0 0 0 0 0 71,194 0.00 ** 2022 CAPITAL EQUIPMENT ** 00700 TOTAL DEBT SERVICE 302,713 302,714 252,262 302,714 302,714 373,908 23.52 00800 OTHER 05853 CONTINGENCY APPROPRIATION 0 0 0 0 0 132,157 0.00 00800 TOTAL OTHER 0 0 0 0 0 132,157 0.00 650 TOTAL NON DEPARTMENTAL 302,713 302,714 252,262 302,714 302,714 506,065 67.18 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 46 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 700 NON DEPARTMENTAL 00100 PERSONAL SERVICES 05113 PAYROLL ADJUSTMENTS 0 0 0 0 0 15,000 0.00 00100 TOTAL PERSONAL SERVICES 0 0 0 0 0 15,000 0.00 700 TOTAL NON DEPARTMENTAL 0 0 0 0 0 15,000 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: JDA Page 47 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual TOTAL EXPENDITURES 6,730,976 7,649,916 5,720,344 7,144,225 6,752,720 7,973,359 11.61 TOTAL FUND SURPLUS (DEFICIT) 741,576 (25,853) 712,828 0 (6,446,691) 0 0.00 Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: JDA Page 48 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual REVENUES 900 SOLID WASTE 00407 MISCELLANEOUS & OTHER 40700 SERVICE CHARGES 361,200 373,236 323,883 361,200 0 365,000 1.05 40703 SALE OF EQUIP/MATERIAL/SCRAP 0 0 2,809 0 0 5,000 0.00 40707 MISCELLANEOUS REV 1,216 0 0 1,000 0 1,000 0.00 40729 TRANSFER FROM GENERAL FUND 61,867 61,867 86,392 86,392 0 76,487 (11.47) 40735 INSURANCE PAID CLAIMS 0 2,895 163 0 0 0 0.00 40737 REFUNDS/REIMBURSEMENTS 0 4,603 2,812 0 0 0 0.00 00407 TOTAL MISCELLANEOUS & OTHER 442,601 424,283 416,059 448,592 0 447,487 (0.25) TOTAL REVENUES 442,601 424,283 416,059 448,592 0 447,487 (0.25) EXPENDITURES 00100 PERSONAL SERVICES 05100 SALARIES 121,710 97,093 124,029 146,884 146,884 149,822 2.00 05101 OVERTIME 10,500 3,942 8,070 8,000 8,000 8,000 0.00 05103 ANNUAL BONUS 650 420 820 820 940 940 14.63 05104 SOCIAL SECURITY 10,540 7,275 9,413 11,237 11,237 11,462 2.00 05105 RETIREMENT CONTRIBUTIONS 18,939 15,721 20,555 22,856 22,856 23,313 2.00 05106 HEALTH INSURANCE CONTRIBUTIONS 31,108 31,432 26,842 33,821 32,211 32,211 (4.76) 05107 WORKERS COMPENSATION 20,000 15,000 11,000 20,000 2,000 2,000 (90.00) Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: JDA Page 49 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 00100 TOTAL PERSONAL SERVICES 170,883 213,447 200,729 243,618 224,128 227,748 (6.51) 00200 COMMODITIES 05201 FUEL 12,000 9,970 11,162 13,754 13,800 13,800 0.33 05202 OFFICE SUPPLIES 1,000 523 262 1,000 1,000 1,000 0.00 05206 VEHICLE MAINT/REPAIR 50,000 65,195 29,926 60,000 60,000 50,000 (16.67) 05208 UNIFORMS 5,100 4,606 5,123 5,100 5,100 5,100 0.00 05209 JANITORIAL SUPPLIES 600 490 237 500 500 500 0.00 05210 MISCELLANEOUS 300 0 0 200 200 200 0.00 05211 SERVICE FEES 300 317 247 300 300 300 0.00 05212 EQUIPMENT PURCHASED 10,000 5,589 1,019 11,000 0 10,000 (9.09) 05215 BUILDING MAINT. 2,000 0 0 1,000 1,000 1,000 0.00 05216 MATERIALS - MAINT. 1,000 408 251 1,000 1,000 1,000 0.00 05222 SUPPLIES 8,000 7,078 5,312 8,000 8,000 8,000 0.00 05223 TOOLS 1,000 478 469 1,000 1,000 1,000 0.00 05225 TRASH CAN/DUMP REPLAC/PARTS 2,000 1,151 1,278 3,000 10,000 10,000 233.33 05232 MATERIAL/SCRAP RECOVERY 0 0 0 0 0 5,000 0.00 00200 TOTAL COMMODITIES 95,805 93,300 55,286 105,854 101,900 106,900 0.99 Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: JDA Page 50 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 800 799 559 900 900 900 0.00 05301 TELEPHONES 2,400 2,170 1,509 2,400 2,400 2,400 0.00 05302 TRAVEL AND TRAINING 100 0 250 100 100 100 0.00 05306 ADVERTISING 100 0 0 300 300 300 0.00 05310 MISCELLANEOUS 300 26 289 300 300 300 0.00 05313 UTILITIES PURCH FROM WUD 4,000 4,086 3,211 4,000 4,000 4,000 0.00 05319 PROFESSIONAL SERVICES 250 0 0 100 100 100 0.00 05320 MEDICAL PROFESS. SERVICES 800 237 128 500 500 500 0.00 05323 VEHICLE & PROPERTY INSURANCE 7,000 7,000 668 7,000 7,000 7,000 0.00 05357 EQUIPMENT RENTAL/LEASE 1,000 0 0 1,000 1,000 1,000 0.00 05358 EQUIPMENT REPAIR & MAINT. 10,000 1,144 1,570 10,000 10,000 10,000 0.00 05360 HAND POWER / HYDRAULIC TOOLS 5,000 210 370 3,000 3,000 3,000 0.00 05361 HEAVY DUTY EQUIP RENT/LEASE 1,000 0 0 1,000 1,000 1,000 0.00 05365 CONTRACTUAL SERVICES 5,000 6,090 4,520 5,000 5,000 18,720 274.40 ** temp person $18 hr 9 months ** 05374 GARBAGE PERMIT FEES 250 120 120 250 250 250 0.00 Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: JDA Page 51 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 00300 TOTAL CONTRACTUAL SERVICES 21,882 38,000 13,194 35,850 35,850 49,570 38.27 00700 DEBT SERVICE 05708 GARB TRK W/DUMPSTERS PRINCIPAL 29,348 29,348 0 30,005 0 30,677 2.24 05709 KNUCKLE BOOM PAYMENT PRINCIPAL 28,278 28,278 28,982 28,983 0 29,704 2.49 05712 GARB TRK W/DUMPSTERS INTEREST 2,719 2,719 0 2,062 0 1,390 (32.59) 05713 KNUCKLE BOOM PAYMENT INTEREST 2,923 2,923 2,220 2,220 0 1,498 (32.52) 00700 TOTAL DEBT SERVICE 63,268 63,268 31,202 63,270 0 63,269 0.00 900 TOTAL SOLID WASTE (90,763) (16,268) (115,648) 0 361,878 0 0.00 Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: JDA Page 52 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual TOTAL EXPENDITURES 351,838 408,015 300,411 448,592 361,878 447,487 (0.25) TOTAL FUND SURPLUS (DEFICIT) 90,763 16,268 115,648 0 (361,878) 0 0.00 Budget Worksheet 040-FIRE DEPARTMENT 1% FUND CITY OF WESTMINSTER Run By: JDA Page 53 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual REVENUES 004 REVENUE 00407 MISCELLANEOUS & OTHER 40707 MISCELLANEOUS REV 14,598 11,997 12,386 14,500 14,500 14,500 0.00 00407 TOTAL MISCELLANEOUS & OTHER 11,997 14,598 12,386 14,500 14,500 14,500 0.00 004 TOTAL REVENUE 11,997 14,598 12,386 14,500 14,500 14,500 0.00 Budget Worksheet 040-FIRE DEPARTMENT 1% FUND CITY OF WESTMINSTER Run By: JDA Page 54 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual TOTAL REVENUES 11,997 14,598 12,386 14,500 14,500 14,500 0.00 EXPENDITURES 005 EXPENSE 00515 EXPENSE 05310 MISCELLANEOUS 14,598 3,292 1,455 14,500 14,500 14,500 0.00 00515 TOTAL EXPENSE 3,292 14,598 1,455 14,500 14,500 14,500 0.00 005 TOTAL EXPENSE 3,292 14,598 1,455 14,500 14,500 14,500 0.00 Budget Worksheet 040-FIRE DEPARTMENT 1% FUND CITY OF WESTMINSTER Run By: JDA Page 55 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual TOTAL EXPENDITURES 3,292 14,598 1,455 14,500 14,500 14,500 0.00 TOTAL FUND SURPLUS (DEFICIT) 8,705 0 10,931 0 0 0 0.00 Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: JDA Page 56 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual REVENUES 400 RECREATION 00401 INTERGOVENMENTAL REV 40101 COUNTY ALLOCATION 30,000 30,000 30,000 30,000 0 30,000 0.00 00401 TOTAL INTERGOVENMENTAL REV 30,000 30,000 30,000 30,000 0 30,000 0.00 00402 LICENSE, PERMITS, & FEES 40206 ADMISSION 58,714 33,401 15,260 48,000 0 58,714 22.32 40207 CONCESSIONS 39,000 25,934 16,215 38,000 0 39,000 2.63 40208 REGISTRATION 68,714 48,950 38,120 55,000 0 68,714 24.93 40209 SPONSOR FEES 32,506 18,020 10,690 20,000 0 32,506 62.53 40213 TOURNAMENT FEE 1,500 600 375 1,500 0 1,500 0.00 00402 TOTAL LICENSE, PERMITS, & FEES 126,905 200,434 80,660 162,500 0 200,434 23.34 00406 GRANT INCOME 40600 PARD GRANT 10,000 0 4,320 21,500 0 10,000 (53.49) 00406 TOTAL GRANT INCOME 0 10,000 4,320 21,500 0 10,000 (53.49) 00407 MISCELLANEOUS & OTHER 40702 DONATIONS 8,500 9,241 1,478 8,500 0 8,500 0.00 40703 SALE OF EQUIP/MATERIAL/SCRAP 4,000 2,470 6,607 5,000 0 4,000 (20.00) 40707 MISCELLANEOUS REV 1,000 0 0 1,000 0 1,000 0.00 40729 TRANSFER FROM GENERAL FUND 210,000 210,000 187,491 187,491 0 154,314 (17.70) Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: JDA Page 57 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 40730 HTAX TRANSFER 0 0 0 25,000 0 111,621 346.48 40737 REFUNDS/REIMBURSEMENTS 0 1,204 1,323 0 0 0 0.00 00407 TOTAL MISCELLANEOUS & OTHER 222,915 223,500 196,899 226,991 0 279,435 23.10 TOTAL REVENUES 379,820 463,934 311,879 440,991 0 519,869 17.89 EXPENDITURES 00100 PERSONAL SERVICES 05100 SALARIES 49,933 49,933 43,096 50,931 50,932 85,230 67.34 ** HALF OF HERB'S AND NEW POSITION TO COME FROM F&B ** 05103 ANNUAL BONUS 2,010 1,410 1,740 2,040 1,870 1,870 (8.33) 05104 SOCIAL SECURITY 9,940 8,902 7,555 10,203 6,881 9,561 (6.29) ** 3261.00 FROM F&B ** 05105 RETIREMENT CONTRIBUTIONS 7,770 8,832 9,153 10,925 13,994 19,332 76.95 ** 6632.00 FROM F&B ** 05106 HEALTH INSURANCE CONTRIBUTIONS 5,289 5,876 4,197 5,288 5,037 17,226 225.76 05107 WORKERS COMPENSATION 9,000 7,500 7,200 9,000 9,000 9,000 0.00 05109 PART TIME EMPLOYEES 81,492 66,272 54,971 83,445 39,000 84,000 0.67 00100 TOTAL PERSONAL SERVICES 148,725 165,434 127,912 171,832 126,714 226,219 31.65 00200 COMMODITIES 05201 FUEL 4,500 3,231 2,656 4,500 4,500 4,500 0.00 05202 OFFICE SUPPLIES 3,000 1,337 1,461 3,000 3,000 3,000 0.00 05206 VEHICLE MAINT/REPAIR 5,000 3,597 2,983 4,500 4,500 4,500 0.00 Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: JDA Page 58 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05208 UNIFORMS 45,000 22,266 18,509 45,000 45,000 45,000 0.00 05209 JANITORIAL SUPPLIES 1,500 672 239 1,500 1,500 1,500 0.00 05210 MISCELLANEOUS 500 0 300 500 500 500 0.00 05211 SERVICE FEES 200 337 272 200 200 200 0.00 05212 EQUIPMENT PURCHASED 1,600 432 1,280 2,600 2,600 2,600 0.00 00200 TOTAL COMMODITIES 31,872 61,300 27,700 61,800 61,800 61,800 0.00 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 2,700 1,728 1,118 2,700 2,700 2,700 0.00 05301 TELEPHONES 3,000 2,382 1,668 3,000 3,000 3,000 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 2,500 471 1,745 2,500 3,500 3,500 40.00 05306 ADVERTISING 250 210 100 500 500 500 0.00 05310 MISCELLANEOUS 600 3,994 414 600 600 600 0.00 05313 UTILITIES PURCH FROM WUD 60,000 57,275 45,738 61,000 61,000 61,000 0.00 05314 UTILITIES PURCH FROM OTHER 250 187 150 250 250 250 0.00 05320 MEDICAL PROFESS. SERVICES 500 379 379 500 500 500 0.00 05323 VEHICLE & PROPERTY INSURANCE 1,500 1,500 0 1,500 1,500 1,500 0.00 05328 CUSTOMER REFUNDS 600 11,530 5,290 1,000 1,000 1,000 0.00 Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: JDA Page 59 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 05330 TROPHY AWARDS 10,000 6,645 2,505 10,000 10,000 10,000 0.00 05331 INSURANCE EXPENSE 900 266 0 900 900 900 0.00 05332 OFFICIALS EXPENSE 22,000 16,098 9,904 27,000 27,000 27,000 0.00 05333 SPORTS/EQUIP SUPPLIES 20,000 4,834 10,880 25,000 25,000 25,000 0.00 05334 GROUNDS EXPENSE 22,000 20,608 14,708 24,009 24,000 24,000 (0.04) 05335 TOURNAMENT EXPENSE 5,000 2,314 1,249 5,000 5,000 5,000 0.00 05337 CONCESSIONS 20,000 12,520 7,773 20,000 20,000 20,000 0.00 05357 EQUIPMENT RENTAL/LEASE 400 0 749 400 400 400 0.00 05365 CONTRACTUAL SERVICES 0 0 0 0 0 35,000 0.00 00300 TOTAL CONTRACTUAL SERVICES 142,941 172,200 104,370 185,859 186,850 221,850 19.36 00600 CAPITAL OUTLAY 05607 FIELD/FACILITY IMPROVEMENTS 30,000 30,000 30,516 21,500 30,000 10,000 (53.49) ** COUNTY ALLOCATION/PARD EXPENSE ** 00600 TOTAL CAPITAL OUTLAY 30,000 30,000 30,516 21,500 30,000 10,000 (53.49) 400 TOTAL RECREATION (26,282) (35,000) (21,381) 0 405,364 0 0.00 Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: JDA Page 60 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual TOTAL EXPENDITURES 353,538 428,934 290,498 440,991 405,364 519,869 17.89 TOTAL FUND SURPLUS (DEFICIT) 26,282 35,000 21,381 0 (405,364) 0 0.00 Budget Worksheet 060-LOCAL DEVELOPMENT CORP CITY OF WESTMINSTER Run By: JDA Page 61 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual REVENUES 700 NON DEPARTMENTAL 00407 MISCELLANEOUS & OTHER 40707 MISCELLANEOUS REV 16,500 16,896 16,886 16,500 16,500 16,500 0.00 00407 TOTAL MISCELLANEOUS & OTHER 16,896 16,500 16,886 16,500 16,500 16,500 0.00 TOTAL REVENUES 16,896 16,500 16,886 16,500 16,500 16,500 0.00 EXPENDITURES 00300 CONTRACTUAL SERVICES 05310 MISCELLANEOUS 16,500 40,502 7,900 16,500 16,500 16,500 0.00 00300 TOTAL CONTRACTUAL SERVICES 40,502 16,500 7,900 16,500 16,500 16,500 0.00 TOTAL EXPENDITURES 40,502 16,500 7,900 16,500 16,500 16,500 0.00 TOTAL FUND SURPLUS (DEFICIT) (23,606) 0 8,986 0 0 0 0.00 Budget Worksheet 080-HOSPITALITY FUND CITY OF WESTMINSTER Run By: JDA Page 62 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual REVENUES 00407 MISCELLANEOUS & OTHER 40724 FOOD & BEV TAX 162,800 134,397 258,734 140,000 140,000 162,800 16.29 40728 FUND BALANCE 0 0 0 0 0 266,121 0.00 40741 TRANSFER FROM ATAX 0 0 0 0 0 2,300 0.00 00407 TOTAL MISCELLANEOUS & OTHER 134,397 162,800 258,734 140,000 140,000 431,221 208.02 TOTAL REVENUES 134,397 162,800 258,734 140,000 140,000 431,221 208.02 EXPENDITURES 00300 CONTRACTUAL SERVICES 05310 MISCELLANEOUS 6,000 0 7,525 5,000 5,000 5,000 0.00 05380 DOWNTOWN EVENTS/REPAIRS 50,500 22,227 2,850 4,000 4,000 25,000 525.00 05382 TRANSFER TO GENERAL FUND 61,000 16,000 50,000 106,000 106,000 62,600 (40.94) 05383 PUBLIC RELATIONS/PROMOTIONS 0 0 0 0 0 12,000 0.00 05384 TRANSFER TO YOUTH RECREATION 0 0 0 0 0 111,621 0.00 05388 GRANT MATCH 0 0 0 25,000 25,000 25,000 0.00 00300 TOTAL CONTRACTUAL SERVICES 38,227 117,500 60,375 140,000 140,000 241,221 72.30 00600 CAPITAL OUTLAY 05607 FIELD/FACILITY IMPROVEMENTS 0 0 0 0 0 150,000 0.00 05630 SPECIAL EVENTS 10,000 11,450 990 0 0 0 0.00 05643 HALL STREET PURCHASE 0 0 162,288 0 0 0 0.00 Budget Worksheet 080-HOSPITALITY FUND CITY OF WESTMINSTER Run By: JDA Page 63 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual 00600 TOTAL CAPITAL OUTLAY 11,450 10,000 163,278 0 0 150,000 0.00 00800 OTHER 05800 GRANTS 35,300 35,300 18,600 0 0 40,000 0.00 00800 TOTAL OTHER 35,300 35,300 18,600 0 0 40,000 0.00 TOTAL EXPENDITURES 84,977 162,800 242,253 140,000 140,000 431,221 208.02 TOTAL FUND SURPLUS (DEFICIT) 49,420 0 16,481 0 0 0 0.00 Budget Worksheet 090-LOCAL ACCOMMODATION CITY OF WESTMINSTER Run By: JDA Page 64 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual REVENUES 00401 INTERGOVENMENTAL REV 40103 STATE ACCOM. TAX 4,000 4,724 0 4,000 4,000 4,000 0.00 00401 TOTAL INTERGOVENMENTAL REV 4,724 4,000 0 4,000 4,000 4,000 0.00 00407 MISCELLANEOUS & OTHER 40725 LOCAL ACCOM REVENUE 2,300 2,079 1,623 2,300 2,300 2,300 0.00 00407 TOTAL MISCELLANEOUS & OTHER 2,079 2,300 1,623 2,300 2,300 2,300 0.00 TOTAL REVENUES 6,803 6,300 1,623 6,300 6,300 6,300 0.00 EXPENDITURES 00800 OTHER 05801 TRANSFER TO CITY GF 4,000 0 0 4,000 4,000 4,000 0.00 05821 TOURISM PROMOTION 2,300 0 0 2,300 2,300 0 (100.00) 05823 TRANSFER TO HTAX 0 0 0 0 0 2,300 0.00 00800 TOTAL OTHER 0 6,300 0 6,300 6,300 6,300 0.00 700 TOTAL NON DEPARTMENTAL (32,617) 0 (27,090) 0 0 0 0.00 Budget Worksheet 090-LOCAL ACCOMMODATION CITY OF WESTMINSTER Run By: JDA Page 65 of 65 5/7/2021 8:45:00AM *** Previous Year *** 2020 *** Next Year *** 2022*** Current Year *** 2021 Pct IncFinalAdmin RcmdDept ReqBudgetYTD ActualBudgetYTD Actual TOTAL EXPENDITURES 0 6,300 0 6,300 6,300 6,300 0.00 TOTAL FUND SURPLUS (DEFICIT) 6,803 0 1,623 0 0 0 0.00 Field Value Selected Options Rev / Exp Delete Next Year Include Encum Print Comments Round to Nearest $ Export to File File Path / Name Report Type Request 1 Header Request 2 Header Request 3 Header Skip Zero / No Activity Administrative Dept Req Admin Rcmd Final Both No No Yes Yes Yes No Yes Yes Ranges Field From To Total Npg Fiscal Year Level 1 Level 2 Level 3 Level 4 2021 ALL ALL Yes ALL NoYes ALL Application: ACCOUNTING SUITE Service Pack: 7.1.21 Export Name: BUDPXP02 Export Version: VM-0711000Y Template Name: 0000_BUD_BudgetWorksheet.rpt Report Summary

Source: City of Westminster website. First collected Oct 31, 2026.