Paper

In Excel, use a suitable method for generating the number of days needed to repair the copier, when it is out of service, according to the discrete distribution shown.

Assuming the following discrete distribution

Repair Time (days) | Probability |

1 | 0.2 |

2 | 0.45 |

3 | 0.25 |

4 | 0.1 |

We can use the following formulas in Excel to generate the number of days needed to repair the copier.

A1 = RANDBETWEEN(1,100)

=IF(A1<=20,1,IF(A1<=65,2,IF(A1<=90,3,4)))

Result: (Answers vary)

Numbers generated

(first15)

# | Repair Time (days) |

1 | 2 |

2 | 1 |

3 | 3 |

4 | 4 |

5 | 2 |

6 | 2 |

7 | 2 |

8 | 2 |

9 | 2 |

10 | 3 |

11 | 2 |

12 | 3 |

13 | 3 |

14 | 3 |

15 | 3 |

In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown. 

Assuming the following continuous distribution

The pdf of the interval between successive breakdowns in weeks is (The equation of the straight line is y=x/18)

,

To get the CDF we compute

We can randomly select probability value between 0 and 1 using Rand()

So Rand()

Solving for y

We can use the following formulas in Excel to generate the interval between successive breakdowns in weeks.

=6*SQRT(RAND())

Result: (Answers vary)

Numbers generated

(first15)

# | Interval between successive break |

1 | 5.5234 |

2 | 2.5619 |

3 | 4.3147 |

4 | 2.8446 |

5 | 3.7834 |

6 | 5.6542 |

7 | 3.5611 |

8 | 3.9544 |

9 | 5.5027 |

10 | 3.8307 |

11 | 2.3811 |

12 | 3.9102 |

13 | 3.1875 |

14 | 4.6555 |

15 | 4.6505 |

In Excel, use a suitable method for simulating the lost revenue for each day the copier is out of service

Assuming a uniform distribution we can use the following formulas in Excel to generate the revenue lost for each day the copier is out of service.

=(RAND()*(8000-2000)+2000)*0.1

Result: (Answers vary)

Numbers generated

(first15)

#...