In: Accounting
Alternative Inventory Methods
Frate Company was formed on December 1, 2018, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply:
Units | Unit Cost | |||
---|---|---|---|---|
January 1, 2019 (beginning inventory) | 4,400 | $5.00 | ||
Purchases: | ||||
January 6, 2019 | 5,100 | 6.00 | ||
January 25, 2019 | 4,800 | 6.50 | ||
February 17, 2019 | 4,200 | 7.00 | ||
March 27, 2019 | 4,500 | 7.50 |
A physical inventory on March 31, 2019, shows 8,800 units on hand.
Required:
Prepare schedules to compute the ending inventory at March 31,
2019, under each of the following inventory methods.
1. FIFO
FRATE COMPANY | |||
Computation of Inventory Under FIFO Inventory Method | |||
March 31, 2019 | |||
Units | Unit cost | Total cost | |
March 27, 2019 | |||
February 17, 2019 | |||
January 25, 2019 (portion) | |||
March 31, 2019 inventory |
2. LIFO
FRATE COMPANY | |||
Computation of Inventory Under LIFO Inventory Method | |||
March 31, 2019 | |||
Units | Unit cost | Total cost | |
Beginning inventory | |||
January 6, 2019 (portion) | |||
March 31, 2019 inventory |
3. Weighted average
FRATE COMPANY | |||
Computation of Inventory Under Weighted Average Inventory Method | |||
March 31, 2019 | |||
Units | Unit cost | Total cost | |
Beginning inventory | |||
January 6, 2019 | |||
January 25, 2019 | |||
February 17, 2019 | |||
March 27, 2019 | |||
Total | |||
Weighted average cost | |||
March 31, 2019 inventory |
FIFO | ||||
Date | Particulars | Units | Cost per Unit | Total Cost |
Jan 1 | Beginning Inventory | 4400 | 5.0 | 22,000 |
Jan 6 | Purchase | 5100 | 6 | 30,600 |
Jan 25 | Purchase | 4800 | 6.50 | 31,200 |
FEb 17 | Purchase | 4200 | 7.00 | 29,400 |
Marc 27 | Purchase | 4500 | 7.50 | 33,750 |
Cost of Goods Available for Sale | 23000 | 83,800 | ||
Less: Ending Inventory (4500*7.5+4200*7+100*6.5) | 8800 | 63,800 | ||
Cost of Goods Sold | 14200 | 20,000 | ||
LIFO (Periodic) | ||||
Date | Particulars | Units | Cost per Unit | Total Cost |
JAn 1 | Beginning Inventory | 4400 | 5.0 | 22,000 |
JAn 6 | Purchase | 5100 | 6 | 30,600 |
JAn 25 | Purchase | 4800 | 6.50 | 31,200 |
Feb 17 | Purchase | 4200 | 7.00 | 29,400 |
MAr 27 | Purchase | 4500 | 7.50 | 33,750 |
Cost of Goods Available for Sale | 23000 | 83,800 | ||
Less: Ending Inventory (4400*5+4400*6) | 8800 | 48,400 | ||
Cost of Goods Sold | 14200 | 35,400 | ||
Weighted Average Cost method | ||||
Date | Particulars | Units | Cost per Unit | Total Cost |
JAn 1 | Beginning Inventory | 4400 | 5.0 | 22,000 |
Jan 6 | Purchase | 5100 | 6 | 30,600 |
Jan 25 | Purchase | 4800 | 6.50 | 31,200 |
Feb 17 | Purchase | 4200 | 7.00 | 29,400 |
Mar 27 | Purchase | 4500 | 7.50 | 33,750 |
Cost of Goods Available for Sale | 23000 | 83,800 | ||
Less: Ending Inventory | 8800 | 3.643478 | 32,063 | |
Cost of Goods Sold | 14200 | 51,737 |