Question

Assigning Traceable Fixed Expenses Selected data for Miller Company, which operates three departments, follow: Department A...

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

Homework Answers

Answer #1

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
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Assigning Traceable Fixed Expenses Selected data for Colony Company, which operates three departments, follow: Department A...
Assigning Traceable Fixed Expenses Selected data for Colony Company, which operates three departments, follow: Department A Department B Department C Inventory $20,000 $72,000 $28,000 Equipment (average cost) $180,000 $108,000 $72,000 Payroll $607,500 $540,000 $202,500 Square feet of floor space 27,000 13,500 4,500 During the year, the company's fixed expenses included the following: Depreciation on equipment $30,000 Real estate taxes 9,000 Personal property taxes (on inventory and equipment) 14,400 Personnel department expenses 15,000 Assume that the property tax rate is the...
Summarized data for 2016 (the first year of operations) for Gorman Products, Inc., are as follows:...
Summarized data for 2016 (the first year of operations) for Gorman Products, Inc., are as follows: Sales (75,000 units) $6,000,000 Production costs (80,000 units) Direct material 1,760,000 Direct labor 1,440,000 Manufacturing overhead: Variable 1,088,000 Fixed 640,000 Operating expenses: Variable 336,000 Fixed 480,000 Depreciation on equipment 120,000 Real estate taxes 36,000 Personal property taxes (inventory & equipment) 57,600 Personnel department expenses 60,000 Assume that you must decide quickly whether to accept a special one-time order for 1,000 units for $60 per...
Manufacturing Overhead Distribution Worksheet The following are selected operating data for the production and service departments...
Manufacturing Overhead Distribution Worksheet The following are selected operating data for the production and service departments of Bluestone Company for 2016. Departments Service Production 1 2 1 2 Overhead costs (identified by department) Indirect material $72,600 $123,300 $38,160 $774,000 Indirect labor $145,800 $216,000 $48,876 $2,158,500 Square feet of building floor space used 7,200 10,800 18,000 36,000 Assessed value of equipment used $31,500 $94,500 $189,000 $315,000 Cubic yards of factory space used 132,000 198,000 Machine hours 76,800 307,200 Direct labor $30,000...
Variable and Absorption Costing Summarized data for 2016 (the first year of operations) for Gorman Products,...
Variable and Absorption Costing Summarized data for 2016 (the first year of operations) for Gorman Products, Inc., are as follows: Sales (75,000 units) $1,500,000 Production costs (80,000 units) Direct material 440,000 Direct labor 360,000 Manufacturing overhead: Variable 272,000 Fixed 160,000 Operating expenses: Variable 84,000 Fixed 120,000 Depreciation on equipment 30,000 Real estate taxes 9,000 Personal property taxes (inventory & equipment) 14,400 Personnel department expenses 15,000 a. Prepare an income statement based on full absorption costing. Only use a negative sign...
The following data were taken from the records of Griggs Company for December: Administrative expenses $100,800...
The following data were taken from the records of Griggs Company for December: Administrative expenses $100,800 Cost of goods sold (at standard) 550,000 Direct materials price variance-unfavorable 1,680 Direct materials quantity variance-favorable (560) Direct labor rate variance-favorable (1,120) Direct labor time variance-unfavorable 490 Variable factory overhead controllable variance-favorable (210) Fixed factory overhead volume variance-unfavorable 3,080 Interest expense 2,940 Sales 868,000 Selling expenses 125,000 Required: Prepare an income statement for presentation to management. Refer to the list of Labels and Amount...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow: Total Dirt Bikes Mountain Bikes Racing Bikes   Sales $ 929,000 $ 265,000 $ 405,000   $ 259,000     Variable manufacturing and selling expenses 460,000 111,000 195,000   154,000     Contribution margin 469,000 154,000 210,000 105,000     Fixed expenses:     Advertising, traceable 69,500 8,800 40,400 20,300     Depreciation of special equipment 43,400 20,500 7,700 15,200       Salaries of product-line managers 116,700...
Exercise 8-1 Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very...
Exercise 8-1 Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $440,000 $640,000 $220,000 $1,300,000 From past experience, the company has learned that 30% of a month’s sales are collected in the month of sale, another 60% are...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...