In: Accounting
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system. August 1 Beginning inventory 190 units of Product A @ $1,600 total cost 5 Purchased 210 units of Product A @ $2,116 total cost 8 Purchased 310 units of Product A @ $4,416 total cost 11 Sold 260 units of Product A Calculate the August cost of goods sold and the ending inventory at August 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods. Do not round until your final answers. Round your final answers to the nearest dollar.
| a) FIFO | ||||
| Date | Particulars | Units | Cost per Unit | Total Cost |
| Aug 1 | Beginning Inventory | 190 | 8 | 1,600 |
| Aug 5 | Purchase | 210 | 10.07619 | 2,116 |
| Aug 8 | Purchase | 310 | 14 | 4,416 |
| Cost of Goods Available for Sale | 710 | 8,132 | ||
| Less: Ending Inventory ( 310*14+140*10.07619) | 450 | 5,751 | ||
| Cost of Goods Sold | 260 | 2,381 | ||
| b) LIFO (Periodic) | ||||
| Date | Particulars | Units | Cost per Unit | Total Cost |
| Aug 1 | Beginning Inventory 1 | 190 | 8 | 1,600 |
| Aug 5 | Purchase 5 | 210 | 10.07619 | 2,116 |
| Aug 8 | Purchase 8 | 310 | 14 | 4,416 |
| Cost of Goods Available for Sale | 710 | 8,132 | ||
| Less: Ending Inventory ( 190*8+210*10.07619+50*14) | 450 | 4,336 | ||
| Cost of Goods Sold | 260 | 3,796 | ||
| c) Average Cost method | ||||
| Date | Particulars | Units | Cost per Unit | Total Cost |
| Aug 1 | Beginning Inventory 1 | 190 | 8 | 1,600 |
| Aug 5 | Purchase 5 | 210 | 10.07619 | 2,116 |
| Aug 8 | Purchase 8 | 310 | 14 | 4,416 |
| Cost of Goods Available for Sale | 710 | 8,132 | ||
| Less: Ending Inventory ( 450*11) | 450 | 11 | 4,950 | |
| Cost of Goods Sold | 260 | 3,182 |