Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.
image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management Planning And Control Techniques

Authors: Rory Burke

3rd Edition

047198762X, 9780471987628

More Books

Students also viewed these General Management questions

Question

Self-confidence

Answered: 1 week ago

Question

The number of people commenting on the statement

Answered: 1 week ago