Math Problem Statement
One of the methods permitted by Generally Accepted Accounting Principle for reporting the value of a firm's inventory is weighted average inventory pricing. Southwest Consulting began its fiscal year with an inventory of 630 units valued at $13.71 per unit. During the year it made the purchases listed in the following table.
date: january 26 ,, august 20 , december 27 unit purchased: 920 , 295 , 500 unit cost($) : $13.91 ,$13.53 , $14.20 At the end of the year, 115 units remained in its inventory. For full marks your answer(s) should be rounded to the nearest cent.
Determine: a. The weighted average cost of the units purchased during the year.
b. The weighted average cost of the beginning inventory and all units purchased during the year.
c. The value of the ending inventory based on the weighted-average cost calculated in b).
Solution
To solve this problem, we will approach it step by step.
Given Information:
-
Beginning Inventory:
- Units: 630
- Unit Cost: $13.71
-
Purchases during the year:
- January 26:
- Units: 920
- Unit Cost: $13.91
- August 20:
- Units: 295
- Unit Cost: $13.53
- December 27:
- Units: 500
- Unit Cost: $14.20
- January 26:
-
Ending Inventory:
- Units remaining at the end of the year: 115 units
We need to calculate the following:
Part (a): The weighted average cost of the units purchased during the year
For this, we'll consider only the purchases made during the year (excluding the beginning inventory). The formula for the weighted average cost is:
Part (b): The weighted average cost of the beginning inventory and all units purchased during the year
This includes both the beginning inventory and all purchases made during the year. The formula is:
Part (c): The value of the ending inventory based on the weighted-average cost calculated in Part (b)
Finally, we will calculate the value of the ending inventory by multiplying the number of units left in the inventory by the weighted average cost obtained in part (b).
Let's calculate this step by step.Here are the results:
Part (a): Weighted Average Cost of Units Purchased During the Year
- The weighted average cost of the units purchased during the year is $13.93 per unit (rounded to the nearest cent).
Part (b): Weighted Average Cost of the Beginning Inventory and All Units Purchased During the Year
- The weighted average cost of the beginning inventory and all units purchased during the year is $13.87 per unit (rounded to the nearest cent).
Part (c): Value of the Ending Inventory
- The value of the ending inventory, based on the weighted average cost calculated in Part (b), is $1,595.08 (rounded to the nearest cent).
Do you want further details on any of these calculations? Here are some related questions for additional practice:
- How does the FIFO method differ from the weighted average method for inventory valuation?
- If the ending inventory had been 150 units, how would that affect the ending inventory value?
- How would the weighted average cost change if there was an additional purchase in November?
- How does inflation impact the accuracy of weighted average inventory pricing?
- Can the weighted average method result in higher or lower taxes compared to LIFO?
Tip: In a rising price environment, FIFO typically results in a higher ending inventory value compared to the weighted average method.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Weighted Average
Inventory Valuation
Formulas
Weighted Average Cost = Total Cost / Total Units
Ending Inventory Value = Units in Inventory * Weighted Average Cost
Theorems
-
Suitable Grade Level
College Level
Related Recommendation
Calculate Ending Inventory Cost using Weighted-Average Method
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
Calculate Cost of Goods Sold and Ending Inventory Using Weighted Average