$1-19.$ EXCEL APPLICATION: Staff Planning Spreadsheet

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\mathrm{.}5$ hours for fabrication, $2\mathrm{.}25$ hours for welding, $0\mathrm{.}7$ hours for machining, $3\mathrm{.}2$ hours for assembly, and $0\mathrm{.}5$ hours for packaging. Download the Excel file Ch$01$Ex$01($Figure $1\mathrm{.}220),$ and then calculate the weekly staffing required, at $40$ hours per week, for production levels of $200,300,400,$ and $500$ units. How does the total required fo: each level of production change if Precision Products operates a $45-$hour production schedule?