The URL can be used to link to this page

Home My WebLink AboutMinutes_Workshop_08/14/1984. MINUTES OF THE WATER DEPARTMENT BUDGET WORKSHOP MEETING OF THE VILLAGE OF TEQUESTA, FLORIDA AUGUST 14, 1984 A Water Department Budget Workshop Meeting was held by the Village Council of the Village of Tequesta, at 7:00 P.M., in the Village Hall, 357 Tequesta Drive, Tequesta, Florida. Councilmembers present were: Brown, Murphy and Stoddard. Councilmembers Mapes and Wagar were on vacation. Also present were: Robert Harp, Village Manager, Cyrese Colbert, Village Clerk and Bill C. Kascavelis, Finance Director. The Village Manager reviewed briefly the proposed budget. The Manager told Council that the proposed budget had been revised to in- • clude $0.25/1,000 gallons increase by Jupiter and Village's increased rate of $1.05/1,000 gallons. The Village Manager told Council that there has been a 48% increase in insurance for employees. Council had no objections to the budget. (A copy of the budget has been made part of this minutes). The meeting was adjourned at 7:20 P.M. CYR SE COLBERT CC:mk I• VILLAGE OF TEQUESTA WATER DEPARTMENT BUDGET 1984/1985 PROPOSED BUD GET REVENUES 1984/85 OPERATING REVENUE Water Sales $1,228,850 Connection Charges 11,000 Fire Hydrant Rental Fees 11,400 Computer Service Fees 4,000 Other Income 900 TOTAL $1,256,150 INVESTMENT EARNINGS Interest 115,000 Total Revenues $1,371,150 DISTRIBUTION OF REVENUES REVENUES $1,346,150 DISTRIBUTION Operation & Maintenance Fund $ 855,160 Sinking Fund 264,315 Renewal & Replacement Fund _ Bond Amortization Fund 2,000 Special Purpose Fund - Retained Earnings Account 249,b75 TOTAL DISTRIBUTION $1,371,150 • NOTE: Revised to include $0.25/1000 gallons increase by Jupiter and Villages' increased rate of $1.05/1000 gallons REV. 8-10-84 WDR-1 VILLAGE OF TEQUESTA WATER DEPARTMENT OPERATION & MAINTENANCE FUND BUDGET • 1984/1985 Actual Proposed ' Actual Budget Thru Budget EXPENDITURES 1982183 1983/84 6-30-84 1984/85 PUMPING & STORAGE EXPENSE PERSONAL SERVICES Salaries & Wages $ 20,958.00 $ 22,910 $ 16,096 $ 26,062 Overtime 1,456.00 1,300 572 - FICA Taxes 1,565.00 1,677 1,250 1,834 Retirement Contributions 2,576.00 2,600 1,923 3,190 Life and Health Insurance 2,223.00 3,000 2,024 3,012 Workers' Compensation 440.00 480 480 571 TOTAL $ 29,217.00 $ 31,967 $ 22,345 $ 34,669 OPERATING EXPENSES Communication Service $ 1,458.00 $ 1,690 $ 1,126 $ 1,700 Utility Services 37,345.00 38,000 30,474 46,000 Insurance 897.00 1,300 1,046 1,800 Miscellaneous 549.00 502 104 501 . Office Supplies 124.00 150 - 100 Professional Services Water Monitoring 10,315.00 11,000 6,220 12,000 THM Sampling 3,443.00 2,000 1,092 2,000 Other Sampling - - - 1,500 Repair & Maintenance Service Car, .Truck, Tractor 1,973.00 1,000 749 1,100 Machinery and Equipment 16,904.00 6,800 2,272 5,000 .Building and Others 314.00 1,000 41 500 Operating Supplies Gasoline & Oil - Car, Truck, Tractor 1,210.00 1,475 1,044 1,400 Purchased Water 328,500.00 330,000 246,375 335,000 Chemicals 2,082.00 2,000 1,460 2,000 Laboratory Supplies 96.00 200 101 300 Small Tools & Equipment 318.00 500 427 500 Diesel Fuel - 750 - 300 TOTAL $405,522.00 $398,367 $292,531 $ 411,701 DEPARTMENT TOTAL $434,738.00 $430,334 $314,875 $ 446,370 8- 8- 84 WDE-1 VILLAGE OF TEQUESTA • WATER DEPARTMENT BUDGET 1984/1985 Actual Proposed Actual Budget Thru Budget 1982/83 1983/84 6-30-84 1984/85 DISTRIBUTION EXPENSES PERSONAL SERVICES Salaries & Wages $ 57,223 $ 61,393 $ 44,031 $ 66,877 Overtime 5,825 6,000 2,311 5,100 FICA Taxes 4,105 4,669 3,260 5,065 Retirement Contributions 6,888 7,240 5,044 8,186 Life & Health Insurance 5,727 7,960 5,424 9,870 Workers' Compensation 1,154 1,288 1,288 1,577 TOTAL $ 80,920 $ 88,550 $ 61,358 $ 96,675 OPERATING EXPENSES Insurance $ 616 $ 900 $ 853 $ 1,200 Miscellaneous 241 402 - 195 Office Supplies - 50 - 50 Repair & Maintenance Car, Truck & Tractor $ 2,021 $ 1,750 $ 644 $ 1,100 Machinery & Equipment 236 1,200 3,596 4,000 Gasoline and Oil - Car, Truck, Tractor 1,181 1,475 1,024 1,400 TOTAL $ 4,293 $ 5,777 $ 6,117 $ 7,945 DEPARTMENT TOTAL $ 85,213 $ 94,327 $ 67,475 $104,620 WDE-2 8-8-84 J VILLAGE OF TEQUESTA WATER DEPARTM ENT BUDGET 1984/1985 • Actual Proposed Actual Budget Thru Budget • 1982/83 1983/84 6-30-84 1984/85 OFFICE & ADMINISTRATIVE EXPENSE PERSONAL SERVICES Salaries & Wages $ 28,459 $ 30,248 $ 19,320 $ 32,219 ' FICA Taxes 1,956 2,093 1,401 2,267 Retirement Contributions 3,113 3,244 2,300 3,944 Life & Health Insurance 4,263 4,465 3,247 4,011 Workers' Compensation 163 50 49 54 Unem to ent Com Insurance P Ym P - 500 -- 500 Employee Recognition Program - - - 400 TOTAL $ 37,952 $ 40,600 $ 26,317 $ 43,395 OPERATING EXPENSES Accounting & Auditing $ 10,545 $ 12,610 $ 12,609 $ 13,500 Travel & Per Diem 136 300 170 300 Communication Service 2,044 2,200 1,584 2,200 Transportation-Postage 5,418 5,900 4,085 5,900 • Utility Services 3,500 3,500 - 4,000 Insurance 4,439 4,700 3,093 3,500 Miscellaneous 90 99 35 95 Office Supplies 3,701 6,750 1,770 7,500 Books, Publications, Dues 215 300 175 300 Legal Service ,1+,446 1,200 1,261 2,000 Engineering Service 9,222 15,000 6,935 15,000 Rentals and Leases FEC Leases 80 100 80 110 Other - P.O. Box - 50 - 50 Office Equipment 1,083 1,250 700 1,300 Repairs & Maintenance Service Off ice Machines 4,829 5,400 5,095 5,600 General Maintenance 120 130 102 150 Personnel Training 237 300 80 300 Licenses & Fees 1,550 1,600 1,595 1,600 Administrative Manauement.; 52,800 55,440 41,580 60,000 Lot- 15, Teq:uesta.Piries Expense - - - 370 TOTAL $104,449 $116,829 $ 80,949 $123,775 DEPARTMENT TOTAL $142,400 $157,429 $107,264 $167,170 • TOTAL OPERATING EXPENSES $662,350 $682,090 $489,614 $718,160 WDE 3 8-8-84 VILLAGE OF TEQUESTA WATER DEPARTMENT i BUDGET 1984/1985 OPERATION AND MAINTENANCE FUND REVENUES Estimated Cash on Hand - October $ 2,000 Transferred from Revenue Fund 855,160 ' TOTAL $857,160 EXPENDITURES Pumping and Storage Expense $585,370 Distribution Expense 104,620 Office and Administrative Expense 167,170 . TOTAL $857,160 DEBT SERVICE Total Revenues $1,371,150 Less: Operating Expense 857,160 C cis nnn $513,990 = 1.930384 $266,263 NOTE: Revised to include $0.25/1000 gallons increase by Jupiter and Villages' increased rate of $1.05/1000 gallons. WDO&M-1 REV. 8-10-84 i• VILLAGE OF TEQUESTA WATER DEPARTMENT BUDGET 1984/1985 REVENUES The water sales have been estimated based upon the current trend, 3% growth and service to Rolling Hills for 3/4 of the year. The water sales for the first nine (9) months of the current fiscal year were 424,015,000 gallons (388,336,000 last year) for $762,472. ($728,073. last year). The rate per 1,000 gallons has been kept at $0.80. Computer service fees are paid to the Water Department by the Village General Fund. Interest earnings have been estimated taking into account the payments to be paid for the Water System Improvements. EXPENDITURES u OPERATING EXPENSES PROFESSIONAL SERVICES OTHER SAMPLING This line item has been added to the budget to provide for additional required sampling for synthetic and volatile organics. OPERATING SUPPLIES PURCHASED WATER This amount has been based upon 1,518,000 gallons per day to be purchased from Jupiter, 554,070,000 gallons annually at the present contract cost of $0.60 per 1,000 gallons plus approximately $2,600 additional. The enclosed computer printout from Gee & Jenson indicates the complete shut down of the water treatment plant during the construction of the new plant should not adversely affect the contract provisions for purchase of water from Jupiter. OFFICE AND ADMINISTRATIVE EXPENSE EMPLOYEE RECOGNITION PROGRAM Provision has been made for this item the same as for the General Fund. 8-8-84 August 8, 1984 Page 2 - Lot 15, Tequesta Pines Expense Provision has been made for 1984 taxes and membership in the Homeowners Association. Administrative Management This is paid to the General Fund by the Water Department. Capital Improvement Fund The Water Department Superintendent has recommended the purchase of the following items: Heavy Duty Impact Wrench $ 400.00 Trailer for Air Compressor 375.00 $ 775.00 RENEWAL AND REPLACEr1ENT FUND This fund is to make replacement of Capital Equipment as necessary and expenditures from the fund msut have the approval of the Water Department Consulting Engineer and the Village Council. There has been no provision made for funding this fund for the 1984/1985 fiscal year since the balance in the fund at September 30, 1984 is expected to be approximately $26,500. Gee & Jenson (John F. McKune) have been given their approval for this. The Water Department Superintendent has recommended the purchase of a new 3;/I~ ton pick up truck at an estimated cost of $7,000 from this fund during 1984/1985 fiscal year. DEBT SERVICE The following payments are required to be made to the paying agent for annual payment on the $3,915,000 Village of Tequesta Water Refunding Revenue Bonds, Series 1978 and annual payment to Sinking Fund, Bond Amortization Fund, 2007 terms bonds to be applied to the purchase of U.S. Government Obligations until October 1, 1983: August 8, 1984 Page 3 - • April 1, 1985 $ 132,83.1.50 October 1, 1985 132,831.50 $ 265,663.00 Paying Agent Fees 600.00 Total $ 266,263.00 The Bond Ordinance provides that adequate revenues will be provided in each year to pay 100% of all costs of operation and maintenance of the Water System in each year. and all reserve or other payments required and 125% of the Bond Service requirement in each year on the outstanding $3,915,000. Village of Tequesta Water Refunding Revenue Bonds, Series 1978. The coverage in the proposed budget is 1.968504 computed as follows: Total Estimated Revenues $1,242,300 (including interest) Less: Operating Expenses 718,160 • $ 524,140 $524,140 _ 1,968504 $266,263 which meets the 125% coverage requirement. $52.00 of the amount on Page WAR-1, Distribution to the Sinking Fund and Bond Amortization Fund is for postage, etc. Attached is a copy of the "Schedule of Estimated Bond Service Requirements" for. the $3,915,000 Village of Tequesta, Florida Water Refunding Bonds, Series 1978. PAYROLL Has been provided for pursuant to the guidelines established for the General Fund. August 8, 1984 Page 4 - • MISCELLANEOUS Since there are several unknown factors pertaining to the Water System at this time which might affect the budget, we believe that once the new plant is in operation (riarch 1985) we can derive some data from its operation and revise the budget accordingly if need be. We have worked a budget for comparative purposes only providing for an increase in the Rate of Bulk Water purchased from Jupiter in the amount of $0.34/1,000 gallons for a total rate of $0.94/1,000 gallons and increasing the Village's rate to $1.14/1,000 gallons. Using these figures, the debt service coverage would be 2.024840 and an estimated amount of $249,825 would be transferred to the Retained Earnings Account. • RH:mk • SCHEDULE OF ESTIMATED BOND SERVICE REQUIREMENTS The following table sets forth the estimated annual net debt service payments for the 1978 Bonds: • Principal Payments Payments Including Year to Amortization Ending 2007 of 2003 October 1 Term Bonds(1) Term Bonds Less Interest Income and Maturing Principal of Government Obligations in the 2007 Term Bonds Special Account Applied Interest to Reduce Payment(2) Debt Service(3) Principal Amount of Government Obligations Purchased with Total Net Payments Bond Service to the Requirement 2007 to be Paid Term Bonds by Village from Special Net Revenues Account(3) 1978 $536,100(4) $ 44,044 $ $0,144 $ 565,000 1979 1,400 264,263 265,663 50,000 1980 1,400 264,262 _ 265,662 50,x00 1981 1,400 264,263 265,663 r. 60,000 1982 1,400 264,262 265,662 60,000 1983 1,400 264,263 265,663 65,000 1984 1,400 264,262 265,662 75,000 ~~,._, ._ 1,400 264,263 265,663 75,000 1986 1, 400 264, 262 265 , b62 " . `~~"~'S'~d 1987 1,400 264,263 265,663 90,000 1988 1,400 264,262 265,662 100,000 1989 1,400 264,263 265,663 105,000 1990 1,400 264,262 265,662 115,000 1991 1,400 264,263 265,663 125,000 1992 1,400 264,262 265,662 140,000 1993 1,400 264,263 265,663 145,000 1994 $ 145,000 261,900 $ 145,256 261,644 1995 160,000 251,775 145,256 266,519 1996 165,000 240,975 145,256 260,719 1997 180,000 229,500 145,256 ~ 264,244 1998 190,000 217,181 145,256 261,925 1999 205,000 204,187 145,256 263,931 2000 215,000 190,181 145,256 259,925 2001 235,000 175,331 145,256 265,075 2002 250,000 159,300 145,256 264,044 2003 265,000 142,088 145,256 261,831 2004 128,587 145,256 (16,669) 2005 ~ 128,588 145,256 (16,669) 2006 128,587 145,256 (16,669) 2007 1,905,000 64,294 1,977,628 (8,334) $557,100 $3,915,000 $6,530,456 $3,865,959 $6,636,597 $1,905,000 (1) Interest income to be earned on the maturing principal of the Government Obligations will be applied to the purchase of the Government Obligations until October 1, 1993• Payments shown are net of such interest income. Upon the purchase of the required Government Obligations de- scribed above, the interest income on the Government Obligations will be transferred upon re- ceipt thereof to the Sinking Fund. (2) Interest at 6 3/4~. (3) Interest income and maturing principal of Government Obligations based on assumed purchase of U.S. Treasury Bonds bearing interest at 7 5/8q, maturing February 15, 2007. For the purpose of the column showing total net Bond Service Requirement to be paid by Village, it is assumed that such U.S. Treasury Bonds will nature on their stated maturity and that the proceeds will be invested at an equivalent rate until the April 1, 2007 maturity of the 2007 Term Bonds. Based on the foregoing assumptions, the Village estimates that aggregate net debt service pay- ments on the portion of the 1978 Bonds attributable to refunding the Refunded Certificates would be $726,848 less than that of the Refunded Certificates. In the event the U.S. Treasury Bonds are redeemed on February 15, 2002, the first date on which such obligations are subject to redemption, the net debt service requirements after such date may be increased. (4) Includes $500,000 deposited from presently available funds of the Village. 17 ~ ~.-A k ~ _ 4: ~ - 'Y, GEf & JENSON Engineers, Architects, Planners, Inc. 2090 Palm Beach Lakes Blvd. Drawer No. 4600, West Palm Beach, FL 33402 305/683-3301 Telex 513472 G8cJ WPB Mr. Robert Harp Village Manager Village of Tequesta Water Department 357 Tequesta Drive Tequesta, Florida 33458 RE: Annual Water Purchases From Jupiter Dear Bob: July 30, 1984 We have enclosed three schedules <<rhich were designed to forcast the effect of water purchases from Jupiter while the Village's new plant is under construction. These schedules indicate a worst case scenario which assumes 100 percent of • the Village's needs will be purchased during a five month period, We do not consider this to be the case, however, to be conservative, we can plan for it, Schedule 1 was developed from actual data for the period July 9, 1983 weekly through June 30, 1984. This reflects that the total demand was 1,90 MGD average of which you purchased 1.53 MGD average from Jupiter, Schedule 2 assumes that the weekly demands, for your system, will be identical for the coming year as they were last year. If such is the case and you pur- chased 100 percent from Jupiter for the five months from November 1 through March 31, you would need to limit your remaining purchases from April 1 through June 30 to 1.32 MGD. A workable program seeing that you will have a 1.8 MGD plant on line. Schedule 3 assumes a worst case of extremely high constant demands during the five months your plant is off line. In this case, you will need to reduce your purchases to nothing during some of the remaining weeks to keep your annua]. purchase average at 1.5 MGD. However, as the schedule shows, you will be able to do this and provide adequate service to the Village because your new plant will be rated at 1,8 MGD. ~~ `. R?'c~ '- t Mr. Robert Harp July 30, 1984 - Page Two If you have an}• questions, please feel free to call. Very truly yours, GEE & JENSON Engineers, Architects, Planners, Inc. ~~~ ,/ Marco H. Rocca Financial Analyst MHR/jc encls cc: J. McKune B. Reese 84-437 r :~t1L 31 ~98~ ~- 1.~. ,C3, r~ U • V I L L L A TOTAL GALLONS (IN 1000'S) 15,000 16,820 16,740 15.,625 13,865 12,145 12,080 13,275 10,876 12,810 11,095 10,635 10,710 12,350 11,195 10,000 11,420 11,425 11,080 12,360 11,650 11,390 11,820 11,220 11,340 11,310 11,190 11,940 12,280 12,830 12,490 12,310 12,460 13,020 12,120 13,540 14,190 13,590 13,830 14,790 12,290 13,520 16,320 19,661 18,450 19,280 15,660 12,550 17,700 16,840 15,950 13,840 692,877 13,325 G E 0 F AVERAGE DAY MGD -------2.14 2.40 2.39 2.23 1.98 1.73 1.73 1.90 1.55 1.83 .1.58 1.52 1.53 1.76 1.60 1.43 1.63 1.63 1.58 1.77 1.66 1.63 1.69 1.60 1.62 1.62 1.60 1.71 1.75 1.83 1.78 1.76 1.78 1.86 1.73 1.93 2.03 1.94 1.98 2.11 1.76 1.93 2.33 2.81 2.64 2.75 2.24 1.79 2.53 2.41 2.28 1.98 1.90 SCHEDULE 1 T E Q U E S JUPITER PURCHASE (IN 1000'S) ------9,920 10,290 10,330 9,325 8,910 8,150 9,590 9,450 10,511 9,860 8,200 .7,910 8,390 8,z7o 9,470 9,050 10,100 10,370 10,330 10,640 9,020 10,320 11,820 11,220 11,340 11,310 11,190 11,940 12,280 12, 830 12,490 12,310 12,460 13,020 12,120 11,070 10,320 9,580 10,950 10,980 8,970 9,800 13,010 16,010 15,070 15,780 11,860 7,660 12,640 9,910 9,410 7,680 555,436 10,681 12,245 1.75 11,315 T A W A T E AVERAGE DAY MGD 1.42 1.47 1.48 i.33 1.27 1.16 1.37 1.35 1.50 1.41 1.17 1.13 1.20 1.18 1.35 1.29 1.44 1.48 1.48 1.52 1.29 1.47 1.69 1.60 1.62 1.62 1.60 1.71 1.75 1.83 1.78 1.76 1.78 1.86 1.73 1.58 1.47 1.37 1.56 1.57 1.28 1.40 1.86 2.29 2.15 2.25 1.69 1.09 1.81 1.42 1.34 1.10 R S OVER (UNDER) 1.5 MGD Y S T E M RAIN FALL IN. / WEEK ------0.08- 0.03 0.02 0.17 0.23 0.34 0.13 0.15 0,00 0.09 0.33 0.37 0.30 0.32 0.15 0.21 0.06 0.02 0.02 0.02 0.21 0.03 0.19 0.10 0.12 0.12 0.10 0.21 0.25 0.33 0.28 0.26 0.28 _ 0.36 0.23 0.08 ~0.03~ 0.13 0.06 0.07 0.22 0.10 0.36 0.79 0.65 0.75 0.19 (0.41) 0.31 ~0.08~ 0.16 0.40 1.53 0.03 1.b2 0.12 0.50 0.00 0.50 0.69 0,65 2.69 0.50 2.90 2.78 0.00 1.45 4.40 3.72 1.00 2.41 5.31 2.80 1.27 0.16 0.50 1.12 0.02 0.40 1,49 1.27 1.20 1.70 0.40 0.15 0.60 0.87 0.00 0.74 0.50 0.69 0.22 2.55 4.03 6.80 0.50 1.67 0.54 0.50 -0.00 0.12 0.15 1.70 8.77 0.00 0.60 1.05 3.25 1.50 COST AT $0.60 $6;174.00 6,198.00 5,595.00 5,346.00 4,890.00 5,754.00 5,670.00 6,306.60 5,916.00 4,920.00 4,746.00 5,034.00 4,962.00 5,682.00 5,430.00 6,060.00 6,222.00 6,198.00 6,384.00 5,412.00 6,192.00 7,092.00 6,732.00 6,804.00 6,786.00 6,714.00 7,164.00 7,368.00 7,698.00 7,494.00 7,386.00 7,476.00 7,812.00 7,272.00 6,642.00 6,192.00 5,748.00 6,570.00 6,588.00 5,382.00 5,880.00 7,806.00 9,606.00 9,042.00 9,468.00 7,116.00 4,596.00 7,584.00 5,946.00 5,646.00 4,608.00 $333,261.60 $6,408.88 1.21 $149,358.00 -_-WEEK---- Y 9,19842 4 6 8 10 12 14 16 18 Zo 21 22 24 ' 26 28 30 32 34 36 38 40 42 44 46 48 50 51 30,1984 • V ILL L TOTAL GALLONS (IN 1000'8) A G E O F AVERAGE _-DAY-MGD-^ 15,000 16,820 16,740 15,625 13,865 12,145 12,080 13,275 10,876 12,810 11,095 10,635 10,710 12,350 11,195 10,000 11,420 11,425 11,080 12,360 11,650 11,390 11,820 11,220 11,340 11,310 11,190 11,940 12,280 12,830 12,490 12,310 12,460 13,020 12,120 13,540. 14,190 13,590 13,830 14,790 12,290 13,520 16,320 19,661 18,450 19,280 15,660 12,550 17,700 16,840 15,450 13,840 2.14 2.40 2.39 2.23 1.98 1.73 1.73 1.90 1.55 1.83 1.58 1.52 1.53 1.76 1.60 1.43 1.63 1.63 1.58 1.77 1.66 1.63 1.69 1.60 1.62 1.62 1.60 1.71 1.75 1.83 1.78 1.76 1.78 1.86 1.73 1.93 2.03 1.94 1.98 2.11 1.76 1.93 2.33 2.81 2.64 2.75 2.24 1.79 2.53 2.41 2.28 1.98 SCHEDULE 2 • T E Q U E S JUPITER PURCHASE (IN 1000'S) 9,920 10,290 10,330 9,325 8;150 9,590 9,450 10,511 9,860 8,200 7,910 8,390 8,270 9,470 9,050 10,100 11,425 11,080 12,360 11,650 11,390 11,820 11,220 11,340 11,310 11,190 11,940 12,280 12,830 12,490 12,310 12,460 13,020 12,120 13,540 14,190 13,590 13,830 9,261 9,261 9,261 9,261 9,261 9,261 9,261 9,261 9,261 9,261 9,261 9,261 9,261 TOTAL 692,877 547,500 VER GE 13,325 1.90 10,529 T A W A T AVERAGE --DAY-MGD-_ 1.42 1.47 1.48 1.33 1.27 1.16 1.37 1.35 1.50 1.41 1.17 1.13 1.20 1.18 1.35 1.29 1.44 1.63 1.58 1.77 1.66 1.63 1.69 1.60 1.62 1.62 1.60 1.71 1.75 1.83 1.78 1.76 1.78 1.86 1.73 1.93 2.03 1.94 1.98 1.32 1.32 1.32 1.32 1.32 1.32 1.32 1.32 1.32 1.32 1.32 1.32 1.32 1.50 R S Y OVER (UNDER) 1.5 MGD S T E M RAIN FALL IN_-/-WEEK-- ------x.08 0.03 0.02 0.17 0.23 0.34 0.13 0.15 0.00 0.09 0.33 0.37 0.30 0.32 0.15 0.21 0.06 0.13 0.08 0.27 0.16 0.13 0.19 0.10 0.12 0,12 0.10 0.21 0.25 0.33 0.28 0.26 0.28 0.36 0.23 0.43 0.53 0.44 0.48 0.18 0.18 0.18 O.I8 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.00 0.50 0.00 0.50 0.69 0.65 2.69 0.50 2.90 2.78 0.00 1.45 4.40 3.72 1.00 2.41 5.31 2.80 1.27 0.16 0.50 1.12 0.02 0.40 1.49 1.27 1.20 1.70 0.40 0.15 0.60 0.87 0.00 0.74 0.50 0.69 0.22 2.55 4.03 6.80 0.50 1.67 0.54 0.50 0.00 0.12 0.15 1.70 8.77 0.00 0.60 1.05 3.25 7/84-9/$84 @ 9/84-7/$5~@0 $0.81 $6;174.00 6,198.00 5,595.00 5,346.00 4,890.00 5,754.00 5,670.00 6,306.60 7,986.60 6,642.00 6,407.10 6,795.90 6,698.70 7,670.70 7,330.50 8,181.00 9,254.25 8,974.80 10,011.60 9,436.50 9,225.90 9,574.20 9,088.20 9,185.40 9,161.10 9,063.90 9,671.40 9,946.80 10,392.30 10,116.90 9,971.10 10,092.60 10,546.20 9,817.20 10,967.40 11,493.90 11,007.90 11,202.30 7,501.16 7,501.16 7,501.16 7,501.16 7,501.16 7,501.16 7,501.16 7,501.16 7,501.16 7,501.16 7,501.16 7,501.16 7,501.16 _____~.,_____ $425,315.04 1.50 $8,179.14 7/84-9/84 @ 0.60 9/84-7/ 5 @ $0.94 $6;174.00 6,198.00 5,595.00 5,346.00 4,890.00 5,754.00 5,670.00 6,306.60 9,268.40 7,708.00 7,435.40 7,886.60 7,773.80 8,901.80 8,507.00 9,494.00 10,739.50 10,415.20 11,618.40 10,951.00 10,706.60 11,110.80 10,546.80 10,659.60 10,631.40 10,518.60 11,223.60 11,543.20 12,060.20 11,740.60 11,571.40 .11,712.40 12,238.80 11,392.80 12,727.60 13,338.60 12,774.60 13,000.20 8,705.05 8,705.05 8,705.05 8,705.05 8,705.05 8,705.05 8,705.05 8,705.05 8,705.05 8,705.05 8,705.05 8,705.05 8,705.05 $485,248.16 9,331.70 INCREASE $0.00 ' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,281.80 1,066.00 1,028.30 1,090.70 1,075.10 1,231.10 1,176.50 1,313.00 1,485.25 1,440.40 1,606.80 1,514.50 1,480.70 1,536.60 1,458.60 1,474.20 1,470.30 1,454.70 1,552.20 1,596.40 1,667.90 1,623.70 1,600.30 1,619.80 1,692.60 1,575.60 1,760.20 1,844.70 1,766.70 1,797.90 1,203.89 1,203.84 1,203.89 1,203.89 1,203.89 1,203.89 1,203.89 1,203.89 1,203.89 1,203.89 1,203.89 1,203.89 1,203.89 $59,933.12 1,152.56 SCHEDULE 3 • • VI LLLAG E OF TEQ UES TA. WAT ER SYS TEM 7/84-9/84@ 7/84-9/84@ TOTAL JUPITER OVER X50.60 $0.60 GALLONS AVERAGE PURCHASE AVERAGE (UNDER) RAIN FALL 9/84-7/85 @ 9/84-7/85 @ WEEK (IN I000'S) DAY MGD (IN 1000'S) DAY MGD 1.5 MGD IN. / WEEK $0.81 $0.94 INCREASE JULY 9,1984 15,000 2.14 9,920 1.42 0.08 0.50 $5,952.00 $5,952.00 $0.00 2 16,820 2.40 10,290 1.47 0.03 0.00 6,174.00 6,174.00 0.00 3 16,740 2.39 10,330 1.48 0.02 0.50 6,198.00 6,198.00 0.00 4 15,625 2.23 9,325 1.33 0.17 0.69 5,595.00 5,595.00 0.00 5 13,865 1.98 ~ 8,910 1.27 0.23 0.65 5,346.00 5,346.00 0.00 6 12,145 1.73 8,150 1.16 0.34 2.69 4,890.00 4,890.00 0.00 7 12,080 1.73 9,590 1.37 0.13 0.50 5,754.00 5,754.00 0.00 8 13,275 1.90 9,450 1.35 0.15 2.90 5,670.00 5,670.00 0.00 9 10,876 1.55 10,511 1.50 0.00 2.78 6,306.60 6,306.60 0.00 10 12,810 1.83 9,860 1.41 0.09 0.00 7,986.60 9,268.40 1,281.80 11 11,095 1.58 8,200 1.17 0.33 1.45 6,642.00 7,708.00 1,066.00 12 10,635 1.52 7,910 1.13 0.37 4.40 6,407.10 7,435.40 1,028.30 13 10,710 1.53 8,390 1.20 0.30 3.72 6,795.90 7,886.60 1,090.70 I4 12,350 1.76 8,270 1.18 0.32 1.00 6,698.70 7,773.80 1,075.10 15 11,.195 1.60 9,470 1.35 0.15 2.41 7,670.70 8,901.80 1,231.10 16 10,000 1.43 9,050 1.29 0.21 5.31 7,330.50 8,507.00 1,176.50 17 11,420 1.63 10,100 1.44 0.06 2.80 8,181.00 9,494.00 1,313.00 18 15,739 2.25 15,744 2.25 0.75 1.27 12,752.46 14,799.15 1,485.25 19 15,739 2.25 15,744 2.25 0.75 0.16 12,752.46 14,799.15 1,440.40 20 15,739 2.25 15,744 2.25 0.75 0.50 12,752.46 14,799.15 1,606.80 21 15,739 2.25 15,744 2.25 0.75 1.12 12,752.46 14,799.15 1,514.50 22 15,739 2.25 15,744 2.25 0.75 0.02 12,752.46 14,799.15 1,480.70 23 15,739 2.25 15,744 2.25 0.75 0.40 12,752.46 14,799.15 1,53b.60 24 15,739 2.25 15,744 2.25 0.75 1.49 12,752.46 14,799.15 1,458.60 25 15,739 2.25 15,744 2.25 0.75 1.27 12,752.46 14,799.15 1,474.20 • 26 15,739 2.25 15,744 2.25 0.75 1.20 12,752.46 14,799.15 1,470.30 27 15,739 2.25 15,744 2.25 0.75 1.70 12,752.46 14,799.15 1,454.70 28 15,739 2.25 15,744 2.25 0.75 0.40 12,752.46 14,799.15 1,552.20 29 15,739 2.25 15,744 2.25 0.75 0.15 12,752.46 14,799.15 1,596.40 30 15,739 2.25 15,744 2.25 0.75 0.60 12,752.46 14,799.15 1,667.90 31 15,739 2.25 15,744 2.25 0.75 0.87 12,752.46 14,799.15 1,623.70 32 15,739 2.25 15,744 2.25 0.75 0.00 12,752.46 14,799.15 1,600.30 33 34 15,739 1 2.25 15,744 2.25 0.75 0.74 12,752.46 14,799.15 1,619.80 5,739 2.25 15,744 2.25 0.75 0.50 12,752.46 14,799.15 1,692.60 35 15,739 2.25 15,744 2.25 - 0.75 0.69 12,752.46 14,799.15 1,575.60 36 15,739 2.25 15,744 2.25 0.75 0.22 12,752.46 14,799.15 1,760.20 37 38 15,739 1 2.25 15,744 2.25 0.75 2.55 12,752.46 14,799.15 1,844.70 5,739 2.25 15,744 2.25 0.75 4.03 12,752.46 14,799.15 1,766.70 39 15,739 2.25 15,744 2.25 0.75 6.80 12,752.46 14,799.15 1,797.90 40 14,790 2.11 2,190 0.31 1.19 0.50 1,773.90 2,058.60 1,203.89 41 12 290 1.76 0 0.00 1.50 1.67 0.00 0.00 1,203.89 42 13;520 1.93 920 0.13 1.37 0.54 745.20 864.80 1,203.89 43 1b,320 2.33 3,720 0.53 0.97 0.50 3,013.20 3,496.80 1,203.89 44 45 19,661 18,450 2.81 2.64 7,061 5,850 1.01 0.84 0.49 0.66 0.00 0.12 5,719.41 4,738.50 6,637.34 5 499.00 1,203.89 1 203.89 46 47 19,280 15,660 2.75 2.24 6,680 3,060 0.95 0.44 0.55 1.06 0.15 1.70 5,410.80 2,478.60 , 6,279.20 2,876.40 , 1,203.89 1 203.89 48 49 12,550 17,700 1.79 2.53 0 5,100 0.00 0.73 1.50 0.77 8.77 0.00 0.00 4,131.00 0.00 4,794.00 , 1,203.89 1 203.89 50 16,840 2.41 4,240 0.61 0.89 0.60 . 3,434.40 3,985.60 , 1,203.89 51 JUN 30,1985 ----------- ---- 15,950 13,840 ------- -- 2.28 1.98 --------- 3,350 1,240 ----------- 0.48 0.18 ----------- 1.02 -----1.32 - - 1.05 3.25 2,713.50 1,004.40 3,149.00 1,165.60 1,203.89 1,203.89 TOTAL 769,750 547,500 --- - ----------- ----------- $425,315.17 ----------- $485,248.31 ----------- $59,933.12 AVERAGE 14,803 2.11 10,529 1.50 0.00 1.50 $8,179.14 $9,331.70 $1,152.56 • MEMORANDUM FROM: Village Manager T0: Councilmembers, Village Clerk, Finance Director, John F. McKune,P.E., Mike D. Rocca SUBJECT: 1984/1985 WATER DEPARTMENT BUDGET DATE: August 16, 1984 Enclosed are pages WDE-l, WDE--2, WDE-3, WDR--1 and WDO&M--1, Revised August 16, 1984 to reflect changes i.n the refe_reuced budget dis- cussed at the August 14, 1984 Budget Worksl,r,p Meeting. The revisions include an increased rate of $1.05/1,000 gallons for water sales, increased cost to purchase water from Jupiter of $0.85/1,000 gallons and increase in employee health insurance costs of • 48%. You will note, we anticipate the transfer of $220,605 into the Special Purpose Fund - Retained Earnings Account and the Debt Service coverage is 1,..915098.. ROBERT HARP RH:mk Encls. • • VILLAGE OF TEQUESTA WATER DEPARTMENT BUDGET 1984/1985 PROPOSED BUDGET REVENUES ]_984/85 OPERATING REVENUES Water Sales $1,228,850 Connection Charges 11,000 Fire Hydrant. Rental Fees ]_1,400 Computer Service Fees 4,000 Other Income 900 TOTAL $1,'156,150 INVESTMENT EARNINGS Interest 115,000 • Total Revenues $1,371,150 DISTRIBUTION OF REVENUES REVENUES $1,346,150 DISTRIBUTION Operation & Maintenance Fund $ 859,230 Sinking Fund 264,315 Renewal & Replacement Fund - Bond Amortization Fund 2,000 Special Purpose Fund - Retained Earnings Account ~ 220,605 TOTAL DISTRIBUTION $1,346.150 NOTE: Revised to include $0.25/1,000 gallons increase by Jupiter and Villages' increased rate of $1.05/1,000 gallons. Revised to include increased Health Insurance Rate. • REV. 8-16-84 RH:mk WDR-1 VILLAGE OF TEQUESTA • WATER DEPARTMENT BUDGET 1984/1985 OPERATION & MAINTENANCE FUND REVENUES Estimated Cash on Hand - October 1, 1984 $ 2,000 Transferred from Revenue Fund 859,230 TOTAL $ 861,230 ' EXPENDITURES Pumping and Storage Expense 586,017 Distribution Expense 106,979 Office and Administrative Expense 168,234 TOTAL $ 861,230 DEBT SERVICE ~ Total Revenues $1,371,150 Less: Operating Expense 861,230 $ 509,920 $509,920 = 1.915098 $266,263 NOTE: Revised to include $0.25/1,000 gallons increase by Jupiter and Villages' increased rate of $1.05/1,000 gallons and increased Health. Insurance Rate. • REV. 8-16-84 RH:mk WDO&M-1 VILLAGE OF TEQUESTA WATER DEPARTMENT OPERATION & MAINTENANCE FUND BUDGET 1984/1985 EXPENDITURES PUMPING & STORAGE EXPENSE PERSONAL SERVICES Salaries & Wages FICA Taxes Retirement Contributions Life and Health Insurance Workers' Compensation TOTAL U OPERATING EXPENSES Communication Service Utility Services Insurance Miscellaneous Office Supplies Professional Services Water Monitoring THM Sampling Other Sampling Repair & Maintenance Service Car, Truck, Tractor Machinery and Equipment Building and Others Operating Supplies Gasoline & Oil - Car, Truck, Tractor Purchased Water Chemicals Laboratory Supplies Small Tools and Equipment Diesel Fuel TOTAL DEPARTMENT TOTAL REV. 8-16-84 6aD E-1 Proposed Budget 1984/1985 $ 26,062 1,834 3,190 3,659 571 $ 35,316 $ 1,700 46,000 ~ 1,800 501 100 $ 12,000 2,000 1,500 1,100 5,000 500 1,400 474,000 2,000 300 500 300 $ 550,701 $ 586,017 VILLAGE OF TEQUESTA WATER DEPARTMENT BUDGET 1984/1985 PROPOSED BUDGET 1984/85 i• DISTRIBUTION EXPENSES PERSONAL SERVICES Salaries & Wages Overtime FICA Taxes Retirement Contributions Life & Health Insurance Workers' Compensation OPERATING EXPENSES Insurance Miscellaneous Office Supplies Repair & Maintenance TOTAL Car, Truck & Tractor Machinery and Equipment Gasoline and Oil - Car, Truck, Tractor TOTAL DEPARTMENT TOTAL REV. 8-16-84 RH:mk WDE-2 $ 66,877 x,100 5,065 8,186 12,229 1,577 $ 99,034 $ 1,200 ' 195 50 $ 1,100 4,000 1,400 $ 7,945 $ 106,979 VILLAGE OF TEQUESTA WATER DEPARTMENT BUDGET • 1984/1985 OFFICE & ADMINISTRATIVE EXPENSE PERSONAL SERVICES Salaries & Wages FICA Taxes Retirement Contributions Life & Health Insurance Workers' Compensation Unemployment Comp. Insurance Employee Recognition Program TOTAL OPERATING EXPENSES Accounting & Auditing Travel & Per Diem. Communication Service Transportation - Postage Utility Services Insurance Miscellaneous Office Supplies Books, Publications, Dues Legal Service Engineering Service Rentals and Leases FEC Leases Other - P. 0. Box Office Equipment Repairs & Maintenance Service Office Machines General Maintenance Personnel Training Licenses and Fees Administrative Management Lot 15, Tequesta Pines Expense TOTAL DEPARTMENT TOTAL TOTAL OPERATING EXPENSES PROPOSED BUDGET 7 A A/ / A C $ 32,219 2,267 3,944 5,075 54 500 400 $ 44,459 $ 13,500 300 2,200 5,900 4,000 3,500 95 7,500 300 2,000 15,000 I10 50 1,300 5,600 150 300 1,600 60,000 370 $123,775 $168,234 $861,230 WDE-3 REV. 8-16-84