Preview

Mat 540-Assignment 1

Good Essays
Open Document
Open Document
566 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Mat 540-Assignment 1
Days-to-Repair
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: 0.00 > r2 < 0.20, then it will take 1 day; 0.20 > r2 < 0.65, then it will take 2 days; 0.65 > r2 < 0.90, then it will take 3 days; and 0.90 > r2 < 1.00, then it will take 4 days.
Intervals between Breakdowns
Intervals between breakdowns are a probability distribution. The variables will be random and range between 0 through 6 weeks. As the time continues, the probability will increase. To determine this number a function of x will be used, as illustrated. F(x) = x/18, for 0 thru 6, where 'x' equals the weeks between machine breakdowns F(x) = x2/36, for 0 thru 6, this is the distribution function that can be further simplified r1 = x2/36, to simplify set the equation equal to r1 x = 6 * SQRT (r1), final equation. Lost Revenue 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 The total amount of lost revenue is $20,166.30. This number is not totally accurate, but is an approximation of lost. The amount will always change significantly because r1, r2, and r3 are numbers generated randomly. To get a close approximation the breakdown will have to consist of 365 to account for

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

    Assignment 2

    • 1856 Words
    • 7 Pages

    Office Support, Inc. provides on-site repair for most large photocopy machines. It currently has five…

    • 1856 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Mat 540 Assignment 3

    • 293 Words
    • 2 Pages

    Based on the LP model to maximize profit with the established constraints Julia should sell pizza and hotdogs and not BBQ sandwiches. Based on this model Julia will earn $2250.00 in profit. After buying food supplies for the next game she will have $750 remaining ($2250-1500). Julia’s goal was to clear $1000 in profit which she was not able to meet. It is not clear how Julia is paying for the booth rental each game, but assuming she is covering the costs with her profits from the prior game she will need $1000 for the booth + $1500 for food which equals $2500 she needs to make each game just to cover her expenses.…

    • 293 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    MAT 540 Quiz 1

    • 741 Words
    • 3 Pages

    Parameters are known, constant values that are usually coefficients of variables in equations.


Answer
True 
False…

    • 741 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Jet Copies

    • 1218 Words
    • 5 Pages

    2. In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown.…

    • 1218 Words
    • 5 Pages
    Powerful Essays
  • Better Essays

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

    • 808 Words
    • 4 Pages
    Better Essays
  • Good Essays

    MAT 540 MIDTERM EXAM

    • 562 Words
    • 4 Pages

    10. It's often ____________ to validate that the results of a simulation truly replicate reality.…

    • 562 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Brs Mdm3 Tif Ch07

    • 2550 Words
    • 19 Pages

    3) Refer to the figure. What is the slack time, in days, associated with activity E?…

    • 2550 Words
    • 19 Pages
    Powerful Essays
  • Powerful Essays

    Cardio Lab Report

    • 1090 Words
    • 5 Pages

    * Exploration: Answer the questions. The questions in the Exploration section are the same questions in your CardioLab instructions.…

    • 1090 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    The following is the probability distribution function of the number of complaints a customer manager has to handle in half an hour.…

    • 5518 Words
    • 23 Pages
    Good Essays
  • Powerful Essays

    Mat 540 Assignment 1

    • 1196 Words
    • 5 Pages

    This causes the shape of the box plot to be quite spread out with the median and quartiles close together. The female writing hand box plot is also the same length as the writing hand box plot; this is because the minimum and maximum data from the writing hand came from females. When putting the male and female writing hand box plots in comparison to each other, you can see that females have a much larger range than the males as discussed before. This causes the female box plot to have a lower, lower quartile and median and a higher upper quartile. The median for males is only slightly higher than the median for females, keeping in mind that males had data from an eleven (11) year old and females had data from a forty two (42) year old. This can cause the data to be slightly swayed as there were not equal age groups for both box…

    • 1196 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Fi515 Homework4

    • 668 Words
    • 3 Pages

    Boehm Incorporated is expected to pay a $1.50 per share dividend at the end of this year (i.e., D1 = $1.50). The dividend is expected to grow at a constant rate of 7% a year. The required rate of return on the stock, rs, is 15%. What is the value per share of Boehm’s stock?…

    • 668 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Mat 540 Quiz

    • 759 Words
    • 4 Pages

    Information technology (IT) consists of all the hardware that a firm needs to use in order to…

    • 759 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    MAT 540 Week 4 Homework

    • 783 Words
    • 6 Pages

    b. Compute a weighted 3-month moving average forecast for months 4 through 9. Assign weights of 0.55,0.33,and 0.12 to the months in sequence, starting with the most recent month.…

    • 783 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Case study

    • 253 Words
    • 2 Pages

    Hint: Use all of the data from both columns. A defect is any value greater than 60. There are 88 total data points/opportunities and there is only one opportunity for a defect per unit (over the timeframe or within the timeframe).…

    • 253 Words
    • 2 Pages
    Satisfactory Essays