Accounting, Analysis, and Principles

Englehart Company sells two types of pumps. One is large and is for commercial use. The other is smaller and is used in residentialswimming pools. The following inventory data is available for the month of March.

Price per

Units Unit Total

Residential Pumps

Inventory at Feb. 28: 200 \( 400 \) 80,000

Purchases:

March 10 500 \( 450 \)225,000

March 20 400 \( 475 \)190,000

March 30 300 \( 500 \)150,000

Sales:

March 15 500 \( 540 \)270,000

March 25 400 \( 570 \)228,000

Inventory at March 31: 500

Commercial Pumps

Inventory at Feb. 28: 600 \( 800 \)480,000

Purchases:

March 3 600 \( 900 \)540,000

March 12 300 \( 950 \)285,000

March 21 500 \(1,000 \)500,000

Sales:

March 18 900 \(1,080 \)972,000

March 29 600 \(1,140 \)684,000

Inventory at March 31: 500

Accounting

(a) Assuming Englehart uses a periodic inventory system, determine the cost of inventory on hand at March 31 and thecost of goods sold for March under first-in, first-out (FIFO).

(b) Assume Englehart uses dollar-value LIFO and one pool, consisting of the combination of residential and commercialpumps. Determine the cost of inventory on hand at March 31 and the cost of goods sold for March. Assume Englehart’sinitial adoption of LIFO is on March 1. Use the double-extension method to determine the appropriate price indices.

(Hint:The price index for February 28/March 1 should be 1.00.) (Round the index to three decimal places.)

Analysis

(a) Assume you need to compute a current ratio for Englehart. Which inventory method (FIFO or dollar-value LIFO) doyou think would give you a more meaningful current ratio?

(b) Some of Englehart’s competitors use LIFO inventory costing and some use FIFO. How can an analyst compare theresults of companies in an industry, when some use LIFO and others use FIFO?

Principles

Can companies change from one inventory accounting method to another? If a company changes to an inventory accounting methodused by most of its competitors, what are the trade-offs in terms of the conceptual framework discussed in Chapter 2 of the textbook?

Short Answer

Expert verified

Under Periodic system

Ending inventory $745,000

COGS $1,705,000

Under dollar value LIFO

Ending inventory$745,200

COGS $1,704,800

The FIFO method is most preferred in analyzing financial performance, and there can be a change in the inventory method with a cost-benefit trade-off.

Step by step solution

01

Accounting

a. Ending Inventory and COGS using the periodic inventory

Under the periodic inventory system, the inventory received first is utilized first. Thus the ending inventory would always be valued at the cost of the earliest inventory received.

In this case,

The cost of ending inventory for Residential pumps are as follow –

Ending inventory = 500 units

Date

Units

Cost per unit

Amount

March 30

300

$500

$150,000

March 20

200

$475

$95,000

Total

$245,000

Costofgoodssold(forresedentialpumps)=Costofopeninginventory+Costofallpurchases-Costofendinginventory=$80,000+($225,000+$190,000+$150,000)-$245,000=$400,000

The cost of ending inventory for Commercial pumps is as follows–

Ending inventory = 500 units

Date

Units

Cost per unit

Amount

March 21

500

$1000

$500,000

Total

$500,000

Costofgoodssold(forcommercialpumps)=Costofopeninginventory+Costofallpurchases-Costofendinginventory=$480,000+($540,000+$285,000+$500,000)-$500,000=$1,305,000Totalcostofendinginventory=Costofendinginventoryofresedentialpumps+CostofendinginventoryofCommercialpumps=$245,000+$500,000=$745,000Totalcostofgoodssold=Costofgoodssoldforresedentialpumps+Costofgoodssoldforcommercialpumps=$400,000+$1,305,000=$1,705,000

Total ending inventory under the periodic method comes out to be $745,000, and the total cost of goods sold amounts to $1,705,000.

b) Ending Inventory and COGS using dollar-value LIFO under one pool

Under the dollar-value LIFO inventory system, the layers of inventory at base cost added every year are converted to current cost using the price index. The sum of all layers at the current cost is the cost of ending inventory.

In this case, the cost of ending inventory and COGS using one pool would be as follows –

Ending inventory

Date

Units

Current year cost

Amount

