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 34. Then insert a new row below row 11 that lists the probabilities of these demands. Next, in the rows below the Profit Model label, calculate the units sold, revenue, cost, and profit for each demand. For example, the quantities in column C will be for the second possible demand. Finally, use SUMPRODUCT to calculate expected profit below the Profit row.

Step by Step Solution

3.46 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Model Ordering decision with quantity discounts Range names used CostLookup ModelD5E9 Inputs Quantit... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

1497_605b07bfeb642_696406.xlsx

300 KBs Excel File

Students Have Also Explored These Related Practical Management Science Questions!