Chapter 19, Problem 19.4BPR

1.

To determine

Cost-Volume-Profit Analysis: It is a method followed to analyze the relationship between the sales, costs, and the related profit or loss at various levels of units sold. In other words, it shows the effect of the changes in the cost and the sales volume on the operating income of the company.

To construct: a cost-volume-profit chart indicating the break-even sales for last year.

Explanation of Solution

Construct a cost-volume-profit chart indicating the break-even sales for last year.

Figure (1)

The volume in units of sales is shown on the horizontal axis. The maximum relevant range is 7,500 units. The sales and the total costs (fixed cost and variable cost) in dollars is shown on the vertical axis. The maximum relevant range of sales and total costs is $1,500,000.

The total sales line is drawn right upward by connecting the first point at $0 to the second point at $1,500,000$\left[\text{7,500}\text{units×\$200}\text{per}\text{unit}\right]$ for 7,500 units sold (maximum relevant range on the horizontal axis).

The total cost line is drawn right upward by connecting the first point at $225,000 (fixed cost) on the vertical axis to the second point at $1,162,500$\left[\$225,000+\text{\$937,500}\right]$ at the end of the relevant range. The variable cost is $\$937,500\left(\text{7,500}\text{units×\$125}\text{per}\text{unit}\right)$.

The break-even point is the intersection point where the total sales line and total cost line meet. The vertical dotted line drawn downward from the intersection point reaches at 3,000 units. It indicates the break-even sales (units). The horizontal line drawn to the left towards the vertical axis reaches at $600,000. It indicates the break-even sales (dollars).

The operating profit area is the area where the total sales line exceeds the total cost line. However, the operating loss area is the area where the total cost exceeds the total sales line.

Verify the answer using the break-even equation.

Determine the break-even sales in units.

Fixed cost =$225,000

Contribution margin per unit =$75 per unit (1)

  $\begin{array}{c}\text{Break-even}\text{point}\text{in}\text{Sales}\left(\text{units}\right)=\frac{\text{Fixed}\text{Costs}}{\text{Contribution}\text{Margin}\text{per}\text{unit}}\\ =\frac{\$225,000}{\$75}\\ =3,000\text{units}\end{array}$

Working note:

Compute the contribution margin per unit.

Selling price per unit =$200 per unit

Variable cost per unit =$125 per unit

  $\begin{array}{c}\text{Contribution}\text{Margin}\text{per}\text{unit}\text{=}\left(\begin{array}{l}\text{Selling}\text{price}\\ \text{per}\text{unit}\end{array}\right)-\left(\begin{array}{l}\text{Variable}\text{cost}\\ \text{per}\text{unit}\end{array}\right)\\ \text{=\$200}\text{per}\text{unit}-\text{\$125}\text{per}\text{unit}\\ \text{=\$75}\text{per}\text{unit}\end{array}$ (1)

Determine the break-even sales in dollars.

Fixed cost =$225,000

Contribution margin ratio =37.5% (2)

  $\begin{array}{c}\text{Break-even}\text{point}\text{in}\text{Sales}\left(\text{Dollars}\right)=\frac{\text{Fixed}\text{Costs}}{\text{Contribution}\text{Margin}\text{ratio}}\\ =\frac{\$225,000}{37.5\%}\\ =\$225,000\times \frac{100}{37.5}\\ =\$600,000\end{array}$

Working note:

Determine the contribution margin ratio.

Contribution margin =$75 per unit (1)

Selling price per unit =$200 per unit

  $\begin{array}{c}\text{Contribution}\text{Margin}\text{Ratio }=\frac{\text{Contribution}\text{Margin}}{\text{Sales}}\times 100\\ =\frac{\$75perunit}{\$200perunit}\times 100\\ =37.5\%\end{array}$ (2)

2.

To determine

 (A) the income from operations for last year and (B) the maximum income from operations that could have been realized during the year using the cost-volume-profit chart..

Explanation of Solution

Determine (A) the income from operations for last year and (B) the maximum income from operations that could have been realized during the year.

Figure (2)

(A)

Last year, the number of units sold is 4,500 units (3). The total sales is $900,000. The total cost is $\$787,500\left[\$225,000+\text{\$562,500}\right]$ for 4,500 units sold. The fixed cost is $225,000. The variable cost is $\$562,500\left(\text{4,500}\text{units×\$125}\text{per}\text{unit}\right)$. A dotted line is drawn from the total sales at $900,000 on the vertical axis towards the right and a dotted line is drawn upward for the 4,500 units sold from the horizontal axis. The two dotted line meet at a point which indicates the point of sales at 4,500 units.

Similarly, a dotted line is drawn from the total cost at $787,500 on the vertical axis towards the right and a dotted line is drawn upward for the 4,500 units sold from the horizontal axis. The two dotted line meet at a point which indicates the point of total cost at 4,500 units.

