Accounting!!

Applying Average Cost

Click hereto review an illustrated example of the average cost calculation. The key is to compute a new average cost after each purchase.

You will now put the average cost method into practice. Millwall Co. would like to explore what is meant by the weighted average cost per unit, a concept that is central to this method of inventory valuation. Remember, the weighted average must be adjusted with each purchase. Also, as sales occur, previous inventory values must be bundled to keep track of inventory on hand and to accurately track subsequent additions to inventory.

The data for Millwall Co. is below for the month of November.

Complete the schedule below. Remember, the weighted average must be adjusted with each purchase. Also, as sales occur, previous inventory values must be bundled to keep track of inventory on hand and to accurately track subsequent additions to inventory. Round the average cost per unit to four decimal places and total costs to the nearest dollar.