Question

In: Accounting

Required information [The following information applies to the questions displayed below.]    Laker Company reported the...

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 185 units @ $ 11.00 = $ 2,035
Jan. 10 Sales 145 units @ $ 20.00
Jan. 20 Purchase 100 units @ $ 10.00 = 1,000
Jan. 25 Sales 125 units @ $ 20.00
Jan. 30 Purchase 270 units @ $ 9.50 = 2,565
Totals 555 units $ 5,600 270 units

For specific identification, ending inventory consists of 285 units, where 270 are from the January 30 purchase, 5 are from the January 20 purchase, and 10 are from beginning inventory.

Required:

1. Prepare comparative income statements for the month of January for Laker Company for the four inventory methods. Assume expenses are $1,700, and that the applicable income tax rate is 40%.

Solutions

Expert Solution

Income Statement
FIFO LIFO W. Avg SP. ID
Sales Revenue $             5,400 $                5,400 $          5,400 $          5,400
Cost of Goods Sold $             2,885 $                2,870 $          2,881 $          2,875
Gross Margin $             2,515 $                2,530 $          2,519 $          2,525
Expenses $             1,700 $                1,700 $          1,700 $          1,700
Income before income tax $                 815 $                   830 $             819 $             825
Income tax expense $                 326 $                   332 $             328 $             330
Net Income $                 489 $                   498 $             492 $             495

Working

FIFO Cost of Goods Available for sale Cost of Goods Sold Ending Balance
Date Activity Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount
Jan-01 Beginning Inventory 185 $               11.00 $          2,035 185 $           11.00 $       2,035
Jan-10 Sales 145 $            11.00 $       1,595 40 $           11.00 $          440
Jan-20 Purchase 100 $               10.00 $          1,000 40 $           11.00 $          440
100 $           10.00 $       1,000
Jan-25 Sales 40 $            11.00 $          440
85 $            10.00 $          850 15 $           10.00 $          150
Jan-30 Purchase 270 $                  9.50 $          2,565 15 $           10.00 $          150
270 $             9.50 $       2,565
Total 555 $          5,600 125 $      2,885 285 $      2,715
LIFO Cost of Goods Available for sale Cost of Goods Sold Ending Balance
Date Activity Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount
Jan-01 Beginning Inventory 185 $               11.00 $          2,035 185 $           11.00 $       2,035
Jan-10 Sales 145 $            11.00 $       1,595 40 $           11.00 $          440
Jan-20 Purchase 100 $               10.00 $          1,000 40 $           11.00 $          440
100 $           10.00 $       1,000
Jan-25 Sales 100 $            10.00 $       1,000 15 $           11.00 $          165
25 $            11.00 $          275
Jan-30 Purchase 270 $                  9.50 $          2,565 15 $           11.00 $          165
270 $             9.50 $       2,565
Total 555 $          5,600 125 $      2,870 285 $      2,730
W. Avg Cost of Goods Available for sale Cost of Goods Sold Ending Balance
Date Activity Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount
Jan-01 Beginning Inventory 185 $               11.00 $          2,035 185 $           11.00 $       2,035
Jan-10 Sales 145 $            11.00 $       1,595 40 $           11.00 $          440
Jan-20 Purchase 100 $               10.00 $          1,000 140 $           10.29 $       1,440
Jan-25 Sales 125 $            10.29 $       1,286 15 $           10.29 $          154
Jan-30 Purchase 270 $                  9.50 $          2,565 285 $             9.54 $       2,719
Total 555 $          5,600 125 $      2,881 285 $      2,719
Sp. ID Cost of Goods Available for sale Cost of Goods Sold Ending Balance
Date Activity Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount
Jan-01 Beginning Inventory 185 $               11.00 $          2,035 185 $           11.00 $       2,035
Jan-10 Sales 145 $            11.00 $       1,595 40 $           11.00 $          440
Jan-20 Purchase 100 $               10.00 $          1,000 40 $           11.00 $          440
100 $           10.00 $       1,000
Jan-25 Sales 30 $            11.00 $          330 10 $           11.00 $          110
95 $            10.00 $          950 5 $           10.00 $            50
Jan-30 Purchase 270 $                  9.50 $          2,565 10 $           11.00 $          110
5 $           10.00 $            50
270 $             9.50 $       2,565
Total 555 $          5,600 125 $      2,875 285 $      2,725

Related Solutions

Required information [The following information applies to the questions displayed below.]    Laker Company reported the...
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 235 units @ $ 16.00 = $ 3,760 Jan. 10 Sales 200 units @ $ 25.00 Jan. 20 Purchase 180 units @ $ 15.00 = 2,700 Jan. 25 Sales 190 units @ $ 25.00 Jan. 30 Purchase 390 units...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the...
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 175 units @ $ 10.00 = $ 1,750 Jan. 10 Sales 135 units @ $ 19.00 Jan. 20 Purchase 130 units @ $ 9.00 = 1,170 Jan. 25 Sales 140 units @ $ 19.00 Jan. 30 Purchase 275 units...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the...
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 210 units @ $ 13.50 = $ 2,835 Jan. 10 Sales 160 units @ $ 22.50 Jan. 20 Purchase 150 units @ $ 12.50 = 1,875 Jan. 25 Sales 160 units @ $ 22.50 Jan. 30 Purchase 320 units...
Required information [The following information applies to the questions displayed below.] Laker Company reported the following...
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 160 units @ $ 8.50 = $ 1,360 Jan. 10 Sales 120 units @ $ 17.50 Jan. 20 Purchase 100 units @ $ 7.50 = 750 Jan. 25 Sales 120 units @ $ 17.50 Jan. 30 Purchase 220 units @ $...
Required information [The following information applies to the questions displayed below.] Laker Company reported the following...
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 150 units @ $ 7.50 = $ 1,125 Jan. 10 Sales 110 units @ $ 16.50 Jan. 20 Purchase 80 units @ $ 6.50 = 520 Jan. 25 Sales 90 units @ $ 16.50 Jan. 30 Purchase 200 units @ $...
Required information [The following information applies to the questions displayed below.] Laker Company reported the following...
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 160 units @ $ 8.50 = $ 1,360 Jan. 10 Sales 120 units @ $ 17.50 Jan. 20 Purchase 100 units @ $ 7.50 = 750 Jan. 25 Sales 120 units @ $ 17.50 Jan. 30 Purchase 220 units @ $...
Required information [The following information applies to the questions displayed below.] Laker Company reported the following...
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 195 units @ $ 12.00 = $ 2,340 Jan. 10 Sales 155 units @ $ 21.00 Jan. 20 Purchase 120 units @ $ 11.00 = 1,320 Jan. 25 Sales 135 units @ $ 21.00 Jan. 30 Purchase 290 units @ $...
Required information [The following information applies to the questions displayed below.] Laker Company reported the following...
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 160 units @ $ 8.50 = $ 1,360 Jan. 10 Sales 120 units @ $ 17.50 Jan. 20 Purchase 100 units @ $ 7.50 = 750 Jan. 25 Sales 120 units @ $ 17.50 Jan. 30 Purchase 220 units @ $...
Required information [The following information applies to the questions displayed below.] Laker Company reported the following...
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 @ $...
Required information [The following information applies to the questions displayed below.] Laker Company reported the following...
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 140 units @ $ 6.00 = $ 840 Jan. 10 Sales 100 units @ $ 15 Jan. 20 Purchase 60 units @ $ 5.00 = 300 Jan. 25 Sales 80 units @ $ 15 Jan. 30 Purchase 180 units @ $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT