In: Accounting
A company uses a perpetual inventory system. The company's beginning inventory of shoes and the purchases during a month as as follows:
Beginning Inventory Jan 1: 16 pairs at $10 ea
Purchase Jan 11: 14 pairs @ $12 ea
Purchase Jan 20: 23 pairs at $15 ea
On Jan 14 the company sold 25 units of shoes. The other 28 units remained in inventory at Jan 31.
Question 1: Assuming the company uses the average cost flow assumption what is the cost of goods sold to be recorded on Jan 14 (round to the nearest cent).
cost per unit=total cost available for sale/total units available for sale
328/30=10.9
23*10.9=250.7
Question 2: The total cost of goods available for sale is $673. Assuming average cost flow what would the ending inventory be on Jan 31?
COGS/Total pairs available for sale?
Correct Answer:
Requirement 1:
Cost of goods sold to be recorded on 14- Jan = $ 328.00
|
Cost of Goods sold |
||||
|
Units |
Cost per unit |
value |
||
|
Beginning Inventory |
$ - |
|||
|
Purchases |
||||
|
$ - |
||||
|
14-Jan |
25 |
$ 10.93 |
$ 273.25 |
|
|
Total |
25 |
$ 273.25 |
||
|
Cost of Goods Available for sale |
||||
|
Units |
Cost per unit |
value |
||
|
Beginning Inventory |
16 |
$ 10.00 |
$ 160.00 |
|
|
Purchases |
||||
|
11-Jan |
14 |
$ 12.00 |
$ 168.00 |
|
|
Total |
30 |
$ 328.00 |
||
|
Weighted Average Cost Per unit |
|||
|
Units |
(A) |
30 |
|
|
Total Cost |
(B) |
$ 328.00 |
|
|
Average Cost |
(C=B/A) |
$ 10.93 |
|
Requirement 2:
The Ending inventory = $ 00.00
Working:
|
FIFO |
||||||
|
A |
Total Units Available for sale |
53 |
$ 673.00 |
|||
|
Units Sold |
53 |
|||||
|
Ending Inventory Units |
0 |
|||||
|
Valuation |
||||||
|
Cost of Goods Sold |
25 |
$ 10.93 |
$ 273.33 |
|||
|
28 |
$ 14.27 |
$ 399.67 |
||||
|
B |
Total Cost of Goods Sold |
53 |
units |
$ 673.00 |
||
|
A-B |
Ending Inventory |
0 |
units |
$ 0 |
||
End of answer.
Thanks.