Assigning Traceable Fixed Expenses Selected data for Miller Company, which operates three departments, follow: Department A Department B Department C Inventory $80,000 $288,000 $112,000 Equipment (average cost) $720,000 $432,000 $288,000 Payroll $405,000 $360,000 $135,000 Square feet of floor space 18,000 9,000 3,000 During the year, the company’s fixed expenses included the following: Depreciation on equipment $80,000 Real estate taxes 24,000 Personal property taxes (on inventory and equipment) 38,400 Personnel department expenses 40,000 Assume that the property tax rate is the same for both inventory and equipment. Using the most causally related bases, prepare a schedule assigning the fixed expenses to the three departments. Hint: Not all fixed expenses are traceable to the three departments. One of these fixed costs should be considered a common cost and not traceable to the departments. Do not round until your final answer. Round final answer to the nearest whole number. Department A Department B Department C Depreciation $Answer $Answer $Answer Real estate taxes Answer Answer Answer Personal property taxes Answer Answer Answer Personnel dept. expenses Answer Answer Answer
Solution :
Allocation of Fixed Expenses | |||||
Particulars | Allocation base | Total | Department A | Department B | Department C |
Depreciation on equipment (720:432:288) | Equipment cost | $80,000.00 | $40,000.00 | $24,000.00 | $16,000.00 |
Real Estate Taxes (18:9:3) | Square feet of floor space | $24,000.00 | $18,000.00 | $9,000.00 | $3,000.00 |
Personal property taxes (on inventory and equipment) (800:720:400) | Total of inventory and equipment cost | $38,400.00 | $16,000.00 | $14,400.00 | $8,000.00 |
Personnel department expenses (405:360:135) | Payroll | $40,000.00 | $18,000.00 | $16,000.00 | $6,000.00 |
Total Allocated expenses | $182,400.00 | $92,000.00 | $63,400.00 | $33,000.00 |
Get Answers For Free
Most questions answered within 1 hours.