Please show all work

Background In November 2003 Ace Builders (your employer) was awarded a contract for the renovation of Shea Stadium to house the New York Mets. An artist rendition of the proposed renovations is shown in Figure 1. Figure 1. Proposed stadium for the New York Mets The construction must start on January 14, 2004 and must be completed within fifteen months. Liquidated damages (penalty clause) of $250,000 per calendar day of delay beyond March 31 , 2005 is written into the contract. On the other hand Ace will receive an Early Completion Bonus of $100,000 per day for each workday the project is completed before March 31, 2005. In order to meet this aggressive schedule, the project will require around the clock construction crews, detailed project management, good construction weather, and some modern construction techniques. The project will begin with mobilizing equipment, preparing a staging area, and some minor demolition work - activities that are expected to last approximately eight weeks. Once the site is ready and all equipm ent mobilized, the work can start simultaneously on both the structure and the playing field. The work in the field involves excavation for installation of a new subsurface irrigation, drainage and heating facilities. This activity is followed by actual installation of water and drain pipes, valves, heating and control circuits, etc. Installation of the subsurface facilities (fourteen weeks) is followed by filling of the playing field and track. Only with the completion of the backfill material needed for the drainage systems (four weeks) can the installation of the artificial playing turf take place, an activity that consumes six weeks. The work on the structure itself starts with excavation and foundation preparation (four weeks) followed by the pouring of concrete footings (six weeks). Next comes the pouring of supports for box seats, faade, and luxury boxes (ten weeks), followed by erecting pre-cast concrete facade and the luxury boxes (sixteen weeks). Finish work on the boxes will be accomplished over the next five weeks. The roof must be erected on a steel structure that takes approximately four weeks to install. Prefebrication of the work will also take 4 weeks. Once the dressing rooms, office are erected, work can start simultaneously on the lights (seven weeks) and on the scoreboard (five weeks). The date on which the project is scheduled to start, falls on a Wednesday. The contractor has bid this job with 5 -day workweeks. Part III Now it is December 10,2004. The weather has been favorable and so Ace Builders did not face any problem with a strike or bad weather. Up-to-date information for the Stadium Project is given in Table 2. You must develop a status report for Mr. Brown using standard evaluation "figures of merit" such as BCWS, ACWP, BCWP, EAC and the performance SPI and CPI indexes. SYS 612 - Project Management of Complex Systems There is a project evaluation meeting next week. You are supposed to make a presentation about the current status of the project. You will also talk about what you have done so far. Deliverables for Project Evaluation Meeting 1. Analyze the current schedule status of the project using Excel. Calculate the SPI. Is the project ahead, on or behind schedule? 2. Analyze the current cost status of the project. Calculate the CPI. Is the project under, on or over budget? Write a two-page executive summary on the general status of this project. Use figures and statistics to back up you assessment (This is Part III of Homework II). Based on current status, what is the projected EAC? Completion date? The remaining critical path Table 2. Project status as of December 10, 20041