Jet Copies- Case Study Report

934 WordsDec 22, 20134 Pages
According to the discrete distribution in generating the number of days needed to repair the copier under the assumption the number of days to repair the coping machine is random; the Excel RAND function can be used and has been represented by r₂. The number will fall between 0 and 1. Resulting if | | | | | Days to repair | 0 | < | r2 | < | 0.2 | 1 | 0.2 | < | r2 | < | 0.65 | 2 | 0.65 | < | r2 | < | 0.9 | 3 | 0.9 | < | r2 | < | 1 | 4 | This chart above was developed taking information from the excel sheet. First, calculating the cumulative values by taking the probability distribution of repair times that were provided; please see excel attachment cells C3-C6. Taking the r₂ result will determine the number of days it will take to repair the copying machine. The interval between successive breakdowns would result in the following continuous probability for the time between breakdown: f(x)= x/18, 0<x<6. Letting x represents the time between breakdowns; the variation will be between 0 and 6 weeks. As time lapse, the probability will continue to rise. Now giving distribution function to equal f(x) = x²/36, 0<x<6. r₁ is a randomly generated number (under assumption) between 0 and 1, r₁= x²/36, with x= 6 r₁. On average, the copy machine breaks down every 4 weeks. Stimulating the lost revenue for each day the copier is out of service is performed by taking the number of copies per day. The number of copies per day falls between 2000 and 8000 copies. r₃ (represented in column M) is calculated using function: +RANDBETWEEN(2000,8000). Calculating loss is done by taking the variable representing r₃ times the repair time in cell L5. With cell L5 is the time in days it will take to repair the machine. The number is then times by cost. The equation is written as: 0.1* r₃*repair time. Below is the

More about Jet Copies- Case Study Report

Open Document