We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

See Pricing

What's Your Topic?

Hire a Professional Writer Now

The input space is limited by 250 symbols

What's Your Deadline?

Choose 3 Hours or More.
Back
2/4 steps

How Many Pages?

Back
3/4 steps

Sign Up and See Pricing

"You must agree to out terms of services and privacy policy"
Back
Get Offer

Jet Copies Case Problem

Hire a Professional Writer Now

The input space is limited by 250 symbols

Deadline:2 days left
"You must agree to out terms of services and privacy policy"
Write my paper

In Excel, use a suitable method for simulating the lost revenue for each day the copier is out of service. (See Excel spreadsheet) 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. 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).

In this case study the students bought a copier for $1 8,000 to start their own copy business after noticing a need for it.

Don't use plagiarized sources. Get Your Custom Essay on
Jet Copies Case Problem
Just from $13,9/Page
Get custom paper

After purchasing the copier they found out that the one that they purchased is known to break down frequently, and was known to usually take anywhere from one to four days to repair with the time between breakdowns estimated between zero and six weeks. They estimated that they would sell between 2,000 and 8,000 copies per day at .

10 per copy. With this expected demand the students wanted to analyze whether they should purchase a back up copier for $8,000 to avoid the potential loss during breakdowns. In order to analyze this they created a simulation to estimate the amount of revenue that would be lost if they did not have a backup copier.

The sum of those variables was then in a cumulative list in column 3. In column 4 1 generated another random number to calculate the column 5 Repair time in y days. That re was used in column 5 for Repair Time in y days which was calculated by using the =VILLOUS function which related that re to probabilities in the Repair Time probability table originally set up. I then set up random number columns and result columns for repairs taking 1 day, 2 days, 3 days and 4 days. 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 arcograph. From this simulation I would recommend that they purchase the backup copier for $8,000. They mentioned wanting to purchase the backup if the potential loss per year was greater than or equal to $12,000. From this 52 week simulation the average lost revenue ranged from $500-2,000 and lost revenue per year varying from 1-4 repair days. The limits of this study are the assumptions made. If any of these assumptions are not accurate the results of the simulation will be skewed. References Taylor, B. M. (2010). Introduction to management science (10th deed. ). Upper Saddle River, NJ: Pearson/Prentice Hall.

Cite this Jet Copies Case Problem

Jet Copies Case Problem. (2018, May 29). Retrieved from https://graduateway.com/jet-copies-case-problem/

Show less
  • Use multiple resourses when assembling your essay
  • Get help form professional writers when not sure you can do it yourself
  • Use Plagiarism Checker to double check your essay
  • Do not copy and paste free to download essays
Get plagiarism free essay

Search for essay samples now

Haven't found the Essay You Want?

Get my paper now

For Only $13.90/page