Chapter 24, Problem 3AP

To determine

Prepare departmental income statements that show the company’s predicted results of operations for calendar year 2016 for the three operating (selling) departments and their combined totals

Explanation of Solution

Department: A division of the company or an organization which performs the functions of the company is referred to as department.

Prepare departmental income statements.

Company W
Forecasted Departmental Income Statements
For Year Ended December 31, 2016
Particulars	Clock	Mirror	Paintings	Combined
Sales (Refer Table (2))	$140,400	$59,400	$50,000	$249,800
Less: Cost of goods sold (Refer Table (3))	$68,796	$36,828	$22,500	$128,124
Gross profit	$71,604	$22,572	$27,500	$121,676
Less: Direct expenses
Sales salaries	$20,000	$7,000	$8,000	$35,000
Advertising	$1,200	$500	$800	$2,500
Store supplies used (Refer Table (4))	$972	$432	$500	$1,904
Depreciation of equipment	$1,500	$300	$200	$2,000
Total direct expenses (A)	$23,672	$8,232	$9,500	$41,404
Allocated expenses
Rent expense (Refer Table (5))	$5,616	$2,835	$2,349	$10,800
Utilities expense(Refer Table (5))	$2,080	$1,048	$872	$4,000
Share of office department  expenses (Refer Table (6))	$12,364	$5,236	$4,400	$22,000
Total allocated expenses (B)	$20,060	$9,119	$7,621	$36,800
Total expenses $\left(\text{A}\right)+\left(\text{B}\right)$	$43,732	$17,351	$17,121	$78,204
Net income	$27,872	$5,221	$10,379	$  43,472

Table (1)

Working note:

(1) Determine the sales for each department.

Particulars	Clock	Mirror	Paintings
Sales for the year 2015 (A)	$130,000	$  55,000
Growth rate $\left[100+\left(\text{100}\times \text{8\%}\right)\right]$ (B)	108%	108%
Sales for the year 2016 $\left(\text{A}\right)\times \left(\text{B}\right)$	$140,400	$59,400	$50,000

Table (2)

(2) Determine the cost of goods sold for each department.

Particulars	Clock	Mirror	Paintings
Cost of goods sold for the year 2015 (A)	$63,700	$34,100
Sales for the year 2015 (B)	$130,000	$55,000
Percentage of Cost of goods sold for the year 2015$\left[\left(\text{A}\right)÷\left(\text{B}\right)\right]\times 100$	49.0%	62.0%
Sales for the year 2016 (C)	$140,400	$59,400	$50,000
Percentage of Cost of goods sold for the year 2016 (D)	49.0%	62.0%	45%
Cost of goods sold for the year 2016 $\left(\text{C}\right)\times \left(\text{D}\right)$	$68,796	$36,828	$22,500

Table (3)

Note:

• Refer Table (2) for the sales revenue for the year 2016.
• The gross margin is 55% on sales. So, the percentage of goods sold for year 2016 is $\left(1-55\%\right)$45%.

(3) Determine the store supplies expense for each department.

Particulars	Clock	Mirror	Paintings
Store supplies used in 2015	$900	$400
Growth rate $\left[100+\left(\text{100}\times \text{8\%}\right)\right]$ (B)	108%	108%
Store supplies used in 2016	$972	$432	$500

Table (4)

(4) Allocate the rent and utilities for each department.

Particulars	Clock	Mirror	Paintings	Total
Rent expense for 2015	$7,020	$3,780		$10,800
One-fifth from clock to paintings	(1,404)		$1,404
One-fourth from mirror to paintings		$(945)	$945
Allocation of rent expense of $10,800 (A)	$5,616	$2,835	$2,349	$10,800
Percentage of total rent expense (B) $\left[\left(\text{A}\right)÷\text{\$10,800}\right]\times 100$	52.0%	26.2%	21.8%
Allocation of utilities expense $\left[\left(\text{B}\right)\times \text{\$4,000}\right]÷100$	$2,080	$1,048	$872	$4,000

Table (5)

(5) Allocate the office department expense.

Particulars	Clock	Mirror	Paintings	Total
Sales for the year 2016(A)	$140,400	$59,400	$50,000	$249,800
Percent of total sales  (B)$\left[\left(\text{A}\right)÷\text{\$249,800}\right]\times 100$	56.2%	23.8%	20.0%
Office department expense for 2016 (C) $\left[\left(\text{B}\right)\times \text{\$22,000}\right]÷100$	$12,364	$5,236	$4,400	$22,000

Table (6)

Note: The total office department for the year 2015 is $15,000 and the management expects in the increase in the expense by $7,000. Thus, the total office department expense is $\left(\$15,000+\$7,000\right)$ $22,000.