Base year cost

Amount

Residential pumps

March 30

300

$500

$150,000

$400

$120,000

March 20

200

$475

$95,000

$400

$80,000

Commercial pumps

March 21

500

$1000

$500,000

$800

$400,000

Total

$745,000

$600,000

PriceIndex=EndinginventorycostatcurrentyearpriceEndinginventorycostatbaseyearprice=$745,000$600,000=1.242

Valuation of ending inventory using dollar-value LIFO

Date

Inventory at base price

Layer

X

Price Index

=

Dollar Value LIFO

1 March

$560,000

$560,000

X

1.242

=

$695,520

31 March

$600,000

$40,000

X

1.242

=

$49,680

Total

$745,200

Costofgoodssold=Totalopeninginevntory+Totalpurchases-EndinginventoryusinfdollarvalueLIFO=($80,000+$480,000)+($225,000+$190,000+$150,000+$540,000+$285,000+$500,000)-$745,200=$560,000+$1,890,000-$745,200=$1,704,800

The cost of goods sold and ending inventory using dollar-value LIFO comes out to be $1,704,800 and $745,200, respectively.

02

Analysis

a) FIFO vs. dollar-value LIFO in computing current ratio

In computing, the current ratio, one of the factors affecting the ratio, is the ending inventory. There are several methods for computing ending inventory that yields different results.

Under the FIFO method, ending inventory is completed at the earliest cost, while under dollar value LIFO, ending inventory is computed at the current price using a price index. In both methods, there remains a difference in amount.

The ending inventory under both methods is almost the same in the given case. However, the FIFO method would be the most preferred method as this method is quite simple and reasonable in computing the ending inventory. Furthermore, the inventory is calculated at the original cost than at the price index value in this method.

So, the preferred method for computing the current ratio would be the FIFO method.

b) Comparing the results under FIFO and LIFO

Under FIFO and LIFO methods, ending inventory is computed at a different rate. So there remains a difference between the FIFO and LIFO methods. But this difference can be reconciled using the LIFO reverse account. LIFO reverse is the difference between the FIFO ending inventory and the LIFO ending inventory.

Using this account, an analyst can compare the results under both methods.

03

Principles

Yes, a company can change from one inventory method to another with the condition that there should be consistency for the long term. There should not be a frequent change in the inventory method, and there should be full disclosure about the change.

In changing the inventory method, the trade-off in terms of the conceptual framework can be matching principle and cost constrain. A company may lose or gain some inventory value by changing the method. This gain or loss must be matched with the current income, and the cost-benefit trade-off should be properly reported.

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

Presented below is information related to Kaisson Corporation for the last 3 years.

Quantities Base-Year Cost Current-Year Cost

in Ending

Item Inventories Unit Cost Amount Unit Cost Amount

December 31, 2016

A 9,000 \(2.00 \)18,000 \(2.20 \)19,800

B 6,000 3.00 18,000 3.55 21,300

C 4,000 5.00 20,000 5.40 21,600

Totals \(56,000 \)62,700

December 31, 2017

A 9,000 \(2.00 \)18,000 \(2.60 \)23,400

B 6,800 3.00 20,400 3.75 25,500

C 6,000 5.00 30,000 6.40 38,400

Totals \(68,400 \)87,300

December 31, 2018

A 8,000 \(2.00 \)16,000 \(2.70 \)21,600

B 8,000 3.00 24,000 4.00 32,000

C 6,000 5.00 30,000 6.20 37,200

Totals \(70,000 \)90,800

Instructions

Compute the ending inventories under the dollar-value LIFO method for 2016, 2017, and 2018. The base period is January 1, 2016,and the beginning inventory cost at that date was $45,000. Compute indexes to two decimal places.

Question:Johnny Football Shop began operations on January 2, 2017. The following stock record card for footballs was taken from the records at the end of the year.

Units Unit Invoice Gross Invoice

Date Voucher Terms Received Cost Amount

1/15 10624 Net 30 50 \(20 \)1,000

3/15 11437 1/5, net 30 65 16 1,040

6/20 21332 1/10, net 30 90 15 1,350

9/12 27644 1/10, net 30 84 12 1,008

11/24 31269 1/10, net 30 76 11 836

