RecordWell Data

2021 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.

BUDGET YEAR 2020-2021 70% General Utility Solid Waste Fire Dept 1% Youth Recreation Local Development Corp. Hospitality Local Accomodation 20% 5% 4% 1% 0% 0% 0% City of Westminster Budget BUDGET MESSAGE June 12th, 2020 Honorable Mayor Brian Ramey and City of Westminster Council: In the accompanying pages is a recommended Budget for the fiscal year July 1, 2020 to June 30, 2021. This budget document contains exhibits such as summary of fund expenditures and a schedule of inter-fund transfers. In addition to these exhibits there is a complete 65 page “line-item” budget. At the rear of the document are the proposed budget ordinance and a copy of the public notice. After the required public hearing, any changes made during the deliberation can be incorporated into the final reading which is scheduled for Tuesday June 16 th. Budget “Basics” Each Fund is balanced and a summary of each of the 8 Funds is attached as Exhibit A. “Fund” accounting is basic and integral to municipal budgeting. Funds are classified by type. Governmental Funds, such as the General and Hospitality, derive their main sources of revenue from taxes or mandatory fees. Proprietary funds are those such as the Utility Fund and Solid Waste Fund which rely solely or primarily on user charges for support. There are “hybrids as well such as the Youth Recreation Fund that relies on both a transfer from the General Fund as the largest source, but have fees and other user revenue to support a part of the program. A third type of Fund is a Special Purpose Fund whose use is restricted by state law for specific purposes. The Fire Dept. 1% Fund is an example. Transfers between funds are integral to the budgeting process in Westminster. Principally these transfers are to the General Fund from either the Utility Fund or Hospitality Fund. The General Fund appropriates to the Solid Waste Fund to subsidize the cost of collection and to the Youth Recreation Fund for subsidy of its programs. A diagram of inter-fund transfers is marked as Exhibit B. Capital expenditures are directed toward replacement of equipment and continue rehabilitation of the electrical system and water treatment plant. The Utility Fund has historically supported our General Fund through imposition of a Westminster Utility Franchise Fee (WUD Franchise) or inter-fund transfer. Historically, this amount has fluctuated. In the last two years the Council has attempt to keep this transfer in the 5% to 6% range of total customer charges for electric, water and sewer service. Utility fund transfers are not an uncommon practice but are used to reimburse the General Fund for administrative costs of the City not directly allocated in the Utility Fund itself. Our budget ordinance contains a Section 6 specifying the purposes for which the WUD franchise fee is imposed. Here is an example. There are software costs used for the governmental function of the General Fund that can‘t be broken out precisely and an indirect allocation of cost has to be made based on observation. A simpler, but albeit insignificant, example is cost of copier use. It becomes trivial to determine how much should be allocated at some point to either the General Fund or Utility Fund so assumptions have to be made. The more obvious matters like the time of the administrative staff, insurance premiums, and audit expenses are prorated and directly budgeted as a proportional expense to the appropriate Utility Fund. FUND 10 – The General Fund The General Fund is the second largest in the City Budget. It is meant to account for services normally considered “governmental” in nature. Examples, police, fire, codes enforcement and public works functions. Traditionally through the administrative function it supports the other departments like the Utility, Solid Waste and Youth Recreation Fund. Administrative costs include salaries for administrative staff, Governing Body expense, payment of overall computer hardware and software support, insurance expenses and the cost of compliance with state and federal regulations dealing with personnel. Revenues for Fund 10 In summary, the overall estimate for General fund revenues is relatively flat. The revenues for the General Operating Budget consist of the proceeds of the tax levy, franchise taxes, county reimbursement for the fire protection contract, state shared revenues based on reimbursements of previously collected taxes, and other sources such as fees, fines, and interests on investments. The revenues are estimated by past and current revenue collection trend. The following table sets forth the estimated collection based on the last available data. Keeping the current levy of 99.3 mils cents based on a total evaluation of real, personal including vehicle tax should generate total tax revenues of approximately $ using the tax collection rate of 97%. The City imposes a Westminster Utility Tax equaling 7.51% of electric, water, & sewer charges it is estimated to be on the order of $495,106, and would rank as the second largest single revenue source behind property taxes The third largest source of revenue is the annual fire protection contract, value $285,000, with Oconee County for which the fire department provides emergency responses outside the corporate limits of Westminster. There are no fund balance appropriations included in this year’s budget to balance the General Fund. Expenditures for Fund 10 Here is a listing of significant highlights in, or impacts to the General Fund:  A 2 % cost of living adjustment for personnel beginning the first pay period of FY 2020- 2021 which increased salary expense $19,721. • The City budgeted to continue with the codes enforcement effort and for the first time appropriated funds to remove blighted structures. While a minimal amount, $5,000, this first year appropriation is Westminster City Assessed and Market Values TAX YEAR 2018 FISCAL YEAR 2019 Vehicle Ratio 6.0 Implemented Reassessment Year Property Type Assessed Value Market Value Real Property $ 4,827,680 $ 107,281,778 Personal Property/ DOR $ 800,824 $ 7,626,895 Vehicles $ 671,791 $ 11,196,517 Total $ 6,300,295 $ 126,105,190 Value of a Mill $ 6,300 symbolic in that the City is continuing to address blighted housing and commercial buildings. Of course the City utilizes existing state legislation through its ordinances to recoup the cost from property owners, but the City must advance the work through a contractor and hence the need for this type expenditure. • There are minimal capital expenditures in the General Fund: $31,000 for equipment and is exclusive to the Police and Fire Departments. FUND 20 –The Utility Fund Fund 20 accounts for providing service to approximately, 1,502 electric, 3,402 water and 1,101 sewer customers. This requires not only staffing, but regular investment into infrastructure to keep these services reliable. Unfortunately it has the largest exposure to unforeseen and major expenses such as the emergency water line relocation we undertook this spring. Revenues for Fund 20 Monthly charges for services are the largest source of revenue. The City also needs to replace revenue that helped pay annual debt service, not accounted for in the water plant cost calculation. There are also revenue requirements for repair to the water plant and replacement of equipment necessitating a continuation of the $7.00 AMI fee. The revenues by type are summarized in Exhibit A under the heading: Utility Fund. Expenditures for Fund 20 Here is a listing of significant highlights in, or impacts to the Utility Fund: • The impact of 2% across the board increase for employees is estimated to be $31,386. • The City last year, and will again this year, program funds for right-of-way maintenance (tree & underbrush removal) Amounts allocated for electric lines is $90,000 and for sewer mains $25,000 as ongoing operational expenses. $62,000 is budgeted for a sleeve for one of the river pumps at the raw water intake on the Chauga River. • Capital expenses include funds for the completion of Phase 3 and 4 conversion of the distribution system to 7200kV. • Debt service payments of principal and interest are budgeted in the amount of $302,714 for revenue bond obligations incurred in 2014. FUND 30- The Solid Waste Fund This Fund accounts for the collection and disposal of garbage, yard waste and brown goods in Westminster. In addition to fees the Fund receives a subsidy from the General Fund. Revenues and Expenditures for Fund 30 • Debt service payment of principal and interest are budgeted in the amount of $63,270 for both the garbage truck and the knuckle boom truck. FUND 40 – Fire Department 1% Fund The revenues source for this fund is a 1% premium tax on fire insurance policies in Westminster and a prorated amount from the area outside Westminster covered by the fire protection contract with Oconee County. Its expenditures are reserved by law for expenses at the Fire Department that include fire prevention materials, attendance at professional conferences, dues payable to professional associations, and holiday dinner for volunteers and employees. This Fund accounts for less than $15,000 annual in revenues and expenditures and has no staff expenditures. FUND 50 – Youth Recreation Fund This fund provides for a youth recreation program that serves Westminster and surrounding areas. Approximately 44 % of the cost of the program is raised through fees, sponsorships, admission, concession sales and registration fees. The City’s General Fund makes an appropriation of $185,000 to subsidize the cost of Youth Recreation. Within age groupings from 6 years and younger up unto age 19, both male and female are offered 11 different sports/activities with over 850 participants involved annually. There is only one paid employee in the Department which is the Director. However the City appropriates over $80,000 in seasonal, and 3 permanent part-time employee for program support and maintenance of the grounds and buildings. The only capital item is $21,500 for field improvements at the pool field concerning the bathrooms. FUND 60 - Economic Development Fund This Fund and its revenues are available to the non-profit Westminster Local Economic Development Commission for programs to promote economic development in the City. Its sole program at present, and the focus of the expenditures, is the Commercial Building Improvement Grant Program. Its source of revenue for the past two years has been an economic development grant from Piedmont Municipal Power Agency which directs its annual $16,480 appropriation for the CBIG program. FUND 80- Hospitality Tax Fund This Fund collects and disburses a 2% tax on prepared meals in the City. The tax is collected monthly. Expenditures are made in accordance with Section 6-1-730 toward tourism development including advertising, tourism related buildings, civic centers etc., some cost associated by police and fire to service tourism related events. This Fund this year includes the second $40,000 payment on the lease/purchase option on the Hall Street property. The City also appropriates from this Fund for expenditures to outside agencies that promote tourism for Westminster. The City also makes available funds to promote special events such as festivals through its own Special Events Committee, a volunteer organization. FUND 90 – State and Local A-Tax As implied these are two separate taxes. The State A-Tax is a mandatory 2% charge is applied to all accommodations statewide and reallocated back to each municipality by formula. A separate 1.5% tax on the gross proceeds of any accommodations rental is collected by Westminster. By law the first $25,000 of the State A-Tax goes to the General Fund as revenue. The Local A-Tax must be used for advertising and promotion of the City. Both funds generate approximately $6,300 each year. Summary Remarks In addition to the following two exhibits designated as A & B, greater detail can be found in the 65 pages of the line item budget for each Department within each Fund. This Budget document, used in conjunction with the Westminster Budget Book, which can be found online at http://www.westminstersc.org/financial-transparency under the “Financial Transparency” tab, offers detailed insight into exact expenditures being proposed in the upcoming FY 2021 Budget. I would like to thank Ms. Kiley Carter for her help and assistance, without which this endeavor would have been much more difficult for everyone involved. Submitted: June 12th, 2020 Jennifer Adams Jennifer Adams, City Clerk Treasurer Total $ 448,592 Total $ 6,300 FY 20-21 BUDGET SUMMARY EXHIBIT A General Fund Totals Expenditures Revenues Administration $ 417,395 All Taxes $ 630,300 Fire $ 470,864 Intergovernmental Revenue $ 345,000 Police $ 700,594 License, Permits, Fees $ 336,092 Pool Fines &Forfeitures $ 43,000 Codes $ 30,850 Payment in Lieu of Tax & Franchise Fees $ 553,606 Public Works $ 140,200 Interest income $ 1,203 Difference between Revenue & Expenses Utility Totals Expenditures Revenues Utility Administration $ 1,079,933 Interest Income $ 500 Electric $ 3,565,342 Miscellaneous & Other $ 504,168 Water $ 608,603 Electric $ 4,112,200 Sewer $ 820,243 Water $ 1,889,932 Water Plant $ 767,390 Sewer $ 622,000 Non-Departmental $ 302,714 Project Operations $ - Unbudgeted Revenue $ 15,425 Total $ 7,144,225 Total $ 7,144,225 Difference between Revenue & Expenses $ - Solid Waste Totals Expenditures Revenues Personel Services $ 243,618 Fees $ 361,200 Commodities $ 105,854 Proceeds from Borrowing $ - Contractual Services $ 35,850 Other, Interest Income $ 1,000 Debt Service $ 63,270 Transfer from General Fund $ 86,392 Fire Department 1% Totals Revenues Misc. & Other $ 14,500 Total $ 14,500 Difference between Revenue & Expenses $ - Youth Recreation Fund Expenditures Revenues Personal Services $ 171,832 Intergovernmental Revenue $ 30,000 Commodities $ 61,800 License, Permits, & Fees $ 162,500 Contractual Services $ 185859 Grant Income $ 21,500 Capital Outlay $ 21,500 Misc. & Other $ 226,991 Total $ 440,991 Difference between Revenue & Expenses Local Development Corp Totals Hospitality Fund Totals Revenues Misc. & Other $ 16,500 Total $ 16,500 Difference Between Revenue & Expenses $ - Revenues Difference Between Revenue & Expenses State & Local Accom. Totals Expenditures Revenues Intergovernmental Revenue $ 4,000 Misc. & Other $ 2,300 Difference Between Revenue & Expenses 16,500 $ - $ - 1 EXHIBIT B H Tax Fund Retreat St. Park $50,000 H Tax Fund Public Safety $16,000 Utility Fund Franchise Fee $495,106 Solid Waste Fund Garbage Subsidy $86,392 Youth Recreation Subsidy $187,491 A Tax Fund State Accomodation Tax $4,000 General Fun H Tax Fund Hall Street Lease Payment $40,000 Version 6/12/2020 2 EXHIBIT B Schedule of Interfund Transfers Fund To Amount Purpose Utility General $495,106 Franchise General Solid Waste $86,392 Subsidy H Tax General $16,000 Public Safety H Tax General $50,000 Retreat Street Park H Tax General $40,000 Hall Street Lease Payment H Tax Youth Recreation $25,000 Subsidy A Tax General $4,000 State Accom. Tax General Youth Recreation $187,491 Subsidy GRAND TOTAL 903,989 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 1 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct REVENUES 100 ADMINISTRATION 00400 PROPERTY TAXES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40000 PROPERTY TAXES 472,572 476,476 459,122 496,872 475,000 475,000 (4.40) 40001 DELIQUENT TAXES 20,506 36,000 22,495 30,000 30,000 30,000 0.00 40002 VEHICLE TAXES 66,333 68,000 69,674 65,000 65,000 65,000 0.00 40003 HOMESTEAD EXPT. STATE 54,570 55,000 53,801 54,000 54,000 54,000 0.00 40004 MERCHANTS INVT. TAX 6,323 6,300 6,323 6,300 6,300 6,300 0.00 00400 TOTAL PROPERTY TAXES 620,304 641,776 611,415 652,172 630,300 630,300 (3.35) 00401 INTERGOVENMENTAL REV 40102 AID TO SUBDIVISION 56,715 56,800 57,328 56,000 56,000 56,000 0.00 40103 STATE ACCOM. TAX 3,047 4,700 0 4,000 4,000 4,000 0.00 40105 TRANSPORTATION NETWORK ACT 0 0 4 0 0 0 0.00 00401 TOTAL INTERGOVENMENTAL REV 59,762 61,500 57,332 60,000 60,000 60,000 0.00 00402 LICENSE, PERMITS, & FEES 40200 BUSINESS LICENSE 82,731 108,000 59,534 70,000 70,000 81,182 15.97 40202 TELECOM. TAX MASC 6,317 6,500 5,688 6,500 6,500 6,500 0.00 40203 BROKER TAX MASC 5,016 5,016 4,053 4,500 5,000 5,000 11.11 40205 INSURANCE TAX 22,058 209,000 22,373 180,000 210,000 210,000 16.67 40214 CELL TOWER RENT 25,700 26,700 26,200 26,700 26,700 26,700 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 2 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40215 FACILITY RENTAL 8,525 9,700 6,580 6,000 6,000 6,330 5.50 40216 FOIA REQUEST FEES 0 0 143 0 30 30 0.00 00402 TOTAL LICENSE, PERMITS, & FEES 150,347 364,916 124,571 293,700 324,230 335,742 14.31 00404 PYMT IN LIEU OF TAX & FRAN FEE 40400 PAYMENT IN LIEU OF TAX 3,510 3,510 1,780 3,500 3,500 3,500 0.00 40401 FRANCHISE FEES 54,843 54,700 55,441 56,000 50,000 55,000 (1.79) 40402 WUD FRANCISE FEE 336,000 336,000 432,927 432,927 329,632 495,106 14.36 ** 7.51% WATER, SEWER, & ELECTRIC SALES. 2.4% IS FOR 2 COP POSITIONS AND $1.61 AN HOUR ACROSS THE BOARD IN POLICE DPT ** 00404 TOTAL PYMT IN LIEU OF TAX & FRAN FEE 394,353 394,210 490,148 492,427 383,132 553,606 12.42 00405 INTEREST INCOME 40500 INTEREST INCOME 1,929 1,000 0 1,000 1,000 1,000 0.00 00405 TOTAL INTEREST INCOME 1,929 1,000 0 1,000 1,000 1,000 0.00 00406 GRANT INCOME 40602 STATE GRANTS 0 0 125,000 125,000 0 0 (100.00) 00406 TOTAL GRANT INCOME 0 0 125,000 125,000 0 0 (100.00) 00407 MISCELLANEOUS & OTHER 40700 SERVICE CHARGES 0 60 0 60 60 60 0.00 40703 SALE OF EQUIP/MATERIAL/SCRAP 0 25 0 25 25 25 0.00 40707 MISCELLANEOUS REV 44,899 56,644 112 16,600 10,000 10,000 (39.76) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 3 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40734 COURT ORDERED RESTITUTION 0 0 2,050 2,000 2,000 2,000 0.00 40735 INSURANCE PAID CLAIMS 0 0 1,516 1,516 0 0 (100.00) 40736 GHS FACILITY REIMBURSEMENT 0 0 4,200 4,200 4,200 4,200 0.00 40737 REFUNDS/REIMBURSEMENTS 0 0 23,869 8,226 1,000 1,000 (87.84) 00407 TOTAL MISCELLANEOUS & OTHER 44,899 56,729 31,747 32,627 17,285 17,285 (47.02) 100 TOTAL ADMINISTRATION 1,271,594 1,520,131 1,440,213 1,656,926 1,415,947 1,597,933 (3.56) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 4 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 200 FIRE DEPARTMENT 00401 INTERGOVENMENTAL REV YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40101 COUNTY ALLOCATION 285,000 285,000 285,000 285,000 285,000 285,000 0.00 00401 TOTAL INTERGOVENMENTAL REV 285,000 285,000 285,000 285,000 285,000 285,000 0.00 00405 INTEREST INCOME 40500 INTEREST INCOME 229 557 215 200 200 200 0.00 00405 TOTAL INTEREST INCOME 229 557 215 200 200 200 0.00 00407 MISCELLANEOUS & OTHER 40716 FIRE PREVENTION 0 350 0 350 300 300 (14.29) 00407 TOTAL MISCELLANEOUS & OTHER 0 350 0 350 300 300 (14.29) 200 TOTAL FIRE DEPARTMENT 285,229 285,907 285,215 285,550 285,500 285,500 (0.02) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 5 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 300 POLICE 00403 FINES & FORFEITURES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40300 POLICE FINES 30,914 45,000 24,665 35,000 30,000 30,000 (14.29) 40302 DRUG SEIZURES 14,959 15,101 0 13,000 13,000 13,000 0.00 00403 TOTAL FINES & FORFEITURES 45,873 60,101 24,665 48,000 43,000 43,000 (10.42) 00405 INTEREST INCOME 40500 INTEREST INCOME 8 0 9 3 3 3 0.00 00405 TOTAL INTEREST INCOME 8 0 9 3 3 3 0.00 00407 MISCELLANEOUS & OTHER 40704 POLICE FUND 1,980 1,950 1,460 1,200 1,500 1,500 25.00 00407 TOTAL MISCELLANEOUS & OTHER 1,980 1,950 1,460 1,200 1,500 1,500 25.00 300 TOTAL POLICE 47,861 62,051 26,134 49,203 44,503 44,503 (9.55) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 6 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 500 CODES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 00402 LICENSE, PERMITS, & FEES 40211 SIGN PERMIT FEES 200 50 150 0 200 200 0.00 40212 ZONING HEARINGS 225 75 150 75 150 150 100.00 00402 TOTAL LICENSE, PERMITS, & FEES 425 125 300 75 350 350 366.67 500 TOTAL CODES 425 125 300 75 350 350 366.67 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 7 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 700 NON DEPARTMENTAL 00407 MISCELLANEOUS & OTHER YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40730 HTAX TRANSFER 0 16,000 16,000 61,000 106,000 106,000 73.77 ** 16,000 FOR PUBLIC SAFETY 50,000 FOR RETREAT STREET PARK 40,000 FOR HALL STREET LAND PURCHASE ** 00407 TOTAL MISCELLANEOUS & OTHER 0 16,000 16,000 61,000 106,000 106,000 73.77 700 TOTAL NON DEPARTMENTAL 0 16,000 16,000 61,000 106,000 106,000 73.77 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 8 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc TOTAL REVENUES 1,605,109 1,884,214 1,767,862 2,052,754 1,852,300 2,034,286 (0.90) EXPENDITURES 100 ADMINISTRATION 00100 PERSONAL SERVICES 05100 SALARIES 89,314 89,311 88,467 91,990 93,827 93,827 2.00 05101 OVERTIME 0 0 0 500 0 0 (100.00) 05102 MAYOR/COUNCIL SALARIES 14,300 14,300 14,300 14,300 14,300 14,300 0.00 05103 ANNUAL BONUS 1,410 1,410 0 1,500 1,590 1,590 6.00 05104 SOCIAL SECURITY 7,838 6,833 7,701 7,038 7,177 7,177 1.97 05105 RETIREMENT CONTRIBUTIONS 14,242 13,004 15,123 14,314 15,538 14,600 2.00 05106 HEALTH INSURANCE CONTRIBUTIONS 7,657 6,340 15,957 10,401 10,401 10,401 0.00 05107 WORKERS COMPENSATION 2,000 2,200 2,000 2,000 2,000 2,000 0.00 05108 EMPLOYEE BONDING 3,750 5,000 3,750 5,000 5,000 5,000 0.00 05112 UNEMPLOYEMENT INSURANCE REIMBU 0 500 0 250 0 0 (100.00) 05114 VEHICLE ALLOWANCE 2,500 2,500 1,923 2,500 2,500 2,500 0.00 00100 TOTAL PERSONAL SERVICES 143,011 141,398 149,221 149,793 152,333 151,395 1.07 00200 COMMODITIES 05200 POSTAGE 1,163 1,400 1,055 1,800 1,200 1,200 (33.33) 05202 OFFICE SUPPLIES 3,368 4,700 5,352 6,700 4,500 4,500 (32.84) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 9 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05209 JANITORIAL SUPPLIES 153 350 350 350 350 350 0.00 05210 MISCELLANEOUS 1,987 3,000 2,313 2,400 2,400 2,400 0.00 05211 SERVICE FEES 1,705 2,000 2,504 2,700 2,000 2,000 (25.93) 05212 EQUIPMENT PURCHASED 0 0 0 0 3,000 3,000 0.00 ** NEW WINDOWS 10 COMPUTERS ** 05214 PRINTING 0 200 0 200 200 200 0.00 05215 BUILDING MAINT. 264 300 1,121 1,400 500 500 (64.29) 00200 TOTAL COMMODITIES 8,640 11,950 12,695 15,550 14,150 14,150 (9.00) 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 859 1,200 736 1,300 1,000 1,000 (23.08) 05301 TELEPHONES 2,743 6,000 2,573 3,000 3,000 3,000 0.00 05302 TRAVEL AND TRAINING 7,426 9,200 4,666 9,200 9,200 9,200 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 4,772 5,000 6,138 7,000 4,000 4,000 (42.86) 05306 ADVERTISING 796 1,100 502 1,000 1,000 1,000 0.00 05308 OFFICE EQUIP/RENTAL/LEASE 948 1,500 1,023 1,500 1,100 1,100 (26.67) 05310 MISCELLANEOUS 52,566 60,000 1,503 7,000 3,000 3,000 (57.14) 05313 UTILITIES PURCH FROM WUD 8,858 10,500 8,854 9,000 9,000 9,000 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 10 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05319 PROFESSIONAL SERVICES 23,680 25,000 22,065 25,000 25,000 25,000 0.00 05320 MEDICAL PROFESS. SERVICES 0 100 0 100 100 100 0.00 05321 COMPUTER MAINTENANCE 5,048 4,700 3,929 5,000 5,000 5,000 0.00 05323 VEHICLE & PROPERTY INSURANCE 65,525 60,000 0 62,000 62,000 62,000 0.00 05328 CUSTOMER REFUNDS 0 250 250 250 250 250 0.00 05336 SC SALES TAX 0 250 0 400 400 400 0.00 05352 JANITORIAL EXPENSE 1,015 1,800 1,223 1,200 1,200 1,200 0.00 05358 EQUIPMENT REPAIR & MAINT. 0 100 0 100 100 100 0.00 05362 MUNICIPAL COURT 19,930 21,000 18,510 21,000 21,000 21,000 0.00 05365 CONTRACTUAL SERVICES 28,608 29,000 34,688 37,000 32,000 32,000 (13.51) 05372 ELECTION EXPENSE 0 1,260 1,920 1,920 1,000 1,000 (47.92) 05378 PRINTING 0 500 0 500 500 500 0.00 05379 LEGAL SERVICES 7,363 35,000 10,868 30,000 30,000 30,000 0.00 05380 RESERVED FOR FUTURE EXPENDITUR 0 0 0 125,000 0 0 (100.00) 05383 PUBLIC RELATIONS/PROMOTIONS 1,160 5,000 0 2,000 2,000 2,000 0.00 05387 HALL ST PROPERTY PURCHASE 0 0 0 0 40,000 40,000 0.00 00300 TOTAL CONTRACTUAL SERVICES 231,297 278,460 119,448 350,470 251,850 251,850 (28.14) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 11 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 100 TOTAL ADMINISTRATION 382,948 431,808 281,364 515,813 418,333 417,395 (19.08) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 12 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 200 FIRE DEPARTMENT 00100 PERSONAL SERVICES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05100 SALARIES 194,209 182,219 193,416 187,664 284,468 195,969 4.43 05101 OVERTIME 19,977 16,800 13,711 16,000 16,000 16,000 0.00 05103 ANNUAL BONUS 1,260 1,360 1,000 1,510 1,810 1,440 (4.64) 05104 SOCIAL SECURITY 15,889 15,800 16,043 16,248 23,653 15,956 (1.80) 05105 RETIREMENT CONTRIBUTIONS 37,068 37,100 39,158 38,739 59,241 38,050 (1.78) 05106 HEALTH INSURANCE CONTRIBUTIONS 29,318 39,538 19,498 48,972 59,549 21,154 (56.80) 05107 WORKERS COMPENSATION 21,000 25,000 19,000 25,000 30,000 25,000 0.00 05109 PART TIME EMPLOYEES 4,590 24,000 8,032 24,720 24,720 12,608 (49.00) 05110 VOLUNTEER FIREFIGHTERS BONUS 6,000 6,000 6,000 6,000 6,000 6,000 0.00 00100 TOTAL PERSONAL SERVICES 329,311 347,817 315,858 364,853 505,441 332,177 (8.96) 00200 COMMODITIES 05201 FUEL 8,509 10,000 5,978 10,000 10,000 10,237 2.37 05202 OFFICE SUPPLIES 1,920 2,500 1,578 2,500 2,500 2,500 0.00 05204 BUNKER / PPE GEAR 1,548 6,200 4,642 2,000 5,000 5,000 150.00 05205 AWARDS / FLOWERS 472 600 585 600 600 600 0.00 05207 VEHICLE SUPPLIES / PARTS 566 2,000 890 2,000 3,000 3,000 50.00 05208 UNIFORMS 2,972 3,000 2,195 5,000 6,000 6,000 20.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 13 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05209 JANITORIAL SUPPLIES 592 2,000 1,275 2,000 2,000 2,000 0.00 05210 MISCELLANEOUS 267 500 544 1,000 1,000 1,000 0.00 05212 EQUIPMENT PURCHASED 4,174 5,000 576 5,000 5,000 8,000 60.00 ** ADDED $3,000 FOR 3 WINDOWS 10 COMPUTER UPGRADES ** 05222 SUPPLIES 895 2,500 296 2,500 2,500 2,500 0.00 00200 TOTAL COMMODITIES 21,915 34,300 18,559 32,600 37,600 40,837 25.27 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES ** IPAD DATA PLANS ** 602 900 999 1,200 2,500 2,500 108.33 05301 TELEPHONES 5,310 5,500 4,908 5,400 4,000 4,000 (25.93) 05302 TRAVEL AND TRAINING 1,281 4,000 2,314 4,000 5,000 5,000 25.00 05303 RADIO/PAGER REPAIR 0 500 0 500 500 500 0.00 05304 VEHICLE MAINTENANCE 5,026 6,800 6,285 18,000 18,000 16,075 (10.69) 05305 MEMBERSHIPS & SUBSCRIPTIONS 931 3,000 557 3,000 2,000 2,000 (33.33) 05306 ADVERTISING 255 300 0 300 300 300 0.00 05309 FIRE EXTINGUISHER 45 200 85 200 200 200 0.00 05310 MISCELLANEOUS 478 500 0 1,000 1,000 1,000 0.00 05313 UTILITIES PURCH FROM WUD 33,133 40,000 32,483 40,000 40,000 40,000 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 14 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05314 UTILITIES PURCH FROM OTHER 3,297 4,200 3,808 4,200 4,200 4,200 0.00 05319 PROFESSIONAL SERVICES 0 200 0 200 200 200 0.00 05320 MEDICAL PROFESS. SERVICES 468 1,200 608 1,200 1,200 1,200 0.00 05322 CABLE 583 500 615 700 900 900 28.57 05325 SECURITY MONITORING 0 500 0 500 500 500 0.00 05354 FIRE PREVENTION 1,450 1,500 1,294 1,500 1,500 1,500 0.00 05355 BUNKER GEAR REPAIR 0 500 0 500 500 500 0.00 05358 EQUIPMENT REPAIR & MAINT. 4,489 5,250 3,084 5,000 5,000 5,000 0.00 05365 CONTRACTUAL SERVICES 1,795 2,000 520 2,000 3,000 3,000 50.00 00300 TOTAL CONTRACTUAL SERVICES 59,143 77,550 57,560 89,400 90,500 88,575 (0.92) 00600 CAPITAL OUTLAY 05604 VEHICLES 0 0 0 0 42,000 0 0.00 05623 RADIO/PAGERS 4,127 4,275 2,398 4,275 4,275 4,275 0.00 05624 BUNKER/PPE GEAR 9,858 12,000 2,494 5,000 5,000 5,000 0.00 05637 OTHER EQUIPMENT 0 0 2,829 6,420 0 0 (100.00) 00600 TOTAL CAPITAL OUTLAY 13,985 16,275 7,721 15,695 51,275 9,275 (40.90) 200 TOTAL FIRE DEPARTMENT 424,354 475,942 399,698 502,548 684,816 470,864 (6.30) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 15 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 300 POLICE 00100 PERSONAL SERVICES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05100 SALARIES 265,850 256,725 242,548 267,488 359,424 362,370 35.47 05101 OVERTIME 16,934 20,000 13,965 17,000 17,000 20,000 17.65 05103 ANNUAL BONUS 1,020 1,120 830 1,150 1,380 1,380 20.00 05104 SOCIAL SECURITY 19,902 19,640 18,314 20,463 27,496 27,722 35.47 05105 RETIREMENT CONTRIBUTIONS 48,752 44,260 46,770 48,790 69,153 66,097 35.47 05106 HEALTH INSURANCE CONTRIBUTIONS 50,330 66,512 47,161 64,976 80,037 80,038 23.18 05107 WORKERS COMPENSATION 21,000 30,000 19,000 30,000 30,000 30,000 0.00 00100 TOTAL PERSONAL SERVICES 423,788 438,257 388,588 449,867 584,490 587,607 30.62 00200 COMMODITIES ** 05201 FUEL 21,765 30,000 16,787 30,000 30,000 27,000 (10.00) 05202 OFFICE SUPPLIES 2,002 2,000 1,432 2,000 8,000 8,000 300.00 NEW COMPUTERS AND LICENSING TO BE SLED 05206 VEHICLE MAINT/REPAIR COMPLIANT ** 17,347 18,000 10,483 15,000 15,000 18,000 20.00 05208 UNIFORMS 2,992 3,000 282 3,000 3,000 3,000 0.00 05210 MISCELLANEOUS 342 500 14 500 500 500 0.00 05215 BUILDING MAINT. 852 1,000 379 1,000 1,000 1,000 0.00 05222 SUPPLIES 4,679 6,000 3,201 6,000 6,000 6,000 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 16 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05224 POLICE K9 1,246 1,500 860 1,500 1,500 1,500 0.00 05226 DRUG SEIZURE EXPENSE 2,177 3,000 3,191 2,500 3,000 3,000 20.00 00200 TOTAL COMMODITIES 53,402 65,000 36,629 61,500 68,000 68,000 10.57 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 1,687 2,500 1,473 2,500 2,500 2,500 0.00 05301 TELEPHONES 3,163 4,300 2,573 4,300 4,300 4,300 0.00 05302 TRAVEL AND TRAINING 2,235 3,000 1,372 3,000 3,000 3,000 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 350 645 200 645 645 645 0.00 05306 ADVERTISING 498 500 11 500 500 500 0.00 05307 PUBLIC RELATIONS 498 500 0 500 500 500 0.00 05311 RADAR CERTIFICATION 280 400 0 400 400 400 0.00 05313 UTILITIES PURCH FROM WUD 14,860 14,000 11,360 14,000 14,000 14,000 0.00 05315 POLICE FUND 1,686 2,050 768 1,000 1,000 1,000 0.00 05318 SOFTWARE 3,668 3,670 3,144 2,700 3,500 3,500 29.63 ** LAWTRAK IS INCREASING FROM $262/MONTH TO $290/MONTH ** 05319 PROFESSIONAL SERVICES 792 2,500 2,274 2,500 2,500 2,500 0.00 05320 MEDICAL PROFESS. SERVICES 1,106 2,000 1,005 2,000 2,000 2,000 0.00 05352 JANITORIAL EXPENSE 860 1,042 900 1,042 1,042 1,042 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 17 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05357 EQUIPMENT RENTAL/LEASE 0 5,000 0 500 500 500 0.00 05358 EQUIPMENT REPAIR & MAINT. 1,500 1,500 0 1,800 1,800 1,800 0.00 05359 EQUIPMENT PURCHASE 2,430 2,500 1,244 1,400 1,400 1,400 0.00 05373 JUVENILE DETENTION 5,446 8,000 1,643 3,000 3,000 3,000 0.00 00300 TOTAL CONTRACTUAL SERVICES 41,059 54,107 27,967 41,787 42,587 42,587 1.91 00600 CAPITAL OUTLAY 05637 OTHER EQUIPMENT 3,352 3,400 4,493 15,700 0 2,400 (84.71) ** BODY CAMERAS $2400 ** 00600 TOTAL CAPITAL OUTLAY 3,352 3,400 4,493 15,700 0 2,400 (84.71) 300 TOTAL POLICE 521,601 560,764 457,677 568,854 695,077 700,594 23.16 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 18 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 500 CODES 00200 COMMODITIES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05201 FUEL 238 300 238 300 600 600 100.00 05202 OFFICE SUPPLIES 206 500 10 500 500 500 0.00 05206 VEHICLE MAINT/REPAIR 0 250 0 250 250 250 0.00 05210 MISCELLANEOUS 2,172 3,500 752 1,000 1,000 1,000 0.00 05214 PRINTING 189 500 0 500 500 500 0.00 00200 TOTAL COMMODITIES 2,805 5,050 1,000 2,550 2,850 2,850 11.76 00300 CONTRACTUAL SERVICES 05385 CODE SERVICES CONTRACT 9,638 28,000 19,379 23,000 23,000 23,000 0.00 05386 ABATEMENT EXPENSES 0 0 0 5,000 5,000 5,000 0.00 00300 TOTAL CONTRACTUAL SERVICES 9,638 28,000 19,379 28,000 28,000 28,000 0.00 500 TOTAL CODES 12,443 33,050 20,379 30,550 30,850 30,850 0.98 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 19 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 600 PUBLIC WORKS 00200 COMMODITIES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05201 FUEL 0 2,000 1,344 2,500 1,000 1,000 (60.00) 05202 OFFICE SUPPLIES 416 500 1,188 1,500 1,000 1,000 (33.33) 05209 JANITORIAL SUPPLIES 0 50 381 400 400 400 0.00 05210 MISCELLANEOUS 0 0 151 1,000 1,000 1,000 0.00 05215 BUILDING MAINT. 0 0 3,179 10,000 10,000 5,000 (50.00) 05216 MATERIALS - MAINT. 0 0 3,437 4,000 4,000 4,000 0.00 05222 SUPPLIES 3,842 4,000 1,410 1,500 2,000 2,000 33.33 05223 TOOLS 570 1,000 722 1,000 1,000 1,000 0.00 00200 TOTAL COMMODITIES 4,828 7,550 11,812 21,900 20,400 15,400 (29.68) 00300 CONTRACTUAL SERVICES 05313 UTILITIES PURCH FROM WUD 0 100 13,143 14,000 14,000 14,000 0.00 05316 RAILROAD PROPERTY RENTAL 0 0 798 800 900 900 12.50 05319 PROFESSIONAL SERVICES 0 0 0 45,000 0 0 (100.00) 05325 SECURITY MONITORING 0 0 565 2,000 2,000 2,000 0.00 05352 JANITORIAL EXPENSE 0 0 1,090 1,122 900 900 (19.79) 05357 EQUIPMENT RENTAL/LEASE 0 0 0 1,000 500 500 (50.00) 05358 EQUIPMENT REPAIR & MAINT. 14 500 88 500 500 500 0.00 Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 20 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05360 HAND POWER / HYDRAULIC TOOLS 0 0 0 1,000 500 500 (50.00) 05363 R.O.W. MAINTENANCE 44,885 45,000 41,774 45,000 45,000 45,000 0.00 05364 MOSQUITO SPRAYING 3,820 5,102 6,251 8,000 8,000 8,000 0.00 05365 CONTRACTUAL SERVICES 0 0 6,561 20,000 2,500 2,500 (87.50) 00300 TOTAL CONTRACTUAL SERVICES 48,719 50,702 70,270 138,422 74,800 74,800 (45.96) 00600 CAPITAL OUTLAY 05636 BUILDING/OTHER IMPROVEMENTS 14,148 15,000 0 0 0 50,000 0.00 ** RETREAT STREET PARK ** 00600 TOTAL CAPITAL OUTLAY 14,148 15,000 0 0 0 50,000 0.00 600 TOTAL PUBLIC WORKS 67,695 73,252 82,082 160,322 95,200 140,200 (12.55) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 21 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 700 00200 COMMODITIES 00200 TOTAL COMMODITIES 595 600 0 500 500 500 0.00 00300 CONTRACTUAL SERVICES 00300 TOTAL CONTRACTUAL SERVICES 338,534 338,952 272,547 274,167 278,843 273,883 (0.10) 700 TOTAL NON DEPARTMENTAL 339,129 339,552 272,547 274,667 279,343 274,383 (0.10) YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc NON DEPARTMENTAL 05222 SUPPLIES 595 600 0 500 500 500 0.00 05317 TRANSFER TO CHAMBER 1,832 2,250 680 2,300 0 0 (100.00) 05377 SOLID WASTE TRANSFER 126,702 126,702 61,867 61,867 93,843 86,392 39.64 05384 TRANSFER TO YOUTH RECREATION 210,000 210,000 210,000 210,000 185,000 187,491 (10.72) Budget Worksheet 010-CITY GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 22 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc TOTAL EXPENDITURES 1,748,170 1,914,368 1,513,747 2,052,754 2,203,619 2,034,286 (0.90) TOTAL FUND SURPLUS (DEFICIT) (143,061) (30,154) 254,115 0 (351,319) 0 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 23 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct REVENUES 150 UTILITY ADMINISTRATION 00405 INTEREST INCOME YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40500 INTEREST INCOME 699 590 1,363 500 500 500 0.00 00405 TOTAL INTEREST INCOME 699 590 1,363 500 500 500 0.00 00407 MISCELLANEOUS & OTHER 40700 SERVICE CHARGES 54,919 51,550 41,149 50,000 50,000 50,000 0.00 40701 PROCEEDS FROM BORROWING 0 160,000 190,111 414,556 0 0 (100.00) 40707 MISCELLANEOUS REV 59,274 81,700 0 60,000 60,000 60,000 0.00 40710 PENALTIES 72,081 73,700 54,848 60,000 60,000 60,000 0.00 40712 DEBT SET OFF FEES 1,250 575 525 500 500 500 0.00 40723 AMI FEES 297,409 297,000 297,290 297,000 85,104 296,268 (0.25) ** =3,527 AMI CUSTOMERS X $7 PER MONTH X 12 MONTHS ** 40735 INSURANCE PAID CLAIMS 0 0 675 0 0 0 0.00 40737 REFUNDS/REIMBURSEMENTS 0 0 30,673 30,352 30,000 30,000 (1.16) 00407 TOTAL MISCELLANEOUS & OTHER 484,933 664,525 615,271 912,408 285,604 496,768 (45.55) 00412 OTHER REVENUE 41200 GRANTS 0 18,733 0 0 15,425 15,425 0.00 ** REIMBURSEMENT FROM THE COUNTY FOR MONEY SPENT TO TEST/REPLACE BIGGER WATER METERS PER CHRIS CARTER ** 00412 TOTAL OTHER REVENUE 0 18,733 0 0 15,425 15,425 0.00 150 TOTAL UTILITY ADMINISTRATION 485,632 683,848 616,634 912,908 301,529 512,693 (43.84) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 24 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 250 ELECTRIC 00407 MISCELLANEOUS & OTHER YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40703 SALE OF EQUIP/MATERIAL/SCRAP ** CONTRACTED LABOR FOR PHASE 4 COMPLETION $90,000 ** 7,614 9,000 88 5,000 5,000 5,000 0.00 40707 MISCELLANEOUS REV 6,735 0 325 100 100 100 0.00 40711 POLE RENTAL FEES 0 315 386 400 300 300 (25.00) 40733 TRANSFER FROM HOSPITALITY FUND 0 0 22,227 35,000 0 0 (100.00) ** CHRISTMAS LIGHTS ** 40735 INSURANCE PAID CLAIMS 0 0 4,758 0 0 0 0.00 40737 REFUNDS/REIMBURSEMENTS 0 0 21,727 0 0 0 0.00 00407 TOTAL MISCELLANEOUS & OTHER 14,349 9,315 49,511 40,500 5,400 5,400 (86.67) 00408 ELECTRIC 40800 COMMERCIAL ELECTRIC 1,641,331 1,648,730 1,520,270 1,635,609 1,651,700 1,651,700 0.98 40801 RESIDENTIAL ELECTRIC 2,090,772 2,186,353 2,012,930 2,201,303 2,100,000 2,100,000 (4.60) 40803 COMMERCIAL ELE NTX 362,240 370,000 294,680 330,000 360,000 360,000 9.09 40804 TEMP POWER/UNDERGRND PW 0 450 0 500 500 500 0.00 00408 TOTAL ELECTRIC 4,094,343 4,205,533 3,827,880 4,167,412 4,112,200 4,112,200 (1.32) 250 TOTAL ELECTRIC 4,108,692 4,214,848 3,877,391 4,207,912 4,117,600 4,117,600 (2.15) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 25 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 350 WATER 00407 MISCELLANEOUS & OTHER YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40703 SALE OF EQUIP/MATERIAL/SCRAP 2,050 2,100 0 2,100 2,000 2,000 (4.76) 40737 REFUNDS/REIMBURSEMENTS 0 0 14,375 14,375 0 0 (100.00) 00407 TOTAL MISCELLANEOUS & OTHER 2,050 2,100 14,375 16,475 2,000 2,000 (87.86) 00409 WATER 40900 WATER SALES 1,836,936 1,884,772 1,997,114 1,865,837 1,860,932 1,860,932 (0.26) 40901 WATER TAPS 17,506 37,500 21,006 15,000 15,000 15,000 0.00 40902 DHEC 13,849 13,700 13,804 13,700 14,000 14,000 2.19 00409 TOTAL WATER 1,868,291 1,935,972 2,031,924 1,894,537 1,889,932 1,889,932 (0.24) 00411 PROJECT OPERATIONS 41100 WATER LINE EXTENSION 0 19,000 0 10,000 0 0 (100.00) 00411 TOTAL PROJECT OPERATIONS 0 19,000 0 10,000 0 0 (100.00) 350 TOTAL WATER 1,870,341 1,957,072 2,046,299 1,921,012 1,891,932 1,891,932 (1.51) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 26 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 450 SEWER 00407 MISCELLANEOUS & OTHER YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40737 REFUNDS/REIMBURSEMENTS 0 0 803,571 803,570 0 0 (100.00) 40739 BEACON MILL PROJECT 0 0 309,780 0 0 0 0.00 00407 TOTAL MISCELLANEOUS & OTHER 0 0 1,113,351 803,570 0 0 (100.00) 00410 SEWER 41000 SEWER SALES 616,527 617,725 614,011 625,231 620,000 620,000 (0.84) 41001 SEWER TAPS 1,000 4,000 (1,000) 2,000 2,000 2,000 0.00 00410 TOTAL SEWER 617,527 621,725 613,011 627,231 622,000 622,000 (0.83) 450 TOTAL SEWER 617,527 621,725 1,726,362 1,430,801 622,000 622,000 (56.53) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 27 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 550 WATER PLANT 00407 MISCELLANEOUS & OTHER YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40737 REFUNDS/REIMBURSEMENTS 0 0 107 0 0 0 0.00 00407 TOTAL MISCELLANEOUS & OTHER 0 0 107 0 0 0 0.00 550 TOTAL WATER PLANT 0 0 107 0 0 0 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 28 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc TOTAL REVENUES 7,082,192 7,477,493 8,266,793 8,472,633 6,933,061 7,144,225 (15.68) EXPENDITURES 150 UTILITY ADMINISTRATION 00100 PERSONAL SERVICES 05100 SALARIES 186,834 186,608 189,779 192,206 196,204 196,046 2.00 05101 OVERTIME 1,618 2,000 960 1,500 1,500 1,000 (33.33) 05103 ANNUAL BONUS 810 810 900 900 990 990 10.00 05104 SOCIAL SECURITY 13,527 14,276 13,764 14,705 15,009 14,997 1.99 05105 RETIREMENT CONTRIBUTIONS 27,803 27,171 29,978 29,908 32,491 30,505 2.00 05106 HEALTH INSURANCE CONTRIBUTIONS 31,814 32,000 33,101 36,490 36,489 36,489 0.00 05107 WORKERS COMPENSATION 2,500 2,500 4,862 4,862 6,000 6,000 23.41 05108 EMPLOYEE BONDING 590 600 590 700 700 700 0.00 05112 UNEMPLOYEMENT INSURANCE REIMBU 0 500 0 500 0 0 (100.00) 05114 VEHICLE ALLOWANCE 2,500 2,500 1,923 2,500 2,500 2,500 0.00 00100 TOTAL PERSONAL SERVICES 267,996 268,965 275,857 284,271 291,883 289,227 1.74 00200 COMMODITIES 05200 POSTAGE 1,342 1,400 1,077 2,000 1,500 1,500 (25.00) 05201 FUEL 3,801 5,000 2,750 5,000 5,000 5,000 0.00 05202 OFFICE SUPPLIES 3,784 6,000 7,073 8,000 6,000 6,000 (25.00) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 29 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct ** 00200 TOTAL COMMODITIES 40,153 47,400 49,319 42,200 44,200 46,200 9.48 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 1,369 2,800 1,473 2,200 2,200 2,200 0.00 05301 TELEPHONES 3,400 6,000 3,157 5,000 3,500 3,500 (30.00) YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05205 AWARDS / FLOWERS 0 150 83 150 150 150 0.00 05206 VEHICLE MAINT/REPAIR 1,350 3,000 2,140 4,000 3,000 3,000 (25.00) 05208 UNIFORMS 4,191 4,500 3,515 4,000 4,000 4,000 0.00 05209 JANITORIAL SUPPLIES 396 700 827 900 900 900 0.00 05210 MISCELLANEOUS 1,562 2,000 1,506 2,000 1,500 1,500 (25.00) 05211 SERVICE FEES 22,651 23,000 29,626 14,000 20,000 20,000 42.86 05212 EQUIPMENT PURCHASED 0 0 0 0 0 2,000 0.00 NEW WINDOWS 10 COMPUTERS ** 05215 BUILDING MAINT. 63 500 549 500 500 500 0.00 05216 MATERIALS - MAINT. 52 100 0 100 100 100 0.00 05222 SUPPLIES 764 1,000 954 1,500 1,500 1,500 0.00 05223 TOOLS 27 50 0 50 50 50 0.00 05227 BANK RECON ADJUSTMENT 170 0 (781) 0 0 0 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 30 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct ** YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05302 TRAVEL AND TRAINING 2,784 3,000 1,208 2,200 2,200 2,200 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 1,722 3,100 2,077 3,000 3,000 3,000 0.00 05306 ADVERTISING 1,141 200 789 200 200 200 0.00 05308 OFFICE EQUIP/RENTAL/LEASE 948 2,000 1,023 2,000 2,000 2,000 0.00 05310 MISCELLANEOUS 11,301 10,000 2,754 8,000 8,000 8,000 0.00 05313 UTILITIES PURCH FROM WUD 9,540 9,000 8,291 9,000 9,000 9,000 0.00 05319 PROFESSIONAL SERVICES 29,905 40,000 28,665 50,000 50,000 50,000 0.00 05320 MEDICAL PROFESS. SERVICES 53 250 47 250 250 250 0.00 05321 COMPUTER MAINTENANCE 5,048 7,500 6,972 7,500 7,500 7,500 0.00 05323 VEHICLE & PROPERTY INSURANCE 65,111 55,000 1,141 65,000 65,000 65,000 0.00 05326 FRANCHISE FEE 336,000 336,000 432,927 432,927 329,632 495,106 14.36 7.51% WATER, SEWER, & ELECTRIC SALES ** 05327 ONLINE UTILITY EXCHANGE 809 1,000 993 1,000 1,000 1,000 0.00 05336 SC SALES TAX 493 1,250 476 1,400 1,000 1,000 (28.57) 05352 JANITORIAL EXPENSE 2,770 3,000 2,819 3,000 3,000 3,000 0.00 05358 EQUIPMENT REPAIR & MAINT. 0 500 0 500 500 500 0.00 05365 CONTRACTUAL SERVICES 60,857 60,000 61,592 61,100 61,000 61,000 (0.16) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 31 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05375 RECORDS CHECK 0 50 0 50 50 50 0.00 00300 TOTAL CONTRACTUAL SERVICES 533,251 540,650 556,404 654,327 549,032 714,506 9.20 00600 CAPITAL OUTLAY 05604 VEHICLES 0 0 0 0 30,000 30,000 0.00 ** REPLACE METER READER TRUCK ** 00600 TOTAL CAPITAL OUTLAY 0 0 0 0 30,000 30,000 0.00 150 TOTAL UTILITY ADMINISTRATION 841,400 857,015 881,580 980,798 915,115 1,079,933 10.11 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 32 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 250 ELECTRIC 00100 PERSONAL SERVICES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05100 SALARIES 173,945 175,583 162,908 169,925 171,758 174,632 2.77 05101 OVERTIME 12,177 20,000 18,728 15,000 15,000 15,000 0.00 05103 ANNUAL BONUS 490 490 610 610 670 670 9.84 05104 SOCIAL SECURITY 13,434 13,301 13,205 12,864 11,668 13,259 3.07 05105 RETIREMENT CONTRIBUTIONS 27,099 25,565 28,262 26,441 26,440 26,930 1.85 05106 HEALTH INSURANCE CONTRIBUTIONS 26,043 34,489 28,940 36,174 36,174 36,174 0.00 05107 WORKERS COMPENSATION 18,000 18,000 18,000 18,000 25,000 25,000 38.89 00100 TOTAL PERSONAL SERVICES 271,188 287,428 270,653 279,014 286,710 291,665 4.53 00200 COMMODITIES 05201 FUEL 16,293 16,500 13,395 15,000 12,000 12,000 (20.00) 05202 OFFICE SUPPLIES 2,328 2,700 1,057 2,000 2,000 2,000 0.00 05206 VEHICLE MAINT/REPAIR 21,404 27,500 12,092 20,000 20,000 19,000 (5.00) 05208 UNIFORMS 6,185 7,000 4,617 5,000 5,000 5,000 0.00 05209 JANITORIAL SUPPLIES 267 500 69 500 500 500 0.00 05210 MISCELLANEOUS 164 200 181 200 200 200 0.00 05212 EQUIPMENT PURCHASED 0 0 0 0 0 1,000 0.00 ** NEW COMPUTER $1000 ** Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 33 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct ** 00200 TOTAL COMMODITIES 119,699 148,600 91,070 114,400 143,900 233,900 104.46 00300 CONTRACTUAL SERVICES ** YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05216 MATERIALS - MAINT. 69,830 90,000 57,359 67,500 100,000 190,000 181.48 Materials for Phase 4 Wires, insulators & Poles Other estimated materials for additiona 05217 MATERIALS - EXTENSION 1,368 l line work ** 2,000 1,071 2,000 2,000 2,000 0.00 05222 SUPPLIES 767 1,000 326 1,000 1,000 1,000 0.00 05223 TOOLS 1,093 1,200 903 1,200 1,200 1,200 0.00 05300 CELLULAR/WIRELESS PHONES 3,649 4,150 3,839 3,500 3,500 3,500 0.00 05301 TELEPHONES 1,949 1,900 1,795 1,900 1,900 1,900 0.00 05302 TRAVEL AND TRAINING 7,639 9,000 6,919 8,000 8,000 8,000 0.00 05310 MISCELLANEOUS 2,612 3,200 2,581 3,200 3,200 3,200 0.00 05313 UTILITIES PURCH FROM WUD 5,460 5,000 4,322 5,000 5,000 5,000 0.00 05319 PROFESSIONAL SERVICES 63,817 70,000 48,600 74,000 49,000 49,000 (33.78) 05320 MEDICAL PROFESS. SERVICES 53 500 144 500 500 500 0.00 05338 ROW LIABILITIES 0 500 2,512 2,000 2,000 2,000 0.00 05340 ENERGY PURCHASED 2,544,004 2,617,932 2,040,478 2,442,543 2,333,387 2,333,387 (4.47) FOR 6 MONTHS, $50,000/MONTH REDUCTION BY PMPA ** 05352 JANITORIAL EXPENSE 0 100 0 100 100 100 0.00 05358 EQUIPMENT REPAIR & MAINT. 5,721 6,500 5,413 5,000 5,000 5,000 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 34 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05360 HAND POWER / HYDRAULIC TOOLS 5,984 6,000 4,992 5,000 5,000 5,000 0.00 05361 HEAVY DUTY EQUIP RENT/LEASE 111 1,000 756 1,000 1,000 1,000 0.00 05365 CONTRACTUAL SERVICES 30,618 33,000 37,535 67,500 140,000 140,000 107.41 ** Tree Trimming in advance of Phase 4 transformer installation along other tree trimming work to be performed in advance of final system conversion to 12.47kV operating voltage ** 05371 CUT LINES 0 1,500 0 1,500 1,500 1,500 0.00 00300 TOTAL CONTRACTUAL SERVICES 2,671,617 2,760,282 2,159,886 2,620,743 2,559,087 2,559,087 (2.35) 00600 CAPITAL OUTLAY 05604 VEHICLES 0 0 24,027 24,027 18,000 0 (100.00) ** DEPARTMENT HEAD WOULD LIKE SIDE BY SIDE ATV TO SPRAY ROW ** 05608 TRANSFORMERS ** TO HELP COMPLETE PHASE 4 ** 4,750 6,500 2,481 6,500 10,000 10,000 53.85 05633 TRANSFORMER INSTALLATION 121,110 121,110 100,000 100,000 425,000 470,690 370.69 ** CONTRACTED LABOR AND VEGETATION MANAGEMENT FOR PHASE 4 COMPLETION ** 05636 BUILDING/OTHER IMPROVEMENTS 0 0 83,414 83,545 0 0 (100.00) ** CHRISTMAS DECORATIONS TO REPLACE OLD BANNERS TRANSFER FROM HOSPITALITY MONEY ** 05637 OTHER EQUIPMENT 0 0 96,556 102,000 9,400 0 (100.00) ** NEW UNDERGROUND LOCATOR & FAULT FINDER $4400 DIRECTIONAL ARROW BOARD $5000 ** 05639 WESTMINSTER CROSSING PROJECT 0 0 30,090 31,317 0 0 (100.00) 05642 SUBSTATION REPAIRS 0 0 0 119,424 0 0 (100.00) 00600 TOTAL CAPITAL OUTLAY 125,860 127,610 336,568 466,813 462,400 480,690 2.97 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 35 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 250 TOTAL ELECTRIC 3,188,364 3,323,920 2,858,177 3,480,970 3,452,097 3,565,342 2.42 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 36 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 350 WATER 00100 PERSONAL SERVICES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05100 SALARIES 174,746 168,179 168,848 173,207 173,206 129,000 (25.52) 05101 OVERTIME 14,380 16,500 13,493 12,000 12,000 12,000 0.00 05103 ANNUAL BONUS 1,180 1,180 1,300 1,300 1,420 1,110 (14.62) 05104 SOCIAL SECURITY 13,382 12,866 12,957 13,251 13,250 9,869 (25.52) 05105 RETIREMENT CONTRIBUTIONS 27,537 24,487 28,372 26,951 26,951 20,073 (25.52) 05106 HEALTH INSURANCE CONTRIBUTIONS 30,091 29,925 36,400 31,378 31,377 23,376 (25.50) 05107 WORKERS COMPENSATION 14,500 14,500 5,205 5,205 23,500 23,500 351.49 00100 TOTAL PERSONAL SERVICES 275,816 267,637 266,575 263,292 281,704 218,928 (16.85) 00200 COMMODITIES ** ** 1 1/2 COMPUTER SPLIT $1500 ** 05201 FUEL 17,371 16,500 12,320 13,000 16,000 16,000 23.08 05202 OFFICE SUPPLIES 2,940 3,000 1,891 2,000 1,500 1,500 (25.00) 05206 VEHICLE MAINT/REPAIR 17,136 18,000 19,105 25,000 30,000 30,000 20.00 INCREA 05208 ED DUE TO ADDITIONAL PUMP TRUCK ** UNIFORMS 6,898 7,000 6,291 7,500 5,500 5,500 (26.67) 05209 JANITORIAL SUPPLIES 273 500 69 500 500 500 0.00 05210 MISCELLANEOUS 240 250 87 250 250 250 0.00 05212 EQUIPMENT PURCHASED 0 0 0 3,000 0 1,500 (50.00) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 37 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct ** 00200 TOTAL COMMODITIES 213,814 232,000 179,706 188,750 193,250 194,750 3.18 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 3,458 3,300 3,103 3,500 3,300 3,300 (5.71) 05301 TELEPHONES 1,914 3,700 1,795 2,200 2,200 2,200 0.00 05302 TRAVEL AND TRAINING 2,021 2,500 2,229 2,500 2,500 2,500 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 60 200 0 200 200 200 0.00 05306 ADVERTISING 0 100 0 100 300 300 200.00 05310 MISCELLANEOUS 96 100 55 100 100 100 0.00 05313 UTILITIES PURCH FROM WUD 31,336 30,000 29,160 33,000 33,000 33,000 0.00 05319 PROFESSIONAL SERVICES 29,768 33,000 2,400 13,000 13,000 12,000 (7.69) 05320 MEDICAL PROFESS. SERVICES 285 400 189 450 400 400 (11.11) YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05215 BUILDING MAINT. 246 2,000 2,040 2,000 3,000 3,000 50.00 GARAGE DOORS ** 05216 MATERIALS - MAINT. 163,891 170,000 133,073 130,000 120,000 120,000 (7.69) 05217 MATERIALS - EXTENSION 55 10,000 0 0 10,000 10,000 0.00 05222 SUPPLIES 1,293 1,250 1,962 2,000 3,000 3,000 50.00 05223 TOOLS 3,471 3,500 2,868 3,500 3,500 3,500 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 38 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05339 PURCHASED WATER 1,102 2,000 1,134 2,000 1,500 1,500 (25.00) 05341 ASPHALT/PAVING 18,344 20,000 19,995 20,000 20,000 20,000 0.00 05350 PUMP STATION MAINT/REPAIR 11,885 20,000 20,920 22,500 15,000 15,000 (33.33) 05351 ELEVATED TANK MAINT. 42,805 45,000 42,689 45,000 45,000 45,000 0.00 05352 JANITORIAL EXPENSE 0 600 0 600 0 0 (100.00) 05353 HYDRANT MAINTENANCE 151 500 266 500 1,000 1,000 100.00 05358 EQUIPMENT REPAIR & MAINT. 14,418 15,000 9,298 15,000 15,000 15,000 0.00 05360 HAND POWER / HYDRAULIC TOOLS 1,630 2,000 376 2,000 2,000 2,000 0.00 05361 HEAVY DUTY EQUIP RENT/LEASE 5,201 10,000 367 5,000 5,000 3,500 (30.00) 05365 CONTRACTUAL SERVICES 23,190 30,000 59,459 70,000 20,000 20,000 (71.43) 05371 CUT LINES 1,291 2,500 1,201 2,500 2,500 2,500 0.00 00300 TOTAL CONTRACTUAL SERVICES 188,955 220,900 194,636 240,150 182,000 179,500 (25.26) 00600 CAPITAL OUTLAY 05604 VEHICLES 0 0 0 40,000 0 0 (100.00) 05637 OTHER EQUIPMENT 0 0 2,798 48,000 35,000 15,425 (67.86) ** 2"+ METERS BEING CHANGED OUT ** 05640 WATER LINE LONG CRK HWY/US 76 0 0 108,443 108,443 0 0 (100.00) 00600 TOTAL CAPITAL OUTLAY 0 0 111,241 196,443 35,000 15,425 (92.15) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 39 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 00700 DEBT SERVICE 05706 2014 UTILITY REV BOND PRINCIPA 21,974 0 0 0 0 0 0.00 00700 TOTAL DEBT SERVICE 21,974 0 0 0 0 0 0.00 350 TOTAL WATER 700,559 720,537 752,158 888,635 691,954 608,603 (31.51) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 40 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 450 SEWER 00100 PERSONAL SERVICES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05100 SALARIES 79,495 82,244 84,804 81,990 84,458 83,820 2.23 05101 OVERTIME 13,023 16,000 13,604 10,000 13,000 13,000 30.00 05103 ANNUAL BONUS 230 330 1,610 390 450 450 15.38 05104 SOCIAL SECURITY 6,280 6,354 6,953 6,273 6,461 6,412 2.22 05105 RETIREMENT CONTRIBUTIONS 13,471 11,975 15,507 12,758 13,719 13,042 2.23 05106 HEALTH INSURANCE CONTRIBUTIONS 21,853 34,177 22,491 28,533 25,819 23,819 (16.52) 05107 WORKERS COMPENSATION 10,000 10,000 4,126 4,126 10,000 10,000 142.37 00100 TOTAL PERSONAL SERVICES 144,352 161,080 149,095 144,070 153,907 150,543 4.49 00200 COMMODITIES 05201 FUEL 13,273 13,000 12,177 13,000 15,000 15,000 15.38 05202 OFFICE SUPPLIES 932 1,000 741 1,000 1,000 1,000 0.00 05203 RADIO/PAGERS 0 0 0 1,000 2,500 1,000 0.00 05206 VEHICLE MAINT/REPAIR 8,071 8,500 7,956 12,000 12,000 10,500 (12.50) 05208 UNIFORMS 6,512 7,000 5,110 6,000 5,000 5,000 (16.67) 05209 JANITORIAL SUPPLIES 267 400 49 400 300 300 (25.00) 05210 MISCELLANEOUS 45 100 28 100 100 100 0.00 05212 EQUIPMENT PURCHASED 0 0 0 0 0 1,500 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 41 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct ** 1 1/2 COMPUTER $1500 ** YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05216 MATERIALS - MAINT. 8,611 10,000 10,066 12,000 10,000 10,000 (16.67) 05222 SUPPLIES 1,668 2,000 962 2,000 2,000 2,000 0.00 05223 TOOLS 956 1,000 1,264 2,000 2,000 2,000 0.00 00200 TOTAL COMMODITIES 40,335 43,000 38,353 49,500 49,900 48,400 (2.22) 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 1,002 1,500 894 1,500 1,500 1,500 0.00 05301 TELEPHONES 1,914 2,000 1,795 2,000 2,000 2,000 0.00 05302 TRAVEL AND TRAINING 625 1,500 55 2,500 1,000 1,000 (60.00) 05310 MISCELLANEOUS 276 300 99 350 300 300 (14.29) 05313 UTILITIES PURCH FROM WUD 5,259 6,600 4,086 3,000 3,000 3,000 0.00 05319 PROFESSIONAL SERVICES 0 0 0 2,000 1,000 1,000 (50.00) 05320 MEDICAL PROFESS. SERVICES 673 500 264 500 500 500 0.00 05329 OCONEE COUNTY SEWER BILL 511,898 544,000 560,233 564,000 564,000 564,000 0.00 05341 ASPHALT/PAVING 3,869 4,000 3,664 4,000 4,000 4,000 0.00 05352 JANITORIAL EXPENSE 0 600 0 600 0 0 (100.00) 05357 EQUIPMENT RENTAL/LEASE 2,624 10,000 1,367 5,000 3,000 3,000 (40.00) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 42 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05358 EQUIPMENT REPAIR & MAINT. 14,206 15,000 4,129 15,000 15,000 15,000 0.00 05360 HAND POWER / HYDRAULIC TOOLS 202 1,000 0 1,000 1,000 1,000 0.00 05365 CONTRACTUAL SERVICES 26,848 30,000 13,691 16,000 25,000 25,000 56.25 ** INCLUDES SEWER RIGHT-A-WAY CLEARING ** 00300 TOTAL CONTRACTUAL SERVICES 569,396 617,000 590,277 617,450 621,300 621,300 0.62 00600 CAPITAL OUTLAY 05626 SEWER RIGHT-A-WAY CLEARING 13,675 25,000 1,200 25,000 0 0 (100.00) 05637 OTHER EQUIPMENT 0 0 40,500 40,500 6,000 0 (100.00) ** BUSH HOG FOR NEW SKID STEER PURCHASED 2020 ** 05641 BEACON MILL PROJECT 0 0 142,780 142,780 0 0 (100.00) 00600 TOTAL CAPITAL OUTLAY 13,675 25,000 184,480 208,280 6,000 0 (100.00) 450 TOTAL SEWER 767,758 846,080 962,205 1,019,300 831,107 820,243 (19.53) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 43 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 550 WATER PLANT 00100 PERSONAL SERVICES YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05100 SALARIES 122,851 127,906 117,363 131,743 127,733 130,135 (1.22) 05101 OVERTIME 5,231 7,500 3,272 4,000 5,000 5,000 25.00 05103 ANNUAL BONUS 740 740 670 870 1,020 1,020 17.24 05104 SOCIAL SECURITY 10,842 14,360 10,518 14,791 13,214 13,398 (9.42) 05105 RETIREMENT CONTRIBUTIONS 21,256 27,330 21,964 30,084 30,737 24,310 (19.19) 05106 HEALTH INSURANCE CONTRIBUTIONS 11,895 15,146 15,110 23,376 15,865 15,865 (32.13) 05107 WORKERS COMPENSATION 5,500 5,500 4,500 5,500 5,500 5,500 0.00 05109 PART TIME EMPLOYEES 17,906 17,800 20,724 23,594 45,000 45,000 90.73 00100 TOTAL PERSONAL SERVICES 196,221 216,282 194,121 233,958 244,069 240,228 2.68 00200 COMMODITIES 05200 POSTAGE 1,262 1,000 696 1,750 1,750 1,750 0.00 05201 FUEL 2,407 4,500 3,069 4,500 4,500 4,500 0.00 05202 OFFICE SUPPLIES 2,937 3,000 2,911 3,000 3,000 3,000 0.00 05206 VEHICLE MAINT/REPAIR 362 2,500 72 2,500 2,500 2,500 0.00 05208 UNIFORMS 478 500 932 1,000 1,000 1,000 0.00 05209 JANITORIAL SUPPLIES 711 1,000 1,017 1,000 1,000 1,000 0.00 05210 MISCELLANEOUS 250 250 250 250 250 250 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 44 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05213 CHEMICALS 36,863 50,000 33,982 42,500 40,550 40,550 (4.59) 05215 BUILDING MAINT. 9,660 14,500 40,710 42,000 32,473 32,473 (22.68) 05222 SUPPLIES 500 500 577 500 500 500 0.00 00200 TOTAL COMMODITIES 55,430 77,750 84,216 99,000 87,523 87,523 (11.59) 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 2,551 3,000 3,539 4,000 2,500 2,500 (37.50) 05301 TELEPHONES 2,303 2,300 2,184 2,300 2,300 2,300 0.00 05302 TRAVEL AND TRAINING 2,958 4,000 4,645 4,000 5,000 5,000 25.00 ** NEW TRAINEE ** 05305 MEMBERSHIPS & SUBSCRIPTIONS ** ADDED JJ KELLER SAFETY TRAINING ANNUAL SUBSCR. ** 1,337 1,300 2,023 1,300 1,800 1,800 38.46 ** 05313 UTILITIES PURCH FROM WUD 331,886 331,561 266,157 267,500 132,500 132,500 (50.47) 05314 UTILITIES PURCH FROM OTHER 13,112 20,000 11,124 20,000 20,000 20,000 0.00 05319 PROFESSIONAL SERVICES 0 2,000 120 27,000 27,000 57,238 111.99 ADDED 05320 SURPLUS OF $30,238 FROM UTILITY FUND ** MEDICAL PROFESS. SERVICES 195 650 94 650 650 650 0.00 05342 H2O QUALITY REPORT 0 350 0 350 350 350 0.00 05343 WATER SAMPLING 11,168 18,300 5,287 11,500 11,500 11,500 0.00 05344 DHEC/INTERAL FEES 15,093 16,000 15,105 16,000 16,000 16,000 0.00 Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 45 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05345 LAB EXPENSE 29,878 32,430 33,527 32,430 32,430 32,430 0.00 05347 WASTE HANDLING 2,851 5,000 5,106 5,000 5,000 5,000 0.00 05348 GENERATOR 2,185 6,000 3,537 8,000 8,000 8,000 0.00 05349 SCADA MAINTENANCE 4,200 7,500 3,441 3,500 4,200 4,200 20.00 05350 PUMP STATION MAINT/REPAIR 1,800 1,000 1,000 1,000 1,000 1,000 0.00 ** CHAUGA RIVER PUMPS REPAIR ** 05352 JANITORIAL EXPENSE 0 43 12 43 43 43 0.00 05358 EQUIPMENT REPAIR & MAINT. 38,590 43,200 31,347 35,000 38,590 105,028 200.08 ** ADDED $62,000 PER COUNCIL FOR SLEEVE FOR RIVER PUMP ** 05365 CONTRACTUAL SERVICES 25,760 29,100 28,189 34,100 34,100 34,100 0.00 00300 TOTAL CONTRACTUAL SERVICES 485,867 523,734 416,437 473,673 342,963 439,639 (7.19) 00600 CAPITAL OUTLAY 05636 BUILDING/OTHER IMPROVEMENTS 0 45,000 156,760 414,556 0 0 (100.00) 05637 OTHER EQUIPMENT 13,914 187,000 48,758 55,500 0 0 (100.00) 00600 TOTAL CAPITAL OUTLAY 13,914 232,000 205,518 470,056 0 0 (100.00) 550 TOTAL WATER PLANT 751,432 1,049,766 900,292 1,276,687 674,555 767,390 (39.89) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 46 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 650 NON DEPARTMENTAL 00700 DEBT SERVICE YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05706 2014 UTILITY REV BOND PRINCIPA 0 279,017 261,656 285,674 292,489 292,489 2.39 05707 2015 UTILITY REV BOND PRINCIPA 4,709 203,115 189,049 206,347 0 0 (100.00) 05710 2015 UTILITY REV BOND INTEREST 0 5,003 1,725 1,770 0 0 (100.00) 05711 2014 UTILITY BOND REV INTEREST 0 23,696 15,831 17,040 10,225 10,225 (39.99) 00700 TOTAL DEBT SERVICE 4,709 510,831 468,261 510,831 302,714 302,714 (40.74) 650 TOTAL NON DEPARTMENTAL 4,709 510,831 468,261 510,831 302,714 302,714 (40.74) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 47 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct 700 NON DEPARTMENTAL 00800 OTHER YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05853 CONTINGENCY APPROPRIATION 0 0 0 315,413 0 0 (100.00) 00800 TOTAL OTHER 0 0 0 315,413 0 0 (100.00) 700 TOTAL NON DEPARTMENTAL 0 0 0 315,413 0 0 (100.00) Budget Worksheet 020-UTILITY DEPT. GENERAL FUND CITY OF WESTMINSTER Run By: KMR Page 48 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc TOTAL EXPENDITURES 6,254,222 7,308,149 6,822,673 8,472,634 6,867,542 7,144,225 (15.68) TOTAL FUND SURPLUS (DEFICIT) 827,970 169,344 1,444,120 (1) 65,519 0 (100.00) Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: KMR Page 49 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct REVENUES 900 SOLID WASTE 00407 MISCELLANEOUS & OTHER YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40700 SERVICE CHARGES 322,143 322,944 373,236 361,200 361,200 361,200 0.00 40707 MISCELLANEOUS REV 37,047 34,765 0 1,216 1,000 1,000 (17.76) 40729 TRANSFER FROM GENERAL FUND 126,702 126,702 61,867 61,867 93,843 86,392 39.64 40734 COURT ORDERED RESTITUTION 0 0 626 0 0 0 0.00 40735 INSURANCE PAID CLAIMS 0 0 2,895 0 0 0 0.00 40737 REFUNDS/REIMBURSEMENTS 0 0 2,998 0 0 0 0.00 00407 TOTAL MISCELLANEOUS & OTHER 485,892 484,411 441,622 424,283 456,043 448,592 5.73 TOTAL REVENUES 485,892 484,411 441,622 424,283 456,043 448,592 5.73 EXPENDITURES 00100 PERSONAL SERVICES 05100 SALARIES 118,777 143,090 91,500 121,710 133,912 146,884 20.68 05101 OVERTIME 8,313 10,500 3,367 10,500 8,000 8,000 (23.81) 05103 ANNUAL BONUS 530 680 420 650 740 820 26.15 05104 SOCIAL SECURITY 9,758 10,947 6,837 10,540 11,473 11,237 6.61 05105 RETIREMENT CONTRIBUTIONS 18,504 20,834 14,761 18,939 21,854 22,856 20.68 05106 HEALTH INSURANCE CONTRIBUTIONS 25,329 43,782 26,064 31,108 38,617 33,821 8.72 05107 WORKERS COMPENSATION 9,413 20,000 15,000 20,000 20,000 20,000 0.00 Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: KMR Page 50 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05109 PART TIME EMPLOYEES 10,278 10,000 2,682 16,068 16,068 0 (100.00) 00100 TOTAL PERSONAL SERVICES 200,902 259,833 160,631 229,515 250,664 243,618 6.14 00200 COMMODITIES 05201 FUEL 13,084 12,000 9,796 12,000 13,000 13,754 14.62 05202 OFFICE SUPPLIES 607 1,000 440 1,000 1,000 1,000 0.00 05206 VEHICLE MAINT/REPAIR 38,995 64,878 64,972 50,000 60,000 60,000 20.00 05208 UNIFORMS 3,038 5,100 4,343 5,100 5,100 5,100 0.00 05209 JANITORIAL SUPPLIES 124 600 490 600 500 500 (16.67) 05210 MISCELLANEOUS 134 300 0 300 200 200 (33.33) 05211 SERVICE FEES 305 300 294 300 300 300 0.00 05212 EQUIPMENT PURCHASED 0 0 200 10,000 10,000 11,000 10.00 05215 BUILDING MAINT. 1,176 2,000 0 2,000 2,000 1,000 (50.00) 05216 MATERIALS - MAINT. 387 1,000 408 1,000 1,000 1,000 0.00 05222 SUPPLIES 8,661 12,000 7,078 8,000 8,000 8,000 0.00 05223 TOOLS 982 1,000 478 1,000 1,000 1,000 0.00 05225 TRASH CAN/DUMP REPLAC/PARTS 1,372 4,000 1,151 2,000 3,000 3,000 50.00 00200 TOTAL COMMODITIES 68,865 104,178 89,650 93,300 105,100 105,854 13.46 Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: KMR Page 51 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 864 800 736 800 900 900 12.50 05301 TELEPHONES 1,755 2,400 1,989 2,400 2,400 2,400 0.00 05302 TRAVEL AND TRAINING 358 500 0 100 100 100 0.00 05306 ADVERTISING 187 200 0 100 300 300 200.00 05310 MISCELLANEOUS 291 300 26 300 300 300 0.00 05313 UTILITIES PURCH FROM WUD 5,259 6,520 4,086 4,000 4,000 4,000 0.00 05319 PROFESSIONAL SERVICES 0 250 0 250 100 100 (60.00) 05320 MEDICAL PROFESS. SERVICES 525 800 237 800 500 500 (37.50) 05323 VEHICLE & PROPERTY INSURANCE 0 0 0 7,000 7,000 7,000 0.00 05352 JANITORIAL EXPENSE 0 200 0 200 0 0 (100.00) 05357 EQUIPMENT RENTAL/LEASE 0 1,000 0 1,000 1,000 1,000 0.00 05358 EQUIPMENT REPAIR & MAINT. 3,021 4,500 1,050 10,000 10,000 10,000 0.00 05360 HAND POWER / HYDRAULIC TOOLS 2,351 5,000 210 5,000 3,000 3,000 (40.00) 05361 HEAVY DUTY EQUIP RENT/LEASE 0 1,000 0 1,000 1,000 1,000 0.00 05365 CONTRACTUAL SERVICES 0 5,000 6,090 5,000 5,000 5,000 0.00 05374 GARBAGE PERMIT FEES 140 250 120 250 250 250 0.00 Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: KMR Page 52 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 00300 TOTAL CONTRACTUAL SERVICES 14,751 28,720 14,544 38,200 35,850 35,850 (6.15) 00600 CAPITAL OUTLAY 05637 OTHER EQUIPMENT 18,268 25,000 5,402 0 7,800 0 0.00 ** UTILITY DUMP TRAILER ** 00600 TOTAL CAPITAL OUTLAY 18,268 25,000 5,402 0 7,800 0 0.00 00700 DEBT SERVICE 05708 GARB TRK W/DUMPSTERS PRINCIPAL 28,705 28,705 29,348 29,348 30,005 30,005 2.24 05709 KNUCKLE BOOM PAYMENT PRINCIPAL 27,591 27,591 28,278 28,278 28,983 28,983 2.49 05712 GARB TRK W/DUMPSTERS INTEREST 3,362 3,362 2,719 2,719 2,062 2,062 (24.16) 05713 KNUCKLE BOOM PAYMENT INTEREST 3,611 3,611 2,923 2,923 2,220 2,220 (24.05) 00700 TOTAL DEBT SERVICE 63,269 63,269 63,268 63,268 63,270 63,270 0.00 900 TOTAL SOLID WASTE (119,837) (3,411) (108,127) 0 6,641 0 0.00 Budget Worksheet 030-SOLID WASTE CITY OF WESTMINSTER Run By: KMR Page 53 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc TOTAL EXPENDITURES 366,055 481,000 333,495 424,283 462,684 448,592 5.73 TOTAL FUND SURPLUS (DEFICIT) 119,837 3,411 108,127 0 (6,641) 0 0.00 Budget Worksheet 040-FIRE DEPARTMENT 1% FUND CITY OF WESTMINSTER Run By: KMR Page 54 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct REVENUES 004 REVENUE 00407 MISCELLANEOUS & OTHER YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40707 MISCELLANEOUS REV 12,104 12,077 11,997 14,598 14,500 14,500 (0.67) 00407 TOTAL MISCELLANEOUS & OTHER 12,104 12,077 11,997 14,598 14,500 14,500 (0.67) 004 TOTAL REVENUE 12,104 12,077 11,997 14,598 14,500 14,500 (0.67) Budget Worksheet 040-FIRE DEPARTMENT 1% FUND CITY OF WESTMINSTER Run By: KMR Page 55 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc TOTAL REVENUES 12,104 12,077 11,997 14,598 14,500 14,500 (0.67) EXPENDITURES 005 EXPENSE 00515 EXPENSE 05310 MISCELLANEOUS 3,754 12,077 3,292 14,598 14,500 14,500 (0.67) 00515 TOTAL EXPENSE 3,754 12,077 3,292 14,598 14,500 14,500 (0.67) 005 TOTAL EXPENSE 3,754 12,077 3,292 14,598 14,500 14,500 (0.67) Budget Worksheet 040-FIRE DEPARTMENT 1% FUND CITY OF WESTMINSTER Run By: KMR Page 56 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc TOTAL EXPENDITURES 3,754 12,077 3,292 14,598 14,500 14,500 (0.67) TOTAL FUND SURPLUS (DEFICIT) 8,350 0 8,705 0 0 0 0.00 Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: KMR Page 57 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct REVENUES 400 RECREATION 00401 INTERGOVENMENTAL REV YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40101 COUNTY ALLOCATION 10,000 10,000 30,000 30,000 30,000 30,000 0.00 00401 TOTAL INTERGOVENMENTAL REV 10,000 10,000 30,000 30,000 30,000 30,000 0.00 00402 LICENSE, PERMITS, & FEES 40206 ADMISSION 48,721 38,300 33,401 58,714 48,000 48,000 (18.25) 40207 CONCESSIONS 37,549 43,600 25,373 39,000 38,000 38,000 (2.56) 40208 REGISTRATION 53,060 55,000 48,950 68,714 55,000 55,000 (19.96) 40209 SPONSOR FEES 20,890 33,369 17,770 32,506 20,000 20,000 (38.47) 40213 TOURNAMENT FEE 2,316 2,316 600 1,500 1,500 1,500 0.00 00402 TOTAL LICENSE, PERMITS, & FEES 162,536 172,585 126,094 200,434 162,500 162,500 (18.93) 00406 GRANT INCOME 40600 PARD GRANT 10,000 17,000 0 10,000 10,000 21,500 115.00 00406 TOTAL GRANT INCOME 10,000 17,000 0 10,000 10,000 21,500 115.00 00407 MISCELLANEOUS & OTHER 40700 SERVICE CHARGES 0 0 30 0 0 0 0.00 40702 DONATIONS 8,509 8,838 9,241 8,500 8,500 8,500 0.00 40703 SALE OF EQUIP/MATERIAL/SCRAP 5,585 11,000 2,470 4,000 5,000 5,000 25.00 40707 MISCELLANEOUS REV 2,112 1,010 0 1,000 1,000 1,000 0.00 Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: KMR Page 58 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40729 TRANSFER FROM GENERAL FUND 210,000 210,000 210,000 210,000 185,000 187,491 (10.72) 40730 HTAX TRANSFER 0 0 0 0 25,000 25,000 0.00 00407 TOTAL MISCELLANEOUS & OTHER 226,206 230,848 221,741 223,500 224,500 226,991 1.56 TOTAL REVENUES 408,742 430,433 377,835 463,934 427,000 440,991 (4.95) EXPENDITURES 00100 PERSONAL SERVICES 05100 SALARIES 48,478 48,479 48,012 49,933 49,933 50,931 2.00 05103 ANNUAL BONUS 1,980 1,980 1,410 2,010 2,040 2,040 1.49 05104 SOCIAL SECURITY 9,381 13,281 8,570 9,940 10,203 10,203 2.65 05105 RETIREMENT CONTRIBUTIONS 7,140 7,059 8,486 7,770 10,895 10,925 40.60 05106 HEALTH INSURANCE CONTRIBUTIONS 4,346 5,049 5,037 5,289 5,288 5,288 (0.02) 05107 WORKERS COMPENSATION 4,700 9,000 7,500 9,000 9,000 9,000 0.00 05109 PART TIME EMPLOYEES 73,718 67,297 63,810 81,492 83,445 83,445 2.40 00100 TOTAL PERSONAL SERVICES 149,743 152,145 142,825 165,434 170,804 171,832 3.87 00200 COMMODITIES 05201 FUEL 4,500 4,500 3,231 4,500 4,500 4,500 0.00 05202 OFFICE SUPPLIES 2,786 3,000 1,289 3,000 3,000 3,000 0.00 05206 VEHICLE MAINT/REPAIR 2,986 10,000 3,370 5,000 5,000 4,500 (10.00) Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: KMR Page 59 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 05208 UNIFORMS 29,025 51,000 22,266 45,000 45,000 45,000 0.00 05209 JANITORIAL SUPPLIES 162 1,500 478 1,500 1,500 1,500 0.00 05210 MISCELLANEOUS 180 500 0 500 500 500 0.00 05211 SERVICE FEES 325 350 314 200 200 200 0.00 05212 EQUIPMENT PURCHASED 159 1,600 37 1,600 1,600 2,600 62.50 00200 TOTAL COMMODITIES 40,123 72,450 30,985 61,300 61,300 61,800 0.82 00300 CONTRACTUAL SERVICES 05300 CELLULAR/WIRELESS PHONES 1,728 2,700 1,602 2,700 2,700 2,700 0.00 05301 TELEPHONES 2,338 3,000 2,184 3,000 3,000 3,000 0.00 05305 MEMBERSHIPS & SUBSCRIPTIONS 1,334 2,500 0 2,500 2,500 2,500 0.00 05306 ADVERTISING 160 250 210 250 500 500 100.00 05310 MISCELLANEOUS 6,189 6,790 3,994 600 600 600 0.00 05313 UTILITIES PURCH FROM WUD 60,274 60,000 57,275 60,000 61,000 61,000 1.67 05314 UTILITIES PURCH FROM OTHER 203 250 171 250 250 250 0.00 05320 MEDICAL PROFESS. SERVICES 730 330 379 500 500 500 0.00 05323 VEHICLE & PROPERTY INSURANCE 0 0 0 1,500 1,500 1,500 0.00 05328 CUSTOMER REFUNDS 985 1,100 3,575 600 1,000 1,000 66.67 Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: KMR Page 60 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Fina l Inc 05330 TROPHY AWARDS 8,587 13,000 6,645 10,000 10,000 10,000 0.00 05331 INSURANCE EXPENSE 0 900 266 900 900 900 0.00 05332 OFFICIALS EXPENSE 20,234 22,000 16,098 22,000 27,000 27,000 22.73 05333 SPORTS/EQUIP SUPPLIES 23,759 33,618 4,834 20,000 25,000 25,000 25.00 05334 GROUNDS EXPENSE 16,888 25,000 17,399 22,000 25,000 24,009 9.13 05335 TOURNAMENT EXPENSE 3,460 5,000 2,314 5,000 5,000 5,000 0.00 05337 CONCESSIONS 16,012 20,000 11,013 20,000 20,000 20,000 0.00 05357 EQUIPMENT RENTAL/LEASE 0 400 0 400 400 400 0.00 00300 TOTAL CONTRACTUAL SERVICES 162,881 196,838 127,959 172,200 186,850 185,859 7.93 00600 CAPITAL OUTLAY 05604 VEHICLES 0 0 29,845 25,000 0 0 (100.00) 05607 FIELD IMPROVEMENTS 0 0 2,568 30,000 21,500 21,500 (28.33) ** POOL FIELD RESTROOMS ** 05637 OTHER EQUIPMENT 6,983 9,000 0 10,000 0 0 (100.00) 00600 TOTAL CAPITAL OUTLAY 6,983 9,000 32,413 65,000 21,500 21,500 (66.92) 400 TOTAL RECREATION (49,012) 0 (43,653) 0 13,454 0 0.00 Budget Worksheet 050-YOUTH RECREATION FUND CITY OF WESTMINSTER Run By: KMR Page 61 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc TOTAL EXPENDITURES 359,730 430,433 334,182 463,934 440,454 440,991 (4.95) TOTAL FUND SURPLUS (DEFICIT) 49,012 0 43,653 0 (13,454) 0 0.00 Budget Worksheet 060-LOCAL DEVELOPMENT CORP CITY OF WESTMINSTER Run By: KMR Page 62 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct REVENUES 700 NON DEPARTMENTAL 00407 MISCELLANEOUS & OTHER 40707 MISCELLANEOUS REV 00407 TOTAL MISCELLANEOUS & OTHER TOTAL REVENUES 16,893 23,000 16,896 16,500 16,500 16,500 0.00 EXPENDITURES 00300 CONTRACTUAL SERVICES 05310 MISCELLANEOUS 3,780 23,000 40,502 16,500 16,500 16,500 0.00 00300 TOTAL CONTRACTUAL SERVICES 3,780 23,000 40,502 16,500 16,500 16,500 0.00 TOTAL EXPENDITURES 3,780 23,000 40,502 16,500 16,500 16,500 0.00 TOTAL FUND SURPLUS (DEFICIT) 13,113 0 (23,606) 0 0 0 0.00 YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 16,893 23,000 16,896 16,500 16,500 16,500 0.00 16,893 23,000 16,896 16,500 16,500 16,500 0.00 Budget Worksheet 080-HOSPITALITY FUND CITY OF WESTMINSTER Run By: KMR Page 63 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct REVENUES 00407 MISCELLANEOUS & OTHER YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40724 FOOD & BEV TAX 139,931 159,000 123,952 162,800 140,000 140,000 (14.00) 00407 TOTAL MISCELLANEOUS & OTHER 139,931 159,000 123,952 162,800 140,000 140,000 (14.00) TOTAL REVENUES 139,931 159,000 123,952 162,800 140,000 140,000 (14.00) EXPENDITURES 00300 CONTRACTUAL SERVICES 05310 MISCELLANEOUS 5,000 5,000 0 6,000 5,000 5,000 (16.67) 05380 RESERVED FOR FUTURE EXPENDITUR 20,000 96,700 22,227 50,500 4,000 4,000 (92.08) 05382 TRANSFER TO GENERAL FUND 0 16,000 16,000 61,000 106,000 106,000 73.77 ** 16,000 FOR PUBLIC SAFETY EXPENSES AT APPLE FESTIVAL $50,000 FOR RETREAT STREET PARK. $40,000 FOR HALL STREET PURCHASE ** 05388 TRANSFER TO YOUTH REC FUND 0 0 0 0 25,000 25,000 0.00 00300 TOTAL CONTRACTUAL SERVICES 25,000 117,700 38,227 117,500 140,000 140,000 19.15 00600 CAPITAL OUTLAY 05630 SPECIAL EVENTS 3,243 5,000 9,320 10,000 0 0 (100.00) 00600 TOTAL CAPITAL OUTLAY 3,243 5,000 9,320 10,000 0 0 (100.00) 00800 OTHER 05800 GRANTS 36,300 36,300 35,300 35,300 0 0 (100.00) 00800 TOTAL OTHER 36,300 36,300 35,300 35,300 0 0 (100.00) TOTAL EXPENDITURES 64,543 159,000 82,847 162,800 140,000 140,000 (14.00) TOTAL FUND SURPLUS (DEFICIT) 75,388 0 41,105 0 0 0 0.00 Budget Worksheet 080-HOSPITALITY FUND CITY OF WESTMINSTER Run By: KMR Page 64 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct REVENUES 00401 INTERGOVENMENTAL REV YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc 40103 STATE ACCOM. TAX 1,996 4,000 4,724 4,000 4,000 4,000 0.00 00401 TOTAL INTERGOVENMENTAL REV 1,996 4,000 4,724 4,000 4,000 4,000 0.00 00407 MISCELLANEOUS & OTHER 40725 LOCAL ACCOM REVENUE 2,112 2,300 1,915 2,300 2,300 2,300 0.00 00407 TOTAL MISCELLANEOUS & OTHER 2,112 2,300 1,915 2,300 2,300 2,300 0.00 TOTAL REVENUES 4,108 6,300 6,639 6,300 6,300 6,300 0.00 EXPENDITURES 00800 OTHER 05801 TRANSFER TO CITY GF 0 4,000 0 4,000 4,000 4,000 0.00 05821 TOURISM PROMOTION 0 2,300 0 2,300 2,300 2,300 0.00 00800 TOTAL OTHER 0 6,300 0 6,300 6,300 6,300 0.00 700 TOTAL NON DEPARTMENTAL (92,609) 0 (24,138) 0 0 0 0.00 Budget Worksheet 080-HOSPITALITY FUND CITY OF WESTMINSTER Run By: KMR Page 65 of 65 6/12/2020 10:15:00AM *** Previous Year *** 2019 *** Current Year *** 2020 *** Next Year *** 2021 Pct YTD Actual Budget YTD Actual Budget Dept Req Admin Rcmd Final Inc TOTAL EXPENDITURES 0 6,300 0 6,300 6,300 6,300 0.00 TOTAL FUND SURPLUS (DEFICIT) 4,108 0 6,639 0 0 0 0.00 PUBLIC NOTICE OF PROPOSED BUDGET FOR THE CITY OF WESTMINSTER FOR FISCAL YEAR JULY 1, 2020 THROUGH JUNE 30, 2021 Pursuant to Section 6-1-80 of the SC Code of Laws, public notice is hereby given that the City of Westminster City Council will hold a public hearing on the proposed municipal budget for the 2020-2021 fiscal year: Date: June 16th, 2020 Time: 6:00 PM Location: Westminster Fire Department Westminster, SC 29693 Appropriation (Funds) Amount General $2,034,286 Utility $7,144,225 Solid Waste $448,592 Fire Dept. 1% Total $14,500 Youth Recreation Fund $440,991 Local Dev. Corp $16,500 HTAX $140,000 ATAX $6,300 Grand Total $10,245,394 Less Interfund Transfer $903,989 Net Appropriations $9,341,405 Interested citizens may receive the proposed budget upon request to jadams@westminstersc.org. Upon the re-opening of City Hall and relaxation of social distancing requirements it can be reviewed at City Hall. The hours are Monday through Friday, 8:00 a.m. to 5:00 p.m. Its general content is as follows: Current Fiscal Year Revenue $11,013,593 Projected Revenue 2020-2021 $10,245,394 Percentage Change In Revenue -6.9% Current Fiscal Year Millage 99.3 mils Current Fiscal Year Expenditures $ 11,013,593 Projected Expenditures 2020-2021 $10,245,394 Percentage Change In Expenditures -6.9% Estimated Millage for 2015-2016 99.3 mils One mil generates $5,602 as based on the total estimated assessed value of all real and personal properties within the Westminster at a 100% collection rate. One mil equals $1.00 per $1,000 of assessed property value. Ordinance #2020-06-16-02 BUDGET ORDINANCE AN ORDINANCE MAKING APPROPRIATIONS FOR CERTAIN EXPENSES, CAPITAL IMPROVEMENTS AND INDEBTEDNESS OF THE CITY OF WESTMINSTER, SOUTH CAROLINA FOR THE YEAR BEGINNING JULY 1, 2020 AND ENDING JUNE 30, 2021 WHEREAS, the City of WESTMINSTER is coming to the conclusion of its fiscal year and will enter into a new fiscal year on July 1, 2020; and WHEREAS, it is necessary and required that prior to entering into a new fiscal year a budget must be passed and adopted for the operation of the city government; and WHEREAS, a series of budget workshops and a public hearing have been held wherein the public has been notified and invited to be present. THEREFORE, BE IT ORDAINED BY THE PEOPLE OF THE CITY OF WESTMINSTER, SOUTH CAROLINA: SECTION 1: The following amounts are hereby appropriated for the operating and capital budget for the City of WESTMINSTER and its activities for the fiscal year beginning July 1, 2020, and ending June 30, 2021, in accordance with the chart of accounts heretofore established for this City: Appropriation Amount General $ 2,034,286 Utility $ 7,144,225 Solid Waste $ 448,592 Fire Dpt. 1% $ 14,500 Youth Recreation $ 440,991 Local Development Corporation $ 16,500 Hospitality Tax $ 140,000 Accommodation Tax $ 6,300 Grand Total $ 10,245,394 Less Interfund Transfers $ 903,989 Net Appropriations $ 9,341,405 SECTION 2: That the attached detailed budget document will reflect the estimated revenues, , and budget appropriations of the City of WESTMINSTER, SOUTH CAROLINA, for the period 1 Page | 1 beginning July 1, 2020 and ending June 30, 2021. A copy of said document will be available for inspection in the Office of the City Clerk. SECTION 3: That the City Clerk has published notice of this public hearing and a summary of the proposed budget in a newspaper of local circulation as required per SC Code 6-1-80. SECTION 4: Appropriations between departments or divisions within one fund, other than salaries, including contingency appropriations, may be transferred therein by the City Administrator for the purpose of equalizations when necessary as long as the original total appropriated balance for the fund is not changed. Appropriations within a department, other than salaries, may be transferred by the City Administrator to make equalizations when necessary. SECTION 5: There is hereby levied a tax of 99.3 mils on all real and personal properties within the City of Westminster as of July 1 st, 2020. This rate is based on an estimated total valuation of property for the purpose of taxation of $6,207,386 and estimated collection rate of 97%. SECTION 6: There is hereby authorized a transfer between the Utility Fund and the General Fund in the amount of 7.51% of total sales revenue to support administrative cost borne by the General F und for the management and administration of water, sewer and electric services provided by the Utility Fund for the benefit of the citizens. This transfer is in addition to any apportionment of direct costs for the operation of the Utility System by the G eneral Fund as these may be identified in the budget document. There is hereby adopted an official Clerks Record listing specific fees, business licenses, and utility rates charged by the City of WESTMINSTER for: a) the use of City facilities and equipment for the purposes of making them available to public b) specific utility rates the proceeds of which are for the maintenance and expansion of its water and sewer system c) the reproduction of public records and other miscellaneous services to cover the actual cost of producing these documents and information under the provision of SC §30-4-30(B) d) Other various fees associated with enhanced direct services provided by the City. The Clerk’s Record is incorporated and adopted by reference and placed on file in the Office of the City Clerk. SECTION 7: That the items identified as capital expenditures within the line item budget are estimated as to cost and approved for acquisition over the upcoming year; SECTION 8: The City’s Position Allocation to Salary Range which provides all jobs and associated pay bands is adopted as the official Pay and Classification Schedule of the City of WESTMINSTER. The Pay and Classification Schedule is incorporated by reference and placed on file in the office of the City Clerk. SECTION 9: Copies of this Budget Ordinance shall be furnished to the City Clerk, and City Administrator, to be kept on file by them for direction in the disbursement of funds. SECTION 10: This ordinance shall become effective on and after July 1, 2020. SECTION 11: That all ordinances and parts of ordinances in conflict herewith are and the same 2 Page | 2 hereby repealed. Given a FIRST READING at the regular meeting of the City Council of the City of WESTMINSTER, SOUTH CAROLINA, held this NINETEETH day of MAY 2020. Passed and adopted after public hearing at the regular meeting of the City Council of the City of WESTMINSTER, SOUTH CAROLINA, held this 16th day of JUNE 2020 . ATTEST: Brian Ramey Mayor, City of WESTMINSTER Jennifer Adams, City Clerk Page | 3 3

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