Processes Operator Wage $$/$hr Cycle Time $[$min$]$ Output $[$units$/$hr$]$

Cabinet sub assy O$1$ $$185\mathrm{.}1011\mathrm{.}8$

Welding O$2$ $$185\mathrm{.}3011\mathrm{.}3$

Door sub assy O$3$ $$185\mathrm{.}9010\mathrm{.}2$

Wire harness O$4$ $$184\mathrm{.}2014\mathrm{.}3$

Door install O$5$ $$184\mathrm{.}4013\mathrm{.}6$

Electric assy and Inspection O$6$ $$184\mathrm{.}8012\mathrm{.}5$

Testing O$7$ $$205\mathrm{.}0012\mathrm{.}0$

Packaging O$8$ $$185\mathrm{.}7010\mathrm{.}5$

Supervisor$/$team leader $(1)$ $$24$

Material Handling $(2)$ $$20$Develop a spreadsheet analysis to evaluate whether Dr$.$ Ishfaq's suggestion will result in sufficient capacity to fill demand of $1000$ units$/$week$?$ How does the total annual cost $(=$ fixed costs $+$ variable costs$)$