Assignment #1: JET Copies Case Problem
123lynda
mat540_jet_copies_set_up_suggestion.xlsxwith formulas
| Jet Copies Simulation Example (52 Weeks) | Jet Copies Simulation Set Up Suggestion by Professor Aungst, MAT540 Supplemental Instructor | Mat540 | ||||||||||||||||||||
| Probability of Weekly Demand: | Note: x = 6*sqrt of r1 is the formula for the time between breakdowns | |||||||||||||||||||||
| Note: z = 6r + 2 is the formula for copies lost | ||||||||||||||||||||||
| Simulation: | ||||||||||||||||||||||
| P(x) | Cumulative | Repair Time | Week | r1 | Time Between Breakdowns, x weeks | Cumulative Time Between Breakdowns | r1 | Repair Time y days | RN for Day1 | RN for Day2 | RN for Day3 | RN for Day4 | Copies Lost Day1 | Copies Lost Day2 | Copies Lost Day3 | Copies Lost Day4 | Revenue Lost Day1 | Revenue Lost Day2 | Revenue Lost Day3 | Revenue Lost Day4 | Total Revenue Lost | |
| 0.20 | 0 | 1 | 1 | 0.1482957274 | 2.3105510566 | 2.3105510566 | 0.1511624354 | 1 | ||||||||||||||
| 0.45 | 0.20 | 2 | 2 | 0.2668388122 | 3.0993865908 | 5.4099376474 | ||||||||||||||||
| 0.25 | 0.65 | 3 | 3 | 0.2211420962 | 2.8215448714 | 8.2314825188 | ||||||||||||||||
| 0.10 | 0.90 | 4 | 4 | 0.4250803299 | 3.9118910871 | 12.1433736059 | ||||||||||||||||
| 1.00 | ||||||||||||||||||||||
| Average Demand = | ||||||||||||||||||||||
| Average Lost Revenue = | ||||||||||||||||||||||
fixed data
| Jet Copies Simulation Example (52 Weeks) | ||||||||||||||||||
| Probability of Weekly Demand: | Simulation: | |||||||||||||||||
| P(x) | Cumulative | Repair Time | r1 | Time Between Breakdowns, x weeks | Sum of x | r1 | Repair Time y days | r1 | r2 | r3 | r4 | Copies lost day 1 (thousands) | Copies lost day 2 (thousands) | Copies lost day 3 (thousands) | Copies lost day 4 (thousands) | Revenue Lost this breakdown | Cummulative lost revenue | |
| 0.2 | 0 | 1 | 0.2619264135 | 3.0707248147 | 3.0707248147 | 0.148949842 | 1 | 0.9313215449 | 0 | 0 | 0 | 7.5879292696 | 0 | 0 | 0 | 758.7929269557 | 758.7929269557 | |
| 0.45 | 0.2 | 2 | ||||||||||||||||
| 0.25 | 0.65 | 3 | ||||||||||||||||
| 0.1 | 0.9 | 4 | ||||||||||||||||
| 1 | ||||||||||||||||||
| Average Demand = | ||||||||||||||||||
| Average Lost Revenue = |
Sheet3
| If loss of revenue > $12,000 should purchase backup | |||||
| Manual simulation for 1 year | |||||
| Need time between breakdowns | |||||
| At 6 week point there is a .33 | 0.055 | 0 | 0 | ||
| 1 | 0.055 | ||||
| 2 | 0.11 | ||||
| 3 | 0.165 | ||||
| First copier is $18,000 | 4 | 0.22 | |||
| Smaller back up copier is $8000 | 5 | 0.275 | |||
| .10 per copy | 6 | 0.33 | |||
| 2000-8000 copies per day |
