Attached Files: 3 POM+_Week6_Updated (1).mpp & (421.5KB) (3 POM+_CrashingData.xIsx &) (26.418 KB) 3 POM+ Status Update Information_4.30.2012.xIsx &y (10.886 KB) The attached Excel file provides progress information/updates for project tasks as of April 30, 2012. The file in Step 6 (below) provides the crashing data. The attached Project file includes the project file following status update at March 31, which you did in Week 6. Step 1: set the Status Date to April 30, 2012. Then input the actual task info for each task. Use the task status info and MS Project to assess project performance in terms of cost and schedule. Prepare a status report that summarizes your findings. Include in your report the following deliverables: . Executive summary not to exceed 1 page in length . Current status with respect to schedule performance . Current status with respect to cost performance . Use the MSP views that include CV, SV, CPI, SPI, EAC, and tracking Gantt to aid in your analysis . Does the project require action given the status at April 30, 2012? Why or why not? (You do not need to develop a project recovery plan for this step.) . Use the attached Excel file that includes information to shorten project duration for completion by July 31, 2012. Provide the steps necessary to complete the POM+ project by July 31, 2012. Provide which tasks to shorten and the added cost to shorten. 7. To wrap up the assignment, provide the new completion date and project cost. U R WN = A B C | L E POM+ Status Update | April 30, 2012 _ WBS - Task Name/Description % Complete Actual Start Actual Finish Actual Duration 1.2 Secure Fruit suppliers 100% 3/20/2012 A/2772012 29 ;1.5.1 Market Testing 100% 3/20/2012 4/30/2012 30 1.5.1.1 New production equipment delivery 100% 4/13/2012 41372012 1 1.5.1.2 Electrical work 100% 41772012 4/23/2012 5 1.5.1.3 Remove old and retrofit new prod equip 100% A4/24/2012 4302012 5 e e W00~ |0 |[w & [wW M= [~ Task ~ Duration 1.5.3 Quality trials 20 days 1.5.4 Quality metrics 5 days 1.5.5 Quality training 15 days 4 1,6 Distribution 70 days 1.6.1 Market testing 30 days 1.6.2 Package design 15 days 1.6.3 Select distributors 25 days 4 1.7 Legal 20 days 1.7.1 Complete FDA certification 15 days 1.7.2 Register trademark 5 days 1.8 Prepare Product Launch 15 days C D E F G Options to shorten project duration Task Cost | Task Cost/Day Contract Cost/Day | Net Daily Cost to Crash For 1.5.3 - Quality Trials, use lag notation, 1755+ 10 (Hint: use this!) crash time = 10 days .l $ 136,800 9,120 | 15,000 | 5,880 Crash time =25 days 3 96,0003 3,200 $ 5,000 | 1,800 crash time =12 days $ 31,200 |5 2,080 $ 3,000 | 5 920 crash time = 20 days $ 80,000 |5 3,200 $ 4,500 | 5 1,300 crash time =12 days $ 268,800 | S 17,920 22,000 | 4,080 A guick supporting note about the Net Daily Cost to Crash (shorten a task's duration): Look at 1.5.5 - Quality Training. Duration is 15 days and task cost is $136,800, so the daily cost of our assigned resources is $3,120. We can shorten the task by using contract services with a daily cost of $15,000. If we shorten by one day, we incur the $15,000 in contract costs and will use our assigned resources for the task one less day, with a cost of $9,120. The net cost becomes $15,000 less $9,120 = $5,830 per day