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 | ||||