In: Accounting
Alternative Inventory Methods
Frate Company was formed on December 1, 2015, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply:
| Units | Unit Cost | |||
|---|---|---|---|---|
| January 1, 2016 (beginning inventory) | 1,500 | $9.00 | ||
| Purchases: | ||||
| January 6, 2016 | 2,200 | 10.00 | ||
| January 25, 2016 | 1,900 | 10.50 | ||
| February 17, 2016 | 1,300 | 11.00 | ||
| March 27, 2016 | 1,600 | 11.50 | ||
A physical inventory on March 31, 2016 shows 3,000 units on hand.
Required:
For each method, enter your answers in chronological order.
Prepare schedules to compute the ending inventory at March 31,
2016, under each of the following inventory methods:
(For the weighted average method, round the average cost per unit
to two decimal places.)
1. FIFO
| FRATE COMPANY | |||
| Computation of Inventory for Product Ply Under FIFO Inventory Method | |||
| March 31, 2016 | |||
| Units | Unit cost | Total cost | |
| $ | $ | ||
| March 31, 2016 inventory | $ | ||
2. LIFO
| FRATE COMPANY | |||
| Computation of Inventory for Product Ply Under LIFO Inventory Method | |||
| March 31, 2016 | |||
| Units | Unit cost | Total cost | |
| $ | $ | ||
| March 31, 2016 inventory | $ | ||
3. Weighted average
| FRATE COMPANY | |||
| Computation of Inventory for Product Ply Under Weighted Average Inventory Method | |||
| March 31, 2016 | |||
| Units | Unit cost | Total cost | |
| Beginning inventory | $ | $ | |
| January 6, 2016 | |||
| January 25, 2016 | |||
| February 17, 2016 | |||
| March 27, 2016 | |||
| Total | $ | ||
| Weighted average cost | $ | ||
| March 31, 2016 inventory | $ | $ | |
Prepare schedules to compute the ending inventory at March 31,
2016, under each of the following inventory methods:
(For the weighted average method, round the average cost per unit
to two decimal places.)
1. FIFO
| FRATE COMPANY | |||
| Computation of Inventory for Product Ply Under FIFO Inventory Method | |||
| March 31, 2016 | |||
| Units | Unit cost | Total cost | |
| March 27, 2016 | 1600 | $11.50 | $18400 | 
| February 17, 2016 | 1300 | 11 | 14300 | 
| January 25, 2016 | 100 | 10.50 | 1050 | 
| March 31, 2016 inventory | 3000 | $33750 | |
2. LIFO
| FRATE COMPANY | |||
| Computation of Inventory for Product Ply Under LIFO Inventory Method | |||
| March 31, 2016 | |||
| Units | Unit cost | Total cost | |
| January 1, 2016 (beginning inventory) | 1500 | $9 | $13500 | 
| January 6, 2016 | 1500 | 10 | 15000 | 
| March 31, 2016 inventory | 3000 | $28500 | |
3. Weighted average
| FRATE COMPANY | |||
| Computation of Inventory for Product Ply Under Weighted Average Inventory Method | |||
| March 31, 2016 | |||
| Units | Unit cost | Total cost | |
| Beginning inventory | 1500 | $9 | $13500 | 
| January 6, 2016 | 2200 | 10 | 22000 | 
| January 25, 2016 | 1900 | 10.50 | 19950 | 
| February 17, 2016 | 1300 | 11 | 14300 | 
| March 27, 2016 | 1600 | 11.50 | 18400 | 
| Total | 8500 | $88150 | |
| Weighted average cost | $10.37 | ||
| March 31, 2016 inventory | 3000 | $10.37 | $31110 |