Jet Copies Case Problem

1020 Words5 Pages
Assignment #1: JET Copies Case Problem MAT 540 Quantitative Methods Professor Abdul Khan January 26, 2014 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. As for the first segment of the case, I needed to figure out the number of days needed in order to repair the copier. Initially, I assumed that the amount of days required to repair a copier is random. So with that, I could generate a random number using the Excel RAND function that I designated r2 between 0 and 1. If 0 < r2< 0.2 then it takes 1 day 0.2< r2< 0.65 then it takes about 2 days 0.65 < r2 < 0.90 then it takes about 3 days 0.9 < r2 < 1 then it takes about 4 days 2. In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown. With the probability increasing as time goes forward, the probability distribution of the random variable varies between the times of 0 to 6 weeks. In order to find an approximate result, it can be completed by the function F (x) = x/18 for 0 < x < 6 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 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. Because the amount of copies sold each day is a uniform probability distribution between 2000 to 8000 copies, I designated r3 as a random number between 2000 to 8000. In order to find the amount of business lost on a certain day, I took r3 X (repair time), and the lost revenue

More about Jet Copies Case Problem

Open Document