A

B

C

D

E

F

$G$

Topic $3$

Topic $3$

Bristol Bike is doing a year$-$end Business review and finds that the demand for their bikes

has picked up and is now

$\backslash$table$[[,$Relat,Fre,ency,ut$,$for,$],[$Demand$,0,1,2,,4,],[$Probability$,0\mathrm{.}05,0\mathrm{.}45,0\mathrm{.}15,0\mathrm{.}15,0\mathrm{.}10,0\mathrm{.}10]]$

Everything else $($i$.$e$.$ Costs, Reorder point, Reor der time$)$ is exactly the same as before.

i$.$ Run a $12$ week Simulation using the Chart and the Random Numbers in the RN column.

When you need to reorder use as mary of the following random numbers in succession as necessary$-$

$0\mathrm{.}175295$

$0\mathrm{.}742775$

$0\mathrm{.}74976$

$0\mathrm{.}974544$

$0\mathrm{.}036515$

$0\mathrm{.}215327$

Week

RN

Demand

Start Inventory End Inventory Lost Sale: Reorder RN

Time Inventory Total

Calculate the average weekly cost.