Excel demo of 3, 7, 8,9

Excel demo of 3, 7, 8,9 - 130 2 1 0.6 0.88 180 1 0.9 0.63...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Spares req EMV 0 1 2 3 0 0 4000 8000 12000 5600 Spares carried 1 3000 3000 7000 11000 5400 2 6000 6000 6000 14000 6800 3 9000 9000 9000 9000 9000 Prob 0.2 0.3 0.4 0.1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Costs Breakdowns Utility cost Utility Breakdown MAU k1 k2 20000 0 0.8 1 0.900 0.7 0.5 20000 1 0.8 0.9 0.866 30000 0 0.3 1 0.650 30000 1 0.3 0.9 0.606 15000 0 1 1 1.000 15000 1 1 0.9 0.970 15000 2 1 0 0.700 35000 0 0 1 0.500 35000 1 0 0.9 0.450 35000 2 0 0 0.000 U 0.6 0.4 0.15 0.85 ZETA 0.77 0.87 0.61 0.5 0.5 0.2 0.7 0.1 PII 0.68 0.95 0.42
Background image of page 2
k3 -0.2 Calulation formulas in yellow
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Weight Lifetime U Weight U Life MAU k1 k2 k3 130 1 1 0 0.7 0.7 0.3
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 130 2 1 0.6 0.88 180 1 0.9 0.63 180 2 0.9 0.6 0.81 250 2 0.6 0.6 0.6 250 3 0.6 1 0.72 290 2 0.6 0.18 290 3 1 0.3 U 0.6 0.4 0.3 0.7 Plastic 0.8 0.83 0.76 0.7 0.3 0.1 0.9 Metal 0.58 0.71 0.29 Profit Dis Cus U Profit U DC MAU k1 k2 k3 4 2000 1 0.3 0.86 0.8 0.6-0.4 1 0.6 3 5000 0.9 0.72 1 0.4 1 0.76 U 0.7 0.3 Large 0.78 0.7 0.3 Small 0.73...
View Full Document

Page1 / 5

Excel demo of 3, 7, 8,9 - 130 2 1 0.6 0.88 180 1 0.9 0.63...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online