Question: Base on problem 1 and complete all the colored area and exp. profit on the excel files HELP!!! please help me with this question. Thank

Base on problem 1 and complete all the colored area and exp. profit on the excel files
HELP!!! please help me with this question.
Thank you!
A B D E F G H Capacity Choice Capacity= Leftover Capacity Shortage Extra Capacity Deficient Capacity Cumulative Probability Sales Demand Probability Demand Satisfied 100 0.2 200 0.2 0.3 400 0.13 0.100 600 0.040 700 0.030 300 500 E[sales] Exp. Demand Satisfied E[left] Exp. Extra Capacity E[short] Exp. Capacity Deficiency Exp.Value Exp. Profit Revenue= Secondary Revenue= Cost of Capacity= $ 250.00 per unit $ 85.00 per unit $ 100.00 per unit Exp. Capacity Deficiency 0 0 cu= co= 0 Exp. Demand Satisfied 0 100 200 300 400 500 600 700 Exp. Extra Capacity 0 0 0 0 0 0 0 0 0 0 Exp. Profit $ $ $ $ $ $ $ $ Critical Ratio 0 0 0Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
