In: Accounting
Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki’s records show the following for the month of January. Sales totaled 320 units. Date Units Unit Cost Total Cost Beginning Inventory January 1 260 $ 85 $ 22,100 Purchase January 15 420 95 39,900 Purchase January 24 220 115 25,300 Required: Calculate the number and cost of goods available for sale. Calculate the number of units in ending inventory. Calculate the cost of ending inventory and cost of goods sold using the (a) FIFO, (b) LIFO, and (c) weighted average cost methods.
Units | Unit cost | Total | |
January 1 | 260 | 85 | 22100 |
January 15 | 420 | 95 | 39900 |
January 24 | 220 | 115 | 25300 |
Total | 900 | 87300 | |
1 | |||
Number of goods available for sale | 900 | ||
Cost of goods available for sale | 87300 | ||
2 | |||
Number of units in ending inventory | 580 | =900-320 | |
3 | |||
FIFO: | |||
Cost of ending inventory | 59500 | =(220*115)+(580-220)*95 | |
Cost of goods sold | 27800 | =87300-59500 | |
LIFO: | |||
Cost of ending inventory | 52500 | =(260*85)+(580-260)*95 | |
Cost of goods sold | 34800 | =87300-52500 | |
Weighted average cost: | |||
Average cost | 97 | =87300/900 | |
Cost of ending inventory | 56260 | =580*97 | |
Cost of goods sold | 31040 | =87300-56260 | |