The URL can be used to link to this page

Home My WebLink About73-81 RESOLUTIONRESOLUTION NO. 73-f/ A RESOLUTION APPROVING THE 1981-1982 WATER AND SEWER FUND BUDGET. BE IT RESOLVED BY THE BOARD OF DIRECTORS OF THE CITY OF FAYETTEVILLE, ARKANSAS: That the Board of Directbrs hereby approves the 1981-1982 Water and Sewer Fund Budget attached hereto marked Exhibit "A" and made a part hereof. PASSED AND APPROVED this Y. day of /20 , 1981. As_ �'AT-TE ST*: CITY -CLERK '9" APPROVED: MAYOR k41/ CERTIFICATE OF. RECORD State of Arkansas City of Fayetteville ( ss I, Vivian Koettel, City Clerk and Ex -Officio recorder for the City of Fayetteville, do hero - by certify that the annexed or foregoing is of record in my office and the same ap, pears in Ordinance & Resolution book at page 3S Witness my hand • id seal ti�i 11, ofd.y of City Clericand Ex��twi Recor er eZR.OF:ifil,ED WATER AND SEWER FUND ANNUAL BUDGET CITY OF FAYETTEVILLE, ARKANSAS 1981-82 BOARD OF DIRECTORS John Todd Paul R. Noland Ron Bumpass Ann Henry Ernest Lancaster Richard P. Osborne Frank Sharp Donald L. Grimes City Manager Scott C. Linebaugh Finance Director Mayor Assistant Mayor Director Director Director Director Director • II INDEX TO WATER AND SEWER BUDGET 1981-82 PAGE NUMBERS 1 Fund Equity -Schedule A 2 Revenue and Expenses Summary -Schedule B 3 Contributions in Aid of Construction - Schedule C 4 Revenue Detail 5-6 Notes OPERATING EXPENSE DETAIL 7-8 Water Supply and Treatment 9-13 Transmission and Distribution 14-18 Sewer Maintenance and Collection 19-22 Pollution Control Plant 23-29 Customer Accounting and Collection 30-33 Administration and Engineering 34-35 Recreation CAPITAL BUDGET 36-37 Capital Detail 38-42 Capital Notes 43-46 Schedule of Fixed Assets and Depreciation ADDITIONAL SCHEDULES 47 Surplus Revenue Fund 48-51 Explanation of 1980-81 Budgeted to actual SCHEDULE Ai A n CITY OF FAYETTEVILLE, ARKANSAS WATER AND SEWER FUND FUND EQUITY FOR THE YEARS ENDED JULY 31, 1982; 1981; AND 1980 BALANCE - JULY 31, 1980 Net Income (Schedule B) Contributions in aid of Construction (Schedule C) Net Transfers BALANCE - JULY 31, 1981 Net Income (Schedule B) Contributions in aid of Construction (Schedule C) Net Transfers BALANCE - JULY 31, 1982 RETAINED RESERVES £ONTRTRUTTONS EARNINGS TOTAL $1,846,322 $1,846,322 (289,000) $1,557,322 i $11,494,432 $5,517,548 $18,858,302 441,727 289,603 289,603 441,727 511,936,159 $5,807,151 $19,589,632 1,516,000 $13,452,159 155,383 289,000 155,383 1,516,000 $6,251,534 $21,261,015 SCHEDULE B CITY OF FAYETTEVILLE, ARKANSAS WATER AND SEWER FUND REVENUES AND EXPENSES SUMMARY; FOR THE YEARS ENDED JULY 31, 1982; 1981; OPERATING REVENUES Water Sales Sewer Service Charges Fire Protection Charges Miscellaneous Total Operating Revenues OPERATING EXPENSES Water Supply & Treatment Water Transmission & Distribution Sewage Collection & Maintenance Pollution Control Customer Accounting & Collection Administrative & Engineering Total Operating Expenses NET OPERATING INCOME (LOSS) BEFORE DEPRECIATION LESS: DEPRECIATION EXPENSES NET OPERATING INCOME (LOSS) NON-OPERATING INCOME Rental Income Recreation Income Interest Income Gain on Sales of Capital Other Total Non -Operating Income TOTAL INCOME NON-OPERATING EXPENSES Recreation Expense Bond Interest & Paying Agents Other Total Non -Operating Expenses NET INCOME TO RETAINED EARNINGS (SCHEDULE A) ACTUAL 1979-80 $2,085,264 1,424,577 30,918 27,034 3,567,793 624,690 152,912 187,249 553,863 279,809 282,369 2,080,892 1,486,901 ( 765,565) 721,336 1,003 14,422 252,820 6,470 12 274,727 996,063 25,105 Fees 501,827 33,254 560,186 *Not taken into consideration for cash flow $266,000; 1980-81 of $280,00 and 1981-82 of **Miscellaneous -EIS and Facility Grants -$300, of inventory $500, and other $20,000 AND 1980 ESTIMATED 1980-81 $2,579,061 1,637,522 29,414 116,900 4,362,897 796,400 220,860 217,524 673,650 344,573 767,570 3,020,577 BUDGETED 1981-82 $2,200,000 1,830,000 31,220 359,945** 4,421,165 830,250 252,180 291,780 762,450 454,388 519,115 3,110,163 1,342,320 1,311,002 ( 767,566) ( 807,717) 574,754 503,285 818 17,308 248,150 8,519 -0- 274,795 849,549 26,696 500,000 33,250 559,946 2,208 16,500 200,000 18,000 -0- 236,708 739,993 61,360 490,000 33,250 584,610 $ 435,877* $ 289,603* $ 155,383* is bond principal payments made in 1979-80 of $289,000. 000, work for other departments -$39,445, Sale 11 SCHEDULE C CITY OF FAYETTEVILLE, ARKANSAS WATER AND SEWER FUND CONTRIBUTIONS IN AID OF CONSTRUCTION FOR THE YEARS ENDED JULY 31, 1982; 1981; AND 1980 CONTRIBUTIONS IN AID OF CONSTRUCTION EPA Studies Grants - Utility Relocation Grants - State Health Department Water Connection Fees Sewer Connection Fees Rural Water Taps Contractors Contributions Main Extension Fees Other Net to Contributions (Schedule A) CONSTRUCTION EXPENDITURES (CAPITAL) Water Supply & Treatment Transmission & Distribution Sewage Collections & Maintenance Pollution Control Customer Accounting & Collection Adminstration & Engineering Recreation DEPRECIATION ESTIMATED 1980-81 $ —0- 240,000 -0- 46,000 30,000 7,100 4,500 44,000 59,367 430,967 $ 104,000 643,480 303,800 37,000, 40,330 9,210 3,300 $1,141,120 BUDGETED 1981-82 $1,056,500 200,000 66,000' 70,000 60,000 15,000 4,500 44,000 - 0- $1,516,000 $ 69,000 855,995 1,810,510 50,000 38,375 - 0- - 0- $2,823,880_ $ 767,566 $' 807,71.7. NOTE: Under Cash Accounting (old budget system) the Contributions in Aid of Construction were the Capital Revenues and the Construction Expenditures were the Capital Expenses. Under Accrual Accounting, the Capital Expenses are replaced by Depreciation. z SCHEDULE D :fj CITY OF FAYETTEVILLE, ARKANSAS WATER & SEWER - REVENUE DETAIL - OPERATING, NON-OPERATING AND CONTRIBUTUIONS IN AID OF CONSTRUCTION (CAPITAL) FOR THE YEARS ENDING JULY 31, 1982; 1981; and 1980 OPERATING REVENUES Water Sales on computer Water Sales not on computer Rural Water Sales Beaver Water Reimbursements Total Water Sales Sewer Charges on Computer Sewer Charges not on Computer Total Sewer Charges Fire Hydrant Charges Miscellaneous Income Total TOTAL OPERATING REVENUES NON OPERATING REVENUES Rental Income Recreation Fees ACTUAL ESTIMATED 1979-80 7-31-81 $2,085,264 1,424,577 30,918 27,034 57,952 $3,567,793 Lake Fayetteville Lake Sequoyah Interest Sale of Fixed Assets Other Total Non -Operating Revenues Total Revenue for Retained Earnings CONTRIBUTIONS IN AID OF CONSTRUCTION Required EPA Grant Reimbursements Water Connection Fees Rural Water Taps Sewer Connection Fees Construction Contributions Grant Utility Relocation Aid from Federal Government Main Extension Fees Other Total Contributions in Aid of Construction GRAND TOTAL 4 1,003 14,422 252,820 6,470 12 274,727 $3,842,520 $1,234,325 $5,076,845 $2,244,925 9,400 223,600 101,136 $2,579,061 1,588,372 49,150 1,637,522 29,414 116,900 146,314 $4,362,897 818 10,389 6,919 248,150 8,519 274,795 $4,637,692 $ -0- 46,000 7,100 30,000 4,500 240,000 -0- 44,000 59,367 $ 430,967 $5,068,659 PROJECTED 1981-82 REVENUES $2,200,000 1,830,000 31,220 359,945 391,165 $4,421,165 2,208 10,000 6,500 200,000 18,000 236,708 $4,657,873 1,056,500 70,000 15,000 60,000 4,500 200,000 66,000 44,000 -0- $1,516,000 $6,173,873 11 CITY OF FAYETTEVILLE, ARKANSAS WATER AND SEWER FUND FOR THE YEARS ENDING JULY 31, 1982; 1981; and 1980 1. Basis of Accounting:- As reflected in our budget, starting August 1, 1981, the Water and Sewer Fund has been changed to an Accrual Accounting Basis. This will bring our audit, financial statements, and budget together on the same basis for the first time. It also completes our two year reorganization bringing our records in complete compliance with APWA and GAAFR Budgetary Accounting. Of Special Note - Our net income using accrual accounting is higher (lower) than on the cash basis by ($57,413) in 1980-81 and $500,163 in 1981-82. 2. Reserve Funds - Revenue Refunding Bond Fund and Contingency Reserve Fund were allowed in the past to accumulate $604,901 and $398 respectively more than needed. We have pulled, with approval of our auditor, those funds and reinvested them in other reserve funds. The following are the details of the transfers: Revenue Refunding Bond Fund Investments Revenue Refunding Bond Reserve Fund Investments Contingency Reserve Fund Repair and Replacement Surplus Revenue Fund This action was completed in FYE July 31, 1981. 3. Cost Allocation - In FYE July 31, 1982, we have revised our method of cost allocation after an in-depth evaluation. The Water and Sewer Funds cost allocation is shown only in Customer Accounting and Collection and Administration Divisions. For FYE July 31, 1981 and 1980, Customer Accounting and Collection showed $61,000 and $58,000 respectively for Finance Department work. Administration showed $35,030 and $36,000 respectively for the City Attorney, City Manager, Purchasing Officer, and Personnel Officer. These figures were carried forward from prior years with a percentage added each year. Starting in FYE July 31, 1982, the cost allocation is calculated on 21.22% of the Water and Sewer Fund's budgeted salaries. 4. Cash Flow - We are estimating in FYE July 31, 1982 that we will need to make transfers from the surplus revenue fund to the operating fund for proper cash flow. This will again mean a lowering of our reserves. The cause of this is the large amount of money invested into fixed assets without a corresponding amount of revenue. Shown on Schedule C as the difference between Contributions in Aid of Construction and the Construction Expendi- tures is the deficiency. Lower Raise Lower Raise Raise $(604,091) 25,518 ( 398) 50,000 528,971 1 CITY OF FAYETTEVILLE, ARKANSAS WATER AND SEWER FUND CONTINUED FOR THE YEARS ENDING JULY 31, 1982; 1981; and 1980 5. Fixed Assets - A detail schedule of fixed assets and depreciation per division is provided. Depreciation is calculated using the straight line method over the useful life of the related asset. Depreciation rates are summarized as follows: ASSET Building and Structures Pumping and Purification Equipment Water Meters Fire Hydrants Water and Sewer Connections Water and Sewer Mains Laboratory Equipment Beaver Water Line Furniture and Fixtures Maintenance Equipment Vehicles 6 ESTIMATED USEFUL LIFE 20-50 years 20-40 years 25 years 32 years 40-50 years 40-50 years 5-20 years 50 years 5-10 years 5-10 years 4- 5 years : 'I WATER AND SEWER FUND WATER SUPPLY AND TREATMENT 02-4-55 ACTUAL ESTIMATED BUDGETED 1979-80 1980-81 1981-82 OPERATIONS Labor & Expenses 50-001 Salaries & Wages $ -0- $ -0- $ -0- 50-010 Minor Equipment 292 200 250 50-051 Professional Services (NWARPC) 5,000 5,000 -0- 50-063 Telephone 8 -0- -0- 50-064 Utilities 1,457 400 -0- 50-100 Miscellaneous -0- -0- -0- Total Labor &Expenses . 6,757 5,600 250 51-000 Purchased Water 617,933 790,800 830,000 TOTAL OPERATIONS 624,690 796,400 .830,250 MAINTENANCE -0- -0- -0- TOTAL WATER SUPPLY & TREATMENT BEFORE DEPRECIATION (SCHEDULE B) 624,690 DEPRECIATION Depreciation Expense 49,781 TOTAL WATER SUPPLY & TREATMENT $674,471 796,400 830,250 44,338 51,703 $840,738 $881,953 ii WATER SUPPLY AND TREATMENT Explanation of Accounts 1 51-000 Purchased Water: 2. 80-000 Floridation: 3. 50-051. Professional 4. 50-064 Utilities: 5. CAPITAL SCHEDULE: CAPITAL 80-000 Floridation TOTAL CAPITAL Includes $58,000 additional for a possible Beaver Water rate increase This is the estimated cost of completing the floridation project in 81-82. Services: (NWARPC) Moved to 66-50-051 Professional Services $5,000 Moved to 57-50-064 SEE CAPITAL BUDGET FOR DETAILS WATER AND SEWER FUND WATER SUPPLY AND TREATMENT 02-4-55 P. ACTUAL ESTIMATED BUDGETED 1979-80 1980-81 1981-82 $ -0- $104,000 $ 69,000 $ -0- $104,000 $ 69,000 OPERATIONS Labor and Expenses 50-001 50-009 50-010 50-011 50-025 50-063 50-064 50-080 50-082 WATER AND SEWER FUND TRANSMISSION AND DISTRIBUTION 02-4-57 Salaries & Wages Office Supplies Minor Equipment Cleaning Supplies Construction Materials Telephone Utilities Buildings & Grounds Radio Maintenance 50-100 Miscellaneous Total Labor & Expenses Work for Other Departments 61-001 Labor 61-025 Materials 61-083 Vehicles & Equipment 61-100 Other Expenses Total Work for Other Departments TOTAL OPERATIONS MAINTENANCE Water Mains 70-001 Salaries & Wages 70-025 Materials 70-083 Vehicles 70-100 Other Expenses Total Water Mains Fire Hydrants & Valves 71-001 Salaries & Wages 71-025 Materials 71-083 Vehicles and Equipment 71-100 Other Expenses Total Fire Hydrants & Valves ACTUAL 1979-80 $ 26,044 18 2,461 - 0- 1,186 2,525 19,613 4,346 341 4,328 60,862 997 -0- (2.11) - 0- 786 $ 61,648 $ 71,265 5,471 (5,349) 305 71,692 8,963 1,157 (321) - 0- 9,799 ESTIMATED 1980-81 $ -0- 20 1,350 30 750 1,450 26,750 3,000 375 475 34,200 2,600 780 450 - 0- 3,830 $ 38,030 BUDGETED 1981-82 $ -0- 50 2,650 30 -0- 1,600 32,500 3,000 500 500 40,830 3,000 800 500 -0- 4,300 $ 45,130 $ 98,420 $112,000 29,000 30,000 25,500 25,500 480 500 153,400 168,000 6,000 13,000 4,000 5,000 920 1,400 - 0- -0- 10,920 19,400 Meters 72-001 72-025 72-083 72-100 WATER AND SEWER FUND TRANSMISSION AND DISTRIBUTION CONTINUED 02-4-57 Salaries & Wages Materials Vehicles & Equipment Other Expenses Total Meters Growth Area Mains 73-001 Salaries & Wages 73-025 Materials 73-083 Vehicles & Equipment 73-100 Other Expenses Total Growth Area Mains Tools & Equipment 74-001 Salaries & Wages 74-025 Materials 74-083. Vehicles & Equipment 74-100 Other Expenses Total Tools & Equipment Tanks 77-001 Salaries & 77-025 Materials 77-054 Contracts 77-083 Vehicles & Total Tanks TOTAL 11AINTENANCE Wages Equipment TOTAL TRANSMISSION AND DISTRIBUTION BEFORE DEPRECIATION (SCHEDULE B) Depreciation 85-000 Depreciation Expense TOTAL TRANSMISSION AND DISTRIBUTION 1 !1 ACTUAL 1979-80 $ 3,963 974 484 - 0- 5,421 997 - 0- (211) - 0- 786 1,994 - 0- (211) - 0- 1,783 1,994 - 0- - 0- (211) 1,783 $ 91,264 $152,912 350,126 $503,038 ESTIMATED BUDGETED 1980-81 1981-82 $ 2,700 1,250 690 - 0- 4,640 1.950 500 650 - 0- 3,100 5,520 - 0- 750 10 6,280 2,680 140 1,260 410 4,490 $ 3,000 1,500 700 - 0- 5,200 2,500 550 700 - 0- 3,750 4,000 - 0- 300 -0- 4,300 4,500 200 1,300 400 6,400 $182,830 $207,050 $220,860 $252,180 319,495 335,621 $540,355 $587,801 PERSONNEL SCHEDULE Number of Employees Amount 1979-80 1980-81 1981-82 1980-81 1981-82 Superintendent Ass't Superintendent Const. Maint. Foreman Utility Serv. Leadpersons Distribution Persons Laborers Lt. Equip. Operators Fringe Benefits Overtime Contingency TOTAL 1 1 4 2 3 2 3 16 1 1 4 1 1 4 3 15 1 1 4 1 1 4 3 15 $ 19,310 15,850 45,590 9,420 9,350 32,880 34,090 $ 166,490 28,000 16,000 14,570 $ 225,060 Note: The number of personnel has been kept at 15 for the past year and plans are to stay at this level. 11 1. 50-0.01 (Salaries & Wages) 2. 50-010 (minor equipment) 3. 50-064 (Utilities) Transmission & Distribution Explanation of Accounts This account includes: a) straight salaries b) overtime (estimated from 80-81) c) fringe benefits d) + 8.75% contingency. Estimated from 80-81, then these special items added: a) safety cones (250) b) Two (2) electric pumps ($ 500 ea) Estimated from 80-81, then added 20% to account for rate increases by Swepco (30%) and Ozarks Elec. (8%) 4 Water Main Maintenance - 70-001 - 70-100 The 1980-81 year was especially expensive for maintenance. 5 Fire Hydrants & Valves - 71=001 - 71-100 All items are increased considerably to reflect extra effort in repair and maintenance of hydrants and a valve location and repair program. 6. Tanks - 77-054 This contract item is for maintenance and inspection of water tanks for corrosion control and cathodic protection. 12 CAPITAL SCHEDULE - SEE CAPITAL BUDGET FOR DETAILS WATER AND SEWER FUND TRANSMISSION AND DISTRIBUTION 02-4-57 CAPITAL Water Service Connections 89-001 Salaries & Wages 89-025 Materials 89-083 Vehicles & Equipment 89-100 Other Expenses Total Water Service Connections Growth Area Connections 90-001 Salaries & Wages 90-025 Materials 90-083 Vehicles & Equipment 90-100 Other Expenses Total Growth Area Connections Water Mains 91-001 Salaries & Wages 91-025 Materials 91-059 Contracts 91-083 Vehicles & Expenses 91-1.00 Other Expenses Construction Contribution Total Water Mains 92-000 Vehicles & Equipment 93-000 Easements Street Repair 94-001 Salaries & Wages 94-025 Materials 94-083 Vehicles & Equipment 94-100 Other Expenses Total Street Repair TOTAL CAPITAL ACTUAL 1979-80 $ 35,153 26,435 2,657 - 0- 64,245 2,991 - 0- (843) - 0- 2,148 54,501 9,083 847,640 5,921 - 0- (187,146) 729,999 49,834 74,454 10,962 13,661 442 - 0- 25,065 $945,745 ESTIMATED BUDGETED 1980-81 1981-82 $ 31,000 37,500 11,000 - 0- 79,500 6,350 4,800 2,400 - 0- 13,550 20,000 6,350 425,000 8,500 1,080 - 0- 460,930 60,500 (3,000) 8,500 20,500 3,000 -0- 32,000 $ 35,000 43,000 11,000 - 0- 89,000 7,500 5,300 2,400 - 0- 15,200 27,000 23,695 600,000 8,000 - 0- -0- 648,695 4,100 60,000 11,000 25,000 3,000 - 0- 39,000 $643,480 $850,995 • OPERATIONS Labor & Expenses 50-001 50-009 50-010 50-011 50-048 50-063 50-064 50-080 50-082 50-100 Total WATER AND SEWER FUND SEWER MAINTENANCE AND COLLECTION 02-4-62 Salaries & Wages Office Supplies Minor Equipment Cleaning Supplies Travel & Training Telephone Utilities Buildings & Grounds Radio Maintenance Miscellaneous Labor and Expenses Work for Other Departments 61-001 Salaries & Wages 61-025 Materials 61-083 Vehicles & Equipment 61-100 Other Expenses Total Work for Other Departments TOTAL OPERATIONS MAINTENANCE Sewer Mains 75-001 Salaries & Wages 75-012 Chemicals 75-025 Materials 75-067 Self Insurance 75-083 Vehicles & Equipment 75-100 Other Expenses Total Sewer Mains Pumping Equipment 76-001 Salaries & Wages 76-025 Materials 76-083 Vehicles & Equipment 76-100 Other Expenses Total Pumping Equipment 111 ACTUAL 1979-80 $ 7,945 41 2,664 16 492 988 44,869 314 400 627 58,356 1 ,135 -0- (227) - 0- 908 $ 59,264 65,422 2,148 2,864 -0- 13,204 1,432 85,070 35,922 5,245 1,370 - 0- 42,537 ESTIMATED BUDGETED 1980-81 1981-82 -0- 20 900 50 980 1,500 47,000 2,000 674 500 53,624 4,180 1,520 2,070 - 0- 7,770 $ -0- 50 1,700 50 700 1,650 56,500 500 700 550 62,400 6,500 1,680 2,070 - 0- 10,250 $ 61,394 $ 72,650 63,000 8,400 5,900 -0- 35,200 - 0- 112,500 31,700 7,700 3,000 -0- 42,400 105,500 5,000 7,000 2,800 39,750 - 0- 160,050 45,000 8,600 2,980 - 0- 56,580 WATER AND SEWER FUND SEWER MAINTENANCE AND COLLECTION CONTINUED 02-4-62 ACTUAL ESTIMATED BUDGETED 1979-80 1980-81 1981-82 Tools & Equipment 74-001 Salaries & Wages -0- -0- 500 74-025 Materials -0- -0- 50 74-083 Vehicles & Equipment -0- -0- 100 74-100 Other Equipment -0- -0- -0- Total Tools & Equipment -0- -0- 650 Farmington & Greenland Services 80-001 Salaries and Wages 378 960 1,500 80-025 Materials -0- 90 150 80-083 Vehicles & Equipment -0- 180 200 Total Farmington & Greenland Services 378 1,230 1,850 TOTAL MAINTENANCE $127,985 TOTAL SEWER MAINTENANCE AND COLLECTION BEFORE DEPRECIATION (SCHEDULE B) $187,249 Depreciation 85-000 Depreciation Expense 260,807 TOTAL SEWER MAINTENANCE AND COLLECTION $448,056 15 $156,130 $219,130 $217,524 $291,780 270,369 273,494 $487,893 $565,274 Supervisor Maint. Mechanic Const. & Maint. Foremen Lt. Equip. Operators Mechanic I Distribution Persons Utility Serv. Leadpersons Laborer Fringe Benefits Overtime Contingency TOTAL PERSONNEL SCHEDULE Number of Employees AMOUNT 1979-80 1980-81 1981-82 1980-81 1981-82 1 1 3 3 1 1 2 2 14 1 1 2 2 0 1 3 4 14 1 1 2 2 0 1 3 4 14 $ 18,220 20,110 27,640 22,570 -0- 8,220 34,270 32,950 $ 163,980 28,200 10,000 14,320 $ 216,500 Note: We have held the number of personnel to a total of 14. We plan to continue to hold to this level. 16 • • • SEWER MAINTENANCE AND COLLECTION 1. 50-001 Salaries & Wages Explanation of Accounts This account includes: a) straight salaries b) overtime (estimated from this year) c) fringe benefits d) 8.75% contingency for raises Reflects the same personnel contingent as 1980-81. 2. 50-048 Travel and Training Includes trip to AWWPC Conference in Hot Springs - $700 3. .50-064 Utilities Estimated from this years expected expenditure + 30% SWEPCO rate increase. 4. SEWER MAINS MAINTENANCE 75-001 Salaries & Wages 75-012 Chemicals a) Split estimated from this years experience. More added to reflect added emphasis on maintenance in 1981-82. b) Includes root control chemicals, degreasers, and oxygen. We are estimating this less because last year we fed oxygen longer than usual to determine if it helped significantly at the P.C.P. It did not, therefore, oxygen will be used only for odor control this year. 17 5. C'A.PITAE.;SCHEDULE - SEE CAPITAL BUDGET FOR DETAILS WATER AND SEWER FUND SEWER MAINTENANCE AND COLLECTION 02-4-62 ACTUAL ESTIMATED BUDGETED 1979-80 1980-81 1981-82 CAPITAL New Sewer Mains 95-001 Salaries & Wages $ 91,433 $ 41,500 $ 20,000 95-025 Materials 19,562 11,200 13,250 95-054 Contracts 841,151 140,000 1,664,000 95-083 Vehicles & Equipment 28,510 15,600 7,000 95-100 Other Expenses -0- -0- -0- Construction Contributions (Non Cash) 308,941 -0- -0- Total New Sewer Mains 671,715 208,300 1,704,250 Sewer Connections 96-001 Salaries & Wages 34,119 35,800 40,060 96-025 Materials 16,805 20,500 24,200 96-054 Contracts -0- -0- -0- 96-083 Vehicles & Equipment 6,964 12,100 12,000 Ii Total Sewer Connections 5/,888 68,400 76,260 • 92-000 Vehicles & Equipment 43,485 7,100 15,000 Street Repair • 94-001 Salaries & Wages 11,655 -0- -0- 94-025 Materials 1,793 -0- -0- 94-083 Vehicles & Equipment 4,483 -0- -0- 94-100 Other Expenses -0- -0- -0- Total Street Repair 17,931 -0 -0- 93-000 Easements 49,468 20,000 15,000 TOTAL CAPITAL $840,487 $303,800 $1,810,510 s II WATER AND SEWER FUND POLLUTION CONTROL PLANT 02-4-63 ACTUAL ESTIMATED BUDGETED 1979-80 1980-81 1981-82 OPERATIONS • Labor & Expenses 50-001 Salaries & Wages $151,224 $183,900 $228,470 50-009 Office Supplies 330 600 600 50-010 Minor Equipment 3,045 2,500 3,700 50-011 Cleaning Equipment 4,514 6,000 7,000 50-048 Travel & Training 1,836 1,200 1,800 50-051 Professional Services 5,628 15,000 9,500 50-063 Telephone 2,518 2,530 2,800 50-064 Utilities 177,161 210,000 230,000 50-080 Buildings & Grounds 5,400 5,000 5,500 50-082 Radio Maintenance •- 233 100 200 50-100 Miscellaneous Expenses 8,679 9,000 1,000 Total Labor and Expenses - 360,568 435,830 490,570 52-000 Chemicals 141,236 180,000 198,000 53-000 Vehicles Ij 8,647 6,600 8,000 51-000 Purchased Water -0- -0- -0- TOTAL OPERATIONS $510,451 $622,430 $696,570 MAINTENANCE Plant Equipment 78-001 Salaries & Wages 24,618 26,520 35,880 78-083 Pumping Equipment 18,794 24,700 30,000 TOTAL MAINTENANCE $ 43,412 $ 51,220 $ 65,880 TOTAL POLLUTION CONTROL BEFORE DEPRECIATION (SCHEDULE B) $553,863 $673,650 $762,450 Depreciation 85-000 Depreciation Expense 51,195 95,855 106,850 TOTAL POLLUTION CONTROL PLANT $605,058 $769,505 $869,300 H 19 rv� PERSONNEL SCHEDULE Number of Employees AMOUNT 1979-80 1980-81 1981-82 *TepOS Superintendent 1 1 1 $ 20,860 Process Controller 0 1 1 12,300 Maint. Mechanics 2 2 2 28,940 Shift Operators 5 5 5 56,210 Coilfilter Operator 1 1 1 10,140 Ass't Coilfilter Op. 1 1 1 8,580 Sewer Plant Operator 3 3 3 24,840 Lt. Equip. Operator 1 1 1 13,020 Lab Technician 1 1 1 16,600 Ass't Lab Technician 1 1 1 13,460 Summer Workers .2 2 2 4,140 18 19 19 $ 209,09O Overtime 7,500 Contingency 18,360 Fringe Benefits 29,400 TOTAL $ 264,350 a POLLUTION CONTROL PLANT Account Exolanations J 1. 50-001 •Salaries& Wages Includes: a) Present Salaries b) Estimated Overtime c) Fringe Benefits d) 8.75% Contingency for Raises 2. 50-010 Minor Equipment Includes the following special purchases: a) ph Meter $ 400 b) Drum Handler for moving polymer drums 325 c) Weedeater 200 d) Do probe and Associtated Equip- ment 665 e) Desk 300 f) Lawn mower, push type 250 2,140 Balance of account is "normal",:iminor equipment purchases. 3. 50-048 Travel & Training 4. 50-051 Professional Services 5. 50-064 Utilities 6. 52-000 Chemicals Includes: a) AWWPC Conference in Hot Springs$.600 b) Possible training schools 800 c) Unexpected trips in relation to EPA project 400 $1,800 Includes: a) Escomlab services in running split samples, quality control, special sampling projects, ect. $1,500 b) Eng on sludge disposal project 2,000 c) Misc. consultant fees 6,000 9,500 Figured fromwhat hat we estimated for this year plus 8% increase for Ozark Electric and 20% increase for Arkansas Western Gas. Estimate based on this years use of chemicals and projected increases in chemical costs. This includes: a) Lime b) Ferric Chloride c) Chlorine c) Oxygen e) Laboratory Chemicals f) Polymers 21 POLLUTION CONTROL PLANT Account Explanations Continued 7. 78-083 Pumping Equipment Includes "normal" maintenance of $17,000 plus the replacement of 5 motors at lift station No. 1, at a cost of $13,000. 8. CAPITAL SCHEDULE - SEE CAPITAL BUDGET FOR DETAILS WATER AND SEWER FUND POLLUTION CONTROL PLANT 02-4-63 ACTUAL ESTIMATED BUDGETED 1979-80 1980-81 1981-82 CAPITAL 97-000 Plant Improvements $ -0- $ -0- $ -0- 92-000 Vehicles & Equipment 1,516 37,000 50,000 TOTAL CAPITAL $ 1,516 $37,000 $50,000 I 22 WATER AND SEWER FUND CUSTOMER ACCOUNTING AND COLLECTIONS 02-4-65 ACTUAL ESTIMATED BUDGETED 1979-80 1980-81 1981-82 OPERATIONS Meter Reading Labor & Expenses 56-001 Salaries & Wages $ 29,126 $ 37,297 $ 55,807 56-002 Cost Allocation 16,384 19,703 30,278 56-009 Office Supplies 73 150 180 56-010 Minor Equipment 455 120 955 56-048 Travel & Training 33 100 100 56-080 Building & Grounds Maintenance 16 50 75 56-082 Radio Maintenance 358 500 600 56-083 Vehicle & Equipment Maintenance 3,592 3,300 4,000 Total Meter Reading Labor & Expenses 50,037 61,220 91,995 Customer Accounting & Collection Expenses 57-001 Salaries & Wages 40,543 51,044 57,458 57-002 Cost Allocation 29,765 26,956 82,357 57-009 Office Supplies 1,308 2,900 3,200 57-010 Minor Equipment 454 550 1,550 57-044 Publications & Dues 125 150 150 57-048 Travel & Training 134 400 400 57-049 Postage 19,595 23,000 28,000 57-051 Professional Services 60,696 87,500 84,000 57-063 Telephone 3,721 3,000 4,200 57-070 Collection Expense 1,879 2,100 4,000 57-080 Building & Grounds Maintenance 17 67 75 57-081 Office Machine Maintenance 32 100 200 57-083 Vehicle & Equipment Maintenance 5,131 6,150 7,200 57-100 Miscellaneous Expense 873 400 800 Total Customer Accounting & Collection Expenses 164,273 204,317 273,590 Audit Expense 58-000 Independent Audit Expense 15,000 16,900 20,000 Total Audit Expense 15,000 16,900 20,000 Inventory 59-001 Salaries & Wages 12,698 15,400 18,960 59-009 Office Supplies -0- -0- 500 Total Inventory 12,698 15,400 19,460 TOTAL OPERATIONS $242,008 $297,837 $405,045 23 WATER AND SEWER FUND CUSTOMER ACCOUNTING AND COLLECTING CONTINUED 02-4-65 ACTUAL ESTIMATED BUDGETED 1979-80 1980-81 1981-82 • MAINTENANCE Maintenance of Meters 72-001 Salaries & Wages $ 21,069 $ 27,159 $ 34,290 • 72-002 Cost Allocation 11,851 14,341 8,478 72-009 Office Supplies 73 150 150 72-010 Minor Equipment 454 120 150 72-025 Materials 2,764 3,700 4,500 • 72-048 Travel & Training 33 100 100 72-080 Building & Grounds Maintenance 16 66 75 72-083 Vehicles & Equipment Maintenance 1,539 1,100 1,600 Total..Maintenance of Meters 37,799 46,736 49,343 tl TOTAL MAINTENANCE $ 37,799 $ 46,736 $ 49,343 TOTAL CUSTOMER ACCOUNTING & COLLECTION BEFORE DEPRECIATION (SCHEDULE B) $279,807 $344,573 $454,388 Depreciation Depreciation Expense 15,343 33,466 35,485 TOTAL CUSTOMER ACCOUNTING & COLLECTION $295,150 $378,039 $489,873 .24 - -di PERSONNEL SCHEDULE I. Water Meter Service Foreman Water Meter Maintenance Foreman Meter Repair Person Meter Readers Utility Service Representative Warehouse Manager Clerk III Finance Department Overtime TOTAL Fringe Benefits Contingency GRAND TOTAL f NUMBER OF EMPLOYEES AMOUNT 1980-81 1981-82 1980-81 1981-82 1 1 $ 17,429 0 1 12,659 2 1 9,590 3 3 29,354 2 2 26,931 1 1 14,448 1 1 8,900 121,113 8,500 10 10 $248,924 20,808 17,896 $287,628 25 s a CUSTOMER ACCOUNTING AND COLLECTION Explanation of Accounts 02-4-65 NOTES: 57-009 Office Supplies 1978-79 actual are low because of larger than normal inventory of supplies on hand at beginning of year. Also more departments are using existing inventory of supplies 56-010 Minor Equipment 57-010 Minor Equipment Caution Light Mounting Bars $ 450 Two Way Radio Replacement 775 Calculator 250 Map Rack 175 Tool Box 125 Miscellaneous Tools 730 TOTAL $2,505 57-051. Professional Services Unexpected and continued problems with the computer increased the conversion cost of the utility billing package and delayed implementation of other packages. Therefore, water and sewer had to pay more than the anticipated cost. 57-049 Postage This account has increased drastically over the last few years because of the postage rate increases. Also budgeted for 1981-82 is a contingency in case the rates go up from 18¢ to 20�. 56-002, 57-002, 72-002 Cost Allocation Customer Accounting and Collection and Engineering and Administration - includes the entire cost allocation for the Water and Sewer Department. 26 t CAPITAL SCHEDULE - SEE CAPITAL BUDGET FOR DETAILS !: 3 .WATER AND SEWER FUND CUSTOMER ACCOUNTING AND COLLECTION 02-4-65 ACTIIAI FCTTMATFD RllnrFTFn CAPITAL Water Meters 98-000 Water Meters Total Water Meters Vehicles -and Equipment 92-000 Vehicles & Equipment Total Vehicles and Equipment TOTAL CAPITAL 27 $ 17,300 $ 12,500 $ 23,375 17,300 12,500 23.375 400 27,830 15,000 400 27,830 15,000 $ 17,700 $ 40,330 $ 38,375 CUSTOMER ACCOUNTING AND COLLECTIONS - 02-4-65 NARRATIVE OBJECTIVE: Customer Accounting and Collections is under the supervision of the Finance Department. This section consists of three divisions; Meter Reading, Business Office and Ware- house. The Meter Reading Division consists of a Meter Service Foreman, Customer Service Representatives, Pieter Repair Personnel, and Meter Readers. This division is responsible for assigning number to new water, sewer, and sanitation accounts, turn -on orders, turn-off orders, delinquent accounts, meter test orders, re -reads, meter changeouts, meter maintenance, meter testing, meter box and lid maintenance, installing and maintaining remote reading systems, meter reading, and customer service related problems. At the end of fiscal year 1980-81 there will be approximately 13,750 active and inactive water and sewer accounts. This 13,750 active and inactive water and sewer accounts will include approximately 725 active and inactive growth area water accounts. At the end of fiscal year 1980-81, the Meter Reading Division will work approximately 4,450 turn -on orders, 3,900 turn-off orders, 250 test orders, 6,000 re -reads, 400 meter changeouts, 3,600 miscellaneous jobs, 2,250 delinquent accounts, 275 meter repairs, 300 meter tests, and 161,200 meter reads. At the end of fiscal year 1981-82 there will be approximately 14,200 active and inactive water and sewer accounts. This 14,200 water and sewer accounts will include approximately 800 active and inactive growth area water accounts. At the end of fiscal year 1981-82, the Mater R-ading Division will work approxi- mately 4,600 turn -on orders, 4,100 turn-off orders, 200 test orders, 6,000 re -reads, 550 meter changeouts, 3,800 miscellaneous jobs, 2,400 delinquent accounts 350 meter repairs, 500 meter test and 167,000 meter reads. The Business Office Division consist of Business Office Manager, Clerk V, Clerk III, Cashiers, and PBX Operator/Receptionist. This division is responsible for receiving water, sewer, and sanitation payments from customers; receiving and processing turn -on, turn-off, and transfer orders; answering customer questions about water, sani- tation bills; processing of final bills and deposit refund checks; dispatching turn -on, turn-off, and reconnect orders to the meter division; updating delinquent account list; making corrections in water, sewer, and sanitation bills; balancing and auditing daily cash receipts; preparing file maintenance and meter reading books for data processing; preparing end -of -month reports and summaries; and operating switchboard. At the end of fiscal year 1980-81, the Business Office Division will receive and process approximately 161,000 water, sewer, and sanitation payments from customers; 8,300 turn -on, turn -of, and transfer orders; 4,100 correct account orders; 450 meter test and re -check reading orders; 500 meter service orders; 15,500 miscellaneous receipts; and 750 return checks. At the end of fiscal year 1981-82, the Business Office Division will receive and process 166,500 water, sewer, and sanitation pay- ments; 8,800 turn -on, turn-off, and transfer orders; 4,200 correct account orders; 600 meter test and re -check reading orders; 600 meter service orders; 16,500 miscellaneous receipts; and 800 return checks. 2R 4 CUSTOMER ACCOUNTING AND COLLECTIONS - 02-4-65 NARRATIVE CONTINUED OBJECTIVE: The Warehouse Division consists of a warehouse manager. This division orders, inventories, issures, and receives material used in the operation of the Water and Sewer Department. 29 WATER AND SEWER FUND ADMINISTRATION AND ENGINEERING 02-4-66 ACTUAL ESTIMATED BUDGETED 1979-80 1980-81 1981-82 OPERATIONS Labor and Expenses 50-001 Salaries and Wages $ 94,380 $119,770 $133,140 50-002 Cost Allocation 36,000 35,030 71,130 50-009 Office Supplies 2,975 4,040 4,200 50-010 Minor Equipment 804 125 1,550 50-040 Advertising 290 270 350 50-041 Clothing Allowance 2,368 3,170 6,600 50-044 Publications & Dues -0- 1,000 1,000 50-048 Travel & Training 1,735 3,200 3,870 50-051 Professional Service 8,433 550,000 235,000 50-063 Telephone 3,313 3,250 3,575 50-064 Utilities -0- -0- -0- 50-081 Office Machines Maintenance 107 200 200 50-082 Radio Maintenance 121 130 150 50-083 Vehicles 11,172 5,600 6,000 • 50-100 Miscellaneous 8,892 370 400 Total Labor & Expenses 170,590 726,155 467,165 Employee Benefits 54-068 Pensions 12,313 7,965 8,850 54-072 Social Security 43,841 6,900 10,900 Total Employee Benefits 56,154 14,865 19,750 Insurance 55-065 Vehicle and Other 12,934 7,000 10,000 55-066 Health 31,691 5,290 5,500 55-067 Self Insurance -0- 160 2,200 55-071 Unemployment Insurance -0- 3,100 3,500 • Total Insurance 44,625 15,550 21,200 60-075 Rent 11,000 11,000 11,000 TOTAL OPERATIONS AND TOTAL ADMINISTRATION BEFORE DEPRECIATION (SCHEDULE B) $282,369 $767,570 $519,115 Depreciation Depreciation Expense 570 2,569 3,089 TOTAL ADMINISTRATION & ENGINEERING $282,939 $770,139 $522,204 a I 50-001 City Engineer /W&S Superintendent Ass't City Engineer Engr. Aide Utility Serv. Inspector Head Draftsman Draftsperson I Clerk V Land Agent Sub -total Contingency TOTAL Cost allocation TOTAL PERSONNEL SCHEDULE Number of Employees 1979-80 1980-81 1981-82 AMOUNT 1981-82 1 1 1 $ 28,980 1 1 1 21,070 0 1 1 11,730 1 1 1 12,050 1 1 1 14,770 2 1 1 10,570 1 1 1 11,870 2 2 2 11,400 9 9 9 122,440 10,700 $ 133,140* 71,130 $ 204,270 *Note: Administration and engineering is the only division where work is not charged to maintenance and capital. Therefore, the fringe benefits are not included in personnel schedule. Z1 Yz j i �L qi ADMINISTRATION AND ENGINEERING Explanation of Accounts 1. 50-001 Salaries & Wages Includes same personnel contingent as 1980-81. 50-002 Cost Allocation Includes a pro -rata share of cost allocation which is 21.22% of budgeted salaries. 2. 50-010 Minor Equipment Includes $850 for a pressure testing machine and $300 for a chair. 3. 50-041 Clothing Allowance For the past several years we have not enforced the uniform policy -of the Water and Sewer Department. The increase in this account reflects an effort to enforce the policy strictly on the personnel who come in contact with the public out on the job and who work in the field. Essentially, this includes all personnel in T & D. SM&C, and the Pollution Control Plant. A change was made in Customer Accounting and Collection Uniform Policy to allow for rental of uniforms. 4. 50-044 Publications & Dues Includes dues to AWWA, WPCF, Water and Sewer Licenses and miscellaneous trade journal subscriptions. Budgeted based on last years expenditure. 5. 50-048 Travel & Training Includes: a) AWWPC Conference in Hot Springs b) Six (6) Little Rock trips. c) Trips by other city officials on W/S related business. c) National AWWA Conference. 6. 50-051 Professional Services Northwest Arkansas Planning Commission $ 5,000 Facility Plan (EPA Reimbursable) 125,000 EIS (Epa Reimbursable) 50,000 Water Rate Study 15,000 Sewer Rate Study 40,000 $235,000 32 7. C15PITAL SCHEDULE - SEE CAPITAL BUDGET FOR DETAILS WATER AND SEWER FUND ADMINISTRATION AND ENGINEERING 02-4-66 ACTUAL 1979-80 ESTIMATED BUDGETED 1980-81 1981-82 CAPITAL 92-000 Vehicles & Equipment $ -0- $ 9,210 $ -0- TOTAL CAPITAL $ -0- $ 9,210 $ -0- 23 J 10 WATER AND SEWER FUND RECREATION 02-4-67 • ACTUAL ESTIMATED BUDGETED • 1979-80 1980-81 1981-82 OPERATIONS • Labor & Expenses 50-001 Salaries & Wages $ 18,709 $ 21,100 $ 25,500 50-009 Office Supplies 446 456 100 50-051 Professional Services -0- -0- 30,000 50-060 Telephone 209 380 410 50-064 Utilities 2,252 2,230 2,800 50-080 Buildings & Grounds 3,197 2,500 2,500 50-100 Miscellaneous 292 30 50 TOTAL OPERATIONS $ 25,105 $ 26,696 $ 61,360 TOTAL RECREATION BEFORE DEPRECIATION • (SCHEDULE B) 25,105 26,696 61,360 Depreciation Depreciation Expense 4,936 1,474 1,474 TOTAL RECREATION • $ 30,041 •$ 28,170 t62,834 RECREATION Explanation of Accounts 50-051 Phase II study of dam as recommended by the Corps of Engineers. 34 Ji i RECREATION POSITION Dock Operator Overtime Fringe Benefits Contingency TOTAL II Personnel Schedule NO. OF EMPLOYEES 1979-80 1980-81 1981-82 2 2 2 AMOUNT $ 21,740 -0- 1,860 1,900 � 2c_cnn 35 S. I. u, WATER AND • CAPITAL 1981 SEWER FUND BUDGET 1982 NOTE: CAPITAL EXPENDITURES ARE ADDED TO FIXED ASSETS AND A DEPRECIATION CHARGE IS GIVEN TO OPERATIONS. WATER AND SEWER CAPITAL BUDGET 1981-82 Actual Estimated Budgeted 1979-80 1980-81 1981-82 Capital Water Supply & Treatment 8b-000 Fluoridation $ -0- $104,000 $ 69,000 Total Capital -Water & Supply & Treat. $. -0- $104,000 $ 69,000 Capital Transmission & Distribution Water Service Connections 89-001 Salaries & Wages 89-025 Materials $ 35,153 26,435 $ 31,000 37,500 $ 35,000 43,000 89-083 Vehicles & Equipment 2,657 11,000 11,000 89-100 Other Expenses -0- -0- -0- Total Water Service Connections 64,245 79,50U 89,000 Growth Area Connections 90-001 Salaries & Wages 2,991 6,350 7,500 90-025 Materials -0- 4,800 5,300 90-083 Vehicles & Equipment (843) 2,400 2,400 90-100 Other Expenses -0- -0- -0- Total Growth Area Connections 2,148 13,550 15,200 Water Mains 9090-001 Salaries & Wages 54,501 20,000 27,000 91-025 Materials 9,083 6,350 23,695 91-059 Contracts 847,640 425,000 590,000 91-083 Vehicles & Expenses 5,921 8,500 8,000 91-100 Other Expenses -0- 1,080 -0- Construction Contribution (187,146) -0- -0- Total Water Mains 729,999 460,930 648,695 92-000 Vehicles & Equipment 49,834 60,500 4,100 93-000 Easements 74,454 (3,000) 60,000 Street Repair 001 Salaries & Wages 10,962 8,500 11,000 94-025 Materials 13,661 20,500 25,000 94-083 Vehicles & Equipment 442 3,000 3,000 94-100 Other Expenses -0- -0- -0- Total Street Repair 5� 32,000 39,000 Total Capital Transmission and Distribution $945,745 $643,480 $855,995 Capital Sewer Maintenance & Collection Sewer Mains 95-001ries & Wages $ 91,433 95-025 Materials 19,562 95-054 Contracts 841,151 95-083 Vehicles & Equipment 28,510 95-100 Other Ex ense oo Construction Lont.(non cash)(308,941) Total Sewer Maint. & Col. W71,715 $ 41,500 $ 20,000 11,200 13,250 140,000 1,664,000 15,600 7,000 8 8 -- -- 08 1h Actual Estimated Budgeted 1979-80 1980-81 1981-82 Sewer Connections 96-001 Salaries & Wages 34,119 35,800 40,060 96-025 Materials 16,805 20,500 24,200 96-054 Contracts -0- -0- -0- 96-083 Vehicles & Equipment 6,964 12,100 12,000 Total Sewer Connections �i8,400 �76,26 92-000 Vehicles & Equipment 43,485 7,100 15,000 Street Repair 9494-OOTSalaries & Wages 11,655 -0- -0- 94-025 Materials 1,793 -O- -0- 94-083 Vehicles & Equipment 4,483 -0- -0- 94-100 Other Expenses -0- -0- -0- Total Street Repair 17,931 -0- -0- 93-000 Easements 49,468 20,000 15,000 Total Capital Sewer Maint. & Col. $840,487 $303,800 $1,810,510 Capital Pollution Control Plant 97-000 Plant Improvements $ -0- $ -0- $ -0- 92-000 Vehicles & Equipment 1,516 37,000 50,000 Total Capital Pollution Control $ 1,516 $ 37,000 $ 50,000 Capital Customer Accounting & Collection Water Meters 98-000 Water Meters $ 17,300 $ 12,500 $ 23,375 Total Water Meters 17,300 12,500 23,375 Vehicles & Equipment 2-000 Vehicles & Equipment Total;Vehicles & Equipment Total Capital Customer Acct. & Col. $17,700 400 400 $ 27,830 27,830 40,330 $ 15,000 15,000 38,375 Capital Administration & Engineering 92-000 Vehicles & Equipment Total Capital Administration & Eng. $ $ -0- -0- $ $ 9,210 9,210 $ $ -0- -0- Capital Recreation 99-000 Capital Expense Total Capital Recreation $ $ -0- -0- $ $ 3,300 3,300 $ $ -0- -0- Grand Total $1,805,448 $1,141,120 $2,823,880 37 ♦ i WATER AND SEWER FUND CAPITAL BUDGET EXPLANATION OF ACCOUNTS Water Supply and Treatment Capital Expenditures Y Acct. 80-000 Fluoridation: This project is carried over from 80-81 and is expected to be completed this year. Transmission and Distribution Capital Expenditures Acct. 89-001 - 89-100 Water Service Connections - Very little change is anticipated in the number of taps of 1981-82. The materials cost is higher to account for these special purchases: a) 3/4" and 1" bits b) 6" and 8" shell cutters c) new hose for Hole -Hog Acct. 91-001 - 91-100 See Water Mains Summary* Acct. 93-000 Easements - includes - a) settlement of prior condemnations b) new right-of-way on relocation project (highway 62 from bypass through Farmington) c) miscellaneous R/W acquisitions Acct. 94-001 - 94-083 Street Repair - reflects an increase of effort in this program Acct. 57/92-000 Capital Equipment: Ice machine $3,000 Generator 1,100 Total $4,100 One Tractor/Backhoe will be sold and not replaced. * Water Mains Summary Project Cost Labor Materials 1. Relocation Hwy 62 from 71 through Farmington (c) $510,000 $ -0- $ -0- 2. Relocation Hwy 156 (c) 72,000 -0- -0- 3. Industrial Park Ext (f.a.) (Marshalltown Tools) 20,695 3,000 15,695 Equipment $ -0- -0- 2,000 38 4. Miscellaneous (f.a) 38,000 24,000 5. Relocation North Street (c) 8,000 -0- Total Water $648,695 $ 27,000 Explanation of Projects WATER MAINS - Capital 1. Relocation, Hwy 62, Bypass through Farmington - $510,000 8,000 -0- $ 23,695 6,000 -0- $ 8,000 The purpose of this project is to clear the Highway right-of-way with our water lines. Engineering for this project was included in the 1980-81 budget, but was not expended. The above cost included engineering and construction costs, but not right-of-way. The cost of right-of-way is included elsewhere in this budget. We will be replacing some 8 -inch line with 12 -inch line in order to improve service to Farmington and the growth area. 2. Relocation, Hwy 156, $72,000 The purpose of this project is to clear proposed Highway construction on 156. The cost given is a contract cost. If feasible, we would do this work on force account. 3. Industrial Park Ext. - $20,695 The purpose of this project is to supply adequate water service to an industrial site the Industrial Park. We will supply labor and equipment on force account and the owner will supply material. 4. Miscellaneous - $38,000 These projects would include small water line extensions, placing of mains and services in various areas prior to paving, oversizings, and line replacements. 5. Relocation, Gregg & North St., $8,000 • The purpose of this project is to move our 12" waterline for street widening (by Arkansas Highway Transportation Department). The above cost is to clear the • way for the construction of R.C. Box Culvert, which we anticipate to occur in 1981-82 fiscal year, however, the total estimated cost of this project will be $42,000 to be completed in 1982-83 fiscal year. Engineering will be done in-house and right-of-way expenses are included elsewhere in this budget. r 39 W i + c Sewer Maintenance and Collection Capital Expenditures Acct. 95-001 - 95-100 Sewer Mains - See explanation of projects** Acct. 96-001 to 96-083 Sewer Connections - All items were estimated from 80-81 experience. We expect about the same number of taps in 1981-82 as we had in 1980-81. The materials include $2800 for new sewer tapping bits. Acct. 92-000 Vehicles & Equipment - One 3/4 ton pickup with heavy duty transmission and suspension. Needs long wheel base with utility bed and special storage bin. Rear bumper to be of strength for plumbers vice work. Cost $15,000 Acct. 93-000 Easements - Possible easement acquisition on Highway 62, 71 to Farmington Project, condemnation settlements, miscellaneous easements. Sewer Mains Summary** Sewer Mains 1. Relocation, Hwy 62 from 71 to . Farmington (c) 46,000 -0- -0- -0- 2. Hwy 71, between Johnson Road & Hwy 71 (c) 150,000 -0- -0- -0- 3. Ind. Park Ext. (f.a.) (Marshalltown Tools) 18,250 6,000 9,250 3,000 4. Miscellaneous (f.a.) 22,000 14,000 4,000 4,000 SA. Relocation, North Street 6,000 -0- -0- -0- Subtotal 242,250 20,000 13,250 7,000 5B. Sewer Rehabilitation Eng. (c) 142,000 -0- -0- -0- Sewer Rehabilitation Construction (c) 1,320,000 -0- -0- -0- Total Sewer $1,704,250 $20,000 $13,250 $ 7,000 an A Explanation of Projects SEWER MAINS - Capital 1. Relocation - Hwy 62, Bypass to Farmington - $46,000 The purpose of this project is to clear Highway construction with our sewer lines. The engineering cost was budgeted in 1980-81, but was not expended. The cost given above includes Engineering and construction. 2. Relocation - Hwy 71, Between Johnson Rd. & Hwy 112 - $150,000 The purpose of this project is to clear proposed construction of an interchange. One hundred percent of this cost is reimbursible. 3. Industrial Park Extension - $18,250 The purpose of this project is to provide sewer service to an industrial site adjacent to the Industrial Park. We will supply labor and equipment on force account and the owner will supply material. 4. Miscellaneous - $22,000 These projects will include short extensions, crossings prior to paving, and possible oversizing projects. 5A. Relocation, North Street - $6,000 The purpose of this project is to clear the way for construction of R.C. Box Culvert on North St. Engineering will be done in house, and right-of-way expenses are included elsewhere in this budget. 58. Sewer Rehabilitation - $1,462,000 The purpose of this project is to rehabilitate certain sewers in the City which have been determined to be cost-effective to repair. This project will be funded in part by an EPA grant. The grant money is shown in revenues.of $300,000 and in contributions in aid of construction - EPA studies $757,500. Pollution Control Plant Capital Expenditures Acct. 92-000 Vehicles and Equipment - includes - a) Equipment & improvements in connection with sludge disposal $36,600 b) Automatic samplers (2) 5,400 c) Hydraulic set-up for removal of bearings 2,700 j d) Chlorine scale for RAS chlorinator 2,300 e) Machine for cleaning lime scale from coil filter tanks 1,500 f) Chemical pump for Ferric Chloride 1,500 TOTAL Al Customer Accounting and Collection Capital Expenditures Acct. 92-000 Vehicle and Equipment purchase - Replacement of one 1974 Ford and one 1977 Datsun. The Ford has been overhauled once and needs overhauling again. The 1977 Datsun has a history of high maintenance costs. • Total $15,000 Acct. 98-000 Water Meters Item No. Needed Unit Cost Total Cost 5/8" and 5/8" x 3/4" water meter- P.D. $ 500 $ 30 $15,000 5/8" water meter - P.D. 10 100 1,000 1 1/2" water memer - P.D. 6 200 1,200 2" water meter - P.D. 2 250 500 2" water meter - comp. 2 575 1,150 3" water meter - Turbo 1 575 575 3" water meter - F.H. 2 400 800 4" water meter - Turbo 1 850 850 4" water meter - comp 1 1,350 1,350 Generator remote - P.D. 20 20 400 Generator remote - Turbo 10 50 500 Generator remote - comp 2 25 50 Total Water Meters - 98-100 • $23,375 TOTAL Capital 98-000 - 92-000 $38,375 A9 C T C 4 T C I I F - + a -• n d= T- d o (3- _ — r4 p _ C o : L` J_C d — 7 _ d• m N ' K - n LUi fN .— C P N _ or- _ II' I III L —] j K1 — - M� _. r --L _ _ _ 1 — r T r.• 4 F 4- ^` O '�' rA Ir1 C I" — i 1 - _ r O ~ I rn I✓ N �Vy o+ N J un I :r J` rn T � Lt N v � C - ._ v ✓ —v—v. rr - r.i 41 -c-a MniN OC,T rrON o- — I -- -I 2� o I :� o Ina IUr� 7Tn'it rich GN= N o- I�>, I �y 1 :r E i mi O K1 �i ' - — O N N to 1n i. r!1 O �• T C. — In Lr rn rO t'- u• ' rl o- - n .- y Vi w r N v� r -- m p P P l-. 1'- N J c. _ l V O' iL N T In f Yl L^ TJO.. c-unl S r r —CC m u J H �.( 1L!�j O U N s In r y F o-" r N N c- N ^y� T no L9 L "1 ry In IPn z o 5 , - N N -r ll I :1 I1 I I I I I I I u n n ¢_o n 1 I I - I - P P s VI o VI i rn T o. a T i .. m 1/I +- —P ru— —cr3 m o LomaIV' ql T G 9 M N O o- Ib oa I _ F m .. - - ry I I < : �i a P 1- v o o ,- r N r _ y c_ o-- J N c.. ^y - n C O} o oe T rr'1 WJ - '1 P U N in S NuPt N 3 _... __ n nJ r CI N T. - 4+ .4o- , - 5 9 r- . . s-.- J .S a- «m— _N 1 I I •I I I I _ _ E I. I I Il I I I I I I I I;_.� I 1 r, 1 I I . I I 1 L I I Q.. a L C I I I I I I I I I C� ;�� : — - N M G N r . — ti L O r .I P I S Y I — --'-0- _— ,i r l u ml ry 9 Lv - ,n - — C? LJ 4 N L1 3 �� i r— rIc— O U Tm N— °--O--V -rT NS L. T3 L_ u 0— in — _ ry r- °-0a0--- ' T N 1 b L r _ I u W o .-,',r N iq Y in Cp ..o, ... _r 4.-.. U• ... _ .... n P V n 4 •V Vt I a l L • U l t l u b p J J Y a • , a J p Y J • O I. , O L a i P 4. I-' .4 a p Y O L— K — K Y a r l - J a C W U M d d C K O J 6 W Tr'- L C •. O ' C 4 a +! O LL L .O C • L VI y C C L a r. 4 W a U U N LL Q u P M y 6 • u O C O S N S= CT O 9 W N r £ d -a .O N W V .e — Q 4 N P 4 u L n •W S - .d- tl— L Y U • C • L ` Y N 4 i t r •Q+ J O 4 U v" nc u c o v Ci i `4 = `u Y C= C- -` `n I. 0 `.C L` c v v •- C C U C O a a, C 0 C v 4 C 9 `+ L L O 4 4 b — -- r• • 4 J LL O 4 C b J S 4 O Y J- S£ it IJL ~ r i L J O£ i r. ~ O u 9 l 4 H J m 3 O • ' 3 LL£> 1. •• O l 0 m l .4 r a - 1 • G - r� ' c r N - a a I € I V V: I 43 .d. , 1. lr(0-i.. __ 1 CL7 t — n1 d d -2 V M IN1 rtl r '?. - Ifl m 'ul N Cn N f 7 c 1 � _ Vf w cn . __.. P N -r NI I I I I I I) V I I I I I I --_. u w o LO r-' I o- Ln r N c N r- In . N . •d+ al i .y fr, ;i r ` V Vl N ll!I fr' U W r6 G r },J r7 - E d 1 �l ':./ rrtl ) to . t O -5 V r I - ._ ,. I r 1 ciU a r" o-- r• n N . r o- o- U] c r .. _.. ...__..----._.. d r I s 'c ea ,-5 - _ rflrflC , M 3 — O ^t V 1` rV 7- n v q h1 .. ., .. w .._ .._.._—.. ... Co M -S cD — I I I I I I I I I 1 I I..I ......� I. ..._I_. _ O N I J�n - to r''. I .. .. ..... w u U Too N N 1 L V rll s S 7 i : r'1i r>f G 1 w 2 -o t r o- r crr�—� r cc -...-.,. W 1 UO N Uc- Ir y 1� PNT .__ .o«r rm—' lf1m ,nceJrr'p --o E ry N3 N to r' rn r�Pt L ._'V1ern rA-1T,�M _.w o r O — —_ u n ,Z — U N N • "C i C) C -- V W « d • «a u • LL d « n, j W a N N a,-,-- b 0 U Cl ..-- K P CC — u W .- C O M d£ L W = 1 •a. W O. • J r d d N c , O W N L N • « W N W >O. H • rd C W .--. u ._ N OI d a0 L N [ d d d C'— C u -a « • u p = U C O E d d q d J H C 7 E ^ CL- D O �' U d I C 0p i I «' V O C C.- 0 N I - ....bi- r N -- �:-M�FT-,'- � J iT9 L� ✓T p, � r r7-o� �'�' 1 I I b mi I.l '(L o- Ln ♦c P 1% T r G I U S r• rr'1 - u r M P r �' 00 b� i N p _ S a r, r o -I .. T ll'1 _-- - n-T�� N �- � -> C. i= .J-rJ'� �T v o- G - -•. =1 ' LI- •. r m n llL 17 v V n -T 4 N In ' fl +l T c r o- Ir :l P ? P - I D^ J •-] /- r m J` I I! l/1 'T r <a Nl T ` Q P � L" � u tp� ri rJ -r I.. l V Yl 1.^ J r �' M - ✓ ? :J U - r J' +. N • q_ P U Y iP u. S i[ T J T t •r —N I JI � I I I I I i I I �II III rl I I Ii I.II n tT m J' T N M — � � - - L- N - ✓ r z rr:lo Lov Mo I�� .+MCP r 1rl .� e rn o -n I I tr �u'a _ i. u re o- rl In In r r " I z I' I I_ I J` a cl P I P r :c 7- r 1/i 7 o u. r Y o- 7.n mtrr T Inm __ VJ ml v �e NH - o- � h S tr � .. _ •, T - rl N ry - -1 rl !1 In !J T O rA S 9 N r C r 1 _9 r II r 'c r I .4.. j� L I (� O 9 ua• (T V tr I T- S O T~ T r I I :f• e b v r v T1T1iTLh1I1 G_ a` } - V E L7 U - - I11 M —� i11I L. _- - .? J m 3 V P y P }. U �$ VI S N ✓' r'. 1 1 b V. S c m r P1 J w r r r- 4 17 r s - L - N w �• I • c 0- , • Iv p m o PI - N oe 'Sp s - e, S S U ni C -=-c- _. 0 n 'fl'- •' .N u1- r -. v' 9 5 UI n 2 1 Y 1 _� J,;LI-IIII'I I i l I � 11.11I 1lI I i.lI I W b I L � V J p N l• O II J_S r'__ cP mI III I'III T V Q y O Y N u V. •:.e N J S LT , tr_ N m P r, _ m n L y— ri C eq ref J` T . C I _ 41 — —ry y Y 0 _ M ; c - m Q tr J -r ^ 0 Th C U' - g---- -4C L -- C- I_ L' IJ N N Ill IVi ♦ : _ �/: i V P .. V -a m..N, _..: -fl c, Jr W O — I 0I • L L J —O • I` b b d N I L L Tj d J p Y: Y •• L . L L L ••1 Y J r• O W V N d I Y a Y O N a J • - 1•_ C V p W 6 fl C •Y O C C -- U 7 - ^ - V o ]., 1- L C L V J .- -J •� S. •K C • L N_ u g 2 C b p W N LL F Y P LL Q Q U. £ L p W r 4 N P d a N£ L Y V= d b £ W d, U W d! Q N W WI V /1 C Y N q y h y t C L L !- C Y q O d> 1 d Y V • q L •Y V •C Y V •C •-I0 • g J c d` O Y C p C L q u L - .C L Y •V -q -CL C • C C C O C�- C CI - CO 0 (•• J J J~ J 0 3 0 N£ 2 LL t i 4 3 L Y LL~ £ a V~ '� v q b> O U I o W K Q K • 45 _ . I I J t -adi rr] _S - O ._ c T — d - - — a - •I r-- cJ r- M rJ r r -- — In L I I I o I c- I L r N b.• Y — .. ._._ .._ .. .. c —va—�^ �' Cam` _ -'mac -rte r� rr� :° .- t° -1 t -J s r L� a y K z - i u a n — - .. - m of C. .. .. ? 'ni o - u o 91 _ _ I I '�� •� S v r to ry S r -c -o-a- a- :-..-' - r N r .. _ r .. .._.... .. ... _:. -- M �._... q - r t+"1 ci �..__... Miy �, Vci N V O N q_ m -.N _ .. — — ......i ---I .. .. .. ... (fl -OD ' Y W y ..... .. .. Q _ C J O ' d ^ C I N r I — I 0 I I_ .- Cj If) 1 .. .. •O - r,4 r N - Y' J L W 6 v V > r .N ¢ C U- -------- RE rn r ^! U ^ N rw Nn r.- S - G �J T cM„q r - y' ._•' Y Y lV i In J V 0 - La m rn — rJ — S N V U .. .I.. _...— _.L: C. .. .—_..(__.___.—_.. W O 1 I�� U ' N m 0. I I ' d C • GI ••-• N 6 I + 0 a x L J ' d '^ - >' Y • ..- r J•V L J L• Y d Y • LL Y a W , J a- d V -- on. U.- Y W U, • C J J N 6r a0 V - J O d - X ; C '^ O L S C C O L 0-U '^ >, 0- y V! q O W N L N N 0 N O 6 : Q C 0. O£ U d J Or C d c01-) F- d V p • C. d d C C Y V • 0. C CO Y W- 1 •n C E; 3.-s L 5-0 C V E ^ L -n 0 G V b • d q J d d q d J 1- Cr- r q d J I F- O CC) G J m 1 N N£ > LL J m 0- i> LL J Q O •^ 01 - 6 a U •Y q U 1 In 0= a0 6 C V £if - - — a n I AI A pi CITY OF FAYETTEVILLE, ARKANSAS WATER AND SEWER FUND SURPLUS REVENUE FUND FOR THE YEARS ENDED JULY 31, 1982; 1981; and 1980 CASH INVESTMENTS Balance - July 31, 1980 $ 129,207 $ 333,000 Maturities of Investments $1,958,091 ($ 1,958,091) Purchase of Investments ($2,739,562) $ 2,739,562 Disbursements Loans and Transfers Receipts Transfers and Loans Other Balance - July 31, 1981 Maturities of Investments Purchase of Investments Disbursements Loans and Transfers Receipts Transfers and Loans Other Balance - July 31, 1982 $ 462,207 $ 623,971 $ 623,971 $ 45,233 $ 45,233 16,940. $1,114,471. %i,131,411 $1,114,471 ($ 825,471) ($ 289,000) $ 16,940 ($1,114,471) 825,471 ($ 289,000) $ 825,471 $ 842,411 47 CITY OF FAYETTEVILLE, ARKANSAS WATER AND SEWER FUND EXPLANATION OF 1980-81 BUDGETED TO ACTUAL Revenues Budgeted Estimated Difference Water Sales $2,100,000 $2,478,000 $ 378,000 Sewer Service Charges 1,375,000 1,640,000 265,000 Interest 150,000 250,000 100,000 Beaver Reimbursement 75,000 100,000 25,000 CPA Reimbursement 315,050 82,000 (233,050) Water & Sewer Connection Fees 140,000 121,000 ( 19,000) Reimbursement on Hwy Projects 415,900 240,000 (175,900) General Fund Loan 70,000 -0- ( 70,000) State Health Dept. Grant 66,000 -0- ( 66,000) Surplus Fund Transfer 450,000 -0- (450,000) $5,156,950 $4,911,000 45,950 !, Expenses Fluoridation 140,000 104,000 36,000 Easement Acquisition 120,000 20,000 100,000 Materials (57/91-025) 47,000 6,500 40,500 New Sewer Main Contracts 345,700 140,000 205,700 Utilities 170,000 210,000 ( 40,000) Professional Services 436,000 550,000 (114,000) $1,132,700 $1,030,500 $ 228,200 as YI � 1 CITY OF FAYETTEVILLE, ARKANSAS WATER AND SEWER FUND EXPLANATION OF 1980-81 BUDGETED TO ACTUAL REVENUES DETAIL V 1. Total Water Sales Budgeted - $2,100,000 Estimated- 2,478,000 $ 378,000 over Explanation - More water sold than expected due to dry weather conditions. 2. Sewer Service Charge Budgeted - $1,375,000 Estimated- 1,640,000 000 over Explanation - Did not budget for sewer rate increase. 3. Interest Budgeted - $ 150,000 Estimated- 250,000 100,000 over Explanation - Did not have to use surplus funds as expected. 4. Beaver Reimbursement Budgeted - $ 75,000 Estimated- 100,000 25,000 over Explanation - Original figure was estimated by Richard Starr 5. EPA Reimbursements Budgeted - $ 315,050 Estimated- 82,000 233,050 under Explanation - EPA Regulations prohibit the reimbursement of more than ii 80% of a grant until the project is completed. Fayetteville has reached that limit now. We should complete the project in 81-82 and receive all grant funds due. 6. Water and Sewer Connection Fees Budgeted - $ 140,000 Estimated- 121,000 19,000 under Explanation - Mistake made in estimating original figures on. sewer connections. 7. Reimbursements on Highway Projects Budgeted - $ 415,900 Estimated- 240,000 $-175,900 under Explanation - A $200,000 reimburseable project was delayed until 1981-82 8. General Fund Loan Budgeted - $ 70,000 Estimated- -0- $-70,000 under Explanation - Loan not required. Ito 9. State Health Department Grant (Fluoridation) Budgeted - $ 66,000 Estimated- -0- 66,000 under • Explanation - Fluoridation project not completed in 80-81 as expected. 10. Surplus Fund Transfer Budgeted - $ 450,000 Estimated- -0- 50,000 under Explanation - Transfer not required to meet expenses 4 *._.I.. • CITY OF FAYETTEVILLE, ARKANSAS WATER AND SEWER FUND EXPLANATIONS OF 1.980-81 BUDGETED TO ACTUAL EXPENSES DETAIL Project 1. Fluoridation Budgeted Amount - $ 140,000 Estimated Exp. - 104,000 36,000 under Explanation - Work will not be completed in 1980-81. Carry over to 81-82. a 2. Easement Acquisition Budgeted Amount - $ 120,000 Estimated Exp. - 20,000 100,000 under Explanation - Did not acquire easements. through Farmington as expected. Will be done in 1981-82. 3. Materials (57/91-025) Budgeted Amount- $ 47,000 Estimated Exp. - 6,500 40,500 under Explanation - Did not do Highway 156 as budgeted. Will be carried over to 1981-82. 4. New Sewer Mains Contracts Budgeted Amount - $ 345,700 Estimated Exp. - 140,000 205,700 under Explanation - The 12 -inch sewer relocation estimated to cost $200,000 will be done in 81-82 rather than in this budget year. 5. Utilities (63/50-064) Budgeted Amount - $ 170,000 Estimated Exp. - 210,000 40,000 over Explanation - Did not budget property originally, plus using more blowers than usual in the treatment process. 6. Professional Services (66/50-051) Budgeted Amount - $ 436,000 Estimated Exp. - 550,000 ,000 over Explanation - Overrun of estimated costs in EIS project and Facility Plan work. 51