In: Finance
The Lippert Company uses the periodic inventory system. The following July data are for an item in loppers inventory:
July 1 Beginning Inventory 100 units@ $8 per unit
10 Purchased 120 units@ $9 per unit
15 sold 130 units@
26 Purchased 95 units@ $10 per unit
Calculate the cost of goods sole for July and ending inventory at July 31 using (a) first-in, first out (b) last-in, first out and (c) the weighted- average cost methods. Round your final answers to the nearest dollar.
A. first-in, first-out
Ending Inventory $-
Cost of goods sold $-
B. Last-in, first-out
ending inventory $-
cost of goods sold $-
C. Weighted- average cost
ending inventory. $-
cost of goods sold $-
Let me know if you need any clarification..
| Answer A. using FIFO | ||||||
| Purchase | ||||||
| Date | Qty | rate | value | |||
| July -1 beginning | 100 | 8 | 800 | |||
| July -10 pur | 120 | 9 | 1080 | |||
| July -15 sale | -130 | |||||
| July 26 Purchase | 95 | 10 | 950 | |||
| closing inventory | 185 | |||||
| 2830 | ||||||
| Therefore cost of goods sold | 100*8+30*9 | |||||
| Therefore cost of goods sold | 1070 | |||||
| ending inventory 2830-1070 | 1760 | |||||
| Answer B. using LIFO | ||||||
| Therefore cost of goods sold | 95*10+35*9 | 35 | ||||
| Therefore cost of goods sold | 1265 | |||||
| ending inventory 2830-1265 | 1565 | |||||
| Answer C. using weighted average | ||||||
| Weighted average rate = 2830/(100+120+95) | 8.98 | |||||
| Cost of goods sold = 130*8.98 | 1,168 | |||||
| ending inventory = 2830-1168 | 1,662 | |||||