.." 􀀭􀀢􀀮􀁾􀀠-_ .. lII!I!1Ia 1996 North Dallas County Water Supply f 􀁾􀀠 Sewer Tunnel Agreement Addison & Farmers .-!ii'PIV"'" __ ll...."'"n ..... 'h_ . l. r 􀁾􀀺􀀩􀀠􀀯􀁾􀁾􀁾ENGINEERS CONSOER TOWNSEND ENVIRODYNE ENGINEERS, INC. February 4, 1997 10700 Richmond Avenue North Dallas County Water Supply Corporation Post Office Box 819010 City of Farmers Bram,h, Texas 75381-9010 Suite 275 Attention: Mr. Jerry Murawski" SUbject: North Dallas County Water Supply Corporation Phase 1-Sanitary Interceptor Sewer Houston, Texas 77042 F ina! Report Gentlemen: Phone: (713) 780 7168 Submitted herewith is the Final Report for the subject project: I. PROJECT REVIEW Fax: (713) 780 7193 A. 􀁾􀀠1. Construction The construction of the project is complete including the one year warranty Post video of the inside ofthe sewer for its entire length, Substantial completion was September 21, 1996. The Post videos were submitted for final review on December 10, 1996. 2. Post Video Review A review ofthe Post video tapes is as follows: a. The grade and alignment of the sewer is excellent with no offsets 0r dips. b. The tee-lock liner is also in excellent condition with 􀁾􀀠. joint in the sewer sewer and manholes sealed. There are absolutely no leaks. c. The flow varies in depth from ± 1 inch below the 270 degree tee-lock liner to ± 3 inches above the edge ofthe liner. The flow is smooth and uniform. The video was taken during a dry period with no rain before or during the video taping. Q;n,(cPPY,ofthe.4 video tapes will be sent under separate 􀁾􀀮􀀺􀁩􀂣􀀬􀀠cqyer; " . '. . \; ., .. \-\, . '. , \ \ \, 􀁾􀁾ENGINEERS CONSOER TOWNSEND ENVIRODYNE ENGINEERS. INC 3. Restoration All restoration has been completed. 4. Record 􀁄􀁲􀁡􀁷􀁪􀁮􀁾􀁳􀀠One copy of sealed Mylars and electronic CAD discs of the record drawings were submitted June 10, 1996. 5. Pictures Construction pictures have been bound in two books. These books will also be sent under separate cover. II. FINAL CONSTRUCTION I. Original Bid Price = $ 11,046,890.00 2. 􀁃􀁨􀁡􀁮􀁾􀁥􀀠Orders Net total of3 Change Orders is a deduction of= $ 89,709.72 3. Final Construction Cost = $ 10,642,336.01 The contract is a Unit Price Contract. The final cost is the. net amount of the Change Order reduction and the payment for actual pay items measured in place on a unit price basis. 4. The Final Construction Cost is $404,553.99 under the original Bid Price. III. ODOR CONTROL A. General Shortly after the Phase II sewers from Farmers Branch and Addison were connected into the tunnel, odors associated with hydrogen sulfide gas were detected around the tunnel vent pipe vents. vents. Generally these odors are only detected during warm weather. There is minimal to no odor during the late fall and winter months. B. Corrective Action In order to determine the cause and potential magnitude of the odors several steps have been taken. 1. Air Quality Analvsis: Armstrong Environmental, Inc. has been contracted by CTE to provide air and gas sampling of the six vents associated with the 60 inch tunnel. 2 􀁾􀁭ENGINEERS CONSOER TOWNSEND ENVIRODYNE ENGINEERS, INC. 2. Chemical Analvsis ofSewage: ERMI Environmental Laboratories has been contracted by CTE to provide a chemical analysis of the sewage over a 24 hour period at 4 locations, including one each of sewage being discharged by the Addison and Farmers Branch Phase II sewers immediately up stream of the terminal turmel shaft. The results ofthese air and water samples will be available during February 1997. Several odor control systems, which will treat the hydrogen sulfide in the liquid state rather than treating the generation of hydrogen sulfide gas that is released from solution, will be analyzed. A separate report will be prepared after the laboratory tests have been completed, and a recommended system including operating and chemical costs will be submitted. 3. Interim Solution Installed In order to remove the gaseous odors at the vents Unisorb Corporation has modified the existing vents so that carbon pellets can be placed in the vents, which filter the odor (gas) as it passes through the vent. The carbon pellets have been installed and the odors have been removed. The cost ofthe pellets are $525 for the four vents where odors were detected. The carbon will probably not be required to be removed during the winter. There is no history oflongevity ofthe pellets in the summer but Unisorb estimates ± 3 month changes in the summer. IV. SUMMARY AND CONCLUSION A. Final Payment Based on Final Payment Request No. 26, it is recommended that the Contractor be paid in full in the amount of$181,919.27. B. Final Inspection ofInterceptor Sewer TurmeJ and Open Cut Final acceptance of the sewer is recommended. There are no visible defects along the entire length ofthe sewer. There are a1S0!lQ leaks. The line and grade are straight with no offsets. Consoer Townsend Envirodyne appreciates the trust placed in our firm to provide Engineering Design and Construction Services to successfully complete this project. We wish to thank the engineering staffs of both the City of Farmers Branch and the City of Addison and the North Dallas County Water Supply Corporation Board for their excellent cooperation and assistance. Yours truly, CONSOER TOWNSEND ENVIRODYNE ENGINEERS, INC. Wilbur Van Riper Project Manager 3 REC'D JAN 3 1 1997F.9J FaRmeRS BRanCI-f. january"29; 1997 )0: Charles Cox, Director of Finance FROM: jerome Murawski, jr., City Engineer SUBJECT: NDCWSC Contract Administration The attached detail of tasks reflect City of Farmers Branch Engineering staff time for the NDCWSC Interceptor Sewer. The project manager agreement was executed April 15, 1993 and Engineering staff time is for the months of October, November, and December, 1996. Phase I: Project Engineer 8 hours Engineering Inspector 12 hours Phase II: Project Engineer 7 hours Engineering Inspector 78 hours Please invoice the Cities per agreement including any time for financial administration and public relations and administrative services. JVM:nm attachments cc: Abhn Baumgartner, P.E. V Town of Addison B,\SISTIME.ONDINDCWSC GARY OSHEL PROJECT ENGINEER PHASE I October 24, 1996 • 2 hours Review proposal for odor control with Consoer Townsend & Associates October 28, 1996· 1 hour Process purchasin!:l order for odor control November 7, 1996 • 2 hours Review agreements for air testing and sampling November 21, 1996 • 2 hours Coordinate installation of odor control December 26, 1996 -1 hour Process payment for odor control 8 hours total for Phase I PHASE II November 19, 1996 -2 hours look at replacement trees for restoration December 5, 1996 -2 hours Meeting with Providence Towers re: restoration Nov. 1996 -Dec. 1996 -3 hours Various communications with property managers, contractor re: tree replacement 7 hours total for Phase II Barry Maternowski Engineering Inspector Phase I November 22, 1996 -8 hours Installing odor control @vent stacks December 23, 1996 -4 hours Air sampling conducted Phase II October 1, 1996 -2 hours October 22, 1996 -2 hours Inspection Inspection October 2, 1996 -2 hours October 23, 1996 -2 hours Inspection Inspection October 3, 1996 -2 hours October 24, 1996 -2 hours Inspection Inspection October 4, 1996 -2 hours October 25, 1996 -2 hours Inspection Inspection October 9, 1996 -1 hour October 28, 1996 -2 hours Inspection Inspection October 10, 1996 -1 hour October 29, 1996 -2 hours Inspection Inspection October 11, 1996 -2 hours November 1, 1996 -1 hour Inspection Inspection October 14, 1996 -1 hour November 4, 1996 -1 hour Inspection Inspection October 15, 1996 -3 hours November 5, 1996 -1 hour Inspection Inspection October 17, 1996 -2 hours November 6, 1996 -2 hours Inspection Inspection October 18, 1996 -2 hours November 7, 1996 -3 hours Inspection Inspection October 21, 1996 -1 hour November 11, 1996 -1 hour· Inspection Inspection November 12, 1996 -2 hours Inspection November 13, 1996 -2 hours Inspection November 14, 1996 -2 hours Inspection November 15, 1996 -1 hour Inspection November 20, 1996 -2 hours Inspection December 2, 1996 -2 hours Inspection December 3, 1996 -2 hours Inspection December 5, 1996 -2 hours Inspection December 6, 1996 -2 hours Inspection December 9, 1996 -2 hours Inspection December 10, 1996 -2 hours Inspection December 11, 1996 -1 hour Inspection December 12, 1996 -2 hours Inspection December 13, 1996 -2 hours Inspection December 16, 1996 -2 hours Inspection December 17, 1996 -1 hour Inspection December 18, 1996 -1 hour Inspection December 19, 1996 -1 hour Inspection December 20, 1996 -1 hour Inspection December 23, 1996 -1 hour Inspection December 24, 1996 -1 hour Inspection December 26, 1996 -1 hour Inspection December 27, 1996 -1 hour Inspection 12 hours total for Phase I 78 hours total for Phase II • ASSETS Cash Accounts Receivable· Addison Accounts Receivable· Farmers Branch Total Assets TOTAL LIABILITIES AND FUND BALANCE Accounts Payable Liability to Quebecor • Retainage Payable Fund Balance· Addison Fund Balance· Farmers Branch Total Fund Balance Total Liabilities and Fund Balance * Developer Contribution Outstanding DEC96FIN.WK1 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION BALANCE SHEET ALL FUNDS DECEMBER 31, 1996 􀁏􀁐􀁅􀁩􀁴􀁁􀁴􀁬􀁎􀁾􀀠..FUND> . $0 $0 $0 $0 $0 $0 !O $0 .cAPffAI..J .> < FiJNp ,TotAL $83,797 $83,797 83,782 83,782 64,507 64,507 $232.086 $232.086 $0 2,280 147,973 􀀤􀀱􀀵􀀰􀀬􀀲􀁾􀀠$43,632 38,201 $81,833 $232.086 $0 2,280 147,973 $150,253 $43,632 38,201 $81,833 $232.086 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION STATEMENT OF REVENUES AND EXPENDITURES BUDGET AND ACTUAL FOR THE MONTH ENDING DECEMBER 31, 1996 OPERATING FUND 95·96 96-91 DEbaMsER' AMENDED ADOPTED 1996 .' 􀁙􀁾􀁒􀁔􀀶DAf!:tii=\: iODATE' . BUDGET BUDGET ACTUA( .... ACtUAlA¢tUAL REVENUES: Charges to participant cities $16,500 $11,000 $0 $0 $1,128,725 Interest income and miscellaneous o o o o 664 Transfer from Capital Projects Fund o o o o o TOTAL REVENUES $16,500 $11,000 $0 $0 $1,129,389 EXPENDITURES: Project Administration $4,700 $1,600 $0 $0 $8,922 Supplies 0 0 0 0 244 Legal 3,000 3,000 0 0 44,961 Insurance 1,000 1,000 0 0 8,737 􀁁􀁵􀁤􀁾􀁆􀁥􀁥􀁳􀀠3,200 3,500 0 0 3,200 Bank Fees 4,000 1,200 0 0 3,911 Miscellaneous 600 700 0 .!L 12,709 Total General Overhead 16,500 11,000 0 0 82,684 Transfer to Capital Projects Fund 0 0 0 0 1,046,705 TOTAL EXPENDITURES $16,500 $11,000 $0 $0 $1,129,389 EXCESS OF REVENUES OVER EXPENDITURES $0 $0 $0 $0 ($0) BEGINNING FUND BALANCE $0 $754 ENDING FUND BALANCE ·0 􀀨􀁾􀁏􀁽􀀽􀀽􀀽􀁾􀀽􀀽􀀽􀀽􀀽􀀱􀀡􀀤􀁾􀀰􀀮􀀠===_ 􀀤􀁾􀀠DEC96FIN.wK1 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION STATEMENT OF REVENUES AND EXPENDITURES BUDGET AND ACTUAL FOR THE MONTH ENDING DECEMBER 31, 1996 CAPITAL PROJECTS FUND )(::;:$" .. 􀁩􀁩􀁊􀁾􀁦􀀧... ·􀀧􀁄􀀺􀁾􀀡􀀡􀁾􀀺􀁒􀀠􀁙􀁾􀁾􀁾􀁧􀁗􀁾􀁉􀁾􀀺􀀬􀀧􀁗􀁾􀁉􀀺􀁾􀀻􀁬􀀬􀁾􀀻􀀺􀁾􀁕􀁾􀀺􀁾􀁾􀁾􀀱􀁾􀀠 REVENUES: Charges to participant cities Interest Income Transfer from Operating Fund TOTAL REVENUES EXPENDITURES: Engineering, Design & Inspection Construction Contract Administration LendIR.O.W. Acquisition Total Development Transfer to Operating Fund TOTAL EXPENDITURES EXCESS OF REVENUES OVER EXPENDITURES BEGINNING FUND BALANCE ENDING FUND BALANCE DEC96FINWK1 $4,317.000 8,000 o $4,325,000 $568,000 3,712,800 40,500 3.700 4,325.000 0 $4,325,000 $0 $0 $27.000 3.000 o $30,000 $25,000 0 0 5.000 30.000 $30,000 $0 $0 $5.658 407 o $6,065 $5,658 0 0 5,658 $5,658 $407 $407 $5.658 1,216 o .__-"$6",,,874 $5,658 0 0 5,658 $5,658 $1,216 $117,155 $118.371 $17,096,295 7,000 1.046,705 $18,150,000 $2,500,000 15,579,700 38.300 32.000 18.150,000 $18,150,000 $0 $0_ $14.178.531 27,213 1.046.705 $15,252,449 $1,999,471 13,072,060 68,363 30.722 15,170,616 0 $15.170.616 $81.833 $81.833 ":;;":> ":,,..,H'Capital 􀁐􀁾􀁯􀁪􀁥􀁴􀁴􀁓􀁦􀁴􀁩􀁾􀁾􀁊􀁩􀀠Description, 􀀾􀁩􀀧􀁩􀁾􀁾􀀶􀁾􀀧􀀢􀀠DR, CR '12-31-96 Cash 110,705.63 22,707.50 49,615.23 83,797.90 Accounts Receivable 0.00 0.00 Due from Farmers Branch 64,507.21 64,50721 Due from Addison 100,424.40 16,642.73 83,781.67 Due from Other Funds 0.00 0.00 Construction in Progress 0.00 0.00 Accounts Payable 0.00 0.00 Quebecor Liability (2,280.36) (2,280.36) Retainage Payable (191,929.85) 43,957.23 (147,972.62) Due to Other Funds 0.00 0.00 Investmenlin GFA 0.00 0.00 Fund Balance -FB (37,654.93) (37,654.93) Fund Balance -Addison (42,962.95) (42,962.95) Charges to Farmers Branch 0.00 2,444.82 (2,444,82) Charges to Addison 0.00 3,213,18 (3,213.18) Interest Income-FB (364.12) 183.05 (547,17) Interest Income-Addison (445.03) 223.72 (668.75) Eng, Design, Inspect-FB 0.00 2,444.82 2,444.82 Eng, Design, Inspect-Addison 0.00 3,213.18 3,213.18 Construction-FB 0.00 0.00 Construction-Addison 0.00 0,00 Contract Administration -FB 0.00 0.00 Contract Administration -Addison 0.00 0.00 LandIROW-FB 0,00 0.00 LandlROW-Addison 0,00 0.00 Operating Transfers In-FB 0.00 0.00 Operating Transfers In-Addison 0.00 0.00 Operating Transfers Out-FB 0.00 0,00 Operating Transfers Out-Addison 0.00 Total 0.00 72,322.73 72,322.73 0.00 TB97,WK1 NDCWSC JOURNAL Eo" IRIES DECEMBER 31, 1996 OPERATING FUND To Record December Cash Disbursements Project Admin -Farmers Branch Project Admin -Addison Legal -Farmers Branch Legal -Addison 􀁁􀁵􀁤􀁾-Farmers Branch 􀁁􀁵􀁤􀁾-Addison Bank -Farmers Branch Bank -Addison Mise -Farmers Branch Mise -Addison Accounts Payable Cash 0,00 0.00 To Record December Cash Receipts Cash IAccounts Receivable -Farmers Branch !Accounts Receivable -Addison 0,00 0.00 0.00 TOTAL OPERATING 0.00 0.00 􀁃􀁁􀁐􀁉􀁔􀁁􀁬􀁐􀁒􀁏􀁾􀁅􀁃􀁔􀁓􀀠FUND To Record December Cash Disbursements Design -Farmers Branch 2,444.82 Design -Addison 3,213.18 Construction -Farmers Branch Construction -Addison Project Mgt -FB Project Mgt -Addison . LandIROW -Farmers Branch LandIROW -Addison Quebecor Uability Retainage Payable 43,957.23 Cash To Record December Cash Receipts Cash 22,707.50 Intarest Income-Farmers Branch Interest Income-Addison Contributions -Farmers Branch Contributions -Addison Accls Receivable -Addison TOTAL CIP 72,322.73 TOTAL ALL FUNDS 72322.73 49,615.23 183,05 223.72 2,444.82 3,213,18 16,642.73 72.322,73 72322.73 BANKRECoNCILIATION· DECEMBER31; 1996 Book Balance November 30, 1996 December Receipts Disbursements Book Balance December 31, 1996 Bank Statement Balance December 31, 1996 Outstanding Deposits Outstanding Checks (1171) Book Balance December 31, 1996 110,705.65 22,707.50 (49,615.23) 83,797.92 89,455.92 (5,658.00) 83,797.92 0.00 RfC'D S£p 3a1996 CC /Zrrr tUh,k/-LJc r= 9'V//0'/' 'If, 91:-/5 FaRmeRS BRanCI-f September 27, 1996 Mr. Wilbur Van Riper, P.E. Project Manager Consoer, Townsend Environdyne Engineers, Inc. 10700 Richmond Avenue, Suite 275 Houston, Texas 77042 Subject: North Dallas County Water Supply Corporation Sanitary Interceptor Sewer Phase I Odor Control at Tunnel Air Vents Dear Mr. Van Riper: Please proceed with the odor control measures as proposed by Unisorb Corp. (See Attached) This work is to be accomplished under your contract with the NDCWSC. The corporation will reimburse CTE Engineers upon invoicing after the work is completed. Sincerely, Gary M. Oshel, P.E. Project Manager GMO/nrn􀁢􀀺􀁜􀁮􀁤􀁣􀁷􀁾􀁜􀁶􀁡􀁮􀁲􀁯􀁤􀁯􀁲􀀮􀁬􀁬􀁲􀀠Attachment cc: John Baumgartner, Town of Addison City of Farmers Branch P.O. Bex B1901 0 Farmers Branch. Texas 753B1·901 0 214/247·3131 linked in Friendship with District of Bassetlaw, Nottinghamshire. Great Britain and Garbsen, Germany. Joined in an Economic Alliance with Markham, Canada and and Guadalupe, Mexico. w 􀁡􀁭􀁨􀀴􀁁􀁐􀁒􀁾􀀠• #GR ,;:; S-& iij, ! €! A RECEIVED SEP 24 1996 ENG!/\'ct:""!(:B 􀁦􀀩􀁅􀁆􀁔􀁾􀀠September 13,1996 Mr. Jerry Murawski, P.E. North Dallas County Water Supply Corporation Post Office Box 819010 City ofFarmers Branch, Texas 75381-9010 Re: Odor Control At Tunnel Air Vents Dear Mr. Murawski: Unisorb propose to build sections to insert in top and bottom of existing exhaust pipe and load pipe with activated impregnated carbon for odor controL The bottom section is a 8" T with flanges as shown on attached drawing. The top cover would allow the air to escape and keep rain water out ofcarbon media. All parts would be painted dark green in accordance with paint color specifIcations furnished by city. Unisorb would offer complete service with fabrication of parts, delivery, and installation. Parts include the following: 1. Tees with flanges, blank & perf x 4 2. Tops per drawing x 4 􀁾􀀠.>. section 8' iron pipe with flanges x 1 4. AGB 248 carbon 90 lbs. each x 4 5. 16 guage stainless steel insert x 1 at base of existing 8" DIP U fitting Total price for 4 units installed = S5372 We should be able to be on the job within one week after approval with order. Unisorb will require City ofFarmers Branch equipment and operator assistance in removing and replacing existing 8" vent pipes so that Tees and Cap can be installed. It is estiimated that the time required would be one afternoon and the following morning. Ifone replacement change of carbon is requested, the additional cost would be $525 for all four vents. The total cost for the installation plus the replacement change would be $5372 + $525 =$5897. The cost ofthe carbon pellets are $1.50/pound. There are 35 poundslbox and approximately 10 boxes will be required for replacement for all four vents. 􀁾􀁾􀁾􀁾􀁾􀁾􀁾􀀲􀁾􀁾􀁾􀁾􀀧􀁾􀁾􀁾􀁾􀁾􀁾􀀭􀀽􀁾􀀧􀁾􀂣􀁾􀀭􀁾􀁾􀁾􀁾􀁾􀁾􀁾􀁾􀁾􀁾􀁾􀀽􀁮􀁾 􀁾􀁾􀀽􀀭􀁾􀁾􀀭􀀽􀁾􀀠P.O. BOX 388 • SO. HOCSrO:-.1, rx 77587 • (713) 943-3753 • FAX: (713) 943·7313 ,,,g* e', #* g; a ;e ... Thanks, for considering Unisorb. We look forward to working witn you on this project and any other odor control projects that require our services. Very truly yours, 􀁾􀁾􀁲􀁰􀀩􀁫􀁁􀀠'.Joel Taylor, MUlJlclpal Manager P.O. BOX 388 • SO. HOUSTON, TX 77587 • (713) 943·3753 • FAX; (713) 943-7313 ____ --I' 20'------1 􀁲􀁰􀁌􀁾􀁾􀀺􀀠FLANGE 22' -. I7A 8' DIA, 5 7735' • 1 r t HOLE P TERMATCH 15tJN TOFLANGE, I V/I u v 􀁾􀀰􀀴􀀠S,S, PERF 0 0 􀀯􀁾􀁾􀀬􀀠0. 0 ,\ I I 18,875'1 'I7 0 .....􀁾􀀧􀀯􀀧-_/0 0 I w BLANK .ct. llZZHn!! Ii I II t t -FLO\.! -'--11'--t-1l' ELDED TO 􀀸􀁾􀀠TEE. 􀁾􀀮􀀧􀁏􀀢􀁏􀁯􀀢􀁏􀁯􀀢􀁏􀁯􀀮􀀻􀁯􀁯1000000000000 ';)OOOOOOOOOOO( 1000000000000 ')OOOOOCOOOO()( 􀁾􀀩􀁁􀀬􀀻􀁉􀂰􀁏􀁑􀁏􀁏􀁏 􀁏􀁏􀁏􀁯􀁯􀀠􀁾􀁯􀁯􀁏􀁑􀁏􀁏􀁏􀁏􀁏􀁏􀁏􀀨iOOOOOOOOCiOOO 􀁏􀀨􀀩􀁏􀁏􀁏􀁏􀁏􀁏􀁏􀁏􀀼􀁈􀀠000000000000􀁾􀀠oOCloooaoooo(O()()ooooooooolOCQQOOooaoot 000000(100000lQOOOOOaOOQO(000000000000 )OOQOOOOOOOO( 09QOOO g Q..MJ;I.O o 0 􀀧􀁾􀀠o 0 , 􀁾􀀧􀀠 304 S,S PERF, .1 􀁉􀁾􀁨􀀠􀁣􀁲􀁾II IIOPAllClll. 􀁉􀁾􀀮􀀠it"""",, ...... 1....i lI. 􀀼􀀮􀀬􀁾􀀠/1/11. 􀁾􀀢􀀢􀁨_. 11«1'" !If 􀁯􀁯􀁯􀀯􀁉􀁯􀁢􀁬􀁾􀀠I. ltlt" ""lin ..rill"", \1., .1"1.. 􀁾􀁩􀁬􀁴􀀼􀁦􀁏􀀠_. $2.000 a ..::I II. $1.000 $0 0 In 0 In 0 In 0 In 0 -oN oN C') C') .. .. In-Yeln $12.000 $10.000 􀁾􀀠C! $8,000III 0 IJ!llI Future Value .. $6.000i 􀁾Present Value > e $4.000 􀁾􀀠$2.000 $0 o In 0 In 0 In 􀁾􀀠In 0 􀁾􀀠-􀁾􀀠􀁾􀀠M M 􀁾􀀠􀁾􀀠Years $8.000 $7,000 􀁾􀀠o $6.000 0 ; $5,000 !lill Future Value 􀁾􀀠$4,000 II!Ii Present Value 􀁾􀀠..-$3.000 􀁾􀀠$2.000 $1.000 $0 $20.000 $18.000 􀁾􀀠$16.000 :5 $14.000 cO (§I $12,000 􀁾􀀠$10,000 11 > $8.000 e $6.000 􀁾􀀠$4,000 $2,000 $0 o In 0 In 0 In 0 In 0 -_ 􀁾􀀠N M M 􀁾􀀠􀁾􀀠􀁾􀀠Years Future Value o In 0 In 0 In 0 In 0 __ 􀁾􀀠􀁾􀀠􀁾􀀠􀁾􀀮􀁾􀀠􀁾N Years Present Values PVC Lined (360· T-Lock/Pipe -Rubber &. Steel Joints .',-i PVC Lined (2700 T-Lockl Pipe .!5 -Rubber &. Steel Joints .. .. " .!! PVC Lined (3600 T-Lockl Pipe(,) ct -Rubber &. Concrete Joints .9A-PVC Lined (2700 T-Lockl Pipe ct -Rubber &. Concrete Joints a. ii: I\Z. Design Pipe -Rubber &. ! Steel Joints 13IS Standard Pipe -Rubber &. Steel (,) Joints..,.. !:! P\l. Design Pipe -Rubber &. .e ConcrQte Joints i II: Standard Pipe -Rubber &. Concrete Joints 0.00 0.50 1.00 1.50 2.00 2.50 3.00 Indexes 'Tvpe Of Reinforced Concrete Pipe .• Baseline Costs 􀁓􀁴􀁾􀁮􀁤􀁡􀁲􀁤􀀠Pipe -Rubber &. Concrete Joints Standard Pipe· Rubber &. Steel Joints AZ Design Pipe· Rubber &. Steel Joints PVC Uned (270· T-Lockl Pipe· Rubber & Concrete Joints PVC Uned (360· T-Lockl Pipe· Rubber & Concrete Joints PVC Uned 1270· T-Lockl Pipe -Rubber & Steel Joints PVC Lined 1360· T-Lockl Pipe· Rubber & Steel Joints AZ Design Pipe· Rubber &. Concrete Joints 1.00 1.10 1.40 1.54 1.80 2.00 2.52 2.80 5 10 15 20 25 30 35 40 45 50 $l,(](JO @3'J(". \ YEAR COMPQt:.; .D 1 1,030 2 1,(161 3 1,093 4 1,126 1,159 6 1,194 7 1,230 8 1,267 9 ! 1.305 --1.344 11 1.384 12 1.426 13 1,469 14 1.513 1,558 16 1.605 17 1,653 18 1.702 19 1,754 1,806 21 1,860 22 1,916 23 1,974 24 2.033 2,094 26 2,157 27 2,221 28 2.288 29 2.357 2,427 31 2,500 32 2,575 33 2,652 34 2,732 2,814 36 2,898 37 2,985 38 3.075 39 3.167 3.262 41 3,360 42 3,461 43 3,565 44 3.671 3.782 46 .-3.895 47 4.012 48 4,132 49 4,256 4,384 $l,(](JO @4% COMPOUND 1,040 1,082 1.125 1,170 1,217 1.265 1,316 1.369 1.423 1.480 1.539 1.601 1,665 1,732 1,801 1,873 1,948 2,026 2.107 2,191 2,279 2,370 2,465 2,563 2,666 2.772 2,883 2.999 3.119 3.243 3,373 3,508 3,648 3,794 3,946 4.1D4 4,268 4.439 4,616 4,801 4,993 5.193 5,400 5.617 5.841 6.075 6.318 6.571 6,833 7,107 􀁾􀁬􀀬􀀨􀁝􀀨􀁊􀁏􀀠@5% COMPOUND 1,050 1,103 1.158 1,216 1:Zl6 1,340 1.407 1,477 1.551 1.629 1,710 1.796 1,886 1.980 .2,079 2,183 2.292 2.407 2,527 2,653 2,786 2,925 3,072 3.225 3,386 3.556 3,733 3,920 4,116 4.322 4,538 4,765 5,003 5,253 5,516 5,792 6.081 6,385 6,705 7,040 7,392 7,762 8,150 8.557 8.985 9.434 9.006 10.401 10.921 11,467 􀁾􀁬􀀬􀁕􀁕􀁕􀀠' @6%. i 􀁾􀁏􀁍􀁐􀁏􀁕􀁎􀁄􀀠1,050 1,124 1,191 1,262 1,338 1,419 1.504 1,594 1,689 ,1,791 1,898 2,012 2,1332,261 2.397 2,540 2,693 2.854 3,026 3,207 3.400 3,604 3.820 4.049 4.292 4,549 4.822 5.112 5.418 5.743 6,088 6,453 6,841 7,251 7,686 8,147 8,636 9.154 9.704 10,286 10,903 11,557 '12,250 12.985 13.765 14.590 15.466 16,394 17,378 18.420 ) PUBUC WORKS DEPARTMENT (214) 450-2871 Post Office Box 144 AddisO"n. TexlL'! 75001 16801 Westgrove July 19, 1994 Mr. Gary Oshel, P. E. Assistant City Engineer City of Fanners Branch P.O. Box 819010 Fanners Branch, Texas 75381-9010 Re: NDCWSC Seven K Construction Company -Progress Payment No.7 Dear Gary: The Town ofAddison concurs with your assessment and'reeommends payment ofSeven K Construction Company's 􀁾􀀧􀀧􀀧􀀧􀀧􀀧􀀧􀀠«.,.....", m1"0[$'",881.''' . ely, ohnR. 􀁂􀁡􀁵􀁭􀁧􀁾􀀷Director of Public Works JRB/gmk cc: Randy Moravec Finance Director PUBLIC WORKS DEPARTMENT (214) 450-2871 Post Office Box 144 Addison. Texas 75001 16801 WestiJl'ove July 19, 1994 Mr. Gary Oshel, P.E. Assistant City Engineer City of Farmers Branch P.O. Box 8l90l0 Farmers Branch, Texas 75381-90l0 Re: NDCWSC Seven K Constructi' . on Company· Progress Payment No. 7 Dear Gary: FaRmeRS BRanCI-f July 14, 1994 Mr. John Baumgartner, P.E. City Engineer Town of Addison P.O. Box 144 Addison, Texas 75001 RE: NDCWSC INVOICE FOR CONTRACTOR Attached is a copy of Seven K Construction Company's progress payment application No.7 through June 25, 1994. I have examined their application for payment and find that it is reasonable and should be paid. Please review the enclosed documentation for approval of payment on behalf of the Town of Addison and respond in writing if you concur. You may fax your response to Engineering Department, 241-6305. Should you have any questions, please do not hesitate to contact me. Sincerely,/J1nu Gary M. Oshel, P.E. Assistant City Engineer GMO/en Attachment: Seven K Construction Company Payment Application No.7 INTERCEP\7K.ADD City of Farmers Branch P.o, Box 819010 Farmers Branch, Texas 75381-9010 214/247-3131 [jnked in Friendship with District of 8assetlaw, Nottlnghamshlre, Great Britain and Garbsen, Germany. Joined in an Economic Alliance with Markham, Canada and and Guadalupe, MeXICO. CERTIFICATE OF THE CONTRACTOR OR HIS DULY AUTHORIZED REPRESENTATIVE APPUCATlON 7 • ' To the best of my knowlegdge and belief, I certify that all items, units, quantities, and PERIOD 5-26-94 TO 6-25-94 .. prices of work and material shown on the face of Sheets 1 thru 4 of this Monthly Estimate are correct that all work has been performed and materials supplied in full accordance with the terms and conditions of the corresponding construction contract documents between the undersigned as Contractor and The North Dallas County Water Supply Corporation, as Owner, dated November 16, 1993, and all autholized changes thereto; that the following is a true and correct statement 01 the contract account up to and Including the laS! day of the period covered by this estimate and that no part of the To18l Amount Due has been received: (a) Total amount eamed (From Worksheet) $ 2,294,095,10 (b) Ratainage -5% -,•. ""..".""".".""".""..."""" "".",,",,,.,,,,,,,,,,,,,,,",",",",,,,,,,,,,,$ 114,704.76 (c) To18l earned less relainage.,,,,.,.,.,,,.,,,,,,,,,,,,,,,...,,,,,,,,,,,,,...,,,,,,,,,,,,,,,,,,,,,,,,,",,,",,,,,$ 2,179,390.35 (d) TOlal previously certified (Line c from previous estimate)"" ........... ",$ 1,905,509.15 (e) Amount due this estimate,,,.,,.,,,,., ...., " .. " .""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.,,,,,,,,,,,, ,,,,,,,,.$ 273,881.20 (f) Excess cost of field engineering and inspection 17 HOURS @$751HR$ (1,275.00) (g) Total Amount Due........".".,"''',."''''',..""."'''''''".""... "."."."''''".'",,.,,,,."."""" ",,$ 272,606,20 I fUrther certify that all claims outstanding as ofthis date against the undersigned as contractor for labor, materials, and expendable equipment employed in the performance of said contract to this date have been paid in accordance with the requirements of said contract, CON DATE: vCLt J,, 􀁌􀁦􀁾􀀠fc. BY: TlTLE: 􀁦􀀱􀁴􀁚􀁂􀀮􀂣􀁾􀀠/'-(AivA 􀁾'601'1.'" TO!=lIES -- SI EM.IIE OF SERl7ICES AND MJ:NllU( FEES HRIH 􀁾GiI1l'I'lllNICAL 􀁾DIVISICN FII!U) SlWllS JANOl\RY 1991 IDBILIZATION lIND DEM:lBILIZATION 1. Truck lroUJ1ted drill rig, water truck arrl crew--$ 2. 65/mi. ($175.00 MiniImlm) 2. Pickup arrl 3-roan crew (travel to/from site arrl office when equipn-ent left at location on out-of-tc1Nn projects) $ 1.25/rni. 3. SUbsistence per crew :member $ 60.00/day 4. Minimum drillirq fee $500.00 FIElD lNVFSTIGATION 5. Soil samples (Shelby Tube samples in =hesive soils, 2-inch split spoon samples in =hesive soils) a. Intermittent 2 or 3-inch diameter 0-50 (sampled at 51 intervals $ 9.l5/ft 50-100 (sampled at 51 intervals) $ 11. 60/ft. 100-200 (sampled at 10'intervals) $ l6.80/ft. 200-300 (sampled at 20'intervals) $ 21.00/ft. b. Continuous 2 or 3-inch diameter 0-50 feet-----------------$ 16.80/ft. 50-100 feet $ 21.00/ft. c. Larger diametersi----------------------Quoted on request 6. wash or auger J:orirqs without samples $ 5.00/ft. 7. Uhdisturbed or split-spoon samples in wash or or auger J:orings---------------------$ 31.50/ea. 8. casing of J:oring through overl::urden for soil sampling or rock coring-------------------$ 5.00/ft. Page 1 of 2 '---_____________________ '.iOUT.... wESTERN LAGORATOfUES __---l T 7 9. Rock coring (NX-size), continuous coring, plus bit costs a. Carbid.ee---------------------$14.95 b. 􀁄􀁩􀁾􀁮􀁤􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭􀀭$21.00 10. Equipment rental plus bit costs a. Two men, Mobil B-53---------------------$136.50/hr. b. '1h1:'ee men, Failing 1250 (air), GD1000 (air) MobilB-57-----------------------------------$150. OO/hr. c. '1h1:'ee men, om 75 air cambination--------------$160.00/hr. 11. starn-by of =_ and equipment, includi.nq move time in excess of 30 minute per boring a. '1h1:'ee men, drilling equipment.----------$130.00/hr. 12. Rental equipment necessary to gain access------Cost +15% 13. Instrumentation (slope indicators, piezometers, etc.) a. Installation------------------Rig rental rate b. Materials (s=een, pipe, :instruments)-------Cost +15% c. Geologist or Engineer at rate listed in Schedule of Hourly fees for personnel d. standard 2-inch standpipe observation wells-----$ 6.00/ft. 14. Drilling tools, casing and bits lost in hole'------Cost +15% 15. Pressure testing----------------------------Rig rental rate 16. Resistivity SllrVeys----------------------lded or compacted specimen for items above 17. Opt:i:mu:m Moisture -Density Relation stan::lard Mcxiifierl , 18. california Bearirg Ratio (3 specimens) 19. Lime stabilization Lime/Atterberg Series Lime/pH Series Opt:i:mu:m Moisture -Density/Lime stabilizerl Soil 4-inch Mold 6-inch Mold Optinrum Moisture Density with strenjth tests -three lime contents 20. Dispersion Pinhole Cr\mlb Double Hydrometer 21-Iaboratory Resistivity Page 2 of 2 L-______________________ 501.1 'THwESYCPf,,/UNIT l2EICE $ 180.00 $ 60.00 $ 80.00 $ 20.00 $ 135.00 $ 150.00 $ 415.00 $ 160.00 $ 80.00 $ 150.00 $ 150.00 $ 450.00 $ 115.00 $ 21.00 $ 115.00 $ 35.00 I.. A80AI>. TO 1'(1, F.S -_---' ANALYTICAL TESTING SANITARY INTERCEPTOR SEWER FARMERS BRANCH/ADDISON, TEXAS pH 5.00 ea. Sulfates 20.00 ea. Sulfides 25.00 ea. cyanide 25.00 ea. volatile Organics 225.00 ea. Semi-Volatile Organics 575.00 ea. Chlorides 20.00 ea. Methane 50.00 ea. Total $945.00/sample Above series on five or more samples $875.00/sample. Sampling Charge $45.00/hr. For three sampling times estimate maximum of 8 hours. April 17, 1991 "------------------------'"." ..." ............. EXHIBIT "D" SUMMARY OF COSTS This is an exhibit to and incorporated into the Agreement (the "Agreement") entered into by and between the NORTH DALLAS COUNTY WATER SUPPLY CORPORATION, a Texas Water Supply Corporation, created by the Cities of Farmers Branch and Addison hereinafter referred to as "OWNER" and CONS ER, TOWNSEND & ASSOCIATES, INC., hereinafter referred to as "Engineer", on \p , 1991MAXIMUM FINAL DESIGN BASIC SERVICES COST A. BASIC FINAL DESIGN SERVICES $607,984 B. OTHER DIRECT COSTS: 1. Printing plans specifications @commercial invoice costs a. 5 sets for 50, 90 & 100 percent review b. 30 sets for bidding purposes c. 20 sets for regulatory & utility agencies d. Total costs $5,500 2. Travel cost @commercial invoice cost @26 round trips $4,000 3. CAD use costs @$10.00 per hour @1 ,384 hours = $13,840 Total other direct costs $23,340 TOTAL MAXIMUM FINAL DESIGN BASIC SERVICES $631,324 MAXIMUM SPECIAL SERVICES COST SUMMARY A. Surveying $92,896 22 B. Easement legal descriptions and plat preparation $49,408 C. Gectechnical investigations $183,500 D. Sanitary sewage analytical testing $3,195 E. Flow metering $4,500 TOTAL MAXIMUM SPECIAL SERVICES $333,499 TOTAL MAXIMUM COST FINAL DESIGN AND SPECIAL SERVICES COST 􀁾􀀹􀀶􀀴􀀬􀀸􀀲􀀳􀀠23 EXHIBIT "E" PAYMENT AND BILLING RATES FOR SERVICES ,DURING CONSmUCTION This is an exhibit to and incorporated into the Agreement (the "Agreement") entered into by and between the NORTH DALLAS COUNTY WATER SUPPLY CORPORATION, a Texas Water Supply Corporation, created by the Cities of Farmers Branch and Addison hereinafter referred to as "OWNER" and CONJi9ER, TOWNSEND & ASSOCIATES, INC., hereinafter referred to as "Engineer", on 􀁾􀀠Y't2A.. (; , 199!-7J I. PAYMENT Payment will be based on actual salary of staff members involved in productive work on the project based on a salary multiplier to be negotiated with the owner upon the completion of Final Design. II. BILLING RATES Billing rates will be based on the personnel assigned to the project upon the completion of Final Design and will also be based upon the salary multiplier negotiated in Paragraph I -Payment -above. Exhibit "E" is not included in this Agreement and if for information only. 24 EXHIBIT UP' SUMMARY OF MAXIMUM COST FOR SERVICES DURING CONSTRUCTION This is an exhibit to and incorporated into the Agreement (the "Agreement") entered into by and between the NORTH DALLAS COUNTY WATER SUPPLY CORPORATION, a Texas Water Supply Corporation, created by the Cities of Farmers Branch and Addisonson hereinafter referred to as "OWNER" and CONSOER, TOWNSEND & ASSOCIATES, INC., hereinafter referred to as "Engineer", on 􀁾􀁾􀀠, 199:1The Maximum Costs for Services Du􀁾􀁯􀁮􀁳􀁾􀁣􀁴􀁩􀁯􀁮􀀠will be negotiated with the owner upon completion of Final Design, Exhibit UFn is not included in this Agreement and if for information only, 25 ATTACHMENT 'B' NORTH DAlLAS COUNTY WATER SUPPLY CORPORATION EXTRA WORK COST SUMMARY A. SouthWestern Bell Design Adjustment 1. Consoer Townsend & Associates Base Base Salary Position Salary Hours Mulllplier Cost Project Manager $39.01 20 3.1 $2,418.62 CADD Technician $19.58 40 3.1 $2,427.92 Total $4,846.54 B. R.O.W. Easements 1. Consoer Townsend & Associates Base Base Salary Position Salary Hours Multiplier Cost CADD Technician $18.74 43 3.1 $2,498.04 Technician $13.71 11 3.1 $467.51 CADD Technician $19.58 23 3.1 $1,396.05 Technician $14.33 6 3.1 $266.54 Total $4,628.14 C. City of Dallas Requested Easement Adjustments 1. ConsoerTownsend & Associates Base Base Salary . Position Salary Hours Mulllplier Cost CADD Technician $19.58 4 3.1 $242.79 2. lichliter/Jameson & Associates Invoice No. 110185 $661.75 Totat $904.54 D. A-Z Report 1. Consoer Townsend & Associates Base Base Salary Position Salary Hours Mulllplier Cost Project Director $39.01 6 3.1 $725.59 Project Manager $39.01 28 3.1 $3,386.07 Project Engineer Engineer $29.63 23 3.1 $2,112.62 Technician $13.99 8 3.1 $346.95 Technician $14.33 3.1 $44.42 SubTotat $6,615.65 2. Jay Dee Contractors, tnc. tnvoice No. __ $0.00 Totat $6,615.65 E. Project Advertisement McGraw-Hili Invoice Nos. Cost K1794047 $1,066.00 K1804051 $1,066.00 K1944062 $1,066.00 Total $3,198.00 F. Total Extra Work $20,192.88 Farmers Brat Tunnel 02193 $607,984.00 $71,602.96 $27,685.76BASICSVCS $405,223.96 $29,740.35 CT&A Design: $555,996.00 $27,685.76$388,372.21 $51.526.83 $29.740.35 UJ Design: $15.312.00 $14,925.75 $346.00 Jay Dee Cns!r: $36,676.00 $1,926.00 $19,730.13 $23,340.00 $0.00DIRECT COSTS $20.844.86 $704.24 $376.90 printing: $5.500.00 $1,679.44 $265.03 $376.90 travel: $4,000.00 $5,125.42 $439.21 CAOO: $13.840.00 $13,840.00 Advertisement: $0.00 $0.00 TOTAL BASIC: $831 117.25 SVCS surveying: $92,896.00 $92,677.50 Esmts, Legal: $49,408.00 $49,408.00 TOTALSRVY: $142,304.00 $142.085.50 $0.00 $0.00 $0.00 $183,500.00Geotechnical: $142,403.16 Anlytcl Tests: $3,195.00 $0.00 Flow Metering: $4,500.00 . $4,500.00 $0.00 . $0.00 . 04/93 $19,952.46 $19.952.46 $255.33 $255.33 $0.00 $1,325.00 $27 <"::," $15,198.89 •. $7,593.39 .. $2,605.50 "'i"';: $5,000.00 ; • $421.52 ,i' $10,177.00 . . . $1,890.75 ". $12,067.75 ($12.511 $39,001.84 $3,195.00 $0.00 $30,050.24 $20,030.83 $10,019,41 $678.88 $153,53 $525.35 $0.00 06/93 $25,962.93 $25,962.93 $3,032.33 $251.38 $646.95 $2,132.00 $661.75 $881.75 $770.00 07/93 $17,897.42 $17.897.42 $1,187.76 $121.76 $1,066.00 $0.00 $1 ! · .Jrth Dallas County Water Supply Cu. fJoration City of Farmers Branch/Town of Addison Joint Venture Sanitary Interceptor Sewer -Phase I I. Consoer Townsend & Associates A. Estimated Staffing Costs Position Manhours Rate Cost Principal 200 123.75 $24.750.00 Project Manager 940 123.00 $116,325.00 Resident Engineer 4002 75.00 $300,150.00 Project Engineer 500 94.00 $47,000.00 Structural Engineer 100 115.00 $11,500.00 CADD Technician 120 62.00 $7,440.00 Technician-Office 400 45.00 􀁾􀀱􀀸􀀬􀀰􀀰􀀰􀀮􀀰􀀰􀀠Subtotal $525,165.00 B. Direct Costs Travel -Plane and car rental (158 + 55) x 30 = $6,390.00 Printing @$125 x 24 = 􀁾􀀳􀀬􀀰􀀰􀀰􀀮􀀰􀀰􀀠Subtotal $9,390.00 Subtotal CT&A $534,555.00 II. Jay Dee Contractors A. Estimated Staffing Costs Position Manhours Rate Cost Manager 768 115.00 $88,320.00 Assistant Resident Engineer 4002 75.00 $300,150.00 Field Inspector 3480 35.00 $121,800.00 Senior Safety Engineer 192 72.00 􀁾􀀱􀀳􀀮􀀸􀀲􀀴􀀮􀀰􀀰􀀠Subtotal $524,094.00 B. Direct Costs Travel Expenses (160 + 400) x 24 = $13,440.00 Subtotal Jay Dee $537,534.00 Page 1 of 2 III. Project Special Costs A. Safety Equipment Combination Gas Tester, 2 @$120/month x 20 = Escape SCBA Units, 4 @$50/month x 18 = Anemometer, 1 @$50/month x 18 = Subtotal Safety Equipment B. Photographs 5 photos x 21 days x 20 months @.60/photo = C. Tunnel Survey Consultant 3 surveys @3,OOO/Survey = D. Surveying for Line and Grade and Settlement Control 1. Line and grade and setting elevation markers and establishing starting elevations 2. Provide elevations on all markers once a month for 12 months 3. Provide elevations at end of warranty period one year after construction Subtotal Surveying E. Project Vehicles 2 Vehicles @$35/day @21 days x 23 months = 1 Vehicle @$35/day @21 days x 20 months = Subtotal Vehicles F. One Year Warranty Inspection and Report Subtotal Warranty Subtotal Special Costs Total Project Cost $4,800.00 $3,600.00 $900.00 $9,300.00 $1,260.00 $9,000.00 $25,650.00 $25,700.00 $5.250.00 $56,600.00 $33,810.00 $14,700.00 $48,510.00 $11,990.00 $136,660.00 $1.208.749.00 Page 2 of 2 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION ANNUAL FINANCIAL REPORT YEAR ENDED SEPTEMBER 30, 1996 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION ANNUAL FINANCIAL REPORT YEAR ENDED SEPTEMBER 30, 1996 CONTENTS Page INDEPENDENT AUDITOR'S REPORT 1 FINANCIAL STATEMENTS Balance Sheet -All Fund Types and Account Groups 2 Statement of Revenues, Expenditures and Changes in Fund Balances -All Govemmental Fund Types 3 Statement of Revenues, Expenditures and Changes in Fund Balances -Budget (GAAP Basis) and Actual -All Govemmental Fund Types Notes to Financial Statements 4 5 III WEAVER TIDWELL ----LLP CERTIFIED PUBUC ACCOUNTANTS AND CONSULTANTS !222J I'leril Drii't Snih' 1700 DeJl.1f, Tex,n 752,51 972.490,}970 F 972.702.8321 FORT WORTH OFFICE .>07 \\;(.)/S"I'l:ttt/; S/f'tt'l SHift 15uo FOri IVbl',b, 'j;XaS 76/!):! WORLOWIOE AFFILIATIONS THROUGH SUMMIT INTERNATIONAL ASSOCIATES, INC INDEPENDENT AUDITOR'S REPORT Board of Directors North Dallas County Water Supply Corporation Fanners Branch, Texas We have audited the accompanying financial statements of the North Dallas county Water Supply Corporation, as of and for the year ended September 30, 1996, as listed in the table of contents. These financial statements are the responsibility of the Corporation's management. Our responsibility Is to express an opinion on these financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards. Those standards require that we plan and perfonn the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An aUdit alsc includes assessing the accounting principles used and significant eStimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. In our opinion, the financial statements referred to above present fairly, in all material respects, the financial position of the North Dallas County Water Supply Corporation at September 3D, 1996, and the results of its operations for the year then ended in confonnity with generally accepted accounting principles. 􀀴􀁉􀀬􀁾􀁥􀀺􀀭􀀮􀀯􀁟􀀲􀀺􀁊􀁾􀁾􀀯􀀠WEAVER AND TIDWELL, L.L.P. Dallas, Texas November 7, 1996 573 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION BALANCE SHEET· ALL FUND TYPES AND ACCOUNT GROUPS SEPTEMBER 30, 1996 Govemmental Account Fund T:/:!!es Grout! Totals General Memorandum Onl:/: Capital Fixed General Projects Assets 1996 1995 ASSETS Cash $ $ 83,156 $ $ 83,156 $ 125,971 Accounts receivable: Town of Addison 411 147,783 148,194 636,579 Cny of Farmers Branch 337 150,407 150,744 484,613 Construction in progress 15,164,957 15,164,957 12,624,059 Total Assets $ 748 $ 381,346 $ 15,164,957 $ 15,547,051 $ 13,871,222 LIABILITIES Accounts payable $ 748 $ 108,798 $ $ 109,546 $ 652,886 Retainage payable 191.930 191,930 521.002 Totaillabilnies 748 300,728 301,476 1,173,888 EQUITY AND OTHER CREDITS I nvestment in general fixed assets 15.164,957 15.164.957 12,624,059 Fund balances 80.618 80,618 73.275 Total equity and other credits 80.618 15.164,957 15,245,575 12.697.334 Total Liabilities, Equity and Other Credits $ 748 $ 381.346 $ 15.164.957 $ 15,547,051 $ 13,871.222 The Notes to Financial Statements are an integral part of this statement. 2 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES -ALL GOVERNMENTAL FUND TYPES YEAR ENDED SEPTEMBER 30, 1996 Revenues: Charges to participant cities: Town ofAddison City of Farmers Branch Interest income and other $ Governmental Fund 􀁔􀁾􀁬􀀡􀁥􀁳􀀠Capnal General Pro;ects 6,209 $ 1,023,596 5,080 1,517,303 7,343 Totals Memorandum 􀁏􀁮􀁬􀁾􀀠1996 1995 $ 1,029,805 $ 4,246,101 1,522,383 3,252,716 7,343 13,954 Total revenues 11,289 2,548,242 2,559,531 7,512,771 Expendnures: Current Project administration Legal fees Miscellaneous Capnal outlay 3,077 1,078 7,134 2,540,899 3,077 1.078 7,134 2,540,899 2,353 25,610 3,835 7.407,698 Total expendnures 􀀱􀀱􀁾􀀸􀀹􀀠2,540,899 2,552,188 7,439,496 Excess (deficiency) of revenues over expendnures 7,343 7,343 73,275 Other financing sources (uses): Operating transfers In Operating transfers out (8,062) 8,062 8,062 (8,062) Total other financing sources (uses) (8,062) 8,062 Excess (deficiency) of revenues and other financing sources over expenditures and other financing uses (8,062) 15,405 7,343 73,275 Fund balances, beginning of year 8,062 65,213 73,275 Fund balances, end ofyear $ $ 80,618 $ 80,618 $ 73,275 The Notes to Financial Statements are an integral part of this statement 3 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES -BUDGET (GAAP BASIS) AND ACTUAL ALL GOVERNMENTAL FUND TYPES YEAR ENDED SEPTEMBER 30, 1996 General Fund Caeital Projects Fund Revenues: Charges to participant cities: Town of Addison City of Farmers Branch Interest and miscellaneous $ BU!!l!e! 9,075 7,425 Actual $ 6,209 5,080 Variance favorable !unfavorable) $ (2,866) (2,345) Bud!!e! $ 2,288,000 2,029,000 8,000 Actual $ 1,023,596 1,517,303 7,343 Variance favorable !unfavorablel $ (1,264,404) {511 ,697) (657) Total revenues 16,500 11,289 (5,211) 4,325,000 2,548,242 (1,776,758) Expenditures: Current Project administration Insurance Legal fees Miscellaneous Capital oUlley 4,700 1,000 3,000 7,800 3,077 1,078 7,134 1,623 1,000 1,922 866 4,325,000 2,540,899 1,784,101 Tetal expenditures 16,500 11,289 5,211 4,325,000 2,540,899 1,784,101 Excess (deficiency) of revenues over expenditures 7,343 7,343 other Financing Sources (Uses): Operating transfers in Operating transfers out !8,062l !8,062l 8,062 8,062 Total other financing sources (uses) (8,062l (8, 062l 8,062 8,062 Excess (deficiency) of revenues and other financing sources over expenditures and other financing uses (8,062) (8,062) 15,405 15,405 Fund balances, beginning of year 8,062 8,062 -65,213 65,213 Fund balances, end of year $ 81062 $ $ !8,O62l $ 65,213 $ 80,618 $ 15,405 The Notes to Financial Statements are an integral part of this statement 4 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION NOTES TO FINANCIAL STATEMENTS Note 1. Summary of Significant Accounting Policies The financial statements of the North Dallas County Water Supply Corporation are presented in accordance with generally accepted accounting principles applicable to state and local governmental units as set forth by the Governmental Accounting Standards Board. The following is a summary of the more significant accounting ana reporting policies ana practices. Organization ana Reporting Entity The North Dallas County Water Supply Corporation ("Corporation") was incorporatea on April 29, 1991 as a public instrumentality ana non-profit water supply corporation under Article 1434a, Texas Revised Civil Statutes Annotated, as amended. The Corporation was formed with the approval of the Town Council of the Town of Addison. Texas ("Town,,), and the City Council of the City of Farmers Branch,Texas (,City"), to provide sanitary sewer interceptor services to the Town and City on a joint baSis. The affairs of the Corporation are managed by a six person board of directors that is appOinted by the governing bodies of the Town and the City. The Corporation's financial statements include the accounts of all Corporate activities. OperatiOns The Corporation was formed to design. finance, construct, operate and maintain a joint sanitary sewer interceptor. Costs of development, financing, overhead, operations and maintenance are allocated to the Town and City in accordance with an interlocal sanitary sewer interceptor agreement. Basis of Presentation The accounts of the Corporation are Ofllanized on the basis of funds and account groups, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self:balancing accounts that comprise its assets, 􀁬􀁩􀁡􀁢􀁬􀁬􀁾􀁩􀁥􀁳􀀬􀀠fund equity, revenues. and expenditures, as appropriate. Government resources are allocated to and accounted for in individual funds based upon the purposes for which they are are to be spent and the means by which spending activities are controlled. The various funds are grouped, in the flnaru:ial statements in this report, into the fund types and account groups listed below: Governmental Funds General fund -is the general operating fund of the Corporation. It is used to account for all finanCial resources except those required to be accounted for in another fund. Capital projects fund -is used to account for financial resources to be used for the construction of the joint sanitary sewer interceptor project. Account Group General fixed assets account group -is utilized to account for fIXed assets utilized in governmental fund type operations. 5 NORTH DALLAS COUNlY WATER SUPPLY CORPORATION NOTES TO FINANCIAL STATEMENTS Note 1. Summary of Significant Accounting Policies -continued Measurement Focus Measurement focus is the accounting convention which determines which assets and liabilities are included on the balance sheet of a fund type and whether a fund type's operating statement presents "financial flow" or capital maintenance information. All governmental fund types are accounted for on a spending or "financial flow" measurement focus. This means that only current assets and current liabilities are generally included on their balance sheets. Their reported fund balance is considered a measure of "available spendable resources". Govemmental fund operating statements present increases (revenues and other financing sources) and decreases (expenditures and other financing uses) in net current assets. Accordingly, they are said to present a summary of sources and uses of "available spendable resources" during a period. Fixed assets used in governmental fund type operations are accounted for in the General Fixed Assets account group, which is not a "fund". It is concemed only with the measurement of financial pOSition. It is not involved with the measurement of results of operations. Basis of Accounting Basis of accounting refers to when revenues and expenditures or expenses are recognized in accounts and reported in the financial statements. Basis of accounting relates to the timing of the measurements made, regardless of the measurement focus applied . All govemmental fund types are accounted for using the modified accrual basis of accounting. Under the modified accrual basis of accounting. revenues are recognized when they become measurable and available as net current assets. Primary revenues of the govemmental fund types which have been accrued are charges to participant cities for liabilities of the Corporation which were incurred but not reimbursed by participant cities prior to year end. This amount is considered available due to the close relationship between the Corporation and participant cities. Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred. Budget At least sIxty days prior to the commencement of each fiscal year. the Board of Directors of the Corporation adopts a proposed budget of expected revenues and proposed expenditures for the next ensuing fiscal year. The budget is not effective until approved by the Town and City. General Fixed Assets General fIXed assets have been acquired or constructed for general govemmental purposes from governmental fund types. Assets purchased or constructed in these funds are recorded as expenditures and capitalized at cost In the general fIXed asset account group. No depredation is provided on general fIXed assets . . 1 6 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION NOTES TO FINANCIAL STATEMENTS Note 1. Summary of Significant Accounting Policies· continued Memorandum Only· Total Columns The total columns presented in the financial statements are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis. Data in these columns do not present financial position or results of operations in conformity with generally accepted accounting principles. Neither are such data comparable to a consolidation. Interfund eliminatlons have not been made in the aggregation of these data. Estimates The preparation of financial statements in conformity with generally accepted accounting principles requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at the date of the finanCial statements and the reported amounts of revenues and expenses during the reporting period. Actual results could differ from those estimates. Note 2. Cash and Investments Deposits At September 30, 1996, the carrying amount of the Corporation's cash deposits held at the Corporation's depository bank was $83,156 and the bank balance was $84,458. In addition to the $100,000 of federal deposit insurance, the Corporation's depository bank had pledged in the Corporation's name $1,049,055 in additional collateral held by the Corporation's agent in the Corporation's name. Cash deposits held at finanCial institutions can be categorized according to three levels of risk. These three levels of risk are: Category 1 Deposits which are insured or collateralized with securities held by the entity or by Its agent in the entity's name. Category 2 Deposits which are collaterialized with securities held by the pledging financial institution's trust department or agent in the entity's name. Category 3 Deposits which are not collateralized. Based on these three levels of risk, the Corporation's cash deposits at Septembar 30, 1996 are classified classified as Category 1. Investments The investment policy approved by the Board of Directors of the Corporation authorizes the investment of the Corporation's funds in obligations of the United States or Its agencies and instrumentalitles, fully collateralized direct repurchase agreements with a defined termination date secured by obligations of the United States or its agencies and instrumentalities, or joint pools of political subdiviSions in the State of Texas which invest in instruments allowed by current law. The Corporation had no investments at September 30, 1996. 7 NORTH DALLAS COUNTY WATER SUPPLY CORPORATION NOTES TO FINANCIAL STATEMENTS Note 3. General Fixed Assets A summary of changes in general fixed assets follows: Balance at Balance at beginning end ohear Additions ofvear Construction in progress $12624 Q5Q $254Q 898 $15164951 Note 4. Commitments At September 30. 1996. the Corporation is committed under the following outstanding construction contracts in the Capital Projects Fund. Phase I construction $ 61.787 Phase II construction 69.117 8 , \ -"'. CARROLLTON 􀁾􀁾􀀺􀀻􀀩􀀠Pop 40,595 􀁾􀀠/'---' FARMERS BRA.NCIlI 􀁾􀁉􀀠+ PROIPOlJ:o 6O"HrERCEPTOR SEWER...,Jl TRA TRUNK SEWER , PLAZA CT&A ' Consoe.r, Townsend & Assoc. Consulting Engineers City of farmers Branch Town of Addison TUNNEL INTERCEPTOR SEWER DETAlLI;lD LOCATION MAP 􀀮􀁾􀀺􀀠􀁎􀁏􀀮􀁾􀀠I ! !