Loading...
HomeMy WebLinkAbout39721; Municipal Golf Course "The Crossings at Carlsbad"; Municipal Golf Course "The Crossings at Carlsbad"; 2006-06-01City of Carlsbad Municipal Golf Course Project 7^ 39721 Monthly Status Report June 2006 Prepared by Dudek & Associates, Inc. DUDEKI & ASSOCIATES. INC. SCORECARD Hole l3ackTce Par Hole Uackl'ec Par 1 435 4 10 !46 4 2 377 4 II 393 4 3 412 4 i: 436 4 4 222 3 13 342 4 5 5S4 14 1.30 3 1) 440 J 15 541 5 7 527 5 16 ,540 5 S 160 3 17 192 9 355 4 IS 414 4 Out 3512 36 In \^^^ 36 Out 3512 36 Toial 6«46 72 CITY OF CARLSBAD MUNICIPAL GOLF COURSE Table of Contents Section 1: Mass Grading Contract > Executive Summary > Contract Status - Change Orders > Cash Flow Projection > Project Schedule > Potential Issues > Project Photographs Section 2: Golf Course Construction Contract > Executive Summary > Contract Status - Change Orders > Cash Flow Projection > Project Schedule > Potential Issues > Project Photographs Section 3: Golf Course Buildings Contrac > Executive Summary > Contract Status - Change Orders > Cash Flow Projection > Project Schedule > Potential Issues > Project Photographs Section 4: > Overall Golf Course Project Financials Section 1 - Mass Grading Contract No. 3972M General Contractor: Sema Construction 6 Orchard 7^150 Lake Forrest, CA 92630 Construction Start Date: September 8, 2005 DUDEK City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Executive Summary Work Summary for June The Grading Contractor continues to complete the punchlist item. Approximately 80% of the items on the list are complete with the remaining items scheduled for completion shortly. Staff is continuing to meet with the Contractor to close-out this project. Planned Work for July • Continue with punchlist work and close-out procedures. Contract Status -Change Orders Change Order No.7 has been prepared and is being reviewed by the Contractor. The Change Order increases contract Bid Items that have exceeded their estimated quantities listed in the Bid Schedule. The increase in quantities and cost were previously approved by the City Council in February 2006, Agenda BiU No. 13. The actual quantities have now been exceeded and this Change Order encumbers the funds to pay for the work. This Change Order is listed in the report as pending until it's executed. Cash Flow Projection There was no progress billing in June as there was very little work done, except punchlist work. We anticipate that there will be a July progress billing that will include Change Order No. 7. Project Schedule Work is substantially complete so there wUl be no further Baseline Schedule up-dates or 3-Week look Ahead Schedules. There has been no further discussion regarding a time extension. Staff anticipates any time extension requests to be negotiated with future Change Order requests. Potential Issues Staff is StiU evaluating a cost from Geogrid Retaining Wall System for the overflow parking lot. However, this work is on hold and wUl be addressed in future reports as the work gets closer. DUDEK & ASSOCIATES, INC. City of Carlsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Commercial Pad Crib WaU 6-15-06 DUDEK City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Project #39724 MASS GRADING CONTRACT STATUS/CHANGE ORDERS Original Contract Amount: Approved Change Orders: Revised Contract Amount; Percent Ciiange Orders (on Original Contract): Potential Change Orders (Estimate): Potential Revised Contract Amount: 7,721,463.48 2,827,918.43 10,549,381.91 36.62% 10,549,381.91 Description Approved Projected Project Total C lange Orders $ 7,721,463.48 1 Remedial Grading ($2.22 yd.) .'^ 932,400.00 $ 8,653,863.48 2 Increase SWPPP Measures ,$ 825,413.10 $ 9,479,276.58 5 Cap Archeological Site/Creek Crossing $ 48,192.33 $ 9,527,468.91 4 PVC Pipe Change/Clearing/Boxes $ (7,254.00) $ 9,520,214.91 5 Additional Sur\'eying $ 25,000.00 $ 9,545,214.91 6 Increase Compaction from 90% to 95% $ 224,000.00 $ 9,769,214.91 7* Adjustments to estimated quantities to reflect the actual quantities of materials instaUed in the field* $ 780,167.00 $ 10,549,381.91 Total Approved Change Orders: $ 2,827,918.43 Revised Contract Amount: $ 10,549,381.91 Pending Final Fxecution Potential Change Orders Estimate Total Estimated Potential Changes: $ Projected Budget (w/potential Changes): $ 10,549,381.91 City of Carlsbad Municipal Golf Course Project #3972 June 2006 Monthly Status Report Municipal Golf Course Project 3972-1 Contract 1 - Mass Grading Cash Flow Projection $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 .c^ .c^' Cb*' y y y y y y y ^ J .J ..J^' ^ ^ ^o^' # f 0 Monthly Projection • Monthly Actual City of Carlsbad Municiapl Golf Course Project #3972 June 2006 Monthly Status Report Section 2 - Golf Course Construction Contract No. 39721-2 General Contractor: Wadsworth Golf Construction Company 600 N. 195'^ Avenue Buckeye, AZ 85326 Construction Start Date: March 1, 2006 DUDEKI & ASSOCIATES, INC. City of Carlsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Executive Summary Work Summary for June Wadsworth GoU Construction Company (Wadsworth) continues to push hard on grassing the GoU Course. Another major mUestone was reached in June with the sprigging (grassing) of Holes #2, #3, #5, and #6. Grass is starting to grow and the Fairways are looking green. The Contractor is continuing with sod placement and Cart Path installation through out the course. The Contractor is scheduled to have the entire course grassed by September 1^', 2006. A GoU Hole is considered complete once the grass has grown for over fourteen days. The Architect made two site visits in June and approved several holes for grassing. Construction activities for the month included the following: • Approval of Holes #2, #3, #5, and #6 for grassing. • Completion of the irrigation system (flushing, cleaning and testing continues). • Completion of the Parson's Rock WaUs on the Golf Course • Continued sod placement for Holes M, #8, and #9. • Continued installation of Bunker Sand. • Continued Lake Liner installation and Pump Station construction. • Continued work on the Lake Waterfall feature on Hole • Continued with placement of concrete Cart Path. Planned Work for July • Irrigation, flushing, cleaning and testing. • Sprigging of GoU Holes #1, #4, #8, and #9. • Begin mitigation irrigation system. • Continue installation of sod on Holes #10 through M4. • Continue Lake Liner and Pump Station work. • Continue WaterfaU construction on Lake for Hole M. • Continue placement of concrete Cart Path. Contract Status- Change Orders Change Order No. 1, containing ten items, has been signed by the Contractor and distributed for execution. The total amount of the Change Order is $433,319.00 and represents 2.7 % of the contract amount. There are several other Potential Change Orders currently being reviewed by the CM Staff that will be converted to Change Order No. 2 next month. Cash Flow^ Projection Actual cash flow continues to outpace projections due to the fact that Wadsworth has made more progress than shown on the schedule. Based on Wadsworth's progress we expect this trend to continue. DUDEK & ASSOCIATES, INC. City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Project Schedule Wadsworth appears to be ahead of schedule according to their Baseline Schedule. Reaching another key mUestone date of sprigging the Holes reinforces this fact. Staff will continue to monitor progress. Potential Issues Staff is StiU deaUng with the fabrication schedules for Bridges B, C, D, and E. Bridges E and C have been approved and released for fabrication. However, a delivery date has not yet been provided by the Contractor. Once we have these dates the fuU impact to the schedule can be determined and reported. Staff expects the approval and release of Bridge B to occur next month. DUDEK i:^ ASSOCIATES, INC tsnmmnKma.uiimii City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Hole # 16 Bridge "E" Footing Construction 6-01-06 Hole # IB Rock Wall Construction New Green Location 6-13-06 DUDEKI City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Hole #18 Irrigation Lake Boulder Placement 6-13-06 DUDEK Hok #18 Irrigation Lake Boulder Placement 6-13-06 City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Hole # 9 Greg Nash Greenside Bunker Layout 6-22-06 DUDEK & ASSOCIATES, INC. Hole # 2 First Green Seeding 6-27-06 City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Hok # 2 Fairway Mechanical Planting Sprigs 6-29-06 DUDEK & ASSOCIATES. INC. Hole # 3 Hand Sprigging Tees 6-30-06 City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Project #3972-2 GOLF COURSE CONSTRUCTION CONTRACT STATUS/CHANGE ORDERS Original Contract Amount: Approved Change Orders: Revised Contract Amount: Percent Change Orders (on Original Contract): Potential Change Orders (Estimate): Potential Revised Contract Amount: 16,727,761.00 433,319.00 17,161,080.00 2.59% 47,311.08 17,208,391.08 Description Approved Projected Project Total C lange Orders $ 16,727,761.00 1* Club House Parking Lot Water Main Revisions, Hole 18 Change from PAR 3 to PAR 4, Drainage Pipe Change, Cart Path Fibermesh, Hole 7 Reshaping, SWPPP, Calloway Tree Additions, Additional Surveying, Additional Bunker Sand Work, Installation of Lateral Sewer Line from Comfort St. A' to Maintenance Bldg. $ 433,319.00 $ 17,161,080.00 Total Approved Change Orders: $ 433,319.00 Revised Contract Amount: $ 17,161,080.00 * Pending Final Execution Potential Change Orders Estimate Irrigation & Pump Station Changes % (50,000.00) Revise Grassing/Seed Placing .S (73,598.00) Bridge A' Modifications to Veneer $ J 7,534.36 Bridge A Foundation Changes •S J5,35500 Drainage on Trees - Oaks 36' & Larger % 124,649.48 Bridge E' Abutment i^^l Redesign $ 6,381.51 Bridge E' Rock Breaking at Abutment #2 $ 6,988.73 Total Estimated Potential Changes: $ 47,311.08 Projected Budget (w/potential Changes): $ 17,208,391.08 City of Carlsbad Municipal Golf Course Project #3972 June 2006 Monthly Status Report Municipal Golf Course Project 3972-2 Contract 2 - Golf Course Cash Flow Projection $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 y y y 0 Monthly Projection • Monthly Actual City of Carlsbad Municiapl Golf Course Project #3972 June 2006 Monthly Status Report Wadsvwjrth Goif Co- Carlsbar 3-wK Schedul •ctfon Co. .06 ID o Task Name Duration Start Finish 1 -i Shape DR and hole #18 3.2 wks " Fri 5/26/06 Fri 6/16/06 2 Irrigation 15,16 2.9 wks Thu 5/18/06 Wed 6/7/06 Wadsworth secondarv rougtl Irrigation front 9 8.5 wks Thu 6/18/06 Mon 7/17/06 Gms Dmg hole 16 4 days Thu 5/18/06 Tue 5/23/06 5 Zi Fnwy Dmg 18 11 days Mon 6/26/06 Mon 7/10/06 6 Gravel Blanlcet hole 18 3 days Fri 7/7/06 Tue 7/11/06 Root Zone mix installation Holes PG,8.10 13 days Mon 6/12/06 Wed 6/28/06 a Zi Root Zone mix installation Holes 11.12,14 15 days Mon 6/19/06 Fri 7/7/06 8 Zi intake line/wet well const, in* lake 10 days Tue 5/23/06 Mon 6/5/06 Lake 7 construction 6 wks Thu 5/18/06 Wed 6/28/06 11 Zi Concrete cart path form and pour frtjnt 9 5 wks Thu 5/18/06 Wed 6/21/06 12 Zi Parsons walls 6 wks Thu 5/18/06 Wed 6/28/06 13 Zi Bunker Construction front 9 3.4 wks Thu 5/18/06 Fri 6/9/06 14 Zi Tree Planting front 9 3.4 wks Thu 5/18/06 Fri 6/9/06 , IS Zi Irrigation Mitigation areas 5,6,4,3,2 5 wks Mon 5/22/06 Fri 6/23/06 16 Zi Grow/kill Mitigation areas 6 wks Mon 5/29/06 Fri 7/7/06 17 Zi Sod holes 5,6 6.5 days Tue 5/23/06 Wed 5/31/06 18 Sod Holes 2,3 3 days Tue 5/30/06 Thu 6/1/06 19 Zi Stolonize 2.3 8.5 days Tue 6/20/06 Fri 6/30/06 20 Zi Bridge "A" 7.4 wks Thu 5/18/06 Fri 7/7/06 21 Zi Bridge "6" 26 days Thu 6/1/06 Thu 7/6/06 ~22 Zi Bridge "C" 26 days7 Thu 6/1/06 Thu 7/6/06 23 Zi Bridge "D" 7777?77?77 27 days7 Wed 5/31/06 Thu 7/6/06 24 Zi Bridge "E" 40 days7 Mon 6/22/06 Fri 7/14/06 ^5 Zi Hyrdoseed Fescue Hole#6 3 days Wed 6/7/06 Fri 6/9/06 26 Zi Sod Hole 4 2 days Tue 6/6/06 Wed 6/7/06 27 Zi Concrete cari path fomi and pour back 9 11 days Wed 7/5/06 Wed 7/19/06 28 Zi Sod Holes 1.8.9 3 days Mon 6/26/06 Wed 6/26/06 29 !H3 Stolonize Holes 5.6 2 days Thu 7/6/06 Fri 7/7/06 ~56 -E3 Sod Hols PG Area 1 day Fri 7/7/06 Fri r/7/06 "31 m Seed greens 1,8,9 2 days Thu 7/13/06 Fri 7/14/06 Pump station deliverv & setup 5 days Tue 7/18/06 Mon 7/24/06 33 [13 Greensmix 13,14,15 3 days Mon 7/24/06 Wed 7/26/06 34 Irilgate Hole#18 & Driving Range 14 days Mon 7/10/06 Thu 7/27/06 •06 May21,'06 May28,'06 Jun 4,'06 Junl1,'06 Jun 18,'06 Jun 26,'06 WTFSSMTWT F S 8 M TWT F S S M TWT F 8 S MTWT F SS M TW T F SS M T WT |J|J|2.'06 _ FSSMTWTFS Jul 9, '06 S M T WT Jui 16, '00 FS S M TWT Jul 23, '06 F S S M TWT F • • Project: look ahead achedule Date: Thu 7/13/06 Task Split Progress Milestone Summary Project Summary Page 1 External Tasks Extemal Milestone ^ Section 3 - Golf Course Buildings Contract # 39721-^3 General Contractor: Jaynes Corporation 111 Elm Street, Fourth Floor San Diego, CA 92101-2649 Construction Start Date: November 1, 2005 DUDEK & ASSOCIATES, INC. City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Executive Summary Work Summarv for June Maintenance Building The Contractor is putting the finishing touches to the interior and exterior elements of the building. The interior of the building has been painted and tile is being placed in the bathrooms. The Contractor is waiting for door hardware to complete hanging the doors and begin flooring. The exterior EFIS plastering is complete and only the site work remains. Staff is working with Jaynes to complete an office so Kemper's Maintenance Superintendent can utilize it to work out of prior to final completion. Clubhouse Building The Contractor continues to erect structural steel for the building's towers. Steel stud framing is also continuing and most of the masonry block has been completed. The milestone of setting the buildings trusses on the East side has been reached. However, the West side building trusses are still outstanding. Once the trusses have been installed the building can be dryed-in allowing for interior finishing to begin. Planned Work for July Maintenance Building • Complete copper metal roofing system. • Complete exterior painting and finishing. • Complete instaUation of interior tile work in bathrooms. • Continue with exterior underground piping and flatwork. • Complete site concrete. Clubhouse Building • Continue with exterior underground piping. • Complete upper floor structural steel posts and columns. • Continue with Half-Way House construction. • Continue work on Comfort Stations "A" and "B". • Continue second floor metal wall stud framing. • Complete west side truss installation. Contract Status-Change Orders Change Order No. 1 has been prepared and executed. It contains nine items for an estimated total of $115,023.00 representing 1% of the overall contract value. There has been several other Potential Change Order (PCO) requests that have been converted to Change Order No. 2 that is currently under review. DUDEK & ASSOCIATES, INC. City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Cash Flow Projection When averaged over the first six months of the contract actual cash flow met projections. The CM Staff expects this trend to continue through-out the remainder of the project. Project Schedule Staff is waiting for the Contractor to up-date the schedule through the end of May which is expected to be submitted next month. It appears they're still about four weeks behind schedule. Meetings continue between the Contractor and CM Staff to review progress, confirm dates, and discuss delays and ways to expedite the project. The remaining key item will be the dehvery of the trusses for the second floor of the West side of the Clubhouse Building. If this can be expedited and installed earlier than estimated the Contractor can pick-up some time on the overall schedule. We'U report on this issue again next month. Potential Issues The potential issue mentioned last month regarding the wrong structural bid set is closer to being resolved regarding both time and schedule impacts. The Contractor has submitted three Potential Change Order requests from their structural metal supplier and Framing Contractor for a total amount of $80,000.00 that has been agreed to by CM Staff and will be included in Change Order No. 2. CM Staff was able to negotiate this down by about $20,000.00. The West side Clubhouse Budding trusses have had several issues. During the submittal process several discrepancies arose. The roof trusses were changed to Glue-lam beams, and most of the steel plate and connection details needed to be revised. Unfortunately, the submittal process for these trusses has taken over four months and has impacted the Building's completion schedule. At this time the full impact caused by the truss submittal is unknown and is still being evaluated. &t.'\SSOClATES, LNC. City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Clubhouse - Framing Golf Shop 6-28-06 Clubhouse - Window WaU at Golf Shop 6-28-06 DUDEK I & ASSOCIATES, INC. City of Carlsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report clubhouse - Roof over East Wing 6-28-06 Clubhouse - Framing Locker/Restrooms 6-28-06 DUDEK & ASSOCIATES, INC. City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Clubhouse - East Elevation 6-30-06 Clubhouse - South Elevation 6-30-06 DUDEK & ASSOCIATES, INC. City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Maintenance Bldg. - Exterior of Building Finished 6-30-06 Comfort Sta. "A" - From Palomar Point Way 6-30-06 DUDEK & ASSOCIATES, INC. City of Carlsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Project #3972-3 GOLF COURSE BUILDINGS CONTRACT STATUS/CHANGE ORDERS Original Contract Amount; Approved Change Orders; Revised Contract Amount; Percent Change Orders (on Original Contract); Potential Change Orders (Estimate); Potential Revised Contract Amount; $ 10,660,864.00 $ 114,792.00 $ 10,775,656.00 1.08% $ 140,682.00 $ 10,916,338.00 Description Approved Projected Project Total C lange Orders $ 10,660,864.00 1 Elevator Modification to Holeless, Modification to Parking Lot Structural Section, Add Concrete for Stepped Footing, Duct above west side of Club House Mechanical Room Door, H Vac Relocation, Modify Switchgear w/two Electric Meters @ Halfway House, $ 114,792.00 $ 10,775,656.00 Total Approved Change Orders: $ 114,792.00 Revised Contract Amount: $ 10,775,656.00 * Pending Final Execution * Potential Change Orders Estimate * Delta 8 Structural Changes $ 38,050.00 * Demo Rock and Perineter WaU Footing at Maintenance Building $ 1,012.00 * Window W2 Radius Adjustment $ 1,505.00 * Landscape Sleeve Damage $ 616.00 * Atmospheric Vent for Sewer Pump @ Halfway House Comfort Station B' $ 1,100.00 * Door Hardware Changes $ 11,283.00 * Substitution of Glu Lam Beams in lieu of Douglas Fir Rafters $ 3,349.00 * Provide 13 SEER AC Unit.s in I jcu of 10 SEER .\C Units $ 2,971.00 * Exterior Steel Columns - Clubhouse $ 12,166.00 * Maintenance Building Gas Meter Relocation $ 1,980.00 * Maintenance Bldg. Concrete Slabs & Parking Lot $ 58,006.00 * Sand Blasting of Glue-Lam Beam Trusses S 8,644.00 * Total Estimated Potential Changes; S 140,68200 * Projected Budget (w/potential Changes): $ 10,916,338.00 City of Carlsbad Municipal Golf Course Project #3972 June 2006 Monthly Status Report Municipal Golf Course Project 3972-3 Contract 3 - Buildings Cash Flow Projection $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $- 0 Monthly Projection • Monthly Actual City of Carlsbad Municiapl Golf Course Project #3972 June 2006 Monthly Status Report 6/6/2006 Carlsbad Golf Course Buildings Look Ahead Schedule * Activities on hold until plans are finalized. I*** Pending Excess Dirt removal and new lol r[nspection Required Activity Planned Weekend or Holiday Pending approved change I Rain Delay Section 4 Overall Golf Course Project Financials Contract ^ 3972M, 39721-2, and 39721-3 DUDEK & ASSOCIATES, INC. City of Cadsbad Municipal Golf Course Project # 3972 June 2006 Monthly Status Report Carlsbad Municipal Golf Course - Project 3972 Budget, Expenditures and Contracts through 6/30/2006 This table summarizes expenditures and contracts authorized as of the July 26, 2005 Agenda which approved the construction budget of the Golf Course in the amount of $45,320,789. Original budget and budget changes Original Estimate Increases (Decreases) Revised Budget Grading 7,721.463 $ 2,055,005 S (7,254) $ 9,769,214 Construction 16,727.761 $ 16,727,761 Buildings 10,661,052 $ 10,661,052 Construction contingency 1,755,514 2,943,954 (2,080,005) $ 2,619,465 Construction misc 5,855,000 25,000 S 5,880,000 Grow -in/preopening costs 1.100,000 $ 1,100,000 Start-up costs 1,500.000 $ 1,500,000 Total Estimated Cost $ 45,320,790 $ 5,023,959 $ (2,087,259) $ 48,257,490 A B c D E EXPENDITURES / Budget Total Contract Contract Remaining CONTRACTS Budget Expenditures / Oibligation Balance Budget (A - C - D) * Grading - SEMA Construction (US Bank-Escrow) $ 9,769,214 9,769,214 9,759,787 9,427 - * Construction - Wadsworth (California Bank & Trust) 16,727,761 16,727,761 5,684,700 11,045,061 - * Buildings - Jaynes Corporations (Califomia Bank) 10,661,052 10,661,052 6,045,407 4,615,645 - Contingency 2,619,463 2,619,465 --2,619,463 Subtotal Construction 39,777,490 39,777,490 21,489,894 15,668,133 2,619,463 * Construction management & miscellaneous 2,315,000 Dudek 1,500,000 902,092 597,908 * Geotechnical testing (1) 150,000 Tj Dixon & James Nelson (Artwork) 128,000 70,400 57,600 Simon Wong (inspection) 1,408 968 440 Engineering overhead 61,906 61,906 - Construction Analysts 2,880 2,880 - Misc. (shipping, copies, etc) 47,642 47,642 - Water Meters (estimate not in original budget) 500,000 161,411 338,589 Mark Mojado (San Louis Rey Band of Indians) 53,668 29,015 4,655 Testing Engineers 55,000 50,817 4,183 Subtotal construction management/support 2,465,000 2,330,504 1,327,128 1,003,375 134,496 * Design Team - construction phase services 250,000 250,000 Greg Nash 75,000 44,850 30,170 (75,000) I>3UgIas Frederikson Architects 85,000 72,722 12,278 (85,000) * Environmental monitoring and special studies 350,000 350,000 217,730 152,270 - * Utility fees 25,000 25,000 * SDG&E Undergrounding 1,150,000 1,150,000 * Furniture Fixtures Si Equipment 1,640,000 1,640,000 • Grow In and Pre-opening maintenance 1,100,000 1,100,000 Kemper Sports Management 140,000 19,677 120,525 (140,000) * Start-Up Budget to open and operate 1,500,000 1,500,000 Total Expenditures and Commitments $ 48,257,490 $ 42,757,994 $ 23,171,981 $ 16,966,550 $ 8,118,959 City of Carlsbad Municipal Golf Course Project 3972 June 2006 Monthly Status Report Carlsbad Municipal Golf Course Project Construction Contracts - Monthly Cash Flow Projection Cash Flow Projection by Month Month Mass Grading Contract Billings Golf Course Building Monthly Total Cumulative Total September - 2005 October - 2005 November - 2005 December - 2005 January - 2006 February - 2006 March - 2006 April - 2006 May - 2006 June - 2006 July - 2006 August - 2006 September - 2006 October - 2006 November - 2006 December - 2006 January - 2007 February - 2007 March - 2007 1,700,000.00 1,100,000.00 1,500,000.00 1,500,000.00 900,000.00 500,000.00 521,463.48 300,000.00 700,000.00 1,000,000.00 1,500,000.00 2,000,000.00 2,000,000.00 2,500,000.00 2,500,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 727,761.00 - 500,000.00 1.100,000.00 1,100,000.00 800,000.00 800,000.00 1,000,000.00 1,200,000.00 1,000,000.00 1,000,000.00 800,000.00 700,000.00 660,864.00 1,700,000.00 1,100,000.00 2,000,000.00 2,600,000.00 2,000,000.00 1,600,000.00 2,021,463.48 2,000,000.00 2,700,000.00 3,000,000.00 3,000,000.00 3,300,000.00 3,200,000.00 1,660,864.00 1,000,000.00 1,000,000.00 1,000,000.00 727,761.00 1,700,000.00 2,800,000.00 4,800,000.00 7,400,000.00 9,400,000.00 11,000,000.00 13,021,463.48 15,021,463.48 17,721,463.48 20,721,463.48 23,721,463.48 27,021,463.48 30,221,463.48 31,882,327.48 32,882,327.48 33,882,327.48 34,882,327.48 35,610,088.48 35,610,088.48 35,610,088.48 35,610,088.48 35,610,088.48 35,610,088.48 Totals: 7,721,463.48 17,227.761.00 $ 10,660,864.00 Contract Values: 1. Mass Grading: $ 7,721,463.48 2. GolfCour.se: $ 17,227,761.00 3. Buildings: $ 10,660,864.00 City of Carlsbad Mumcipal Golf Course Project # 3972 June 2006 Monthly Status Report