Abdul is the new maintenance supervisor at a local manufacturing plant ...
guru2009Abdul is the new maintenance supervisor at a local manufacturing plant. He is responsible for the maintenance of machinery for production line processes. Abdul is interested in the level of machine failures. He would like to simulate the number of machine failures each month. Using historical date, Abdul established the probability of failures during a month as follows: Number of Machine failures Probability 1 0.1 2 0.17 4 0.21 5 0.28 6 0.16 7 0.07 8 0.01 Simulate Abdul’s monthly machine failures for a period of 3 years. Replicate the failures 300 times. Provide the following information: A copy of the completed Excel spreadsheet (10 marks) The average number of failures per month for one replication (1 mark) The average number of failures per month for 300 replications (1 mark) Explain any difference(s) between the simulated average failures and the expected value of failures (long run value). Number of Machine failures Probability 1 0.1 2 0.17 4 0.21 5 0.28 6 0.16 7 0.07 8 0.01 Simulate Abdul’s monthly machine failures for a period of 3 years. Replicate the failures 300 times. Provide the following information: A copy of the completed Excel spreadsheet (10 marks) The average number of failures per month for one replication (1 mark) The average number of failures per month for 300 replications (1 mark) Explain any difference(s) between the simulated average failures and the expected value of failures (long run value).
- 5 years ago
Purchase the answer to view it
- Abdulisthenewmaintenancesupervisoratalocalmanufacturingplant.xlsx