Totals 365 $5,234

A physical inventory on December 31, 2017, reveals that 100 footballs were in stock. The bookkeeper informs you that all thediscounts were taken. Assume that Johnny Football Shop uses the invoice price less discount for recording purchases.

Instructions

(a) Compute the December 31, 2017, inventory using the FIFO method.

(b) Compute the 2017 cost of goods sold using the LIFO method.

(c) What method would you recommend to the owner to minimize income taxes in 2017, using the inventory informationfor footballs as a guide?

You are asked to travel to Milwaukee to observe and verify the inventory of the Milwaukee branch of one of your clients. You arrive on Thursday, December 30, and find that the inventory procedures have justbeen started. You spot a railway car on the sidetrack at the unloading door and ask the warehouse superintendent, Buck Rogers,how he plans to inventory the contents of the car. He responds, “We are not going to include the contents in the inventory.”

Later in the day, you ask the bookkeeper for the invoice on the carload and the related freight bill. The invoice lists the variousitems, prices, and extensions of the goods in the car. You note that the carload was shipped December 24 from Albuquerque,f.o.b. Albuquerque, and that the total invoice price of the goods in the car was \(35,300. The freight bill called for a payment of\)1,500. Terms were net 30 days. The bookkeeper affirms the fact that this invoice is to be held for recording in January.

Instructions

(a) Does your client have a liability that should be recorded at December 31? Discuss.

(b) Prepare a journal entry(ies), if required, to reflect any accounting adjustment required. Assume a perpetual inventory

system is used by your client.

(c) For what possible reason(s) might your client wish to postpone recording the transaction?

The following independent situations relate to inventory accounting.

1. Kim Co. purchased goods with a list price of \(175,000, subject to trade discounts of 20% and 10%, with no cash discounts allowable. How much should Kim Co. record as the cost of these goods?

2. Keillor Company’s inventory of \)1,100,000 at December 31, 2017, was based on a physical count of goods priced at cost and before any year-end adjustments relating to the following items.

(a) Goods shipped from a vendor f.o.b. shipping point on December 24, 2017, at an invoice cost of \(69,000 to Keillor Company were received on January 4, 2018.

(b) The physical count included \)29,000 of goods billed to Sakic Corp. f.o.b. shipping point on December 31, 2017. The carrier picked up these goods on January 3, 2018.

What amount should Keillor report as inventory on its balance sheet?

3. Zimmerman Corp. had 1,500 units of part M.O. on hand May 1, 2017, costing \(21 each. Purchases of part M.O. during May were as follows.

Units Unit Cost

May 9 2,000 \)22.00

17 3,500 23.00

26 1,000 24.00

A physical count on May 31, 2017, shows 2,000 units of part M.O. on hand. Using the FIFO method, what is the cost of part M.O. inventory at May 31, 2017? Using the LIFO method, what is the inventory cost? Using the average-cost method, what is the inventory cost?

4. Ashbrook Company adopted the dollar-value LIFO method on January 1, 2017 (using internal price indexes and multiple pools). The following data are available for inventory pool A for the 2 years following adoption of LIFO.

At Base- At Current-

Inventory Year Cost Year Cost

1/1/17 \(200,000 \)200,000

12/31/17 240,000 264,000

12/31/18 256,000 286,720

Computing an internal price index and using the dollar-value LIFO method, at what amount should the inventory be reported at December 31, 2018?

5. Donovan Inc., a retail store chain, had the following information in its general ledger for the year 2018.

Merchandise purchased for resale $909,400

Interest on notes payable to vendors 8,700

Purchase returns 16,500

Freight-in 22,000

Freight-out (delivery expense) 17,100

Cash discounts on purchases 6,800

What is Donovan’s inventoriable cost for 2018?

Instructions

Answer each of the preceding questions about inventories, and explain your answers.

Question:Stallman Company took a physical inventory on December 31 and determined that goods costing \(200,000 were on hand. Not included in the physical count were \)25,000 of goods purchased from Pelzer Corporation, f.o.b. shipping point, and \(22,000 of goods sold to Alvarez Company for \)30,000, f.o.b. destination. Both the Pelzer purchase and the Alvarez sale werein transit at year-end. What amount should Stallman report as its December 31 inventory?

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