Question

The Gigantic Mining Co. employs a maintenance crew to repair its machines as needed in its repair centre. Management now wants a simulation study done to analyse what the size of the crew should be, where the crew sizes under consideration are 2, 3, and 4 crew members. The time required by the crew to repair a machine has a uniform distribution over the interval from 0 to twice the mean, where the mean depends on the crew size. The mean is 4 hours with two crew members, 3 hours with three crew members, and 2 hours with four crew members. The time betweern breakdowns of the machines has a normal distribution with a mean of 4 hours and a standard deviation of 1.5. When a machine breaks down and so requires repair, management wants the average waiting time before repair begins to be no more than 3 hours. Management also wants the crew size to be no larger than necessary to achieve this.

Need help simulating this with excel. Thankyou.

Answer 1

in the follo orig じ ulation Tab me Corc the Bo machime Soes (BTo a otcuor Bo RE o yteve mosT be am ent the Pecedng 3ot D t The achine hos toat up to the RE OF The Pecedn hove imply се

TBD 100 001001o 9o 310 30 35a0 86 580 23050 310 540 910 910|80 | 271520 to δ40 o 56030 21350 120 1S S10/ppe ence avoe 6 Bureakdoung ond hence average coatig Of a10 amd hence Jimei - 13.22