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: 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. 2. In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown. 3. In Excel, use a suitable method for simulating the lost revenue for each day the copier is out of service. 4. Put all of this together to simulate the lost revenue due to copier breakdowns over 1 year to answer the question asked in the case study. 5. In a word processing program, write a brief description/explanation of how you implemented each component of the model. Write 1-2 paragraphs for each component of the model (days-to-repair; interval between breakdowns; lost revenue; putting it together). 6. Answer the question posed in the case study. How confident are you that this answer is a good one? What are the limits of the study? Write at least one paragraph.

Case Problem
James Banks was standing in line next to Robin Cole at Klecko’s Copy Center, waiting to use one of the copy machines. “ Gee, Robin, I hate this,” he said. “We have to drive all the way over here from Southgate and then wait in line to use these copy machines. I hate wasting time like this.” “I know what you mean,” said Robin. “And look who’s here. A lot of these students are from Southgate Apartments or one of the other apartments near us. It seems as though it would be more logical if Klecko’s would move its operation over to us, instead of all of us coming over here.” James looked around and noticed what Robin was talking about. Robin and he were students at State University, and most of the customers at Klecko’s were also students. As Robin...

...JETCopiesProblem
Lost revenue of JetCopies due to breakdown can be done by generating random numbers from different probability distributions according the given probability law. The different steps of this simulation and assumption made are explained below.
1. Simulation for the repair time.
It is given that the repair time follows
|Repair Time (days) |Probability...

...JETCopiesCaseProblem
Assignment 1
Professor
Dr. Elena Klimova
MAT 540 – Quantitative Methods
Janeiro 28, 2013
5.
Model number of days to repair
In regard to the first part of the CaseProblem (The average number of days needed to repair the copier), I worked on the Excel to find the number of the days required to repair the copier (Repair Time (days). In Excel, I wrote down the table...

...Assignment 1: JETCopiesCaseProblem
Rose Leahy
Strayer University
Quantitative Methods-MAT540
Dr. Patricia DeJarnett
July 21, 2013
Assignment 1: JETCopiesCaseProblem
Read the “JETCopies” CaseProblem on pages 678-679 of the text. Using simulation estimate the loss of revenue due to copier breakdown for one...

...Running Head: JETCOPIESCASEJETCopiesCase
Math 540
Winter 2013
JETCopiesCase
Introduction
Before starting the case, it is important to know how this case will be evaluated through excel, the functions and their application, and how they quantifiably accentuate on the variables and known possibilities...

...JetCopiesCaseProblem
Shelandria Jones
Strayer University
MAT 540-Quantitative Methods
Dr. Raymond Ottinot
February 5, 2013
Introduction
JetCopies is a business venture of a couple of young men who had the insight to open up a copy business. James Ernie and Terri received a loan from Terri’s parents of $18,000. Due to information they have received the large copier they purchased...

...JETCopiesProblem
The simulation of JetCopies can be done by generating random numbers from given probability distributions. The different steps of this simulation and assumption made are explained below.
1. Simulation for the repair time.
It is given that the repair time follows
Repair Time (days) Probability
1. .20
2. .45
3. .25...

...JetCopiesCase Study
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.
2. In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown.
3. In Excel, use a suitable method for simulating the lost revenue for each day the copier is out of service.
4. Put...

...Read the "JETCopies" CaseProblem 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.
In Excel, use a suitable method for simulating the interval between successive breakdowns, according...

825 Words |
3 Pages

Share this Document

Let your classmates know about this document and more at StudyMode.com

## Share this Document

Let your classmates know about this document and more at StudyMode.com