In: Accounting
Carlson Auto Dealers Inc. sells a handmade automobile as its
only product. Each automobile is identical; however, they can be
distinguished by their unique ID number. At the beginning of 2021,
Carlson had three cars in inventory, as follows:
| Car ID | Cost | ||
| 203 | $ | 69,000 | |
| 207 | 69,000 | ||
| 210 | 72,000 | ||
During 2021, each of the three autos sold for $99,000. Additional
purchases (listed in chronological order) and sales for the year
were as follows:
| Car ID | Cost | Selling Price | ||||
| 211 | $ | 69,000 | $ | 99,000 | ||
| 212 | 69,000 | 102,000 | ||||
| 213 | 70,500 | not sold | ||||
| 214 | 72,000 | 105,000 | ||||
| 215 | 75,000 | 109,500 | ||||
| 216 | 73,500 | not sold | ||||
| 217 | 78,000 | 114,000 | ||||
| 218 | 75,300 | 115,500 | ||||
| 219 | 81,000 | not sold | ||||
2. Calculate ending inventory and cost of goods sold assuming FIFO and a periodic inventory system.
Correct Answer:
|
FIFO |
|
|
Cost of Goods Sold |
$ 6,39,000 |
|
Cost of Ending Inventory |
$ 2,25,300 |
Working:
|
Cost of Goods Available for sale |
||||
|
Units |
Cost per unit |
value |
||
|
203 |
Beginning Inventory |
1 |
$ 69,000 |
$ 69,000 |
|
207 |
Beginning Inventory |
1 |
$ 69,000 |
$ 69,000 |
|
210 |
Beginning Inventory |
1 |
$ 72,000 |
$ 72,000 |
|
211 |
Purchases |
1 |
$ 69,000 |
$ 69,000 |
|
212 |
Purchases |
1 |
$ 69,000 |
$ 69,000 |
|
213 |
Purchases |
1 |
$ 70,500 |
$ 70,500 |
|
214 |
Purchases |
1 |
$ 72,000 |
$ 72,000 |
|
215 |
Purchases |
1 |
$ 75,000 |
$ 75,000 |
|
216 |
Purchases |
1 |
$ 73,500 |
$ 73,500 |
|
217 |
Purchases |
1 |
$ 78,000 |
$ 69,000 |
|
218 |
Purchases |
1 |
$ 75,300 |
$ 75,300 |
|
219 |
Purchases |
1 |
$ 81,000 |
$ 81,000 |
|
$ - |
||||
|
Total |
12 |
$ 8,64,300.0 |
||
|
FIFO |
|||||||
|
A |
Total Units Available for sale |
12 |
$ 8,64,300 |
||||
|
Units Sold |
9 |
||||||
|
Ending Inventory Units |
3 |
||||||
|
Valuation |
|||||||
|
Cost of Goods Sold |
203 |
1 |
$ 69,000.00 |
$ 69,000 |
|||
|
207 |
1 |
$ 69,000.00 |
$ 69,000 |
||||
|
210 |
1 |
$ 72,000.00 |
$ 72,000 |
||||
|
211 |
1 |
$ 69,000.00 |
$ 69,000 |
||||
|
212 |
1 |
$ 69,000.00 |
$ 69,000 |
||||
|
213 |
1 |
$ 70,500.00 |
$ 70,500 |
||||
|
214 |
1 |
$ 72,000.00 |
$ 72,000 |
||||
|
215 |
1 |
$ 75,000.00 |
$ 75,000 |
||||
|
216 |
1 |
$ 73,500.00 |
$ 73,500 |
||||
|
B |
Cost of Goods Sold |
9 |
units |
$ 6,39,000 |
|||
|
A-B |
Ending Inventory |
3 |
units |
$ 2,25,300 |
|||
End of Answer.
Thanks