In: Accounting
A company uses the periodic inventory system and had the following activity during the current monthly period.
November 1: Beginning inventory 114 Units @ $30
November 5: Purchased 114 Units @ $26
November 8: Purchased 64 Units @ $30
November 16: Sold 182 Units @ $115
November 19: Purchased 85 Units @ $30
Using the weighted-average inventory method, the company's ending inventory would be:
Opening Inventory | Purchases | Sales | Closing Inventory | |||||||||
Date | Quantity | Rate | Amount | Quantity | Rate | Amount | Quantity | Rate | Amount | Quantity | Rate | Amount |
Nov.1 | 114.00 | $ 30.00 | $ 3,420.00 | 114.00 | $ 30.00 | $ 3,420.00 | ||||||
Nov.5 | 114.00 | $ 30.00 | $ 3,420.00 | 114.00 | $ 26.00 | $ 2,964.00 | 228.00 | $ 28.00 | $ 6,384.00 | |||
Nov.8 | 228.00 | $ 28.00 | $ 6,384.00 | 64.00 | $ 30.00 | $ 1,920.00 | 292.00 | $ 28.44 | $ 8,304.00 | |||
Nov.16 | 292.00 | $ 28.44 | $ 8,304.00 | 182.00 | $ 28.44 | $ 5,175.78 | 110.00 | $ 28.44 | $ 3,128.22 | |||
Nov.19 | 110.00 | $ 28.44 | $ 3,128.22 | 85.00 | $ 30.00 | $ 2,550.00 | 195.00 | $ 29.12 | $ 5,678.22 |
Ending Inventory -
Quantity | Rate | Amount |
195.00 | $ 29.12 | $ 5,678.22 |