Assignment:
Table below represents a spreadsheet simulation model of the breakdown and repair processes in the maintenance program and the resulting costs. The spreadsheet is frozen at row 24 to show the first 10 breakdowns and the last 4.
Table: Spreadsheet simulation model of the breakdown and repair processes
(a) Derive an equation for generating x given the random number r.
(b) Write down the formula for determining X in the spreadsheet cell D113.
(c) What is the average time between breakdowns over the last four breakdowns in the simulation run?
(d) What is the expected machine repair time resulting from the maintenance program?
(e) What is the repair time of the 100th breakdown in the simulation run?
(f) What is the repair cost of the 100th breakdown in the simulation run?
(g) What is the input range for creating the descriptive statistics in the spreadsheet?
(h) Use the descriptive statistics to draw conclusions about the characteristics of the probability distribution of the output variable of the simulation.
(i) Calculate the lower limit of a 95% confidence interval for the cost.