The dotted line from sales is above the dotted line for total cost. This indicates the income from operations. Thus, the area in between the two dotted lines is the income from operations of $\$112,500\left(\$900,000-\$787,500\right)$.

(B)

The maximum relevant range for number of units to be sold is 7,500 units. Thus, the total sales are $\$1,500,000\left[\text{7,500}\text{units×\$200}\text{per}\text{unit}\right]$. The total cost is $\$1,162,500\left[\$225,000+\text{\$937,500}\right]$ for 7,500 units sold. The fixed cost is $225,000. The variable cost is $\$937,500\left(\text{7,500}\text{units×\$125}\text{per}\text{unit}\right)$. A dotted line is drawn from the total sales at $1,500,000 on the vertical axis towards the right and a dotted line is drawn upward for the 7,500 units sold from the horizontal axis. The two dotted line meet at a point which indicates the point of sales at 7,500 units.

Similarly, a dotted line is drawn from the total cost at $1,162,500 on the vertical axis towards the right and a dotted line is drawn upward for the 7,500 units sold from the horizontal axis. The two dotted line meet at a point which indicates the point of total cost at 7,500 units.

The dotted line from sales is above the dotted line for total cost. This indicates the income from operations. Thus, the area in between the two dotted lines is the income from operations of $\$337,500\left(\$1,500,000-\$1,162,500\right)$.

Verify the answers using the mathematical approach to cost-volume-profit analysis.

(A)

Determine the income from operations for the last year.

Determine the income from operations for 4,500 units
Particulars	Amount ($)	Amount ($)
Sales		900,000
Less: Fixed costs	225,000
Variable costs $\left[4,500\text{units}\left(3\right)\text{×\$125}\text{per}\text{unit}\right]$	562,500	(787,500)
Income from operations		112,500

Table (1)

Working note (3):

Determine the number of units sold.

Sales =$900,000

Selling price per unit =$200 per unit

  $\begin{array}{c}\left(\begin{array}{l}\text{Number}\text{of}\text{units}\\ \text{sold}\end{array}\right)=\frac{\text{Sales}}{\left(\begin{array}{l}\text{Selling}\text{price}\\ \text{per}\text{unit}\end{array}\right)}\\ =\frac{\$900,000}{\text{\$200}\text{per}\text{unit}}\\ =4,500\text{units}\end{array}$

(B)

Determine the maximum income from operations that could have been realized during the year.

Determine the income from operations for 7,500 units
Particulars	Amount ($)	Amount ($)
Sales $\left[\text{7,500}\text{units×\$200}\text{per}\text{unit}\right]$		1,500,000
Less: Fixed costs	225,000
Variable costs $\left[\text{7,500}\text{units×\$125}\text{per}\text{unit}\right]$	937,500	(1,162,500)
Income from operations		337,500

Table (2)

3.

To determine

To construct: a cost-volume-profit chart indicating the break-even sales for the current year.

Explanation of Solution

Construct a cost-volume-profit chart indicating the break-even sales for the current year.

Figure (3)

The volume in units of sales is shown on the horizontal axis. The maximum relevant range is 7,500 units. The sales and the total costs (fixed cost and variable cost) in dollars is shown on the vertical axis. The maximum relevant range of sales and total costs is $1,600,000.

The total sales line is drawn right upward by connecting the first point at $0 to the second point at $900,000$\left[\text{4,500}\text{units×\$200}\text{per}\text{unit}\right]$ for 4,500 units sold (maximum relevant range on the horizontal axis).

The total cost line is drawn right upward by connecting the first point at $\$337,500\left[\$225,000+\text{\$112,500}\right]$ (total fixed cost) on the vertical axis to the second point at $1,275,000$\left[\$337,500+\text{\$937,500}\right]$ at the end of the relevant range. The variable cost is $\$562,500\left(\text{4,500}\text{units×\$125}\text{per}\text{unit}\right)$.

The break-even point is the intersection point where the total sales line and total cost line meet. The vertical dotted line drawn downward from the intersection point reaches at 4,500 units. It indicates the break-even sales (units). The horizontal line drawn to the left towards the vertical axis reaches at $900,000. It indicates the break-even sales (dollars).

The operating profit area is the area where the total sales line exceeds the total cost line. However, the operating loss area is the area where the total cost exceeds the total sales line.

Verify the answer using the break-even equation.

Determine the break-even sales in units.

Fixed cost =$225,000

Increase in fixed cost (billboard advertising) =$112,500

