I have already completed parts 1-3 of the Red Zuma Project - just do not understand this part. Please answer/upload the answers in a way that I will be able to understand and use for the project. e-mail is allie.mckenna22@aol.com

Part 4

Part A

Today's date is July 8, 2015, the milestone date for the completion of the Prototype. You are charged with preparing a status report for top management. Table A2.8 summarizes progress on the Red Zuma project:

TABLE A2.8 Red Zuma Project Update

	Task Name	Act. Start	Act. Finish	% Comp.	Phys. % Comp.	Act. Dur.	Rem. Dur.
1	1 Red Zuma	Fri 1/9/15	NA	46%	0%	125.85 days	146.4 days
2	1.1 Market Analysis	Fri 1/9/15	Thu 2/12/15	100%	0%	25 days	0 days
3	1.2 Product Design	Fri 2/13/15	Wed 4/1/15	100%	0%	35 days	0 days
4	1.3 Manufacturing Study	Fri 2/13/15	Fri 3/6/15	100%	0%	16 days	0 days
5	1.4 Product Design Selection	Thu 4/2/15	Fri 4/17/15	100%	0%	13 days	0 days
6	1.5 Detailed Marketing Plan	NA	NA	0%	0%	0 days	15 days
7	1.6 Manufacturing Process	NA	NA	0%	0%	0 days	30 days
8	1.7 Detailed Product Design	Mon 4/20/15	Wed 6/24/15	100%	0%	49 days	0 days
9	1.8 Build Prototypes	Wed 6/10/15	NA	39%	0%	9 days	14 days
10	1.9 Lab Test Prototypes	NA	NA	0%	0%	0 days	10 days
11	1.10 Field Test Prototypes	NA	NA	0%	0%	0 days	15 days
12	1.11 Finalized Product Design	NA	NA	0%	0%	0 days	20 days
13	1.12 Final Manufacturing Process	NA	NA	0%	0%	0 days	10 days
14	1.13 Order Components	NA	NA	0%	0%	0 days	7 days
15	1.14 Order Production Equipment	NA	NA	0%	0%	0 days	14 days
16	1.15 Install Production Equipment	NA	NA	0%	0%	0 days	35 days
17	1.16 Celebrate	NA	NA	0%	0%	0 days	1 days

Submit a professional status report to Robin Lane that addresses the following questions:

How is the project progressing in terms of cost and schedule?

What activities have gone well? What activities have not gone well?

How much of the project has been accomplished (PCIB)?

What is the forecasted cost at completion (EAC_f)?

What is the estimated completion date?

How is the project doing in terms of priorities (see Part 1)?

Report and interpret relevant Earned Value metrics in your report.

Include a Tracking Gantt chart as well as an Earned Value Table with your memo.

Page 651

Part B

You have told Robin Lane that based on what you know now you need to revise the estimates for some of the remaining activities. Detailed Product Design is expected to take 3 days longer than planned. Build Prototypes is expected to take 2 days less than planned and Finalized Product Design is expected to take 3 days longer than planned. Final Manufacturing Process is expected to take 2 days less than planned, while Install Production Equipment is now expected to take only 30 days. You also report that Detailed Marketing plan will be completed before the end of the New Year. She is insisting that the project be completed by January 17th in order to be ready for the Las Vegas show. She is willing to spend $50,000 from Management Reserves to expedite shipping if necessary. $25,000 would reduce the shipping of components by 5 days and/or $25,000 would reduce the shipping of manufacturing parts by 5 days (Hint: Adjust lag). Prepare a memo to Robin that addresses the following questions:

What is the impact of the revised estimates for Finalized Product Design and Install Production Equipment on the project schedule and cost?

Would you recommend authorizing the expenditure of $50,000? Explain.

What, if any other recommendations, would you make so that the project can achieve Robin's deadline? Justify your recommendations.

Include a Tracking Gantt chart with variance schedule that depicts your final recommendations and revised schedule.

Hint: After adjusting the Installation of Production Equipment and Finalized Product Design, level outside of slack to eliminate any resource over allocation problems.

Parts 1 Data from my file is below

