requirea intormation

LAB $2-4($LO $2-7)$ Alternate: Prescriptive Analytics: Sensitivity Analysis of Profitability under Changing Volume, Sales Price, and Fixed and Variable Cost Assumptions

$[$The following information applies to the questions displayed below.$]$

Lab Insight: Apply the same base scenario as Lab $2-4$ to Alt Lab $2-4,$ but now vary the fixed costs from $500$ to $3,000($in increments of $250)$ and vary sales price from $$5$ to $$50($increments of $$5)$ and see how profitability varies on these two dimensions.

Required:

Determine how sensitive the profits are with changing assumptions of the level of total fixed costs and sales price.

Apply conditional formatting to the differing levels of profitability in the data table.

Data File: Use your previous created data file from regular lab $2-4.$ There is no separate data file provided for this lab.

Perform the Analysis: Refer to Lab $2-4$ in the text for lab instruction steps.

Lab $2-4$ Alternate: Assessment Questions

Answer the following questions based the details provided.

Note: Enter a loss as a negative number. Answer will display in parenthesis.

$\backslash$table$[[$Question$,$Answer$],[1.$ If the sales price is $$15,$ and fixed costs are $500,$ what are the expected profits $($all other things equal$)?,$$