Helio Polymer Enterprises Spreadsheet Modeling Assignment

$-$ As the operations manager, Margaret Wagoki has given you permission to improve tasks for, and add employees$/$resources to$,$ the gunny bag production process.

$-$ You are not authorized to add available work hours $($i$.$e$.,$ overtime or extra shift$)$ at this time.

$-$ Fill in$/$modify the orange cells with hard numbers and the yellow cells with equations $($no hard coding$),$ and improve tasks $($exploit$)$ to the required stations to meet current demand $(100,000$ bags$/$week$).$ Only make improvements where required $($subordinate$).$

$-$ Explain your decision$($s$)$ in the space highlighted below $($tasks improved, # of resources added$)$

Projected demand $=100,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$/$week$)$

Time available $($in

seconds$/$week$)$ Weekly Capacity

Cutting $12\mathrm{.}5040$

Stitching $410040$

Printing $10\mathrm{.}8023$

$*$Input $"$# tasks$/$bag$"$ from your solution on the "HPE Capacity $(25$K$)"$ worksheet, then make further improvements as necessary

Explain your decisions below $($must provide detail explaining why resources were added and how tasks were improved $[$relative to the previous spreadsheet$])$: