Solved

Beckham Created the Worksheets Above to Show the Profitability and Break-Even

Question 89

Multiple Choice

   Beckham created the worksheets above to show the profitability and break-even points for his company. Please refer to the figure above as you answer the questions below. -Beckham has received new information regarding some of the assumptions. The estimate of the COGS per unit has changed from $75.75 to $95.00, and the estimated marketing expense has been cut from $75,000 to $60,000. What should Beckham do to show this change in the worksheet above? A)  Calculate the changes manually to ensure the integrity of the data table. B)  Change the worksheet to a two-variable data table. C)  Change those items in the Assumptions section of the worksheet, and Excel will recalculate the data table. D)  none of the above
Beckham created the worksheets above to show the profitability and break-even points for his company. Please refer to the figure above as you answer the questions below.
-Beckham has received new information regarding some of the assumptions. The estimate of the COGS per unit has changed from $75.75 to $95.00, and the estimated marketing expense has been cut from $75,000 to $60,000. What should Beckham do to show this change in the worksheet above?


A) Calculate the changes manually to ensure the integrity of the data table.
B) Change the worksheet to a two-variable data table.
C) Change those items in the Assumptions section of the worksheet, and Excel will recalculate the data table.
D) none of the above

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions