The URL can be used to link to this page

Home My WebLink About6/28/99 . Water Board Agenda Regular Meeting June 28, 1999 7:00 PM 1. Call to Order 2. Approve Agenda 3. Approve Minutes -special, regular, May 24, 1999 4. Continued Discussion Items a) Water Reservoir Update b) Well No.5, Pumphouse No.5 Update c) Policy Manual Update d) Water Use Restrictions 5. New Business . a) Generator Project Change Order b) Solid Waste Division Request - Cardboard Recycle Container c) Water Board Future Facility Signage 6. Approve Bills 7. Financial Report 8. Open Forum 9. Adjourn . I ~ . . . ~a.... City of Farmington 325 Oak Street, Farmington, MN 55024 (651) 463-7111 Fax (651) 463-2591 www.ci.farmington.mn.us TO: Water Board FROM: Lee M. Mann, P.E., Director of Public Works/City Engineer SUBJECT: Generator Project Change Order DATE: June 24, 1999 INTRODUCTIONIDISCUSSION Attached is a change order for work necessary for the Pumphouse Generator Project. At Well #3, upon commencement of the work, it was discovered that the wiring of the pump house needed to be modified due to incorrect installation at the time of original construction. At Well# 4, an existing circuit breaker needed to be replaced. BUDGET IMPACT The amount of the change order is $1,830.00, revising the Water Board's portion of the original contract amount of $69,650 to $71,480. The originally budgeted amount for this project was $128,000. ACTION REQUESTED Approve Change Order No. I for the Pumphouse Generator Project. Respectfully Submitted, ~m~ Lee M. Mann, P .E. Director of Public Works/City Engineer cc: file " . t a Bonestroo ___ Rosene --- AnderIik & 1J1 Associates Engineers & Archiletts Owner: City of Farmington, 325 Oak St., Farmington, MN 55024 I Datel June II, 1999 Contractor: Electrical Installation & Maintenance, 4985 Broadmoor Dr., Maple Plain, MN 55359 Bond Co. United Fire & Casualty, 118 2nd Ave SE, Cedar Rapids, IA 52407 I . CHANGE ORDER NO. 1 EMERGENCY GENERA TORS BRA File No. 14198806 Description of Work Item I Extra work Well No.3 - Rewire 3 phase 480 v circuit to 30 kva lighting & power Transformer (circuit was improperly connected to the line side of 200 amp service switch) Total Item No.1 $355.00 Item 2 Extra work Well No.4 - replace 225 amp circuit breaker with new 200 amp 480v molded case circuit breaker Total Item No.2 $1,475.00 TOTAL CHANGE ORDER NO.1 $1,830.00 . Original Contract Amount Previous Change Orders This Change Order Revised Contract Amount (including this change order) $145,760.01 $0.00 $1,830.00 $147,590.01 Recommended for Approval by: BONESTROO, ROSENE, ANDERLIK & ~R\ date: Approved by Contractor: ELECTRICAL INST ALLA TION & MAINTENANCE Approved by Owner: CITY OF FARMINGTIN ~-~.:.../ cc: Owner Contractor Bonding Company Bonestroo & Assoc. . CHANGEORI . . . 5"'b City of Farmington 325 Oak Street, Farmington, MN 55024 (651) 463-7111 Fax (651) 463-2591 www.ci.farmington.mn.us TO: Water Board FROM: Lee M. Mann, P.E., Director of Public Works/City Engineer SUBJECT: Solid Waste Division Request - Cardboard Recycle Container DATE: June 28, 1999 INTRODUCTIONIDISCUSSION The Solid Waste division is requesting permission to locate a cardboard recycle container at Well #4. The City has several recycling containers located throughout the City for residents to use. The City needs to add an additional cardboard recycling site. There is currently a container at Budget Mart that has become inadequate to meet the recycling needs of the northern end of the City. The location of Well #4 is ideal for the placement of a recycling container. The container would be 12-feet long, 8-feet wide and 6-feet tall, the same as the container at Budget mart. The City's Solid Waste division empties and maintains the recycling containers. BUDGET IMPACT None. ACTION REQUESTED Approve solid Waste Division request to locate a cardboard recycle container at Well #4. Respectfully Submitted, ~m~ Lee M. Mann, P .E. Director of Public Works/City Engineer cc: file . CITY OF FARMINGTON REVENUES AND EXPENDITURES ANALYSIS WATER FUND 5/31/99 1999 BUDGET 1999 ACTUAL OPERATING REVENUES USER FEES 780,000 111,544 WATER PERMITS 6,105 METER SALES 26,745 CUSTOM SERVICE TOTAL OPERATING REVENUE 780,000 144,394 NON OPERATING REVENUES WATER AVAILABILITY CHARGES 67,770 WATER MAIN TRUNK FEES SPECIAL ASSESSMENTS 26,022 INTEREST 25,000 14,297 MISCELLANEOUS 881 ANTENNA LEASE 11,500 5,513 TOTAL NON OPERATING REVENUE 36,500 114,483 TOTAL ALL REVENUE 816,500 258,877 . EXPENDITURES SALARIES 52,542 18,906 OVERTIME 4,500 542 BENEFITS 8,854 2,404 PRINTING & PUBLISHING 2,652 762 PROFESSIONAL SERVICES 66,580 16,358 DUES & SUBSCRIPTIONS 515 128 SCHOOLS & CONFERENCES 1,018 TRANSPORTATION COSTS 1 ,442 361 EQUIPMENT MAl NT/RENT 21,946 BUILDING MAl NT/RENT 10,609 UTILITIES 41,754 15,487 SUPPLIES/METERS 62,951 103,442 MISCELLANEOUS CAPITAL OUTLAY 80,282 15,093 TOTAL EXPENDITURES 355,645 173,483 OTHER FINANCING USES DEBT SERVICE 101,145 DEPRECIATION TRANSFER FOR ADMINISTRATIVE FEES 26,250 10,938 TRANSFER TO CONSTRUCTION FUND 250,000 TOTAL OTHER FINANCING USES 377,395 10,938 TOTAL EXPENDITURES & OTHER . FINANCING USES 733,040 184,421 INCREASE (DECREASE) TO RETAINED EARNINGS 83,460 74,456 . . . City of Farmington 325 Oak Street, Farmington, MN 55024 (651) 463-7111 Fax (651) 463-2591 www.ci.farmington.mn.us TO: Water Board Members FROM: Robin Roland, Finance Director SUBJECT: December 31, 1998 Financial Report DATE: June 28, 1999 INTRODUCTION/DISCUSSION Attached is a copy of the final audited financial report for the City of Farmington Water Utility as it appears in the City's Comprehensive Annual Financial Report. Also attached is the more detailed report that the Water Board usually sees on a monthly basis, with a three year comparison. These reports do not include the construction of the Water Reservoir or Well #5; only the actual revenues and expenditures of operations. A copy of the appropriate page from the Auditor's Management Report is attached. Although the Water Board had authorized a transfer from operations to the Water Construction Fund of $250,000 in 1998, that transfer did not occur in the 1998 operations due to the timing of the authorization. The 1998 transfer will be done in 1999. ACTION REQUESTED For information only. Please contact me with any questions you may have. Respectfully submitted, ftRJ Robin Roland Finance Director ,. . CITY OF FARMINGTON, MINNESOTA STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS WATER UTILITY For Years Ended December 31, 1998 and 1997 1998 1997 Operating revenues: Charges for services $ 741,569 $ 616,012 Other 36,136 24,079 Total operating revenues 777 ,705 640,091 Operating expenses: Personal services 54,833 51,970 Supplies 60,433 59,046 Other services and charges 178,434 78,675 Depreciation 106,481 106,481 Total operating expenses 400,181 296,172 Operating income (loss) 377,524 343,919 Non-operating revenues (expenses) Special assessments 99,192 148,507 Investment income 157,526 95,439 . Intergovernmental Donations Miscellaneous revenues 10,753 12,662 Bond interest (38,520) Miscellaneous expenses (632) Total non-operating revenues (expenses) 266,839 218,088 Income before operating transfers 644,363 562,007 Operating transfers in (out): General fund (21,500) (20,003) Special revenue fund Debt service fund Capital project funds (278,288) Total operating transfers in (out) (21,500) (298,291) Net income 622,863 263,716 Credit arising from transfer of depreciation to contributed capital 72,673 72,675 Net increase in retained earnings 695,536 336,391 Retained earnings, January 1 2,515,815 2,179,424 . Retained earnings, December 31 3,211,351 2,515,815 f" CITY OF FARMINGTON REVENUES AND EXPENDITURES ANALYSIS WATER FUND . 12/31/98 1998 1997 1996 RETAINED EARNINGS BEGINNING $ 2,515,815 $ 2,179,424 $ 1,655,197 OPERATING REVENUES USER FEES 538,997 447,246 434,002 WATER PERMITS 17,928 12,596 17,635 METER SALES 36,136 24,079 32,161 CUSTOM SERVICE 437 2,209 2,556 TOTAL OPERATING REVENUE 593,498 486,130 486,354 NON OPERATING REVENUES WATER AVAILABILITY CHARGES 184,460 143,360 197,784 WATER MAIN TRUNK FEES 10,601 27,675 SPECIAL ASSESSMENTS 99,192 148,507 15,944 INTEREST 157,526 99,365 14,013 ANTENNA LEASE 10,500 8,736 TOTAL NON OPERATING REVENUE 451,678 410,569 255,416 TOTAL ALL REVENUE 1,045,176 896,699 741,770 EXPENDITURES . SALARIES 46,225 45,256 41,555 OVERTIME 3,042 1,225 412 BENEFITS 5,566 5,488 10,828 PRINTING & PUBLISHING 2,690 2,858 118 PROFESSIONAL SERVICES 62,942 28,101 30,772 DUES & SUBSCRIPTIONS 3,242 123 1,179 SCHOOLS & CONFERENCES 175 585 768 TRANSPORTATION COSTS 1,043 925 EQUIPMENT MAl NT/RENT 10,540 3,927 7,399 UTILITIES 48,411 36,592 33,679 MISCELLANEOUS 49,637 SUPPLIES 24,688 38,373 17,022 MERCHANDISE FOR RESALE 35,529 26,237 24,806 TOTAL EXPENDITURES 293,730 189,690 168,538 OTHER FINANCING USES DEBT SERVICE 603 38,520 DEPRECIATION 33,807 33,807 28,155 TRANSFER FOR ADMINISTRATIVE FEES 21,500 20,003 20,850 TRANSFER TO CONSTRUCTION FUND 278,288 TOTAL OTHER FINANCING USES 55,910 370,618 49,005 TOTAL EXPENDITURES & OTHER FINANCING USES 349,640 560,308 217,543 INCREASE (DECREASE) TO RETAINED EARNINGS 695,536 336,391 524,227 . RETAINED EARNINGS, END OF YEAR $ 3,211,351 $ 2,515,815 $ 2,179,424 r I ,. I I I I I I I. I I I I I I I ,. I FINANCIAL ANALYSIS (Continued) Liquor Gross Profit Percentage 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% 1994 2U'J(, 1997 1998 1995 1998 . GreIM PllllIl P-noe Water Fund: Operating revenues for the Water Fund increased 21.5% from $640,091 in 1997 to $777,705 in 1998. Operating expenses showed a 35.1% increase from $296,172 in 1997 to $400,181 in 1998. The Water Fund experienced operating income of $377,524 for 1998 and after non-operating revenues/expenses and operating transfers out, the fund's net income amounted to $622,863. The following chart indicates the Water Fund results over the past five years: Water Fund $800,000 $700.000 $800.000 ssoo.ooo $400,000 $300.000 $200.000 $100.000 $0 1994 1995 1996 1997 1998 . Water Cllarg.. .Tolal aper.ting Expenees . OperatIng Income 5 . . . City of Farmington 325 Oak Street, Farmington, MN 55024 (651) 463~7111 Fax (651) 463-2591 www.ci.farmington.mn.us TO: Water Board Members FROM: Robin Roland, Finance Director SUBJECT: Customer Refund - Kenneth Brown DATE: June 28, 1999 INTRODUCTION/DISCUSSION Kenneth Brown of 18209 Emerald Trail has requested a refund of overpayment of water usage fees for the period April 1996 through March 1999. Sometime between the April 1996 and July 1996 water meter readings, the remote water meter reading device on Mr. Brown's house malfunctioned. Although staff verified the external meter reading at the time and billed a significant increase, Mr. Brown did not contact Arvilla about his increased usage until after the April 1, 1999 billing. At that time, Mr. Brown compared the outside reading device to the reading on his water meter and found them to be significantly different. City Staff investigated and found that the water meter located inside the house (which we always consider to be the accurate reading) was reading 334,000 while the external reader read 1,972,000. Staff replaced the customer's meter with a radio read meter on May 17, 1999. Mr. Brown has requested a refund of the overpayment of water usage fees. Arvilla has determined that the customer was over billed by 1,628 thousand gallons and is due a refund of $1,877.52. Her computations are attached. The City has already refunded his overpayment of sewer fees. ACTION REQUESTED Authorize refund of $1,877.52 of water usage fees to Kenneth Brown of 18209 Emerald Trail. ;Z;;;;' Robin Roland Finance Director . . . CCOUNT METER READING HISTORYCI) Account Number: 154151820900401 Phone: <-) Name : BROWN KENNETH - Site Address : 18209 1/_ EMERALD TRAIL Acct Status: AC FARMINGTON MN 55024-9267 Acct Type : RE Route/Seq : 7/1630 ACH : H Meter Number : 7845352 Pri/Sec Func: HA/AD 2ndary ID : 5695610 Meter Size : 5/8" Unit of Meas: THGL Avg Consump: 117 . 38 Date Removed : Service : klA- Periods : 16 Date Read Reading Billed Rdg Consumption Billed Adj Read Flag Type Date Diff by 03/05/1997 749 - A- 132 04/01/1997 0 HAND 12/16/1996 617 - A- 134 01/01/1997 0 twill 09/24/1996 483 - A- 158 09/30/1996 0 HAND 07/18/1996 325 - A- 150 07/01/1996 0 HAND 04/25/1996 175 - A- 21 04/01/1996 0 HAND 01/24/1996 154 - A- 25 01/01/1996 0 HAND 09/14/1995 129 - A- 19 10/01/1995 0 CONV 06/16/1995 110 - A- 16 07/01/1995 0 CONV METER INFOCODE EXISTS Press a function key Modifying . . ~/lI() r-e Ifefl cI EI<.. !;~!'-h~ ;tc 11,J .;.. ;I Nt II f<.( 4 1c- 04.J ,.4- P piJ ILl':''''' II.. Y g //<1 aI& J ,/JIll/.. C't(IJC Tt,[)A.J J,V 7 be:7WE€.-J ?//<fhG ~,e,4.t. . - -" -"d ,,1/1 w,Q...J t/S"#I fle-d, &o/(f:c{ /fT 7'-/{l4r11rJ1€ -i- .me rEA:,-.: I /J1t2-.da()w~ ""b.d .-v~>f t?A/( -4&0"" ;/, ~;lwar<'"1C- ClIA"tE, &.,;/,,/1 C"'tlv;;.vaFcl~ U>> 7"', L ,q.{re~ -r-ffC f't/ftf bill. HE rAid tic -(-/.If)~'iJ/r- TN'; ;e'e/7lur~- /Z~J(lclc/C. W4--l: A)dl tvC>IZ./4.v1 (],/Z,e~cr'/y ~€('4~~~ 7H.? Ifl) W~A.E r;p7//l-~.L7 d. ff €-'tiA.JI. Ou II m[,A.} wi" -u,- tI u r 'f7) C' 1/ E e K ;tE ;1f() r G ~c "'<< €t2- -i- n? t:- r,~ /l.. , /I tE ,<' E;-;tQ r e tCc,dr:!SL w<u MIIl(.(Ll,vCI'<Jrl.II~? 7t1~/7J~-re~ 1/.145 c>HAL-'t:te<-,j'1'I;;> ,4 ~11~/(.> ;fE4d /h/...<:(-c-~ . ,tI.:- /JJI=-r-t:;-,c K€.4d 33~o()a A.T T/rn<~ 0.(' c.1I.4"r~' OU /L (It(s 7l)..-n.....1( w,q..s; O(.JCIC..- 6dlc--c/ tr /(.,36 7'"'1'ku rA.va 9.4//CI~.J. 6eo:;q.{,c oI! -r j-/ tJ~ P ~z () r. L f! 111 . It/f,oOD tjlll/u,vs C joq.. El1cl/ 1197, 000 94/lilf,).{ C- "'/'I b t;;t.d! J63t ~cf/.o () 113(.. .!; :Z. c4i JI 77. :>;) ::::::i- 6cL14t7E t<I /Z?.(u-..d s:40"t..a foe /J1~h<c- J,J -r I-i .4 7 A m()u'Yr . . . CCOUNT METER READING HISTORYlIl Account Number: 154151820900401 Phone: <-> Name : BROWN KENNETH - Site Address : 18209 1/_ EMERALD TRAIL Acct Status: AC FARMINGTON MN 55024-9267 Acct Type : RE Route/Seq : 7/1630 ACH : H Meter Number : 7845352 Pri/Sec Func: MA/AD 2ndary ID : 5695610 Meter Size : 5/8" Unit of Meas: THGL Avg Consump: 117 . 38 Date Removed : Service :~ Periods : 16 Date Read Reading Billed Rdg Consumption Billed Adj Read Flag Type Date Diff by 03/08/1999 1972 - A- 107 04/01/1999 0 tWill 12/11/1998 1865 - A- 163 01/01/1999 0 HAND 09/08/1998 1702 - A- 150 10/01/1998 0 HAND OS/29/1998 1552 - A- 140 07/01/1998 0 HAND 03/03/1998 1412 - A- 138 04/01/1998 0 HAND 12/01/1997 1274 - tJ-. 187 01/01/1998 0 HAND 09/03/1997 1087 - tJ-. 197 10/01/1997 0 HAND 06/03/1997 890 - tJ-. 141 07/01/1997 0 HAND METER INFOCODE EXISTS Press a function key Modifying . . ...~ . Il~ ,;:JI"'J 4,(<~, J) ~.~.'" //..C....-." ~ '" I" Account Number ',";7 .',~ METER SERVICE REQUEST . 0.:1"- ~-,' " , ~~~~: ' ":'->1''; '':'':> '.':; "'" A.ddress: Installation by: ()A II #, /Y> .:~,,:i J';J--r- W ~ #:;.>1 t;..\ ';?!t. 6/~- ~ 3:3_ 7 V 7' y /IIff"~/.' ;t\:rAti f'. r-o f li e111 r),l' ;,';~ "',{ Appointment Date /) , A jl . Time Forwar4ing"'Address CQmrnents-J./!:~' p LA //71.J ~(,~iJ7 r? ,..vo r- .-~-iJ'); ':;l~ ~,; ,~>;F;. '':,<1 . ;'-A -, " . .. . .' . . . .......... .; ..... ..... . '. ....,~t '~/JJfI~ Je, v~ (1" II tZ 1::'-( "'"y..-l./ttiI44.>';,H~ t,,<IK..~-~i':;~ u~tf 4 '- .. /I ~/,) cis. (.)ll^~lJ 7 # ';i~; /II el~""... . RtF ,If, 7':.'....J 1It'c~",,'rtd(f ,~ <.'i,i Da' obe"Serviced Date SeMeed . /JJ w~" CCO' . . )I/I/,l,"&.~~' Meter Rea(:tin' ,,,,r . NEW Name ,-"'i \, J":":~ ';':d~'.,:" .."../v"...). __' - ,c"""'~ !l)'l'" : " -"~;' ' -,' .c"' " .~,!,.",._",.,...t""l;" . '.,', __,', " "f":;':J,' Nt~~.: '- ., -:}" -,', , Date .i~ ", .., -\ Kind Address ~ I Date.Requested Seria{No. Size M~ter Reading I i Deposit Received Water Turned On---.-,.- Yes___ NO-4Bi~ ;,' Tlnspector /vtl.:,U. .'. .. . ..........1 lie- rl./,,/) 1(..1 ::::f~f,rf(.::- /c-'1I(1-c:~r lup J DJte.. J$ ;/i;-'} I r/~/{.f.." !oQ q,' J Y :%Q :::l~JP33;;/7(J sj7,(JJ -~:33~~3.J.. rf€l11,l'e.(;~ol(JQC " / Illill/.",- - ~ ~Cil;l f ~C, 5,h . S/r~ '.. >; .I -::J ..u.J _ it 3.J "J" ::J b /tf'II.,.' - t,";p/,/o(,/ (/ .s-/ /.,;