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 Case Problem (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 information given from the case study to make it easier to find it and copy, if necessary. I used the RAND() function in to create random values for column F4:F16. After created the RAND()values, I copied and pasted the values in the column F4:F16 because I needed to freeze the number, otherwise it would keep changing. Using the random probabilities numbers created previously by the function RAND(). I used Excel function VLOOKUP to find the number of days needed to repair =VLOOKUP(F4,LookUp,2) to =VLOOKUP(F16,LookUp,2) and the sum gave me the information of number of days needed to repair the copier.=2 days. Per the calculations, the average repair time is 2 days. Model number of weeks between breakdowns

In regard to the second part of the case (The average number of weeks between breakdowns), to find the time between breakdowns in weeks, I used the maximum number of 6 weeks which is in cell I4, and I used formula =6*SQRT(H4). I pulled the formula down and erase the numbers that exceed 52 weeks, once the problem wanted to find the cost of breakdowns over a year only. For each information required I calculate a total =SUM(I4:I28) = 53.67. The average time between breakdowns is 4.13 (or 4.00 rounded) weeks. Model lost revenue due to breakdowns

In regard to the third part of the case (Lost revenue due to copier being out of service), I first had to find the uniform probability distribution between 2,000 and 8,000 (the estimated copies per day by the owners). To find the numbers of copies lost, I used the formula =6000*J4+2000 and I pulled the formula down...

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

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

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

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

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

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

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

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

1218 Words |
4 Pages

Share this Document

{"hostname":"studymode.com","essaysImgCdnUrl":"\/\/images-study.netdna-ssl.com\/pi\/","useDefaultThumbs":true,"defaultThumbImgs":["\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_1.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_2.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_3.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_4.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_5.png"],"thumb_default_size":"160x220","thumb_ac_size":"80x110","isPayOrJoin":false,"essayUpload":false,"site_id":1,"autoComplete":false,"isPremiumCountry":false,"userCountryCode":"US","logPixelPath":"\/\/www.smhpix.com\/pixel.gif","tracking_url":"\/\/www.smhpix.com\/pixel.gif","cookies":{"unlimitedBanner":"off"},"essay":{"essayId":37269226,"categoryName":"Literature","categoryParentId":null,"currentPage":1,"format":"text","pageMeta":{"text":{"startPage":1,"endPage":3,"pageRange":"1-3","totalPages":3}},"access":"premium","title":"Jet Copies Case Problem","additionalIds":[16,184,5,79,3],"additional":["Law","Law\/Intellectual Property","Computer Science","Computer Science\/Software Development","Business \u0026 Economy"],"loadedPages":{"html":[],"text":[1,2,3]}},"user":null,"canonicalUrl":"http:\/\/www.studymode.com\/essays\/Jet-Copies-Case-Problem-1497329.html","pagesPerLoad":50,"userType":"member_guest","ct":10,"ndocs":"1,500,000","pdocs":"6,000","cc":"10_PERCENT_1MO_AND_6MO","signUpUrl":"https:\/\/www.studymode.com\/signup\/","joinUrl":"https:\/\/www.studymode.com\/join","payPlanUrl":"\/checkout\/pay","upgradeUrl":"\/checkout\/upgrade","freeTrialUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fcheckout%2Fpay%2Ffree-trial\u0026bypassPaymentPage=1","showModal":"get-access","showModalUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fjoin","joinFreeUrl":"\/essays\/?newuser=1","siteId":1,"facebook":{"clientId":"306058689489023","version":"v2.8","language":"en_US"},"analytics":{"googleId":"UA-32718321-1"}}