In: Accounting
Required information
[The following information applies to the questions
displayed below.]
Laker Company reported the following January purchases and sales data for its only product.
|
Date |
Activities |
Units Acquired at Cost |
Units sold at Retail |
|||||||||||||||
|
Jan. |
1 |
Beginning inventory |
240 |
units |
@ |
$ |
16.50 |
= |
$ |
3,960 |
||||||||
|
Jan. |
10 |
Sales |
190 |
units |
@ |
$ |
25.50 |
|||||||||||
|
Jan. |
20 |
Purchase |
170 |
units |
@ |
$ |
15.50 |
= |
2,635 |
|||||||||
|
Jan. |
25 |
Sales |
190 |
units |
@ |
$ |
25.50 |
|||||||||||
|
Jan. |
30 |
Purchase |
380 |
units |
@ |
$ |
15.00 |
= |
5,700 |
|||||||||
|
Totals |
790 |
units |
$ |
12,295 |
380 |
units |
||||||||||||
The Company uses a perpetual inventory system. For specific
identification, ending inventory consists of 410 units, where 380
are from the January 30 purchase, 5 are from the January 20
purchase, and 25 are from beginning inventory.
3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO.
|
GOODS PURCHASED |
COST OF GOODS SOLD |
INVENTORY BALANCE |
||||||
|
DATE |
# OF UNITS |
COST PER UNIT |
# OF UNITS SOLD |
COST PER UNIT |
COST OF GOODS SOLD |
# OF UNITS |
COST PER UNIT |
INVENTORY BALANCE |
|
JAN 1 |
240 @ |
$16.50 = |
$3960.00 |
|||||
|
JAN 10 |
||||||||
|
JAN 20 |
||||||||
|
JAN 25 |
||||||||
|
JAN 30 |
||||||||
|
TOTALS |
||||||||
| GOODS PURCHASED | COST OF GOODS SOLD | INVENTORY BALANCE | ||||||
| DATE | # OF UNITS | COST PER UNIT | # OF UNITS SOLD | COST PER UNIT | COST OF GOODS SOLD | # OF UNITS | COST PER UNIT | INVENTORY BALANCE |
| Jan-01 | 240 @ | $16.50 = | $3960.00 | |||||
| Jan-10 | 190 | $ 16.50 | $ 3,135.00 | 50@ | $ 16.50= | $ 825.00 | ||
| Jan-20 | 170 | $ 15.50 | 50@ | $ 16.50= | $ 825.00 | |||
| 170@ | $ 15.50= | $ 2,635.00 | ||||||
| 220 | $ 3,460.00 | |||||||
| Jan-25 | 50 | $ 16.50 | $ 825.00 | |||||
| 140 | $ 15.50 | $ 2,170.00 | 30@ | $ 15.50= | $ 465.00 | |||
| Jan-30 | 380 | $ 15.00 | 30@ | $ 15.50= | $ 465.00 | |||
| 380@ | $ 15.00= | $ 5,700.00 | ||||||
| TOTALS | 380 | 6130 | 410 | $ 6,165.00 | ||||