Assignment 1

Assignment #1

1. In Excel, use a suitable method acting for simulating the interval in the midst of successive breakdowns, according to the continuous dispersion shown?
If you assume that the add up of geezerhood needed to repair a copier is random,you can generate a random subdue denoted r2 between 0 and 1:0 < random observe < 0.2, accordinglyce it takes 1 day 0.2 < random value < 0.65, then it takes 2 days 0.65 < random value < 0.90, then it takes 3 days 0.9 < random value < 1, then it takes 4 days

2. In Excel, use a suitable method for simulating the lost(p) revenue for each day the copier is out of avail?
Intervals between successive breakdowns: The fortune distribution of the random variable varies between the times of 0 to 6 weeks, with the probability increase as time goes on. This can be approximated by the matter F(x) = x/18, for 0?x?6, where x= weeks between car breakdowns Therefore the distribution function is :F(x) = x²/36 for 0?x?6
If we set this equal to another random number r1 that is between 0 and 1 then r1 = x²/36 => x=6*sqrt(r1)

3. Put all of this together to re-create the lost revenue due to copier breakdowns over 1 year to answer the question asked in the case probe?
Since the number of copies sold per day is a uniform probability distribution between 2000 to 8000 copies, r3 is a random number between 2000 and 8000.



To get the amount of business lost on a particular day is r3*repair time, and the lost revenue is then equal to 0.1*r3*repair time, since they charge $0.10 per copy.
4. In a vocalize processing program, write a brief description/ explanation of how you implemented each piece of the model. Write 1-2 paragraphs for each component of the model (days-to-repair; interval between breakdowns; lost revenue; position it together).

1.Repair Distribution

P(x)
Cumulative
Repair Time
0.2
0
1
0.45
0.2
2
0.25
0.65
3
0.1
0.9
4
1.0

Breakdown
Random
Time between
Random
Repair
Random
Lost...If you want to get a full essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper