Step's tcpic 1. Precision Products specializes in custom-manufactured metal parts. 2. The production manager has asked you to create an Excel spreadsheet to help manage operations. The company needs a way to calculate staffing requirements (number of employees) based on different levels of production. 3. five manufacturing operations are fabrication, welding, machining, assembly, and packaging. One unit of production requires 1.5 hours for fabrication, 2.25 hours for welding, 0.7 hours for machining, 3.2 hours for assembly, and 0.5 hours for packaging. 5. 6. Fill in the Excel spreadsheet to calculate the weekly manpower required, at 40 hours per week, for 7. Copy the section of the spreadsheet containing the weekly requirements for a 40 hour week and paste it production levels of 200, 300, 400, and 500 units. 8. Change the weekly requirements from 40 hour into 45 hours. The formulas should be modified to 9. How does the total required for each level of production change if Precision Products operates a 45-hour below this section accommodate the 45 hours. production schedule