Production Report – Subsequent Department – Weighted Average

Learning Outcomes

  • Prepare a production cost report for a second or subsequent stage of a multi-step process using the weighted-average method

Once the mixing department is done converting direct materials (flour and butter) and indirect materials (salt and sugar) into raw shells using direct labor, indirect labor, and other factory overhead, the materials are transferred out into the next stage—in this case, baking. For purposes of this example, we’re going to combine the baking and packaging departments into one cost center.

A graphic showing the progression from left to right from the Mixing Department to the Baking Department to the Packaging Department to Finished Goods. Under each department is shown the formula Direct Materials + Direct Labor + Factory Overhead (for that department) = Work in Process (for that department). Under Finished Goods, it states Total cost of the batch includes work in process costs from all three departments.

Before we examine subsequent departments, let’s review the Production Cost Report from the first stage of production—the mixing department for the month of January:

Dad’s Perfect Pies
Production Cost Report – Mixing Department
Month Ended January 31
Equivalent Units
UNITS Physical Units Single LineDirect Materials Single LineConversion Costs
Subcategory, Units to account for: Single Line Single Line Single Line
      Beginning work-in-process 0
      Started in production 3,000
Total units to account for Single Line3,000Double line
Subcategory, Units accounted for:
      Completed and transferred out 2,250 2,250 2,250
      Ending work-in-process 750 750 450
Total units accounted for Single Line3,000Double line Single Line3,000Double line Single Line2,700Double line
COSTS Direct Materials Conversion Costs Total Costs
Subcategory, Costs to account for:
      Beginning work-in-process $       – $       – $      –
      Costs added during the period $   3,000 $   3,240 $  6,240
Total costs to account for Single Line$   3,000 Single Line$   3,240 Single Line$  6,240Double line
Divided by: Total EUP   3,000               2,700
Cost per equivalent unit Single Line$    1.00Double line Single Line$    1.20Double line
Subcategory, Costs accounted for:
      Completed and transferred out $   2,250 $   2,700 $  4,950
      Ending work-in-process $     750 $     540 $  1,290
Total costs accounted for Single Line$   3,000Double line Single Line$   3,240Double line Single Line$  6,240Double line

 

Take note of the following:

  • Units transferred out = 2,250. They were transferred out to the baking/packaging department because they were 100% complete.
  • They carried with them $4,950 in accumulated costs.

Preparing the Production Cost Report for subsequent departments is similar to preparing the report for the first department, with the addition of a column for costs transferred in.

Let’s make these assumptions for the baking/packaging department for the month of January:

  • Jan 14: 750 pie crusts (uncooked) transferred from mixing to baking/packaging—baked, packaged, quality-checked, and transferred to the cooler on Jan 19.
  • Jan 20: 750 pie crusts (uncooked) transferred from mixing to baking/packaging—baked, packaged, quality-checked, and transferred to the cooler on Jan 25.
  • Jan 26: 750 pie crusts (uncooked) transferred from mixing to baking/packaging—500 baked, packaged, quality-checked, and transferred to the cooler on Jan 31, leaving 250 pie crusts 20% through the process.
  • All direct materials in this combined department (packing materials) are added at the end of the process, so the 250 shells remaining in work-in-process on January 31 are 0% complete as to direct materials.
  • Costs accumulated in the accounting records are:
    • $600 in direct materials
    • $4,100 in labor, factory overhead, and other conversion costs.

Let’s put together a Production Cost Report one step at a time.

Step 1 – Calculate units to account for

Establish the total inventory in production by adding units started into production to beginning work in process (what was left only partially finished at the end of the prior month). For this example, we will assume that all pie shells in process were completed in December, and the facility was shut down over the holiday break for annual repairs, maintenance, and deep cleaning. So, the beginning inventory of zero plus the 2,250 pie shells transferred in from the mixing department during the month gives us a total number of units to account for of 2,250.

UNITS Physical Units
Subcategory, Units to account for: Single Line
      Beginning work-in-process 0
      Transferred in from mixing 2,250
Total units to account for Single Line2,250Double line

Step 2 – Calculate units accounted for

In subsequent departments like these, the units are then broken down into three categories: transferred in, direct materials, and conversion costs. The 2,000 units that have been transferred out are 100% complete, so the Equivalent Units and the actual physical units are the same. However, unfinished units (work-in-process) in this department have to be converted to Equivalent Units. In this case, since materials are all added at the end of the process, the Equivalent Units for Direct Materials is 0% of the actual units, but the Equivalent Units for the Conversion Costs allocation is 20% of actual units or 50 EUs.

From our assumptions: Jan 26: 750 pie crusts (uncooked) and transferred from mixing to baking/packaging—500 baked, packaged, quality-checked, and transferred to the cooler on Jan 31, leaving 250 pie crusts 20% through the process. 250 * 0.20 = 50 EUs.

Equivalent Units
Physical Units Single LineTransferred In Single LineDirect Materials Single LineConversion Costs
Subcategory, Units accounted for: Single Line Single Line Single Line Single Line
      Completed and transferred out 2,000 2,000 2,000 2,000
      Ending work-in-process 250 250 0 50
Total units accounted for Single Line2,250Double line Single Line2,250Double line Single Line2,000Double line Single Line2,050Double line

 