Contribution margin per unit =$75 per unit (1)

  $\begin{array}{c}\text{Break-even}\text{point}\text{in}\text{Sales}\left(\text{units}\right)=\frac{\text{Total}\text{Fixed}\text{Costs}}{\text{Contribution}\text{Margin}\text{per}\text{unit}}\\ =\frac{\$225,000+\$112,500}{\$75}\\ =\frac{\$337,500}{\$75}\\ =4,500\text{units}\end{array}$

Determine the break-even sales in dollars.

Fixed cost =$225,000

Increase in fixed cost (billboard advertising) =$112,500

Contribution margin ratio =37.5% (2)

  $\begin{array}{c}\text{Break-even}\text{point}\text{in}\text{Sales}\left(\text{Dollars}\right)=\frac{\text{Total}\text{Fixed}\text{Costs}}{\text{Contribution}\text{Margin}\text{ratio}}\\ =\frac{\$225,000+\$112,500}{37.5\%}\\ =\frac{\$337,500}{37.5\%}\\ =\$337,500\times \frac{100}{37.5}\\ =\$900,000\end{array}$

4.

To determine

(A) the income from operations for sales 6,000 units and (B) the maximum income from operations that could have been realized during the year using the cost-volume-profit chart..

Explanation of Solution

Determine (A) the income from operations for sales 6,000 units and (B) the maximum income from operations that could have been realized during the year.

Figure (4)

(A)

The number of units sold is 6,000 units. The total sales is $\$1,200,000\left(\text{6,000}\text{units×\$200}\text{per}\text{unit}\right)$. The total cost is $\$1,087,500\left[\$337,500+\text{\$750,000}\right]$ for 6,000 units sold. The total fixed cost is $\$337,500\left[\$225,000+\text{\$112,500}\right]$. The variable cost is $\$750,000\left(\text{6,000}\text{units×\$125}\text{per}\text{unit}\right)$. A dotted line is drawn from the total sales at $1,200,000 on the vertical axis towards the right and a dotted line is drawn upward for the 6,000 units sold from the horizontal axis. The two dotted line meet at a point which indicates the point of sales at 6,000 units.

Similarly, a dotted line is drawn from the total cost at $1,087,500 on the vertical axis towards the right and a dotted line is drawn upward for the 6,000 units sold from the horizontal axis. The two dotted line meet at a point which indicates the point of total cost at 6,000 units.

The dotted line from sales is above the dotted line for total cost. This indicates the income from operations. Thus, the area in between the two dotted lines is the income from operations of $\$112,500\left(\$1,200,000-\$1,087,500\right)$.

(B)

The maximum relevant range for number of units to be sold is 7,500 units. Thus, the total sales are $\$1,500,000\left[\text{7,500}\text{units×\$200}\text{per}\text{unit}\right]$. The total cost is $\$1,275,000\left[\$337,500+\text{\$937,500}\right]$ for 7,500 units sold. The total fixed cost is $\$337,500\left[\$225,000+\text{\$112,500}\right]$. The variable cost is $\$937,500\left(\text{7,500}\text{units×\$125}\text{per}\text{unit}\right)$. A dotted line is drawn from the total sales at $1,500,000 on the vertical axis towards the right and a dotted line is drawn upward for the 7,500 units sold from the horizontal axis. The two dotted line meet at a point which indicates the point of sales at 7,500 units.

Similarly, a dotted line is drawn from the total cost at $1,275,000 on the vertical axis towards the right and a dotted line is drawn upward for the 7,500 units sold from the horizontal axis. The two dotted line meet at a point which indicates the point of total cost at 7,500 units.

The dotted line from sales is above the dotted line for total cost. This indicates the income from operations. Thus, the area in between the two dotted lines is the income from operations of $\$225,000\left(\$1,500,000-\$1,275,000\right)$.

Verify the answers using the mathematical approach to cost-volume-profit analysis.

(A)

Determine the income from operations for the last year.

Determine the income from operations for 6,000 units
Particulars	Amount ($)	Amount ($)
Sales $\left[\text{6,000}\text{units×\$200}\text{per}\text{unit}\right]$		1,200,000
Less: Total Fixed costs $\left[\$225,000+\$112,500\right]$	337,500
Variable costs $\left[\text{6,000}\text{units×\$125}\text{per}\text{unit}\right]$	750,000	(1,087,500)
Income from operations		112,500

Table (3)

(B)

Determine the maximum income from operations that could have been realized during the year.

Determine the income from operations for 7,500 units
Particulars	Amount ($)	Amount ($)
Sales $\left[\text{7,500}\text{units×\$200}\text{per}\text{unit}\right]$		1,500,000
Less: Total Fixed costs $\left[\$225,000+\$112,500\right]$	337,500
Variable costs $\left[\text{7,500}\text{units×\$125}\text{per}\text{unit}\right]$	937,500	(1,275,000)
Income from operations		225,000

Table (4)