In: Accounting
Inventory Costing Methods—Periodic Method
The following data are for the Porter Corporation, which sells just one product:
Units | Unit Cost | ||
---|---|---|---|
Beginning Inventory, January 1 | 1,200 | $8 | |
Purchases: | February 11 | 1,500 | 9 |
May 18 | 1,400 | 12 | |
October 23 | 1,100 | 14 | |
Sales: | March 1 | 1,400 | |
July 1 | 1,400 | ||
October 29 | 1,200 |
Calculate the value of ending inventory and cost of goods sold at year-end using the periodic method and (a) first-in, first-out, (b) last-in, first-out, and (c) weighted-average cost method. Round the cost per unit to 3 decimal places and round your final answers to the nearest dollar.
a. | First-in, First-out: | |
Ending Inventory | Answer | |
Cost of goods sold | Answer | |
b. | Last-in, first-out: | |
Ending Inventory | Answer | |
Cost of goods sold | Answer | |
c. | Weighted Average | |
Ending Inventory | Answer | |
Cost of goods sold | Answer |
Units | Unit cost | Total | |
Beginning Inventory | 1200 | 8 | 9600 |
February 11 | 1500 | 9 | 13500 |
May 18 | 1400 | 12 | 16800 |
October 23 | 1100 | 14 | 15400 |
Total | 5200 | 55300 | |
Sales units | 4000 | =1400+1400+1200 | |
Ending inventory units | 1200 | =5200-4000 | |
Average cost | 10.635 | =55300/5200 | |
a | |||
First-in, First-out: | |||
Ending Inventory | 16600 | =(1100*14)+(1200-1100)*12 | |
Cost of goods sold | 38700 | =55300-16600 | |
b | |||
Last-in, first-out: | |||
Ending Inventory | 9600 | =1200*8 | |
Cost of goods sold | 45700 | =55300-9600 | |
c | |||
Weighted Average : | |||
Ending Inventory | 12762 | =1200*10.635 | |
Cost of goods sold | 42538 or 42540 | =55300-12762 |