Preview

Assignment 1 - Quantitative Methods

Powerful Essays
Open Document
Open Document
1089 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Assignment 1 - Quantitative Methods
JET Copies Case Problem page 1

Assignment #1: JET Copies Case Problem

By: Jenna Kiragis

Quantitative Methods 540

7/29/2012

JET Copies Case Problem page 2
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.
Lost revenue of Jet Copies due to breakdown can be done by generating random numbers from different probability distributions according the given probability law.
1. Simulation for the repair time.
|Repair Time (days) |Probability |
|1 |0.2 |
|2 |0.45 |
|3 |0.25 |
|4 |0.1 |

The generated random number 0.2 take repair time = 1. If the generated random number is 0.2 to 0.65, the repair time will be 0.2. The random generated number of 0.65 and 0.90, we take repair time = 3 and take 4 otherwise.
In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown.
2. Simulation for break-down Distribution f(x) =x/18 0 < x < 6 the distribution function of x is F(x)=x2/36 0 < x < 6between 0 and 1, then we can write r1= x2/36
In Excel, use a suitable method for simulating the lost revenue for each day



References: Taylor, B. M. (2010). MAT540: Quantitative methods: 2010 custom edition. Upper http://www.statisticalforecasting.com/forecasting-methods.php

You May Also Find These Documents Helpful

  • Good Essays

    Nt1310 Unit 4 Lab Report

    • 2595 Words
    • 11 Pages

    selects a batch of 13 Blu-ray players from each day’s production. The day’s production is…

    • 2595 Words
    • 11 Pages
    Good Essays
  • 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
  • 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

    When determining the number of days needed to repair a copier, it is best to assume that the number of days is random. It is best to generate this random, which is illustrated on the excel spreadsheet as r2. R2 will be numbers between 0 and 1. To determine this value a random number will be generated in excel. The number of days needed to repair the copier will be determined based on the cumulative outline below:…

    • 566 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Plot a claims distribution with claim size intervals of 10000, 20000, 30000, 50000, and 100000.…

    • 434 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Scenario: Richman Investments provides high-end smartphones to several employees. The value of each smartphone is $500, and approximately 1,000 employees have these company-owned devices. In the past year, employees have lost or damaged 75 smartphones .…

    • 705 Words
    • 7 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
  • Good Essays

    Hrm/531 Week 3 Quiz

    • 1774 Words
    • 8 Pages

    15. The cashier service time at a local bank has an exponential distribution with a mean…

    • 1774 Words
    • 8 Pages
    Good Essays
  • Good Essays

    Math Midterm

    • 1005 Words
    • 5 Pages

    200 imulations runs were completed using the probability of a machine breakdown from the table below . the average number of breakdowns from the simulation trials was 1.93 with a standard deviation of .20.…

    • 1005 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    MAT 2377C Final Exam

    • 3165 Words
    • 13 Pages

    Q1. Suppose that for a very large shipment of integrated-circuit chips, the probability of failure for any one chip is 0.09. Find the probability that at most 2 chips fail in a random sample of size 20. (The numbers are rounded down to the second decimal place). (a) 0.13 (b) 0.90 (c) 0.73 (d)…

    • 3165 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    Suppose the lifetime of a certain type of component is a random variable having an exponential distribution…

    • 1289 Words
    • 6 Pages
    Satisfactory Essays
  • Good Essays

    Exam M Notes F05

    • 8852 Words
    • 134 Pages

    Probability of death between age x and age y: Pr(x < X ≤ z) = FX (z) − FX (x) s(x) =…

    • 8852 Words
    • 134 Pages
    Good Essays
  • Satisfactory Essays

    Jet Copies

    • 430 Words
    • 2 Pages

    The repair time determines how long it will take to repair the copy machines when they breakdown. In order to calculate the repair time we must create a new column for random numbers, Column F. In this column I used the formula =RAND() to find random number 2. Next I used the random number 2 in column F and the lookup tool. In order to get…

    • 430 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Midterm Exam

    • 1263 Words
    • 11 Pages

    Suppose that 50 identical batteries are being tested. After 8 hours of continuous use, assume that a given battery is still operating with a probability of 0.70 and has failed with a probability of 0.30.…

    • 1263 Words
    • 11 Pages
    Satisfactory Essays
  • Good Essays

    Evaluate the statistical analysis packages available for quantitative research. Which statistical analysis packages would be most beneficial for the examination of quantitative data within your study?…

    • 413 Words
    • 2 Pages
    Good Essays