In: Accounting
Vortex Company operates a retail store with two departments.
Information about those departments follows.
Department A | Department B | |||||
Sales | $ | 832,000 | $ | 448,000 | ||
Cost of goods sold | 455,000 | 291,200 | ||||
Direct expenses | ||||||
Salaries | 119,000 | 84,000 | ||||
Insurance | 13,500 | 10,100 | ||||
Utilities | 23,500 | 29,000 | ||||
Depreciation | 17,000 | 13,500 | ||||
Maintenance | 6,700 | 5,200 | ||||
The company also incurred the following indirect costs.
Salaries | $28,000 |
Insurance | 7,600 |
Depreciation | 14,200 |
Office expenses | 46,000 |
Indirect costs are allocated as follows: salaries on the basis of
sales; insurance and depreciation on the basis of square footage;
and office expenses on the basis of number of employees. Additional
information about the departments follows.
Department | Square footage | Number of employees | ||||
A | 29,400 | 66 | ||||
B | 12,600 | 44 | ||||
Required:
1. Determine the departmental contribution to
overhead and the departmental net income for department A and
Department B. (Do not round intermediate calculations.
Round your final answers to nearest whole dollar.)
|
Departmental Contribution Statements :-
Particulars | Department A | Department B |
Sales (A) | $832000 | $448000 |
Less : Cost of Goods Sold (B) | 455000 | 291200 |
Gross Margin C = A - B | 377000 | 156800 |
Direct Expenses :- | ||
Salaries | 119000 | 84000 |
Insurance | 13500 | 10100 |
Utilities | 23500 | 29000 |
Depreciation | 17000 | 13500 |
Maintenance | 6700 | 5200 |
Total Direct Expenses (D) | 179700 | 141800 |
Departmental Contribution to Overhead (E) = (C - D) | 197300 | 15000 |
Allocated Indirect Expenses | ||
Salaries (Working Note 1) | 18200 | 9800 |
Insurance (Working Note 2) | 5320 | 2280 |
Depreciation (Working Note 3) | 9940 | 4260 |
Office Expenses (Working Note 4) | 27600 | 18400 |
Total Allocated Indirect Expenses (F) | 61060 | 34740 |
Departmental Net Income (G) = (E - F) | 136240 | (19740) |
Working Note ;-
1) Salaries Allocation ;-
Particulars | Sales | % | Amount($) | Allocated |
Department A | $832000 | 65 | 28000 | $18200 |
Department B | $448000 | 35 | 28000 | $9800 |
Total | $1280000 | 100 | $28000 |
2) Insurance Allocation :-
Particulars | Sq. Ft. | % | Amount($) | Allocated |
Department A | 29400 | 70 | 7600 | $5320 |
Department B | 12600 | 30 | 7600 | $2280 |
Total | 42000 | 100 | $7600 |
3) Depreciation Allocation :-
Particulars | Sq. Ft. | % | Amount($) | Allocated |
Department A | 29400 | 70 | 14200 | $9940 |
Department B | 12600 | 30 | 14200 | $4260 |
Total | 42000 | 100 | $14200 |
4) Office Expense Allocation :-
Particulars | Employees | % | Amount($) | Allocated |
Department A | 66 | 60 | 46000 | $27600 |
Department B | 44 | 40 | 46000 | $18400 |
Total | 110 | 100 | $46000 |