Please solve in EXCEL Chance Constrained Programming

1. IronMan company produces 3 types of steel members: X, Y, and Z. Each of the 3 types would go through two processes A and B whose capacities are under uncertainty.

We want to maximize the total profit subject to the following capacity constraints. For example: the capacity of process A follows a Normal distribution with 400 as the mean and 50 as the standard deviation

	x	y	z	Capacity
A	1	2	1	Normal(400,50)
B	3	2	1	Normal(1000,120)
Profit/Unit	$40	$30	$20

1. Solve the CCP problem; the violation probability for both constraints is less than 0.1 (K0.1=-1.282).
2. If we use only the mean values as the RHS, what is the solution? Is the objective value higher than (a)?
3. If we are more conservative about the constraints. That is, we want to increase the probability thresholds to 0.99 (K0.01=-2.326), what is the solution now?