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. write a status report that summarizes your findings. Include in your reportthe following deliverables:

1. Executive summary
2. Current status with respect to schedule performance
3. Current status with respect to cost performance
4. Use the MSP views that include CV, SV, CPI, SPI, EAC, and tracking Gantt to aid in your analysis
5. 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.)
6. 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.

Task _ Duration 1.5.3 Quality trials 20 days 1.5.4 Quality metrics 5 days 1.5.5 Quality training 15 days I 1.6 Distribution 70 days 1.6.1 Market testing 30 days 1.62 Package design 15 days 1.5.3 Select distributors 25 days I 1.7 Legal 20 days 1.7.1 Complete FDA certification 15 days 1.12 Register trademark 5 days 1.8 Prepare Product Launch 15 days 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 thisl) crash time = 10 clays S 136,800 5 9,120 5 15,000 5 5,880 Crash time = 25 days S 96,000 S 3,200 5 5,000 3 1,800 crash time : 12 days 5 31,200 5 2,080 $ 3,000 5 920 crash time = 20 days 5 30,000 5 3,200 5 4,500 5 1,300 crash time : 12 days 5 258,800 5 17,920 $ 22,000 $ 4,050 A quick 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 $9,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 an assigned resources for the task one less day, with a cost of $9,120. The net cost becomes $15,000 less 59,120 = $5,880 per clay. will use our POM+ Status Update | April 30, 2012 WBS - Task Name/Description % Complete Actual Start Actual Finish Actual Duration 1.2 Secure Fruit suppliers 100% 3f20f2012 4f27f2012 29 1.5.1 Market Testing 100% 3:20:2012 4330:2012 30 1.5.1.1 New production equipment deliveryr 100% 4f13f2012 4f13f2012 1 1.5.1.2 Electrical work 100% 411712012 4;23;2012 5 1.5.1.3 Remove old and retrofit new prod equip 100% 4f24f'2012 4f30f2012 5 Total Cost . Baseline Variance Actual Remaining . CPI SP Duration Add New Column 2009 2014 2,112,640.00 $2,111,100.00 $1,540.00 1,098,740.00 1,013,900.00 1 0.99 156 days $166,400.00 $150,400.00 $16,000.00 $166,400.00 $0.00 0.9 1 54 days n $70,400.00 $64,000.00 $6,400.00 $70,400.00 $0.00 0.91 1 22 days MRKT[500%] UI D W I $69,120.00 $57,600.00 $11,520.00 $69,120.00 $0.00 0.83 1 18 days MRKT[200%],R&D[400%] $19,200.00 $19,200.00 $0.00 $19,200.00 $0.00 1 1 10 days R&D[300%] 6 $7,680.00 $9,600.00 ($1,920.00) $7,680.00 $0.00 1.25 1 4 days R&D [300%] $9,600.00 $9,600.00 $0.00 $4,320.00 $5,280.00 1 0.69 20 days FURCH CO V $893,920.00 $908,380.00 ($14,460.00) $893,920.00 $0.00 1.02 1 2 days IE (Scope Change), Purchasing Manager(SC) $5,300.00 $5,300.00 $0.00 $5,300.00 $0.00 1 1 2 days Attorney ... . .... 10 $503,820.00 $503,820.00 $0.00 $0.00 $503,820.00 0 69 days 11 $33,420.00 $33,420.00 $0.00 $0.00 $33,420.00 0 14 days .. .. . . ..... 17 $640.00 $640.00 $0.00 $0.00 $640.00 0 0 1 day IE (Scope Change) 13 $14,460.00 $14,460.00 $0.00 $0.00 $14,460.00 0 4 days Master Electrician, IE (Scope Change), Electric M oo 14 $14,640.00 $14,640.00 $0.00 $0.00 $14,640.00 0 6 days IE (Scope Change), Installation Labor SC[500%], 15 $2,880.00 $2,880.00 $0.00 $0.00 $2,880.00 0 2 days Operations Manager SC,IE (Scope Change) 16 $800.00 $800.00 $0.00 $0.00 $800.00 0 1 day Operations Manager SC 17 $235,200.00 $235,200.00 $0.00 $0.00 $235,200.00 0 15 days PROD[1,500%],PURCH,ENG[1,000%] 18 $86,400.00 $86,400.00 $0.00 $0.00 $86,400.00 0 20 days QUAL[300%],PROD[500%] 19 $12,000.00 $12,000.00 $0.00 $0.00 $12,000.00 0 5 days QUAL[300%],PROD 20 $136,800.00 $136,800.00 $0.00 $0.00 $136,800.00 0 15 days QUAL[300%],PROD[1,500%] 21 $207,200.00 $207,200.00 $0.00 $28,800.00 $178,400.00 0.69 70 days O O O O O O H H OOOOOO 22 $96,000.00 $96,000.00 $0.00 $28,800.00 $67,200.00 0.69 30 days MRKT [500%] 23 $31,200.00 $31,200.00 $0.00 $0.00 $31,200.00 0 15 days MRKT,DESIGN[300%] 24 $80,000.00 $80,000.00 $0.00 $0.00 $80,000.00 0 25 days MRKT [500%] 25 $57,600.00 $57,600.00 $0.00 $0.00 $57,600.00 0 20 days 26 $43,200.00 $43,200.00 $0.00 $0.00 $43,200.00 0 15 days LEGAL[300%] 27 $14,400.00 $14,400.00 $0.00 $0.00 $14,400.00 0 5 days LEGAL[300%] 28 $268,800.00 $268,800.00 $0.00 $0.00 $268,800.00 0 15 days QUAL[300%],PROD[1,500%],PURCH[200%],1