Learning Outcomes
- Prepare a production cost report using the FIFO method
Let’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.
- Costs for beginning work-in-process come from the prior Production Report’s ending work-in-process
- 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
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.