preview

Assignment 1: Jet Copies Case Problem

Good Essays

Assignment 1: JET Copies Case Problem
Rose Leahy
Strayer University
Quantitative Methods-MAT540

Dr. Patricia DeJarnett

July 21, 2013

Assignment 1: JET Copies Case Problem

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:

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.
(See Excel spreadsheet)

In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown.
(See Excel spreadsheet)

In Excel, use a suitable method …show more content…

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 paragraph.

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 $25,000-100,000 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 ed.). Upper Saddle River, NJ:

Pearson/Prentice

Get Access