Production Report – FIFO

Learning Outcomes

  • Prepare a production cost report using the FIFO method

pie crustLet’s take a look at Dad’s Perfect Pies Production Report for February based on the following results:

The 750 shells in production at the end of January were 60% complete as to conversion costs and 100% complete as to direct materials, so in February they will need 40% more conversion but 0% more direct materials.

The mixing department started another 3,250 shells during February, and at the end of the month, there were still 1,000 shells being mixed and prepped for baking. They were only 25% complete as to conversion but 100% of the direct materials had been added (because they are added at the beginning of the process).

According to the accounting records, direct materials transferred to the mixing department were costed at $3,575 and direct labor and factory overhead were $3,640.

Under the weighted average method, costs transferred in from last month are added to this month’s costs and distributed across all units. This is the simplest way to account for beginning inventory costs, but not always the most accurate. For example, if costs are going up, the cost of those 750 pie shells in beginning work in process inventory would be less than the cost of the 1,000 pie shells in ending inventory.

The First-in, First-out method of allocating costs assumes that the units in beginning work-in-process inventory are finished first, then transferred out, and then all the batches during the month are finished and transferred out, and then only the most recent costs are assigned to ending inventory.

Therefore, FIFO creates three groups of units to be accounted for:

  • Beginning work-in-process – Units started in the prior month, completed in the current month
  • Started and completed – Units started and completed in the current month
  • Ending work-in-process – Units started in the current month not yet completed

Therefore, there are a few more steps in creating the Production Cost Report. However, the first step is the same as with the weighted average method.

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). The company had 750 shells in process at the close of business on January 31. The beginning inventory of 750 plus the 3,250 pie shells worth of materials placed into production during the month gives us 4,000 total units to account for.

Description Physical Units
Subcategory, Units to account for:
      Beginning work-in-process 750
      Started in production 3,250
Total units to account for Single Line4,000Double line

 

Step 2 – Calculate units accounted for

This is where equivalent units are different than the normal formula, but only for beginning inventory.

Under the FIFO method, we assume beginning inventory is finished first, before anything else is started. Last month (January) all of the direct materials were added and accounted for, so this month, there are no more direct materials to add. The EUs for this month for direct materials for beginning inventory is zero. For conversion costs, last month we added 60% of the costs to the work-in-process, and for February, we will use 40% as our factor to convert the physical units to Equivalent Units. 60% finished last month = 40% left to do this month.

For beginning inventory, the formula for EUs is:

Actual Units * (1 – % complete)

750 units * (1 – 0.60) = 750 * 0.40 = 300 EUs

This is important and an easy place to slip up. EUs for beginning inventory is the complement of last month’s ending inventory because now you are finishing them up. If the beginning work-in-process inventory is 10% done, then the factor to use to calculate EUs to finish it up this month is 90%.

Units started during the period, finished, and then transferred out are 100% complete, so the Equivalent Units and the actual physical units are the same.

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, the Equivalent Units for Direct Materials is 100% of the actual units, but the Equivalent Units for the Conversion Costs allocation is 25% of actual units or 250 EUs.

Equivalent Units
UNITS Physical Units Single LineDirect Materials Single LineConversion Costs
Subcategory, Units accounted for: Single Line Single Line Single Line
      Beginning work-in-process 750 0 300
      Started and completed 2,250 2,250 2,250
Total units transferred to baking Single Line3,000 Single Line2,250 Single Line2,550
      Ending work-in-process 1,000 1,000 250
Total units accounted for Single Line4,000Double line Single Line3,250Double line Single Line2,800Double line

 

We started with 750 units that were 100% complete as to materials and 60% processed, so the beginning work-in-process EUs for direct materials is 0% of 750 and for conversion costs is 40% of 750 which is 300.

We have 4,000 total units for which to account, with 750 in process at the beginning of the month, and the last batch that is still in process at the end of the month will be 1,000 shells once it is done. On the last day of February, it was only 25% through the process, meaning that the EUs for ending inventory for direct materials was 1,000 units and for conversion costs was 25% of 1,000 units which is 250 EUs.

Because we started with 750 shells we finished and transferred out, and we started another 3,250 into the process and ended with 1,000 still in the mixing department, we see that we transferred out 3,000 shells to the baking/packaging department. With 750 started in January, the other 2,250 were started and completed in February.

Step 3 – Divide costs by equivalent units

From the accounting records, we see that total direct materials transferred to the mixing department in February were $3,575 and that direct labor and manufacturing overhead totaled $3,640.

Description Direct Materials Converion Costs Total Costs
Subcategory, Costs to account for: Single Line Single Line Single Line
Beginning work-in-process $         750 $         540 $    1,290
Costs added during the period $       3,575 $       3,640 $    7,215
Total costs to account for Single Line$       4,325Double line Single Line$       4,180Double line Single Line$    8,505Double line

 

