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

---

Definitions:

Collective Bargaining Process

A negotiation process between employers and a group of employees aimed at reaching agreements to regulate working salaries, working conditions, and other aspects of workers' compensation and rights.

Grievance Procedure

A formalized procedure for resolving disputes if the parties have a disagreement regarding the interpretation of a term of the collective agreement.

Preparation

The act or process of making ready or being made ready for use or consideration.

Conciliation

A method of dispute resolution where a neutral third party assists the disputing parties in reaching a voluntary agreement.