MAT 540 Assignment #1 Should Jet Copies Buy a funding Copier? By Richard C. King Prof. Angel Martinez MAT540054VA005-1118-001: quantifiable Methods October 30, 2011 1. assume Number of eld to Repair The sample for the glass of days to repair a duplicator employ the inclination used in a ergodic Number genesis RAND() in tower E, and base on the Cumulative opportunity data listed below: Repair beat Distribution| hazard| Cum Probability| Repair metre (days)| 0.2| 0| 1| 0.45| 0.2| 2| 0.25| 0.65| 3| 0.1| 0.9| 4| The spirit =VLOOKUP(E20,$C$8:$D$11,2) which was used in pillar F based on the following correlation: 0 < RAND() < 0.2 is listed as 1 Day 0.2 < RAND() < 0.65 is listed as 2 Days 0.65 < RAND() < 0.90 is listed as 3 Days 0.9 < RAND() < 1 is listed as 4 Days 2. Model Number of Weeks mingled with Breakdowns The model for number of weeks in the midst of copier breakdowns used a chance distribution of the haphazard variable star that varied amongst the numbers of weeks 0 to 6. It was based on the luck would be increasing as time goes on.
An approximation of this model by the function of x listed below: fx=x18 for 0<x<6 and so the distribution function is: fx=x236 for 0<x<6 When applying this equation in tower C to a random number that is between 0 and 1 in Column B hence: Random Number=x236 or x=6Random Number 3. Model unconnected Revenue due to Breakdowns The number of copies made per day is a uniform probability distribution between 2000 to 8000 copies sold, the le gislation used is a =+RANDBETWEEN(2000,6000)! . This entrust generate a random number in Column G between 2000 and 8000 only, the limits of the model. The next formula in Column H used is the =0.1*G49*F49 which multiples the appeal of a single paginate of copy at $0.10 with the Number of days of repair and the random number of copies made per day. This formula provides cost of business losings per repair....If you want to get a rich essay, order it on our website: BestEssayCheap.com
If you want to get a full essay, visit our page: cheap essay
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.