Jet Copies Problem

Jet Copies Case Problem

Renne Brown

Dr. Simona Barb

Quantitative Methods-MAT 540

January 27, 2013

Jet Copies 1

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

For the first component of the case, I was asked to find the number of days needed to repair the copier. To begin, I assumed that the number of days needed to repair a copier is random, you can generate a random number using the Excel RAND function which I denoted r2 between 0 and 1. If

0 < r2 < 0.2 then it takes 1 day

0.2 < r2 < 0.65 then it takes 2 days

0.65 < r2 < 0.90 then it takes 3 days

0.9 < r2 < 1 then it takes 4 days

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

The probability distribution of the random variable varies between the times of 0 to 6 weeks, with the probability increasing as time goes on. This can be approximated by the function

f(x) = x/18 for 0 < x < 6

Jet Copies 2

Therefore, the distribution function is

f(x) = x-square divided by 36 for 0 < x < 6

If we set this equal to another random number r1 that is between 0 and 1 then

R1 = x-square divided by 36 which results to x = 6√ r1

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

Since the number of copies sold per day is a uniform probability distribution between 2000 to 8000 copies, I made r3 a random number between 2000 to 8000. To get...