In the weighted average method, we divided total costs by total Equivalent Units, but here is where the FIFO method is significantly different.

Because we calculated EUs based on completed units, including EUs that represent the effort it took to complete the beginning inventory, we divide ONLY costs added during the period by our Equivalent Units.

Description Direct Materials Conversion Costs
Costs added during current period Single Line$        3,575 Single Line$        3,640
Divided by: Total EUP             3,250                 2,800
Cost per equivalent unit Single Line$         1.10Double line Single Line$         1.30Double line

 

Step 4 – Allocate costs based on equivalent units

Refer to step 2 for our calculator of EUs:

Equivalent Units
UNITS Physical Units Single LineDirect Materials Single LineConversion Costs
Subcategory, Units accounted for: Single Line Single Line Single Line
      Beginning work-in-process 750 0 300
      Started and completed 2,250 2,250 2,250
Total units transferred to baking Single Line3,000 Single Line2,250 Single Line2,550
      Ending work-in-process 1,000 1,000 250
Total units accounted for Single Line4,000Double line Single Line3,250Double line Single Line2,800Double line

 

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

  1. Costs for beginning work-in-process come from the prior Production Report’s ending work-in-process
  2. The cost to complete work-in-process is the EUs calculated in step 2 * the cost per EU from step 3
Description Direct Materials Conversion Costs
Equivalent units to complete beginning work-in-process 0 300
Cost per equivalent unit $       1.10 $            1.30
Cost allocated to completed units Single Line$          –Double line Single Line$             390Double line

 

Description Direct Materials Conversion Costs Total Costs
Subcategory, Costs accounted for: Single Line Single Line Single Line
Beginning work-in-process (1) $         750 $          540 $     1,290
Costs to complete (2) $           – $          390 $       390
Cost of work-in-process completed Single Line$         750 Single Line$          930 Single Line$     1,680
Started and completed (3) $       2,475 $        2,925 $     5,400
Transferred to baking/packaging Single Line$       3,225 Single Line$        3,855 Single Line$     7,080
Ending work-in-process $       1,100 $          325 $     1,425
Total costs accounted for Single Line$       4,325Double line Single Line$        4,180Double line Single Line$     8,505Double line

 

3. Work started and completed during the period = EUs * cost per EU

Description Direct Materials Conversion Costs
Equivalent units to complete beginning work-in-process 2,250 2,250
Cost per equivalent unit $       1.10 $        1.30
Cost allocated to completed units Single Line$      2,475Double line Single Line$       2,925Double line

 

4. Costs allocated to ending work-in-process = EUs * cost per EU

Description Direct Materials Conversion Costs
Equivalent units to complete beginning work-in-process 1,000 250
Cost per equivalent unit $       1.10 $       1.30
Cost allocated to completed units Single Line$      1,100Double line Single Line$        325Double line

 

Step 5 – Complete the production report

Dad’s Perfect Pies
Production Cost Report – Mixing Department – FIFO
Month Ended February 28
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 750
Started in production 3,250
Total units to account for Single Line4,000Double line
Subcategory, Units accounted for:
Beginning work-in-process 750 0 300
Started and completed 2,250 2,250 2,250
Total units transferred to baking Single Line3,000 Single Line2,250 Single Line2,550
Ending work-in-process 1,000 1,000 250
Total units accounted for Single Line4,000Double line Single Line3,250Double line Single Line2,800Double line
COSTS Direct Materials Conversion Costs Total Costs
Subcategory, Costs to account for: Single Line Single Line Single Line
Beginning work-in-process $          750 $          540 $      1,290
Costs added during the period $        3,575 $        3,640 $      7,215
Total costs to account for Single Line$        4,325Double line Single Line$        4,180Double line Single Line$      8,505Double line
Costs added during current period $        3,575 $        3,640
Divided by: Total EUP             3,250             2,800
Cost per equivalent unit Single Line$ 1.10Double line Single Line$ 1.30Double line
Subcategory, Costs accounted for:
Beginning work-in-process $          750 $           540 $     1,290
Costs to complete $            – $           390 $       390
Cost of work-in-process completed Single Line$          750 Single Line$           930 Single Line$     1,680
Started and completed $        2,475 $         2,925 $     5,400
Transferred to baking/packaging Single Line$        3,225 Single Line$         3,855 Single Line$     7,080
Ending work-in-process $        1,100 $           325 $     1,425
Total costs accounted for Single Line$        4,325Double line Single Line$         4,180Double line Single Line$     8,505Double line

 

In circumstances where the product is flowing in batches like this, FIFO gives us a more accurate per unit cost for both beginning and ending work-in-process inventory.

Now, check your understanding of the FIFO method of computing ending and work-in-process inventory using process costing.

Practice Question