Task $4$: Fill in the orange$-$colored cells in cell H$79$ and H$80$ for the analysis of revenue and cost.

Based on the above data,

total number of units $($obtained by adding the units at each stage$)=$

number on rent $($units at customers$)=$

So$,$ utilization $($units with the customer $/$ total units owned$)=$ #DIV$/0!$

We can now evaluate the revenue and cost per week for the above system.

Revenue:

Revenue per week $=$ number on rent x rental cost per week $=$

Cost:

Cost per week $=$ shipping cost $+$ receiving cost $($shipping$)+$ pre$-$configuration cost $+$ repair cost $+$ depreciation $=0$

Shipping cost per week $=$

Receiving cost per week $=$

Pre$-$configuration cost per week $=$

Repair cost per week $=$

Depreciation per week $($total units x depreciation$/$unit$/$week$)=$

Profit per week $=$ Revenue minus Cost $=$

As such, last year, the process generated $ $($number in H$96)$ in profit per week.

Another way to view the economics is as follows. A rented computer has three possible flows depending on its classification at receiving:

$1.$ Classified correctly as status $24($F$1)$: The unit flows from pre$-$configuration to Status $20$

$2.$ Classified incorrectly as Status $24($F$2)$: The unit flows from pre$-$configuration to Status $40$

$3.$ Classified as Status $40($F$3)$: The unit flows from Receiving to Status $40$

Task $5$: Evaluate the duration of a cycle, which varies in each case $($duration of F$1$ is given as an example$)$:

Case F$1$: Duration of cycle $=$ Customer $+$ Receiving $+$ Pre$-$config $+$ Status $20=$ #DIV$/0!$ weeks

Case F$2$: Duration of cycle $=$ Customer $+$ Receiving $+$ Pre$-$config $+$ Status $40+$ Status $41+$ Status $42+$ Status $20=$ weeks

Case F$3$: Duration of cycle $=$ Customer $+$ Receiving $+$ Status $40+$ Status $41+$ Status $42+$ Status $20=$ weeks

Task $6$: Evaluate the contribution per cycle in each case:

Case F$1$:

Revenue per cycle $=8$ x $30=$

Cost per cycle $($test$)=$

Depreciation per cycle $=12\mathrm{.}64$ x $(1,000/(52$x$3))=$

Contribution per cycle $=240-(4+50+81)=$

Contribution per week $=105/12\mathrm{.}64=$

Case F$2$:

Revenue per cycle $=$

Cost per cycle $($Repair cost$)=$

Depreciation per cycle $=$

Contribution per cycle $=$

Contribution per week $=$

Case F$3$:

Revenue per cycle $=$

Cost per cycle $($Repair cost$)=$

Depreciation per cycle $=$

Contribution per cycle $=$

Contribution per week $=$

Based on the contribution margins, every computer going through repairs is currently generating a $\_\_\_\_\_\_\_\_\_\_\_.($choose between profit or loss$)$

Computers that are misclassified generate $\_\_\_\_\_\_\_\_\_\_\_$ than those that are not because of $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

Customer

type here type here

Parts

type hereRepairsConfiguration

type here

type here

Status $41$

Status $41$

type heretype here

type here

$30\%$

xx$\%$

xx$\%$

Receiving

Repairs

Pre$-$configuratio

Supplier

Status $24$

Status $40$

Status $42$

Status $20$