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

Question

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

Quizplus · Accepted Answer

To update the data in the worksheet, Beckham should change the relevant items in the Assumptions section of the worksheet, and Excel will recalculate the data table automatically. This is the easiest and most efficient option. Changing the worksheet to a two-variable data table would not be necessary in this case, as there is only one variable that has changed. Calculating the changes manually could be time-consuming, and there is a higher risk of making mistakes. Therefore, the best option is to update the Assumptions section in Excel.

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