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.