In: Accounting
Given the following:
| Number purchased |
Cost per unit |
Total | ||||
| January 1 inventory | 40 | $ | 4 | $ | 160 | |
| April 1 | 60 | 7 | 420 | |||
| June 1 | 50 | 8 | 400 | |||
| November 1 | 55 | 9 | 495 | |||
| 205 | $ | 1,475 | ||||
a. Calculate the cost of ending inventory using
the weighted-average method (ending inventory shows 61 units).
(Round the "average unit cost" and final answer to the
nearest cent.)
b. Calculate the cost of goods sold using the
weighted-average method. (Round your intermediate
calculations and final answer to the nearest
cent.)
| Date | Number purchased | Cost per Unit | Total | |
| January 1 inventory | 40 | 4 | 160 | |
| Apr-01 | 60 | 7 | 420 | |
| Jun-01 | 50 | 8 | 400 | |
| Nov-01 | 55 | 9 | 495 | |
| 205 | 1,475 | |||
| Cost per Unit as per weighted average = total purchase / total Inventory Units | ||||
| =1475 / 205 | ||||
| 7.20 | ||||
| a) Cost of ending inventory = Ending units * weighted average cost | ||||
| =61*7.20 | ||||
| 439 | ||||
| b) Cost of goods sold = total purchase - ending Inventory | ||||
| =1475 - 439 | ||||
| 1,036 | ||||