Mat 540-Assignment 1

Good Essays
566 Words
Grammar
Plagiarism
Writing
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

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

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

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

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

• 562 Words
• 4 Pages
Good 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
• 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
• 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
• Good Essays

Based on recent records, the manager of a car painting center has determined the following probability distribution for the number of customers per day. Suppose the center has the capacity to serve two customers per day.…

• 5518 Words
• 23 Pages
Good Essays
• Powerful Essays

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

• 1090 Words
• 5 Pages
Powerful Essays
• Satisfactory Essays

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

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

Using these figures, we created a normal distribution and then calculated the number of days frozen in our simulation, using the random number generator.…

• 554 Words
• 3 Pages
Satisfactory 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