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.)
Cost of ending inventory
$
b. Calculate the cost of goods sold using the
weighted-average method. (Round your intermediate
calculations and final answer to the nearest cent.)
Cost of goods sold
$
|
Units |
Cost per unit |
value |
|
|
Beginning Balance |
40 |
$ 4.00 |
$ 160.00 |
|
Purchases |
|||
|
1-Apr |
60 |
$ 7.00 |
$ 420.00 |
|
1-Jun |
50 |
$ 8.00 |
$ 400.00 |
|
1-Nov |
55 |
$ 9.00 |
$ 495.00 |
|
205 |
$ 1,475.000 |
|
Average Cost of Inventory |
||
|
Units |
(A) |
205 |
|
Total Cost |
(B) |
$ 1,475.00 |
|
Average Cost |
(C=B/A) |
$ 7.20 |
|
Weighted Average method |
||||
|
Total Units Available for sale |
205 |
|||
|
Units Sold |
144 |
|||
|
Closing Stock in Units |
61 |
|||
|
Valuation |
||||
|
Ending Inventory |
61 |
@ |
$ 7.20 |
$ 439.20 |
|
Value Of Ending Inventory |
$ 439.20 |
|||
|
Cost of Goods sold |
(Total Purchase and opening stock Minus Closing Stock) |
$ 1,035.80 |
||
Requirement 1
Cost of Ending Inventory =$439.20
Requirement 2
Cost of Goods sold =$1035.80