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

Ask an Expert

Your posts are moderated

Write your message here..

Related Questions

Carpal tunnel statistics, Cindy, the Assistant Vice President of Engineerin... 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

Calculate the ratio of the sample standard deviation, The Case Study includ... 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

Test the null hypothesis, A consumer preference study involving three diffe... 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

Correlation matrix table, A.    Do the correlation matrix table. B.    W... 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, Linear Regression Generally, in two mutually related... 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

X-bar charts, First we look at these charts assuming that we know both the ... 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

Markov Chain, Each weekend, Derek either reads a book (B), goes to the cine... 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

Implement a simple k-means method, There exists an unclassified data set wi... 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

Statisttics., Explain any two applications of statistics Explain any two applications of statistics

Advantages of sampling, Advantages of Sampling Why should we settle on ... 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