Preview

Jet Copies

Powerful Essays
Open Document
Open Document
1218 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Jet Copies
Jet Copies Case 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 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 good one? What are the limits of the study? Write at least one paragraph.
Answers
1.
# of days P(x) Cumulative
1 0.2 0
2 0.45 0.2
3 0.25 0.65
4 0.1 0.9
Q: 2-4.
Break Random times b/w Random Repair Random Lost cumulative down # 1 Break (weeks) # 2 Time #3 Revenue time
1 0.78468 5.314929 0.88991 3 2237 $6,711 5.314929
2 0.512227 4.294201 0.831365 2 3244 $6,488 9.60913
3 0.389251 3.743399 0.912647 2 5874 $11,748 13.35253
4 0.998082 5.994243 0.216353 1 3330 $3,330 19.34677
5 0.963834 5.890502 0.415313 4 5487 $21,948 25.23727
6 0.130715 2.169274 0.201205 1 7810 $7,810 27.40655
7 0.499181 4.239164 0.36532 2 3030 $6,060 31.64571
8 0.461862 4.077625 0.268624 2 3987 $7,974 35.72334
9 0.424543 3.909416 0.802426 3 6846 $20,538 39.63275
10 0.387223 3.733637 0.474831 2 3449 $6,898 43.36639
11 0.349904 3.549162 0.148055 4 6373 $25,492 46.91555
12 0.312585 3.354559 0.24356 4 7206 $28,824 50.27011
13 0.275266 3.147948 0.716607 1 4446 $4,446 53.41806
14 0.237947 2.926787 0.105522 2 4667 $9,334 56.34485
Total Revenue Lost = $167,601

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Jet Copies Mat540

    • 328 Words
    • 2 Pages

    The days to repair component was calculated by using the probability distribution of repair times given. This was used along with a set of random numbers based on 100 breakdowns a year. Then, a vlookup was used and the probability distribution per day to come up with the days to repair, which varies based on the random number that excel generates. The random number represents the probability of how many days it would take to repair the copier.…

    • 328 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Midterm Comm293

    • 5099 Words
    • 21 Pages

    No programmable calculators are permitted. Please show all calculations in an orderly and clear format for part marks. Time management is crucial. Be sure to attempt each question. No questions will be permitted during this examination. If you need to make an assumption, state it and continue. Read the questions carefully before making any assumptions. Question 1 (18 marks; suggested time 18 minutes) Revenue Recognition…

    • 5099 Words
    • 21 Pages
    Better Essays
  • Satisfactory Essays

    Mat 540 Week 1 Assignment

    • 405 Words
    • 2 Pages

    In excel I sued the equation =Rand( ). This new random number column will help me to determine the money lost per day. Next, I created a column that will actually generate the dollar amount of money lost. I used the equation =(400-200)*r=200. I used the mentioned random variable numbers for this new equation. I will use the generated number of days for repair to determine the cost of money loss per breakdown. In excel I use the equation =E2*G2. This uses the days of repair and multiplies this by the money per day lost…

    • 405 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Mat 540-Assignment 1

    • 566 Words
    • 3 Pages

    Jet Copies demonstrates a uniform probability distribution as it pertains to the number of copies sold per day. The average sale is between 2,000 through 8,000 copies a day, at $0.10 a copy. This number is denoted on the excel spreadsheet as r3 by generating a random number between 2,000 and 8,000. To calculate the total amount of business lost on any given day, the following calculations utilized: Lost Revenue = repair time * r3 * 0.10…

    • 566 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Write a 1,050- to 1,750-word paper which addresses the following in reference to the case study:…

    • 479 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Ulcer Bug

    • 1015 Words
    • 5 Pages

    3) In addition to the information in the case presentation (including the web sites contained in the case itself), what other information did you find to determine whether this study represents a successful application of the process of scientific inquiry? For example, you found other studies that reviewed the power of the research method or…

    • 1015 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Week 4 Ilab

    • 813 Words
    • 4 Pages

    * Now we will change the probability of a success to ½. In column C3 enter the words ‘one half’ as the variable name. Use similar steps to that given above in order to calculate the probabilities for this column. The only difference is in Event probability: use 0.5.…

    • 813 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    Salem

    • 923 Words
    • 4 Pages

    2. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour. Jan 1,546 7,896 9,442 329 28.70 0.03 Feb 1,485 7,584 9,069 316 28.70 0.03 Mar 1,697 8,664 10,361 361 28.70 (costs/hours) 0.03 (hours/costs)…

    • 923 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Assignment 2

    • 1856 Words
    • 7 Pages

    worksheet. Define the random variable x as the number of service calls per day. Clearly x is a discrete…

    • 1856 Words
    • 7 Pages
    Good Essays
  • Powerful Essays

    Tanglewood Case 2

    • 1369 Words
    • 6 Pages

    d. Compute year end totals for each job in Table 1.1 and do a gap analysis to determine where shortages will occur in the next year.…

    • 1369 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Decision Making Problem

    • 1292 Words
    • 6 Pages

    For Problems 1-3 below, submit a non-technical consulting report (approximately ½ a page for each…

    • 1292 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    phy lab

    • 405 Words
    • 2 Pages

    VI-1 The results of experiment EC1 part V1 are summarized as below. V, I, Rm are directly measured…

    • 405 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    This study was designed to examine the relationship between the self-efficacy perceptions of middle school principals, the climate of their schools, and the achievement of their students. In the examination of this topic, data were collected from four suburban middle schools located in southeastern Pennsylvania. Information was collected from teachers, principals, and student test data to answer the established research questions.…

    • 591 Words
    • 3 Pages
    Powerful Essays
  • Satisfactory Essays

    3- a) Assume that the average commercial customers demand is 131 hours ((123 + 135 + 138) / 3) for the current situation and the total revenue is;…

    • 441 Words
    • 2 Pages
    Satisfactory Essays