Question

In: Accounting

Required information [The following information applies to the questions displayed below.]    Hemming Co. reported the...

Required information

[The following information applies to the questions displayed below.]
  
Hemming Co. reported the following current-year purchases and sales for its only product.
    

Date

Activities

Units Acquired at Cost

Units Sold at Retail

Jan.

1

Beginning inventory

220

units

@ $10.80

=

$

2,376

Jan.

10

Sales

190

units

@ $40.80

Mar.

14

Purchase

330

units

@ $15.80

=

5,214

Mar.

15

Sales

280

units

@ $40.80

July

30

Purchase

420

units

@ $20.80

=

8,736

Oct.

5

Sales

390

units

@ $40.80

Oct.

26

Purchase

120

units

@ $25.80

=

3,096

Totals

1,090

units

$

19,422

860

units

Required:
Hemming uses a perpetual inventory system.
  
1. Determine the costs assigned to ending inventory and to cost of goods sold using FIFO.
2. Determine the costs assigned to ending inventory and to cost of goods sold using LIFO.
3. Compute the gross margin for FIFO method and LIFO method.

Perpetual 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

January 1

220

@

$10.80

=

$2,376.00

January 10

March 14

March 15

July 30

October 5

October 26

Totals

·                Required 1

·               

FIFO:

LIFO:

Sales revenue

Less: Cost of goods sold

Gross margin

·      

Solutions

Expert Solution

Part (1) Perpetual FIFO
Goods purchased Cost of goods sold Inventory balance
Date # of units Cost per unit # of units Cost per unit Cost of goods sold # of units Cost per unit Inventory balance
Jan 1           220                10.8                      2,376
Jan 10      190.00                10.8                         2,052             30                10.8                         324
Mar 14           330                15.8             30                10.8                         324
          330                15.8                      5,214
Mar 15             30                10.8                            324
          250                15.8                         3,950             80                15.8                      1,264
July 30           420                20.8             80                15.8                      1,479
          420                20.8                      8,736
Oct 5             80                15.8                         1,264
          310                20.8                         6,448           110                20.8                      2,288
Oct 26           120                25.8           110                20.8                      2,288
          120                25.8                      3,096
          870           860                       14,038           230                      5,384
Part (2) Perpetual LIFO
Goods purchased Cost of goods sold Inventory balance
Date # of units Cost per unit # of units Cost per unit Cost of goods sold # of units Cost per unit Inventory balance
Jan 1           220                10.8                      2,376
Jan 10           120                25.8                         3,096           220                10.8                      2,376
            70                20.8                         1,456
Mar 14           330                15.8           220                10.8                      2,376
          330                15.8                      5,214
Mar 15           280                20.8                         5,824           220                10.8                      2,376
          330                15.8                      5,214
July 30           420                20.8           220                10.8                      2,376
          330                15.8                      5,214
            70                20.8                      1,456
Oct 5             70                20.8                         1,456           220                10.8                      2,376
          320                15.8                         5,056             10                15.8                         158
Oct 26           120                25.8           220                10.8                      2,376
            10                15.8                         158
          870           860                       16,888           230                      2,534
Part (3) FIFO   LIFO
Sales      35,088            35,088
Less : Cost of goods sold      14,038            16,888
Gross margin      21,050            18,200
Sales = (190*40.8)+(280*40.8)+(390*40.8) = 35,088

Related Solutions

Required information [The following information applies to the questions displayed below.]    Hemming Co. reported the...
Required information [The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year purchases and sales for its only product.      Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 215 units @ $10.60 = $ 2,279 Jan. 10 Sales 180 units @ $40.60 Mar. 14 Purchase 320 units @ $15.60 = 4,992 Mar. 15 Sales 260 units @ $40.60 July 30 Purchase 415 units @ $20.60 = 8,549 Oct....
Required information [The following information applies to the questions displayed below.]    Hemming Co. reported the...
Required information [The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year purchases and sales for its only product.      Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 260 units @ $12.40 = $ 3,224 Jan. 10 Sales 215 units @ $42.40 Mar. 14 Purchase 420 units @ $17.40 = 7,308 Mar. 15 Sales 380 units @ $42.40 July 30 Purchase 460 units @ $22.40 = 10,304 Oct....
Required information [The following information applies to the questions displayed below.]    Hemming Co. reported the...
Required information [The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year purchases and sales for its only product.      Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 230 units @ $11.20 = $ 2,576 Jan. 10 Sales 160 units @ $41.20 Mar. 14 Purchase 350 units @ $16.20 = 5,670 Mar. 15 Sales 320 units @ $41.20 July 30 Purchase 430 units @ $21.20 = 9,116 Oct....
[The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year...
[The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year purchases and sales for its only product.      Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 290 units @ $13.60 = $ 3,944 Jan. 10 Sales 260 units @ $43.60 Mar. 14 Purchase 500 units @ $18.60 = 9,300 Mar. 15 Sales 430 units @ $43.60 July 30 Purchase 490 units @ $23.60 = 11,564 Oct. 5 Sales...
[The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year...
[The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year purchases and sales for its only product.      Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 200 units @ $10 = $ 2,000 Jan. 10 Sales 150 units @ $40 Mar. 14 Purchase 350 units @ $15 = 5,250 Mar. 15 Sales 300 units @ $40 July 30 Purchase 450 units @ $20 = 9,000 Oct. 5 Sales...
[The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year...
[The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year purchases and sales for its only product.      Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 200 units @ $10 = $ 2,000 Jan. 10 Sales 150 units @ $40 Mar. 14 Purchase 350 units @ $15 = 5,250 Mar. 15 Sales 300 units @ $40 July 30 Purchase 450 units @ $20 = 9,000 Oct. 5 Sales...
The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year...
The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year purchases and sales for its only product.      Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 275 units @ $13.00 = $ 3,575 Jan. 10 Sales 230 units @ $43.00 Mar. 14 Purchase 450 units @ $18.00 = 8,100 Mar. 15 Sales 400 units @ $43.00 July 30 Purchase 475 units @ $23.00 = 10,925 Oct. 5 Sales...
Required information [The following information applies to the questions displayed below.] The following information was reported...
Required information [The following information applies to the questions displayed below.] The following information was reported in the December 31, 2017, financial statements of National Airways, Inc. (listed alphabetically, amounts in millions). Accounts Payable $ 4,125 Accounts Receivable 710 Aircraft Fuel Expense 10,000 Cash 3,100 Common Stock 1,285 Dividends 20 Equipment 15,930 Income Tax Expense 320 Interest Expense 260 Landing Fees Expense 4,400 Notes Payable 7,015 Repairs and Maintenance Expense 2,500 Retained Earnings (as of December 31, 2017) 8,060 Salaries...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT