Question

Shellhammer Company's inventory records show the following data for the month of September: Units Unit Cost Inventory, September 1 100 $3.34 Purchases: September 8 450 3.50 September 18 350 3.70 A physical inventory on September 30 shows 200 units on hand. Calculate the value of the ending inventory and cost of goods sold if the company uses weighted average inventory costing and a periodic inventory system. (Round

Answer 1

Answer:

Shellhammer Company

Ending inventory = $712

Cost of goods sold = $2,492

Explanation:

a) Data and Calculations:

Date                     Item          Units           Unit Cost     Total Cost

September 1    Inventory           100           $3.34          $334.00

September 8   Purchases        450             3.50          1,575.00

September 18 Purchases        350              3.70          1,295.00

September 30 Total                900                            $3,204.00

Ending inventory                     200

Cost of goods sold                 700

Weighted Average cost = Total cost of goods available for sale/Total units available for sale

= $3,204/900 = $3.56

Value of Ending Inventory = $3.56 * 200 = $712

Value of Cost of goods sold = $3.56 * 700 = $2,492

b) The weighted average inventory costing, under the period inventory system, used by Shellhammer is an assumption that the costs attributable to ending inventory and cost of goods sold are determined from the average cost per unit and that these the average cost is ascertained at the end of the period.  Therefore, the cost of beginning inventory and purchases are accumulated and divided by the units of goods available for sale.