SKI.XLS Ski Jacket Simulation
Variable Cost (C) 80 Mean demand 12,000
Selling Price (S) 100 Standard deviation 3,500
Salvage value (V) 30 Demand (D) ннн 12,000 [1]
Fixed Cost (F) 100,000
Salvage Variable
Quantity (Q) Revenue Value Cost Profit
ннннннннннн 6,000  [2]
ннннннннннн 8,000  [3]
нннннннннн 10,000  [4]
нннннннннн 12,000  [5]
нннннннннн 14,000  [6]
 

[1]
Assumption: Demand
Normal distribution
нн Mean 12,000 (=G3)
нн Standard Dev. 3,500 (=G4)
Selected range is
нн fromн -Infinity toн +Infinity
[2]
Forecast: Profit
[3]
Forecast: E11
[4]
Forecast: E12
[5]
Forecast: E13
[6]
Forecast: E14