Spreadsheet simulation model of breakdown

Assignment Help Operation Management

Reference no: EM132223550

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.

(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.

Reference no: EM132223550

Questions Cloud

What would you do to stay competitive in the market : If you were the manager of a newly opened Dallas restaurant, what would you do to stay competitive in the market?

How long-run equilibrium is different : Briefly explain how long-run equilibrium is different for each of the following types of markets: perfect competition, monopolistic competition, and monopoly.

In a purely private market economy : In a purely private market economy how is the for whom question answered?

Perfect competition and why is it important : What does MC=MR indicate for both perfect competition and less than perfect competition and why is it important?

Spreadsheet simulation model of breakdown : Below represents a spreadsheet simulation model of the breakdown and repair processes in the maintenance program and the resulting costs.

What different competitive moves are commonly used by firms : What different competitive moves are commonly used by firms? When and how do firms respond to competitive actions taken by their rivals?

Four other examples of inferior goods : In addition, discuss how revenues of inferior goods producers are expected to be affected by economic recessions and expansions.

What is the intercept of marginal function : The original revenuse function of micro chip producer is R=170Q-20Q square. What is the intercept of marginal function?

How might it have boosted productivity : List one innovation since 1990. How might it have boosted productivity?

User Account

All Pages