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

Related

## Jet Copies Essay

707 Words | 3 PagesAssignment #1: JET Copies Case Problem 1. How was the information implemented in each component of the model? According to the data that was given for JET Copies, I was able to calculate based on random variables how much it would have cost JET Copies if the copy machine had broken down. The first thing that I needed to calculate was the days it would take to repair the copier. Below you can see the range that was given in the case study for the amount of days the copier would take to repair:

## Jet Copies Essay

782 Words | 4 PagesJET Copies is a photocopy business opened by James, Ernie, and Terri, three students who wanted to make it more suitable for other students in their apartment complex to get copies in a judicious manner. After obtaining a copy machine for the business with an advance from Terri’s mother, the students quickly began deliberating the numerous breakdowns that may transpire. It was at that point that the three students decided they needed a backup copier. Nevertheless, the students desired to first have

## Mat540 Jet Copies Essay

865 Words | 4 PagesMAT 540 Assignment #1 Should Jet Copies Buy a Backup Copier? By Richard C. King Prof. Angel Martinez MAT540054VA005-1118-001: Quantitative Methods October 30, 2011 1. Model Number of Days to Repair The model for the number of days to repair a copier used the determination used in a Random Number generation RAND() in Column E, and based on the Cumulative Probability data listed below: Repair Time Distribution | Probability | Cum Probability | Repair Time (days) | 0.2 | 0 | 1 |

## Jet Copies Case Problem Essay

472 Words | 2 PagesRunning Head: JET Copies Case Problem – Solution JET Copies Case Problem – Solution JET Copies Case Problem – Solution 5. The average time will be the possible times (1-4 days) weighted by the probabilities of each. So multiply each number of days by the probability of that number of days, and added the results to get 2.25 days. The area under the diagonal line in the given graph, between two points on the

## Jets Copies Case Essay

856 Words | 4 PagesJETS Copies Case MAT540: Quantitative Methods: Jeremy Frens Michigan State University Professor Name April 28, 2013 Background In the JET Copies Case, the class was asked to use simulation to estimate the loss of revenue due to copier breakdown for one year. Using the model prescribed by the textbook, students were to use a suitable method to generate the average number of days needed to repair the copiers, when it is out of service, according to the discrete distribution shown. In

## Jet Copies Essay

887 Words | 4 PagesRunning head: ASSIGNMENT 1 JET COPIES Assignment 1- Jet Copies Dr. Joseph MAT 540 October 20, 2012 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. Days-to-repair: If you assume that the number of days needed to repair a copier is random, you can generate a random number denoted r2 between 0 and

## Jet Copies Mat 540 Essay

798 Words | 4 PagesJet Copies MAT 540 Quantitative Methods 2013 A group of college students had an idea after waiting in line at their neighborhood copy center. They were at Klecko’s Copy Center and wondered what it would take to open their own business in competition with Klecko’s. The decision on a name was to call it JET Copies (named for James, Ernie and Terri). The dilemma they had was the decision to purchase one or two copy machines. This was based on the potential down time they could potentially

## Jet Copies Essay

357 Words | 2 PagesRead 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. Repair Time P(Y) Cumulative RN Range 1 0.20 0.20 01-20 2 0.45 0.65 21-65 3 0.25 0.90 66-90 4 0.10 1.00 91-99,000 In Excel, use a suitable method for simulating

## Jet Copies Case Problem Essay

1020 Words | 5 PagesAssignment #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

## Jet Copies Essay

380 Words | 2 Pagesillustrated in Table 1 of the attached Excel worksheet. I then generated random numbers in column r2 of Table 2 and lookup this values in Table 1 for the corresponding estimate for Repair Time. Estimate loss due to repair time For the case of the estimate number of copies sold per day, I generate a uniform random number between 2000 and 8000. I then multiply these values by 10 cents and the number of days in repair to get the estimate loss due to repair time. And finally I get the sum of the losses

### Jet Copies Essay

707 Words | 3 Pages### Jet Copies Essay

782 Words | 4 Pages### Mat540 Jet Copies Essay

865 Words | 4 Pages### Jet Copies Case Problem Essay

472 Words | 2 Pages### Jets Copies Case Essay

856 Words | 4 Pages### Jet Copies Essay

887 Words | 4 Pages### Jet Copies Mat 540 Essay

798 Words | 4 Pages### Jet Copies Essay

357 Words | 2 Pages### Jet Copies Case Problem Essay

1020 Words | 5 Pages### Jet Copies Essay

380 Words | 2 Pages