Remember, Equivalent Units will be used to come up with an overall allocation rate that will then be used to allocate total costs between products completed and transferred out and products still in the process.

Step 3 – Divide total costs by equivalent units

From the accounting records, we see that total direct materials used in January by the baking/packaging department were $600, and direct labor and manufacturing overhead totaled $4,100. We divided those amounts by the related Equivalent Units to come up with a cost per EU.

Transferred In Direct Materials Conversion Costs Total Costs
Subcategory, Costs to account for:
      Beginning work-in-process $         – $       – $        – $       –
      Costs added during the period $     4,950 $     600 $    4,100 $   9,650
Total costs to account for Single Line$     4,950 Single Line$     600 Single Line$    4,100 Single Line$   9,650Double line
Divided by: Total EUP     2,250     2,000   2,050
Cost per equivalent unit Single Line$      2.20Double line Single Line$    0.30Double line Single Line$     2.00Double line

 

Notice that the “Transferred In” column comes right from the mixing department Production Cost Report.

Total costs of $9,650 are the $4,950 transferred in from the mixing department plus the $4,700 incurred in baking and packaging.

Step 4 – Allocate costs based on equivalent units

Refer to step 2:

Equivalent Units
Physical Units Single LineTransferred In Single LineDirect Materials Single LineConversion Costs
Subcategory, Units accounted for: Single Line Single Line Single Line Single Line
      Completed and transferred out 2,000 2,000 2,000 2,000
      Ending work-in-process 250 250 0 50
Total units accounted for Single Line2,250Double line Single Line2,250Double line Single Line2,000Double line Single Line2,050Double line

 

Multiply the cost per equivalent unit by the number of equivalent units for each category of units accounted for: Completed and transferred out, and Ending work-in-process.

Completed and transferred out

Transferred In Direct Materials Conversion Costs Total Costs
Equivalent units completed and transferred out Single Line2,000 Single Line2,000 Single Line2,000
Cost per equivalent unit $  2.20 $  0.30 $   2.00
Cost allocated to completed units Single Line$ 4,400Double line Single Line$   600Double line Single Line$  4,000Double line Single Line$   9,000Double line

 

Ending work-in-process

Transferred In Direct Materials Conversion Costs Total Costs
Equivalent units not yet completed Single Line250 Single Line0 Single Line50
Cost per equivalent unit $  2.20 $  0.30 $  2.00
Cost allocated to work-in-process Single Line$550Double line Single Line$    00Double line Single Line$   100Double line Single Line$   650Double line

 

Notice that under this Equivalent Units method of allocating costs, no direct materials were allocated to ending work in process because the EUs were zero. However, because we are using the average method instead of the First-in, First-out (FIFO) method, which uses the assumption that the flow of goods through the system is a constant mix, we still have costs left in the “transferred in” column. Using a FIFO cost-flow assumption, we would have allocated those costs to finished goods first.

Before we examine the FIFO method, let’s complete the production cost report for this department and check your understanding of how subsequent departments differ from the first department.

Step 5 – Complete the production report

Dad’s Perfect Pies
Production Cost Report – Baking/Packaging Department
Month Ended January 31
Equivalent Units
Subcategory, UNITS Physical Units Single LineTransferred In Single LineDirect Materials Single LineConversion Costs
Subcategory, Units to account for: Single Line Single Line Single Line Single Line
Beginning work-in-process 0
Transferred in from mixing 2,250
Total units to account for Single Line2,250Double line
Subcategory, Units accounted for:
Completed and transferred out 2,000 2,000 2,000 2,000
Ending work-in-process 250 250 0 50
Total units accounted for Single Line2,250Double line Single Line2,250Double line Single Line2,000Double line Single Line2,050Double line
COSTS Transferred In Direct Materials Conversion Costs Total Costs
Subcategory, Costs to account for: Single Line Single Line Single Line Single Line
Beginning work-in-process $       – $      – $      – $     –
Costs added during the period $   4,950 $    600 $  4,100 $ 9,650
Total costs to account for Single Line$   4,950 Single Line$    600 Single Line$  4,100 Single Line$ 9,650Double line
Divided by: Total EUP       2,250       2,000       2,050
Cost per equivalent unit Single Line$    2.20Double line Single Line$   0.30Double line Single Line$   2.00Double line
Subcategory, Costs accounted for:
Completed and transferred out $   4,400 $     600 $  4,000 $ 9,000
Ending work-in-process $     550 $       – $    100 $   650
Total costs accounted for Single Line$   4,950Double line Single Line$     600Double line Single Line$  4,100Double line Single Line$ 9,650Double line

 

And here is a summary of total inventory at the end of January based on the two production reports:

Description Amount Total
Subcategory, Inventory
      Work-in-process
      Mixing $       1,290
      Baking/Packaging 650 $       1,940
      Finished Goods Single Line 9,000
Total Inventory Single Line$      10,940Double line

 

Thus, all the costs from both departments are accounted for and allocated to the proper category.

Description Total
Mixing Department $       6,240
Baking/Packaging Department 4,700
Total costs to be allocated Single Line$      10,940Double line

 

Now, check your understanding of the second or subsequent stage of a multi-step process using the weighted-average method of process costing.

Practice Question