JET Copies Case Problem, Applied Statistics

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.
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 MAT540 Student Version 201005 Page 6 of 19 good one? What are the limits of the study? Write at least one paragraph.
There are two deliverables for this Case Problem, the Excel spreadsheet and the written
description/explanation. Please submit both of them electronically via the dropbox
Posted Date: 1/26/2013 8:23:35 PM | Location : United States






Your posts are moderated
Related Questions
Cindy, the Assistant Vice President of Engineering/Administrative Services at Blue Cross Blue Shield Rhode Island (BCBSRI), has seen all of the OSHA statistics: In 2000, 1

The Case Study included information about the price for a full meal before and after the law change (in dollars).  Of interest is whether the differences in price for a full meal b

A consumer preference study involving three different bottle designs (A, B, and C) for the jumbo size of a new liquid detergent was carried out using a randomized block experimenta

A.    Do the correlation matrix table. B.    Which variable (s) has the largest correlation coeffieient which is not a perfect correlation? C.    Which variable (s) has the s

Linear Regression Generally, in two mutually related statistical series, the regression analysis based on graphic method. Under graphic method the values  of X and Y variable

First we look at these charts assuming that we know both the mean and the standard deviation of the process, that is  μ and  σ . These values represent the acceptable values (bench

Each weekend, Derek either reads a book (B), goes to the cinema (C), visits his local museum (M), or plays squash (S). If he reads a book one weekend, then he will take part in one

There exists an unclassified data set with hidden data structures in it. The task in this assignment is to perform comprehensive Cluster Analysis in order to reveal the structures

Explain any two applications of statistics

Advantages of Sampling Why should we settle on a sample instead of studying the entire population?  Sampling has the following advantages over a census (study of the entire pop