Lane Company operates a retail store with two departments, A and B. its departmental income statement for the current year follows:
Lane Company
Departmental income statement
For year ended Dec 31st
|
Dept. A
|
Dept. B
|
Combined
|
Sale
|
$180000
|
$200000
|
$380000
|
Direct expenses
|
129900
|
142870
|
272770
|
Contributions to OH
|
50100
|
57130
|
107230
|
Indirect expenses:
|
Depreciation-building
|
10000
|
11760
|
21760
|
Maintenance
|
1600
|
1700
|
3300
|
Utilities
|
6200
|
6320
|
12520
|
Office expenses
|
1800
|
2000
|
3800
|
Total indirect expenses
|
19600
|
21780
|
41380
|
Net income
|
30500
|
35350
|
65850
|
Lane Co. allocates building depreciation, maintenance, and utilities on the basis of sq. ft. office expenses are allocated on the basis of sales.
Management is considering an expansion to a three-department operation. The proposed department C would generate $120000 in additional sales and have a 17.5% contribution to OH. The company owns its building. Opening department C would redistribute the square footage to each department as follows: A, 19040; B, 21760 sq.ft; C, 13600. Increases in indirect expenses would include: maintenance, $500; utilities, 3800, and office expenses, 1200.
Complete the following departmental income statements, showing projected results of operations for the three sales departments. Round amount to the nearest whole dollar.
complete the chart below with above information:
|
Dept. A
|
Dept. B
|
Dept. C
|
combined
|
Sales
|
$180000
|
$200000
|
|
|
Direct expenses
|
129900
|
142870
|
|
|
Contributions to OH
|
50100
|
57130
|
|
|
Indirect exp
|
|
|
|
|
Dep-building
|
|
|
|
|
Maintenance
|
|
|
|
|
Utilities
|
|
|
|
|
Office exp
|
|
|
|
|
Total indirect exp
|
|
|
|
|