Precision Products specializes in custom-manufactured metal parts. 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. The 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. Create the Excel spreadsheet shown in Figure 1-18 to calculate the weekly manpower required, at 40 hours per week, for production levels of 200, 300, 400, and 500 units. How does the total required for each level of production change if Precision Products operates a 45-hour production schedule?

  • CreatedJanuary 03, 2015
  • Files Included
Post your question