Stochastic Programming Newsvendor Problem
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Stochastic Programming: Two Stage Solution for the Newsvendor Problem
2
3
Instructions: The objective is to determine the order size that maximizes expected return. This spreadsheet uses the OpenSolver Add-on. The Green cells denote user input, yellow are decision variablez determined by the solver, and the red cell is the problem objective.
4
5
Retail Price (r)10
Value of the Stochastic Solution
37.50
6
Cost (c)6
Value of Perfect Information
175.00
7
Salvage Value (w)
2(r-c)/(r-w)0.50
8
Order Quantity (x)
125
9
10
11
Two Stage Stochastic Programming Solution (Maximize Expected Profit)
12
ScenarioProbabilityDemandNo. OrderedNo. SoldNo. SalvagedProfit
13
Low Demand0.25751257550100.00
14
Medium Demand0.501251251250500.00
15
High Demand0.252501251250500.00
16
400.00
17
18
Expected Value of the Mean Solution (Set Order equal to Mean Demand)
19
ScenarioProbabilityDemandNo. OrderedNo. SoldNo. SalvagedProfit
20
Low Demand0.2575144756925.00
21
Medium Demand0.5012514412519425.00
22
High Demand0.252501441440575.00
23
143.75
<< Mean Demand
362.50
24
25
Expected Value of Perfect Information (Unrealistic)
26
ScenarioProbabilityDemandNo. OrderedNo. SoldNo. SalvagedProfit
27
Low Demand0.257575750300.00
28
Medium Demand0.501251251250500.00
29
High Demand0.2525025025001000.00
30
^^ Order is equal to Demand
575.00
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
__OpenSolver__