Question: The current spreadsheet model essentially finds the expected profit in several steps. It first finds the profit in cell B19 for a fixed value of
The current spreadsheet model essentially finds the expected profit in several steps. It first finds the profit in cell B19 for a fixed value of demand. Then it uses a data table to find the profit for each of several demands, and finally it uses SUMPRODUCT to find the expected profit. Modify the model so that expected profit is found directly, without a data table. To do this, change row 11 so that instead of a single demand, there is a list of possible demands, those currently in row
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
