Question

The following information was available from the inventory records of Sheffield Corp. for January: Units Unit Cost Total Cost Balance at January 1 9200 $9.73 $89516 Purchases: January 6 6400 10.31 65984 January 26 7900 10.71 84609 Sales January 7 (7700 ) January 31 (11300 ) Balance at January 31 4500 Assuming that Sheffield does not maintain perpetual inventory records, what should be the inventory at January 31, using the weighted-average inventory method, rounded to the nearest dollar

Answer 1

Answer:

$45,990

Explanation:

The Weighted Average Cost Method, calculates a new Unit Cost with every purchase that is made. This is applicable to perpetual Inventory method. In this case we are required to use the periodic Inventory method (Sheffield does not maintain perpetual inventory records). Thus our Unit Cost is calculated from Inventory available for Sale.

Step 1

Units Available For Sales Calculation :

Opening Balance                           9,200

Add Purchases (6,400 + 7,900)   14,300

Units Available for Sale               23,500

Less Units Sold (7700 + 11300)  (19,000)

Ending Inventory Units                  4,500

Step 2

Unit Cost = Total Cost ÷ Units Available for Sale

                = ($89,516  + $65,984 + $84,609) ÷ 23,500

                = $10.22

Step 3

Ending Inventory = Units in Stock × Unit Cost

                             = 4,500 × $10.22

                             = $45,990