Production Report – First Department – Weighted Average

Learning Outcomes

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

pie crust

There are two basic methods used to allocate costs in process costing: weighted average and First-in, First-out (FIFO).

For now, we’ll focus on the weighted average method which assumes that products and therefore costs, flow through the process like paint or beverages. Later, once you are comfortable with the basic idea of the process costing production report, we’ll take a look at the FIFO method which is based on the assumption that the work-in-process sitting in the department at the end of the month is finished at the beginning of the next month before anything else is started.

Allocating Costs to Products in the First Department of a Multi-Step Process

What we are looking at here is a multi-step process, such as creating food products. In our Dad’s Perfect Pie (crusts) example, the three steps to get from raw materials (flour and butter) to a finished product probably look like this, so these would be our cost accounting departments as well:

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.

Let’s assume a ton of flour and ¾ ton of butter comes into the Mixing Department on Jan 3rd. A ton of flour makes 3,000 pie crusts. It is mixed up, rolled out, and cut into shape by machine, so there are minimal direct labor costs and some indirect factory overhead costs (such as depreciation, rent, insurance, indirect labor) added to the direct materials costs.

Here is how the production schedule looked:

  • Jan 6: 500 pounds of flour and 375 pounds of butter turned into 750 pie crusts (uncooked) and transferred to Baking on Jan 14
  • Jan 15: 500 pounds of flour and 375 pounds of butter turned into 750 pie crusts (uncooked) and transferred to Baking on Jan 20
  • Jan 21: 500 pounds of flour and 375 pounds of butter turned into 750 pie crusts (uncooked) and transferred to Baking on Jan 27
  • Jan 28: 500 pounds of flour and 375 pounds of butter dumped into the mixing process – 60% mixed as of Jan 31

In our accounting records, we shouldn’t transfer all of the direct material costs into baking. Instead, we should leave those unmixed raw materials in the Mixing Department work in process and only transfer out the costs attributed to the product transferred out.

Here are the costs for the mixing department for January:

Direct materials:

1 ton flour at $0.60 per pound = $1,200

¾ ton butter at $1.20 per pound = $1,800

Total Direct Materials = $3,000

Conversion costs:

90 hours direct Labor at $20/hr = $1,800

3,600 machine hours at $0.40/DMH = $1,440

Total Conversion costs: $3,240

Total costs that need to be allocated = $6,240

If we just divided $6,240 by 3,000 crusts, we would get $2.08 per crust, but recall that 750 of those shells are not done yet, so they should not get a full allocation of the conversion costs.

We completed and transferred out three batches of 750 crusts. That’s 2,250 shells transferred to baking, but once again, we can’t take total costs of $6,240 and allocate that cost over only the completed shells because $750 of that $6,240 is direct materials in work-in-process, and some of the indirect costs should stay in the mixing department work-in-process as well.

This is where equivalent units come in.

A unit that is 60% done is the equivalent of 6/10 of a completed unit. So, the 750 pie crusts in process on Jan 31 would be, for conversion cost purposes, the equivalent of 450 completed units. For direct materials cost purposes, those units are 100% complete because all of the direct materials are added at the very beginning of the process.

Equivalent Units – used to allocate
Date Direct Materials Direct Labor and Overhead Single LineStatus
3-Jan Single Line                    750 Single Line                    750 Single Linecompleted and transferred to baking
15-Jan                     750                     750 completed and transferred to baking
21-Jan                     750                     750 completed and transferred to baking
28-Jan                     750                     450 mixing department work-in-process
Single Line3,000Double line Single Line2,700Double line

 

Again, the 750 units in work-in-process are 100% complete as to direct materials and 60% complete as to other costs, so the EUs are:

750 * 1.00 = 750 equivalents units for direct materials allocation

750 * 0.60 = 450 equivalent units for labor and other conversion costs allocation

In order to document our allocation of costs, we’ll create a Department Production Cost Report in four steps:

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 clean. So, the beginning inventory of zero plus the 3,000 pie shells worth of materials placed into production during the month gives us 3,000 total units to account for.

UNITS Physical Units
Subcategory, Units to account for: Single Line
      Beginning work-in-process 0
      Started in production 3,000
Total units to account for Single Line3,000Double line

 

Step 2 – Calculate units accounted for

The units are then broken down into two categories: direct materials and conversion costs. 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 beginning (which may not always be the case), the Equivalent Units for Direct Materials is 100% of the actual units, but the Equivalent Units for the Conversion Costs allocation are 60% of actual units or 450 EUs.

Equivalent Units
Physical Units Single LineDirect Materials Single LineConversion Costs
Subcategory, Units accounted for: Single Line Single Line Single Line
      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

 

Total Equivalent Units (also called Equivalent Units of Production or EUPs) is 3,000 for Direct Materials but only 2,700 for Conversion Costs.

Step 3 – Divide total cost by equivalent units

From the accounting records, we see that total direct materials transferred in to the mixing department was $3,000, and direct labor and manufacturing overhead totaled $3,240. We divided those amounts by the related Equivalent Units to come up with a cost per EU.

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

 

Step 4 – Allocate costs based on equivalent units

Refer to step 2:

Equivalent Units
Physical Units Single LineDirect Materials Single LineConversion Costs
Subcategory, Units accounted for: Single Line Single Line Single Line
      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

Multiply the cost per equivalent unit by the number of equivalent units for each category of units accounted for.

Direct Materials Conversion Costs Total Costs
Equivalent units completed and transferred out 2,250 2,250
Cost per equivalent unit $         1.00 $       1.20
Cost allocated to completed units Single Line$       2,250Double line Single Line$     2,700Double line Single Line$   4,950Double line
Equivalent units not yet completed 750 450
Cost per equivalent unit $       1.00 $       1.20
Cost allocated to work-in-process Single Line$       750Double line Single Line$      540Double line Single Line$   1,290Double line

 

Step 5 – Complete the production report

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

 

In summary, (1) identify total units for the department, (2) calculate equivalent units for both completed items (transferred out) and uncompleted (work-in-process), (3) divide total costs by total equivalent units to get an allocation rate, (4) multiply the rate from Step 3 by the equivalent units in order to allocate total costs to completed items and work-in process.

Before we look at the next department in line, check your understanding of how to allocate process costs to the first department using a weighted average method.

Practice Question