Can you please check my explanation and calculations?

For your calculations, assume $8$ hours$/$day$,5$ days$/$week$,4$ weeks$/$month$,$ and $12$ months$/$year$.$ Assignment Questions:

$3.$ Consider the scenario of NoBull Burger maintaining the existing configurations with two cooks but buying the automated pack$-$and$-$label machine to be used at Step $4$ of the process.

NoBull Burger $($SPREADSHEET$)$

Labor

Days$/$Week $5$

Hours$/$Day $8$

Weeks$/$Month $4$

Months$/$Year $12$

Minutes$/$Week $(8$ hours$)2400$

Hours$/$year $40$

Standard Batch Size $($# of Burgers$)80$

Burgers$/$Package $4$

Package$/$Batch $20$

Step $1$ Setup Time $($min$/$batch$)$ Cook Time $($min$/$batch$)$ Time for $80$ Throughput Time Additions

Lentils $252510$ with lentil steamer

Step $2$ Setup Time $($min$/$batch$)$ Cook Time $($min$/$batch$)$

Mushrooms and Onions $20123217$ w$/$steamer: $22$

Step $3$ Setup Time $($min$/$batch$)$ Cook Time $($min$/20$ burgers$)$

Cooking Burgers $1284412$

Step $4$ Setup Time $($min$/$batch$)$ Operation Time $($min$/4$ burgers$)$

Pack & Label $1013015$ with pack and label machine

Scenario $3$: Existing Configuration with Automated Pack$-$and$-$Label Machine Cook $1($Steps $1$ & $2)$

Weekly Capacity $($batches$/$week$)40\mathrm{.}677966154\mathrm{.}54545455$ Cook $2($Steps $3$ & $4)$

Throughput Rate $($batches$/$week$)40\mathrm{.}6779661$ Total

Utilization of Cook $10\mathrm{.}966101694996\mathrm{.}61\%$

Utilization of Cook $21100\mathrm{.}00\%$

Throughput Time $($min$)118$

WIP $($batches$)2$

Overall Profit $($$$/$year$)$ $$8,576\mathrm{.}27$

Profit in the next year $($without capital expense$)$ $$58,576\mathrm{.}27$

Bottleneck Cook $2-$ Steps $3$ & $4$

Cycle time $($min$)116$

Batches per minute $0\mathrm{.}01694915254$

Additional one$-$time Cost $($machine$)$ $$50,000\mathrm{.}00$

$($a$)$ the weekly capacity $($batches$/$week$)$

In the scenario of NoBull Burger, with two cooks but buying the automated pack$-$and$-$label machine to be used at Step $4$ of the process. The weekly capacity is $40$ batches$/$week$,$ calculating a five$-$day work week, each cook working eight hours a day.

$($b$)$ the throughput rate $($batches$/$week$)$

The throughput rate is $40$ batches$/$week because we are limited by our capacity of $40$ batches$/$week$.$

$($c$)$ the utilization of each cook

In one scenario, Cook $1$ is utilized $96\mathrm{.}61\%$ of the time, and Cook $2$ is utilized $100\%$ of the time. The utilization of each cook is based on the actual labor hours used relative to the avaialable labor hours for two cooks working $40$ hours a week.

With the remaining $25$ minutes that can be used for another task, cook $2$ can prepare and cook the mushrooms at the same time that cook $1$ is preparing and cooking the onions. Cook $1$ can help prep the burgers for the girls.

$($d$)$ the throughput time $($min$)$

The throughput time is $118$ minutes.

$($e$)$ the WIP $($batches$)$

The work in progress IS $2$ BATCHES

$($f$)$ the overall profit $($$$/$year$)$

COGS $\mathrm{.}5$

Raw materials $2\mathrm{.}5$

Labor$/$Rent$/$Misc $2$

Cook pay $127460$

Sell Price $680$ x $74$x $4800$

Profit per sale $1\mathrm{.}564\mathrm{.}86486486$

Revenue per batch $120$

COGS per batch $90$

Profit per batch $30$