Helio Polymer Enterprises Spreadsheet Modeling Assignment

$*$As the operations manager, Margaret Wagoki has given you permission to add employees$/$resources to the gunny bag production process.

$*$You cannot add available work hours $($i$.$e$.,$ overtime or extra shift$).$

$*$Using the spreadsheet model below, fill in the blanks highlighted in yellow with equations $($no hard coding$),$ and add resources to the required stations to meet current demand $(25,000$ bags$/$week$).$

$*$Explain your decision$($s$)$ in the space highlighted below $($# of resources added$)$

Current demand $=25,000$ bags

Step # resources # tasks$/$bag$**$

Processing time$/$task

$($in seconds$)$

Total processing

time$/$bag $($in seconds$)$

Cycle time $($in

seconds$/$bag$)$

Time available $($in

hours$/$shift$)$

Time available $($in

seconds$/$week$)$ Weekly Capacity

Cutting$*122\mathrm{.}5540$

Stitching $43103040$

Printing $10\mathrm{.}823$

Notes:

$*$Cutting: There are actually two employees, but they are essentially acting as one resource. Two employees are required to complete this step safely.

$**$Tasks: Cutting $=$ cutting one side of material; Stitching $=$ stitching one edge of the bag

Explain your decisions below $($must provide detail explaining why resources were added$)$: