In: Accounting
Compute cost of goods sold, assuming Kingbird uses:
| 1.Perpetual system, FIFO cost flow |
2.Perpetual system, LIFO cost flow
3.
| Perpetual system, moving-average cost flow |
Kingbird Company is a multi product firm. Presented below is
information concerning one of its products, the Hawkeye.
|
Date |
Transaction |
Quantity |
Price/Cost |
|||
| 1/1 | Beginning inventory | 3,500 | $19 | |||
| 2/4 | Purchase | 4,500 | 28 | |||
| 2/20 | Sale | 5,000 | 47 | |||
| 4/2 | Purchase | 5,500 | 36 | |||
| 11/4 | Sale | 4,700 |
52 |
1
Perpetual system, FIFO cost flow =$253,700
Perpetual system, FIFO cost flow=$304,700
Perpetual system, moving-average cost flow=$279,726
Working notes for the above answer is as under
1
FIFO
|
Date |
Purchased |
Cost of goods sold |
Balance |
|||
|
1-Jan |
3500 @ $19 |
$66,500 |
3500 @ $19 |
$66,500 |
||
|
4-Feb |
4500 @ $28 |
$126,000 |
3500 @ $19 |
$192,500 |
||
|
4500 @28 |
||||||
|
20-Feb |
3500 @ $19 |
66,500 |
||||
|
1500 @ $28 |
42000 |
3000 @28 |
$84,000 |
|||
|
2-Apr |
5500 @ $36 |
$198,000 |
3000 @28 |
$84,000 |
||
|
5500 @36 |
$198,000 |
|||||
|
4-Nov |
3000 @ $28 |
84,000 |
||||
|
1700 @ $36 |
61,200 |
3800 @36 |
$136,800 |
|||
|
253,700 |
||||||
2
LIFO
|
Date |
Purchased |
Cost of goods sold |
Balance |
|||
|
31-Dec |
3500 @ $19 |
$66,500 |
3500 @ $19 |
$66,500 |
||
|
3-Feb |
4500 @ $28 |
$126,000 |
3500 @ $19 |
$192,500 |
||
|
4500 @28 |
||||||
|
19-Feb |
4500 @ $28 |
126,000 |
||||
|
500 @ $19 |
9500 |
3000 @19 |
$57,000 |
|||
|
1-Apr |
5500 @ $36 |
$198,000 |
3000 @19 |
$57,000 |
||
|
5500 @36 |
$198,000 |
|||||
|
3-Nov |
4700 @ $36 |
169,200 |
3000 @19 |
$57,000 |
||
|
800 @36 |
$28,800 |
|||||
|
304,700 |
||||||
3
Moving g average
|
Date |
Purchased |
Sold or Issued |
Balance |
|||
|
31-Dec |
3500 @ $19 |
$66,500 |
3500 @ $19 |
$66,500 |
||
|
3-Feb |
4500 @ $28 |
$126,000 |
3500 @ $19 |
$66,500 |
||
|
4500 @ $28 |
$126,000 |
|||||
|
8000 @24.0625 |
$192,500 |
|||||
|
19-Feb |
5000 @ $24.0625 |
$130,313 |
||||
|
3000 @ $24.0625 |
$72,188 |
|||||
|
1-Apr |
5500 @ $36 |
$198,000 |
3000 @ $24.0625 |
$72,188 |
||
|
5500 @ $36 |
$198,000 |
|||||
|
8500 @31.79 |
$270,188 |
|||||
|
3-Nov |
4700 @ $31.79 |
$149,413 |
||||
|
$279,726 |
3800 @ $31.79 |
$120,802 |
||||