Math Problem Statement
Intercontinental, Incorporated, uses a perpetual inventory system. Consider the following information about its inventory: August 1, purchased 10 units for $910 or $91 per unit; August 3, purchased 15 units for $1,590 or $106 per unit; August 14, sold 20 units; August 17, purchased 20 units for $2,300 or $115 per unit; August 28, purchased 10 units for $1,190 or $119 per unit; August 30, sold 23 units.
Using weighted average, the cost of goods sold for the sale of 23 units on August 30 is ____ and the inventory balance at August 30 is _____.
Solution
To calculate the cost of goods sold (COGS) and the inventory balance using the weighted average method, we follow these steps:
-
Calculate Total Units and Cost of Inventory:
- Beginning Inventory:
- August 1: 10 units at $91 = $910
- Purchases:
- August 3: 15 units at $106 = $1,590
- August 17: 20 units at $115 = $2,300
- August 28: 10 units at $119 = $1,190
Total Units Purchased:
- 10 + 15 + 20 + 10 = 55 units
Total Cost:
- $910 + $1,590 + $2,300 + $1,190 = $6,990
- Beginning Inventory:
-
Calculate Weighted Average Cost per Unit:
-
Calculate COGS for Sale of 23 Units on August 30:
-
Calculate Remaining Inventory:
Units After Sale on August 30:
- Total Units After Sales: 55 - 20 (sold on August 14) - 23 (sold on August 30) = 12 units remaining.
Cost of Remaining Inventory:
Final Results:
- COGS for the sale of 23 units on August 30: $2,921.07
- Inventory balance at August 30: $1,525.08
Would you like more details or have any questions? Here are some related questions to consider:
- How would the COGS change if a different inventory valuation method were used?
- What factors might affect the weighted average cost calculation?
- How does a perpetual inventory system differ from a periodic system?
- Can you explain how inventory purchases affect cash flow?
- What impact do sales returns have on COGS and inventory balance?
Tip: Regularly update your inventory records to reflect real-time inventory levels and costs for more accurate financial reporting.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Inventory Management
Weighted Average Cost
Formulas
Weighted Average Cost per Unit = Total Cost / Total Units
COGS = Units Sold × Weighted Average Cost per Unit
Remaining Inventory Cost = Remaining Units × Weighted Average Cost per Unit
Theorems
-
Suitable Grade Level
Grades 11-12
Related Recommendation
Calculate Cost of Goods Sold and Ending Inventory Using Weighted Average
Calculate Cost of Goods Sold (COGS) and Ending Inventory: FIFO vs Weighted Average Methods
Cost of Goods Sold and Inventory Valuation Using FIFO, LIFO, and Average Cost for Thames Company
FIFO Inventory Accounting: Calculating Cost of Goods Sold (COGS)
Calculating Cost of Goods Sold Using FIFO Method in Perpetual Inventory System