In: Accounting
Crane Company uses a periodic inventory system. For October,
when the company sold 1,690 units, the following information is
available.
Units | Unit Cost | Total Cost | ||||
---|---|---|---|---|---|---|
October 1 inventory | 580 | $22 | $12,760 | |||
October 8 purchase | 1,160 | 23 | 26,680 | |||
October 25 purchase | 580 | 26 | 15,080 | |||
2,320 | $54,520 |
Compute the October 31 inventory and the October cost of goods sold
using the FIFO method.
Ending inventory | $enter the ending inventory in dollars | |
---|---|---|
Cost of goods sold | $enter the cost of goods sold in dollars |
Solution
FIFO | |
Ending Inventory | $ 16,230 |
Cost of Goods Sold | $ 38,290 |
Working
Units | Cost per unit | value | |
Beginning Balance | 580 | $ 22.00 | $ 12,760 |
Purchases | |||
1160 | $ 23.00 | $ 26,680 | |
580 | $ 26.00 | $ 15,080 | |
Cost of goods available for sale | 2320 | $ 54,520 |
.
FIFO | ||||
Total Units Available for sale | 2320 | |||
Units Sold | 1690 | |||
Closing Stock in Units | 630 | |||
Valuation | ||||
Ending Inventory | 580 | @ | $ 26.00 | $ 15,080 |
50 | @ | $ 23.00 | $ 1,150 | |
Value Of Ending Inventory | $ 16,230 | |||
Cost of Goods sold | 54520 minus 16230 | $ 38,290.00 |