Math Problem Statement
Use the weighted-average inventory method to calculate the cost of the ending inventory for the inventory table below.
Date of purchase
Units purchased
Cost per unit
Total cost
Retail price per unit
Total retail value
Beginning inventory
9696
$1212
$1 comma 1521,152
$1616
$1 comma 5361,536
February 5
2121
$88
$168168
$1313
$273273
February 19
1717
$1111
$187187
$1616
$272272
March 3
3535
$1414
$490490
$2222
$770770
Goods available for sale
169169
$1 comma 9971,997
$2 comma 8512,851
Units sold
8989
Ending inventory
8080
Solution
To calculate the cost of the ending inventory using the weighted-average inventory method, we need to find the average cost per unit for the goods available for sale and then multiply this by the number of units in the ending inventory.
Here's the data provided:
Date of purchase | Units purchased | Cost per unit | Total cost | Retail price per unit | Total retail value |
---|---|---|---|---|---|
Beginning inventory | 96 | $12 | $1,152 | $16 | $1,536 |
February 5 | 21 | $8 | $168 | $13 | $273 |
February 19 | 17 | $11 | $187 | $16 | $272 |
March 3 | 35 | $14 | $490 | $22 | $770 |
Goods available for sale | 169 | $1,997 | $2,851 | ||
Units sold | 89 | ||||
Ending inventory | 80 |
Step 1: Calculate the total cost of goods available for sale. This is already given as $1,997.
Step 2: Calculate the average cost per unit.
Step 3: Calculate the cost of the ending inventory.
So, the cost of the ending inventory is approximately .
Would you like more details or have any questions about this calculation?
Here are some additional questions you might find useful:
- How does the weighted-average inventory method differ from FIFO and LIFO?
- What are the advantages of using the weighted-average inventory method?
- Can you explain the impact of inventory valuation methods on financial statements?
- How do you account for inventory shrinkage in inventory valuation?
- What are the steps to switch from one inventory valuation method to another?
Tip: When using the weighted-average inventory method, ensure that all purchase costs are included, and remember to update the average cost per unit after each purchase.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Weighted-average inventory method
Formulas
Average cost per unit = Total cost of goods available for sale / Total units available for sale
Cost of ending inventory = Average cost per unit × Units in ending inventory
Theorems
-
Suitable Grade Level
Advanced
Related Recommendation
Calculate Weighted Average Cost and Ending Inventory Value in Accounting
Calculate Ending Inventory and Cost of Goods Sold (FIFO and Weighted Average)
Weighted Average Inventory Valuation with Perpetual System - Trey Monson Example
Weighted-Average Method Calculation for Ending Inventory and COGS at October 31
Ending Inventory Calculation using Average Cost Method for Gecko Enterprises