Allocating Overhead Using Departmental Rates

Learning Outcomes

  • Allocate manufacturing overhead to cost objects using multiple rates and cost pools

You determined a departmental rate for each cost pool as follows:

Departments Total MOH Base(Description) Base(quantity) Rate
  Assembly $ 141,000.00 Machine Hours       47,000.00 $    3.0000
  Finishing   47,000.00 Direct Labor $ $ 376,000.00 $    0.1250
Single Line$ 188,000.00Double line

 

Now, let’s check our logic by applying the rate to each product line. If our calculations are correct, we should be allocating all $188,000 of the overhead based on two rates instead of one.

Subcategory, Products
Basic Rate Base (description) Base (amount) Total Allocation
  Assembly $  3.0000 Machine Hours       28,800.00     $86,400.00
  Finishing $  0.1250 Direct Labor $ $ 264,000.00 $ 33,000.00
Single Line$119,400.00
Deluxe Single Line
  Assembly $  3.0000 Machine Hours     18,200.00   $54,600.00
  Finishing $  0.1250 Direct Labor $ $ 112,000.00 $ 14,000.00
Single Line$ 68,600.00
Single Line
Single Line$188,000.00Double line

 

Here is another way to look at it:

Subcategory, Departments
Assembly Rate Base (description) Base (amount) Total Allocation
  Basic $  3.0000 Machine Hours       28,800.00     $86,400.00
  Deluxe $  3.0000 Machine Hours     18,200.00 $ 54,600.00
Single Line$141,000.00
Finishing Single Line
  Basic $  0.1250 Direct Labor $ $ 264,000.00 $ 33,000.00
  Deluxe $  0.1250 Direct Labor $ $ 112,000.00 $ 14,000.00
Single Line$47,000.00
Single Line
Single Line$188,000.00

 

This shows that based on our standard hours and standard labor costs, all overhead will be allocated. Now let’s look at the allocations for each purse.

MOH Allocated to Basic Purse

Basic Purse MHR DLH DLR DL$ Rate Allocation
  Assembly       9 $ 3.0000 $27.0000
  Finishing             4.125 $20.00 $82.50 $ 0.1250 $10.3125
      Total $37.3125

 

Our basic purse takes 9 machine hours to produce (MHR) and we allocate $3 per machine hour of overhead, so the assembly department overhead allocation per purse is $27.

Our basic purse takes 4.125 hours of labor at a standard cost of $20 for a total labor cost per basic purse of $82.50. Our allocation rate for the finishing department is $0.125, so we allocate $10.3125 of finishing department overhead to each basic purse.

MOH Allocated to Deluxe Purse

Deluxe Purse MHR DLH DLR DL$ Rate Allocation
  Assembly     32.5 $ 3.0000 $97.500
  Finishing             10 $20.00 $200.00 $ 0.1250 $25.000
      Total $122.500

 

Our deluxe purse takes 32.5 machine hours to produce (MHR) and we allocate $3 per machine hour of overhead, so the assembly department overhead allocation per purse is $97.50.

Our deluxe purse takes 10 hours of labor at a standard cost of $20 for a total labor cost per basic purse of $200.00. Our allocation rate for the finishing department is $0.125, so we allocate $25.00 of finishing department overhead to each basic purse.

We’ll round the allocated overhead cost to the basic unit from $37.3125 to $37.31. Notice that under this more sophisticated system of allocation, at $532.50, the deluxe purse appears to cost more to produce than the $515 it sells for. Also, notice that variable costs like direct material and direct labor (and variable manufacturing costs, which we have not included in this simulation) do not change on a per-unit basis.

Product Manufacturing Costs

Description Product 1 Product 2
Using Multiple Allocation Rates Basic Deluxe
  Direct Materials $        100.00 $        210.00
  Direct Labor 82.50 200.00
  Manufacturing Overhead 37.31 122.50
Single Line$        219.81Double line Single Line$        532.50Double line

 

Let’s compare these results to our single-rate computations by looking at the gross profit per unit.

Description Product 1 Product 2
Basic Deluxe
Subcategory, Multiple-base allocation (by department)
Sales Price $        245.00 $        515.00
Less: Direct Variable Costs 182.50 410.00
Single Line62.50 Single Line105.00
Less: Allocated Fixed Costs 37.31 122.50
Gross profit per unit Single Line$          25.19Double line Single Line$          (17.50)Double line
Subcategory, Single Allocation Rate (DMH)
Sales Price $        245.00 $        515.00
Less: Direct Variable Costs 182.50 410.00
Single Line62.50 Single Line105.00
Less: Allocated Fixed Costs 36.00 130.00
Gross profit per unit Single Line$          26.50Double line Single Line$        (25.00)Double line
Subcategory, Single Allocation Rate (DL$)
Sales Price $        245.00 $        515.00
Less: Direct Variable Costs 182.50 410.00
Single Line  62.50 Single Line105.00
Less: Allocated Fixed Costs 41.25 100.00
Gross profit per unit Single Line$          21.25Double line Single Line$            5.00Double line

Using multiple (departmental) allocation rates, we see that sales of the deluxe purse are actually hurting our bottom line:

Basic Deluxe
Gross profit per unit $          25.19 $        (17.50)
Times number of units sold             3,200                 560
Total gross profit Single Line          80,600.00Double line Single Line          (9,800.00)Double line
Total gross profit – basic $   80,600.00
Total gross profit – deluxe $   (9,800.00)
Total gross profit, all products Single Line$   70,800.00Double line

If the sales manager thinks we can sell more basic purses, would it make sense to shift production away from deluxe purses?

If it takes 32.50 machine hours to produce one deluxe purse, and we are producing 560 per month, we could free up 18,200 machine hours by discontinuing the deluxe model. That would then allow us to produce at least 2,000 more basic models, which could increase the bottom line by over $50,000 ($25.19 * 2,000). However, discontinuing the deluxe model only frees up 5,600 labor hours (560 * 10 hours) which, according to our standards, only allows us to produce 1,357 more basic purses (1,357 * 4.125 hours per basic purse = 5,600 hours), so we would either be limited by that, or we would have to hire more employees to finish the increased production of basic purses (up to 15 more, in fact).

You’ve now seen one example of the various ways to allocate costs for the Yore Company. Let’s look at another example in this video:

You can view the transcript for “Departmental Overhead Rates” here (opens in new window).

Although our information is becoming more detailed and sophisticated, and we hope more accurate, we still have one more option, Activity-Based Costing (ABC), that may give us yet more insight. However, before you tackle ABC, check your understanding of allocating fixed manufacturing overhead using multiple departmental rates.

Practice Question