a) Use this information to formulate a linear programming model for the Two-Stage Stochastic Programming problem.

b) Solve it in Excel and give you answers for different scenarios. (For example, in scenario 1, the optimal solution is x1=XXX, x2=YYY, the total profit will be XXX; in scenario 2, the solution will be x1=, x2=, total profit will be )

Stochastic Programming Version of Wyndor Glass Co. Plant Production Time per Batch (Hours) Product 1 2 Production Time Available per Week (Hours) 1 1 0 21 2 0 2 Z2 3 3 2 23 Profit per batch $3,000 $5,000 Costs for one hour capacity: Plant 1: $300 (c1) Plant 2: $360 (c2) Plant 3: $520 (C3) D1, D2: random variables for demands of product 1 and 2 UNC CHARLOTTE 19 Problem 2. Recall the class example for Two-Stage Stochastic Programming, which was extended from our Wyndor Glass company problem. Suppose that the demands have the following distribution. Use C1 = 0.2,C2 = 0.3,C3 = 0.1 for the cost of each hour in plants 1, 2, 3, respectively. = = Demand Outcome Scenario (Product 1, Product 2) Probability 1 (5,5) 0.3 2 (3,6) 0.2 3 (3,8) 0.1 4 (2,5) 0.2 5 (2,8) 0.2 a) Use this information to formulate a linear programming model for the Two-Stage Stochastic Programming problem. b) Solve it in Excel and give you answers for different scenarios. (For example, in scenario 1, the optimal solution is x1=XXX, X2=YYY, the total profit will be XXX; in scenario 2, the solution will be x1=..., X2=..., total profit will be ...)