please show work on excel ms project

TABLE A2.5 Red Zuma: Project Schedule ID Task Name Duration Predecessors 1 1 Red Zuma Project 260 days 2 1.1 Market Analysis 25 days 3 1.2 Product Design 30 days 2 4 1.3 Manufacturing Study 20 days 2 5 1.4 Product Design Selection 10 days 3,4 6 1.5 Detailed Marketing Plan 15 days 5 7 1.6 Manufacturing Process 30 days 5 8 1.7 Detailed Product Design 45 days 5 9 1.8 Build Prototypes 25 days 8 10 1.9 Lab Test Prototypes 10 days 9 11 1.10 Field Test Prototypes 15 days 9 12 1.11 Finalized Product Design 20 days 7.10.11 13 1.12 Final Manufacturing Process 10 days 12 14 1.13 Order Components 7 days 12 15 1.14 Order Production Equipment 14 days 13 16 1.15 Install Production Equipment 35 days 14FS+20 days, 1SFS+30 days 17 1.16 Celebrate 1 days 6, 16 TABLE A2.6 Red Zuma Project Resources S Number available Marketing specialist $80,000/yr 4 Design engineer $125,000/yr 4 $110,000/yr 4 Development engineer Industrial engineer $100,000/y 4 Purchasing agent $75,000/yr 2 Test rider $70/hr 4 Note: MS Project considers resources in terms of percentages with one full-time worker being 100%. Red Zuma Resource Assignments e Resource Names Project nalysis esign uring Study esign Selection Marketing Specialist (400%] Marketing Specialist, Design Engineer [400%], Development Engineer [200%], Industrial Engineer, Purchasing Agent Industrial Engineer (400%). Development Engineer (200%] Marketing Specialist (200%), Design Engineer [300%], Development Engineer [200%), Industrial Engineer [200%), Purchasing Agent (25%] Marketing Specialist (400%) Design Engineer, Development Engineer [200%], Industrial Engineer (300%] Marketing Specialist (200%], Design Engineer [400%], Development Engineer (200%], Industrial Engineer [200%), Purchasing Agent (25%) Design Engineer [200%). Development Engineer [200%], Industrial Engineer (400%] farketing Plan uring Process 'roduct Design otypes 3 'rototypes Design Engineer (200%], Development Engineer [200%), Test Rider Marketing Specialist, Design Engineer [200%], Development Engineer, Industrial Engineer, Test Rider (300%] Product Design Marketing Specialist (200%), Design Engineer [300%], Development Engineer [300%), Industrial Engineer [200%), Purchasing Agent (25%] ufacturing Process Industrial Engineer [300%), Design Engineer. Purchasing Agent [25%] nponents Purchasing Agent duction Equipment Purchasing Agent duction Equipment Design Engineer, Development Engineer (300%], Industrial Engineer [400%] 11 Design Engineer (400%]. Development Engineer [400%], Industrial Engineer (400%), Marketing Specialist (400%], Purchasing Agent (200%] 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 100% 0% 25 days 0 days 2 1.1 Market Analysis 3 1.2 Product Design Fri 1/9/15 Thu 2/12/15 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 O 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 NA NA 0% 0% 0 days 15 days II 1.10 Field Test Prototypes 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% O days 35 days 17 1.16 Celebrate NA NA 0% 0% 0 days 1 days 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 Page 649 activities. 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. S25.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: 1. What is the impact of the revised estimates for Finalized Product Design and Install Production Equipment on the project schedule and cost? 2. Would you recommend authorizing the expenditure of $50,000? Explain. 3. 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