ART $3$: PROCESS ANALYSIS

This is a practice with complex process analysis where there are both multiple resources and

multiple flow unit types. You would need to construct an Extended Table like in HW$1-$Q$24.$

Hypothetically, we are analyzing operations of a restaurant with $20$ workers. This

restaurant serves three different dishes $($A$,$ B$,$ and C$)$ and use different stations $($R$1-$R$6)$ for

preparing and cooking food. The restaurant is open for $10$ hours a day. And, the daily demand is

$540$ units of A$,621$ units of B$,$ and $459$ units of C$.$ Besides, the current operations have the

following settings:

$4$

Station$/$Resource R$1$ R$2$ R$3$ R$4$ R$5$ R$6$

Number of workers $5\mathrm{.}0005\mathrm{.}0004\mathrm{.}0002\mathrm{.}0002\mathrm{.}0002\mathrm{.}000$

Processing time for A $($minutes$/$unit$/$worker$)1\mathrm{.}53\mathrm{.}02\mathrm{.}52\mathrm{.}00\mathrm{.}01\mathrm{.}0$

Processing time for B $($minutes$/$unit$/$worker$)1\mathrm{.}52\mathrm{.}51\mathrm{.}50\mathrm{.}50\mathrm{.}01\mathrm{.}0$

Processing time for C $($minutes$/$unit$/$worker$)2\mathrm{.}51\mathrm{.}00\mathrm{.}00\mathrm{.}03\mathrm{.}01\mathrm{.}0$

Given the assumption of a fixed product mix, you would need to construct the Extended

Table in Excel with the following blocks $($where cells are linked together by functions$)$:

$$ Block $1$ Labor and technology settings $($the above table$)$

$$ Block $2$ Resource capacities in minutes of work, per hour and per day $(10$ hours$)$

$$ Block $3$ Demands in product units, workloads in minutes, and original implied utilizations

$$ Intermediate step $$ A separate cell for the Demand Acceptance Ratio $($DAR$)$ where, in Excel,

DAR $=$ MIN$(100\%,1/$MAX$($original IUs$)$

$$ Block $4-$ Flow rates, effective workloads, effective implied utilizations, and utilizations.

In your report of this part, you need to present the following:

$($a$)$ A copy of The Extended Table that shows numerical results with one extra cell for the DAR.

$($b$)$ Another copy of the Extended Table that shows how cells are linked together. To have this:

copy to have another Extended Table; highlight the area that you want to show formulas; then,

go to the Formulas tab at the top panel and click on the Show Formulas button.

$($c$)$ A profile $($column chart$)$ of the original implied utilizations and a brief discussion on it$.$

$($d$)$ A profile of the effective implied utilizations and a profile of the utilizations. Explain why

these two profiles look the same. Explain why there is one utilization column of exactly $100\%.$

$($e$)$ A brief statement of how efficient the process currently is based on the U$-$profile