Assignment 1: Jet Copies Case Problem Essay

818 Words Aug 26th, 2013 4 Pages
Assignment 1: JET Copies Case Problem
Rose Leahy
Strayer University
Quantitative Methods-MAT540

Dr. Patricia DeJarnett

July 21, 2013

Assignment 1: JET Copies Case Problem

Read the “JET Copies” Case Problem on pages 678-679 of the text. Using simulation estimate the loss of revenue due to copier breakdown for one year, as follows:

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.
(See Excel spreadsheet)

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

In Excel, use a suitable method
…show more content…
They decided that if the loss of revenue due to machine downtime during the first year is greater than or equal to $12,000, then they should purchase the back-up copier. They decided to conduct a manual simulation of this process for one year to see if the model was working correctly. Repair Time | Repair Time | Cumulative Probability | RN Ranges | y (days) | P(y) | | | 1 | 0.2 | .2 | 01-20 | 2 | 0.45 | .65 | 21-65 | 3 | 0.25 | .90 | 66-90 | 4 | 0.10 | 1.00 | 91-99, 000 |

The probability function for time between repairs, f(x), is, f(x) = x/18, 0 <= x <= 6 and, r = x^2/36; x2 = 36r; x = 6*sqrt of r. The probability function for daily demand is developed by determining the linear function for the uniform distribution, which is, f(z) = 1 / b – a which equals 1/6; z = 6r + 2.
The Simulation itself would be for 52 weeks. I began with a Random Number chosen using the random number generation in Excel (r1) which was multiplied by column 2, the Time Between Breakdown formula of 6*square root of r1. The sum of those variables was then in a cumulative list in column 3. In column 4 I generated another random number to calculate the column 5 Repair time in y days. That r2 was used in column 5 for Repair Time in y days which was

Related Documents