Question: The attached Excel file provides progress info for project tasks as of March 31, 2012: The attached MS Project file includes the project baseline, after

The attached Excel file provides progress info for project tasks as of March 31, 2012: The attached MS Project file includes the project baseline, after the scope change from week 3:

First, set the Status Date in MS Project to March 31, 2012. Then input the "Actual" task information for each task.

Use the MS Project file you just updated to assess project performance in terms of cost and schedule. write a status report which summarizes your findings.

Include in your report the following sections/information:

  1. Executive summary
  2. Current status with respect to schedule performance.
  3. Current status with respect to cost performance.
  4. Use the MS Project views which include CV, SV, CPI, SPI, EAC, and Tracking Gantt to aid in your analysis.
  5. Does the project require action, given the status as of March 31, 2012? Why or why not? If your assessment concludes action is required, there is no need to generate recovery options/alternatives to generate a recovery plan.
The attached Excel file provides progress info for project tasks as ofMarch 31, 2012: The attached MS Project file includes the project baseline,

POM+ Status information March 31, 2012 Activity % complete Actual Start Actual Finish Actual Duration Remaining Duration Notes/Comments 1.1.1 Need survey 100% 1/3/2012 2/2/2012 22 1.1.2 Set Product Specs 100% 2/3/2012 2/28/2012 18 1.1.3 Shelf Life Report 100% 2/29/2012 3/13/2012 10 1.1.4 Nutrition Report 100% 3/14/2012 3/19/2012 4 1.2 Secure Fruit Suppliers 45% 3/20/2012 11 On track 1.3 Order new production equipment 100% 2/29/2012 3/1/2012 2 Actual equipment cost: $885,000 + freight cost of $7,000 1.4 Obtain state/local regulatory permits 100% 3/2/2012 3/5/2012 1.6.1 Market Testing 30% 3/20/2012 21 On track1 Pom+ Project 152 days $2,111,100.00 $0.00 . 1.1 R&D Product Development 50 days $150,400.00 $0.00 1.1.1 Need survey 20 days $64,000.00 $0.00 MRKT [500%] 1.1.2 Set product specs 15 days $57,600.00 $0.00 MRKT [200%],R&D [400%] 1.1.3 Shelf life report 10 days $19,200.00 $0.00 R&D[300%] 1.1.4 Nutrition report 5 days $9,600.00 $0.00 R&D[300%] 1.2 Secure fruit suppliers 20 days $9,600.00 $0.00 PUIRCH 1.3 Order new production 3 days $908,380.00 $905,500.00 HE ($cope Change), Purchasing Manager(SC) equipment 1.4 Obtain State/Local 2 days $5,300.00 $0.00 Attorney regulatory permits 1.5 Initial Production 69 days $503,820.00 $0.00 1.5.1 Install New Production 14 days $33,420.00 $0.00 Equipment 1.5.1.1 New production 1 day $640.00 $0.00 IE Scope Change) equipment delivery 1.5.1.2 Electrical Work 4 days $14,460.00 $0.00 Master Electrician, IE (Scope Change), Electric Materials[1] 1.5.1.3 Remove old and 6 days $14,640.00 $0.00 IE (Scope Change), Installation Labor SC[500%], Installation Materials SC[1] retrofit new production 1.5.1.4 Installation test 2 days $2,880.00 $0.00 Operations Manager SC,IE (Scope Change) 1.5.1.5 Installation accepta 1 day $800.00 $0.00 Operations Manager SC 1.5.2 production trials 15 days $235,200.00 $0.00 PROD[1,500%], PURCH,ENG[1,000%] 1.5.3 Quality trials 20 days $86,400.00 $0.00 QUAL[300%], PROD [500%] 1.5.4 Quality metrics 5 days $12,000.00 $0.00 QUAL[300%], PROD 1.5.5 Quality training 15 days $136,800.00 $0.00 QUAL[300%],PROD[1,500%] 1.6 Distribution 70 days $207,200.00 $0.00 1.6.1 Market testing 30 days $96,000.00 $0.00 MRKT [500%] 1.6.2 Package design 15 days $31,200.00 $0.00 MRKT, DESIGN[300%] 1.6.3 Select distributors 25 days $80,000.00 $0.00 MRKT[500%] . 1.7 Legal 20 days $57,600.00 $0.00 1.7.1 Complete FDA certificat 15 days $43,200.00 $0.00 LEGAL[300%] 1.7.2 Register trademark 5 days $14,400.00 $0.00 LEGAL [300%] 1.8 Prepare Product Launch 15 days $268,800.00 $0.00 QUAL[300%],PROD[1,500%],PURCH[200%],ENG[

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!