Question

In: Accounting

Laker Company reported the following January purchases and sales data for its only product. Date Activities...

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


The Company uses a perpetual inventory system. 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.
Complete 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%. (Round your Intermediate calculations to 2 decimal places.)

LAKER COMPANY
Income Statements
For Month Ended January 31
Specific Weighted
Identification Average FIFO LIFO
Sales
Cost of goods sold
Gross profit
Expenses
Income before taxes
Income tax expense
Net income


3. Does net income using weighted average fall between that using FIFO and LIFO?2. Which method yields the highest net income?

4. If costs were rising instead of falling, which method would yield the highest net income?

Solutions

Expert Solution

Laker Company
Specific Identification Weighted - Average FIFO LIFO
(270 X $20) Sales $        5,400 $       5,400 $        5,400 $       5,400
Less: Cost of goods sold $        2,875 $       2,881 $        2,885 $       2,870
Gross profit $        2,525 $       2,519 $        2,515 $       2,530
Less: Expenses $        1,700 $       1,700 $        1,700 $       1,700
Income before taxes $            825 $           819 $           815 $           830
Less: Income tax expense @40% $            330 $           328 $           326 $           332
Net Income $            495 $           491 $           489 $           498
2 Specific Identification yeilds highest Net Income
3 Yes, Net Income from weighted average method falls between FIFO and LIFO
4 FIFO method will result in highest net income in case when inventory cost is rising
Workings:
1 Cost of goods available for sale Cost of goods sold Ending Inventory
Specific Identification # of units    (A) Cost per unit Cost of goods available for sale # of units sold               (B) Cost per unit Cost of goods sold # of units in ending inventory       Cost per unit Ending Inventory
Jan-01                185 $       11.00 $        2,035               175 $       11.00 $       1,925               10 $    11.00 $              110
Jan-20                100 $       10.00 $        1,000                 95 $       10.00 $           950                 5 $    10.00 $                50
Jan-30                270 $         9.50 $        2,565                  -   $         9.50 $              -              270 $       9.50 $          2,565
Total                555 $        5,600               270 $       2,875            285 $          2,725
2 Cost of goods available for sale Cost of goods sold Ending Inventory
Weighted - Average # of units    (A) Cost per unit Cost of goods available for sale # of units sold               (B) Cost per unit Cost of goods sold # of units in ending inventory       Cost per unit Ending Inventory
Jan-01            185 $    11.00 $          2,035
Jan-10               145 $       11.00 $       1,595               40 $    11.00 $              440
Jan-20                100 $       10.00 $        1,000               40 $    11.00 $              440
           100 $    10.00 $          1,000
           140 $    10.29              1,440
Jan-25               125 $       10.29 $       1,286               15 $    10.29 $              154
Jan-30                270 $         9.50 $        2,565               15 $    10.29 $              154
           270 $       9.50 $          2,565
Total                370 $        3,565               270 $       2,881            285 $       9.54 $          2,719
3 Cost of goods available for sale Cost of goods sold Ending Inventory
FIFO # of units    (A) Cost per unit Cost of goods available for sale # of units sold               (B) Cost per unit Cost of goods sold # of units in ending inventory       Cost per unit Ending Inventory
Jan-01            185 $    11.00 $          2,035
Jan-10               145 $       11.00 $       1,595               40 $    11.00 $              440
Jan-20                100 $       10.00 $        1,000               40 $    11.00 $              440
           100 $    10.00 $          1,000
Jan-25                 40 $       11.00 $           440               15 $    10.00 $              150
                85 $       10.00 $           850
Jan-30                270 $         9.50 $        2,565               15 $    10.00 $              150
           270 $       9.50 $          2,565
Total                370 $        3,565               270 $       2,885            285 $          2,715
4 Cost of goods available for sale Cost of goods sold Ending Inventory
LIFO # of units    (A) Cost per unit Cost of goods available for sale # of units sold               (B) Cost per unit Cost of goods sold # of units in ending inventory       Cost per unit Ending Inventory
Jan-01            185 $    11.00 $          2,035
Jan-10               145 $       11.00 $       1,595               40 $    11.00 $              440
Jan-20                100 $       10.00 $        1,000               40 $    11.00 $              440
           100 $    10.00 $          1,000
Jan-25               100 $       10.00 $       1,000               15 $    11.00 $              165
                25 $       11.00 $           275
Jan-30                270 $         9.50 $        2,565               15 $    11.00 $              165
           270 $       9.50 $          2,565
Total                370 $        3,565               270 $       2,870            285 $          2,730

Related Solutions

Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 @ $ 4.50 = 810 Totals 380 units $ 1,950 180 units The...
Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 180 units @ $ 10.50 = $ 1,890 Jan. 10 Sales 140 units @ $ 19.50 Jan. 20 Purchase 110 units @ $ 9.50 = 1,045 Jan. 25 Sales 130 units @ $ 19.50 Jan. 30 Purchase 270 units @ $ 9.00 = 2,430 Totals 560 units $ 5,365 270 units The...
Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 230 units @ $ 15.50 = $ 3,565 Jan. 10 Sales 180 units @ $ 24.50 Jan. 20 Purchase 190 units @ $ 14.50 = 2,755 Jan. 25 Sales 220 units @ $ 24.50 Jan. 30 Purchase 360 units @ $ 14.00 = 5,040 Totals 780 units $ 11,360 400 units The...
Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 The...
Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 215 units @ $ 14.00 = $ 3,010 Jan. 10 Sales 165 units @ $ 23.00 Jan. 20 Purchase 160 units @ $ 13.00 = 2,080 Jan. 25 Sales 190 units @ $ 23.00 Jan. 30 Purchase 330 units @ $ 12.50 = 4,125 Totals 705 units $ 9,215 355 units The...
Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 @ $ 4.50 = 810 Totals 380 units $ 1,950 180 units The...
Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 170 units @ $ 9.50 = $ 1,615 Jan. 10 Sales 130 units @ $ 18.50 Jan. 20 Purchase 120 units @ $ 8.50 = 1,020 Jan. 25 Sales 130 units @ $ 18.50 Jan. 30 Purchase 240 units @ $ 8.00 = 1,920 Totals 530 units $ 4,555 260 units The...
Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 rev:...
Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 145 units @ $7.00 = $ 1,015 Jan. 10 Sales 105 units @ $16.00 Jan. 20 Purchase 70 units @ $6.00 = 420 Jan. 25 Sales 85 units @ $16.00 Jan. 30 Purchase 190 units @ $5.50 = 1,045 Totals 405 units $ 2,480 190 units Required: The Company uses a perpetual...
Laker Company reported the following January purchases and sales data for its only product. Date Activities...
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 250 units @ $ 8.50 = 2,125 Totals 555 units $ 5,045 275 units The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT