Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Hemming Co. reported the following current-year purchases and sales for its only product.

Date

Activities

Units acquired at a cost

Units Sold to Retail

Jan 1

Beginning Inventory

200 units @ \(10 = \)2,000

Jan 10

Sales

150 units @ \(40

March 14

Purchase

350 units @ \)15= \(5,250

March 15

Sales

300 units @ \)40

July 30

Purchases

450 units @ \(20 = \)9,000

Oct 5

Sales

430 units @ \(40

Oct 26

Purchase

100 units @ \)25 = \(2,500

Total

1,100 units for \)18,750

880 units

Required

Hemming uses a perpetual inventory system. Determine the costs assigned to ending inventory and to cost of goods sold using (a) FIFO and (b) LIFO. Compute the gross margin for each method. (Round amounts to cents.)

Short Answer

Expert verified

Method

Ending Inventory

Gross Profit

FIFO

$4,900

$21,350

LIFO

$4,150

$20,600

Step by step solution

01

Definition of Gross Margin

The margin reflecting the money retained by the business entity after adjusting for all the expenses directly associated with the product is known as the gross margin.

02

FIFO Method

Calculation of Ending Inventory:

Particular
Beginning inventory/ PurchasesCost of goods soldEnding Inventory
Units
Cost per unit
Total cost
Units
Cost per unit
Total cost
Units
Cost per unit
Total cost

Jan 1

200

10

2,000

200

10

2,000

Jan 10

150

10

1,500

50

10

500

March 14

350

15

5,250

50

10

500

350

15

5,250

March 15

50

10

500

250

15

3,750

100

15

1,500

July 30

450

20

9,000

100

15

1,500

450

20

9,000

Oct 5

100

15

1,500

330

20

6,600

120

20

2,400

Oct 26

100

25

2,500

120

20

2,400

100

25

2,500

Total

13,850

4,900

Calculation of Gross profit

Particular

Amount $

Sales880×$40

$35,200

Less: Cost of goods sold

(13,850)

Gross profit

$21,350

03

LIFO Method

Calculation of Ending Inventory:


Particular
Beginning inventory/ PurchasesCost of goods soldEnding Inventory
Units
Cost per unit
Total cost
Units
Cost per unit
Total cost
Units
Cost per unit
Total cost

Jan 1

200

10

2,000

200

10

2,000

Jan 10

150

10

1,500

50

10

500

March 14

350

15

5,250

50

10

500

350

15

5,250

March 15

300

15

4,500

50

10

500

50

15

750

July 30

450

20

9,000

50

10

500

50

15

750

450

20

9,000

Oct 5

430

20

8,600

50

10

500

50

15

750

20

20

400

Oct 26

100

25

2,500

50

10

500

50

15

750

20

20

400

100

25

2,500

Total

$14,600

$4,150

Calculation of Gross profit

Particular

Amount $

Sales880×$40

$35,200

Less: Cost of goods sold

(14,600)

Gross profit

$20,600

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Aloha Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions. (For specific identification, the May 9 sale consisted of 80 units from beginning inventory and 100 units from the May 6 purchase; the May 30 sale consisted of 200 units from the May 6 purchase and 100 units from the May 25 purchase.)

Date

Activities

Units acquired at cost

Units sold at retail

May 1

Beginning inventory

150 units @ \(300.00 per unit

May 6

Purchase

350 units @ \)350.00 per unit

May 9

Sales

180 units @ \(1,200.00 per unit

May 17

Purchase

80 units @ \)450.00 per unit

May 25

Purchase

100 units @ \(458.00 per unit

May 30

Sales

300 units @ \)1,400.00 per unit

680 units

480 units

Required

Analysis Component

5. If the company’s manager earns a bonus based on a percent of gross profit, which method of inventory costing will the manager likely prefer?

Question: Comparative figures for Apple and Microsoft follow

\( million
Apple
Microsoft
Current year
One year Prior
Two years prior
Current year
One year Prior
Two years prior

Inventory

\)2,349

\(2,111

\)1,764

\(2,902

\)2,660

$1,938

Cost of Sales

140,089

112,258

106,606

33,038

27,078

20,385

Required

Comment on and interpret your findings from parts 1 and 2. Assume an industry average for inventory turnover of 15.

Cruz Company uses LIFO for inventory costing and reports the following financial data. It also recomputed inventory and cost of goods sold using FIFO for comparison purposes.

2017

2016

LIFO Inventory

\(160

\)110

LIFO Cost of goods sold

740

680

FIFO Inventory

240

110

FIFO Cost of goods sold

660

645

Current assets (Using LIFO)

220

180

Current liabilities

200

170

1. Compute its current ratio, inventory turnover, and days’ sales in inventory for 2017 using (a) LIFO numbers and (b) FIFO numbers. (Round answers to one decimal.)

Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions. (For specific identification, units sold consist of 600 units from beginning inventory, 300 from the February 10 purchase, 200 from the March 13 purchase, 50 from the August 21 purchase, and 250 from the September 5 purchase.)

Date

Activities

Units acquired at cost

Units sold at retail

Jan 1

Beginning inventory

600 units @ \(45.00 per unit

Feb 10

Purchases

400 units @ \)42.00 per unit

March 13

Purchases

200 units @ \(27.00 per unit

March 15

Sales

800 units @ \)75.00 per unit

Aug 21

Purchases

100 units @ \(50.00 per unit

Sep 5

Purchases

500 units @ \)46.00 per unit

Sep 10

Sales

600 units @ $75.00 per unit

Total

1,800 units

1,400 units

Required

Compute gross profit earned by the company for each of the four costing methods in part 3.

BTN 5-7 Review the chapter’s opening feature highlighting Brad Gillis and Ben Friedman and their company, Homegrown Sustainable Sandwich Shop. Assume that Homegrown consistently maintains an inventory level of \(30,000, meaning that its average and ending inventory levels are the same. Also assume its annual cost of sales is \)120,000. To cut costs, Brad and Ben propose to slash inventory to a constant level of $15,000 with no impact on cost of sales. They plan to work with suppliers to get quicker deliveries and to order smaller quantities more often.

Required

Evaluate and comment on the merits of their proposal given your analysis for part 1. Identify any concerns you might have about the proposal.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free