07-11-2013 - Laserfiche WebLink

TASK_ORDER_SUMMARY‐07‐11‐2013‐REV2.DOCX 1 Task Order Summary Date: July 11, 2013 Task Order Summary Budget Estimate ($) HMG Task Order No. 2, Amendment 2 ‐CR‐31/CR‐4 Bridge 20,000  Amendment to add scope and budget for additional CR‐4 road and Ditch 29 alignment work HMG Task Order No. 3, Amendment 2 ‐I‐29/CR‐81 Bridges 115,000  Amendment to add scope and budget for additional I‐29 alignment evaluation, construction staging work, and increase in reach length HMG Task Order No. 4, Amendment 2 ‐CR‐32/CR‐22 Bridges 145,000  Amendment to add scope and budget for bridge detour road design work and EMB additional design work HMG Task Order No. 9, Amendment 7 ‐Hydrology and Hydraulic Modeling 210,000  Amendment to add Phase 7.1 model update scope and budget  Amendment to add PMF model evaluation scope and budget Total of Task Orders $ 490,000 Item 4c. TASK_ORDER_SUMMARY‐07‐11‐2013‐REV2.DOCX 2 TASK ORDER SUMMARY HMG – Task Order No. 2 – Amendment 2 Increase $ 20,000 Work Package 2, CR‐31 Bridge Schedule Extension Description: Defines additional scope for Drain 29 under Final Roadway Design and Plan Preparation: Coordinate Drain 29 temporary and permanent outlets with USACE’s Outlet and Reach 1 design team. A permanent drain outlet is to be incorporated into the Diversion Outlet. Provide a temporary Drain 29 outlet into the Red River outside of the construction limits for the Outlet and Reach 1. Background: The Drain 29 design modification relocates the drain prior to construction of Reach 1 for improved constructability. The above described work is creditable as part of the Owner’s Lands, Easements, Rights of Way, Relocations, and Disposal (LERRDs) work. Recommendation: PMC recommends authorization for Task Order No. 2, Amendment 2 for $20,000. HMG – Task Order No. 3 – Amendment 2 Increase $ 115,000 Work Package 4 ‐CR‐81 Bridge, I‐29 N & S Bridges Schedule Extension Description: Defines additional scope: 1. Provide channel design for additional 2,500‐ft of channel. 2. Develop a comprehensive construction staging plan for all four bridges in Reach 3 and provide analysis and budgetary cost estimates. Conduct a realignment analysis of I‐29 to avoid construction staging issues and costs. Background: The additional channel length is needed to provide adequate fill for bridge approach raises. The staging plan and realignment analysis are needed to determine the optimal bridge configuration with respect to constructability. The above described work is creditable work‐in‐kind assistance. Recommendation: PMC recommends authorization for Task Order No. 3, Amendment 2 for $115,000. HMG – Task Order No. 4 – Amendment 2 Increase $ 145,000 Work Package 7 ‐CR‐32 & 22 Bridges Schedule Extension Description: Defines additional scope: 1. Provide field survey services to upgrade 5.0 miles of minimum maintenance roadway, to Cass County roadway standards, for use as by‐pass route. 2. Provide by‐pass roadway design improvements to upgrade 5.0 miles of minimum maintenance roadway, to Cass County roadway standards. TASK_ORDER_SUMMARY‐07‐11‐2013‐REV2.DOCX 3 3. Provide hydraulic analysis and designs for by‐pass crossings of the Rush and Lower Rush Rivers. Coordinate design of Excavated Material Berms (EMB) with adjacent USACE diversion channel reach EMBs. Revise EMB layouts as needed to match USACE final EMB layouts. Background: The surveys, design improvements, and hydraulic analyses for the by‐pass roadways are needed to accommodate anticipated traffic. Additional coordination and EMB layout revisions are needed to match adjacent EMB designs. The above described work is creditable as part of the Owner’s Lands, Easements, Rights of Way, Relocations, and Disposal (LERRDs) work. Recommendation: PMC recommends authorization for Task Order No. 4, Amendment 2 for $145,000. HMG – Task Order No. 9 – Amendment 7 Increase ‐$ 210,000 Hydrology and Hydraulic Modeling Schedule Extension Description – Subtask 2.I: Phase 7.1 Model Update: Update the Red River peak flow model geometry. Complete modeling for the Red River peak flood events, including the 10‐, 2‐, 1‐, 0.2‐percent chance events and the 103kcfs and PMF flood events for both existing conditions and with‐project conditions. Update tributary peak flow models with geometry developed in Task 1. Complete modeling‐for the 10‐, 2‐, 1‐, 0.2‐percent chance flood events for both existing conditions and with‐project conditions. Conduct a higher volume sensitivity analysis using the Red River peak flow geometry from Task 1 and the high volume hydrology developed as part of the Phase 5 unsteady modeling effort. Conduct QA/QC of Phase 7.1 modeling. Complete additional modeling and mapping tasks as part of the Phase 7.0 modeling effort. Background USACE continues to request additional assistance from the Diversion Authority for hydrology and hydraulic modeling. The above described work is creditable work‐in‐kind assistance. Cost = $130,000 Description – Subtask 2.J: Update PMF Study with Revised Distribution of Snowmelt Runoff: a. Update the USACA‐provided HMS model runs in conjunction with the GIS/HMS‐based runoffdetermination effort. Determine the order of HMS model simulations and account for the breakout flows between the various models. Coordinate between the HMS model simulations and RES‐SIM with USACE. Save Reservoir inflows for Traverse and Orwell in DSS and submit to USACE for simulation. Forward the regulated flow DSS records for inclusion into the RAS Model. b. Upon completion of the update to the Wild Rice River basin HMS model by USACE, perform final model runs. Perform work that can be accomplished in advance to prepare for the final HMS models runs. c. Use the HMS results as input for an updated unsteady HEC‐RAS model run for each storm centering. Complete the existing scope of work for the PMF study using the updated unsteady HEC‐RAS model runs. TASK_ORDER_SUMMARY‐07‐11‐2013‐REV2.DOCX 4 d. Prepare a report section documenting the GIS/HMS‐based runoff‐determination effort and comparing the 1985 PMF study to this current study, including input assumptions. Incorporate this draft report section into the overall current PMF study report. Background USACE continues to request additional assistance from the Diversion Authority for PMF modeling. The above described work is creditable work‐in‐kind assistance. Cost = $80,000 Recommendation: PMC recommends authorization of Task Order No. 9, Amendment 7 for $210,000. Item 6. FM Diversion Authority Fiscal Accountability Report Design Phase (Fund 790) As of 6/30/2013 Cumulative 2011 2012 2013 Totals Revenues City of Fargo 4 43,138 7,652,681 1,829,900 9,925,718 Cass County 4 43,138 7,652,681 1,829,900 9,925,718 City of Moorhead /Clay County 98,475 1,700,595 4 06,644 2,205,714 State Water Commission (10% Cap) ----Total Revenues 984,750 17,005,957 4,066,444 22,057,151 Expenditures 7905 Army Corp Payments --3 50,000 350,000 7910 WIK -Administration 1 07,301 331,321 1 07,121 545,743 7915 WIK -Project Design 1 49,632 5,366,147 5 56,319 6,072,098 7920 WIK -Project Management 6 79,037 7,223,650 2,489,139 10,391,826 7925 WIK -Recreation -163,223 -163,223 7930 LERRDS -North Dakota 48,664 3,843,620 5 61,240 4,453,524 7931 LERRDS -Minnesota -27,996 2,624 30,620 7940 WIK Mitigation -North Dakota ----7941 WIK Mitigation -Minnesota ---7950 Construction -North Dakota ----7951 Construction -Minnesota ----7955 Construction Management ----T:\Auditors\Finance\FM Diversion Authority\Reporting Financial Results\Cumulative Fiscal Accountability Report.xlsx 7990 Project Financing -50,000 -50,000 7995 Project Eligible -Off Formula Costs ----7999 Non Federal Participating Costs 116 --116 Total Expenditures 984,750 17,005,957 4,066,444 22,057,151 Item 6. FM Diversion Authority Operating Statement ‐June, FY 2013 Current Annual Current F‐Y‐T‐D FY Budget % Month 10/1‐9/30/13 10/1/12‐9/30/13 Expended Comments Revenues: City of Fargo $ 609,751 $ 5,748,495 $ 16,470,000 Cass County 609,751 5,748,495 16,470,000 City of Moorhead 135,500 1,277,442 3,660,000 State of North Dakota ‐‐‐State of Minnesota ‐‐‐Miscellaneous ‐‐‐Total Revenues $ 1,355,001 $ 12,774,431 $ 36,600,000 Expenditures: 7905 Army Corp Local Share 33‐42 Army Corp of Engineers 350,000 350,000 ‐Total Army Corp Local Share 350,000 350,000 ‐100% 7910 WIK ‐General & Administrative 33‐20 Accounting Services $ 260 $ 2,750 $ 10,000 33‐25 Legal Services 40,209 306,160 500,000 34‐55 Financial Advisor 30,000 30,000 ‐38‐99 Other Services 95 380 5,000 52‐30 General Liability Insurance ‐4,975 5,000 Total WIK ‐General & Administrative 70,564 344,264 525,000 66% 7915 WIK ‐Project Design 33‐05 Engineering Services 183,726 3,317,253 20,000,000 Total WIK ‐Project Design 183,726 3,317,253 20,000,000 17% 7920 WIK ‐Construction Management 33‐05 Engineering Services 176,165 728,343 ‐33‐06 Quality Testing ‐5,350 ‐33‐79 Project Management 414,471 4,517,882 7,600,000 Total WIK ‐Construction Management 590,637 5,251,575 7,600,000 69% 7925 WIK ‐Recreation 33‐05 Engineering Services ‐263 ‐Total WIK ‐Recreation ‐263 ‐100% 7930 LERRDS ‐North Dakota 33‐05 Engineering Services 159,910 2,141,089 5,000,000 33‐25 Legal Services ‐99,707 130,000 33‐91 Property Management ‐15,947 50,000 34‐65 Right of Entry Requests ‐35,290 65,000 61‐50 General Supplies /Postage ‐230 ‐71‐30 Land & Building Purchases ‐1,044,496 3,000,000 71‐31 Land Easements ‐25,000 ‐80‐17 Property Taxes /Special Assessments ‐91,658 100,000 Total LERRDS ‐North Dakota 159,910 3,453,417 8,345,000 41% 7931 LERRDS ‐Minnesota 33‐25 Legal Services ‐‐‐34‐65 Right of Entry Requests 164 7,659 10,000 Total LERRDS ‐Minnesota 164 7,659 10,000 77% 7990 Project Financing 34‐55 Financial Advisor ‐50,000 120,000 42% Total Project Financing ‐50,000 120,000 42% Total Expenditures $ 1,355,001 $ 12,774,431 $ 36,600,000 35% FM Diversion Authority Summary of Cash Disbursements Period June 2013 Date: 7/2/2013 Period/Year: 06/2013 Account Number Check Date Check Number Vendor Name Transaction Amount Description 1 Project Number Project Description 790-7905-429.33-42 6/19/2013 JB06130011 ARMY CORP OF ENGINEERS 3 50,000.00 COST SHARE -ARMY CORPS V01101 Army Corp Local Share Pmt Total Army Corp of Engineers $350,000.00 790-7910-429.33-20 6/30/2013 JB06130012 CITY OF FARGO 2 60.00 FISCAL SERVICES V00102 General & Admin. WIK Total Accounting Services $260.00 790-7910-429.33-25 6/20/2013 240575 DORSEY & WHITNEY LLP 21,936.50 LEGAL SVCS THRU 4/30/13 V00101 Dorsey Whitney Legal WIK 6/20/2013 240581 ERIK R JOHNSON & ASSOCIATES 7,161.68 METRO FLOOD PROJECT V00102 General & Admin. WIK 6/20/2013 240552 BRIGGS & MORGAN PA 11,111.20 METRO FLOOD CONTROL PROJ V00102 General & Admin. WIK Total Legal Services $40,209.38 790-7910-429.34-55 6/12/2013 240439 PFM PUBLIC FINANCIAL MANAGEMENT 30,000.00 JAN-MAR 2013 PROF FEES V00102 General & Admin. WIK Total Financial Advisor $30,000.00 790-7910-429.38-99 6/6/2013 240206 NORTH DAKOTA TLEPHONE CO 95.00 CONFERENCE CALL 4/26/2013 V00102 General & Admin. WIK Total Other Services $95.00 790-7915-429.33-05 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 23,399.40 3/1-31/13 V01603 CR-81 & I29 BRIDGE DESIGN 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 2,653.88 3/1-31/13 V01607 RECREATION/USE MASTER PLN 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 3,248.18 3/1-31/13 V01608 WORK-IN-KIND (WIK) 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 19,966.28 3/1-31/13 V01609 HYDROLOGY/HYDRAULIC MODEL 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 107,820.54 3/1-31/13 V01613 LEVEE DESIGN & SUPPORT 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 26,637.53 3/1-31/13 V01614 TRANS/DRAINAGE MASTER PLN Total Engineering Services $183,725.81 Page 1 FM Diversion Authority Summary of Cash Disbursements Period June 2013 Date: 7/2/2013 Period/Year: 06/2013 Account Number Check Date Check Number Vendor Name Transaction Amount Description 1 Project Number Project Description 790-7920-429.33-05 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 176,165.48 3/1-31/13 V01601 HMG -PROJECT MANAGEMENT Total Engineering Services $176,165.48 790-7920-429.33-79 6/26/2013 240726 CH2M HILL ENGINEERS INC 414,471.06 THRU 5/31/13 V00203 CH2M HILL -10/1-6/30/13 Total Project Management $414,471.06 790-7930-429.33-05 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 56,333.75 3/1-31/13 V01602 CR-31 BRIDGE DESIGN 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 4,276.57 3/1-31/13 V01604 CR-32 & CR-22 BRIDGE DSGN 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 38,843.30 3/1-31/13 V01604 CR-32 & CR-22 BRIDGE DSGN 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 26,048.38 3/1-31/13 V01606 LAND MANAGEMENT SERVICES 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 8,380.35 3/1-31/13 V01610 UTILITIES DESIGN 6/12/2013 240334 HOUSTON-MOORE GROUP LLC 26,028.10 3/1-31/13 V01611 REACH 6 & CR20 BRIDGE Total Engineering Services $159,910.45 790-7931-429.34-65 6/6/2013 240209 OHNSTAD TWICHELL PC 164.00 RIGHT OF ENTRY V01301 CityofMoorhead ROE Total Right of Entry Requests $164.00 Total Disbursed for Period $1,355,001.18 Page 2 FM Diversion Authority Outstanding Contracts As of June 30, 2013 Date: 7/2/2013 Project Number Account Number PO No. Vendor No. P.O. Date Vendor Name Encumbered Liquidated Balance V00101 790-7910-429.33-25 F12217 9367 12/31/2011 DORSEY & WHITNEY LLP 5 2,102.12 52,102.12 -V00101 790-7910-429.33-25 146629 9367 1/18/2012 DORSEY & WHITNEY LLP 5 2,679.63 52,679.63 -V00101 790-7910-429.33-25 F12289 9367 2/21/2012 DORSEY & WHITNEY LLP 5 8,693.38 58,693.38 -V00101 790-7910-429.33-25 F12293 9367 2/21/2012 DORSEY & WHITNEY LLP 1 ,600.00 1,600.00 -V00101 790-7910-429.33-25 156087 9367 10/15/2012 DORSEY & WHITNEY LLP 8 6,960.88 86,960.88 -V00101 790-7910-429.33-25 157021 9367 11/9/2012 DORSEY & WHITNEY LLP 2 7,111.94 27,111.94 -V00101 790-7910-429.33-25 157608 9367 11/29/2012 DORSEY & WHITNEY LLP 9 ,138.50 9,138.50 -V00101 790-7910-429.33-25 159215 9367 1/14/2013 DORSEY & WHITNEY LLP 1 5,177.50 15,177.50 -V00101 790-7910-429.33-25 160364 9367 2/20/2013 DORSEY & WHITNEY LLP 2 0,559.60 20,559.60 -V00101 790-7910-429.33-25 161130 9367 3/18/2013 DORSEY & WHITNEY LLP 1 0,442.50 10,442.50 -V00101 790-7910-429.33-25 163408 9367 6/12/2013 DORSEY & WHITNEY LLP 2 1,936.50 21,936.50 -V00102 790-7910-429.38-99 F11738 20660 11/15/2011 GALLAGHER BENEFIT SERVICES INC 2 50.00 250.00 -V00102 790-7910-429.31-10 F11749 646 11/15/2011 FORUM COMMUNICATIONS (ADVERT) 4 94.24 494.24 -V00102 790-7910-429.31-10 F11750 646 11/15/2011 FORUM COMMUNICATIONS (ADVERT) 3 45.97 345.97 -V00102 790-7910-429.31-10 F11751 646 11/15/2011 FORUM COMMUNICATIONS (ADVERT) 2 96.56 296.56 -V00102 790-7910-429.31-10 F11752 646 11/15/2011 FORUM COMMUNICATIONS (ADVERT) 1 7.05 17.05 -V00102 790-7999-729.68-30 PCARD 18009 12/20/2011 GOOGLE LOVEINTHEOVEN 1 16.00 116.00 -V00102 790-7910-429.31-10 F12082 647 12/31/2011 FORUM COMMUNICATIONS (LEGALS) 2 ,224.20 2,224.20 -V00102 790-7910-429.38-69 F12079 8645 12/31/2011 SEIGEL COMMUNICATIONS SERVICE 1 ,490.00 1,490.00 -V00102 790-7910-429.53-60 F12218 13981 12/31/2011 NORTH DAKOTA TELEPHONE CO 8 1.20 81.20 -V00102 790-7910-429.33-20 AJ COF 2/1/2012 CITY OF FARGO 1 ,300.00 1,300.00 -V00102 790-7910-429.55-10 F12256 20829 2/14/2012 BROKERAGE PRINTING 1 53.85 153.85 -V00102 790-7910-429.55-10 F12256 20829 2/14/2012 BROKERAGE PRINTING 2 02.10 202.10 -V00102 790-7910-429.52-30 F12595 1772 4/16/2012 WARNER & CO 4 ,975.00 4,975.00 -V00102 790-7910-429.33-20 AJ COF 5/25/2012 CITY OF FARGO 1 ,850.00 1,850.00 -V00102 790-7910-429.33-25 151789 16872 6/15/2012 ERIK R JOHNSON & ASSOCIATES 6 73.20 673.20 -V00102 790-7910-429.33-25 151876 16872 6/19/2012 ERIK R JOHNSON & ASSOCIATES 1 ,309.00 1,309.00 -V00102 790-7910-429.33-20 AJ COF 6/25/2012 CITY OF FARGO 3 40.00 340.00 -V00102 790-7910-429.33-25 152528 1286 7/10/2012 OHNSTAD TWICHELL PC 1 ,903.50 1,903.50 -V00102 790-7910-429.33-20 AJ COF 7/27/2012 CITY OF FARGO 2 40.00 240.00 -Page 1 FM Diversion Authority Outstanding Contracts As of June 30, 2013 Date: 7/2/2013 Project Number Account Number PO No. Vendor No. P.O. Date Vendor Name Encumbered Liquidated Balance V00102 790-7910-429.33-25 153237 1286 7/31/2012 OHNSTAD TWICHELL PC 7 28.50 728.50 -V00102 790-7910-429.38-99 153670 13981 8/9/2012 NORTH DAKOTA TELEPHONE CO 7 1.60 71.60 -V00102 790-7910-429.38-99 154211 13981 8/23/2012 NORTH DAKOTA TELEPHONE CO 9 0.60 90.60 -V00102 790-7910-429.33-20 AJ COF 8/30/2012 CITY OF FARGO 2 80.00 280.00 -V00102 790-7910-429.33-20 AJ COF 9/26/2012 CITY OF FARGO 3 20.00 320.00 -V00102 790-7910-429.38-99 155381 13981 9/27/2012 NORTH DAKOTA TELEPHONE CO 8 7.40 87.40 -V00102 790-7910-429.33-20 AJ COF 10/30/2012 CITY OF FARGO 4 10.00 410.00 -V00102 790-7910-429.33-20 AJ COF 11/28/2012 CITY OF FARGO 2 20.00 220.00 -V00102 790-7910-429.33-25 157670 16872 11/30/2012 ERIK R JOHNSON & ASSOCIATES 1 6,826.60 16,826.60 -V00102 790-7910-429.38-99 158387 13981 12/20/2012 NORTH DAKOTA TELEPHONE CO 7 6.20 76.20 -V00102 790-7910-429.33-20 AJ COF 12/27/2012 CITY OF FARGO 2 60.00 260.00 -V00102 790-7910-429.33-25 159214 16872 1/14/2013 ERIK R JOHNSON & ASSOCIATES 2 6,922.05 26,922.05 -V00102 790-7910-429.33-20 AJ COF 1/29/2013 CITY OF FARGO 1 60.00 160.00 -V00102 790-7910-429.33-20 AJ COF 1/29/2013 CITY OF FARGO 1 80.00 180.00 -V00102 790-7910-429.38-99 159926 12961 2/5/2013 FEDERAL EXPRESS CORPORATION 7 1.89 71.89 -V00102 790-7910-429.33-25 160367 16872 2/20/2013 ERIK R JOHNSON & ASSOCIATES 7 ,606.58 7,606.58 -V00102 790-7910-429.52-30 160461 1772 2/25/2013 WARNER & CO 4 ,975.00 4,975.00 -V00102 790-7910-429.33-20 AJ COF 2/27/2013 CITY OF FARGO 2 60.00 260.00 -V00102 790-7910-429.33-25 161131 16872 3/18/2013 ERIK R JOHNSON & ASSOCIATES 4 ,769.78 4,769.78 -V00102 790-7910-429.33-20 AJ COF 3/27/2013 CITY OF FARGO 2 00.00 200.00 -V00102 790-7910-429.33-25 161699 16872 4/8/2013 ERIK R JOHNSON & ASSOCIATES 2 ,366.41 2,366.41 -V00102 790-7910-429.38-99 161972 13981 4/17/2013 NORTH DAKOTA TELEPHONE CO 4 9.20 49.20 -V00102 790-7910-429.33-25 162044 14216 4/19/2013 BRIGGS & MORGAN PA 1 ,616.36 1,616.36 -V00102 790-7910-429.34-55 162074 21621 4/22/2013 PFM PUBLIC FINANCIAL MANAGEMEN 1 40,000.00 80,000.00 60,000.00 V00102 790-7910-429.33-20 AJ COF 4/26/2013 CITY OF FARGO 4 60.00 460.00 -V00102 790-7910-429.33-25 162703 16872 5/14/2013 ERIK R JOHNSON & ASSOCIATES 3 ,219.38 3,219.38 -V00102 790-7910-429.38-99 163136 13981 5/30/2013 NORTH DAKOTA TELEPHONE CO 9 5.00 95.00 -V00102 790-7910-429.33-20 AJ COF 5/31/2013 CITY OF FARGO 3 40.00 340.00 -V00102 790-7910-429.33-25 163409 16872 6/12/2013 ERIK R JOHNSON & ASSOCIATES 7 ,161.68 7,161.68 -V00102 790-7910-429.33-25 163410 14216 6/12/2013 BRIGGS & MORGAN PA 1 1,111.20 11,111.20 -Page 2 FM Diversion Authority Outstanding Contracts As of June 30, 2013 Date: 7/2/2013 Project Number Account Number PO No. Vendor No. P.O. Date Vendor Name Encumbered Liquidated Balance V00102 790-7910-429.33-20 AJ COF 6/30/2013 CITY OF FARGO 2 60.00 260.00 -V00201 790-7920-429.33-79 144170 20663 11/18/2011 CH2M HILL ENGINEERS INC 1 ,908,938.41 1,908,938.41 -V00202 790-7920-429.33-79 148611 20663 3/15/2012 CH2M HILL ENGINEERS INC 3 ,422,306.58 3,422,306.58 -V00203 790-7920-429.33-79 154940 20663 9/17/2012 CH2M HILL ENGINEERS INC 5 ,000,000.00 3,905,414.65 1,094,585.35 V00301 790-7910-429.38-69 143936 11604 11/16/2011 ADVANCED ENGINEERING INC 5 0,000.00 50,000.00 -V00401 790-7920-429.33-06 143937 165 11/16/2011 BRAUN INTERTEC CORP 5 4,060.00 43,620.00 10,440.00 V00501 790-7915-429.33-06 143938 165 11/16/2011 BRAUN INTERTEC CORP 3 6,150.00 34,009.00 2,141.00 V00601 790-7915-429.33-06 144975 20729 12/13/2011 IN SITU ENGINEERING 5 4,800.00 47,973.00 6,827.00 V00701 790-7915-429.33-05 144866 20723 12/9/2011 MINNESOTA DNR 3 46,100.00 346,100.00 -V00801 790-7915-429.33-05 146973 801 1/27/2012 HOUSTON ENGINEERING INC 9 2,424.03 92,424.03 -V00802 790-7915-429.33-05 146974 801 1/27/2012 HOUSTON ENGINEERING INC 7 0,742.30 70,742.30 -V00803 790-7915-429.33-05 146975 801 1/27/2012 HOUSTON ENGINEERING INC 4 7,124.46 47,124.46 -V00804 790-7925-429.33-05 148054 801 2/29/2012 HOUSTON ENGINEERING INC 1 63,222.91 163,222.91 -V00805 790-7915-429.33-05 148058 801 2/29/2012 HOUSTON ENGINEERING INC 9 4,786.00 94,786.00 -V00806 790-7915-429.33-05 148078 801 2/29/2012 HOUSTON ENGINEERING INC 1 08,369.87 108,369.87 -V00901 790-7915-429.33-05 146976 1118 1/27/2012 MOORE ENGINEERING INC 9 2,291.55 92,291.55 -V00902 790-7915-429.33-05 146977 1118 1/27/2012 MOORE ENGINEERING INC 1 35,231.99 135,231.99 -V00903 790-7915-429.33-05 146978 1118 1/27/2012 MOORE ENGINEERING INC 1 42,924.27 142,924.27 -V00904 790-7930-429.33-05 148055 1118 2/29/2012 MOORE ENGINEERING INC 7 8,760.62 78,760.62 -V00905 790-7930-429.33-05 148056 1118 2/29/2012 MOORE ENGINEERING INC 3 2,727.08 32,727.08 -V00906 790-7915-429.33-05 148057 1118 2/29/2012 MOORE ENGINEERING INC 8 ,326.50 8,326.50 -V00907 790-7915-429.33-05 148077 1118 2/29/2012 MOORE ENGINEERING INC 1 64,867.66 164,867.66 -V01002 790-7915-429.33-05 148086 17791 2/29/2012 URS CORPORATION 4 80,488.42 403,927.45 76,560.97 V01003 790-7915-429.33-05 163308 17791 6/6/2013 URS CORPORATION 4 95,000.00 -495,000.00 V01101 790-7905-429.33-42 AJ CORP 6/19/2013 ARMY CORP OF ENGINEERS 3 50,000.00 350,000.00 -V01201 790-7930-429.33-25 F12069 19734 12/31/2011 CASS COUNTY JOINT WATER RESOUR 1 6,708.86 16,708.86 -V01201 790-7930-429.34-65 F12069 19734 12/31/2011 CASS COUNTY JOINT WATER RESOUR 2 2,452.50 22,452.50 -V01201 790-7930-429-33-25 149405 19734 4/10/2012 CASS COUNTY JOINT WATER RESOUR 2 0,652.04 $20,652.04 -V01201 790-7930-429-34-65 149405 19734 4/10/2012 CASS COUNTY JOINT WATER RESOUR 6 2,467.05 $62,467.05 -V01201 790-7930-429-33-05 156814 19734 11/5/2012 CASS COUNTY JOINT WATER RESOUR 4 8,138.28 $48,138.28 -Page 3 FM Diversion Authority Outstanding Contracts As of June 30, 2013 Date: 7/2/2013 Project Number Account Number PO No. Vendor No. P.O. Date Vendor Name Encumbered Liquidated Balance V01201 790-7930-429-33-25 156814 19734 11/5/2012 CASS COUNTY JOINT WATER RESOUR 2 3,113.23 $23,113.23 -V01201 790-7930-429-34-65 156814 19734 11/5/2012 CASS COUNTY JOINT WATER RESOUR 8 ,250.00 $8,250.00 -V01201 790-7930-429-33-25 157055 19734 11/9/2012 CASS COUNTY JOINT WATER RESOUR 5 5,312.46 $55,312.46 -V01201 790-7930-429-34-65 157055 19734 11/9/2012 CASS COUNTY JOINT WATER RESOUR 2 6,500.00 $26,500.00 -V01201 790-7930-429-71-31 157055 19734 11/9/2012 CASS COUNTY JOINT WATER RESOUR 1 3,500.00 $13,500.00 -V01201 790-7930-429.61-50 160369 19734 2/20/2013 CASS COUNTY JOINT WATER RESOUR 2 4,990.57 24,990.57 -V01201 790-7930-429.71-31 161700 19734 4/8/2013 CASS COUNTY JOINT WATER RESOUR 5 2,735.94 52,735.94 -V01301 790-7915-429.33-05 147745 1118 2/17/2012 MOORE ENGINEERING INC 5 ,558.50 5,558.50 -V01301 790-7931-429.33-25 F12593 1286 4/16/2012 OHNSTAD TWICHELL PC 1 ,408.00 1,408.00 -V01301 790-7931-429.33-05 149869 1118 4/23/2012 MOORE ENGINEERING INC 1 ,780.00 1,780.00 -V01301 790-7931-429.33-25 150230 1286 5/3/2012 OHNSTAD TWICHELL PC 2 ,029.50 2,029.50 -V01301 790-7931-429.33-25 150961 1286 5/23/2012 OHNSTAD TWICHELL PC 2 20.50 220.50 -V01301 790-7931-429.33-25 151790 1122 6/15/2012 MOORHEAD, CITY OF 1 5,062.90 15,062.90 -V01301 790-7931-429.33-25 152058 1286 6/27/2012 OHNSTAD TWICHELL PC 4 10.00 410.00 -V01301 790-7931-429.33-25 154504 1286 9/4/2012 OHNSTAD TWICHELL PC 1 ,373.50 1,373.50 -V01301 790-7931-429.33-25 154505 1286 9/4/2012 OHNSTAD TWICHELL PC 6 76.50 676.50 -V01301 790-7931-429.33-25 156088 1286 10/15/2012 OHNSTAD TWICHELL PC 1 ,102.50 1,102.50 -V01301 790-7931-429.34-65 157054 1286 11/9/2012 OHNSTAD TWICHELL PC 2 ,685.00 2,685.00 -V01301 790-7931-429.34-65 159216 1286 1/14/2013 OHNSTAD TWICHELL PC 1 ,247.16 1,247.16 -V01301 790-7931-429.34-65 160365 1286 2/20/2013 OHNSTAD TWICHELL PC 1 ,148.00 1,148.00 -V01301 790-7931-7931-429.34-65 160797 1286 3/7/2013 OHNSTAD TWICHELL PC 7 38.00 738.00 -V01301 790-7931-429.34-65 161824 1286 4/11/2013 OHNSTAD TWICHELL PC 4 71.50 471.50 -V01301 790-7931-429.34-65 162447 1286 5/6/2013 OHNSTAD TWICHELL PC 1 02.50 102.50 -V01301 790-7931-429.34-65 163135 1286 5/30/2013 OHNSTAD TWICHELL PC 1 64.00 164.00 -V01501 790-7915-429.74-10 150960 19581 5/23/2012 GEOKON INC 3 3,815.36 33,815.36 -V01601 790-7920-429.33-05 151232 21007 5/31/2012 HOUSTON-MOORE GROUP LLC 2 ,072,675.00 1,149,816.48 922,858.52 V01602 790-7930-429.33-05 151233 21007 5/31/2012 HOUSTON-MOORE GROUP LLC 8 71,000.00 780,060.22 90,939.78 V01603 790-7915-429.33-05 151234 21007 5/31/2012 HOUSTON-MOORE GROUP LLC 2 ,333,300.00 2,253,084.71 80,215.29 V01604 790-7930-429.33-05 151235 21007 5/31/2012 HOUSTON-MOORE GROUP LLC 1 ,421,000.00 1,399,455.52 21,544.48 V01605 790-7915-429.33-05 151236 21007 5/31/2012 HOUSTON-MOORE GROUP LLC 9 05,000.00 845,983.45 59,016.55 Page 4 FM Diversion Authority Outstanding Contracts As of June 30, 2013 Date: 7/2/2013 Project Number Account Number PO No. Vendor No. P.O. Date Vendor Name Encumbered Liquidated Balance V01606 790-7930-429.33-05 151237 21007 5/31/2012 HOUSTON-MOORE GROUP LLC 5 38,103.00 357,335.02 180,767.98 V01607 790-7915-429.33-05 152022 21007 6/25/2012 HOUSTON-MOORE GROUP LLC 2 40,000.00 124,920.68 115,079.32 V01608 790-7915-429.33-05 152023 21007 6/25/2012 HOUSTON-MOORE GROUP LLC 7 27,330.00 477,033.98 250,296.02 V01609 790-7915-429.33-05 152024 21007 6/25/2012 HOUSTON-MOORE GROUP LLC 5 37,341.00 266,852.02 270,488.98 V01610 790-7930-429.33-05 152025 21007 6/25/2012 HOUSTON-MOORE GROUP LLC 2 88,000.00 51,600.75 236,399.25 V01611 790-7930-429.33-05 155529 21007 10/2/2012 HOUSTON-MOORE GROUP LLC 7 71,000.00 38,078.00 732,922.00 V01612 790-7930-429.33-05 155530 21007 10/2/2012 HOUSTON-MOORE GROUP LLC 6 65,000.00 -665,000.00 V01613 790-7915-429.33-05 157599 21007 11/29/2012 HOUSTON-MOORE GROUP LLC 5 75,000.00 345,201.92 229,798.08 V01614 790-7915-429.33-05 160644 21007 3/1/2013 HOUSTON-MOORE GROUP LLC 6 05,000.00 28,089.53 576,910.47 V01701 790-7930-429.71-30 155627 7198 10/3/2012 NORTHERN TITLE CO 4 84,016.00 484,016.00 -V01701 790-7930-429.80-17 159217 201 1/14/2013 CASS COUNTY TREASURER 8 4,832.36 84,832.36 -V01702 790-7930-429.71-30 157394 20529 11/21/2012 KENNELLY & OKEEFFE 2 16,401.85 216,401.85 -V01702 790-7930-429.71-30 157470 20529 11/26/2012 KENNELLY & OKEEFFE 3 42,601.87 342,601.87 -V01702 790-7930-429.71-30 F13677 11046 11/26/2012 RED RIVER TITLE SERVICES INC 2 50.00 250.00 -V01702 790-7930-429.71-30 F13678 11046 11/26/2012 RED RIVER TITLE SERVICES INC 1 70.00 170.00 -V01702 790-7930-429.71-30 158252 21423 12/18/2012 HUBER, STEVE 1 ,056.43 1,056.43 -V01702 790-7930-429.80-17 159217 201 1/14/2013 CASS COUNTY TREASURER 6 ,825.95 6,825.95 -V01801 790-7930-429.33-05 155531 1714 10/2/2012 ULTEIG ENGINEERS INC 1 00,000.00 -100,000.00 V01901 790-7930-429.33-05 155469 21258 10/1/2012 PROSOURCE TECHNOLOGIES, INC 1 00,000.00 -100,000.00 V02001 790-7930-429.33-91 157598 10078 11/29/2012 COLDWELL BANKER 4 ,346.77 4,346.77 -V02001 790-7930-429.33-91 158046 10078 12/12/2012 COLDWELL BANKER 8 ,000.00 8,000.00 -V02001 790-7930-429.33-91 160366 10078 2/20/2013 COLDWELL BANKER 2 ,600.00 2,600.00 -V02001 790-7930-429.33-91 161153 10078 3/18/2013 COLDWELL BANKER 1 ,000.00 1,000.00 -V02101 790-7930-429.33-05 157607 12775 11/29/2012 RED RIVER BASIN COMMISSION 5 00,000.00 52,775.00 447,225.00 V02201 790-7915-429.38-99 163309 18968 6/6/2013 US GEOLOGICAL SURVEY 4 6,920.00 -46,920.00 28,929,087.08 22,057,151.04 6,871,936.04 Page 5