In: Accounting
CHO Company was formed on December 1, 2009. The following information is available from Jones's inventory record for Product X.
Units Unit Cost
January 1, 2010 (beginning inventory) 1,600 $18.00
Purchases:
January 5, 2010 2,600 $20.00
January 25, 2010 2,400 $21.00
February 16, 2010 1,000 $22.00
March 15, 2010 1,800 $23.00
A physical inventory on March 31, 2010, shows 2,500 units on hand.
Prepare schedules to compute the ending inventory at March 31, 2010, using Weighted-average
Particulars | Units | Cost per unit | Value | |||
January 1, 2010 (beginning inventory) | 1600 | 18 | 28800 | |||
Add: Purchases | ||||||
Jan-05 | 2600 | 20 | 52000 | |||
Jan-25 | 2400 | 21 | 50400 | |||
Feb-16 | 1000 | 22 | 22000 | |||
Mar-15 | 1800 | 23 | 41400 | |||
Total | 9400 | 194600 |
Using Weighted Average, Cost per unit : 194600 /9400 Cost per unit : $20.70. Its given that March 31.2010 : 2500 units on hand. Cost per unit : $ 20.70 Therefore Value of Inventory : 2500 X 20.70 : $51,750. |