Question: Please help on this Scenario Manager excel problem. The link to the Excel file will be posted below (copy and paste into another tab or
Please help on this Scenario Manager excel problem. The link to the Excel file will be posted below (copy and paste into another tab or browser for access), thanks again

Updated Excel File: https://1drv.ms/x/s!AnWxTJTVVD_IgQLw6zb64_JHrJ3T
Using the Scenario Manager, create three scenarios using the data in the table below: Small Medium Large Default Plan: Price Per Unit Marketing Expense $124 $12,000 $131 $19,000 $136 $19,500 Discount Plan: Price Per Unit Marketing Expense $112 $9,000 $117 $14,000 $125 $17,000 Greedy Plan: $170 $7,750 Price Per Unit $195 $8,500 $210 $9,250 Marketing Expense Create a Scenario Summary by using the Gross Profit, Contribution Margin, Total Fixed Expenses and the Marginal Income Before Taxes as your result cells
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