Task Mode Task Name ree Total Late Start Late Finish Slack Slack Add New Column 1 Red Zuma Project 1.1 Market Analysis 1.2 Product Design 1.3 Manufacturing Study 1.4 Product Design Selection 1.5 Detailed Marketing Plan 1.6 Manufacturing Process 1.7 Detailed Product Design 1.8 Build Prototypes 1.9 Lab Test Prototypes 1.10 Field Test Prototypes 1.11 Finalized Product Design 1.12 Final Manufacturing Process Tue 1/5/16 Tue 1/19/16 Tue 1/5/16 1.13 Order Components 1.14 Order Product Equipment 1.15 Install Production Equipment Mon 3/21/16 Mon 5/9/16 Mon 3/21/16 1.16 Celebrate Fri 1/2/15 Tue 1/12/16 Mon 5/4/15 Tue 5/10/16 85 days 85 days Fri 1/2/15 Mon 2/9/15 Fri 1/2/15 Mon 2/9/15 0 days days Mon 2/9/15 Wed 7/29/15 Mon 2/9/15 Wed 7/29/15 0 days 0 days Mon 2/9/15 Mon 3/9/15 Tue 6/30/15 Wed 7/29/15 100 days 100 days Wed 7/29/15 Wed 8/12/15 Wed 7/29/15 Wed 8/12/15 0 days0 days Wed 8/12/15 Wed 9/2/15 Mon 4/18/16 Mon 5/9/16 174 days 174 days Wed 8/12/15 Fri 11/27/15 Wed 8/26/15 Fri 12/11/15 10 days 10 days Wed 8/12/15 Thu 10/15/15 Wed 8/12/15 Thu 10/15/15 days days Thu 9/24/15 Thu 11/19/15 Thu 9/24/15 Thu 11/19/15 days 0 days Thu 11/19/15 Fri 12/11/15 Thu 11/19/15 Fri 12/11/15 days0 days Thu 11/19/15 Fri 12/11/15 Thu 11/19/15 Fri 12/11/15 days0 days Fri 12/11/15 Tue 1/12/16 Fri 12/11/15 Tue 1/12/16 days 0 days days 0 days 22 days 22 days days 0 days days days 0 days Tue 1/19/16 Tue 1/12/16 Thu 1/21/16 Thu 2/11/16 Mon 2/22/16 Tue 1/19/16 Mon 2/8/16 Tue 1/19/16 Mon 2/8/16 Mon 5/9/16 Tue 5/10/16 14 17 Mon 5/9/16 Tue 5/10/16 Mon 5/9/16 0 days Task Mode Task Name ree Total Late Start Late Finish Slack Slack Add New Column 1 Red Zuma Project 1.1 Market Analysis 1.2 Product Design 1.3 Manufacturing Study 1.4 Product Design Selection 1.5 Detailed Marketing Plan 1.6 Manufacturing Process 1.7 Detailed Product Design 1.8 Build Prototypes 1.9 Lab Test Prototypes 1.10 Field Test Prototypes 1.11 Finalized Product Design 1.12 Final Manufacturing Process Tue 1/5/16 Tue 1/19/16 Tue 1/5/16 1.13 Order Components 1.14 Order Product Equipment 1.15 Install Production Equipment Mon 3/21/16 Mon 5/9/16 Mon 3/21/16 1.16 Celebrate Fri 1/2/15 Tue 1/12/16 Mon 5/4/15 Tue 5/10/16 85 days 85 days Fri 1/2/15 Mon 2/9/15 Fri 1/2/15 Mon 2/9/15 0 days days Mon 2/9/15 Wed 7/29/15 Mon 2/9/15 Wed 7/29/15 0 days 0 days Mon 2/9/15 Mon 3/9/15 Tue 6/30/15 Wed 7/29/15 100 days 100 days Wed 7/29/15 Wed 8/12/15 Wed 7/29/15 Wed 8/12/15 0 days0 days Wed 8/12/15 Wed 9/2/15 Mon 4/18/16 Mon 5/9/16 174 days 174 days Wed 8/12/15 Fri 11/27/15 Wed 8/26/15 Fri 12/11/15 10 days 10 days Wed 8/12/15 Thu 10/15/15 Wed 8/12/15 Thu 10/15/15 days days Thu 9/24/15 Thu 11/19/15 Thu 9/24/15 Thu 11/19/15 days 0 days Thu 11/19/15 Fri 12/11/15 Thu 11/19/15 Fri 12/11/15 days0 days Thu 11/19/15 Fri 12/11/15 Thu 11/19/15 Fri 12/11/15 days0 days Fri 12/11/15 Tue 1/12/16 Fri 12/11/15 Tue 1/12/16 days 0 days days 0 days 22 days 22 days days 0 days days days 0 days Tue 1/19/16 Tue 1/12/16 Thu 1/21/16 Thu 2/11/16 Mon 2/22/16 Tue 1/19/16 Mon 2/8/16 Tue 1/19/16 Mon 2/8/16 Mon 5/9/16 Tue 5/10/16 14 17 Mon 5/9/16 Tue 5/10/16 Mon 5/9/16 0 days