(MS Project Assignment) 36 Management Consulting Computer designs and manufactures high tech devices for public consumption Currently, the 36 Management Consulting executive team is considering the development of a new version of their popular smartphone. As with all their products, they intend to design the smartphone to meet current trends and manufacture the device in house to maintain quality standards. Estimates have been made regarding the development project to take it to the point of operational manufacture. The estimates are based on the results of the projects for the two prior versions. The company requires meeting the product specifications, prefers to complete the project as close to schedule as possible, and is willing to assume some additional costs if necessary. to meet a tighter schedule. Part 1. Use the information provided in Table 1 to develop the project schedule. Assume that the project will begin on September 18, 2021. A standard work week is to be applied to the schedule with the only recognized holidays being New Year's Day, MLK Day, Memorial Day, Labor Day, Thanksgiving Day and the day after, and December 25th and 26th. If a holiday falls on the weekend, the employees are out of luck. First, develop the schedule without considering resources. Next, add the resources and determine the shortest feasible schedule as constrained by the resources in Table 2. Assume that tasks cannot be split. Write a memo 350 words or more to the executives about the schedule and any resource issues associated with the schedule. Consider carefully what to consider and how to structure the memo Table 1. Activity requirements input this table in your Microsoft Project Application software. Hint resource required 4-100%, 3-75%, 2-50%, 1.25% Resources required Task ID Predecessors 4 1 4 1 NNN 1 4 2 1 3 2 1 Duration 25 40 20 10 15 30 50 10 25 72 14 35 Task Description 1 Market Study 2 Functional Specifications 3 Manufacturing Planning 4 Product Feature Selection 5 Develop Marketing Plan 6 Design Manufacturing Process 7 Detailed Smartphone Design 8 Prototype Testing 9 Finalize Product Design 10 Order Parts 11 Order Manufacturing Equipment 12 Install Equipment Notes: "duration is in days 2 1 1 2,3 4 4 4 7 6,8 9 9 10,11 4 2 2. 1 1 4 3 3 2 2 2 3 2 2 _ 2 1 1 1 3 4 Table 2. Additional Resources Available for Project Duration Resource S/hour Assigned to project Market Researchers 60 Product Designers 100 4 Quality Engineers 80 4 Manufacturing Engineers 90 4 Acquisition Specialists 50 1 Memos & MS Project 1. I'm looking for 1 memo in one file 350 words or more. 2. I'm looking for detail and clarity on the Memo 3. 1 MS Project either in PDF or best format (it's not going to look clean) MS Project should show: (1 point each) 1. Percent work completed 2. Task ID 3. Task Description 4. Duration 5. Start dates 6. Finish dates 7. Predecessor 8. Resource Name 9. Actual Duration 10. Remaining Duration (if applicable) Frequently Ask Questions 1. How many MS project files? a One for table 1 for assignment 5 2. is there a right or wrong answer? a. No, I need to know if you are creating a sound resolution for the executives 3. What are you grading for? a Sound project management solution and scheduling b. Clarity and knowledge of scheduling (Chapter 5 and Chapter 63 4. Memo needs to be 350 words or more