In: Accounting
Computing Cost of Sales and Ending Inventory
Stocken Company has the following financial records for the current
period.
Units | Unit Cost | |
---|---|---|
Beginning Inventory | 100 | $ 26 |
Purchases: #1 | 650 | 22 |
#2 | 550 | 18 |
#3 | 200 | 16 |
Ending inventory is 350 units. Compute the ending inventory and the
cost of goods sold for the current period using (a) first-in, first
out, (b) average cost, and (c) last-in, first out.
(a) First-in, first-out | |
Ending inventory | $Answer |
Cost of goods sold | $Answer |
(b) Average cost | |
Ending inventory | $Answer |
Cost of goods sold | $Answer |
(c) Last-in, first-out | |
Ending inventory | $Answer |
Cost of goods sold | $Answer |
Units | Unit Cost | Total | ||||
Beginning Inventory | 100 | 26.00 | 2600 | |||
Purchases: #1 | 650 | 22.00 | 14300 | |||
#2 | 550 | 18.00 | 9900 | |||
#3 | 200 | 16.00 | 3200 | |||
Total Units Available | 1500 | 30000 | ||||
Less: Closing Inventory | 350 | |||||
Units Sold | 1150 | |||||
A | FIFO: | |||||
Units Sold | 1150 | |||||
In FIFO Method, First In Units are sold first | ||||||
Beginning Inventory | 100 | 26.00 | 2600 | |||
Purchases: #1 | 650 | 22.00 | 14300 | |||
#2-(1150-100-650) | 400 | 18.00 | 7200 | |||
Cost of Goods Sold | 1150 | 24100 | ||||
Ending Inventory | 350 | 5900 | (30000-24100) | |||
B | Average Cost: | |||||
Computation of Average Cost: | A | B | B/A | |||
Total Units Available | 1500 | 30000 | 20.00 | |||
Average Cost | ||||||
Cost of Goods Sold | 1150 | 20.00 | 23000 | |||
Ending Inventory | 350 | 20.00 | 7000 | |||
C | LIFO: | |||||
Units Sold | 1150 | |||||
In LIFO Method, Last In Units are sold first | ||||||
#3 | 200 | 16.00 | 3200 | |||
#2 | 550 | 18.00 | 9900 | |||
Purchases: #1-(1150-200-550) | 400 | 22.00 | 8800 | |||
Cost of Goods Sold | 1150 | 21900 | ||||
Ending Inventory | 350 | 8100 | (30000-21900) | |||