Chapter 9, Problem 55P

Comparative Income Statements and Management Analysis

Pepper’s Products manufactures and sells two types of chew toys for pets, Squeaky and Silent. In May, Pepper’s Products had the following costs and revenues:

Pepper’s Products currently uses labor costs to allocate all overhead but is considering implementing an activity-based costing system. After interviewing the sales and production staff, management decides to allocate administrative costs on the basis of direct labor costs but to use the following bases to allocate the remaining overhead:

Required

1. a.      Complete the income statement using the preceding activity bases.
2. b.      Write a report indicating how management might use activity-based costing to reduce costs.
3. c.       Restate the income statement for Pepper’s Products using direct labor costs as the only overhead allocation base.
4. d.      Write a report to management stating why product line profits differ-using activity based costing compared to the traditional approach. Indicate whether activity-based costing provides more accurate information and why (if you believe it does provide more accurate information). Indicate in your report how the use of labor-based overhead allocation could cause management at Pepper’s Products to make suboptimal decisions.

To determine

Complete the income statement using preceding activity bases.

Explanation of Solution

Activity-based costing:

Activity-based costing refers to the method of costing where the overhead cost is assigned to various products. This costing method identifies the relationship between the manufacturing overhead costs and the activities. This relationship is then used to allocate indirect costs to the products.

Complete the income statement using preceding activity bases:

Particulars	Squeaky	Silent	Total
Sales revenue	$43,200	$48,000	$91,200
Direct materials	$4,000	$4,000	$8,000
Direct labor	$9,600	$14,400	$24,000
Overhead costs:
Add: Administration $\left(\begin{array}{l}\text{Percentage of direct labor }\left(1\right)\\ \times \text{ Direct labor}\end{array}\right)$	$2,400	$3,600	$6,000
Add: Production setup $\left(\begin{array}{l}Rate\text{ per setup }\left(2\right)\\ \times \text{ Number of setups}\end{array}\right)$	$8,000	$4,000	$12,000
Add: Quality control $\left(\begin{array}{l}Rate\text{ per inspection }\left(3\right)\\ \times \text{ Number of inspections}\end{array}\right)$	$4,500	$1,500	$6,000
Add: Distribution $\left(\begin{array}{l}Shipping\text{ c}ost\text{ per unit }\left(4\right)\\ \times \text{ Units shipping}\end{array}\right)$	$1,920	$2,880	$4,800
Total overhead costs	$16,820	$11,980	$28,800
Operating profit $\left(\begin{array}{l}\mathrm{Re}venue\\ -\text{ Total overhead cost}\\ -\text{ Direct materials}\\ -\text{ Direct labor}\end{array}\right)$	$12,780	$17,620	$30,400

Table: (1)

Working note 1:

Compute the percentage of direct labor applicable:

$\begin{array}{c}Percentage\text{ applicable =}\frac{\text{Administrative costs}}{Direct\text{ labor costs}}\times 100\\ =\frac{\text{\$6,000}}{\$24,000}\times 100\\ =0.25\times 100\\ =25\%\end{array}$

Working note 2:

Compute the rate per setup:

$\begin{array}{c}\text{Rate per setup = }\frac{\text{Production setup costs}}{\mathrm{Pr}oduction\text{ runs}}\\ =\frac{\$12,000}{15}\\ =\$800\end{array}$

Working note 3:

Compute the rate per inspection:

$\begin{array}{c}\text{Rate per inspection = }\frac{\text{Quality control costs}}{Number\text{ of inspections}}\\ =\frac{\$6,000}{40}\\ =\$1,800\end{array}$

Working note 4:

Compute the shipping cost per unit:

$\begin{array}{c}\text{Shipping cost per unit = }\frac{\text{Distribution costs}}{\text{Number of units shipped}}\\ =\frac{\$4,800}{40,000}\\ =\$0.12\end{array}$

To determine

Write a brief report indicating how management could use activity-based costing to reduce costs

Explanation of Solution

Activity-based costing:

Activity-based costing (ABC) refers to the method of costing where the overhead cost is assigned to various products. This costing method identifies the relationship between the manufacturing overhead costs and the activities. This relationship is then used to allocate indirect costs to the products.

ABC method for reducing the cost:

Reduction in the cost of activities may not be the direct result of implementing the ABC method of costing, but it can highlight the activities where the cost reduction can be made. Reducing the setup costs or other overhead costs specifically from the perspective of cost reduction can be identified using the ABC method of costing.

To determine

Restate the income statement according to the information given in the question.

Explanation of Solution

Recompute the income statement according to the information given in the question:

Particulars	Squeaky	Silent	Total
Sales revenue	$43,200	$48,000	$91,200
Direct materials	$4,000	$4,000	$8,000
Direct labor	$9,600	$14,400	$24,000
Overhead costs $\left(\begin{array}{l}Overhead\text{ rate }\left(5\right)\\ \times \text{ Direct labor costs}\end{array}\right)$	$11,520	$17,280	$28,800
Operating profit	$18,080	$12,320	$30,400

Table: (2)

Working note 5:

$\begin{array}{c}Overhead\text{ rate = }\frac{Over\text{head costs}}{Direct\text{ labor costs}}\times 100\\ =\frac{\$28,800}{\$24,000}\times 100\\ =1.2\times \text{ 100}\\ \text{= 120\%}\end{array}$

To determine

Write a report to management stating why product line profits differ using activity-based costing compared to the traditional approach. Indicate whether activity-based costing provides more accurate information and provide a reason for the same.

Explanation of Solution

Purpose of the report:

To explain the difference between the implementation of ABC costing and traditional labor-based costing method for the computation of the product line profits.

The implication of both the methods:

Direct costs do not differ in both the methods implemented. While using the labor-based method, all the overhead costs are computed under one single head and while using ABC the bifurcation of cost drivers is relevant to their respective cost of allocation

Result using the traditional labor-based method of costing:

The result shows that the product Squeaky has made a profit of $18,080 which is 41% percent of the sales revenue. And the product Silent has attained a profit of $12,320 which is 25% of sales revenue.

Result using the ABC method of costing:

The result shows that the product Squeaky has attained a profit of $12,780 which is 30% percent of the sales revenue. And the product Silent has incurred the loss of $17,620 which is 36% of sales revenue.

Conclusion:

The choice of a method adapted should be ABC costing as the results computed from the traditional labor-based method are fluctuating.