Step 2 Solution Part a. Inventory Valuation (FIFO) Date Purchase Cost of goods sold Balance May Units Unit cost Total cost Units Unit cost Total cost Units Unit cost Total cost 1 100 $4 $400 6 810 $4.40 $3,564 100 810 $4 $4.40 $400 $3,564 7 100 250 $4 $4.40 $400 $1,100 560 $4.40 $2,464 10 350 $4.40 $1,540 210 $4.40 $924 12 450 $5 $2,250 210 450 $4.40 $5 $924 $2,250 15 210 40 $4.40 $5 $924 $200 410 $5 $2,050 18 340 $4.80 $1,632 410 340 $5 $4.80 $2,050 $1,632 22 410 40 $5 $4.80 $2,050 $192 300 $4.80 $1,440 25 510 $4.60 $2,346 300 510 $4.80 $4.60 $1,440 $2,346 30 250 $4.80 $1,200 50 510 $4.80 $4.60 $240 $1,200 Ending Inventory Using FIFO = $240 + 1,200 = $1,440 CAN YOU CROSS CHECK or WHY NOT LIKE THIS ENDING INVENTORY = (50 units@ $4.80) +(510@ $4.60)=2586
Part a.
Date |
Purchase |
|
|
Cost of goods sold |
|
|
Balance |
|
|
May |
Units |
Unit cost |
Total cost |
Units |
Unit cost |
Total cost |
Units |
Unit cost |
Total cost |
1 |
|
|
|
|
|
|
100 |
$4 |
$400 |
6 |
810 |
$4.40 |
$3,564 |
|
|
|
100 810 |
$4 $4.40 |
$400 $3,564 |
7 |
|
|
|
100 250 |
$4 $4.40 |
$400 $1,100 |
560 |
$4.40 |
$2,464 |
10 |
|
|
|
350 |
$4.40 |
$1,540 |
210 |
$4.40 |
$924 |
12 |
450 |
$5 |
$2,250 |
|
|
|
210 450 |
$4.40 $5 |
$924 $2,250 |
15 |
|
|
|
210 40 |
$4.40 $5 |
$924 $200 |
410 |
$5 |
$2,050 |
18 |
340 |
$4.80 |
$1,632 |
|
|
|
410 340 |
$5 $4.80 |
$2,050 $1,632 |
22 |
|
|
|
410 40 |
$5 $4.80 |
$2,050 $192 |
300 |
$4.80 |
$1,440 |
25 |
510 |
$4.60 |
$2,346 |
|
|
|
300 510 |
$4.80 $4.60 |
$1,440 $2,346 |
30 |
|
|
|
250 |
$4.80 |
$1,200 |
50 510 |
$4.80 $4.60 |
$240 $1,200 |
Ending Inventory Using FIFO = $240 + 1,200 = $1,440
CAN YOU CROSS CHECK or WHY NOT LIKE THIS
ENDING INVENTORY = (50 units@ $4.80) +(510@ $4.60)=2586
Step by step
Solved in 2 steps