The URL can be used to link to this page

2020 Adopted Budget Adjustment2020 Annual Municipal Budget Adjustment Fiscal Year January 1, 2010 through December 31, 2020 Administration Department Interoffice Memorandum TO: Mayor and City Council FROM: Rachelle Moody, Interim City Administrator DATE: June 16, 2020 SUBJECT: Budget Adjustment for Fiscal Year 2020 A MESSAGE FROM THE INTERIM CITY ADMINISTRATOR Transmitted herewith is the balanced budget adjustment for Fiscal Year 2020 commencing January 1, 2020, and ending December 31, 2020. The budget adjustment as proposed is submitted to Mayor and City Council for consideration and subsequent adoption. The current outbreak of the 2019 Novel Coronavirus Disease (“COVID-19”), has negatively impacted City revenue streams, specifically in the areas of parks, recreation and tourism. As current prevailing data and guidance as well as governmental orders and directives continue to place limitations on public gatherings, the City has determined that adjustments to the General Fund and Riverfront Central Core Fund are necessary at this time. As with the original adopted budget, the 2020 budget adjustment was developed with the goal of maintaining a high level of service and to offer continued City services at a level that is considered appropriate to maintain the safety and wellbeing of its citizens. There are no proposed millage or other rate modifications included with this budget adjustment. Staff will continue to monitor the impacts of COVID-19 and will bring forth any additional budget adjustments for Council’s consideration if and when necessary. The 2020 budget as originally adopted includes a 2% merit based employee raise across all funds with a previously anticipated July 1 effective date. The budget adjustment does not impact the employee raise at this time and funding options will be brought forth for Council’s consideration as we continue to monitor financial performance and the circumstances surrounding COVID-19. Mayor and City Council II June 16, 2020 GENERAL FUND REVENUE SUMMARY: A brief summary of major income categories within the General Fund follows: Major Sources 2020 Budget 2020 Adjusted Budget % Increase (Decrease) Taxes $7,498,967 $7,498,967 0.00% Licenses & Permits 6,351,000 6,351,000 0.00% Fines & Forfeitures 1,120,000 1,120,000 0.00% Other Sources 750,648 750,648 0.00% Service Charges 1,371,963 646,828 -52.85% Miscellaneous 713,323 698,323 -2.10% Transfers 1,308,967 1,308,967 0.00% TOTAL $19,114,868 $18,374,733 -3.87% SERVICE CHARGES: The proposed adjustment to service charges takes into consideration the cancellations and modifications of athletic and other programs as well as cancellations to rentals of City facilities. MISCELLANEOUS: The proposed adjustment to miscellaneous revenue defers SCPRT PARD Funds to 2021 for upgrade to the playground surface at Riverview Park. EXPENDITURE SUMMARY: A brief summary of major spending categories within the General Fund follows: Functional Areas 2020 Budget 2020 Adjusted Budget % Increase (Decrease) General Government $5,711,790 $5,557,825 -2.70% Public Safety 8,843,667 8,716,761 -1.43% Public Works 1,650,089 1,647,218 -0.17% Parks, Recreation & Tourism 2,909,322 2,452,929 -15.69% TOTAL $19,114,868 $18,374,733 -3.87% Mayor and City Council III June 16, 2020 EXPENDITURES: The following changes are reflected in the adjusted budget above: salary savings due to vacant positions in the areas of General Government, Public Safety and Parks, Recreation & Tourism; employer retirement contribution savings in all functional areas related to the General Assembly’s continuing resolution that contribution rates will remain unchanged for their fiscal year 2021 (7/1/2020-6/30/2021); savings from the cancellations and modifications of athletic and other programs as well as cancellations to rentals of City facilities; promotion of one Public Safety sergeant position to lieutenant; additional information technology purchases to include server upgrades and switch replacements for SLED compliance for Public Safety as well as backup storage expansion for citywide needs; and increase of administrative contingency to provide a more conservative balance for the ever changing environment created by COVID-19. RIVERFRONT/CENTRAL CORE FUND EXPENDITURE SUMMARY: A brief summary of the Riverfront/Central Core Fund follows: EXPENDITURES: The changes reflected in the budget adjustment above include postponement of non-critical projects due to the financial impact of COVID-19 on income generated from tourism and related activities. 2020 Budget 2020 Adjusted % Increase Tourism $2,040,781 $1,578,631 -22.65% General Fund CITY OF NORTH AUGUSTA FY 2020 GENERAL FUND SUMMARY OF REVENUES ACCOUNT NUMBER/DESCRIPTION ACTUAL BUDGET ACTUAL 2Q1$ 2Q12 07/31/2019 ADOPTED PROPOSEDADJUSTMENT 2020 TAXES 10 -3000 -010 CURRENT TAXES 7,160,003 7,185,560 14,005,160 7,395,967 7,395.967 10- 3000 -020 DELINQUENT TAXES 14,749 10,000 5,204 10,000 10.000 10 -3000 -030 PENALTIES 75,419 55,000 110,932 55,000 55,000 10 -3000 -040 AMBIOPHARM FILOT 33,168 33,000 96,725 38,000 38,000 TOTAL TAXES 7,283,339 7,283,560 14,218,020 7,498,967 7,498,967 LICENSES & PERMITS 10- 3100 -010 BUS LICENSE/FRANCHISE FEE 6,009,285 6,105,770 7,715,188 5,980,000 5.980,000 10 -3100 -020 BUILDING PERMITS 299,448 300,000 514,274 326,000 326.000 10- 3100 -030 ELECTRICAL PERMITS 23,047 20,000 34,222 18,000 18.000 10- 3100 -040 MECHANICAL PERMITS 19,740 18,000 33,094 16,000 16.000 10- 3100 -050 PLUMBING PERMITS 12,189 12,000 20,098 11,000 11,000 TOTAL LICENSES & PERMITS 6,363,709 6,455,770 8,316,876 6,351,000 6,351,000 FINES & FORFEITURES 10- 3200 -010 PUBLIC SAFETY FINES 808,531 1,070,000 1,228,275 1, 100,000 1,100,000 10- 3200 -020 DRUG RELATED ACCT -STATE 21,425 15,000 26,485 15,000 15,000 10 -3200 -025 DRUG RELATED ACCT - FEDERAL 4,244 5,000 4,694 5,000 5.000 TOTAL FINES & FORFEITURES 834,200 1,090,000 1,259,454 1,120,000 1,120,000 FROM OTHER SOURCES 10 -3300 -043 STATE SHARED REVENUE 500,909 502,230 928,081 526,107 526,107 10- 3300 -045 STATE ACCOMMODATIONS TAX 61,399 44,000 107,508 49,500 49.500 10- 3300 -048 MERCHANTS' INVENTORY TAX 54,790 54,700 95,836 54,700 54,700 10- 3300 -049 LOCAL OPTION SALES TAX 21,146 20,000 28,873 20,000 20,000 10- 3300 -070 LAW ENF NET GRANT- 2JC10002 5,120 10,000 3,989 10,000 10.000 10 -3300 -071 US TREASURY -DOJ GRANT 4,719 146,521 2,002 5,000 5.000 10 -3300 -076 HWY SAFETY GRANT PT- 2019- HS -14- 12,239 0 148,871 85,341 85,341 TOTAL FROMOTHER SOURCES 660,321 777,451 1,315,160 750,648 750,648 SERVICE CHARGES 10 -3400 -010 FIRE PROTECTION FEES 62,182 63,000 59,889 41,760 41,760 10- 3400 -015 CUSTOM STREET LIGHT FEES 82,045 87,244 123,625 85,808 85.808 10- 3400 -018 MUNICIPAL CENTER RENTALS 103,084 103,800 95,111 83,300 15,000 10 -3400 -026 RECREATION FEES -SPEC PROGRAMS 24,209 29,600 36,848 29,600 26,350 06/17/2020 Page 1 CITY OF NORTH AUGUSTA FY 2020 GENERAL FUND SUMMARY OF REVENUES PROPOSED ACTUAL BUDGET ACTUAL ADOPTED ADJUSTMENT ACCOUNT NUMBER/DESCRIPTION 2018 2Q12 07/31/2019 2020 10- 3400 -028 RECREATION FEES - VOLLEYBALL 6,438 5,880 5,320 5,500 5,500 10- 3400 -029 RECREATION FEES - SOCCER 69,503 65,990 88,203 68,650' 50,650 10- 3400 -030 RECREATION FEES -MISC 129,984 145,000 131,026 150,000 50,000 10- 3400 -031 RECREATION FEES - BASKETBALL 45,065 51,300 52,807 46,410 32,000 10- 3400 -032 RECREATION FEES - SOFTBALL 28,024 29,820 43,409 29,920 18,070 10- 3400 -033 RECREATION FEES - FOOTBALL 45,162 36,065 39,505 39,770 28,000 10- 3400 -034 RECREATION FEES - BASEBALL 62,909 55,420 106,942 58,940 38,690 10- 3400 -035 CONCESSION STANDS REVENUE 173,273 150,000 228,883 170,000 75,000 10- 3400 -036 COMMUNITY CENTER RENTALS 63,346 64,800 80,890 69,770 10,000 10- 3400 -037 RVP ACTIVITIES CENTER FEES 178,249 164,035238,701 164,035 130,000 10- 3400 -038 RECREATION FACILITIES RENTALS 32,115 24,000 50,255 29,000 18,000 10- 3400 -039 ACTIVITIES CENTER TOURN/RENTAI 269,956 241,000 346,612 299,500 22,000 TOTAL SERVICE CHARGES 1,375,543 1,316,954 1,728,026 1,371,963 646,828 MISCELLANEOUS REVENUE 10- 3500 -010 OTHER INCOME 368,922 376,417 627,839 444,323 429.323 10- 3500 -015 SCDOT TRAFFIC SIGNAL REVENUE 78,641 14,550 21,330 0 0 10- 3500 -020 COMMUNICATION TOWER RENTAL 164,062 190,000326,943 194,000 194,000 10- 3500 -050 INTEREST ON INVESTMENTS 79,267 44,000 122,029 75,000 75,000 TOTAL MISCELLANEOUS REVENUE 690,892 624,967 1,098,140 713,323 698,323 TRANSFERS 10- 3900 -010 TRANS FROM ENTERPRISEFUNDS 693,251 1,119,237 2,310,919 1,191,682 1,191,682 10- 3900 -015 TRANSFER FROM RF /CC FUND 40,075 40,075 80,150 40,075 40,075 10- 3900 -045 TRANSFER FROM CAPITAL PROJECT: 178,260 76,354 153,564 77,210 77,210 TOTAL TRANSFERS 911,586 1,235,666 2,544,633 1,308,967 1,308,967 TOTAL GENERAL FUND 18,119,589 18,784,368 30,480,311 19,114,868 18,374,733 06/17/2020 Pagc 2 FY 2020 CITY OF NORTH AUGUSTA GENERAL FUND SUMMARY OF REVENUES - TEXT EXPECTED ADOPTED PROPOSED ADJUSTMENT ACCOUNT REVENUE CHANGE AMOUNT CHANGE AMOUNT CURRENT TAXES 7,395,967 0 7,395,967 0 7,395,967 10- 3000 -010 TAXTYPE ASSESSED VALUES TAX @ 72.00 MILLS REAL PROPERTY AIKEN COUNTY DIGEST (6C) - 79,960,640 AIKEN COUNTY TIF BASE (6T) - 831,138 EDGEFIELD COUNTY DIGEST - 814,740 MERCHANTS /MFG /RR /UTILITY /BUSINESS FF - 10,208,781 PERSONAL - BOATS /MOTORS /AIRCRAFT - 392,160 AUTOS @ 6.00% ASSESSMENT (ESTIMATE) - 12,610,660 TOTALS 5,757,166 59,842 58, 661 735,032 28,236 907,968 104,818,119 7,546,905 GENERAL FUND TAX (GROSS) 7,546,905 COLLECTION RATE (98.0 %) 7,395,967 RECOMMENDED MILLS - 73.50 MILLS WITH 1.5 MILL TO THE CAPITAL PROJECTS FUND VALUE OF A MILL - 102,722 DELINQUENT TAXES 10,000 10- 3000 -020 ESTIMATED UNCOLLECTEDTAXES AT 12 -31 -2018 0 10,000 0 10,000 PENAL'T'IES 55,000 0 55,000 0 10- 3000 -030 PENALTY OF 15% PLUS COST OF 2.10 PER DELINQUENTTAX NOTICE ON MAY 1, 2020 55,000 AMBIOPIIARM FII,O'1' 10 -3000 -040 38,000 0 38,000 0 38,000 BUS LICENSE /FRANCHISE FEE 5,980,000 10- 3100 -010 ELECTRICITY FRANCHISE (5 %) - 1,300,000 GAS FRANCHISE (5 %) - 300,000 CABLETV FRANCHISE (5 %) - 280,000 INSURANCECOMPANIES (2 %) - 2,400,000 TELECOMMUNICATIONS FEE (1 %) - 62,000 ALL OTHERS - 1,638,000 TOTAL ESTIMATED REVENUE 5,980,000 0 5,980,000 0 5,980,000 BUILDING PERMITS 10- 3100 -020 326,000 0 326,000 0 326,000 06/17/2020 Page 3 CITY OF NORTH AUGUSTA FY 2020 GENERAL FUND SUMMARY OF REVENUES - TEXT EXPECTED ADOPTED PROPOSED ADJUSTMENT ACCOUNT REVENUE CHANGE AMOUNT CIIANGE AMOUNT ELECTRICAL PERMITS 18,000 0 18,000 0 18,000 10 -3100 -030 MECHANICAL PERMITS 16,000 0 16,000 0 16,000 10- 3100 -040 PLUMBING PERMITS 11,000 0 11,000 0 11,000 10- 3100 -050 PUBLIC SAFETY FINES 1,100,000 10- 3200 -010 MUNICIPAL COURT FINES - 473,577 CRIME VICTIM'S ASSESSMENT - 47,758 CRIME VICTIM'S 25 SURCHARGE ON NON - TRAFFIC CASES - 8,050 STATE MANDATED (REMITTED TO STATE) - 570,615 0 1,100,000 0 1,100,000 TOTAL ESTIMATED REVENUE 1,100,000 DRUGRELATED ACCT -STATE 15,000 0 15,000 0 15,000 10- 3200 -020 THIS REVENUE OFFSET BY EXPENDITURES IN ACCOUNT #10- 4100 -250 DRUG RELATED ACCT - FEDERAL 5,000 0 5,000 0 5,000 10 -3200 -025 THIS REVENUE OFFSET BY EXPENDITURES IN ACCOUNT #10 -4100 -255 STATE SHARED REVENUE 526,107 10- 3300 -043 AID TO SUBDIVISIONS - 506,107 MANUFACTURERS EXEMPTION PROGRAM - 20,000 TOTAL STATE SHARED REVENUE 526,107 0 526,107 0 526,107 STATE ACCOMMODATIONS TAX 95,000 - 45,500 49,500 0 49,500 10- 3300 -045 GENERAL FUND PORTION 28,500 EXCESSS DESIGNATED ASTERC FOR CHAMBER AND JOJ 21,000 65% TO TOURISMRELATED EXPENDITURES ACCOMMODATIONS TAX FUND 45,500 MERCHANTS' INVENTORY TAX 54,700 0 54,700 0 54,700 10- 3300 -048 THIS REVENUE SOURCE IS FROZEN AT THE 1988 LEVEL 06/17/2020 Page 4 FY 2020 ACCOUNT LOCAL OPTION SALES "TAX 10- 3300 -049 LOCAL OPTION SALES TAX - EDGEFIELD COUNTY CITY OF NORTH AUGUSTA GENERAL FUND SUMMARY OF REVENUES - TEXT EXPECTED ADOPTED REVENUE CHANGE AMOUNT 20,000 0 20,000 PROPOSED ADJUSTMENT CHANGE AMOUNT 0 20,000 LAW ENF NET GRANT -2JC 10002 10,000 0 10,000 10- 3300 -070 LAW ENFORCEMENT NETWORK GRANT (SEE ACCT #10- 4100 -248 FOR EXPENDITURES) 0 10,000 US "TREASURY -DOJ GRANT 10- 3300 -071 USDOJ BVP GRANT FOR BULLET PROOF VEST 5,000 0 5,000 0 5,000 1IWY SAFETY GRANT PT- 2019- I -IS -I 10- 3300 -076 SCDPS GRANT OFFICER - 85,341 NEW SCDPSGRANT OFFICER - 159,242:N0 244,583 - 159,242 TOTAL REVENUE 244,583 85,341 0 85,341 FIRE PROTECTION FEES 10- 3400 -010 570 CUSTOMERS @ 72 (ON CITY WATER SERVICE) - 41,040 10 CUSTOMERS @ 72 (CONTRACT) - 720 41,760 0 TOTAL ESTIMATED REVENUE 41,760 41 ,760 0 41,760 CUSTOM STREET LIGI -IT FEES 85,808 0 10- 3400 -015 3,109 CUSTOMERS @ 2.30 PER MONTH (PARTIALLY OFFSETS COST OF ELECTRICITY FOR STREET LIGHTS, ACCOUNT #10- 4210 -220) 85,808 0 85,808 MUNICIPAL CENTERRENTALS 10- 3400 -018 EVENINGS AND WEEKENDS 29 RENTALS @ 2,000 = 3 RENTALS @ 1,500 = 11 RENTALS @ 900 = 3 RENTALS @ 500 = MONDAY THRU THURSDAY 4 RENTALS @ 600 = 0 RENTALS @ 150 = MISCELLANEOUS = TOTAL REVENUE 83,300 0 83,300 68,300 15,000 58,000 PALMETTO TERRACE (FRIDAY, SATURDAY, SUNDAY - 10 HR) 4,500 PALMETTO TERRACE (MONDAY THRU THURSDAY - 10HR) 9,900 PALMETTO TERRACE (MONDAY THRU THURSDAY - 8 HR) 1,500 COUNCIL CHAMBER 8AM -5PM) 2,400 PALMETTO TERRACE 0 PALMETTO TRAINING ROOM 7,000 83,300 ADDITIONAL HRSFOR PALMETTO TERRACE CHARGED AT 250 /HOUR *COVID -19 BUDGET ADJUSTMENT 06/17/2020 Page 5 FY 2020 CITY OF NORTH AUGUSTA GENERAL FUND SUMMARY OF REVENUES - TEXT EXPECTED ADOPTED PROPOSED ADJUSTMENT ACCOUNT REVENUE CHANGE AMOUNT CHANGE AMOUNT RECREATION FEES -SPEC PROGRA 29,600 0 29,600 -3,250 26,350 10- 3400 -026 JAZZERCISE / GYMNASTICS - 3,600 ADVENTURE CAMP - 17,500 CLASSES (OTHER) - 2,000 TENNIS - 6,500 TOTAL ESTIMATED REVENUE 29,600 OFFSET BY EXPENDITURE ACCOUNT #10- 4300 -265 *COVID -19 BUDGET ADJUSTMENT RECREATION FEES - VOLLEYBALL 10- 3400 -028 OF TEAMS IN 2020 - 10 OF PARTICIPANTS IN 2020 - 82 RESIDENT'S FEE - 62 @ 50 = 3,100 NON - RESIDENT'S FEE - 20 @ 70 = 1,400 LEAGUE SPONSORS - 2 @ 500 = 1,000 5,500 0 5,500 0 5,500 TOTAL ESTIMATED REVENUE = 5,500 OFFSET BY EXPENSE ACCOUNT #10- 4300 -278 RECREATION FEES - SOCCER 68,650 0 68,650 - 18,000 50,650 10- 3400 -029 OF TEAMS IN 2020 - 93 OF PARTICIPANTS IN 2020 - 1107 RESIDENT'S FEE - 692 @ 50 = 34,600 NON - RESIDENT'S FEE - 415 @ 70 = 29,050 LEAGUE SPONSORS - 8 @ 500 = 4,000 SOCCER CAMP - = 1,000 TOTAL ESTIMATED REVENUE = 68,650 OFFSET BY EXPENDITURE ACCOUNT #10 -4300 -277 *COVID -19 BUDGET ADJUSTMENT RECREATION FEES -MISC 10- 3400 -030 JACK -O- LANTERN JUBILEE 150,000 0 150,000 - 100,000 50,000 VENDOR REGISTRATIONS, OTHER - 45,000 FESTIVAL RIDETICKETS - 25,000 LOP PERMITS - 15,000 STATE ACCOMMODATIONS TAX - 10,000 SPONSORSHIPS - 55,000 TOTAL ESTIMATED REVENUE 150,000 OFFSET BY EXPENDITURE ACCOUNT #10 -4325 -270 *COVID -19 BUDGET ADJUSTMENT 06/17/2020 Page 6 FY 2020 ACCOUNT CITY OF NORTH AUGUSTA GENERAL FUND SUMMARY OF REVENUES - TEXT EXPECTED ADOPTED PROPOSED ADJUSTMENT REVENUE CIIANGE AMOUNT CHANGE AMOUNT RECREATION FEES- BASKETBALL 46,410 0 46,410 - 14,410 32,000 10- 3400 -031 OF TEAMS IN 2020 - 68 YOUTH OF PARTICIPANTS IN 2020 - 577 YOUTH RESIDENT'S FEE - 374 @ 50 = 18,700 NON - RESIDENT'S FEE - 203 @ 70 = 14,210 LEAGUE SPONSORS - 11 @ 500 = 5,500 BASKETBALL CAMPS - 50 @ 100 = 5,000 GATE FEE = 3,000 TOTAL ESTIMATED REVENUE = 46,410 OFFSET BY EXPENDITURE ACCOUNT #10- 4300 -273 *COVID -19 BUDGET ADJUSTMENT RECREATION FEES- SOF•I'BAI.I. 10- 3400 -032 OF TEAMS IN 2020 - 19 OF PARTICIPANTS IN 2020 - 221 29,920 RESIDENT'S FEE NON - RESIDENT'S FEE GIRLS SPONSOR FEES ALLSTAR PLAYERS FEES ADULT SOFTBALL TEAMS YOUTH SOFTBALL CAMPERS TOURNAMENT REVENUE 0 29,920 - 11,850 18,070 154 @ 50 = 7,700 67 @ 70 = 4,690 19 @ 250 = 4,750 48 @ 35 = 1,680 16 @ 475 = 7,600 25 @ 60 = 1,500 2,000 TOTAL ESTIMATED REVENUE = 29,920 OFFSET BY EXPENDITURE ACCOUNT #10 -4300 -274 *COVID -19 BUDGET ADJUSTMENT RECREATION FEES- FOOTBALL 39,770 10- 3400 -033 0 39,770 - 11,770 28,000 OF TEAMS IN 2020 - 16 FOOTBALL / 13 CHEERLEADING OF PARTICIPANTS IN 2020 - 431 FOOTBALL RESIDENT'S FEE - 187 @ 50 = 9,350 FOOTBALL NON- RESIDENT'S FEE - 80 @ 70 = 5,600 CHEERLEADING RESIDENT'S FEE - 114 @ 55 = 6,270 CHEERLEADING NON - RESIDENT'S FEE - 50 @ 80 = 4,000 SPONSORS FEE - 16 @ 250 = 4,000 YOUTH FOOTBAL CAMP FEES - 31 @ 50 = 1,550 CHEERLEADER CAMP FEES - 40 @ 100 = 4,000 GATE FEE - = 5,000 TOTAL ESTIMATED REVENUE = 39,770 OFFSET BY EXPENDITURE ACCOUNT #10- 4300 -275 *COVID -19 BUDGET ADJUSTMENT RECREATION FEES - BASEBALL 10- 3400 -034 OF TEAMS IN 2020 - 55 OF PARTICIPANTS IN 2020 - 617 58,940 RESIDENT'S FEE NON - RESIDENT'S FEE LEAGUE SPONSOR ALLSTAR FEE BASEBALL CAMP TOURNAMENT REVENUE 0 58,940 - 20,250 38,690 391 @ 50 = 19,550 226 @ 70 = 15,820 8 @ 1,500 = 12,000 96 @ 45 = 4,320 25 @ 50 = 1,250 6,000 TOTAL ESTIMATED REVENUE = 58,940 OFFSET BY EXPENDITURE ACCOUNT #10 -4300 -276 *COVID -19 BUDGET ADJUSTMENT 06/17/2020 Page 7 FY 2020 ACCOUNT CONCESSION S'T'ANDS REVENUE 10- 3400 -035 2020 ESTIMATED GROSS SALES - 170,000 2020 ESTIMATED EXPENDITURES - (130,000) CITY OF NORTH AUGUSTA GENERAL FUND SUMMARY OF REVENUES - TEXT EXPECTED REVENUE 170,000 ADOPTED CHANGE AMOUNT 0 170,000 ESTIMATED NET 40,000 SEE EXPENDITURE ACCOUNT #10 -4300 -280 *COVID -19 BUDGET ADJUSTMENT PROPOSED ADJUS'T'MENT CHANGE AMOUNT 95,000 75,000 COMM(JNI1'Y CENTER RENTALS 10- 3400 -036 PRESENTRATE 5 RENTALS @ 2,000 = 10,000 30 RENTALS @ 1,300 = 39,000 4 RENTALS @ 1,000 = 4,000 6 RENTALS @ 600 = 3,600 0 RENTALS @ 500 = 0 2 RENTALS @ 300 = 600 21 RENTALS @ 200 = 4,200 15 RENTALS @ 100 = 1,500 28 RENTALS @ 75 = 2,100 10 RENTALS @ 40 = 400 CIVIC CLUB RENTAL = 1,050 MISCELLANEOUS = 3,320 69,770 0 69,770 - 59,770 HOLIDAY RATE - FULL CENTER (12 HR) BANQUET Al /A2 WITH KITCHEN (10 HR) BANQUET Al /A2 WIHT KITCHEN (10HR- WEEKDAY) BANQUET A2 WITH KITCHEN (8 HR) BANQUET Al WEEKDAY BANQUET B1 /B2 WITH KITCHEN (8 HR) BANQUET B1 /B2 W/O KITCHEN (8 HR) BANQUET B1 W/O KITCHEN (4 I -IR) MEETING C1 /C2 (4 HR) MEETING Al /A2 OR B1 /B2 (4 HR) TOTAL REVENUE 69,770 *COVID -19 BUDGET ADJUSTMENT 10,000 RVPACI'IVITIES CENTER FEES 10 -3400 -037 MEMBERSHIP INSIDE SINGLE ANNUALSEMI - ANNUAL QUARTERLY INSIDE FAMILY ANNUALSEMI - ANNUAL QUARTERLY OUTSIDESINGLE ANNUALSEMI - ANNUAL QUARTERLY OUTSIDE FAMILY ANNUALSEMI - ANNUAL QUARTERLY SENIOR ANNUALSEMI - ANNUAL QUARTERLY MISCELLANEOUS DAY PASSES TOTAL REVENUE 164,035 0 164,035 - 34,035 MEMBERS22% 3% 26% 5% 1% 1% 5% 3% 7% 1% 0% 1% 21% 1% 3% INDIVIDUAL # 56675650118163412575175146345353065490 RATE TOTAL 75 42,450 50 3,750 3019,500 175 20,650 125 2,000 75 2,550 125 15,625 75 5,625 45 7,875 350 4,900 200 1,200 115 3,910 5026,750 35 1,050 20 1,300 10 4,900 164,035 NOTE: SEE SUPPORT SECTION FOR FURTHER ANALYSIS *COVID -19 BUDGET ADJUSTMENT 1 30,000 RECREATION FACILITIES RENTAL; 10- 3400 -038 LIONS MEMORIAL FIELD - 12,000 RIVERVIEW PARK PAVILLION - 8,000 MISCELLANEOUS RENTALS - 4,000 TROLLEY REVENUE - 5,000 29,000 0 29,000 - 11,000 TOTAL ESTIMATED REVENUE 29,000 *COVID -19 BUDGET ADJUSTMENT 18,000 06/17/2020 Page 8 FY 2020 ACCOUNT ACTIVITIES CENTER TOURN /RENT 10- 3400 -039 RVP ACTIVITIES CENTER NIKE PEACH JAM (RENTAL /PROGRAM SALES) - 250,000 SEE ACCT #10- 4330 -270 FOR TOURNAMENT EXPENSES) CITY OF NORTH AUGUSTA GENERALFUND SUMMARY OF REVENUES - TEXT EXPECTED REVENUE 299,500 ADOPTED CIIANGE AMOUNT 0299,500 OTHER TOURNAMENT REVENUE* CAT SHOW DOG SHOW MISCELLANEOUS RENTALS GYMS, CLASSROOMS, ETC) 40,000 2,500 2,000 5,000 299, 500 OTHER TOURNAMENT REVENUE AAU SUPER REGIONAL, MARCH 13 THRU 15 - 6,000 ICE BREAKER RENTAL, MARCH 27 THRU 29 - 6,000 LINEAGE OF CHAMPIONS RENTAL, APRIL 24 THRU 26 - 6,000 AC TOURNAMENT RENTALS - 22,000 OTHER TOURNAMENT REVENUE COVID -19 BUDGET ADJUSTMENT 40,000 PROPOSED ADJUSTMENT CHANGE AMOUNT 277,500 22,000 OTHER INCOME 469,323 - 25,000 10- 3500 -010 ADVERTISED SALE OF CITY ASSETS RESOURCE OFFICER PROGRAM SPECIAL STUDY FEES APPLICATION FEES /SALE OF PUBLICATIONS BILLBOARD RENTAL I -20 /FIVE NOTCH ROAD JEFFERSON DAVIS HWY AIKEN COUNTY 911 GRANT PUBLIC SAFETY SPECIALS CHRISTMAS CLASSIC SCPRT PARD FUNDS RECREATION TRAILS GRANT MASC GRANT FOR MASTERPLAN SCMIT /SCMIRFF PROGRAMS SURPLUS RETURN MISCELLANEOUS SALE OF CONTRACTOR DECALS SPECIAL PROJECTINCOME (SIDEWALKS, CURB /GUTTER) 444,323 15,000 50,000 35,500 (SEE ACCT #10 -4100 -102) 5,000 20,000 (SEE ACCT #10 -4055 -265) 7,800 16,400 (SEE ACCT #10 -4100 -226) 110,000 (SEE ACCT #10 -4100 -101) 25,000 (SEE ACCT #10 -4100 -249) 15,000 *COVID -19 BUDGET ADJUSTMENT 100,000 25,000 (SEE ACCT #10- 4300- 265):NO 49,623 10,000 429,323 SCDOT TRAFFIC SIGNAL REVENUI 0 10- 3500 -015 0 0 0 0 COMMUNICATION TOWER RENTA 194,000 10- 3500 -020 0 194,000 0 194,000 INTEREST' ON INVES'I'MI;NTS 75,000 0 75,000 10- 3500 -050 ESTIMATE BASED ON PREVIOUS EXPERIENCE AND CURRENT INTEREST RATES 0 75,000 06/17/2020 Page 9 CITY OF NORTH AUGUSTA FY 2020 GENERAL FUND SUMMARY OF REVENUES - TEXT EXPECTED ADOPTED PROPOSED ADJUSTMENT ACCOUNT REVENUE CHANGE AMOUNT CHANGE AMOUNT TRANS FROM ENTERPRISE FUNDS. 1,191,682 0 1,191,682 0 1,191,682 10- 3900 -010 REIMBURSEMENT FROM THE ENTERPRISE FUNDS FOR SERVICES PROVIDED BY THE GENERAL FUND AS CALCULATED BY BENCHMARKING (INDIRECT COST) STUDY ANALYSIS FROM THE SANITATION SERVICES FUND - 365,814 FROM THE UTILITIES 0 & M FUND - 798,831 FROM THE STORMWATER FUND - 27,037 TOTAL ESTIMATED TRANSFER 1,191,682 TRANSFER FROM RF /CC FUND 40,075 0 40,075 0 40,075 10- 3900 -015 TRANSFER FROM RIVERFRONT /CENTRAL CORE FUND DESIGNATED TO OFFSET LOSS OF NAAHC RENT TRANSFER FROM CAPITAL PROJE( 77,210 0 77,210 0 77,210 10- 3900 -045 SCRS & PORS SC 2018 -2019 APPROPRIATION ACT CREDIT 06/17/2020 Page 10 CITY OF NORTH AUGUSTA FY 2020 GENERAL FUND SUMMARY OF EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YR ACTUAL 07/31 /2019 BUDGET REQUEST CHANGE AMOUNT ADJUSTMENT BUDGET GENERAL GOVERNMENT 4000 CITY COUNCIL 177,046 242,450 185,261 180,713 965 181,678 0 181,678 4010 ADMINISTRATION 385,334539,409 547,337 654,750 - 151,390 503,360 -RR 220 415,140 4015 INFORMATION TECHNOLOGY 265,941 1,136,953 780,057 1,128,685 - 353,642775,043 -23576 751,467 4020 JUSTICE & LAW 651,575 978,256 797,399 808,794 3,376812,170 0 812,170 4030 COMMUNITY PROMOTION 72,052 116,037 74,187 138,697 - 72,600 66,097 0 66,097 4040 FINANCE 437,329 642,212 439,038447,512 3,727 451,239 -1 322 449,917 4045 HUMAN RESOURCES 277,464 358,951 300,851 484,428 - 230,228 254,200 -628 253,572 4050 BUILDING STANDARDS 438,475 575,130 431,828 459,636 - 16,910 442,726 -30297 412,429 4055 PLANNING & DEVELOPMENT 177,750 531,781 412,999 852,758 - 395,463 457,295 -1 166 456,129 4060 CITY BUILDINGS 321,659 417,795 377,666310,053 0310,053 -5 000 305,053 4065 PROPERTY MAINTENANCE 1,322,8982,172,867 1,389,086 1,625,620 - 167,691 1,457,929 -1 756 1,454,173 TOTAL GENERAL GOVERNMENT 4,527,522 7,711,842 5,735,709 7,091,646 - 1,379,856 5,711,790 - 153,965 5,557,825 PUBLIC SAFETY 4100 PUBLIC SAFETY TOTAL PUBLIC SAFETY 8,425,371 12,867,932 8,596,074 11,358,592 - 2,514,925 8,843,667 -126 906 8,716,761 8,425,371 12,867,932 8,596,074 11,358,592 - 2,514,925 8,843,667 - 126,906 8,716,761 PUBLIC WORKS 4200 ENGINEERING 207,283350,893 245,507 289,818 - 37,484252,334 -781 251,551 4210 STREET LIGHT/TRAFFIC 483,900606,989 487,952 724,818 - 250,000 474,818 0 474,818 4220 STREETS & DRAINS 908,826 1,338,157 930,912 982,555 - 59,618 922,937 -2 ORR 920,849 TOTALPUBLIC WORKS 1,600,0092,296,040 1,664,371 1,997,191 - 347,102 1,650,089 -2,871 1,647,218 PARKS, REC & TOURISM 4300 RECREATION 902,362 1,433,831 958,177 1,212,886 - 302,658 910,228 -19166 891,062 4310 PARKS 453,208 570,987 464,709 822,826 - 237,582 585,244 -55 128 530,116 4315 PROPERTY MAINTENANCE 482 -482 0 0 0 0 0 0 4320 COMMUNITY CENTER 163,141 250,092 176,079 227,065 - 57,900 169,165 -17 849 151,316 4325 TOURISM 398,890 476,303 397,330448,727 - 41,046 407,681 - 157931 249,750 4330 RVPACTIVITIES CTR 761,169 1,161,138 791,919 1,024,510 - 187,506837,004 -206319 630,685 TOTAL PARKS, REC & TOURISM 2,679,251 3,891,870 2,788,214 3,736,014 - 826,6922,909,322 - 456,393 2,452,929 TRANSFERS 5900 TRANSFERS 750,453 848,854 0 0 0 0 0 0 TOTAL TRANSFERS 750,453 848,854 0 0 0 0 0 0 TOTAL GENERAL FUND 17,982,606 27,616,537 18,784,368 24,183,443 - 5,068,575 19,114,868 - 740,135 18,374,733 6/15/2020 Page 11 FY 2020 4000 CITY COUNCIL 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERAL FUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 111,234 149,664 107,881102,972 818 103,790 0 103,790 TITLE CURRENT REQUESTED RECOMMENDED APPROVED MAYOR 1 PT 1 PT 1 PT 1 PT COUNCIL MEMBERS 6 PT 6 PT 6 PT 6 PT EXECUTIVE SECRETARY /CITY CLERK 1 1 1 1 TOTAL 1F,7PT 1F,7PT 1F,7PT 1F,7PT 104 FICA 7,491 9,932 8,253 7,877 63 7,940 0 7,940 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 12,622 19,559 13,357 13,455 84 13,539 0 13,539 SCRS - 16.06% OF COVERED SALARIES 108 EMPLOYEE INSURANCE 22,60734,774 23,700 31,600 0 31,600 0 31,600 MEDICAL AND DENTAL COVERAGE 109 WORKERSCOMPENSATION 2,190 4,261 3,102 3,090 0 3,090 0 3,090 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES/POSTAGE 3,068 4,808 4,025 4,200 0 4,200 0 4,200 OFFICESUPPLIES /POSTAGE /SMALL OFFICE EQUIPMENT 2I4 DUES/TRAINING/TRAVEL 10,947 9,809 13,510 10,985 0 10,985 0 10,985 MUNICIPAL ASSOCIATION OFSOUTH CAROLINA (1) - 1,000 SC MUNICIPAL FINANCE OFFICERS, CLERKS & TREASURERS ASSOC - 1,200 NORTH AUGUSTA CHAMBER OF COMMERCE ANNUAL MEETING - 750 PLANNING SEMINAR - 2,000 SOUTH CAROLINA PUBLIC RECORDS ASSOCIATION - 35 MISCELLANEOUS - 1,000 MAYOR'S TRAVEL - 5,000 226 CONTRACTS/REPAIRS 697 209 1,000 0 0 0 0 0 261 ADVERTISING 205 799 300 300 0 300 0 300 MISCELLANEOUS ADVERTISING - 300 265 PROFESSIONAL SERVICES 673 1,105 4,050 50 0 50 0 50 MISC FOR MUNICIPAL ELECTION COMMISSION - 50 271 SPECIAL DEPT SUPPLIES 4,367 4,182 2,850 2,850 0 2,850 0 2,850 MISCELLANEOUS - 850 MAYOR - 2,000 6/17/2020 Page 12 FY 2020 4000 CITY COUNCIL 282 INSURANCE CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL 07/31/2019 BUDGET REQUEST CHANGE AMOUNT CHANGU BUDGET 1,116 1,849 1,233 1,334 0 1,334 0 1,334 SELF FUNDED THROUGH SCMIRFF 290 CONTINGENCIES 170 1,500 2,000 2,000 0 2,000 0 2,000 UNDESIGNATED CONTINGENCIES TOTAL PERSONAL SERVICES 156,144 218,190 156,293 158,994 965 159,959 0 159,959 TOTAL OPERATING EXPENSES 20,90224,260 28,968 21,719 0 21,719 0 21,719 TOTAL CITY COUNCIL 177,046242,450 185,261180,713 965 181,678 0 181,678 6/17/21120 Page 13 FY 2020 4010 ADMINISTRATION 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 139,120 257,008 256,823 361,660 - 51,349 310,311 - 112,311 198,000 TITLE CURRENT REQUESTED RECOMMENDED APPROVED CITY ADMINISTRATOR 1 1 1 1* ASSISTANT CITY ADMINISTRATOR 1 1 1 1 PUBLIC INFORMATION OFFICER 0 1 0 0 TOTAL 2 3 2 2 VACANT POSITION TO BE FILLED BY 8/2020 AND INTERIM ADMINISTRATOR ADJUSTMENT. 104 FICA 10,616 19,596 19,647 27,667 -3,928 23,739 -8,589 15,150 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 19,506 38,933 38,678 58,083 -8,263 49,820 - 19,011 30,809 SCRS - 16.06% OF COVERED SALARIES 108 EMPLOYEEINSURANCE 8,198 21,038 15,800 23,700 -7,900 15,800 -5,300 10,500 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 4,411 7,234 3,924 7,357 0 7,357 0 7,357 SELF FUNDED THROUGH SCMIT 201 CONTRIBUTIONS 15,00022,500 15,000 18,000 -3,000 15,000 0 15,000 ECONOMICDEVELOPMENT PARTNERSHIP - 18,000:YES BUT 15,000 210 GENERAL SUPPLIES /POSTAGE 1,880 2,719 2,250 1,850 0 1,850 0 1,850 OFFICE SUPPLIES /POSTAGE /SMALL OFFICE MACHINES /FURNITURE - 1,650 MISCELLANEOUS - 200 214 DUES/TRAINING/TRAVEL, 12,395 19,378 15,300 21,000 -6,000 15,000 0 15,000 MUNICIPAL ASSOCIATION OF SOUTH CAROLINA (2) - 2,000 INTERNATIONAL CITY /COUNTYMANAGERS ASSOCIATION (2) - 4,000 SOUTH CAROLINA CITY COUNTY MANAGERS ASSOCIATION (2) - 6,000 ROTARY, NORTH AUGUSTA CHAPTER - 1,000 STAFF DEVELOPMENT - 900 NA CHAMBER OF COMMERCE AM CONNECTION /BUSINESS AFTER HOURS - 100 VEHICLE ALLOWANCE (NON- TAXABLE PORTION OF 650 /MONTH) - 6,000:SEE 101 MISCELLANEOUS - 1,000 224 DAM PROCESSING 0 1,605 2,500 4,000 -4,000 0 0 0 PC ANDSOFTWARE FOR PIO POSITION:NO 226 CONTRACT'S /REPAIRS 4,171 6,239 8,500 6,650 -1,850 4,800 0 4,800 MAINTENANCE ON COPIER /COLOR COPIES (ADMINISTRATION) - 4,800 CELL PHONE CONTRACT (PIO) - 1,850:NO 265 PROFESSIONAL SERVICES 100,091 23,497 65,000 65,000 - 50,000 15,000 0 15,000 ECONOMIC DEVELOPMENT - 65,000:REDUCED TO 15,000 6/17/2020 I Page 14 FY 2020 4010 ADMINISTRATION 282 INSURANCE 290 CONTINGENCIES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRAGZUAL 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 7,407 16,730 9,9939,783 0 9,783 0 9,783 SELF FUNDED THROUGH SCMIRFF 62,539 104,231 93,922 50,000 - 15,100 34,900 56,991 91,891 COVID -19 BUDGET ADJUSTMENT TOTAL PERSONAL SERVICES 181,852 343,808 334,872 478,467 - 71,440 407,027 - 145,211 261,816 TOTAL OPERATING EXPENSES 203,482 196,900 212,465 176,283 - 79,950 96,333 56,991 153,324 TOTAL ADMINISTRATION 385,334 540,709 547,337 654,750 - 151,390 503,360 - 88,220415,140 6/17/2020 Page 15 FY 2020 CITY OF NORTH AUGUSTA GENERALFUND DEPARTMENTAL EXPENDITURES 4015 INFORMATIONTECHNOLOGY PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL. 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 101 SALARIES/WAGES 77,007344,955 251,837 251,837 2,718254,555 - 69,630 184,925 TITLE CURRENT REQUESTED RECOMMENDED APPROVED MANAGER OF INFORMATION TECHNOLOGY 1 1 1 1* GIS ANALYST 1 1 1 1 NETWORK OPERATIONS COORDINATOR 1 1 1 1 ** PC NETWORK TECHNICIAN 1 1 1 1 TOTAL 4 4 4 4 POSITION VACANT THRU 03/2020 * *POSITION VACANT AFTER03/2020 104 FICA 5,55625,102 19,266 19,266 207 19,473 -5,326 14,147 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 10,105 53,56940,248 42,766 428 43,194 - 14,420 28,774 SCRS - 16.06% OF COVERED SALARIES FORS - 18.74% OF COVERED SALARIES 108 EMPLOYEEINSURANCE 12,296 31,557 23,700 23,700 0 23,700 0 23,700 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 1,3969,961 7,257 7,214 0 7,214 0 7,214 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES/POSTAGE 1,3274,274 4,900 4,900 0 4,900 0 4,900 OFFICE SUPPLIES - 1,000 TECH SUPPLIES - 2,500 PAPER /INK GIS - 700 TECH NET SUBS. - 700 214 DUES/TRAINING/TRAVEL 0 2,160 3,350 3,350 0 3,350 0 3,350 GEOSPATIAL ADMINS ASSOC - 75 GIS TRAINING - 3,000 GMIS - 200 MTASC - 75 217 AUTO OPERATING 8,367 1,303 1,790 1,790 455 2,245 0 2,245 FUEL (650 GALS UNLEADED @ 2.60) - 1,690 :FUEL @ 2.30 1,495 OIL /FLUIDS - 100 MILEAGE REIMBURSEMENT - 650 220 UTILITY SERVICES 96,260 164,276 96,700 96,700 0 96,700 0 96,700 TELEPHONE - 65,000 COMCAST SERVICES - 16,100 SPIRIT - 15,600 6/17/2020 Page 16 FY 2020 CITY OF NORTH AUGUSTA GENERALFUNDDEPARTMENTAL EXPENDITURES 4015 INFORMATION '1'ECI INOL,OGY PREVIOUS ACTUAL YR nCUAI, 07/31/2019 224 DATA PROCESSING CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 25,010 140,964 97,270 295,270 - 198,000 97,270 MICROSOFT ENTERPRISE LIC. AGREEMENT INTERACTIVE WEB HOSTING (VC3) DELL EQUALOGIC VIRTUAL SERVER MAINT VARIPHY CALL ACCOUNTING SOFTWARE MAINT COUNTY AERIAL IMAGERY GIS WEBSITE CONTR /HOSTING /UPGRADES ESET VIRUS SOFTWARE MAINT. DESKTOPS BARRACUDA SPAM /VIRUS /ARCHIVER APP MAINT AVUPGRADESCOUNCILSTREAMING MUN CNTR SECURITY CAMERA CABLING UPGRADE 0 97,270 9,800 ARC GIS - 13,500 9,570 VERISIGNSSL CERT REN - 3,000 16,000 WATCHGUARD LIVE SEC - 2,700 1,700 IT CERT UPDATES - 9,000 10,000 VEEAM BACKUP VIRTUAL - 8,500 6,0003,500 4,000 150,000:CPST IV 40,000:YES,BUTCPF 8,000:CPST IV 226 CONTRACTS /REPAIRS 23,083 235,398 142,100142, AT &T -CISCO MAINTENANCE - 29,000 AV SUPPORT SERVICES - 10,000 SECURITY CAMERA /SERVERS CONTRACT - 4,000 WEBSITE MAINTENANCE CELL PHONES (2) LASERFICHE /WORKFLOW VM WARE MAINTENANCE 6,700 2,400 30,600 32,000 100 0 142,100 0142,100 MOBILE MIFI DEVICE - 800 GPS SUBSCRIPTION - 900 RECEIPT PRINTERS - 600 CITRIX MAINTENANCE - 1,600 LASER PRINTERS - 3,500 LAN SYSTEM MAINTENANCE - 20,000 265 PROFESSIONAL SERVICES 0 0 0 15,000 - 15,000 0 SECURITY ASSESSMENT - 10,000:NO VULNERABILITY SCAN - 5,000:NO 0 0 282 INSURANCE 0 24,902 SELF FUNDED THROUGH SCMIRFF 17,145 16,998 0 16,998 0 16,998 299 LEASE PURCHASE 2016 LEASE 2020 LEASE 5,534 31,148 2020 5,89421,450 5,894 5,894 21,450 20212022 21,450 21,450 27,344 0 2023 2024 21,- 450 21,450 27,344 383 OFFICE MACHINES 0 67,386 68,600 176,900 - 140,900 36,000 65,800 101,800 PERSONAL COMPUTER REPLACEMENT & PUBLIC SAFETY SLED REQ. - 66,800 DELL EQL LOGIX HOST REPLACE(5) DELL BACKUP STORAGE EXP DELL EQL SWITCH REPLACE(2) MAIN CORE SWITCH REPLACE 42,500:YES,BUT L/P 35,000:YES 8,400:NO 55,000:YES,BUT L/P 384 AUTOMOTIVE EQUIPMENT 0 0 0 25,000 INTERMEDIATE UTILITY VEHICLE:SEE 217 25,000 0 0 0 TOTAL PERSONAL SERVICES TOTAL OPERATING EXPENSES TOTAL CAPITAL OUTLAY TOTAL INFORMATION TECHNOLOGY 106,360 465,143 342,308 344,783 3,353 159,581 604,424 369,149 582,002 - 191,095 0 67,386 68,600 201,900 - 165,900 265,941 1,136,953 780,057 1,128,685 - 353,642 348.136 390,907 36,000 775,043 89,376 0 65,800 258,760 390,907 I01,800 23,576 751,467 6/17/2020 Page 17 FY 2020 4020 JUSTICE & LAW 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERALFUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YR ACTUAL 07/31/2019 BUDGET REOUEST MAN G . AMQUNT CHANGE BUDGET 127,790 184,420 122,526 122,526 2,975 125,501 0 125,501 TITLE CURRENT REQUESTED RECOMMENDED APPROVED MUNICIPAL JUDGE 1PT 1PT 1PT 1PT ASSISTANT MUNICIPAL JUDGE 1PT 1PT 1PT 1PT CITY ATTORNEY 1PT 1PT 1PT 1PT TOTAL 3PT 3PT 3PT 3PT 104 FICA 9,338 13,490 9,3739,373 228 9,601 0 9,601 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 15,179 24,012 16,258 17,338 173 17,511 0 17,511 SCRS - 16.06% OF COVERED SALARIES 108 EMPLOYEE INSURANCE 7,536 10,519 7,900 7,900 0 7,900 0 7,900 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 2,285 4,846 3,530 3,510 0 3,510 0 3,510 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES/POSTAGE 0 16 500 500 0 500 0 500 213 STATE FEES/FINES 421,572 654,435 565,986 570,615 0 570,615 0 570,615 STATE MANDATED ASSESSMENT ON MUNICIPAL FINES SEE REVENUE ACCOUNT 10- 3200 -010 214 DUES/TRAINING/TRAVEL 2,813 1,877 4,988 5,738 0 5,738 0 5,738 MUNICIPAL JUDGE SEMINARS (2) - 875 CITY ATTORNEY SEMINARS - 650 ASSISTANT MUNICIPAL JUDGE SEMINAR - 875 DUES FOR MUNICIPAL ASSOCIATION (2) - 338 SEMINARS FORCOURT /RECORDS PERSONNEL (2) CLERK OF COURT SEMINAR IN FEB /OCT (1 PERSON) SCMACC - 1 PERSON) - 3,000 226 CONTRACTS/REPAIRS 9,74422,072 10,800 12,200 0 12,200 0 12,200 CELL PHONE - 1,400 MAINTENANCE ON COURT RECORDER - 1,500 MAINTENANCE AND LICENSE FOR COURTVIEW - 9,300 255 JURY SERVICES 1,800 2,710 2,000 3,000 0 3,000 0 3,000 JURY FOR COURT SESSIONS 6/17/2020 Page 18 FY 2020 4020 JUSTICE & LAW CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES 265 PROFESSIONAL SERVICES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YRACTIIAI, 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANQ BUDGET 20,440 23,037 22,725 23,025 0 23,025 0 23,025 RMC RECORDING FEES - 300 CITY CODE UPDATE /INTERNET - 1,000 CITY CODE ELECTRONIC PDF - 75 CITY CODE UPDATE HARD COPY - 2,550 CITY CODE NOW SERVICES /ORD BANK - 350 CITY CODE ADMIN FEE - 350 WESTLAW -NEXMONTHLY SUBSCRIPTION - 3,800 INDIGENT DEFENSE - 14,600 268 JUVENILE DETENTION 4,305 1,150 3,500 3,700 0 3,700 0 3,700 JUVENILE DETENTION 282 INSURANCE 28,772 35,672 27,313 29,369 0 29,369 0 29,369 SELF FUNDED THROUGH SCMIRFF TOTAL PERSONAL SERVICES 162,128 237,286 159,587 160,647 3,376 164,023 0 164,023 TOTAL OPERAfINGEXPENSES 489,447740,970 637,812648,147 0 648,147 0 648,147 TOTAL JUSTICE & LAW 651,575 978,256 797,399 808,794 3,376 812,170 0812,170 6/17/2020 Page 19 FY 2020 CITY OF NORTH AUGUSTA GENERAL FUNDDEPARTMENTALEXPENDITURES 4030 COMMUNITY PROMOTION 104 FICA PREVIOUS ACTUAL YRACTUAI• 07/31/2019 8 0 NO BUDGETED POSITIONS CURRENT DEPT ADMINISTRATION BUDGET REQUEST CHANGE AMOUNT 0 0 0 0 PROPOSED PROPOSED CIIANG1 BUDGET 0 0 201 CONTRIBUTIONS 48,200 70,800 48,200 111,800 - 72,600 BEST FRIEND EXPRESS - 4,500: CULTURAL ARTS COUNCIL - 19,900: HERITAGE COUNCIL OF NA - 10,000: NANCY CARSON LIBRARY - 20,000: NORTH AUGUSTA FORWARD - 30,000: OLD TOWNE PRESERVATION ASSOC - 20,000: PUBLIC EDUCATION PARTNERS - 5,000: THE RECING CREW - 2,400: 2017 LEVEL YES,BUT 2017 NEW REQUEST YES,BUT 2017 YES,BUT 2017 2017 LEVEL YES, BUT 2017 YES,BUT 2017 39,200 0 39,200 LEVEL 9,900 FOR COUNCIL CONSIDERATION LEVEL 10,800 LEVEL 10,000 8,000 SEE 10 -4065 -265 LEVEL 2,000 LEVEL 2,000 214DUES/TRAINING/TRAVEL 5,931 11,862 5,931 5,931 0 5,931 0 5,931 MUNICIPAL ASSOCIATION OF SOUTH CAROLINA - 5,931 4,650 BASE RATE ON POPULATION OF 21,348 (BETWEEN 10,000- 25,000) PLUS 0.06 PER CAPITA. CALCULATION EVALUATED DURING CENSUSYEARS. 271 SPECIAL DEPT SUPPLIES 12,580 28,173 16,400 17,550 0 17,550 INDUSTRIAL & SMALL BUSINESS DEVELOPMENT - 5,000 CITY PROMOTIONS - 3,550 CUTTING HORSE FUTURITY - 1,000 CSRA ADMINISTRATORS MEETING HOST - 500 EMPLOYEE NIGHT -GREEN JACKETS BASEBALL - 500 MAYOR'S BUSINESS DEVELOPMENT - 250 MAYOR'S PRAYER BREAKFAST - 2,000 MAYOR'S SPEAKER HONORARIUMS - 1,500 DOWNTOWN AUGUSTA INDEPENDENCE DAY CELEBRATION - 1,000 JOINT SPONSORSHIP YELLOW JACKET RADIO SPOTS - 1,250 MISCELLANEOUS - 1,000 0 17,550 282 INSURANCE 5,333 5,202 3,656 3,416 SELF FUNDED THROUGH SCMIRFF 0 3,416 0 3,416 TOTAL PERSONAL SERVICES TOTAL OPERATING EXPENSES TOTAL COMMUNITY PROMOTION 6/17/2020 8 0 0 0 72,043 116,037 74,187 138,697 72,052 116,037 74,187 138,697 0 0 0 72,600 66,097 0 72,60066,097 0 66,097 0 66,097 Page 20 FY 2020 4040 FINANCE 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YRACTUAL 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 276,861 362,625 270,688 274,267 3,064277,331 0 277,331 TITLE CURRENT DIRECTOR OF FINANCE /SUPPORT SERVICES 1 BUSINESS LICENSE INSPECTOR /DEP TAXCLERK 1 TAX CLERK 1 FINANCE MANAGER 1 TOTAL 4 REQUESTED 1111 4 RECOMMENDED 1111 4 APPROVED 1111 4 104 FICA 20,494 26,617 7.65% OF COVERED SALARIES 20,708 20,981 235 21,216 0 21,216 105 EMPLOYEE RETIREMENT 38,158 54,246 40,766 44,047 428 44,475 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 1,322 43,153 108 EMPLOYEE INSURANCE 30,143 42,075 31,600 31,600 0 31,600 MEDICAL AND DENTAL COVERAGE 0 31,600 109 WORKERS COMPENSATION 6,437 13,782 SELF FUNDED THROUGH SCMIT 7,789 7,754 0 7,754 0 7,754 110 UNEMPLOYMENT INSURANCE 06,520 REIMBURSING EMPLOYER 0 0 0 0 0 0 210 GENERAL SUPPLIES/POSTAGE 9,83420,317 10,000 GENERAL OFFICE ANDCOMPUTER SUPPLIES TAX AND BUSINESS LICENSE NOTICES 10,000 0 10,000 0 10,000 214 DUES/TRAINING/TRAVEL 2,2722,814 2,225 2,225 0 2,225 SC MUNICIPAL FINANCE OFFICERS, CLERKS, TREASURERS ASSOCIATION - GOVERNMENT FINANCEOFFICERS ASSOCIATION OF US & CANADA - SC BUSINESS LICENSE OFFICIALS ASSOCIATION (2) AMERICAN PAYROLL ASSOCIATION TRAINING /TRAVEL 1502501252001,500 0 2,225 224 DATA PROCESSING 12,734 TAX BILLING (CSRA MERCHANT SERVICES MERCHANT SERVICES 31,532 11,000 11,000 0 11,000 COMPUTER SERVICE) - 2,000 ON -LINE TAX PAYMENTS) - 7,000 COUNTER TAX PAYMENTS) - 2,000 0 11,000 226 CONTRACTS/REPAIRS 15,010 32,716 17,700 17,500 FINANCE PROGRAMS - 16,000 CELL PHONES (1) - 550 0 17,500 MISCELLANEOUS - 350 COPIER MAINTENANCE - 600 0 17,500 6/17/2020 Page 21 FY 2020 4040 FINANCE 261 ADVERTISING CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED MAMA, BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET 723 400 1,000 1,000 0 1,000 0 1,000 TAX DEADLINE ADS BUSINESS LICENSE DEADLINE ADS BUDGET ADS 265 PROFESSIONAL SERVICES 20,600 43,848 22,25024,030 024,030 0 24,030 AUDIT - 23,780 OTHER - 250 282 INSURANCE 4,062 4,719 3,312 3,108 0 3,108 • 0 3,108 SELF FUNDED THROUGH SCMIRFF TOTAL PERSONAL SERVICES 372,093 505,866 371,551 378,649 3,727382,376 -1,322 381,054 TOTAL OPERATING EXPENSES 65,236 136,34767,48768,863 0 68,863 0 68,863 TOTALFINANCE 437,329 642,212 439,038 447,512 3,727 451,239 - 1,322 449,917 6/17/2020 Page 22 FY 2020 4045 HUMAN RESOURCES 101 SAI.ARIES/WAGES CITY OF NORTH AUGUSTA GENERAL FUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YR ACTI IAI, 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 147,129 188,452 125,918 149,960 - 21,482 128,478 0 128,478 TITLE CURRENT REQUESTED RECOMMENDED APPROVED MANAGER OF HUMAN RESOURCES 1 1 1 1 HUMAN RESOURCES SPECIALIST 1 1 1 1 RISK SPECIALIST (JULY START) 0 1 0 0 TOTAL 2 3 2 2 104 FICA 11,393 13,629 9,633 11,472 -1,643 9,829 0 9,829 7.65% OF COVERED SALARIES 105 EMPLOYEERETIREMENI' 21,08829,139 18,963 24,084 -3,46520,619 -628 19,991 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEE INSURANCE 19,882 24,272 19,01023,700 -7,900 15,800 0 15,800 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 2,285 4,691 3,284 3,607 0 3,607 0 3,607 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES/POSTAGE 2,297 3,229 2,200 2,200 0 2,200 0 2,200 AUGUSTADATA STORAGE - 300 OFFICE SUPPLIES /MISCELLANEOUS - 1,900 214 DUES/TRAINING/TRAVEL 2,466 6,212 2,900 4,000 0 4,000 0 4,000 MUNICIPAL ASSOCIATION - 1,500 HR PROFESSIONAL MEMBERSHIPS - 1,000 HR /RM /LEGAL TRAINING /SEMINARS - 1,500 226 CONTRACTS/REPAIRS 783 2,453 1,850650 0 650 0 650 MAINTENANCE ON COPIER /FAX /PRINTER - 650 261 ADVERTISING 4,120 10,434 9,600 9,600 09,600 0 9,600 EMPLOYMENT ADVERTISING 265 PROFESSIONAL SERVICES 36,514 40,637 38,999 174,998 - 137,37837,620 0 37,620 NURSE PRACTICIONER (40 HRS /WK) - 151,840:N0 LABOR LAW POSTER UPDATES - 646 EMPLOYEE DOT /NON -DOT SCREENS - 1,164 BACKGROUND CHECKS - 1,128 EMPLOYMENT PHYSICALS - 5,798 EAP - 6,384 URGENT CARE CO -PAY - 7,500 COMP STUDY - 15,000 6/17/2020 Page 23 FY 2020 4045 I IUMAN RESOURCES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES 271 SPECIAL DEPT SUPPLIES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YR ACTUAI, 07/31/2019 BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET 29,507 22,129 54,042 74,860 - 58,360 16,500 0 16,500 TRAINING AND ORIENTATIONSUPPLIES /RETIREMENT PLAQUES /ETC - 2,000 EMPLOYEE RECOGNITION - 5,000 SERVICE AWARDS - 26,360:SEE 101 ACCTS CHRISTMAS LUNCHEON - 3,500 EMPLOYEE SAFETY AWARDS - 20,000:SEE 101 ACCTS NURSE PRACTICIONER AREA UPFIT - 10,000:NO NURSE PRACTICIONER SUPPLIES - 8,000:NO WELLNESS PROGRAM - 5,000 HEALTH FAIR - 1,000 282 INSURANCE 0 7,862 5,452 5,297 0 5,297 0 5,297 SELF FUNDED THROUGH SCMIRFF 385 MACHINES /EQUIPMENT NO REQUEST 0 5,813 9,000 0 0 0 0 0 TOTAL PERSONAL SERVICES 201,777 260,183176,808 212,823 - 34,490 178,333 -628 177,705 TOTAL OPERATING EXPENSES 75,68792,956 115,043 271,605 - 195,738 75,867 0 75,867 TOTAL CAPITAL OUTLAY 0 5,813 9,000 0 0 0 0 0 TOTAL 1-IUMAN RESOURCES 277,464358,951 300,851 484,428 - 230,228 254,200 -628 253,572 6/17/2020 Page 24 CITY OF NORTH AUGUSTA FY 2020 GENERAL FUNDDEPARTMENTAL EXPENDITURES 4050 BUILDING STANDARDS 101 SALARIES/WAGES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL 07/31/2019 AUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 262,739359,170 259,141 280,916 3,009 283,925 - 23,464 260,461 TITLE CURRENT REQUESTED RECOMMENDED APPROVED SUPERINTENDENT BUILDING STANDARDS 1 1 1 1 BUILDING STANDARDS INSPECTOR II 1 2 2 2 BUILDING STANDARDS INSPECTOR I 2 1 1 1 PUBLIC WORKS SECRETARY .5 .5 .5 .5 BUILDING STANDARDS INSPECTOR III 0 1PT 1PT 1PT* TOTAL 4.5 4.5,1PT 4.5,1PT 4.5,1PT COVID -19 BUDGET ADJUSTMENT 102 OVERTIME PAY 314 0 0 0 0 0 0 0 104 FICA 19,721 26,106 19,824 21,490 230 21,720 -1,795 19,925 7.65% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 105 EMPLOYEERETIREMENT 36,777 54,204 39,02745,115 451 45,566 -5,03840,528 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEE INSURANCE 33,906 47,289 35,500 35,550 035,550 035,550 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 16,313 10,081 7,267 7,423 0 7,423 0 7,423 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES/POSTAGE 3,490 4,327 3,000 3,000 0 3,000 0 3,000 OFFICE SUPPLIES - 1,000 PRINTING - 1,000 FORMS /DECALS - 1,000 214 DUES/TRAINING/TRAVEL 3,483 5,062 3,925 3,925 0 3,925 CERTIFICATION TRAINING - 3,150 INTERNATIONAL CODE COUNCIL - 135 NATIONAL FIRE PROTECTION ASSOC - 175 INTERNATIONAL ASSOCIATION OF ELECTRICAL INSPECTORS - 120 CENTRAL BUILDING INSPECTORS ASSOC OF SC - 40 BUILDING OFFICIALS OF SC - 175 BUSINESS LICENSE OFFICIALS ASSOC - 60 ASSOCIATION OF STATE FLOODPLAIN MANAGERS - 50 SC ASSOCIATION FOR HAZARD MITIGATION - 20 0 3,925 217 AUTO OPERATING 5,129 5,787 6,400 6,400 -600 5,800 0 5,800 FUEL (2,000 GALS UNLEADED @ 2.60) - 5,200:FUEL @ 2.30 4,600 TIRES /BATTERIES /FLUIDS - 500 PREVENTIVE MAINTENANCE - 700 6/17/2020 Page 25 FY 2020 4050 BUILDING STANDARDS 224 DATA PROCESSING CITY OF NORTH AUGUSTA GENERALFUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL YR ACTUAL 07/31/2019 9,986 16,263 PERMITTING SOFTWARE ANNUAL ONLINE PERMITTING UPGRADE MERCHANT SERVICES (COUNTER CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED BUDGETRLOUEST CIIANGE AMOUNT CHANGE BUDGET 10,000 31,000 - 20,000 11,000 MAINTENANCE FEE - 7,50020,000:CPST IV PAYMENTS) - 3,500 0 11,000 226 CONTRACTS/REPAIRS 3,940 6,357 CELL PHONES (4) - 2,400 VEHICLE REPAIRS - 600 COPIER MAINTENANCE - 550 3,790 3,550 0 3,550 0 3,550 241 UNIFORMS /CLOTHING 1,352 UNIFORMS - 1,000 2,212 1,550 1,550 SAFETY /PPE - 550 0 1,550 0 1,550 265 PROFESSIONAL SERVICES NO REQUEST 26,556 2,016 24,000 0 0 0 0 0 271 SPECIAL DEPT SUPPLIES 4,332 6,133 STANDARD CODE BOOKS - 1,800 TOOLS - 400 2,6002,600 0 2,600 MISCELLANEOUS - 400 0 2,600 282 INSURANCE 1,409 3,535 SELF FUNDED THROUGH SCMIRFF 1,959 3,272 0 3,272 0 3,272 299 LEASE PURCHASE 2016 LEASE 2017 LEASE 2019 LEASE 9,028 26,766 13,845 13,845 2020 2021 4,626 -- 4,379 4,379 4,840 4,840 2022 4,840 0 13,845 2023 4,840 0 13,845 384 AUTOMOTIVE EQUIPMENT NO REQUEST 0 0 0 0 0 0 0 0 TOTAL PERSONAL SERVICES TOTAL OPERATING EXPENSES TOTALCAPITAL OUTLAY TOTAL BUILDING STANDARDS 369,770 496,851 360,759 390,494 3,690 394,184 - 30,297363,887 68,70478,458 71,069 69,142 - 20,600 48,542 0 48,542 0 0 0 0 0 0 0 0 438,475575,309 431,828 459,636 - 16,910 442,726 - 30,297 412,429 6/17/2020 Page 26 FY 2020 CITY OF NORTH AUGUSTA GENERAL FUNDDEPARTMENTAL EXPENDITURES 4055 PLANNING & DEVELOPMENT PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YRACTUAL 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 101 SALARIES/WAGES 89,670 337,460 236,887 321,591 - 82,034239,557 0 239,557 TITLE CURRENT REQUESTED RECOMMENDED APPROVED DIR PLANNING & DEVELOPMENT 1 1 1 1 PLANNER 1 2 1 1 SECRETARY .5 .5 .5 .5 CODES ENFORCEMENT OFFICER 1 1,1PT 1 1 TOTAL 3.5 4.5,1PT 3.5 3.5 104 FICA 6,27824,283 18,122 24,602 -6,276 18,326 0 18,326 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 11,371 50,745 37,132 51,648 - 13,207 38,441 -1,166 37,275 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEE INSURANCE 18,80636,816 27,65035,550 -7,900 27,650 0 27,650 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 3,174 7,897 5,075 6,786 0 6,786 0 6,786 SELF FUNDED THROUGH SCMIT 110 UNEMPLOYMENT INSURANCE 2,934 REIMBURSING EMPLOYER 0 0 0 0 0 0 0 210 GENERAL SUPPLIES/POSTAGE 2,065 5,932 4,400 6,400 0 6,400 -1,000 5,400 OFFICE SUPPLIES /POSTAGE /SMALL OFFICE MACHINES *DEVELOPMENT CODE REWRITE 214 DUES/TRAINING/TRAVEL 2,127 1,823 8,000 11,000 -2,0009,000 -5,000 4,000 MEMBERSHIPS (3 PROFESSIONALS) - 3,000:YES,BUT 2 PROFESSIONALS 2,000 AMERICAN PLANNING ASSOCIATION SC CHAPTER, APA TRAINING (STAFF, PC, BZA) - 2,000 APA NATIONAL TRIP - 2,000 NEW EMPLOYEE AND CODE ENFORCEMENT TRAINING - 2,000:YES,BUT CODE ENFORCEMENT TRAINING 1,000 VARIOUS CONTINUING EDUCATION - 2,000 *DEVELOPMENT CODE REWRITE 217 AUTO OPERATING 0 962 5,492 6,800 -698 6,102 0 6,102 FUEL (2,327 GALS UNLEADED @ 2.60) - 6,050:FUEL @ 2.30 5,352 MAINTENANCE - 750 224 DATA PROCESSING 7,016 7,440 7,775 17,775 - 10,000 7,775 0 7,775 TRACKIT ANNUAL MAINTENANCE - 7,775 UPGRADE TO E- TRACKIT - 10,000:CPST IV 6/17/2020 Page 27 FY 2020 CITY OF NORTH AUGUSTA GENERALFUND DEPARTMENTAL EXPENDITURES 4055 PLANNING & DEVELOPMENT PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTIIA!, 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE DUDGET 226 CONTRACTS/REPAIRS 2,322 3,243 4,800 4,400 0 4,400 0 4,400 COPIER MAINTENANCE AND COPIES - 2,000 CELL PHONE CONTRACT (2) - 2,400 261 ADVERTISING 1,357 1,595 1,000 2,000 0 2,000 0 2,000 PUBLIC HEARING POSTINGS AND NOTICES 265 PROFESSIONAL SERVICES 22,365 32,000 38,000 320,000 - 250,000 70,000 10,000 80,000 TRANSPORATION PLAN(MATCH ONLY) - 20,000 COMPREHENSIVE PLAN UPDATE - 80,000:YES,BUT 2YR FUND PLAN IN CPF DEVELOPMENT CODE REWRITE - 120,000:YES,BUT 2019 SURPLUS OVERLAY STUDY(ONLY) - 50,000:INCLUDE W /DEV CODE REWRITE INCIDENTAL CONSULTING(PARKING,AREA PLANS, ETC)- 50,000 271 SPECIAL DEPT SUPPLIES 3,347 3,012 6,600 16,850 -6,500 10,350 -4,000 6,350 PLOTTING SUPPLIES, MAPS FOR SALE - 1,000 MISCELLANEOUS (NON- CAPITAL) EQUIPMENT - 1,500 PLAT & COVENANT RECORDING FEES - 500 REIMBURSED BY FEES, SEE ACCOUNT #10- 3500 -010) DEPARTMENT LAPTOP - 1,500 NEW EMPLOYEE COMPUTER SYSTEM - 3,000:YES,BUT 1,500 CODE ENFORCEMENT SPECIALTY TOOLS AND SUPPLIES - 1,350 CODE ENFORCEMENT FIELD COMPUTER UPGRADE - 500 PLANNING COMMISSION IPADS AND SOFTWARE - 2,500 FURNITURE FOR PLANNER POSITION - 5,000:NO DEVELOPMENT CODE REWRITE 282 INSURANCE 2,852 3,790 2,000 3,690 0 3,690 0 3,690 SELF FUNDED THROUGH SCMIRFF 299 LEASE PURCHASE 2,066 9,090 2,066 2,066 4,752 6,818 0 6,818 2020 2021 2022 2023 2024 2016 LEASE 2,066 -- -- -- -- 2020 LEASE 4,752 4,752 4,752 4,752 4,752 383 OFFICE MACHINES 0 5,813 8,000 0 0 0 0 0 384 AUTOMOTIVE EQUIPMENT 0 0 0 21,600 - 21,600 PICK UP TRUCK (REP. 4055 -006) - 21,600:YES,BUT L/P 0 0 0 TOTAL PERSONAL SERVICES 132,233 457,201 324,866 440,177 - 109,417 330,760 -1,166 329,594 TOTAL OPERATING EXPENSES 45,517 68,888 80,133 390,981 - 264,446 126,535 0 126,535 TOTAL CAPITAL OUTLAY 0 5,813 8,000 21,600 - 21,600 0 0 0 TOTAL PLANNING & DEVELOPMENT 177,750 531,901 412,999 852,758 - 395,463 457,295 -1,166 456,129 6/17/2020 Page 28 FY 2020 4060 CITYBUILDINGS CITY OF NORTH AUGUSTA GENERAL FUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YRACTUAL 07/31/2019 BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET 210 GENERAL SUPPLIES/POSTAGE 18,566 28,530 15,000 18,000 0 18,000 0 18,000 217 AUTO OPERATING 0 3,859 0 2,800 0 2,800 0 2,800 220 UTILITY SERVICES 196,039 213,072 260,000 185,163 0185,163 -5,000 180,163 ELECTRICITY /GAS - 183,163 WATER (STATION II) - 2,000 *COVID -19 BUDGET ADJUSTMENT 226 CONTRACTS/REPAIRS 72,250 137,241 80,000 80,000 0 80,000 0 80,000 HEATING /AIR SERVICE CONTRACTS - 10,000 NORMAL EQUIPMENT /BUILDING REPAIRS - 30,000 ELEVATOR SERVICE CONTRACTS - 17,000 FIRE ALARM MONITORING - 810 FIRE SPRINKLER MAINTENANCE CONTRACT - 1,500 FIRE ALARM SYSTEM TESTING /INSPECTION - 2,200 HVAC CONTROLS - 2,000 FALL PROTECTION ANNUAL INSPECTION - 2,600 ELEVATORANNUAL INSPECTION - 675 GENERATOR SERVICE - 3,412 FLAG /POLE MAINTENANCE - 2,000 MISCELLANEOUS - 7,803 265 PROFESSIONAL SERVICES 5,163 11,731 6,700 6,700 0 6,700 0 6,700 PEST CONTROL SERVICE - 6,700 282 INSURANCE 29,640 23,968 15,966 17,390 017,390 0 17,390 SELF FUNDED THROUGH SCMIRFF TOTAL OPERATING EXPENSES 321,659 418,400 377,666 310,053 0 310,053 -5,000 305,053 TOTAL CITY BUILDINGS 321,659418,400 377,666 310,053 0 310,053 -5,000 305,053 6/17/2020 Page 29 FY 2020 CITY OF NORTH AUGUSTA GENERAL FUNDDEPARTMENTAL EXPENDITURES 4065 PROPERTY MAINTENANCE 101 SALARIES/WAGES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YR ACTUAI, 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 580,285943,202606,348 753,040 - 20,907 732,133 0 732,133 TITLE CURRENT REQUESTED RECOMMENDED APPROVED SUPERINTENDENT 1 1 1 1 SUPEREVISOR OF PROP MAINTENANCE 0 1 1 1 IRRIGATION TECH /FOREMAN 1 0 0 0 CHEMICAL TECHNICIAN II 1 1 1 1 HEAVY EQUIPMENT OPERATOR I 1 1 1 1 CREW LEADER 3 4 4 4 GROUNDS WORKER III 2 2 2 2 GROUNDS WORKER II 5 8 7 7 TREE CARE TECHNICIAN 1 1 1 1 TOTAL 15 19 18 18 102 OVERTIME PAY 20,92329,702 17,297 18,680 374 19,054 0 19,054 104 FICA 44,045 71,534 47,709 59,037 -1,571 57,466 0 57,466 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 82,732 146,212 93,921 123,938 -3,297 120,641 -3,756 116,885 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEE INSURANCE 105,168 156,481 106,650 150,100 -7,900 142,200 0 142,200 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 14,161 26,548 16,837 17,864 0 17,864 0 17,864 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES/POSTAGE 1,397 3,387 2,6522,830 0 2,830 0 2,830 OFFICE SUPPLIES /POSTAGE - 2,150 COPIER - 680 214 DUES/TRAINING/TRAVEL 2,261 3,742 1,935 3,020 0 3,020 0 3,020 SAFETY /TECHNICAL TRAINING - 1,820 ARBORIST WORKSHOPS - 900 SC MOSQUITO ASSOCIATION - 300 217 AUTO OPERATING 47,577 47,481 39,927 38,017 -3,521 34,496 0 34,496 FUEL (9,260 GALS UNLEADED @ 2.60) - 24,076:FUEL @ 2.30 21,298 FUEL (2,475 GALS DIESEL @ 3.10) - 7,673:FUEL @ 2.80 6,930 TRUCK REPAIRS /MAINTENANCE - 6,268 220 UTILITY SERVICES 18,823 20,380 17,770 17,060 017,060 0 17,060 ELECTRIC SERVICE - 17,060 (BRICK POND PUMPS /MEDIANS /US 25) 6/17/2020 Page 30 FY 2020 CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES 4065 PROPERTY MAINTENANCE 226 CONTRACTS /REPAIRS PREVIOUS ACTUAL YRACTUAL 07/31/2019 35,909 74,010 CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET 30,900 36,155 0 36,155 EQUIPMENT REPAIRS /MAINTENANCE - 30,405 OPERATIONS FACILITY HVAC REPAIRS - 3,600 (SHARED EXPENSE) TABLET /CELL PHONES /GIS WORKFORCE - 2,150 0 36,155 231 BUILDING MATERIALS 1,449 2,337 TOOLS - 1,975 2,070 1,975 0 1,975 0 1,975 241 UNIFORMS /CLOTHING 7,694 18,419 UNIFORMS - 6,175 SAFETY /PPE - 5,008 7,834 11,183 0 11,183 0 11,183 265 PROFESSIONAL SERVICES 125,275 141,589 TREE REMOVAL - TREE PRUNING - JANITORIAL SERVICE - LANDSCAPE MAINT CONTRACTS - LIVING HISTORY PARK - 129,200 97,822 - 59,00038,822 17,500 10,0003,322 (SHARED EXPENSE) 67,000:NO 8,000 FROM COMMUNITY PROMOTIONS 0 38,822 271 SPECIAL DEPT SUPPLIES 122,768 254,931 130,710 191,560 - 31,075 160,485 CHEMICALS - 63,500 LANDSCAPE SUPPLIES /PLANT MATERIALS - 57,200 SOD /TOP SOIL /MULCH - 23,700 SMALL MOTOR EQUIPMENT - 7,800 IRRIGATION PIPE /VALVES /CONTROLS - 4,410 EQUIPMENT /VEHICLE WASH BAY - 3,875 (SHARED EXPENSE) GREENEWAY TRAIL TREE REPLACEMENT - 15,000:NO LAKE AVE TREE REPLACEMENT PHASE I - 13,575:NO WADE HAMPTON PARK TREE REPALCEMENT - 2,500:NO 0 160,485 282 INSURANCE 23,036 30,928 21,903 SELF FUNDED THROUGH SCMIRFF 20,010 0 20,010 0 20,010 299 LEASE PURCHASE 2016 LEASE 2017 LEASE 2018 LEASE 2019 LEASE 2020 LEASE 64,597 85,495 49,673 2020 2021 5,986 -- 6,945 6,945 12,224 12,224 5,874 5,874 11,506 11,506 31,029 11,506 42,535 20222023 2024 12,2245,874 11,506 5,87411,506 0 42,535 11,506 385 MACHINES /EQUIPMENT 24,797 116,870 65,750 52,300 - 52,300 0 0 VERSA MOWER FLAIL 50/96" CUTTER - 52,300 (REP:4065 -57M & 80M):YES,BUT L/P 0 TOTAL PERSONAL SERVICES 847,314 1,373,679 888,762 1,122,659 - 33,301 1,089,358 -3,756 1,085,602 TOTAL OPERATING EXPENSES 450,786682,699 434,574 450,661 - 82,090 368,571 0368,571 TOTAL CAPITAL OUTLAY 24,797 116,870 65,750 52,300 - 52,300 0 0 0 TOTAL PROPERTY MAINTENANCE 1,322,8982,173,248 1,389,086 1,625,620 - 167,691 1,457,929 - 3,756 1,454,173 6/17/2020 page 3I FY 2020 4100 PUBLIC SAFETY 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YR ACTUAL 07/31/2019 BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET 4,780,805 6,978,439 4,717,637 4,920,569 - 58,271 4,862,298 - 62,298 4,800,000 TITLE CURRENT REQUESTED RECOMMENDED APPROVED DIRECTOR PUBLIC SAFETY 1 1 1 1 CAPTAIN 3 3 3 3 LIEUTENANT 7 7 7 7 SERGEANT 10 10 10 10 ** CORPORAL 6 6 6 6 CRIME ANALYST 1 1 1 1 INVESTIGATOR (PSO) 1 2 1 1 DARE OFFICER 1 1 1 1 RESOURCE OFFICER 2 2 2 2 NARCOTICS OFFICER(PSO) 2 2 2 2 PUBLIC SAFETY OFFICER 30 30 30 30 PUBLIC SAFETY OFFICER (SCDHP GRANT) 1 2 1 1 ANIMAL CONTROL OFFICER 1 1 1 1 SUPERVISOR COURT SERVICES 1 1 1 1 ADMINISTRATIVE SECRETARY 1 1 1 1 COMMUNICATION TECHNICIAN I 7 8 8 8* RECORDS /CLERK OF COURT /CVA 1 1 1 1 CLERK OF COURT 2 2 2 2 SECRETARY CRIMINAL INVDIV 1 1 1 1 SECRETARY COURT 1 1 1 1 MAINTENANCE WORKER II 1 1 1 1 FIRE FIGHTERS 9 9 9 9 RECORDS /COURT CLERK 1 1 1 1 SCHOOL GUARDS (PART -TIME) 1PT 4PT 1PT 1PT TOTAL 91F,1PT 94F,4PT 92F,1PT 92F,1PT NEW COMMUNICATION TECHNICIAN I JULY 1 START DATE. *COVID -19: DELAYED TO 10/2020. PROMOTION OF ONE SERGEANT TO LIEUTENANT EFFECTIVE 7/2020. 102 OVERTIME PAY 175,277 272,814 154,300 169,300 3,386 172,686 0 172,686 NORMAL OVERTIME - 125,000 K -9 OFFICER - 4,400 SPECIAL EVENTS JULY 4TH CELEBRATION - 1,800 JACK -O- LANTERN JUBILEE FESTIVAL - 2,600 RESOURCE OFFICER PROGRAM* - 35,500 REIMBURSED BY SCHOOL SYSTEM /SEE ACCOUNT #10- 3500 -010) 104 FICA 365,092 534,139 372,703 376,424 8,752 385,176 - 17,976367,200 7.65% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 105 EMPLOYEE RETIREMENT 762,508 1,210,596840,318 896,867 22,123 918,990 - 46,632 872,358 FORS - 18.74% OF COVERED SALARIES SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEEINSURANCE 677,548 944,222 703,100 742,600 - 19,750722,850 0 722,850 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 103,559229,562 139,664 139,557 0 139,557 0 139,557 SELF FUNDED THROUGH SCMIT 6/17/2020 Page 32 FY 2020 4100 PUR1.IC SAFETY CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL YR ACTUAL 07/31/2019 CURRENT DEPT ADMINISTRATION BUDGET REQUEST CHANGE AMOUNT 210 GENERAL. SUPPLIES /POSTAGE 19,858 34,624 22,000 22,000 OFFICE SUPPLIES, PRINTING, FLAGS - 22,000 0 22,000 PROPOSED PROPOSED CHANGE BUDGET 0 22,000 214 DUES/TRAINING /TRAVE1. 49,579 71,989 PROFESSIONAL ORGANIZATIONS - SC FIRE ACADEMY - SC CRIMINAL JUSTICE - INVESITGATIONS TRAINING - ACCREDITATION - PIO TRAINING - TRAINING FOR DRONE - TRAINING NOT NEEDED IF EQUI REDUCED TO 50,000 50,000 73,900 - 23,90050,000 2, 960 7,000 2,500 2,500 14,000 4,000 8,500:NO PMENT IS NOT CONTINUING EDUCATION TRAINING /CONFERENCES SRO TRAINING/ CONFERENCE SPECIAL SCHOOLS NOTARY RENEWALS FBI NATIONAL ACADEMY EXTRADITIONAPPROVED 0 50,000 13,5009,300 4,5003,000300840 1,000 217 AUTO OPERATING 264,742322,451 234,270 TIRES /BATTERIES /FLUIDS /PREV MAIN - FUEL (72,700 GALSUNLEADED @ 2.60) - FUEL (2,500 GALS DIESEL @ 3.10) - 234,270 - 22,560 211,710 0 211,710 37,500 189,020:FUEL @ 2.30 167,210 7,750:FUEL @ 2.80 7,000 224 DATA PROCESSING 126,385 196,627 115,000 133,310 0 133,310 0133,310 AIRTIME FOR 800 RADIO SYSTEM - 69,500 EQUIPMENT - 5,850 BROADBAND SERVICE FOR MDT'S - 27,600 RSA TOKEN (SLED REQUIREMENT) - 1,500 AIRTIME CARDS FOR EXIST LAPTOPS - 9,000 E- DISPTACH - 2,160 CODE RED NOTIFICATION SYSTEM - 8,700 CRIME SCENE SKETCHING - 600 FORENSIC CELL PHONE EXTRACTION - 6,400 COMPUTER FOR EXTRACTION SOFTWRE - 2,000 226 CONTRACTS /REPAIRS 264,606 455,896 TRITECH /SOFTWARE MAINTENANCE VEHICLE /RADIO /EQUIP REPAIR OFFICE EQUIPMENT MAIN PUMP AND LADDER TESTS INSPECTION /CLEAN SUPPLIES AIR COMPRESSOR CAR STRIPE (NEW VEHICLES) PAGERS /BATTERIES /LEASES STATION 2 CEILING REPAIR 911 /REPLAY /NCIC DRONE WARRANTY & INSURANCE 265,000 301,990 - 36,990265,000 0 265,000 125,920 OVERHEAD DOORS MAINTENANCE - 3,850 68,600 BUILDING REPAIRS - 15,000 5,570 SCBA BENCH TEST - 1,750 6,000 HOSE TESTING - 5,000 3,000 GROUND SUPPLIES - STATION 2 - 2,500 7,300 TRAFFIC EQUIPMENT MAINT - 3,000 2,400 OBSTACLE COURSE REPAIR - 4,000 7,000 COUNTER SPEAKER (RECORDS) - 2,000 6,000 CELL PHONES ALLOWANCE - 12,160 ** 16,400* CELL PHONE NEW INVESTIGATOR - 540:NO 4,000:NO * ** 100% FUNDED BY AIKEN COUNTY 911 (SEE ACCOUNT #10- 3500 -010) SEE 10 -4100 -101 NOT NEEDED IF EQUIPMENT NOT APPROVED REDUCED TO 265,000 6/17/2020 Page 33 FY 2020 4100 PUBLIC SAFETY 241 UNIFORMS /CLOTHING CITY OF NORTH AUGUSTA GENERALFUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YR ACTUAL 07/31/2019 BUDGET J2EOUEST CHANGE AMOUNT CHANGE BUDGET 83,101 158,894 118,100 182,100 - 61,000 121,100 0 121,100 POLICE CLOTHING /CLEANING /FIRE PROTECTION /CLASS D - 65,000 FIRE GEAR REPLACEMENTSCHEDULE (10 SETS PER YEAR) - 25,000 VESTS REPLACEMENT SCHEDULE (14) - 14,000 UNIFORMS FOR BLOODHOUND TEAM - 1,100 UNIFORMS FOR SCHPS GRANT OFFICER (AMOUNT NOT COVERED BY GRANT) - 15,000:NO CLOTHING ALLOWANCE (CHIEF, INVESTIGATIONS, PROF STANDARDS) - 6,300* CLOTHING ALLOWANCE (ADDITIONAL INVESTIGATOR) - 700:NO SWAT HELMENTS AND VESTS REPLACEMENT (20 SETS) - 55,000 ** SEE 10 -4100 -101 YES,BUT 16,000. REMAINDER OF FUNDING FROM FEDERAL AND STATE DRUG ACCOUNTS 247 CVA EXPENDITURES 13,839 24,172 36,32036,320 OFFICE SUPPLIES, PRINTING, POSTAGE - 6,000 TRAVEL AND DUES OFFICE EQUIPMENT MAINTENANCE CELL PHONE EMERGENCY FUND FOR VICTIMS CUMBEE CENTER CHILD ADVOCACY CENTER 2,500 1,500 1,3205,00010,000 10,000 036,320 0 36,320 248 LEN GRANT 4,342 8,643 10,000 10,000 0 10,000 0 LEN GRANT EXPENDITURES 100% FUNDED BY LAW ENFORCEMENT NETWORK GRANT - SEE ACCOUNT #10- 3300 -070) 10,000 249 COMMUNITY POLICING 28,66029,566 34,400 34,400 0 34,400 FIRE CADET CAMP - 1,200 CITIZENS ACADEMY (2 PER YEAR) - 3,000 SPLASH DOWNS - 2,000 COMMUNITY EVENTS - 2,000 POLICE CADET CAMP - 1,200 CHRISTMAS CLASSIC - 25,000* EXPENSES OFFSET BY REVENUE IN 10- 3500 -010 0 34,400 250 DRUG RELATED ACCT -STATE 21,391 45,559 15,000 15,000 0 MISCELLANEOUS K -9 CARE AND EXPENSES PAGERS FOR DIRECTOR, CAPT ,INVESTIGATORS,RESOURCE,DARE 17,000 OF FUNDS COLLECTED IN PRIOR YEARSTO BE USED 10- 4100 -241 EXPENSES FOR DRUG ENFORCEMENT ARE OFFSET BY REVENUE 15,000 0 11,200 2,500 1,300 FOR SWAT UNIFORMS. SEE IN ACCOUNT #10- 3200 -020) 15,000 255 DRUG RELATED ACCT- FEDERAL 8,118 26,694 5,000 5,000 MISCELLANEOUS - 5,000 22,000 OF FUNDS COLLECTED IN PRIOR YEARS TO 10- 4100 -241 EXPENSES FOR DRUG ENFORCEMENTARE OFFSET BY 0 5,000 0 BE USED FOR SWAT UNIFORMS. SEE REVENUE IN ACCOUNT #10- 3200 -025) 5,000 6/17/2020 Page 34 FY 2020 4100 I'1113I.IC SAFE; fY CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES 265 PROFESSIONAL SERVICES PREVIOUS ACTUAL YR ACTUAL 07/31 /2019 31,363 46,328 CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED JUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 40,000 86,050 - 26,850 59,200 0 59,200 PHYSICALS /STRESS TESTS /EKG - 20,390 AIR MASK FIT TESTS (OSHA) - 2,250 RANDOMDRUG TESTS FOR OFFICERS - 1,000 ANIMAL ADOPTION - 1,300* EMPLOYMENT TESTS /CREDIT REPORTS - 3,060 VETERINARIAN - 12,000* VETERINARY SPAY /NEUTER VOUCHERS - 46,050* TOTAL TO BE ALLOCATED TO ANIMAL SERVICES 32,500 271 SPECIAL DEPT SUPPLIES 98,109 143,196 100,000 117,500 - 17,500 100,000 PRISONER SUPPLIES - 500 METRO DOG TEAM SUPPLIES - 1,900 INVESTIGATION SUPPLIES /EVIDENCE - 6,200 CRIME PREVENTION/ DARE FIREFIGHTING EQUIPMENT FIRE PAGER STOP STICKS PROJECT LIFESAVER ANIMAL CONTROL SUPPLIES REDUCED TO 100,000 5,000 8,400 3,000 2,300 3,000 4,300 0 100,000 MEDICAL SUPPLIES - 5,200 A.E.D'S (2) - 6,500 TASERS - 8,100 DEFENSIVE TACTICS - 5,100 RANGE SUPPLIES - 15,500 PATROL SUPPLIES - 8,400 RADAR & LIDAR FOR TRAFFIC - 6,000 TRAFFIC EQUIPMENT - 8,100 SWAT SUPPLIES - 20,000 282 INSURANCE 80,611 114,716 SELF FUNDED THROUGH SCMIRFF 74,846 76,148 0 76,148 0 76,148 299 LEASE PURCHASE 2016 LEASE 2017 LEASE 2018 LEASE 2019 LEASE 2020 LEASE 465,878999,138 2020123, 669 87, 61776, 586 108,24095,260 533,791 396,112 95,260 491,372 2021 2022 87,617 -- 76,586 76,586 -- 108,240 108,240108,240 95,260 95,260 95,260 0 491,372 2023 2024 95,260 381 BUILDINGS /FIXED EQUIPMENT 0 3,572 0 131,050 - 119,500 11,550 0 11,550 FIRING RANGE UPGRADE - 100,000:NO ELECTRICAL UPGRADE AND FANS @ SHELTER - 5,550 AC /HEATING REPLACEMENT @ SHELTER - 6,000 CID- INTERVIEW ROOM SECURITY & RECORDING SYSTEM REPLACEMENT - 19,500:MOVE TO 385 384 AUTOMOTIVE EQUIPMENT 0 50,247 0 1,596,500 - 1,596,500 VEHICLES (7) REP. 4100- 193,194,215,216,217,218,219 VEHICLE FOR NEW INVESTIGATOR (1) VEHICLE FOR SCDPS GRANT OFFICERS (1)* TRANSPORTATION VAN (1) REP. 4100 -184 SERVICE AND RESCUE TRUCK (REP 4100 -059) BRUSH TRUCK (REP. 4100 -098) NOTE: VEHICLE PRICES INCLUDE ALL EQUIPMENT AMOUNTS FOR SCDPS GRANT PSO VEHICLE WILL BE REIMBURSED 0 0 433,000:YES,BUT L/P 59,000:NO 74,000:NO 61,500:NO 850,000:NO 55,000:NO 0 6/17/2020 Page 35 FY 2020 4100 PUBLICSAFETY 385 MACHINES/EQUIPMENT CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL YB.ACTUAL 07/31/2019 CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED BUDGET REQUEST CHANGE AMOUNT CHANGE WIMEI 0 0 14,625 800 RADIOS (1 PSO, 1 INVESTIGATOR) WEAPON AND LOCKED STORAGE* COMPUTERS AND LICENSES* RADAR AND LIDAR ** - DRONE - TRAFFIC SPEED TRAILER (REP. 4100 -308F) - WALKIE TALKIE SYSTEM UPGRADE - CID INTERVIEW ROOM SEC & SYSTEM REPLACE - 661,625 - 661,625 0 AMOUNT FOR ONE PSONOT COVEREDUNDER BY AMOUNT FOR ONE PSO UNDER SCDPS GRANT TO 10,000:NO 1,000:NO 2,500:NO 5,125:NO 27,000:NO 16,000:NO 600,000:NO 19,500:FROM 381,NO SCDPS GRANT. BE REIMBURSED. 0 0 TOTAL PERSONAL SERVICES TOTAL OPERATING EXPENSES TOTALCAPITAL OUTLAY TOTAL PUBLIC SAFETY 6/17/2020 6,864,789 10,169,771 6,927,722 7,245,317 - 43,760 7,201,557 - 126,906 7,074,651 1,560,582 2,678,492 1,653,727 1,724,100 - 93,540 1,630,560 0 1,630,560 0 53,819 14,625 2,389,175 - 2,377,625 11,550 0 11,550 8,425,371 12,902,082 8,596,074 11,358,592 - 2,514,925 8,843,667 - 126,906 8,716,761 Page 36 CITY OF NORTH AUGUSTA FY 2020 GENERAL FUND DEPARTMENTAL EXPENDITURES 4200 ENGINEERING PREVIOUS ACTUAI, CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YRACTUAI 07/31 /2019 13UDGET J EOUEST CHANGE AMOUNT CHANGE BUDGET 101 SALARIES/WAGES 123,588227,853 160,671 188,250 - 26,894 161,356 0 161,356 TITLE CURRENT REQUESTED RECOMMENDED APPROVED DIRECTOR OF ENG & PUBLIC WORKS 0 .5 0 0 ENGINEER I 1 1 1 1 PLANNING TECHNICIAN 1 1 1 1 ENGINEERING INSPECTOR .5 .5 .5 .5 SECRETARY .5 .5 .5 .5 TOTAL 3 3.5 3 3 104 FICA 9,291 17,207 12,291 14,401 -2,057 12,344 0 12,344 7.65% OF COVERED SALARIES 105 EMPLOYEERETIREMENT 16,84434,030 24,197 30,233 -4,343 25,890 -783 25,107 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEEINSURANCE 18,475 31,557 23,700 27,650 -3,95023,700 0 23,700 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 1,571 5,519 3,636 4,602 0 4,602 0 4,602 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES /POSTAGE 374 OFFICE SUPPLIES /PAPER 636 500 500 0 500 0 500 214 DUES/TRAINING/TRAVEL 1,606 3,332 2,535 2,835 0 2,835 0 2,835 AMERICAN SOCIETY CIVIL ENGINEERS (2) - 520 NATIONAL SOCIETY OF PROFESSIONAL ENGINEERS - 305 TECHNICAL TRAINING - 1,800 APWA - 210 217 AUTO OPERATING 1,675 3,538 2,455 2,455 -240 2,215 0 2,215 FUEL (800 GALS UNLEADED @ 2.60) - 2,080:FUEL @ 2.30 1,840 PREVENTIVE MAINTENANCE - 375 224 DATA PROCESSING 2,500 7,784 3,600 6,300 0 6,300 0 6,300 MISCELLANEOUS SOFTWARE FEES - 3,700 PAVEMENT MANAGEMENT SOFTWARE - 2,600 226 CONTRACTS/REPAIRS 6,865 3,464 2,280 2,480 0 2,480 0 2,480 VEHICLE REPAIRS - 300 WIRELESS SERVICE (1) - 480 COPIER MAINTENANCE - 500 CELL PHONE (2) - 1,200 241 UNIFORMS /CLOTHING 464 1,409 1,000 1,000 0 1,000 0 1,000 SAFETY /PPE - 400 UNIFORMS - 600 6/17/2020 I'agc 37 FY 2020 4200 ENGINEERING 261 ADVERTISING CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACT11AI. 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 0 49 100 100 0 100 0 100 BID ADVERTISEMENT 265 PROFESSIONAL SERVICES 0 360 0 1,000 0 1,000 0 1,000 SURVEYING SERVICES - 1,000 271 SPECIAL DEPT SUPPLIES 1,2122,096 1,500 1,500 0 1,500 0 1,500 DRAFTING /PRINT SUPPLIES - 1,000 SURVEY SUPPLIES - 500 282 INSURANCE 22,819 1,908 1,498 968 0 968 0 968 SELF FUNDED THROUGH SCMIRFF 299 LEASEPURCHASE 2019 LEASE 0 10,510 5,544 5,544 0 5,544 0 5,544 2020 2021 2022 2023 5,544 5,544 5,544 5,544 384 AUTOMOTIVE EQUIPMENT NO REQUEST 0 0 0 0 0 0 0 0 TOTAL PERSONAL SERVICES 169,769 316,166 224,495 265,136 - 37,244 227,892 -783227,109 TOTAL OPERATING EXPENSES 37,514 35,085 21,012 24,682 -240 24,442 0 24,442 TOTALCAPITAL OUTLAY 0 0 0 0 0 0 0 0 TOTAL ENGINEERING 207,283 351,250245,507289,818 - 37,484 252,334 -783 251,551 6/17/2020 Page 38 FY 2020 4210 STREET LIGHT/TRAFFIC CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES 214 DUES/TRAINING/TRAVEL PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YR ACTUAL Q7/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 9402,298 2,450 1,350 0 1,350 0 1,350 INTERNATIONAL MUNICIPAL SIGNAL ASSOCIATION CERTIFICATION - 1,200 INTERNATIONAL MUNICIPAL SIGNAL ASSOCIATION DUES - 150 220 UTILITY SERVICES 446,717 536,990 435,500 432,000 0 432,000 0 432,000 STREET LIGHTS / POLES - 432,000 PARTIALLY OFFSET BY CUSTOM STREET LIGHT FEE, ACCT #10- 3400 -015) 226 CONTRACTS/REPAIRS 18,492 15,326 10,275 3,000 0 3,000 0 3,000 STREETLIGHT REPAIR - 3,000 265 PROFESSIONAL SERVICES 6,101 0 0 185,000 - 185,000 MARTINTOWN RD MAST -ARM TRAFFIC SIGNALS (2 INTERSECTIONS):NO FOUNDATION DESIGN - 10,000 INSTALLATION - 175,000 SEE RELATED REQUEST IN4210 -271) 0 0 0 271 SPECIAL DEPT SUPPLIES 11,650 18,461 16,000 81,000 - 65,000 16,000 0 16,000 STREETLIGHT BULBS /BALLASTS - 4,000 MISCELLANEOUS - 2,000 STREETLIGHT POLES /FIXTURES - 10,000 MARTINTOWN RD TRAFFIC SIGNAL MAST -ARM POLES (2 INTERSECTONS) - 65,000:NO POLES ONLY, SEE RELATED REQUEST IN 4210 -265) 282 INSURANCE 0 33,914 23,72722,468 0 22,468 0 22,468 SELF FUNDED THROUGH SCMIRFF TOTAL OPERATING EXPENSES TOTAL STREET LIGHT/TRAFFIC 483,900606,989 487,952 724,818 - 250,000474,818 0 474,818 483,900 606,989 487,952 724,818 - 250,000 474,818 0474,818 6/17/2020 Page 39 FY 2020 4220 STREETS &r. DRAINS 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERALFUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YRACTUAL 07/31/2019 BUDGET REQUEST CHANGE AMOUNT QHANGF BUDGET 471,108 646,895 460,094 486,714 - 20,521 466,193 0 466,193 TITLE CURRENT REQUESTED RECOMMENDED APPROVED SUPERINTENDENT OF STREETS /DRAINS 1 1 1 1 STREETS AND DRAINS FOREMAN 2 2 2 2 TRAFFIC SIGNAL /STREET LIGHTS TECH 1 0 0 0 VEHICLE OPERATOR III 0 1 1 1 HEAVY EQUIPMENT OPERATOR I 2 2 2 2 TRADES WORKER 3 3 3 3 STREET LABORER 1 2 1 1 TOTAL 10 11 10 10 102 OVERTIME PAY 9,056 7,323 7,500 7,500 150 7,650 0 7,650 104 FICA 35,770 48,519 35,771 36,896 -647 36,249 0 36,249 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 66,036 97,713 70,420 77,458 -1.640 75,818 -2,088 73,730 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEEINSURANCE 75,357 105,189 79,000 86,900 -7.900 79,000 0 79,000 MEDICAL AND DENTAL COVERAGE I09 WORKERS COMPENSATION 14,625 27,498 13,425 13,394 0 13,394 0 13,394 SELF FUNDED THROUGH SCMIT 210 GENERAL. SUPPLiES/POSTAGE 686 823 500 800 0 800 0 800 OFFICE SUPPLIES 214 DVESPI'RAINING/TRAVEL 2,059 4,260 2,500 2,900 0 2,900 0 2,900 SCDHEC MINING PERMIT (1 /2) - 200 TECHNICAL TRAINING - 500 SAFETY TRAINING - 2,200 217 AUTO OPIRAI'1NG 35,377 46,989 36,620 37,620 -3,060 34,560 0 34,560 TIRES /BATTERIES /FLUIDS PREVENTIVE MAINTENANCE FUEL (4,000 GALSUNLEADED @ 2.60) FUEL (6,200 GALS DIESEL @ 3.10) 226 CONTRACTS/REPAIRS 6/17/2020 5,0003,000 10,400:FUEL @ 2.30 9,200 19,220:FUEL @ 2.80 17,360 28,371 25,039 19.160 49,460 - 26,000 23,460 0 23,460 VEHICLE /EQUIPMENT REPAIRS - 15,000 CELL PHONES (4) - 1,860 BUILDING MAINT /REPAIRS - 3,000 OPERATIONS FACILITY RESURFACING (PART) - 26,000:NO OPERATIONS FACILITY HVAC REPAIR (PART) - 3,600 Page 40 FY 2020 4220 STREETS & DRAINS 231 BUILDING MATERIALS CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YRACTUAI 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 62,902 99,725 70,000 70,000 0 70,000 0 70,000 ASPHALT - 20,000 CONCRETE - 19,000 PIPE - 13,000 STONE - 7,000 LUMBER - 2,500 TOOLS - 3,500 MASONRY - 5,000 241 UNIFORMS /CLOTHING 6,106 11,989 5,940 6,950 0 6,950 0 6,950 UNIFORMS - 4,950 SAFETY /PPE - 2,000 265 PROFESSIONAL SERVICES 12,419 33,675 16,270 19,270 019,270 0 19,270 TREE SERVICE - 16,000 CDL DRUG TESTING - 270 TEMP WORKER (1, SHARED) - 3,000 271 SPECIAL DEPT SUPPLIES 17,338 30,771 17,850 16,500 0 16,500 0 16,500 STREET SIGNS /POLES - 2,000 LANDFILL FEES - 2,500 TRAFFIC CONTROL - 2,000 MISCELLANEOUS - 10,000 282 INSURANCE 10,044 17,337 11,685 12,189 0 12,189 0 12,189 SELF FUNDED THROUGH SCMIRFF 299 LEASEPURCHASE 61,572 138,03484,177 58,004 0 58,004 0 58,004 2020 2021 2022 2023 2016 LEASE 19,583 -- -- -- 2017 LEASE 6,125 6,125 -- 2018 LEASE 10,010 10,010 10,010 -- 2019 LEASE 22,286 22,286 22,286 22,286 385 MACHINES/EQUIPMENT NO REQUEST 0 0 0 0 0 0 0 0 TOTAL PERSONAL SERVICES 671,951 933,136 666,210708,862 - 30,558 678,304 -2,088 676,216 TOTAL OPERATING EXPENSES 236,875 408,642264,702 273,693 - 29,060 244,633 0 244,633 TOTAL CAPITAL OUTLAY 0 0 0 0 0 0 0 0 TOTAL STREETS & DRAINS 908,826 1,341,778 930,912 982,555 - 59,618 922,937 -2,088 920,849 6/17/2020 Page 41 FY 2020 4300 RECREATION 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YR ACTUAL, 07/31 /2019 BUDGET REOUEST Cl IAN ,E AQUj lam' CHANGE BUDGET 407,003 478,460 391,805 322,832 4,139 326,971 0 326,971 TITLE CURRENT REQUESTED RECOMMENDED APPROVED DIRECTOR OF PARKS /RECREATION /TOURISM 1 1 1 1 SUPERINTENDENT OF PROGRAMS /FACILITIES 1 1 1 1 PROGRAM COORDINATOR II 1 1 1 1 SECRETARY TO DIRECTOR 1 1 1 1 CENTER COORDINATOR 2PT 2PT 2PT 2PT TOTAL 4F,2PT 4F,2PT 4F,2PT 4F,2PT 102 OVERTIME PAY 10,6726,611 6,0006,000 120 6,120 -5,000 1,120 BASKETBALL EVENTS, SPECIAL EVENTS, MISCELLANEOUS *COVID -19 BUDGET ADJUSTMENT 104 FICA 31,521 36,02230,43225,156 32525,481 -38325,098 7.65% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 105 EMPLOYEE RETIREMENT 45,387 69,818 47,02652,306 1,028 53,334 -2,283 51,051 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEEINSURANCE 30,143 42,075 31,600 31,600 0 31,600 0 31,600 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 6,982 15,781 11,333 11,395 0 11,395 0 11,395 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES/POSTAGE 702 1,447 2,400 2,400 0 2,400 -1,000 1,400 OFFICE SUPPLIES *COVID -19 BUDGET ADJUSTMENT 214 DUI FS11RAINING/1'RAVEL 9,506 14,332 9,940 5,695 0 5,695 -1,000 4,695 AUGUSTA SPORTS COUNCIL - 500 SOUTH CAROLINA RECREATION & PARKS ASSOCIATION - 775 NRPA - 800 TRAINING /TRAVEL - 3,500 OPTIMIST CLUB DUES - 120 *COVID -19 BUDGET ADJUSTMENT 217 AUTO OPERATING 3,241 2,529 2,740 2,740 -270 2,470 -1,000 1,470 TIRES /BATTERIES /FLUIDS - 400 FUEL (900 GALS UNLEADED @ 2.60 /GAL) - 2,340:FUEL @ 2.30 2,070 COVID -19 BUDGET ADJUSTMENT 226 CONTRACT/REPAIRS 6,953 15,333 7,750 8,100 0 8,100 0 8,100 CSRA DOCUMENT SOLUTIONS - 3,000 CELL PHONES (4) - 2,850 EQUIPMENT REPAIRS - 2,250 241 UNIFORMS /CLOTHING 0 587 900900 0 900 0 900 STAFF SHIRTS, PERSONAL PROTECTIVE EQUIPMENT 6/17/2020 Page 42 FY 2020 4300 RECREATION 261 ADVERTISING CITY OF NORTH AUGUSTA GENERALFUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL YRACTUAL 07/31/2019 CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET 860 1,746 1,300 1,300 0 1,300 -1,000 300 BROCHURES - 800 PROGRAM ADS - 500 *COVID -19 BUDGET ADJUSTMENT 265 PROFESSIONAL SERVICES 8,157 207,243 73,000 108,000 26,970 134,970 CLASSES - 1,000 ADVENTURE CAMP (SUPPLIES) - 10,000 INSTRUCTORS - 12,000 SEASONAL LABOR SERVICE - 111,970 MASTER PLAN - 85,000 *:NO PENDING MASC GRANT APPLICATION FOR $25,000:NO 0 134,970 271 SPECIAL DEPT SUPPLIES 5,915 8,190 6,000 6,000 0 6,000 -2,500 SPECIAL EVENTS - 4,000 SENIOR PROGRAMS - 2,000 3,500 PARTIALLY OFFSET BY REVENUE IN ACCOUNTS 10- 3400 -030 *COVID -19 BUDGET ADJUSTMENT 273 BASKETBALL, PROGRAM 37,727 36,221 37,500 45,000 - 19,500 25,500 0 25,500 AWARDS - 2,000 BASKETBALL CAMP INSTRUCTORS - 5,000 EQUIPMENT - 4,000 OFFICIALS - 12,500:SEE 265 UNIFORMS - 12,000 SCOREKEEPERS - 7,000:SEE 265 NYSCA COACH CERT - 1,000 INSURANCE - 1,500 OFFSET BY REVENUE IN ACCOUNT #10- 3400 -031 274 SOFTBALL PROGRAM 17,425 44,782 27,400 31,506 - 13,106 AWARDS - 1,000 EQUIPMENT - 4,000 INSURANCE - 2,000 FIELD PAINT - 1,000 NYSCA COACH CERT - 500 PROGRAM ASSISTANT - 2,106:SEE 265 CAMP - OFFICIALS - ASA/ALL-STAR - UNIFORMS - SCOREKEEPERS - 18,400 1,400 9,000:SEE 265 2,000 6, 500 2,000:SEE 265 OFFSET BY REVENUE IN ACCOUNT #10- 3400 -032 0 18,400 275 FOOTBALL PROGRAM 33,011 37,567 30,000 35,738 -8,738 27,000 AWARDS - 1,000 EQUIPMENT - 8,500 INSURANCE - 2,000 PROGRAM ASSISTANT - 1,200:SEE 265 FIELD PAINT - 4,000 0 27,000 CAMP - 2,000 UNIFORMS - 9,000 OFFICIALS - 5,000:SEE 265 SCOREKEEPERS - 2,538:SEE 265 NYSCA COACH CERT - 500 OFFSET BY REVENUE IN ACCOUNT #10- 3400 -033 276 BASEBALL, PROGRAM 58,424 106,437 50,000 56,106 - 18,106 38,000 AWARDS - 1,000 EQUIPMENT - 9,000 INSURANCE - 2,000 ALL STAR UNIFORMS - 4,000 BASEBALL CAMP - 2,000 0 38,000 PITCHING MACHINES - 1,000 OFFICIALS - 14,000:SEE 265 LEAGUE FEES & STATE MEETINGS - 1,000 TOURNAMENT COST - 1,000 UNIFORMS - 12,000 ATHLETIC FIELD PAINT - 4,000 NYSCA COACH CERTIFICATION - 1,000 PROGRAM ASSISTANT - 2,106:SEE 265 SCOREKEEPERS - 2,000:SEE 265 OFFSET BY REVENUE IN ACCOUNT #10- 3400 -034 6/17/2020 Page 43 FY 2020 4300 RECREATION 277 SOCCER PROGRAM CITY OF NORTI -I AUGUSTA GENERAL FUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL YR ACTUAL 07 /31/2019 48,632 69,182 CURRENT DEPT ADMINISTRATION BUDGET REQUEST CHANGE AMOUNT 55,000 58,000 - 17,000 41,000 PROPOSED PROPOSED CHANGE BUDGET 0 41,000 AWARDS - 2,000 ATHLETIC FIELD PAINT - 6,000 EQUIPMENT - 8,000 INSURANCE - 2,000 UNIFORMS - 22,000 SOCCER CAMP INSTRUCTORS - 2,000:SEE 265 OFFICIALS - 12,000:SEE 265 NYSCA COACH CERTIFICATION - 1,000 PROGRAM ASSISTANT - 3,000:SEE 265 OFFSET BY REVENUE IN ACCOUNT #10- 3400 -029 278 VOLLEYBALL PROGRAM 4,677 4,267 AWARDS - 500 UNIFORMS - 1,500 OFFICIALS - 1,000:SEE 265 SCOREKEEPERS - 520:SEE 265 OFFSET BY REVENUE IN ACCOUNT #10- 3400 -028 4,200 5,220 -1,520 3,700 EQUIPMENT - 1,000 INSURANCE - 500 NYSCA COACH CERT - 200 0 3,700 279 SENIORS PROGRAM 0 0 LEASE - 35,000: NO 0 35,000 - 35,000 0 0 0 280 CONCESSION STAND SUPPLIES 100,820 160,007 91,000 FOOD PRODUCTS /SUPPLIES - 95,000 LABOR COST - 34,000:SEE 265 SALES TAX - 1,000 130,000 - 34,000 96,000 -5,000 ESTIMATED GROSS SALES - 170,000 ESTIMATED EXPENSES - (130,000) ESTIMATED NET 40,000 TOTAL EXPENSES 130,000 OFFSET BY REVENUE IN ACCOUNT #10- 3400 -035 *COVID -19 BUDGET ADJUSTMENT 91,000 282 INSURANCE 20,773 26,628 17,551 SELF FUNDED THROUGH SCMIRFF 19,592 0 19,592 0 19,592 299 LEASE PURCHASE 2019 LEASE 0 16,826 8,800 2020 2021 8,800 8,800 8,800 0 8,800 2022 2023 8,800 8,800 0 8,800 382 FURNITURE /FIXTURES 0 772 1,500 1,500 0 1,500 PICNIC TABLES, BENCHES, WASTE RECEPTACLES, CHAIRS 0 1,500 385 MACI IINES/EQUIPMENT 13,832 32,330 13,000 CLUB CAR 1500 (REP. 4300 -269M) JOHN DEERE 521 LOADER KARCHER SWEEPER YOUTH BASEBALL DUGOUTS (FIELDS 1 & 2) CARRIER HVAC CONTROLS FOR RVP BLEACHERS (5 -8 ROW AT RVP) 202,000 - 188,000 14,000 14,000 15,000:NO 13,000:NO 60,000:NO 50,000:YES,BUT RF /CC FUND 50,000:NO 0 14,000 6/17/2020 Page 44 FY 2020 4300 RECREATION CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL 07/31/2019 BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET TOTAL PERSONAL SERVICES 531,708 648,767 518,196 449,289 5,612454,901 - 7,666 447,235 TOTAL OPERATING EXPENSES 356,822 753,323 425,481 560,097 - 120,270439,827 - 11,500428,327 TOTAL CAPITAL OUTLAY 13,83233,102 14,500 203,500 - 188,000 15,500 0 15,500 TOTAL RECREATION 902,362 1,435,191 958,177 1,212,886 - 302,658 910,228 - 19,166 891,062 6/17/2020 Page 45 FY 2020 4310 PARKS 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YR ACTUAL 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 210,943 272,053 205,577 240,675 - 28,032 212,643 0 212,643 TITLE CURRENT REQUESTED RECOMMENDED APPROVED MAINTENANCE FOREMAN II 1 1 1 1 MAINTENANCE FOREMAN 1 1 1 1 CREW LEADER 1 1 1 1 GROUNDS WORKER III 1 1 1 1 GROUNDSWORKER II 1 2 1 1 TOTAL 5 6 5 5 102 OVERTIME PAY 15,298 13,423 14,000 14,000 280 14,280 - 13,000 1,280 SPECIAL EVENTS, FESTIVALS, ATHLETIC TOURNAMENTS *COVID -19 BUDGET ADJUSTMENT 104 FICA 17,197 21,697 16,798 19,483 -2,123 17,360 0 17,360 7.65% OF COVERED SALARIES 105 EMPLOYEERETIREMENT 30,271 42,753 33,06840,901 -4,537 36,364 -3,078 33,286 SCRS - 16.06% OFCOVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEEINSURANCE 37,678 52,594 39,50039,500 0 39,500 0 39,500 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 4,956 10,069 6,402 6,290 0 6,290 0 6,290 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES/POSTAGE 226 344 1,500 1,500 0 1,500 -750 750 JANITORIAL SUPPLIES - 1,500 *COVID -19 BUDGET ADJUSTMENT 214 DUES/TRAINING/TRAVEL 6492,006 1,450 1,450 0 1,450 -800 650 SCRPA - 500 SEMINAR - 100 PLAYGROUND CERTIFICATION - 600 TRAINING - 250 *COVID -19 BUDGET ADJUSTMENT 217 AUTO OPERATING 12,603 14,267 11,890 11,890 -1,170 10,720 -2,500 8,220 TIRES /BATTERIES /FLUIDS /PREY MAINTENANCE - 1,000 FUEL (2,400 GALS UNLEADED 8 2.60) - 6,240:FUEL AT 2.30 5,520 FUEL (1,500 GALS OFF ROAD DIESEL 8 3.10) - 4,650:FUEL AT 2.80 4,200 COVID -19 BUDGET ADJUSTMENT 220 UTILITY SERVICES 29,823 16,204 20,50020,500 0 20,500 0 20,500 EDENFIELD TENNIS - 3,500 LIONS FIELD - 6,500 CALHOUN PARK - 3,500 BEOCKH PARK - 2,000 SUMMERFIELD PARK - 5,000 6/17/2020 Page 46 FY 2020 4310 PARKS 226 CONTRACTS /RF,PAIRS CITY OF NORTI -I AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL 07/31/2019 BUDGET REOUEST CIIANGE AMOUNT CHANGE BUDGET 51,034 54,184 32,600 32,600 0 32,600 0 32,600 EQUIPMENT REPAIR - 15,000 PARK REPAIRS - 10,000 BULBS /BALLAST /FIXTURES - 2,000(PARKS) SPRAY PAD CHEMICALS - 500 CELL PHONES (2) - 1,100 NAMS & SUMMERFIELD PK - 4,000 231 BUILDING MATERIALS 5,152 8,586 13,500 13,500 0 13,500 -8,000 5,500 MULCH FOR PLAYGROUNDS - 8,000 HAND TOOLS - 500 BUILDING MATERIALS - 5,000 *COVID -19 BUDGET ADJUSTMENT 241 UNIFORMS/CLOTHING 1,534 3,929 2,100 2,500 0 2,500 -1,000 1,500 UNIFORMS - 2,000 SAFETY SHOES - 500 *COVID -19 BUDGET ADJUSTMENT 265 PROFESSIONAL SERVICES 0 11,224 06,000 0 6,000 -6,000 0 SUMMER CONTRACT WORKERS - 6,000 *COVID -19 BUDGET ADJUSTMENT 271 SPECIAL DEPT SUPPLIES 6,912 17,461 I8,500 22,500 - 10,000 12,500 -5,000 7,500 CHRISTMAS DECORATIONS - 8,000:YES,RF /CC CHRISTMAS LIGHTING - 2,000:YES,RF /CC COVID -19 BUDGET ADJUSTMENT SEASONAL BANNERS - 10,000 POWER TOOLS - 2,500 282 INSURANCE 9,053 7,805 5,283 5,496 0 5,496 0 5,496 SELF FUNDED THROUGH SCMIRFF 299 LEASE PURCI IASE 2016 LEASE 12,041 24,081 12,041 12,041 0 12,041 0 12,041 202012,041 381 BUILDINGS /FIXED EQUIPMENT 0 0 0 22,000 - 22,000 0 0 0 RIVERVIEW PARK SECURITY CAMERAS - 22,000:NO 385 MACHINES /EQUIPMENT NO REQUEST 7,837 0 0 0 0 0 0 0 387 PARK IMPROVEMEN"1'S 0 0 30,000 310,000 - 170,000 140,000 - 15,000 125,000 PARK UPGRADES - 310,000 BREAK DOWN OF PARK UPGRADES FOLLOWS: 1. INSTALL NEW PLAYGROUND SURFACE AT RIVERVIEW PARK - 85,000:YES,BUT 15,000 AND BALANCE OF PROJECT TO RF /CC FUND (PARD FUNDS, 15,000) 2. GREENEWAY UPGRADE (PAVE SECTION OF TRAIL) - 125,000 RECREATION TRAILS GRANT APPLICATION FOR $100,00) 3. REPLACE PLAYGROUND EQUIPMENT AT LAKE AVENUE - 100,000:NO OLD EQUIPMENT NEEDS TO BE REPLACED) COVID -19 BUDGET ADJUSTMENT 6/17/2020 Page 47 FY 2020 4310 PARKS TOTAL PERSONAL SERVICES TOTAL OPERATING EXPENSES TOTALCAPITAL OUTLAY TOTAL PARKS 6/17/2020 CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT YRAmlAL 07/31/2019 BUDGET REOUEST 316,344412,589 315,345360,849 129,028 160,092 119,364 129,977 7,837 0 30,000 332,000 453,208572,681 464,709 822,826 - 237,582 585,244 ADMINISTRATION CHANGE AMOUNT 34,412 326,437 11,170 118,807 192,000 140,000 PROPOSEDPROPOSED CHANGE BUDGET 16,078 310,359 24,050 94,757 15,000 125,000 55,128 530,116 Page 48 FY 2020 CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES 4315 PROPERTY MAINTENANCE 271 SPECIAL DEPT SUPPLIES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 482 -482 0 0 0 0 0 0 MOVED TO 9065 TOTAL OPERATING EXPENSES TOTAL PROPERTY MAINTENANCE 482 -482 0 0 0 0 0 0 482 -482 0 0 0 0 0 0 6/17/2020 Page 49 FY 2020 4320 COMMUNITY CENTER 101 SALARIES /WAGES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YRACTUAL 07/31/2019 BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET 80,445 116,937 78,717 78,617 886 79,503 0 79,503 TITLECENTER COORDINATOR TOTAL CURRENT REQUESTED RECOMMENDED APPROVED 2 2 2 2 2 2 2 2 102 OVERTIME PAY 241 454 2,000 2,000 40 2,040 -2,040 COMMUNITY CENTER EVENTS, MUNICIPAL CENTER EVENTS, RVP CENTER EVENTS COVID -19 BUDGET ADJUSTMENT 0 104 FICA 6,152 8,957 6,1756,167 71 6,238 0 6,238 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 11,086 17,589 12,156 12,947 133 13,080 -709 12,371 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEEINSURANCE 15,071 21,038 15,800 15,800 0 15,800 0 15,800 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 1,760 18,019 2,325 2,312 0 2,312 0 2,312 SELF FUNDED THROUGH SCMIT 210 GENERALSUPPLIES /POSTAGE 0 343 2,800 2,800 0 2,800 -1,400 1,400 OFFICE SUPPLIES - 500 PAPER PRODUCTS - 1,000 KITCHEN SUPPLIES - 800 CARPET CLEANER - 500 *COVID -19 BUDGET ADJUSTMENT 217 AUTO OPERATING 222 274 310310 -30 280 0 280 FUEL (100 GALS UNLEADED @ 2.60) - 260:FUEL @2.30 230 OIL /FLUIDS - 50 220 UTILITY SERVICES 4,277 24,906 23,000 23,000 -8,000 15,000 0 15,000 ELECTRICITY /GAS 226 CONTRACTS /REPAIRS 31,540 26,538 16,200 67,200 - 51,000 16,200 -5,000 11,200 EQUIPMENT /BUILDING REPAIRS - 30,000:YES,BUT 15,000 PAINT BUILDING & REPAIR STUCCO - 6,000:NO UPGRADE LIGHTING TO LED - 10,000:NO ROOF REPLACEMENT - 20,000:NO COPIER LEASE - 1,200 *COVID -19 BUDGET ADJUSTMENT 241 UNIFORMS /CLO'I'IIING 602 227 700 700 0 700 -700 0 STAFF SHIRTS - 550 PPE /SAFETY - 150 *COVID -19 BUDGET ADJUSTMENT 261 ADVERTISING 2,858 2,904 3,000 3,000 0 3,000 -3,000 PROMOTIONS - BROCHURES /FLYERS /SLIDES /PICTURES *COVID -19 BUDGET ADJUSTMENT 0 6/17/2020 Page 50 FY 2020 4320 COMMUNITY CENTER CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES 265 PROFESSIONAL SERVICES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSEDPROPOSED YRAC IAL 07/31/2019 BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET 0 0 0 1,000 0 1,000 -1,000 0 TEMP LABOR - 1,000 *COVID -19 BUDGET ADJUSTMENT 271 SPECIAL DEPT SUPPLIES 4,8268,205 10,000 8,500 0 8,500 -4,000 4,500 CATERING /SENIORS - 500 DECORATIONS - 2,500 FLATWARE /CHINA REPLACE - 2,000 MISCELLANEOUS - 1,500 CLEAN LINENS - 2,000 *COVID -19 BUDGET ADJUSTMENT 282 INSURANCE 4,062 4,124 2,896 2,712 0 2,712 0 2,712 SELF FUNDED THROUGH SCMIRFF TOTAL PERSONAL SERVICES 114,755 182,993 117,173 117,843 1,130 118,973 -2,749 116,224 TOTAL OPERATING EXPENSES 48,386 67,520 58,906 109,222 - 59,030 50,192 - 15,100 35,092 TOTAL COMMUNITY CENTER 163,141 250,513 176,079 227,065 - 57,900 169,165 - 17,849 151,316 6/17/2020 Page 51 FY 2020 4325 TOURISM 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAIL 07/31/2019 DUDGET REOUEST CHANGt AMOUNT CHANGE DUDGET 123,183 176,745 126,116 126,116 1,511 127,627 - 22,627 105,000 TITLE CURRENT REQUESTED RECOMMENDED APPROVED FACILITIES & EVENTS SUPERVISOR 1 1 1 1 MAINTENANCE WORKER II 2 2 2 2 TOTAL 3 3 3 3 COVID -19 BUDGET ADJUSTMENT 102 OVERTIME PAY 3,842 5,748 5,000 5,000 100 5,100 -4,000 1,100 COVID -19 BUDGET ADJUSTMENT 104 FICA 9,621 13,871 10,030 10,030 124 10,154 -2,037 8,117 7.65% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 105 EMPLOYEE RETIREMENT 17,412 27,261 19,746 21,057 219 21,276 -4,767 16,509 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEE INSURANCE 23,836 31,557 23,700 23,700 0 23,700 -6,000 17,700 MEDICAL AND DENTAL COVERAGE *COVID -19 BUDGET ADJUSTMENT 109 WORKERS COMPENSATION 2,586 5,247 3,851 3,756 0 3,756 0 3,756 SELF FUNDED THROUGH SCMIT 201 CONTRIBUTIONS 12,150 18,225 12,150 13,000 -850 12,150 0 12,150 CHAMBER OF COMMERCE - 13,000:YES,BUT 2019 LEVEL 12,150 APPROPRIATION DESIGNATED AS TOURISM EXPENDITURE OF STATE A -TAX 210 GENERAL SUPPLIES /POSTAGE 7,349 9,606 8,000 8,000 0 8,000 0 8,000 PAPER PRODUCTS (TOWELS, TISSUE, ETC) - 8,000 217 AUTO OPERATING 0 13 0 700 0 700 0 700 FUEL AND MAINTENANCE FOR TROLLEYS 224 DATA PROCESSING 0 1,784 1,100 1,100 0 1,100 0 1,100 MOTION VR HOST FEE - 500 (ANNUAL FEE) COMCAST - 600 (FEE + MONTHLY RATE) 241 UNIFORMS /CLOTHING 685 160 1,000 1,000 0 1,000 -1,000 0 STAFF SHIRTS /TROUSERS - 850 SAFETY SHOES - 150 *COVID -19 BUDGET ADJUSTMENT 261 ADVERTISING 1,916 47 0 0 0 0 0 0 NO REQUEST 6/17/2020 Page 52 FY 2020 4325 TOURISM CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES 265 PROFESSIONAL SERVICES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL 07/31/2019 BUDGET REQUEST CHANGE AQtia CHANGE BUDGET 30 898 0 3,500 0 3,500 -2,500 1,000 TEMP WORKERS FOR WEEK -END SET -UPS - 2,000 TEMP WORKERS FOR TROLLEY RENTALS - 1,500 *COVID -19 BUDGET ADJUSTMENT 270 TOURISM EVENTS/FESTIVALS /SU 175,567 151,020 155,000 155,000 0 155,000 - 105,000 50,000 FESTIVALS - 150,000* SPECIAL EVENTS - 5,000 SEE 10- 3400 -030 FOR REVENUE *COVID -19 BUDGET ADJUSTMENT 271 SPECIAL DEPT SUPPLIES 20,711 20,542 22,000 67,150 - 42,150 25,000 - 10,000 15,000 MAINTENANCE /CLEANING SUPPLIES - 16,000 CHINA FLATWARE REPLACEMENT (MUNICIPAL CENTER) - 5,000 SEASONAL DECORATIONS (MUNICIPAL CENTER) - 3,000 SKIRTING /CLOTHS /LINENS (MUNICIPAL CENTER) - 5,000 REPLACE 11 TABLE TOPS - 900 INSTALL KITCHEN TILE BACKSPLASH - 2,500 CARPET REPLACEMENT 4TH FLOOR & ELEVATORS - 30,000 FLOOR SCRUBBER - 4,750 REDUCED TO 25,000 *COVID -19 BUDGET ADJUSTMENT 282 INSURANCE 0 14,030 9,637 9,618 0 9,618 0 9,618 SELF FUNDED THROUGH SCMIRFF TOTAL PERSONAL SERVICES 180,481260,429 188,443 189,659 1,954 191,613 - 39,431 152,182 TOTAL OPERATING EXPENSES 218,409216,324208,887 259,068 - 43,000216,068 - 118,500 97,568 TOTALTOURISM 398,890 476,753 397,330 448,727 - 41,046407,681 - 157,931 249,750 6/17/2020 Page 53 FY 2020 4330 RVP ACTIVITIES CTR 101 SALARIES/WAGES CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAI, 07/31/2019 BUDGET REQUEST CHANGE AMOUNT CHANGE BUDGET 341,437 503,025 344,533 473,631 - 117,850 355,781 0 355,781 TITLE CURRENT REQUESTED RECOMMENDED APPROVED PROGRAMS /FACILITIES SUPERVISOR 1 1 1 1 PROGRAM COORDINATOR I 1 1 1 1 PROGRAM COORDINATOR 1 2 1 1 CREW LEADER 1 1 1 1 MAINTENANCE WORKER II 1 1 1 1 CENTER COORDINATOR 2F,2PT 4F,3PT 2F,2PT 2F,2PT TOTAL 7F,2PT 10F, 3PT 7F,2PT 7F,2PT 102 OVERTIME PAY 9,684 10,010 10,000 10,000200 10,200 -9,000 1,200 TOURNAMENTS, SPECIAL PROGRAMS /EVENTS, MAINTENANCE *COVID -19 BUDGET ADJUSTMENT 104 FICA 25,54637,901 27,122 36,998 -9,000 27,998 0 27,998 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 48,35977,482 53,39377,671 - 19,906 57,765 -2,219 55,546 SCRS - 16.06% OF COVERED SALARIES *COVID -19 BUDGET ADJUSTMENT 108 EMPLOYEEINSURANCE 52,750 73,632 55,300 71,100 - 15,800 55,300 0 55,300 MEDICAL AND DENTAL.COVERAGE 109 WORKERS COMPENSATION 6,030 13,887 10,054 10,156 010,156 0 10,156 SELF FUNDED THROUGH SCMIT 210 GENERAL SUPPLIES/POSTAGE 15,411 20,378 15,500 15,500 0 15,500 -5,000 10,500 OFFICE SUPPLIES - 3,000 JANITORIAL SUPPLIES - 10,500 PRINTER - 2,000 *COVID -19 BUDGET ADJUSTMENT 214 DUES/TRAINING/TRAVEL 1,112 1,396 1,400 1,400 0 1,400 -1,400 0 SC RECREATION & PARKS ASSOCIATION MEMBERSHIP - 400 TRAINING /TRAVEL - 1,000 *COVID -19 BUDGET ADJUSTMENT 217 AUTO OPERATING 1,163 496 1,700 1,700 -150 1,550 -1,000 550 FUEL (500 GALS UNLEADED @ 2.60) - 1,300:FUEL @ 2.30 1,150 TIRES /BATTERIES /FLUIDS /PREY MAIN - 400 *COVID -19 BUDGET ADJUSTMENT 220 UTILITY SERVICES 7,408 0 0 0 0 0 0 0 224 DATA PROCESSING 0 0 0 25,000 - 25,000 0 0 0 INSTALL FIBER OPTIC IN ACTIVITIES CENTER - 25,000:NO 6/17/2020 Page 54 FY 2020 4330RVP ACTIVITIES CTR 226 CONTRACTS /REPAIRS CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL YR ACTUAL 07/31/2019 50,740 148,898 ADT ALARMSYSTEM - 800 BULBS /BALLAST - 5,000 ELEVATOR SERVICE - 5,000 HVAC SYSTEM - 15,000 WINDOW WASHING - 2,500 CHILLER SERVICE - 8,000 INTERIOR PAINTING - 2,500 FLOOR FINISH - 10,000 CURRENT DEPT ADMINISTRATION BUDGET REQUEST CHANGE AMOUNT 73,300 73,300 0 73,300 PROPOSEDCHANGE EQUIPMENT /BUILDING REPAIR - 5,000 RECTRAC SOFTWARE LICENSE - 5,500 CHILLER WATER CONTROLSCOPIERMAINTENANCE GENERAL REPAIRS COMCASTSIMPLEX FIRE SYSTEM 1,000 8,000500 2,500500 1,500 PROPOSEDBUDGET 0 73,300 241 UNIFORMS /CLOTHING 124 595 1,400 1,400 UNIFORMS - 400 SAFETY SHOES - 200 0 1,400 900 VOLUNTEER GIFTS - 300 STAFF SHIRTS - 500 *COVID -19 BUDGET ADJUSTMENT 500 261 ADVERTISING 468 741 2,300 2,300 0 2,300 -1,300 RVP ACTIVITY CENTER - 2,300 *COVID -19 BUDGET ADJUSTMENT 1,000 270 TOURNAMENTS /SPECIAL EVENT 163,217 TOURNAMENT EXPENSES AAU SUPER REGIONAL, PEACH INVITATIONAL, NIKE PEACH JAM, 232,758 150,000 1 80,000 0 180,000 - 170,000 FEES, OFFICIALS /SCOREKEEPERS, AWARDS) MARCH 13 -15 - 5,000 MARCH 27 -29 - 25,000 JULY 10 -14 - 150,000 10,000 TOURNAMENT EXPENSES 180,000 TOURNAMENT REVENUE /EXPENSE SUMMARY REVENUES: 299,500 SEE ACCT #10- 3400 -039 EXPENSES: (180,000) SEE THIS ACCOUNT ABOVE OVERTIME: ( 10,000) SEE ACCT #10- 4300,4310,4330- 102,19 -4325 -102 NET TOURNAMENT REVENUE - 109,500 *COVID -19 BUDGET ADJUSTMENT 271 SPECIALDEPT SUPPLIES 33,595 19,869 ATHLETIC SUPPLIES - 3,400 VOLUNTEER AWARDS - 900 MISCELLANEOUS - 900 COVID -19 BUDGET ADJUSTMENT 29,500 29,500 0 29,500 - 15,000 EQUIPMENT SUPPLIES - 5,800 ID RIBBON - 3,500 FITNESS EQUIPMENT - 15,000 14,500 282 INSURANCE 18,942 20,922 SELF FUNDED THROUGH SCMIRFF 14,917 13,354 0 13,354 0 13,354 382 FURNITURE/FIXTURES 0 973 1,500 1,500 0 1,500 FOLDING CHAIRS AND TABLES - 1,500 *COVID -19 BUDGET ADJUSTMENT 500 1,000 I'O'IAL PERSONAL SERVICES TOTAL OPERATING EXPENSES TOTAL CAPITAL OUTLAY TOTAL RVP ACTIVI IES CTR 483,805 277,363 0 761,169 715,937 446,052 973 1,162,962 500,402 290,017 1,500 679,556 - 162,356 343,454 - 25,150 1,500 0 791,919 1,024,510 - 187,506 517,200 318,304 1,500 11,219 194,600 500 505,981 123,704 1,000 837,004 - 206,319630,685 6/17/2020 Page 55 FY 2020 5900 TRANSFERS CITY OF NORTH AUGUSTA GENERAL FUND DEPARTMENTAL EXPENDITURES 010 TO CAPITAL PROJECTS FUND PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAL 07/31/2019 BUDGET REOUEST CHANGE &QUNQ CHANGE BUDGET 750,453 825,129 0 0 0 0 0 0 020 TRANS TO ACCOMMODATIONS T 0 23,725 0 0 0 0 0 0 TOTAL TRANSFERS 750,453 848,854 TOTAL TRANSFERS 750,453 848,854 6/17/2020 0 0 0 0 0 0 0 0 0 0 0 0 Page 56 FY 2020 5900 TRANSFERS TOTAL PERSONAL SERVICES TOTAL OPERATING EXPENSES TOTAL CAPITALOUTLAY TOTALTRANSFERS TOTAL GENERAL FUND 6/17/2020 CITY OF NORTH AUGUSTA GENERAL FUNDDEPARTMENTAL EXPENDITURES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION PROPOSED PROPOSED YRACTUAI, 07/31/2019 BUDGET REOUEST CHANGE AMOUNT CHANGE BUDGET 11,863,280 17,997,995 12,573,792 13,704,204 - 533,17113,171,033 - 478,676 12,692,357 5,322,407 8,532,376 5,998,601 7,277,264 - 1,537,979 5,739,285 - 311,759 5,427,526 46,466 283,774 211,975 3,201,975 - 2,997,425204,55050,300 254,850 750,453 848,854 0 0 0 0 0 0 17,982,606 27,662,999 18,784,368 24,183,443 - 5,068,575 19,114,868 - 740,135 18,374,733 Page 57 Riverfront/ Central Core Redevelopment Fund FY 2020 CITY OF NORTH AUGUSTA RIVERFRONT /CC REDEV FUND SUMMARY OF REVENUES ACCOUNT NUMBER/DESCRIPTION PROPOSED ACTUAL BUDGET ACTUAL ADOPTED ADJUSTMENT 2018 2M 07/31/2019 2020 2020 TAXES 19 -3000 -050 LOCALACCOMMODATIONS TAX 109,092 274,504 278,265 339,478339,478 19 -3000 -055 LOCAL HOSPITALITY TAX 1,609,103 1,575,000 2,485,443 1,775,000 1,775,000 TOTAL TAXES 1,718,195 1,849,504 2,763,708 2,114,478 2,114,478 MISCELLANEOUS REVENUE 19- 3500 -050 INTEREST ON INVESTMENTS 11,684 0 21,961 0 0 TOTAL MISCELLANEOUS REVENUE 11,684 0 21,961 0 0 TOTALRIVERFRONT/CC REDEV FUND 1,729,879 1,849,504 2,785,669 2,114,478 2,114,478 06/17/2020 Page 95 FY 2020 ACCOUNT CITY OF NORTH AUGUSTA RIVERFRONT /CC REDEVFUND SUMMARY OF REVENUES - TEXT LOCAL ACCOMMODATIONS TAX 19 -3000 -050 3% TAX ON GROSS PROCEEDS DERIVED FROM RENTAL OR CHARGES FOR ACCOMMODATIONS FURNISHED TO TRANSIENTS EXPECTED ADOPTED PROPOSED ADJUSTMENT REVENUE CHANGE AMOUNT CHANGE AMOUNT 339,478 0 339,478 0 339,478 RIVERSIDE VILLAGE AT HAMMONDS FERRY — 189,478 OTHER AREAS — 150,000 LOCAL HOSPITALITY TAX 1,775,000 0 1,775,000 0 1,775,000 19 -3000 -055 2% TAX ON SALE OF PREPAREDMEALS AND BEVERAGES INTEREST ON INVESTMENTS 0 0 0 0 0 19 -3500 -050 06/17/2020 Page 96 FY 2020 4325 TOURISM CITY OF NORTH AUGUSTA RIVERFRONT /CC REDEV FUNDDEPARTMENTAL EXPENDITURES 101 SALARIES/WAGES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION BUDGET PROPOSED YRACPIbIJ. 07/31/2019 BUDGET REOUEST CHANGE AMOUNT ADJUSTMENT BUDGET 39,981 65,108 43,917 45,913 459 46,372 0 46,372 CURRENT REQUESTED RECOMMENDED APPROVED 1 1 1 1 1 1 1 • 1 TITLETOURISM & MARKETINGCOORDINATOR TOTAL 104 FICA 3,078 4,923 3,360 3,512 35 3,547 0 3,547 7.65% OF COVERED SALARIES 105 EMPLOYEE RETIREMENT 5,537 9,687 6,614 7,374 73 7,447 0 7,447 SCRS - 16.06% OF COVERED SALARIES 108 EMPLOYEE INSURANCE 6,307 10,519 7,900 7,900 0 7,900 0 7,900 MEDICAL AND DENTAL COVERAGE 109 WORKERS COMPENSATION 0 1,689 1,208 1,258 0 1,258 0 1,258 SELF FUNDED THROUGH SCMIT 201 CONTRIBUTIONS 0 0 100,000 100,000 0 100,000 - 100,000 0 RIVERSIDE VILLAGE OPPORTUNITY *COVID -19 BUDGET ADJUSTMENT 217 AUTO OPERATING 0 543 0 0 19,150 19,150 - 16,150 3,000 TROLLEY FUEL AND MAINTENANCE *COVID -19 BUDGET ADJUSTMENT 220 UTILITY SERVICES 203,077220,513 216,000 216,000 0 216,000 0 216,000 RVP LIGHTS - 35,500 RVP ACTIVITIES CENTER - 168,000 SECURITY LIGHTS - 2,500 SOCCER COMPLEX - 8,500 GREENEWAY LIGHTING - 1,500 226 CONTRACTS/REPAIRS 98,784 158,366 102,500 236,900 - 134,400 102,500 0 102,500 RVP BUILDING REPAIR /NETS - 15,000 RVP SPORTS TURF PROGRAM - 50,000 NA COUNTRY CLUB CONTRACT - 134,400:N0 32 WEEKS X 4200) RVP BULBS,BALLASTS,FIXTURES - 17,500 GREENEWAY TREE REMOVAL - 20,000 231 BUILDING MATERIALS 10,583 10,773 19,000 19,000 0 19,000 0 19,000 BRICK POND TRAIL BRICK - 2,000 RVP SAND & CEMENT - 10,000 BRICK POND BOARDWALK LUMBER - 2,000 RVP FIELD PREP MATERIAL - 5,000 261 ADVERTISING 1,795 11,026 8,000 8,000 0 8,000 0 8,000 ADVERTISEMENTS /BROCHURES /PHOTOS 265 PROFESSIONAL SERVICES 0 317 0 0 19,000 19,000 - 16,000 3,000 TEMP WORKERS FOR TROLLEYS *COVID -19 BUDGET ADJUSTMENT 6/16/2020 Page 97 FY 2020 4325 TOURISM CITY OF NORTH AUGUSTA RIVERFRONT /CC REDEV FUND DEPARTMENTAL EXPENDITURES 271 SPECIAL DEPT SUPPLIES PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION BUDGET PROPOSED YRACTUAL 07/31/2019 BUDGET REQUEST CHANGE AMOUNT ADJUSTMENT BUDGET 0 0 0 0 10,000 I0,000 - 10,000 0 CHRISTMAS DECORATIONS AND LIGHTING *COVID -19 BUDGET ADJUSTMENT 382 FURNITURE /FIXTURES 9,294 13,763 10,000 10,000 010,000 0 10,000 LED LIGHTING FIXTURES FOR RVP ACTIVITIES CENTER - 10,000 384 AUTOMOTIVE EQUIPMENT 100,000 0 0 46,145 - 46,145 0 0 0 TROLLEY MAINTENANCE: 15,000 FUEL (2240 GALS UNLEADED @ 2.60) 5,284:FUEL @ 2.30 5,152 FUEL (1680 GALS DIESEL @ 3.05) 5,124:FUEL @ 2.80 4,704 TROLLEYDRIVERS: 20,737 56 EVENTS @ 7 HRS /EVENT X 26.45/HR X 2 DRIVERS PER EVENT) SEE ACCOUNT 217 385 MACHINES /EQUIPMENT 61,651221,931 77,000 75,000 - 25,000 50,000 0 50,000 NEW LOCKERS IN ACTIVITIES CENTER NEW FLOORING IN LOCKER ROOMS CARRIER HVAC CONTROLS FOR RVP 50,000:NO 25,000:NO 50,000 387 PARK IMPROVEMENTS 28,580256,348 385,000 285,000 70,000 355,000 - 320,000 35,000 PICNIC SHELTER & RESTROOMS GREENEWAY PAVING UPGRADE PLAYGROUND SURFACE AT RVP COVID -19 BUDGET ADJUSTMENT 250,000 35,000 70,000 (15,000 OF PROJECT IN GENERAL FUND) TOTAL PERSONAL SERVICES 54,903 91,926 62,999 65,957 567 66,524 0 66,524 TOTAL OPERATING EXPENSES 314,239 401,539 445,500 579,900 - 86,250 493,650 - 142,150 351,500 TOTAL CAPITAL OUTLAY 199,524 492,041 472,000 416,145 -1,145 415,000 - 320,000 95,000 TOTALTOURISM 568,666 985,506 980,499 1,062,002 - 86,828975,174 - 462,150 513,024 6/16/2020 Page 98 CI "TY OF NORTH AUGUSTA FY 2020 RIVERFRONT /CC REDEV FUNDDEPARTMENTAL EXPENDITURES 5900 TRANSFERS PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION BUDGET PROPOSED YR ACTIJAI. 07/31/2019 J3UDGET REOUEST CHANGE AMOUNT ADJUSTMENT J3UDGET 010 TRANSFER TO GENERAL FUND 40,075 80,150 40,075 40,075 0 40,075 0 40,075 TRANSFER TO GENERAL FUND DESIGNATED TO OFFSET LOSS OF ARTS & HERITAGE CENTER RENT 020 TRANSFER TO NAPFC FUND 693,600936,463 946,125 1,025,532 0 1,025,532 0 1,025,532 TRANSFER FOR 2017B DEBT SERVICE PAYMENTS ACCOMMODATIONS TAX REVENUE - 189,478 HOSPITALITY TAX REVENUE - 836,054 TOTAL TRANSFERS TOTAL TRANSFERS 6/16/2020 733,675 733,675 1,016,613 986,200 1,065,607 1,016,613 986,200 1,065,607 0 1,065,607 0 1,065,607 0 1,065,607 0 1,065,607 Page 99 CITY OF NORTH AUGUSTA FY 2020 RIVERFRONT /CC REDEV FUND DEPARTMENTAL EXPENDITURES 5900 TRANSFERS PREVIOUS ACTUAL CURRENT DEPT ADMINISTRATION BUDGET PROPOSED YR ACTUAL 07/31/2019 LUDGET REOUEST CHANGE AMOUNTADJUSTMENT BUDGET TOTAL PERSONAL SERVICES 54,903 91,926 62,999 65,957 567 66,524 0 66,524 TOTAL OPERATING EXPENSES 314,239 401,539 445,500 579,900 - 86,250 493,650 - 142,150 351,500 TOTAL CAPITAL OUTLAY 199,524 492,041 472,000 416,145 -1,145 415,000 - 320,000 95,000 TOTAL TRANSFERS 733,675 1,016,613 986,200 1,065,607 0 1,065,607 0 1,065,607 TOTAL RIVERFRONT /CC REDEV FUN 1,302,341 2,002,119 1,966,699 2,127,609 - 86,828 2,040,781 - 462,150 1,578,631 6/16/2020 Page 100