Exercise 4

study objectives

After studying this chapter, you should be able to:

1 Describe the steps in determining inventory quantities.

2 Explain the basis of accounting for inventories and apply the inventory cost flow methods under a periodic inventory system.

3 Explain the financial statement and tax effects of each of the inventory cost flow assumptions.

4 Explain the lower-of-cost-or-market basis of accounting for inventories.

5 Compute and interpret the inventory turnover ratio.

6 Describe the LIFO reserve and explain its importance for comparing results of different companies.

chapter

REPORTING AND ANALYZING INVENTORY

6

280

● Scan Study Objectives

● Read Feature Story

● Scan Preview

● Read Text and Answer p. 285 p. 291 p. 296 p. 298

● Work Using the Decision Toolkit

● Review Summary of Study Objectives

● Work Comprehensive p. 308

● Answer Self-Test Questions

● Complete Assignments

● Go to WileyPLUS for practice and tutorials

● Read A Look at IFRS p. 330

● the navigator

Do it!

Do it!

✓

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:23 PM Page 280

feature story

281

Let’s talk inventory—big, bulldozer-size inventory.

Caterpillar Inc. is the world’s largest manufacturer of

construction and mining equipment, diesel and natu-

ral gas engines, and industrial gas turbines. It sells its

products in over 200 countries, making it one of the

most successful U.S. exporters. More than 70% of its

productive assets are located domestically, and nearly

50% of its sales are foreign.

During the 1980s, Caterpillar’s

profitability suffered, but today it is

very successful. A big part of this

turnaround can be attributed to ef-

fective management of its inventory.

Imagine what a bulldozer costs. Now imagine what it

costs Caterpillar to have too many bulldozers sitting

around in inventory—a situation the company definitely

wants to avoid. Conversely, Caterpillar must make sure

it has enough inventory to meet demand.

At one time during a 7-year period, Caterpillar’s

sales increased by 100%, while its inventory increased

by only 50%. To achieve this dramatic reduction in the

amount of resources tied up in inventory, while contin-

uing to meet customers’ needs, Caterpillar used a

two-pronged approach. First, it completed a factory

modernization program, which dramatically increased

its production efficiency. The program reduced by

60% the amount of inventory the company processed

● A Big Hiccup (p. 283) ● Falsifying Inventory to Boost Income (p. 284) ● Is LIFO Fair? (p. 294) ● Improving Inventory Control with RFID (p. 298)

INSIDE CHAPTER 6 . . .

at any one time. It also reduced by

an incredible 75% the time it takes

to manufacture a part.

Second, Caterpillar dramatically improved its parts

distribution system. It ships more than 100,000 items

daily from its 23 distribution centers strategically lo-

cated around the world (10 million square feet of ware-

house space—remember, we’re talk-

ing bulldozers). The company can

virtually guarantee that it can get any

part to anywhere in the world within

24 hours.

After these changes, Cater-

pillar had record exports, profits, and revenues. It

would have seemed that things couldn’t have been

better. But industry analysts, as well as the com-

pany’s managers, thought otherwise. In order to

maintain Caterpillar’s position as the industry

leader, management began another major overhaul

of inventory production and inventory management

processes. The goal: to cut the number of repairs in

half, increase productivity by 20%, and increase

inventory turnover by 40%. In short, Caterpillar’s

ability to manage its inventory has been a key rea-

son for its past success, and inventory management

will very likely play a huge part in its ability to suc-

ceed in the future.

“W H E R E I S THAT S PAR E B U L LDOZ E R

B LAD E?”

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:23 PM Page 281

Helpful Hint Regardless of the classification, companies report all inventories under Current Assets on the balance sheet.

Reporting and Analyzing Inventory

In the previous chapter, we discussed the accounting for merchandise inventory using a perpetual inventory sys- tem. In this chapter, we explain the methods used to calculate the cost of inventory on hand at the balance sheet date and the cost of goods sold. We conclude by illustrating methods for analyzing inventory.

The content and organization of this chapter are as follows.

Classifying Inventory How a company classifies its inventory depends on whether the firm is a mer- chandiser or a manufacturer. In a merchandising company, such as those de- scribed in Chapter 5, inventory consists of many different items. For example, in a grocery store, canned goods, dairy products, meats, and produce are just a few of the inventory items on hand. These items have two common character- istics: (1) They are owned by the company, and (2) they are in a form ready for sale to customers in the ordinary course of business. Thus, merchandisers need only one inventory classification, merchandise inventory, to describe the many different items that make up the total inventory.

In a manufacturing company, some inventory may not yet be ready for sale. As a result, manufacturers usually classify inventory into three categories: fin- ished goods, work in process, and raw materials. Finished goods inventory is manufactured items that are completed and ready for sale. Work in process is that portion of manufactured inventory that has begun the production process but is not yet complete. Raw materials are the basic goods that will be used in production but have not yet been placed into production.

For example, Caterpillar classifies earth-moving tractors completed and ready for sale as finished goods. It classifies the tractors on the assembly line in various stages of production as work in process. The steel, glass, tires, and other components that are on hand waiting to be used in the production of trac- tors are identified as raw materials.

The accounting concepts discussed in this chapter apply to the inventory classifications of both merchandising and manufacturing companies. Our focus throughout most of this chapter is on merchandise inventory.

By observing the levels and changes in the levels of these three inven- tory types, financial statement users can gain insight into management’s production plans. For example, low levels of raw materials and high levels of finished goods suggest that management believes it has enough inventory on hand, and production will be slowing down—perhaps in anticipation of a reces- sion. On the other hand, high levels of raw materials and low levels of finished goods probably indicate that management is planning to step up production.

preview of chapter 6

• Merchandising • Manufacturing • Just-in-time

Classifying Inventory

• Taking a physical inventory • Determining ownership of

goods

Determining Inventory Quantities

• Specific identification • Cost flow assumptions • Financial statement and tax

effects • Consistent use • Lower-of-cost-or-market

Inventory Costing

• Inventory turnover ratio • LIFO reserve

Analysis of Inventory

282

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 282

Many companies have significantly lowered inventory levels and costs using just-in-time (JIT) inventory methods. Under a just-in-time method, companies manufacture or purchase goods just in time for use. Dell is famous for having developed a system for making computers in response to individual customer requests. Even though it makes computers to meet a customer’s particular spec- ifications, Dell is able to assemble the computer and put it on a truck in less than 48 hours. The success of a JIT system depends on reliable suppliers. By in- tegrating its information systems with those of its suppliers, Dell reduced its in- ventories to nearly zero. This is a huge advantage in an industry where products become obsolete nearly overnight.

Determining Inventory Quantities No matter whether they are using a periodic or perpetual inventory system, all companies need to determine inventory quantities at the end of the accounting period. If using a perpetual system, companies take a physical inventory for two purposes: The first purpose is to check the accuracy of their perpetual inventory records. The second is to determine the amount of inventory lost due to wasted raw materials, shoplifting, or employee theft.

Companies using a periodic inventory system must take a physical inventory for two different purposes: to determine the inventory on hand at the balance sheet date, and to determine the cost of goods sold for the period.

Determining inventory quantities involves two steps: (1) taking a physical in- ventory of goods on hand and (2) determining the ownership of goods.

TAKING A PHYSICAL INVENTORY

Companies take the physical inventory at the end of the accounting period. Tak- ing a physical inventory involves actually counting, weighing, or measuring each kind of inventory on hand. In many companies, taking an inventory is a formi- dable task. Retailers such as Target, True Value Hardware, or Home Depot have thousands of different inventory items. An inventory count is generally more ac- curate when a limited number of goods are being sold or received during the counting. Consequently, companies often “take inventory” when the business is closed or when business is slow. Many retailers close early on a chosen day in January—after the holiday sales and returns, when inventories are at their low- est level—to count inventory. Recall from Chapter 5 that Wal-Mart had a year- end of January 31.

Determining Inventory Quantities 283

A Big Hiccup

JIT can save a company a lot of money, but it isn’t without risk. An unex- pected disruption in the supply chain can cost a company a lot of money. Japanese au- tomakers experienced just such a disruption when a 6.8-magnitude earthquake caused major damage to the company that produces 50% of their piston rings. The rings them- selves cost only $1.50, but without them you cannot make a car. No other supplier could quickly begin producing sufficient quantities of the rings to match the desired specifi- cations. As a result, the automakers were forced to shut down production for a few days—a loss of tens of thousands of cars.

Source: Amy Chozick, “A Key Strategy of Japan’s Car Makers Backfires,” Wall Street Journal (July 20, 2007).

Accounting Across the Organization

?What steps might the companies take to avoid such a serious disruption in the future?(See page 330.)

1 Describe the steps in determining inventory quantities.

Ethics Note In a famous fraud, a salad oil company filled its storage tanks mostly with water. The oil rose to the top, so auditors thought the tanks were full of oil. The company also said it had more tanks than it really did: it repainted numbers on the tanks to confuse auditors.

study objective

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 283

284 chapter 6 Reporting and Analyzing Inventory

DETERMINING OWNERSHIP OF GOODS

One challenge in determining inventory quantities is making sure a company owns the inventory. To determine ownership of goods, two questions must be answered: Do all of the goods included in the count belong to the company? Does the company own any goods that were not included in the count?

Goods in Transit A complication in determining ownership is goods in transit (on board a truck, train, ship, or plane) at the end of the period. The company may have purchased goods that have not yet been received, or it may have sold goods that have not yet been delivered. To arrive at an accurate count, the company must determine ownership of these goods.

Goods in transit should be included in the inventory of the company that has legal title to the goods. Legal title is determined by the terms of the sale, as shown in Illustration 6-1 and described below.

1. When the terms are FOB (free on board) shipping point, ownership of the goods passes to the buyer when the public carrier accepts the goods from the seller.

2. When the terms are FOB destination, ownership of the goods remains with the seller until the goods reach the buyer.

Consigned Goods In some lines of business, it is common to hold the goods of other parties and try to sell the goods for them for a fee, but without taking ownership of the goods. These are called consigned goods.

For example, you might have a used car that you would like to sell. If you take the item to a dealer, the dealer might be willing to put the car on its lot and

What effect does an overstatement of inventory have on a company’s financial statements? (See page 330.)

Falsifying Inventory to Boost Income

Managers at women’s apparel maker Leslie Fay were convicted of falsifying inventory records to boost net income—and consequently to boost management bonuses. In another case, executives at Craig Consumer Electronics were accused of defrauding lenders by manipulating inventory records. The indictment said the com- pany classified “defective goods as new or refurbished” and claimed that it owned cer- tain shipments “from overseas suppliers” when, in fact, Craig either did not own the shipments or the shipments did not exist.

Ethics Insight

?

FOB Shipping Point FOB Destination

Public Carrier Co.

Seller Buyer

Ownership passes to

buyer here

Public Carrier Co.

Seller Buyer

Ownership passes to

buyer here

Buyer pays freight costs Seller pays freight costs

Illustration 6-1 Terms of sale

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 284

charge you a commission if it is sold. Under this agreement, the dealer would not take ownership of the car, which would still belong to you. If an inventory count were taken, the car would not be included in the dealer’s inventory be- cause the dealer does not own it.

Many car, boat, and antique dealers sell goods on consignment to keep their inventory costs down and to avoid the risk of purchasing an item that they won’t be able to sell. Today, even some manufacturers are making consignment agree- ments with their suppliers in order to keep their inventory levels low.

Determining Inventory Quantities 285

Action Plan

• Apply the rules of ownership to goods held on consignment.

• Apply the rules of ownership to goods in transit.

Hasbeen Company completed its inventory count. It arrived at a total inventory value of $200,000. You have been given the information listed below. Discuss how this information affects the reported cost of inventory.

1. Hasbeen included in the inventory goods held on consignment for Falls Co., costing $15,000.

2. The company did not include in the count purchased goods of $10,000, which were in transit (terms: FOB shipping point).

3. The company did not include in the count inventory that had been sold with a cost of $12,000, which was in transit (terms: FOB shipping point).

Solution

The goods of $15,000 held on consignment should be deducted from the inventory count. The goods of $10,000 purchased FOB shipping point should be added to the inventory count. Sold goods of $12,000 which were in transit FOB shipping point should not be included in the ending inventory. Inventory should be $195,000 ($200,000 � $15,000 � $10,000).

RULES OF OWNERSHIP

before you go on...

Do it!

Related exercise material: BE6-1, 6-1, E6-1, E6-2, and E6-3.Do it!

Ted Nickerson, CEO of clock manufacturer Dally Industries, was feared by all of his employees. Ted had expensive tastes. To support his expensive tastes, Ted took out large loans, which he collateralized with his shares of Dally Industries stock. If the price of Dally’s stock fell, he was required to provide the bank with more shares of stock. To achieve target net income figures and thus maintain the stock price, Ted coerced employees in the company to alter inventory figures. Inventory quantities were manipulated by changing the amounts on inventory control tags after the year-end physical inventory count. For example, if a tag said there were 20 units of a particular item, the tag was changed to 220. Similarly, the unit costs that were used to determine the value of ending inventory were increased from, for example, $125 per unit to $1,250. Both of these fraudulent changes had the effect of increasing the amount of reported ending inventory. This reduced cost of goods sold and increased net income.

ANATOMY OF A FRAU D

Total take: $245,000

THE MISSING CONTROL

Independent internal verification. The company should have spot-checked its inventory records periodically, verifying that the number of units in the records agreed with the amount on hand and that the unit costs agreed with vendor price sheets.

Source: Adapted from Wells, Fraud Casebook (2007), pp. 502–509.

c06ReportingandAnalyzingInventory.qxd 9/2/10 1:40 PM Page 285

286 chapter 6 Reporting and Analyzing Inventory

Inventory Costing Inventory is accounted for at cost. Cost includes all expenditures necessary to acquire goods and place them in a condition ready for sale. For example, freight costs incurred to acquire inventory are added to the cost of inventory, but the cost of shipping goods to a customer are a selling expense. After a company has determined the quantity of units of inventory, it applies unit costs to the quan- tities to determine the total cost of the inventory and the cost of goods sold. This process can be complicated if a company has purchased inventory items at dif- ferent times and at different prices.

For example, assume that Crivitz TV Company purchases three identical 50- inch TVs on different dates at costs of $700, $750, and $800. During the year, Crivitz sold two sets at $1,200 each. These facts are summarized in Illustration 6-2.

Cost of goods sold will differ depending on which two TVs the company sold. For example, it might be $1,450 ($700 � $750), or $1,500 ($700 � $800), or $1,550 ($750 � $800). In this section, we discuss alternative costing methods available to Crivitz.

SPECIFIC IDENTIFICATION

If Crivitz can positively identify which particular units it sold and which are still in ending inventory, it can use the specific identification method of inventory costing. For example, if Crivitz sold the TVs it purchased on February 3 and May 22, then its cost of goods sold is $1,500 ($700 � $800), and its ending inventory is $750 (see Illustration 6-3). Using this method, companies can accurately de- termine ending inventory and cost of goods sold.

Specific identification requires that companies keep records of the original cost of each individual inventory item. Historically, specific identification was possible only when a company sold a limited variety of high-unit-cost items that could be identified clearly from the time of purchase through the time of sale. Examples of such products are cars, pianos, or expensive antiques.

Today, with bar coding, electronic product codes, and radio frequency identi- fication, it is theoretically possible to do specific identification with nearly any type of product. The reality is, however, that this practice is still relatively rare. Instead, rather than keep track of the cost of each particular item sold, most companies make assumptions, called cost flow assumptions, about which units were sold.

2 Explain the basis of accounting for inventories and apply the inventory cost flow methods under a periodic inventory system.

study objective

Purchases Feb. 3 1 TV at $700 March 5 1 TV at $750 May 22 1 TV at $800

Sales June 1 2 TVs for $2,400 ($1,200 � 2)

Illustration 6-2 Data for inventory costing example

Illustration 6-3 Specific identification method

SOLD SOLD

$700

Cost of goods sold = $700 + $800 = $1,500 Ending inventory = $750

$800$750

Ending Inventory

Ethics Note A major disadvantage of the specific identification method is that management may be able to manipulate net income. For example, it can boost net income by selling units purchased at a low cost, or reduce net income by selling units purchased at a high cost.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 286

COST FLOW ASSUMPTIONS

Because specific identification is often impractical, other cost flow methods are permitted. These differ from specific identification in that they assume flows of costs that may be unrelated to the actual physical flow of goods. There are three assumed cost flow methods:

1. First-in, first-out (FIFO) 2. Last-in, first-out (LIFO) 3. Average-cost

There is no accounting requirement that the cost flow assumption be consistent with the physical movement of the goods. Company management selects the appropriate cost flow method.

To demonstrate the three cost flow methods, we will use a periodic inven- tory system. We assume a periodic system for two main reasons. First, many small companies use periodic rather than perpetual systems. Second, very few companies use perpetual LIFO, FIFO, or average-cost to cost their inventory and related cost of goods sold. Instead, companies that use perpetual systems often use an assumed cost (called a standard cost) to record cost of goods sold at the time of sale. Then, at the end of the period when they count their inven- tory, they recalculate cost of goods sold using periodic FIFO, LIFO, or average- cost and adjust cost of goods sold to this recalculated number.1

To illustrate the three inventory cost flow methods, we will use the data for Houston Electronics’ Astro condensers, shown in Illustration 6-4.

Inventory Costing 287

HOUSTON ELECTRONICS Astro Condensers

Date Explanation Units Unit Cost Total Cost

Jan. 1 Beginning inventory 100 $10 $ 1,000 Apr. 15 Purchase 200 11 2,200 Aug. 24 Purchase 300 12 3,600 Nov. 27 Purchase 400 13 5,200

Total units available for sale 1,000 $12,000 Units in ending inventory 450

Units sold 550

Illustration 6-4 Data for Houston Electronics

(Beginning Inventory � Purchases) � Ending Inventory � Cost of Goods Sold

From Chapter 5, the cost of goods sold formula in a periodic system is:

Houston Electronics had a total of 1,000 units available to sell during the period (beginning inventory plus purchases). The total cost of these 1,000 units is $12,000, referred to as cost of goods available for sale. A physical inventory taken at Decem- ber 31 determined that there were 450 units in ending inventory. Therefore, Hous- ton sold 550 units (1,000 � 450) during the period. To determine the cost of the 550 units that were sold (the cost of goods sold), we assign a cost to the ending inventory and subtract that value from the cost of goods available for sale. The

1Also, some companies use a perpetual system to keep track of units, but they do not make an entry for perpetual cost of goods sold. In addition, firms that employ LIFO tend to use dollar- value LIFO, a method discussed in upper-level courses. FIFO periodic and FIFO perpetual give the same result; therefore firms should not incur the additional cost to use FIFO perpetual. Few firms use perpetual average-cost because of the added cost of record-keeping. Finally, for instructional purposes, we believe it is easier to demonstrate the cost flow assumptions under the periodic system, which makes it more pedagogically appropriate.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 287

288 chapter 6 Reporting and Analyzing Inventory

value assigned to the ending inventory will depend on which cost flow method we use. No matter which cost flow assumption we use, though, the sum of cost of goods sold plus the cost of the ending inventory must equal the cost of goods available for sale—in this case, $12,000.

First-In, First-Out (FIFO) The FIFO (first-in, first-out) method assumes that the earliest goods purchased are the first to be sold. FIFO often parallels the actual physical flow of merchan- dise because it generally is good business practice to sell the oldest units first. Un- der the FIFO method, therefore, the costs of the earliest goods purchased are the first to be recognized in determining cost of goods sold, regardless which units were actually sold. (Note that this does not mean that the oldest units are sold first, but that the costs of the oldest units are recognized first. In a bin of picture hangers at the hardware store, for example, no one really knows, nor would it matter, which hangers are sold first.) Illustration 6-5 shows the allocation of the cost of goods available for sale at Houston Electronics under FIFO.

Under FIFO, since it is assumed that the first goods purchased were the first goods sold, ending inventory is based on the prices of the most recent units pur- chased. That is, under FIFO, companies determine the cost of the ending inventory by taking the unit cost of the most recent purchase and working backward until all units of inventory have been costed. In this example, Houston Electronics prices the 450 units of ending inventory using the most recent prices. The last purchase was 400 units at $13 on November 27. The remaining 50 units are priced using the unit cost of the second most recent

COST OF GOODS AVAILABLE FOR SALE

Date Explanation Units Unit Cost Total Cost

Jan. 1 Beginning inventory 100 $10 $ 1,000 Apr. 15 Purchase 200 11 2,200 Aug. 24 Purchase 300 12 3,600 Nov. 27 Purchase 400 13 5,200

Total 1,000 $12,000

Illustration 6-5 Allocation of costs—FIFO method

STEP 1: ENDING INVENTORY STEP 2: COST OF GOODS SOLD

Unit Total Date Units Cost Cost

Nov. 27 400 $13 $ 5,200 Cost of goods available for sale $12,000 Aug. 24 50 12 600 Less: Ending inventory 5,800

Total 450 $5,800 Cost of goods sold $ 6,200

Cost of goods sold

$6,200

$1,000

$2,200

$5,200

$600

$3,000

Ending inventory

Warehouse$5,800

Helpful Hint Note the sequencing of the allocation: (1) Compute ending inventory, and (2) determine cost of goods sold.

Helpful Hint Another way of thinking about the calculation of FIFO ending inventory is the LISH assumption—last in still here.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 288

purchase, $12, on August 24. Next, Houston Electronics calculates cost of goods sold by subtracting the cost of the units not sold (ending inventory) from the cost of all goods available for sale.

Illustration 6-6 demonstrates that companies also can calculate cost of goods sold by pricing the 550 units sold using the prices of the first 550 units acquired. Note that of the 300 units purchased on August 24, only 250 units are assumed sold. This agrees with our calculation of the cost of ending inventory, where 50 of these units were assumed unsold and thus included in ending inventory.

Last-In, First-Out (LIFO) The LIFO (last-in, first-out) method assumes that the latest goods purchased are the first to be sold. LIFO seldom coincides with the actual physical flow of inventory. (Exceptions include goods stored in piles, such as coal or hay, where goods are removed from the top of the pile as they are sold.) Under the LIFO method, the costs of the latest goods purchased are the first to be recognized in determining cost of goods sold. Illustration 6-7 shows the allocation of the cost of goods available for sale at Houston Electronics under LIFO.

Inventory Costing 289

COST OF GOODS AVAILABLE FOR SALE

Date Explanation Units Unit Cost Total Cost

Jan. 1 Beginning inventory 100 $10 $ 1,000 Apr. 15 Purchase 200 11 2,200 Aug. 24 Purchase 300 12 3,600 Nov. 27 Purchase 400 13 5,200

Total 1,000 $12,000

Illustration 6-7 Allocation of costs—LIFO method

STEP 1: ENDING INVENTORY STEP 2: COST OF GOODS SOLD

Unit Total Date Units Cost Cost

Jan. 1 100 $10 $ 1,000 Cost of goods available for sale $12,000 Apr. 15 200 11 2,200 Less: Ending inventory 5,000 Aug. 24 150 12 1,800 Cost of goods sold $ 7,000

Total 450 $5,000

$1,000

$2,200

$5,200

$1,800

$1,800 Cost ofgoods sold

$7,000

Warehouse$5,000

Ending inventory

Helpful Hint Another way of thinking about the calculation of LIFO ending inventory is the FISH assumption—first in still here.

Illustration 6-6 Proof of cost of goods soldDate Units Unit Cost Total Cost

Jan. 1 100 $10 $ 1,000 Apr. 15 200 11 2,200 Aug. 24 250 12 3,000

Total 550 $6,200

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 289

290 chapter 6 Reporting and Analyzing Inventory

Under LIFO, since it is assumed that the first goods sold were those that were most recently purchased, ending inventory is based on the prices of the oldest units purchased. That is, under LIFO, companies obtain the cost of the ending inventory by taking the unit cost of the earliest goods avail- able for sale and working forward until all units of inventory have been costed. In this example, Houston Electronics prices the 450 units of ending inventory using the earliest prices. The first purchase was 100 units at $10 in the January 1 beginning inventory. Then 200 units were purchased at $11. The remaining 150 units needed are priced at $12 per unit (August 24 purchase). Next, Houston Electronics calculates cost of goods sold by subtracting the cost of the units not sold (ending inventory) from the cost of all goods available for sale.

Illustration 6-8 demonstrates that we can also calculate cost of goods sold by pricing the 550 units sold using the prices of the last 550 units acquired. Note that of the 300 units purchased on August 24, only 150 units are as- sumed sold. This agrees with our calculation of the cost of ending inventory, where 150 of these units were assumed unsold and thus included in ending inventory.

Under a periodic inventory system, which we are using here, all goods pur- chased during the period are assumed to be available for the first sale, re- gardless of the date of purchase.

Average-Cost The average-cost method allocates the cost of goods available for sale on the basis of the weighted-average unit cost incurred. Illustration 6-9 presents the formula and a sample computation of the weighted-average unit cost.

The company then applies the weighted-average unit cost to the units on hand to determine the cost of the ending inventory. Illustration 6-10 shows the allocation of the cost of goods available for sale at Houston Electronics using average-cost.

We can verify the cost of goods sold under this method by multiplying the units sold times the weighted-average unit cost (550 � $12 � $6,600). Note that this method does not use the simple average of the unit costs. That av- erage is $11.50 ($10 � $11 � $12 � $13 � $46; $46 � 4). The average-cost method instead uses the average weighted by the quantities purchased at each unit cost.

Illustration 6-8 Proof of cost of goods sold

Illustration 6-9 Formula for weighted-average unit cost

Date Units Unit Cost Total Cost

Nov. 27 400 $13 $ 5,200 Aug. 24 150 12 1,800

Total 550 $7,000

Cost of Goods Total Units Weighted- Available � Available � Average for Sale for Sale Unit Cost

$12,000 � 1,000 � $12.00

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 290

Inventory Costing 291

COST OF GOODS AVAILABLE FOR SALE

Date Explanation Units Unit Cost Total Cost

Jan. 1 Beginning inventory 100 $10 $ 1,000 Apr. 15 Purchase 200 11 2,200 Aug. 24 Purchase 300 12 3,600 Nov. 27 Purchase 400 13 5,200

Total 1,000 $12,000

Illustration 6-10 Allocation of costs— average-cost method

STEP 1: ENDING INVENTORY STEP 2: COST OF GOODS SOLD

$12,000 � 1,000 � $12.00 Cost of goods available for sale $12,000 Unit Total Less: Ending inventory 5,400

Units Cost Cost Cost of goods sold $ 6,600 450 $12.00 $5,400

Cost of goods sold

$12,000 – $5,400 = $6,600

Warehouse 450 units × $12= $5,400

Ending inventory

Cost per unit

$12,000––––––––– 1,000 units

= $12 per unit

Action Plan

• Understand the periodic inventory system.

• Allocate costs between goods sold and goods on hand (ending inventory) for each cost flow method.

• Compute cost of goods sold for each cost flow method.

The accounting records of Shumway Ag Implement show the follow- ing data.

Beginning inventory 4,000 units at $3 Purchases 6,000 units at $4 Sales 7,000 units at $12

Determine (a) the cost of goods available for sale and (b) the cost of goods sold during the period under a periodic system using (i) FIFO, (ii) LIFO, and (iii) average-cost.

Solution

(a) Cost of goods available for sale: (4,000 � $3) � (6,000 � $4) � $36,000 (b) Cost of goods sold using:

(i) FIFO: $36,000 � (3,000* � $4) � $24,000 (ii) LIFO: $36,000 � (3,000 � $3) � $27,000

(iii) Average-cost: Weighted-average price � ($36,000 � 10,000) � $3.60 $36,000 � (3,000 � $3.60) � $25,200

*(4,000 � 6,000 � 7,000)

COST FLOW METHODS

before you go on...

Do it!

Related exercise material: BE6-2, BE6-3, 6-2, E6-4, and E6-5.Do it!

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 291

292 chapter 6 Reporting and Analyzing Inventory

FINANCIAL STATEMENT AND TAX EFFECTS OF COST FLOW METHODS

Each of the three assumed cost flow methods is acceptable for use under GAAP. For example, Reebok International Ltd. and Wendy’s International currently use the FIFO method of inventory costing. Campbell Soup Company, Krogers, and Walgreens use LIFO for part or all of their inventory. Bristol-Myers Squibb, Starbucks, and Motorola use the average-cost method. In fact, a company may also use more than one cost flow method at the same time. Stanley Black & Decker Manufacturing Company, for example, uses LIFO for domestic invento- ries and FIFO for foreign inventories. Illustration 6-11 shows the use of the three cost flow methods in the 600 largest U.S. companies.

The reasons companies adopt different inventory cost flow methods are varied, but they usually involve at least one of the following three factors:

1. Income statement effects

2. Balance sheet effects

3. Tax effects

Income Statement Effects To understand why companies might choose a particular cost flow method, let’s examine the effects of the different cost flow assumptions on the financial state- ments of Houston Electronics. The condensed income statements in Illustration 6-12 assume that Houston sold its 550 units for $18,500, had operating expenses of $9,000, and is subject to an income tax rate of 30%.

Explain the financial statement and tax effects of each of the inventory cost flow assumptions.

study objective 3

33% LIFO

44% FIFO

19% Average-

Cost

4% Other

Illustration 6-11 Use of cost flow methods in major U.S. companies

HOUSTON ELECTRONICS Condensed Income Statements

FIFO LIFO Average-Cost

Sales revenue $18,500 $18,500 $18,500

Beginning inventory 1,000 1,000 1,000 Purchases 11,000 11,000 11,000

Cost of goods available for sale 12,000 12,000 12,000 Less: Ending inventory 5,800 5,000 5,400

Cost of goods sold 6,200 7,000 6,600

Gross profit 12,300 11,500 11,900 Operating expenses 9,000 9,000 9,000

Income before income taxes 3,300 2,500 2,900 Income tax expense (30%) 990 750 870

Net income $ 2,310 $ 1,750 $ 2,030

Illustration 6-12 Comparative effects of cost flow methods

Note the cost of goods available for sale ($12,000) is the same under each of the three inventory cost flow methods. However, the ending inventories and the costs of goods sold are different. This difference is due to the unit costs that the company allocated to cost of goods sold and to ending inventory. Each dol- lar of difference in ending inventory results in a corresponding dollar difference in income before income taxes. For Houston, an $800 difference exists between FIFO and LIFO cost of goods sold.

In periods of changing prices, the cost flow assumption can have a signifi- cant impact on income and on evaluations based on income. In most instances, prices are rising (inflation). In a period of inflation, FIFO produces a higher net

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 292

income because the lower unit costs of the first units purchased are matched against revenues. In a period of rising prices (as is the case in the Houston ex- ample), FIFO reports the highest net income ($2,310) and LIFO the lowest ($1,750); average-cost falls in the middle ($2,030). If prices are falling, the re- sults from the use of FIFO and LIFO are reversed: FIFO will report the lowest net income and LIFO the highest.

To management, higher net income is an advantage: It causes external users to view the company more favorably. In addition, management bonuses, if based on net income, will be higher. Therefore, when prices are rising (which is usually the case), companies tend to prefer FIFO because it results in higher net income.

Some argue that the use of LIFO in a period of inflation reduces the likeli- hood that the company will report paper (or phantom) profit as economic gain. To illustrate, assume that Kralik Company buys 200 units of a product at $20 per unit on January 10 and 200 more on December 31 at $24 each. During the year, Kralik sells 200 units at $30 each. Illustration 6-13 shows the results un- der FIFO and LIFO.

Under LIFO, Kralik Company has recovered the current replacement cost ($4,800) of the units sold. Thus, the gross profit in economic terms is real. How- ever, under FIFO, the company has recovered only the January 10 cost ($4,000). To replace the units sold, it must reinvest $800 (200 � $4) of the gross profit. Thus, $800 of the gross profit is said to be phantom or illusory. As a result, re- ported net income is also overstated in real terms.

Balance Sheet Effects A major advantage of the FIFO method is that in a period of inflation, the costs allocated to ending inventory will approximate their current cost. For example, for Houston Electronics, 400 of the 450 units in the ending inventory are costed under FIFO at the higher November 27 unit cost of $13.

Conversely, a major shortcoming of the LIFO method is that in a period of inflation, the costs allocated to ending inventory may be significantly under- stated in terms of current cost. The understatement becomes greater over pro- longed periods of inflation if the inventory includes goods purchased in one or more prior accounting periods. For example, Caterpillar has used LIFO for 50 years. Its balance sheet shows ending inventory of $4,675 million. But, the in- ventory’s actual current cost if FIFO had been used is $6,799 million.

Tax Effects We have seen that both inventory on the balance sheet and net income on the income statement are higher when companies use FIFO in a period of inflation. Yet, many companies use LIFO. Why? The reason is that LIFO results in the lowest income taxes (because of lower net income) during times of rising prices. For example, in Illustration 6-12, income taxes are $750 under LIFO, compared to $990 under FIFO. The tax savings of $240 makes more cash available for use in the business.

Inventory Costing 293

Illustration 6-13 Income statement effects comparedFIFO LIFO

Sales revenue (200 � $30) $6,000 $6,000 Cost of goods sold 4,000 (200 � $20) 4,800 (200 � $24)

Gross profit $2,000 $1,200

Helpful Hint A tax rule, often referred to as the LIFO conformity rule, requires that if companies use LIFO for tax purposes, they must also use it for financial reporting purposes. This means that if a company chooses the LIFO method to reduce its tax bills, it will also have to report lower net income in its financial statements.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 293

294 chapter 6 Reporting and Analyzing Inventory

What are the arguments for and against the use of LIFO? (See page 330.)

Is LIFO Fair?

ExxonMobil Corporation, like many U.S. companies, uses LIFO to value its in- ventory for financial reporting and tax purposes. In one recent year, this resulted in a cost of goods sold figure that was $5.6 billion higher than under FIFO. By increasing cost of goods sold, ExxonMobil reduces net income, which reduces taxes. Critics say that LIFO provides an unfair “tax dodge.” As Congress looks for more sources of tax revenue, some lawmakers favor the elimination of LIFO. Supporters of LIFO argue that the method is conceptually sound because it matches current costs with current revenues. In addition, they point out that this matching provides protection against inflation.

International accounting standards do not allow the use of LIFO. Because of this, the net income of foreign oil companies, such as BP and Royal Dutch Shell, are not di- rectly comparable to U.S. companies, which makes analysis difficult.

Source: David Reilly, “Big Oil’s Accounting Methods Fuel Criticism,” Wall Street Journal (August 8, 2006), p. C1.

International Insight

? KEEPING AN EYE

ON CASH You have just seen that when prices are rising the use of LIFO can have a big effect on taxes. The lower taxes paid using LIFO can significantly increase cash flows. To demonstrate the effect of the cost flow assumptions on cash flow, we will calculate net cash provided by operating activities, using the data for Houston Electronics from Illustration 6-12. To simplify our example, we assume that Houston’s sales and purchases are all cash transactions. We also assume that op- erating expenses, other than $4,600 of depreciation, are cash transactions.

LIFO has the highest net cash provided by operating activities because it results in the lowest tax payments. Since cash flow is the lifeblood of any organization, the choice of inventory method is very important.

LIFO also impacts the quality of earnings ratio. Recall that the quality of earnings ratio is net cash provided by operating activities divided by net income. Here, we calculate the quality earnings ratio under each cost flow assumption.

LIFO has the highest quality of earnings ratio for two reasons: (1) It has the highest net cash provided by operating activities, which increases the ratio’s numerator. (2) It reports a conservative measure of net income, which decreases the ratio’s denominator. As discussed earlier, LIFO provides a conservative mea- sure of net income because it does not include the phantom profits reported under FIFO.

FIFO LIFO Average-Cost

Cash received from customers $18,500 $18,500 $18,500 Cash purchases of goods 11,000 11,000 11,000 Cash paid for operating expenses

($9,000 � $4,600) 4,400 4,400 4,400 Cash paid for taxes 990 750 870

Net cash provided by operating activities $ 2,110 $ 2,350 $ 2,230

FIFO LIFO Average-Cost

Net income (from Illustration 6-12) $2,310 $1,750 $2,030 Quality of earnings ratio 0.91 1.34 1.1

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 294

USING INVENTORY COST FLOW METHODS CONSISTENTLY

Whatever cost flow method a company chooses, it should use that method con- sistently from one accounting period to another. Consistent application enhances the ability to analyze a company’s financial statements over successive time pe- riods. In contrast, using the FIFO method one year and the LIFO method the next year would make it difficult to compare the net incomes of the two years.

Although consistent application is preferred, it does not mean that a com- pany may never change its method of inventory costing. When a company adopts a different method, it should disclose in the financial statements the change and its effects on net income. A typical disclosure is shown in Illustration 6-14, us- ing information from recent financial statements of the Quaker Oats Company.

LOWER-OF-COST-OR-MARKET

The value of inventory for companies selling high-technology or fashion goods can drop very quickly due to changes in technology or changes in fashions. These circumstances sometimes call for inventory valuation methods other than those presented so far. For example, in a recent year, purchasing managers at Ford decided to make a large purchase of palladium, a precious metal used in vehicle emission devices. They made this large purchase because they feared a future shortage. The shortage did not materialize, and by the end of the year the price of palladium had plummeted. Ford’s inventory was then worth $1 billion less than its original cost. Do you think Ford’s inventory should have been stated at cost, in accordance with the cost principle, or at its lower replacement cost?

As you probably reasoned, this situation requires a departure from the cost basis of accounting. When the value of inventory is lower than its cost, compa- nies write down the inventory to its market value. This is done by valuing the inventory at the lower-of-cost-or-market (LCM) in the period in which the price decline occurs. LCM is an example of the accounting concept of conservatism, which means that the best choice among accounting alternatives is the method that is least likely to overstate assets and net income.

Companies apply LCM to the items in inventory after they have used one of the cost flow methods (specific identification, FIFO, LIFO, or average-cost) to de- termine cost. Under the LCM basis, market is defined as current replacement cost, not selling price. For a merchandising company, market is the cost of

Inventory Costing 295

DECISION TOOLKIT DECISION CHECKPOINTS TOOL TO USE FOR DECISION HOW TO EVALUATE RESULTS

Which inventory costing method should be used?

Are prices increasing, or are they decreasing?

Income statement, balance sheet, and tax effects

Depends on objective. In a period of rising prices, income and inventory are higher and cash flow is lower under FIFO. LIFO provides opposite results. Average-cost can moderate the impact of changing prices.

INFO NEEDED FOR DECISION

Helpful Hint As you learned in Chapter 2, consistency and comparability are important characteristics of accounting information.

QUAKER OATS COMPANY Notes to the Financial Statements

Note 1: Effective July 1, the Company adopted the LIFO cost flow assumption for valuing the majority of U.S. Grocery Products inventories. The Company believes that the use of the LIFO method better matches current costs with current revenues. The effect of this change on the current year was to decrease net income by $16.0 million.

Illustration 6-14 Disclosure of change in cost flow method

Explain the lower-of-cost- or-market basis of accounting for inventories.

study objective 4

International Note Under U.S. GAAP, companies cannot reverse inventory write-downs if inventory increases in value in subsequent periods. IFRS permits companies to reverse write-downs in some circumstances.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 295

296 chapter 6 Reporting and Analyzing Inventory

purchasing the same goods at the present time from the usual suppliers in the usual quantities. Current replacement cost is used because a decline in the replace- ment cost of an item usually leads to a decline in the selling price of the item.

To illustrate the application of LCM, assume that Ken Tuckie TV has the fol- lowing lines of merchandise with costs and market values as indicated. LCM produces the results shown in Illustration 6-15. Note that the amounts shown in the final column are the lower-of-cost-or-market amounts for each item.

Adherence to LCM is important. A Chinese manufacturer of silicon wafers for solar energy panels, LDK Solar Co., was accused of violating LCM. When the financial press reported accusations that two-thirds of its inventory of silicon was unsuitable for processing, the company’s stock price fell by 40%.

Analysis of Inventory For companies that sell goods, managing inventory levels can be one of the most critical tasks. Having too much inventory on hand costs the company money in storage costs, interest cost (on funds tied up in inventory), and costs associated with the obsolescence of technical goods (e.g., computer chips) or shifts in fash- ion (e.g., clothes). But having too little inventory on hand results in lost sales. In this section, we discuss some issues related to evaluating inventory levels.

INVENTORY TURNOVER RATIO

The inventory turnover ratio is calculated as cost of goods sold divided by average inventory. It indicates how quickly a company sells its goods—the num- ber of times the average inventory “turns over” (is sold) during the year.

Illustration 6-15 Computation of inventory at lower-of-cost-or-market

Lower-of- Cost Market Cost-or-Market

Flat-panel TVs $60,000 $55,000 $ 55,000 Satellite radios 45,000 52,000 45,000 DVD recorders 48,000 45,000 45,000 DVDs 15,000 14,000 14,000

Total inventory $159,000

Action Plan

• Determine whether cost or market value is lower for each inventory type.

• Sum the lower value of each inventory type to determine the total value of inventory.

Tracy Company sells three different types of home heating stoves (wood, gas, and pellet). The cost and market value of its inventory of stoves are as follows.

Cost Market

Gas $ 84,000 $ 79,000 Wood 250,000 280,000 Pellet 112,000 101,000

Determine the value of the company’s inventory under the lower-of-cost-or-market approach.

Solution

The lower value for each inventory type is: gas $79,000, wood $250,000, and pellet $101,000. The total inventory value is the sum of these figures, $430,000.

LCM BASIS

before you go on...

Do it!

Related exercise material: BE6-7, 6-3, and E6-9.Do it!

Compute and interpret the inventory turnover ratio.

study objective 5

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 296

Inventory turnover can be divided into 365 days to compute days in inventory, which indicates the average number of days inventory is held.

High inventory turnover (low days in inventory) indicates the company has minimal funds tied up in inventory—that it has a minimal amount of inventory on hand at any one time. Although minimizing the funds tied up in inventory is efficient, too high an inventory turnover ratio may indicate that the company is losing sales opportunities because of inventory shortages. For example, invest- ment analysts at one time suggested that Office Depot had gone too far in re- ducing its inventory—they said they were seeing too many empty shelves. Thus, management should closely monitor this ratio to achieve the best balance be- tween too much and too little inventory.

In Chapter 5, we discussed the increasingly competitive environment of retailers like Wal-Mart and Target. Wal-Mart has implemented just-in-time inventory procedures as well as many technological innovations to improve the efficiency of its inventory management. The following data are available for Wal-Mart.

Illustration 6-16 presents the inventory turnover ratios and days in inventory for Wal-Mart and Target, using data from the financial statements of those corpora- tions for 2009 and 2008.

The calculations in Illustration 6-16 show that Wal-Mart turns its inven- tory more frequently than Target and the industry average (8.8 times for Wal- Mart versus 6.5 times for Target and 8.6 for the industry). Consequently, the average time an item spends on a Wal-Mart shelf is shorter (41.5 days for Wal- Mart versus 56.2 days for Target and 42.4 days for the industry). This suggests that Wal-Mart is more efficient than Target in its inventory management.

Analysis of Inventory 297

(in millions) 2009 2008

Ending inventory $ 34,511 $35,159 Cost of goods sold 306,158

Wal-Mart Industry Ratio ($ in millions) Target Average

2009 2008 2009 2009

Inventory Turnover Ratio � Cost of Goods Sold Average Inventory

Days in Inventory � 365 Inventory Turnover

Ratio

Inventory turnover $306,158 � 8.8 times 7.8 times 6.5 times 8.6 times ratio ($34,511 � $35,159)/2

Days in inventory 365 days � 41.5 days 46.8 days 56.2 days 42.4 days 8.8

Illustration 6-16 Inventory turnover ratio and days in inventory

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 297

298 chapter 6 Reporting and Analyzing Inventory

Accounting Across the Organization

?Why is inventory control important to managers such as those at Wal-Mart andBest Buy? (See page 330.)

DECISION CHECKPOINTS TOOL TO USE FOR DECISION HOW TO EVALUATE RESULTS

How long is an item in inventory? Cost of goods sold; beginning and ending inventory

A higher inventory turnover ratio or lower average days in inventory suggests that management is reducing the amount of inventory on hand, relative to cost of goods sold.

INFO NEEDED FOR DECISION

DECISION TOOLKIT

Cost of Inventory

� goods sold

turnover ratio Average inventory

Days in �

365 days inventory Inventory

turnover ratio

Early in 2012, Westmoreland Company switched to a just-in-time inven- tory system. Its sales, cost of goods sold, and inventory amounts for 2011 and 2012 are shown below.

2011 2012

Sales revenue $2,000,000 $1,800,000 Cost of goods sold 1,000,000 910,000 Beginning inventory 290,000 210,000 Ending inventory 210,000 50,000

Determine the inventory turnover and days in inventory for 2011 and 2012. Discuss the changes in the amount of inventory, the inventory turnover and days in inventory, and the amount of sales across the two years.

INVENTORY TURNOVER

before you go on...

Do it!

Note also that Wal-Mart’s inventory turnover, which was already very good in 2008, improved significantly in 2009. Wal-Mart’s sophisticated inventory tracking and distribution system allows it to keep minimum amounts of inventory on hand, while still keeping the shelves full of what customers are looking for.

Improving Inventory Control with RFID

Wal-Mart improved its inventory control with the introduction of radio frequency identification (RFID). Much like bar codes, which tell a retailer the number of boxes of a specific product it has, RFID goes a step farther, helping to distinguish one box of a spe- cific product from another. RFID uses technology similar to that used by keyless remotes that unlock car doors.

Companies currently use RFID to track shipments from supplier to distribution center to store. Other potential uses include monitoring product expiration dates and acting quickly on product recalls. Wal-Mart also anticipates faster returns and warranty processing us- ing RFID. This technology will further assist Wal-Mart managers in their efforts to ensure that their store has just the right type of inventory, in just the right amount, in just the right place. Other companies are also interested in RFID. Best Buy has spent millions research- ing possible applications in its stores.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 298

ANALYSTS’ ADJUSTMENTS FOR LIFO RESERVE

Earlier we noted that using LIFO rather than FIFO can result in significant dif- ferences in the results reported in the balance sheet and the income statement. With increasing prices, FIFO will result in higher income than LIFO. On the bal- ance sheet, FIFO will result in higher reported inventory. The financial state- ment differences from using LIFO normally increase the longer a company uses LIFO.

Use of different inventory cost flow assumptions complicates analysts’ at- tempts to compare companies’ results. Fortunately, companies using LIFO are required to report the difference between inventory reported using LIFO and in- ventory using FIFO. This amount is referred to as the LIFO reserve. Reporting the LIFO reserve enables analysts to make adjustments to compare companies that use different cost flow methods.

Illustration 6-17 presents an excerpt from the notes to Caterpillar’s 2009 financial statements that discloses and discusses Caterpillar’s LIFO reserve.

Analysis of Inventory 299

2011 2012

Inventory turnover $1,000,000 �4

$910,000 � 7ratio ($290,000 � $210,000)/2 ($210,000 � $50,000)/2

Days in 365 � 4 � 91.3 days 365 � 7 � 52.1 days inventory

The company experienced a very significant decline in its ending inventory as a result of the just-in-time inventory. This decline improved its inventory turnover ratio and its days in inventory. However, its sales declined by 10%. It is possible that this decline was caused by the dramatic reduction in the amount of inventory that was on hand, which increased the likelihood of “stock-outs.” To determine the optimal inventory level, man- agement must weigh the benefits of reduced inventory against the potential lost sales caused by stock-outs.

Solution Action Plan

• To find the inventory turnover ratio, divide cost of goods sold by average inventory.

• To determine days in inventory, divide 365 days by the inventory turnover ratio.

• Just-in-time inventory reduces the amount of inventory on hand, which reduces carrying costs. Reducing inventory levels by too much has potential negative implications for sales.

Related exercise material: BE6-8, 6-4, and E6-10.Do it!

Describe the LIFO reserve and explain its importance for comparing results of different companies.

study objective 6

Caterpillar has used LIFO for over 50 years. Thus, the cumulative differ- ence between LIFO and FIFO reflected in the Inventory account is very large. In fact, the 2009 LIFO reserve of $3,003 million is 47% of the 2009 LIFO in- ventory of $6,360 million. Such a huge difference would clearly distort any comparisons you might try to make with one of Caterpillar’s competitors that used FIFO.

CATERPILLAR INC. Notes to the Financial Statements

Inventories: Inventories are stated at the lower of cost or market. Cost is prin- cipally determined using the last-in, first-out (LIFO) method . . . . If the FIFO (first-in, first-out) method had been in use, inventories would have been $3,003, $3,183, and $2,617 million higher than reported at December 31, 2009, 2008, and 2007, respectively.

Illustration 6-17 Caterpillar LIFO reserve

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 299

300 chapter 6 Reporting and Analyzing Inventory

The LIFO reserve can have a significant effect on ratios that analysts com- monly use. Using the LIFO reserve adjustment, Illustration 6-19 calculates the value of the current ratio (current assets � current liabilities) for Caterpillar un- der both the LIFO and FIFO cost flow assumptions.

As Illustration 6-19 shows, if Caterpillar used FIFO, its current ratio would be 1.54:1 rather than 1.39:1 under LIFO. Thus, Caterpillar’s liquidity appears stronger if a FIFO assumption were used in valuing inventories. If a similar ad- justment is made for the inventory turnover ratio, Caterpillar’s inventory turnover actually would look worse under FIFO than under LIFO, dropping from 3.2 times for LIFO to 2.3 times for FIFO.2 The reason: LIFO reports low inventory amounts, which cause inventory turnover to be higher.

CNH Global, a competitor of Caterpillar, uses FIFO to account for its inven- tory. Comparing Caterpillar to CNH without converting Caterpillar’s inventory to FIFO would lead to distortions and potentially erroneous decisions.

Illustration 6-18 Conversion of inventory from LIFO to FIFO

(in millions) 2009 inventory using LIFO $ 6,360 2009 LIFO reserve 3,003

2009 inventory assuming FIFO $9,363

Illustration 6-19 Impact of LIFO reserve on ratios

Current ratio $26,789 �1.39:1 $26,789 � $3,003 � 1.54:1 $19,292 $19,292

($ in millions) LIFO FIFO

2The LIFO reserve also affects cost of goods sold although typically by a much less material amount. The cost of goods sold adjustment is discussed in more advanced financial statement analysis texts.

DECISION CHECKPOINTS TOOL TO USE FOR DECISION HOW TO EVALUATE RESULTS

What is the impact of LIFO on the company’s reported inventory?

LIFO reserve, cost of goods sold, ending inventory, current assets, current liabilities

If these adjustments are material, they can significantly affect such measures as the current ratio and the inventory turnover ratio.

INFO NEEDED FOR DECISION

DECISION TOOLKIT

LIFO �

LIFO �

FIFO inventory reserve inventory

To adjust Caterpillar’s inventory balance, we add the LIFO reserve to reported inventory, as shown in Illustration 6-18. That is, if Caterpillar had used FIFO all along, its inventory would be $9,363 million, rather than $6,360 million.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 300

Using the Decision Toolkit 301

The Manitowoc Company is located in Manitowoc, Wisconsin. In recent years, it has made a series of strategic acquisitions to grow and enhance its market-leading positions in each of its three business segments. These include: cranes and related products (crawler cranes, tower cranes, and boom trucks); food service equipment (commercial ice-cube machines, ice-beverage dispensers, and commercial refrig- eration equipment); and marine operations (shipbuilding and ship-repair services). The company reported inventory of $595.5 million for 2009 and of $925.3 million for 2008. Here is the inventory note taken from the 2009 financial statements.

USING THE DECISION TOOLKIT

THE MANITOWOC COMPANY Notes to the Financial Statements

Inventories: The components of inventories at December 31 are summarized as fol- lows (in millions).

2009 2008

Inventories—gross Raw materials $244.5 $ 416.0 Work-in-process 163.5 262.9 Finished goods 310.8 352.3

Total 718.8 1,031.2 Less: Excess and obsolete inventory reserve (90.9) (70.1)

Net inventories at FIFO cost 627.9 961.1 Less: Excess of FIFO costs over LIFO value (32.4) (35.8)

Inventories—net (as reported on balance sheet) $595.5 $ 925.3

Manitowoc carries inventory at the lower-of-cost-or-market using the first-in, first-out (FIFO) method for approximately 90% of total inventory for 2009 and 2008. The remainder of the inventory is costed using the last-in, first-out (LIFO) method.

Additional facts:

2009 Current liabilities $1,142.2 2009 Current assets (as reported) 1,259.9 2009 Cost of goods sold 2,958.0

Instructions Answer the following questions.

1. Why does the company report its inventory in three components? 2. Why might the company use two methods (LIFO and FIFO) to account for its

inventory? 3. Perform each of the following.

(a) Calculate the inventory turnover ratio and days in inventory using the LIFO inventory.

(b) Calculate the 2009 current ratio using LIFO and the current ratio using FIFO. Discuss the difference.

Solution 1. The Manitowoc Company is a manufacturer, so it purchases raw materials and

makes them into finished products. At the end of each period, it has some goods that have been started but are not yet complete (work in process).

c06ReportingandAnalyzingInventory.qxd 10/12/10 11:38 AM Page 301

By reporting all three components of inventory, a company reveals impor- tant information about its inventory position. For example, if amounts of raw materials have increased significantly compared to the previous year, we might assume the company is planning to step up production. On the other hand, if levels of finished goods have increased relative to last year and raw materials have declined, we might conclude that sales are slowing down—that the com- pany has too much inventory on hand and is cutting back production.

2. Companies are free to choose different cost flow assumptions for different types of inventory. A company might choose to use FIFO for a product that is expected to decrease in price over time. One common reason for choosing a method other than LIFO is that many foreign countries do not allow LIFO; thus, the company cannot use LIFO for its foreign operations.

302 chapter 6 Reporting and Analyzing Inventory

3. (a) Inventory turnover �

Cost of goods sold �

$2,958.0 � 3.9

ratio Average inventory ($595.5 � $925.3)/2

Days in �

365 �

365 � 93.6 days

inventory Inventory turnover ratio 3.9

Summary of Study Objectives 1 Describe the steps in determining inventory quantities.

The steps are (1) take a physical inventory of goods on hand and (2) determine the ownership of goods in transit or on consignment.

2 Explain the basis of accounting for inventories and ap- ply the inventory cost flow methods under a periodic inventory system. The primary basis of accounting for inventories is cost. Cost includes all expenditures nec- essary to acquire goods and place them in a condition ready for sale. Cost of goods available for sale includes (a) cost of beginning inventory and (b) cost of goods purchased. The inventory cost flow methods are: specific identification and three assumed cost flow methods—FIFO, LIFO, and average-cost.

3 Explain the financial statement and tax effects of each of the inventory cost flow assumptions. The cost of goods available for sale may be allocated to cost of goods sold and ending inventory by specific identification or by a method based on an assumed cost flow. When prices are rising, the first-in, first-out (FIFO) method results in lower cost of goods sold and higher net income than the average-cost and the last-in, first-out (LIFO) meth- ods. The reverse is true when prices are falling. In the balance sheet, FIFO results in an ending inventory that is closest to current value, whereas the inventory under LIFO is the farthest from current value. LIFO

results in the lowest income taxes (because of lower taxable income).

4 Explain the lower-of-cost-or-market basis of account- ing for inventories. Companies use the lower-of-cost- or-market (LCM) basis when the current replacement cost (market) is less than cost. Under LCM, compa- nies recognize the loss in the period in which the price decline occurs.

5 Compute and interpret the inventory turnover ratio. The inventory turnover ratio is calculated as cost of goods sold divided by average inventory. It can be converted to average days in inventory by dividing 365 days by the inventory turnover ratio. A higher turnover ratio or lower average days in inventory suggests that man- agement is trying to keep inventory levels low relative to its sales level.

6 Describe the LIFO reserve and explain its importance for comparing results of different companies. The LIFO reserve represents the difference between ending in- ventory using LIFO and ending inventory if FIFO were employed instead. For some companies this difference can be significant, and ignoring it can lead to inappropriate conclusions when using the current ratio or inventory turnover ratio.

(b) Current ratio

LIFO FIFO

Current assets �

$1,259.9 � 1.10:1 $1,259.9 � $32.4 � 1.13:1

Current liabilities $1,142.2 $1,142.2

This represents a 2.7% increase in the current ratio (1.13 � 1.10) /1.10.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 302

Appendix 6A: Inventory Cost Flow Methods in Perpetual Inventory Systems 303

DECISION CHECKPOINTS TOOL TO USE FOR DECISION HOW TO EVALUATE RESULTS

Which inventory costing method should be used?

Are prices increasing, or are they decreasing?

Income statement, balance sheet, and tax effects

Depends on objective. In a period of rising prices, income and inventory are higher and cash flow is lower under FIFO. LIFO provides opposite results. Average-cost can moderate the impact of changing prices.

INFO NEEDED FOR DECISION

DECISION TOOLKIT A SUMMARY

How long is an item in inventory?

Cost of goods sold; beginning and ending inventory

Cost of Inventory

� goods sold

turnover ratio Average inventory

Days in �

365 days inventory Inventory

turnover ratio

A higher inventory turnover ratio or lower average days in inventory suggests that management is reducing the amount of inventory on hand, relative to cost of goods sold.

What is the impact of LIFO on the company’s reported inventory?

LIFO reserve, cost of goods sold, ending inventory, current assets, current liabilities

LIFO �

LIFO �

FIFO inventory reserve inventory

If these adjustments are material, they can significantly affect such measures as the current ratio and the inventory turnover ratio.

Each of the inventory cost flow methods described in the chapter for a periodic inventory system may be used in a perpetual inventory system. To illustrate the application of the three assumed cost flow methods (FIFO, LIFO, and average- cost), we will use the data shown in Illustration 6A-1 and in this chapter for Houston Electronics’ Astro condensers.

appendix 6A

Inventory Cost Flow Methods in Perpetual Inventory Systems

Apply the inventory cost flow methods to perpetual inventory records.

study objective 7

HOUSTON ELECTRONICS Astro Condensers

Unit Total Balance Date Explanation Units Cost Cost in Units

1/1 Beginning inventory 100 $10 $ 1,000 100 4/15 Purchase 200 11 2,200 300 8/24 Purchase 300 12 3,600 600 9/10 Sale 550 50

11/27 Purchase 400 13 5,200 450

$12,000

Illustration 6A-1 Inventoriable units and costs

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 303

304 chapter 6 Reporting and Analyzing Inventory

The ending inventory in this situation is $5,800, and the cost of goods sold is $6,200 [(100 @ $10) � (200 @ $11) � (250 @ $12)].

The results under FIFO in a perpetual system are the same as in a periodic system. (See Illustration 6-5 on page 288 where, similarly, the ending inventory is $5,800 and cost of goods sold is $6,200.) Regardless of the system, the first costs in are the costs assigned to cost of goods sold.

LAST-IN, FIRST-OUT (LIFO)

Under the LIFO method using a perpetual system, the cost of the most recent purchase prior to sale is allocated to the units sold. Therefore, the cost of the goods sold on September 10 consists of all the units from the August 24 and April 15 purchases plus 50 of the units in beginning inventory. The ending in- ventory under the LIFO method is computed in Illustration 6A-3.

The use of LIFO in a perpetual system will usually produce cost allocations that differ from use of LIFO in a periodic system. In a perpetual system, the

Illustration 6A-2 Perpetual system—FIFO Date Purchases Cost of Goods Sold Balance

Jan. 1 (100 @ $10) $1,000 Apr. 15 (200 @ $11) $2,200 (100 @ $10)

(200 @ $11) $3,200

Aug. 24 (300 @ $12) $3,600 (100 @ $10) (200 @ $11) $6,800 (300 @ $12)

Sept. 10 (100 @ $10) (200 @ $11) (250 @ $12) ( 50 @ $12) $ 600

$6,200 Nov. 27 (400 @ $13) $5,200 ( 50 @ $12) $5,800

(400 @ $13)

}

}

}

⎧ ⎪ ⎪ ⎪ ⎨ ⎪ ⎪ ⎪ ⎩

FIRST-IN, FIRST-OUT (FIFO)

Under FIFO, the cost of the earliest goods on hand prior to each sale is charged to cost of goods sold. Therefore, the cost of goods sold on September 10 con- sists of the units on hand January 1 and the units purchased April 15 and August 24. Illustration 6A-2 shows the inventory under a FIFO method perpet- ual system.

Date Purchases Cost of Goods Sold Balance

Jan. 1 (100 @ $10) $1,000 Apr. 15 (200 @ $11) $2,200 (100 @ $10) $3,200

(200 @ $11) Aug. 24 (300 @ $12) $3,600 (100 @ $10)

(200 @ $11) $6,800 (300 @ $12)

Sept. 10 (300 @ $12) (200 @ $11)

(50 @ $10) (50 @ $10) $ 500

$6,300 Nov. 27 (400 @ $13) $5,200 (50 @ $10) $5,700

(400 @ $13)

Illustration 6A-3 Perpetual system—LIFO

}

}

}

⎧ ⎪ ⎪ ⎪ ⎨ ⎪ ⎪ ⎪ ⎩

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 304

latest units purchased prior to each sale are allocated to cost of goods sold. In contrast, in a periodic system, the latest units purchased during the period are allocated to cost of goods sold. Thus, when a purchase is made after the last sale, the LIFO periodic system will apply this purchase to the previous sale. See Illustration 6-8 (on page 290) where the proof shows the 400 units at $13 pur- chased on November 27 applied to the sale of 550 units on September 10.

As shown above, under the LIFO perpetual system the 400 units at $13 pur- chased on November 27 are all applied to the ending inventory.

The ending inventory in this LIFO perpetual illustration is $5,700 and cost of goods sold is $6,300. Compare this to the LIFO periodic illustration (Illustra- tion 6-7 on page 289) where the ending inventory is $5,000 and cost of goods sold is $7,000.

AVERAGE-COST

The average-cost method in a perpetual inventory system is called the moving- average method. Under this method, the company computes a new average after each purchase. The average cost is computed by dividing the cost of goods avail- able for sale by the units on hand. The average cost is then applied to: (1) the units sold, to determine the cost of goods sold, and (2) the remaining units on hand, to determine the ending inventory amount. Illustration 6A-4 shows the application of the average-cost method by Houston Electronics.

As indicated above, the company computes a new average each time it makes a purchase. On April 15, after 200 units are purchased for $2,200, a to- tal of 300 units costing $3,200 ($1,000 � $2,200) are on hand. The average unit cost is $10.667 ($3,200 � 300). On August 24, after 300 units are purchased for $3,600, a total of 600 units costing $6,800 ($1,000 � $2,200 � $3,600) are on hand at an average cost per unit of $11.333 ($6,800 � 600). Houston Electron- ics uses this unit cost of $11.333 in costing sales until another purchase is made, when the company computes a new unit cost. Accordingly, the unit cost of the 550 units sold on September 10 is $11.333, and the total cost of goods sold is $6,233. On November 27, following the purchase of 400 units for $5,200, there are 450 units on hand costing $5,767 ($567 � $5,200) with a new average cost of $12.816 ($5,767 � 450).

Compare this moving-average cost under the perpetual inventory system to Illustration 6-10 (on page 291) showing the weighted-average method under a periodic inventory system.

Summary of Study Objective for Appendix 6A 305

Date Purchases Cost of Goods Sold Balance

Jan. 1 (100 @ $10) $ 1,000 Apr. 15 (200 @ $11) $2,200 (300 @ $10.667) $ 3,200 Aug. 24 (300 @ $12) $3,600 (600 @ $11.333) $ 6,800 Sept. 10 (550 @ $11.333) (50 @ $11.333) $ 567

$6,233 Nov. 27 (400 @ $13) $5,200 (450 @ $12.816) $5,767

Illustration 6A-4 Perpetual system—average- cost method

Summary of Study Objective for Appendix 6A 7 Apply the inventory cost flow methods to perpetual in-

ventory records. Under FIFO, the cost of the earliest goods on hand prior to each sale is charged to cost of goods sold. Under LIFO, the cost of the most recent

purchase prior to sale is charged to cost of goods sold. Under the average-cost method, a new average cost is computed after each purchase.

study objective 8

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 305

306 chapter 6 Reporting and Analyzing Inventory

If beginning inventory is understated, cost of goods sold will be understated. If ending inventory is understated, cost of goods sold will be overstated. Illus- tration 6B-2 shows the effects of inventory errors on the current year’s income statement.

An error in the ending inventory of the current period will have a reverse effect on net income of the next accounting period. This is shown in Illus- tration 6B-3. Note that the understatement of ending inventory in 2011 results in an understatement of beginning inventory in 2012 and an overstatement of net income in 2012.

Over the two years, total net income is correct because the errors offset each other. Notice that total income using incorrect data is $35,000 ($22,000 � $13,000), which is the same as the total income of $35,000 ($25,000 � $10,000) using correct data. Also note in this example that an error in the beginning in- ventory does not result in a corresponding error in the ending inventory for that period. The correctness of the ending inventory depends entirely on the accu- racy of taking and costing the inventory at the balance sheet date under the pe- riodic inventory system.

Unfortunately, errors occasionally occur in accounting for inventory. In some cases, errors are caused by failure to count or price the inventory correctly. In other cases, errors occur because companies do not properly recognize the trans- fer of legal title to goods that are in transit. When inventory errors occur, they affect both the income statement and the balance sheet.

INCOME STATEMENT EFFECTS

Under a periodic inventory system, both the beginning and ending invento- ries appear in the income statement. The ending inventory of one period automatically becomes the beginning inventory of the next period. Thus, in- ventory errors affect the computation of cost of goods sold and net income in two periods.

The effects on cost of goods sold can be computed by entering incorrect data in the formula in Illustration 6B-1 and then substituting the correct data.

appendix 6B

Inventory Errors

Indicate the effects of inventory errors on the financial statements.

study objective 8

Beginning Cost of

Ending Cost of

Inventory � Goods �

Inventory = Goods

Purchased Sold

Illustration 6B-1 Formula for cost of goods sold

Cost of Inventory Error Goods Sold Net Income

Beginning inventory understated Understated Overstated Beginning inventory overstated Overstated Understated Ending inventory understated Overstated Understated Ending inventory overstated Understated Overstated

Illustration 6B-2 Effects of inventory errors on current year’s income statement

Ethics Note Inventory fraud increases during recessions. Such fraud includes pricing inventory at amounts in excess of its actual value, or claiming to have inventory when no inventory exists. Inventory fraud is usually done to overstate ending inventory, thereby understating cost of goods sold and creating higher income.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 306

BALANCE SHEET EFFECTS

The effect of ending inventory errors on the balance sheet can be determined by using the basic accounting equation: Assets � Liabilities � Stockholders’ equity. Errors in the ending inventory have the effects shown in Illustration 6B-4.

The effect of an error in ending inventory on the subsequent period was shown in Illustration 6B-3. Recall that if the error is not corrected, the combined total net income for the two periods would be correct. Thus, total stockholders’ equity reported on the balance sheet at the end of 2012 will also be correct.

Summary of Study Objective for Appendix 6B 307

SAMPLE COMPANY Condensed Income Statements

Illustration 6B-3 Effects of inventory errors on two years’ income statements

2011 2012 Incorrect Correct Incorrect Correct

Sales revenue $80,000 $80,000 $90,000 $90,000 Beginning inventory $20,000 $20,000 $12,000 $15,000 Cost of goods purchased 40,000 40,000 68,000 68,000

Cost of goods available for sale 60,000 60,000 80,000 83,000 Ending inventory 12,000 15,000 23,000 23,000

Cost of goods sold 48,000 45,000 57,000 60,000

Gross profit 32,000 35,000 33,000 30,000 Operating expenses 10,000 10,000 20,000 20,000

Net income $22,000 $25,000 $13,000 $10,000

$(3,000) $3,000 Net income Net income understated overstated

The errors cancel. Thus, the combined total income for the 2-year period is correct.

Ending Inventory Error Assets Liabilities Stockholders’ Equity

Overstated Overstated No effect Overstated Understated Understated No effect Understated

Illustration 6B-4 Effects of ending inventory errors on balance sheet

Summary of Study Objective for Appendix 6B 8 Indicate the effects of inventory errors on the financial

statements. In the income statement of the current year: (1) An error in beginning inventory will have a reverse effect on net income (e.g., overstatement of in- ventory results in understatement of net income, and vice versa). (2) An error in ending inventory will have a similar effect on net income (e.g., overstatement of inventory results in overstatement of net income). If

ending inventory errors are not corrected in the fol- lowing period, their effect on net income for that pe- riod is reversed, and total net income for the two years will be correct.

In the balance sheet: Ending inventory errors will have the same effect on total assets and total stock- holders’ equity and no effect on liabilities.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 307

308 chapter 6 Reporting and Analyzing Inventory

Glossary Average-cost method (p. 290) An inventory costing method that uses the weighted-average unit cost to allo- cate the cost of goods available for sale to ending inven- tory and cost of goods sold.

Consigned goods (p. 284) Goods held for sale by one party although ownership of the goods is retained by an- other party.

Current replacement cost (p. 295) The cost of pur- chasing the same goods at the present time from the usual suppliers in the usual quantities.

Days in inventory (p. 297) Measure of the average number of days inventory is held; calculated as 365 di- vided by inventory turnover ratio.

Finished goods inventory (p. 282) Manufactured items that are completed and ready for sale.

First-in, first-out (FIFO) method (p. 288) An inven- tory costing method that assumes that the earliest goods purchased are the first to be sold.

FOB destination (p. 284) Freight terms indicating that ownership of goods remains with the seller until the goods reach the buyer.

FOB shipping point (p. 284) Freight terms indicating that ownership of goods passes to the buyer when the public carrier accepts the goods from the seller.

Inventory turnover ratio (p. 296) A ratio that measures the liquidity of inventory by measuring the number of times average inventory sold during the period; computed by dividing cost of goods sold by the average inventory during the period.

Just-in-time (JIT) inventory (p. 283) Inventory system in which companies manufacture or purchase goods just in time for use.

Last-in, first-out (LIFO) method (p. 289) An inven- tory costing method that assumes that the latest units purchased are the first to be sold.

LIFO reserve (p. 299) For a company using LIFO, the difference between inventory reported using LIFO and inventory using FIFO.

Lower-of-cost-or-market (LCM) (p. 295) A basis whereby inventory is stated at the lower of either its cost or its market value as determined by current replacement cost.

Raw materials (p. 282) Basic goods that will be used in production but have not yet been placed in production.

Specific identification method (p. 286) An actual physical flow costing method in which items sold and items still in inventory are specifically costed to arrive at cost of goods sold and ending inventory.

Weighted-average unit cost (p. 290) Average cost that is weighted by the number of units purchased at each unit cost.

Work in process (p. 282) That portion of manufac- tured inventory that has begun the production process but is not yet complete.

Comprehensive

Englehart Company has the following inventory, purchases, and sales data for the month of March.

Inventory, March 1 200 units @ $4.00 $ 800 Purchases

March 10 500 units @ $4.50 2,250 March 20 400 units @ $4.75 1,900 March 30 300 units @ $5.00 1,500

Sales March 15 500 units March 25 400 units

The physical inventory count on March 31 shows 500 units on hand.

Instructions Under a periodic inventory system, determine the cost of inventory on hand at March 31 and the cost of goods sold for March under (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the average-cost method. (For average-cost, carry cost per unit to three decimal places.)

Do it!

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 308

Self-Test, Brief Exercises, Exercises, Problem Set A, and many more resources are available for practice in WileyPLUS

Self-Test Questions 309

Solution to Comprehensive Do it! Action Plan

• For FIFO, allocate the latest costs to inventory.

• For LIFO, allocate the earliest costs to inventory.

• For average-cost, use a weighted average.

• Remember, the costs allocated to cost of goods sold can be proved.

• Total purchases are the same under all three cost flow assumptions.

The cost of goods available for sale is $6,450:

Inventory Purchases 200 units @ $4.00 $ 800 March 10 500 units @ $4.50 2,250 March 20 400 units @ $4.75 1,900 March 30 300 units @ $5.00 1,500

Total cost of goods available for sale $6,450

(a) FIFO Method Ending inventory:

Date Units Unit Cost Total Cost

Mar. 30 300 $5.00 $1,500 Mar. 20 200 4.75 950 $2,450

Cost of goods sold: $6,450 � $2,450 � $4,000

(b) LIFO Method Ending inventory:

Date Units Unit Cost Total Cost

Mar. 1 200 $4.00 $ 800 Mar. 10 300 4.50 1,350 $2,150

Cost of goods sold: $6,450 � $2,150 � $4,300

(c) Average-Cost Method

Weighted-average unit cost: $6,450 � 1,400 � $4.607 Ending inventory: 500 � $4.607 � $2,303.50

Cost of goods sold: $6,450 � $2,303.50 � $4,146.50

Note: All Questions, Exercises, and Problems marked with an asterisk relate to material in the appendices to the chapter.

Self-Test Questions Answers are on page 330.

1. When is a physical inventory usually taken? (a) When the company has its greatest amount of in-

ventory. (b) When a limited number of goods are being sold

or received. (c) At the end of the company’s fiscal year. (d) Both (b) and (c).

2. Which of the following should not be included in the physical inventory of a company? (a) Goods held on consignment from another

company.

(b) Goods shipped on consignment to another company.

(c) Goods in transit from another company shipped FOB shipping point.

(d) All of the above should be included.

3. As a result of a thorough physical inventory, Railway Company determined that it had inventory worth $180,000 at December 31, 2012. This count did not take into consideration the following facts: Rogers Consignment store currently has goods worth $35,000 on its sales floor that belong to Railway but

(SO 1)

(SO 1)

(SO 1)

c06ReportingandAnalyzingInventory.qxd 10/12/10 11:39 AM Page 309

310 chapter 6 Reporting and Analyzing Inventory

are being sold on consignment by Rogers. The selling price of these goods is $50,000. Railway purchased $13,000 of goods that were shipped on December 27, FOB destination, that will be received by Railway on January 3. Determine the correct amount of inven- tory that Railway should report. (a) $230,000. (b) $215,000. (c) $228,000. (d) $193,000.

4. Kam Company has the following units and costs.

Units Unit Cost

Inventory, Jan. 1 8,000 $11 Purchase, June 19 13,000 12 Purchase, Nov. 8 5,000 13

If 9,000 units are on hand at December 31, what is the cost of the ending inventory under FIFO? (a) $99,000. (c) $113,000. (b) $108,000. (d) $117,000.

5. From the data in question 4, what is the cost of the ending inventory under LIFO? (a) $113,000. (c) $99,000. (b) $108,000. (d) $100,000.

6. Davidson Electronics has the following:

Units Unit Cost

Inventory, Jan. 1 5,000 $ 8 Purchase, April 2 15,000 10 Purchase, Aug. 28 20,000 12

If Davidson has 7,000 units on hand at December 31, the cost of ending inventory under the average-cost method is: (a) $84,000. (c) $56,000. (b) $70,000. (d) $75,250.

7. In periods of rising prices, LIFO will produce: (a) higher net income than FIFO. (b) the same net income as FIFO. (c) lower net income than FIFO. (d) higher net income than average-cost.

8. Considerations that affect the selection of an inven- tory costing method do not include: (a) tax effects. (b) balance sheet effects. (c) income statement effects. (d) perpetual versus periodic inventory system.

9. The lower-of-cost-or-market rule for inventory is an example of the application of: (a) the conservatism constraint. (b) the historical cost principle. (c) the materiality constraint. (d) the economic entity assumption.

10. Which of these would cause the inventory turnover ratio to increase the most?

(a) Increasing the amount of inventory on hand. (b) Keeping the amount of inventory on hand con-

stant but increasing sales. (c) Keeping the amount of inventory on hand con-

stant but decreasing sales. (d) Decreasing the amount of inventory on hand and

increasing sales.

11. Carlos Company had beginning inventory of $80,000, ending inventory of $110,000, cost of goods sold of $285,000, and sales of $475,000. Carlos’s days in inventory is: (a) 73 days. (b) 121.7 days. (c) 102.5 days. (d) 84.5 days.

12. The LIFO reserve is: (a) the difference between the value of the inventory

under LIFO and the value under FIFO. (b) an amount used to adjust inventory to the lower-

of-cost-or-market. (c) the difference between the value of the inventory

under LIFO and the value under average-cost. (d) an amount used to adjust inventory to historical

cost.

*13. In a perpetual inventory system, (a) LIFO cost of goods sold will be the same as in a

periodic inventory system. (b) average costs are based entirely on unit-cost sim-

ple averages. (c) a new average is computed under the average-cost

method after each sale. (d) FIFO cost of goods sold will be the same as in a

periodic inventory system.

*14. Fran Company’s ending inventory is understated by $4,000. The effects of this error on the current year’s cost of goods sold and net income, respectively, are: (a) understated and overstated. (b) overstated and understated. (c) overstated and overstated. (d) understated and understated.

*15. Harold Company overstated its inventory by $15,000 at December 31, 2012. It did not correct the error in 2012 or 2013. As a result, Harold’s stockholders’ equity was: (a) overstated at December 31, 2012, and under-

stated at December 31, 2013. (b) overstated at December 31, 2012, and properly

stated at December 31, 2013. (c) understated at December 31, 2012, and under-

stated at December 31, 2013. (d) overstated at December 31, 2012, and overstated

at December 31, 2013.

Go to the book’s companion website, www. wiley.com/college/kimmel, to access addi- tional Self-Test Questions.

(SO 2)

(SO 2)

(SO 2)

(SO 3)

(SO 3)

(SO 4)

(SO 5)

(SO 5)

(SO 6)

(SO 7)

(SO 8)

(SO 4)

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 310

Questions 311

Questions 1. “The key to successful business operations is effec-

tive inventory management.” Do you agree? Explain.

2. An item must possess two characteristics to be classified as inventory. What are these two character- istics?

3. What is just-in-time inventory management? What are its potential advantages?

4. Your friend Sara Hovey has been hired to help take the physical inventory in Malaby’s Hardware Store. Explain to Sara what this job will entail.

5. (a) Brandt Company ships merchandise to England Corporation on December 30. The merchandise reaches the buyer on January 5. Indicate the terms of sale that will result in the goods being included in (1) Brandt’s December 31 inventory and (2) England’s December 31 inventory.

(b) Under what circumstances should Brandt Com- pany include consigned goods in its inventory?

6. Katz Hat Shop received a shipment of hats for which it paid the wholesaler $2,940. The price of the hats was $3,000, but Katz was given a $60 cash discount and required to pay freight charges of $75. What amount should Katz include in inventory? Why?

7. What is the primary basis of accounting for invento- ries? What is the major objective in accounting for inventories?

8. Brad Watters believes that the allocation of cost of goods available for sale should be based on the ac- tual physical flow of the goods. Explain to Brad why this may be both impractical and inappropriate.

9. What is the major advantage and major disadvantage of the specific identification method of inventory costing?

10. “The selection of an inventory cost flow method is a decision made by accountants.” Do you agree? Explain. Once a method has been selected, what accounting requirement applies?

11. Which assumed inventory cost flow method: (a) usually parallels the actual physical flow of mer-

chandise? (b) divides cost of goods available for sale by total

units available for sale to determine a unit cost? (c) assumes that the latest units purchased are the

first to be sold?

12. In a period of rising prices, the inventory reported in King Company’s balance sheet is close to the current cost of the inventory, whereas Ritchie Company’s in- ventory is considerably below its current cost. Identify the inventory cost flow method used by each company. Which company probably has been reporting the higher gross profit?

13. Azenabor Corporation has been using the FIFO cost flow method during a prolonged period of inflation. During the same time period, Azenabor has been pay-

ing out all of its net income as dividends. What ad- verse effects may result from this policy?

14. Thomas Holme, a mid-level product manager for Dorothy’s Shoes, thinks his company should switch from LIFO to FIFO. He says, “My bonus is based on net income. If we switch it will increase net income and increase my bonus. The company would be bet- ter off and so would I.” Is he correct? Explain.

15. Discuss the impact the use of LIFO has on taxes paid, cash flows, and the quality of earnings ratio relative to the impact of FIFO when prices are increasing.

16. What inventory cost flow method does Toot- sie Roll Industries use for U.S. inventories? What method does it use for foreign inventories? (Hint: You will need to examine the notes for Tootsie Roll’s financial statements.) Why does it use a different method for foreign inventories?

17. Olivia Dietz is studying for the next accounting midterm examination. What should Olivia know about (a) departing from the cost basis of account- ing for inventories and (b) the meaning of “market” in the lower-of-cost-or-market method?

18. Cataldi Music Center has five TVs on hand at the balance sheet date that cost $400 each. The current replacement cost is $350 per unit. Under the lower- of-cost-or-market basis of accounting for inventories, what value should Cataldi report for the TVs on the balance sheet? Why?

19. What cost flow assumption may be used under the lower-of-cost-or-market basis of account- ing for inventories?

20. Why is it inappropriate for a company to include freight-out expense in the Cost of Goods Sold account?

21. Berges Company’s balance sheet shows Inventory $162,800. What additional disclosures should be made?

22. Under what circumstances might the inventory turnover ratio be too high—that is, what possible negative consequences might occur?

23. What is the LIFO reserve? What are the consequences of ignoring a large LIFO reserve when analyzing a company?

*24. “When perpetual inventory records are kept, the re- sults under the FIFO and LIFO methods are the same as they would be in a periodic inventory system.” Do you agree? Explain.

*25. How does the average-cost method of inventory costing differ between a perpetual inventory system and a periodic inventory system?

*26. Nicholas Company discovers in 2012 that its ending inventory at December 31, 2011, was $5,000 under- stated. What effect will this error have on (a) 2011 net income, (b) 2012 net income, and (c) the com- bined net income for the 2 years?

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 311

312 chapter 6 Reporting and Analyzing Inventory

Brief Exercises BE6-1 Susan Cashin Company identifies the following items for possible inclusion in the physical inventory. Indicate whether each item should be included or excluded from the inventory taking. (a) 900 units of inventory shipped on consignment by Cashin to another company. (b) 3,000 units of inventory in transit from a supplier shipped FOB destination. (c) 1,200 units of inventory sold but being held for customer pickup. (d) 500 units of inventory held on consignment from another company.

BE6-2 In its first month of operations, Cisler Company made three purchases of mer- chandise in the following sequence: (1) 300 units at $6, (2) 400 units at $8, and (3) 500 units at $9. Assuming there are 200 units on hand at the end of the period, compute the cost of the ending inventory under (a) the FIFO method and (b) the LIFO method. Cisler uses a periodic inventory system.

BE6-3 Data for Cisler Company are presented in BE6-2. Compute the cost of the end- ing inventory under the average-cost method, assuming there are 300 units on hand. (Round the cost per unit to three decimal places.)

BE6-4 The management of Easterling Corp. is considering the effects of various inven- tory-costing methods on its financial statements and its income tax expense. Assuming that the price the company pays for inventory is increasing, which method will: (a) provide the highest net income? (b) provide the highest ending inventory? (c) result in the lowest income tax expense? (d) result in the most stable earnings over a number of years?

BE6-5 In its first month of operation, Moraine Company purchased 100 units of inven- tory for $6, then 200 units for $7, and finally 140 units for $8. At the end of the month, 180 units remained. Compute the amount of phantom profit that would result if the com- pany used FIFO rather than LIFO. Explain why this amount is referred to as phantom profit. The company uses the periodic method.

BE6-6 For each of the following cases, state whether the statement is true for LIFO or for FIFO. Assume that prices are rising. (a) Results in a higher quality of earnings ratio. (b) Results in higher phantom profits. (c) Results in higher net income. (d) Results in lower taxes. (e) Results in lower net cash provided by operating activities.

BE6-7 Olsson Video Center accumulates the following cost and market data at December 31.

Inventory Cost Market Categories Data Data

Cameras $12,500 $13,400 Camcorders 9,000 9,500 DVDs 13,000 12,200

Compute the lower-of-cost-or-market valuation for Olsson inventory.

BE6-8 At December 31 of a recent year, the following information (in thousands) was available for sunglasses manufacturer Oakley, Inc.: ending inventory $155,377; beginning inventory $119,035; cost of goods sold $349,114; and sales revenue $761,865. Calculate the inventory turnover ratio and days in inventory for Oakley, Inc.

BE6-9 Winnebago Industries, Inc. is a leading manufacturer of motor homes. Win- nebago reported ending inventory at August 29, 2009, of $46,850,000 under the LIFO inventory method. In the notes to its financial statements, Winnebago reported a LIFO reserve of $30,346,000 at August 29, 2009. What would Winnebago Industries’ ending in- ventory have been if it had used FIFO?

*BE6-10 Dewey’s Department Store uses a perpetual inventory system. Data for product E2-D2 include the purchases shown on page 313.

Identify items to be included in taking a physical inventory.

(SO 1), C

Compute ending inventory using FIFO and LIFO.

(SO 2), AP

Compute the ending inventory using average-cost.

(SO 2), AP

Explain the financial statement effect of inventory cost flow assumptions.

(SO 3), C

Explain the financial statement effect of inventory cost flow assumptions.

(SO 3), AP

Identify the impact of LIFO versus FIFO.

(SO 3), C

Determine the LCM valuation.

(SO 4), AP

Compute inventory turnover ratio and days in inventory.

(SO 5), AP

Determine ending inventory and cost of goods sold using LIFO reserve.

(SO 6), C

Apply cost flow methods to perpetual inventory records.

(SO 7), AP

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 312

Do it! Review 313

Number Unit Date of Units Price

May 7 50 $10 July 28 30 15

On June 1, Dewey sold 25 units, and on August 27, 30 more units. Compute the cost of goods sold using (1) FIFO, (2) LIFO, and (3) average-cost. (Round the cost per unit to three decimal places.)

*BE6-11 Roskopf Company reports net income of $92,000 in 2012. However, ending in- ventory was understated by $7,000. What is the correct net income for 2012? What ef- fect, if any, will this error have on total assets as reported in the balance sheet at Decem- ber 31, 2012?

Determine correct financial statement amount.

(SO 8), AN

6-1 Newell Company just took its physical inventory. The count of inventory items on hand at the company’s business locations resulted in a total inventory cost of $300,000. In reviewing the details of the count and related inventory transactions, you have discovered the following items that had not been considered.

1. Newell has sent inventory costing $28,000 on consignment to Victoria Company. All of this inventory was at Victoria’s showrooms on December 31.

2. The company did not include in the count inventory (cost, $20,000) that was sold on December 28, terms FOB shipping point. The goods were in transit on December 31.

3. The company did not include in the count inventory (cost, $13,000) that was pur- chased with terms of FOB shipping point. The goods were in transit on December 31.

Compute the correct December 31 inventory.

6-2 The accounting records of Orth Electronics show the following data.

Beginning inventory 3,000 units at $5 Purchases 8,000 units at $7 Sales 9,400 units at $10

Determine cost of goods sold during the period under a periodic inventory system using (a) the FIFO method, (b) the LIFO method, and (c) the average-cost method. (Round unit cost to three decimal places.)

6-3 Bardell Company sells three different categories of tools (small, medium and large). The cost and market value of its inventory of tools are as follows.

Cost Market

Small $ 64,000 $ 61,000 Medium 290,000 260,000 Large 152,000 167,000

Determine the value of the company’s inventory under the lower-of-cost-or-market approach.

6-4 Early in 2012, Aragon Company switched to a just-in-time inventory sys- tem. Its sales and inventory amounts for 2011 and 2012 are shown below.

2011 2012

Sales revenue $3,120,000 $3,713,000 Cost of goods sold 1,200,000 1,425,000 Beginning inventory 170,000 210,000 Ending inventory 210,000 90,000

Determine the inventory turnover and days in inventory for 2011 and 2012. Discuss the changes in the amount of inventory, the inventory turnover and days in inventory, and the amount of sales across the two years.

Do it!

Do it!

Do it!

Do it! Apply rules of ownership to determine inventory cost.

(SO 1), AN

Compute cost of goods sold under different cost flow methods.

(SO 2), AP

Compute inventory value under LCM.

(SO 4), AP

Compute inventory turnover ratio and assess inventory level.

(SO 5), AN

ReviewDo it!

c06ReportingandAnalyzingInventory.qxd 8/19/10 8:43 AM Page 313

314 chapter 6 Reporting and Analyzing Inventory

Exercises E6-1 Worthmore Bank and Trust is considering giving Madsen Company a loan. Be- fore doing so, it decides that further discussions with Madsen’s accountant may be de- sirable. One area of particular concern is the Inventory account, which has a year-end balance of $275,000. Discussions with the accountant reveal the following.

1. Madsen sold goods costing $55,000 to Allen Company FOB shipping point on Decem- ber 28. The goods are not expected to reach Allen until January 12. The goods were not included in the physical inventory because they were not in the warehouse.

2. The physical count of the inventory did not include goods costing $95,000 that were shipped to Madsen FOB destination on December 27 and were still in transit at year-end.

3. Madsen received goods costing $25,000 on January 2. The goods were shipped FOB shipping point on December 26 by Lynch Co. The goods were not included in the physical count.

4. Madsen sold goods costing $51,000 to Finet of Canada FOB destination on Decem- ber 30. The goods were received in Canada on January 8. They were not included in Madsen’s physical inventory.

5. Madsen received goods costing $42,000 on January 2 that were shipped FOB desti- nation on December 29. The shipment was a rush order that was supposed to arrive December 31. This purchase was included in the ending inventory of $275,000.

Instructions Determine the correct inventory amount on December 31.

E6-2 Jerry Karron, an auditor with Joshi CPAs, is performing a review of Duncan Company’s Inventory account. Duncan did not have a good year, and top management is under pressure to boost reported income. According to its records, the inventory balance at year-end was $740,000. However, the following information was not considered when determining that amount.

1. Included in the company’s count were goods with a cost of $228,000 that the com- pany is holding on consignment. The goods belong to Arnold Corporation.

2. The physical count did not include goods purchased by Duncan with a cost of $40,000 that were shipped FOB shipping point on December 28 and did not arrive at Duncan’s warehouse until January 3.

3. Included in the Inventory account was $17,000 of office supplies that were stored in the warehouse and were to be used by the company’s supervisors and managers dur- ing the coming year.

4. The company received an order on December 29 that was boxed and was sitting on the loading dock awaiting pick-up on December 31. The shipper picked up the goods on January 1 and delivered them on January 6. The shipping terms were FOB ship- ping point. The goods had a selling price of $40,000 and a cost of $29,000. The goods were not included in the count because they were sitting on the dock.

5. On December 29, Duncan shipped goods with a selling price of $80,000 and a cost of $50,000 to Siebring Sales Corporation FOB shipping point. The goods arrived on January 3. Siebring Sales had only ordered goods with a selling price of $10,000 and a cost of $6,000. However, a sales manager at Duncan had authorized the shipment and said that if Siebring wanted to ship the goods back next week, it could.

6. Included in the count was $50,000 of goods that were parts for a machine that the company no longer made. Given the high-tech nature of Duncan’s products, it was unlikely that these obsolete parts had any other use. However, management would prefer to keep them on the books at cost, “since that is what we paid for them, after all.”

Instructions Prepare a schedule to determine the correct inventory amount. Provide explanations for each item above, stating why you did or did not make an adjustment for each item.

E6-3 Trinh Inc. had the following inventory situations to consider at January 31, its year-end. (a) Goods held on consignment for MailBoxes Corp. since December 12. (b) Goods shipped on consignment to Reddy Holdings Inc. on January 5. (c) Goods shipped to a customer, FOB destination, on January 29 that are still in transit.

Determine the correct inventory amount.

(SO 1), AN

Determine the correct inventory amount.

(SO 1), AN

Identify items in inventory.

(SO 1), K

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 314

Exercises 315

(d) Goods shipped to a customer, FOB shipping point, on January 29 that are still in transit.

(e) Goods purchased FOB destination from a supplier on January 25, that are still in transit.

(f) Goods purchased FOB shipping point from a supplier on January 25, that are still in transit.

(g) Office supplies on hand at January 31.

Instructions Identify which of the preceding items should be included in inventory. If the item should not be included in inventory, state in what account, if any, it should have been recorded.

E6-4 Sunburst sells a snowboard, Xpert, that is popular with snowboard enthusiasts. Below is information relating to Sunburst’s purchases of Xpert snowboards during September. During the same month, 116 Xpert snowboards were sold. Sunburst uses a periodic inventory system.

Date Explanation Units Unit Cost Total Cost

Sept. 1 Inventory 12 $100 $ 1,200 Sept. 12 Purchases 45 103 4,635 Sept. 19 Purchases 20 104 2,080 Sept. 26 Purchases 50 105 5,250

Totals 127 $13,165

Instructions (a) Compute the ending inventory at September 30 using the FIFO and LIFO methods.

Prove the amount allocated to cost of goods sold under each method. (b) For both FIFO and LIFO, calculate the sum of ending inventory and cost of goods

sold. What do you notice about the answers you found for each method?

E6-5 Klumb Inc. uses a periodic inventory system. Its records show the following for the month of May, in which 74 units were sold.

Date Explanation Units Unit Cost Total Cost

May 1 Inventory 30 $ 9 $270 15 Purchase 25 10 250 24 Purchase 38 11 418

Total 93 $938

Instructions Calculate the ending inventory at May 31 using the (a) FIFO, (b) average-cost, and (c) LIFO methods. (For average-cost, round the average unit cost to three decimal places.) Prove the amount allocated to cost of goods sold under each method.

E6-6 On December 1, LoPrice Electronics has three DVD players left in stock. All are identical, all are priced to sell at $85. One of the three DVD players left in stock, with se- rial #1012, was purchased on June 1 at a cost of $52. Another, with serial #1045, was pur- chased on November 1 for $48. The last player, serial #1056, was purchased on Novem- ber 30 for $40.

Instructions (a) Calculate the cost of goods sold using the FIFO periodic inventory method, assuming

that two of the three players were sold by the end of December, LoPrice Electronics’ year-end.

(b) If LoPrice Electronics used the specific identification method instead of the FIFO method, how might it alter its earnings by “selectively choosing” which particular players to sell to the two customers? What would LoPrice’s cost of goods sold be if the company wished to minimize earnings? Maximize earnings?

(c) Which inventory method, FIFO or specific identification, do you recommend that LoPrice use? Explain why.

Compute inventory and cost of goods sold using periodic FIFO and LIFO.

(SO 2), AN

Calculate inventory and cost of goods sold using FIFO, average-cost, and LIFO in a periodic inventory system.

(SO 2), AP

Calculate cost of goods sold using specific identification and FIFO periodic.

(SO 2, 3), AN

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 315

316 chapter 6 Reporting and Analyzing Inventory

E6-7 Kuchin Company reports the following for the month of June.

Instructions (a) Compute the cost of the ending inventory and the cost of goods sold under (1) FIFO,

(2) LIFO, and (3) average-cost. (b) Which costing method gives the highest ending inventory? The highest cost of goods

sold? Why? (c) How do the average-cost values for ending inventory and cost of goods sold relate to

ending inventory and cost of goods sold for FIFO and LIFO? (d) Explain why the average cost is not $6.

E6-8 The following comparative information is available for Prasad Company for 2012.

Date Explanation Units Unit Cost Total Cost

June 1 Inventory 120 $5 $ 600 12 Purchase 370 6 2,220 23 Purchase 500 7 3,500 30 Inventory 240

LIFO FIFO

Sales revenue $86,000 $86,000 Cost of goods sold 38,000 29,000 Operating expenses

(including depreciation) 27,000 27,000 Depreciation 10,000 10,000 Cash paid for inventory purchases 32,000 32,000

Instructions (a) Determine net income under each approach. Assume a 30% tax rate. (b) Determine net cash provided by operating activities under each approach. Assume

that all sales were on a cash basis and that income taxes and operating expenses, other than depreciation, were on a cash basis.

(c) Calculate the quality of earnings ratio under each approach and explain your findings.

E6-9 Laib Camera Shop Inc. uses the lower-of-cost-or-market basis for its inventory. The following data are available at December 31.

Market Units Cost/Unit Value/Unit

Cameras Minolta 5 $170 $158 Canon 7 145 152

Light Meters Vivitar 12 125 114 Kodak 10 120 135

E6-10 This information is available for PepsiCo, Inc. for 2007, 2008, and 2009.

(in millions) 2007 2008 2009

Beginning inventory $ 1,926 $ 2,290 $ 2,522 Ending inventory 2,290 2,522 2,618 Cost of goods sold 18,038 20,351 20,099 Sales revenue 39,474 43,251 43,232

Instructions What amount should be reported on Laib Camera Shop’s financial statements, assuming the lower-of-cost-or-market rule is applied?

Compute inventory and cost of goods sold using periodic FIFO, LIFO, and average- cost.

(SO 2, 3), AP

Evaluate impact of LIFO and FIFO on cash flows and earnings quality.

(SO 3), AP

Determine LCM valuation.

(SO 4), AP

Compute inventory turnover ratio, days in inventory, and gross profit rate.

(SO 5), AP

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 316

Exercises 317

Instructions Calculate the inventory turnover ratio, days in inventory, and gross profit rate for PepsiCo., Inc. for 2007, 2008, and 2009. Comment on any trends.

E6-11 Deere & Company is a global manufacturer and distributor of agricultural, con- struction, and forestry equipment. It reported the following information in its 2009 an- nual report.

(in millions) 2009 2008

Inventories (LIFO) $ 2,397 3,042 Current assets 30,857 Current liabilities 12,753 LIFO reserve 1,367 Cost of goods sold 16,255

Instructions (a) Compute Deere’s inventory turnover ratio and days in inventory for 2009. (b) Compute Deere’s current ratio using the 2009 data as presented, and then again af-

ter adjusting for the LIFO reserve. (c) Comment on how ignoring the LIFO reserve might affect your evaluation of Deere’s

liquidity.

*E6-12 Inventory data for Kuchin Company are presented in E6-7.

Instructions (a) Calculate the cost of the ending inventory and the cost of goods sold for each cost

flow assumption, using a perpetual inventory system. Assume a sale of 410 units oc- curred on June 15 for a selling price of $8 and a sale of 340 units on June 27 for $9. (Note: For the moving-average method, round unit cost to three decimal places.)

(b) How do the results differ from E6-7? (c) Why is the average unit cost not $6 [($5 � $6 � $7) � 3 � $6]?

*E6-13 Information about Sunburst is presented in E6-4. Additional data regarding the company’s sales of Xpert snowboards are provided below. Assume that Sunburst uses a perpetual inventory system.

Date Units

Sept. 5 Sale 8 Sept. 16 Sale 48 Sept. 29 Sale 60

Totals 116

Instructions Compute ending inventory at September 30 using FIFO, LIFO, and moving-average. (Note: For moving-average, round unit cost to three decimal places.)

*E6-14 Brooks Hardware reported cost of goods sold as follows.

2012 2011

Beginning inventory $ 30,000 $ 20,000 Cost of goods purchased 175,000 164,000

Cost of goods available for sale 205,000 184,000 Less: Ending inventory 37,000 30,000

Cost of goods sold $168,000 $154,000

Determine the effect of the LIFO reserve on current ratio.

(SO 5, 6), AP

Calculate inventory and cost of goods sold using three cost flow methods in a perpetual inventory system.

(SO 7), AP

Apply cost flow methods to perpetual records.

(SO 7), AP

Determine effects of inventory errors.

(SO 8), AN

Brooks made two errors: 1. 2011 ending inventory was overstated by $2,000. 2. 2012 ending inventory was understated by $5,000.

Instructions

Compute the correct cost of goods sold for each year.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 317

318 chapter 6 Reporting and Analyzing Inventory

*E6-15 Sprague Company reported these income statement data for a 2-year period.

2012 2011

Sales revenue $250,000 $210,000

Beginning inventory 40,000 32,000 Cost of goods purchased 202,000 173,000

Cost of goods available for sale 242,000 205,000 Less: Ending inventory 55,000 40,000

Cost of goods sold 187,000 165,000

Gross profit $ 63,000 $ 45,000

Sprague Company uses a periodic inventory system. The inventories at January 1, 2011, and December 31, 2012, are correct. However, the ending inventory at December 31, 2011, is overstated by $8,000.

Instructions (a) Prepare correct income statement data for the 2 years. (b) What is the cumulative effect of the inventory error on total gross profit for the 2 years? (c) Explain in a letter to the president of Sprague Company what has happened—that is,

the nature of the error and its effect on the financial statements.

Prepare correct income statements.

(SO 8), AN

Exercises: Set B and Challenge Exercises Visit the book’s companion website, at www.wiley.com/college/kimmel, and choose the Student Companion site to access Exercise Set B and Challenge Exercises.

Problems: Set A P6-1A Kirk Limited is trying to determine the value of its ending inventory as of February 28, 2012, the company’s year-end. The accountant counted everything that was in the warehouse, as of February 28, which resulted in an ending inventory valuation of $48,000. However, she didn’t know how to treat the following transactions so she didn’t record them. (a) On February 26, Kirk shipped to a customer goods costing $800. The goods were

shipped FOB shipping point, and the receiving report indicates that the customer re- ceived the goods on March 2.

(b) On February 26, Seller Inc. shipped goods to Kirk FOB destination. The invoice price was $350 plus $25 for freight. The receiving report indicates that the goods were re- ceived by Kirk on March 2.

(c) Kirk had $500 of inventory at a customer’s warehouse “on approval.” The customer was going to let Kirk know whether it wanted the merchandise by the end of the week, March 4.

(d) Kirk also had $400 of inventory at a Balena craft shop, on consignment from Kirk. (e) On February 26, Kirk ordered goods costing $750. The goods were shipped FOB ship-

ping point on February 27. Kirk received the goods on March 1. (f) On February 28, Kirk packaged goods and had them ready for shipping to a cus-

tomer FOB destination. The invoice price was $350 plus $25 for freight; the cost of the items was $280. The receiving report indicates that the goods were received by the customer on March 2.

(g) Kirk had damaged goods set aside in the warehouse because they are no longer saleable. These goods originally cost $400 and, originally, Kirk expected to sell these items for $600.

Determine items and amounts to be recorded in inventory.

(SO 1), AN

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 318

Problems: Set A 319

Instructions For each of the above transactions, specify whether the item in question should be in- cluded in ending inventory, and if so, at what amount. For each item that is not included in ending inventory, indicate who owns it and what account, if any, it should have been recorded in.

P6-2A Turner Distribution markets CDs of numerous performing artists. At the begin- ning of March, Turner had in beginning inventory 2,500 CDs with a unit cost of $7. Dur- ing March, Turner made the following purchases of CDs.

March 5 2,000 @ $8 March 21 5,000 @ $10 March 13 3,500 @ $9 March 26 2,000 @ $11

During March 12,000 units were sold. Turner uses a periodic inventory system.

Instructions (a) Determine the cost of goods available for sale. (b) Determine (1) the ending inventory and (2) the cost of goods sold under each of the

assumed cost flow methods (FIFO, LIFO, and average-cost). Prove the accuracy of the cost of goods sold under the FIFO and LIFO methods. (Note: For average-cost, round cost per unit to three decimal places.)

(c) Which cost flow method results in (1) the highest inventory amount for the balance sheet and (2) the highest cost of goods sold for the income statement?

P6-3A Remsen Company Inc. had a beginning inventory of 100 units of Product MLN at a cost of $8 per unit. During the year, purchases were:

Feb. 20 600 units at $ 9 Aug. 12 400 units at $11 May 5 500 units at $10 Dec. 8 100 units at $12

Remsen Company uses a periodic inventory system. Sales totalled 1,500 units.

Instructions (a) Determine the cost of goods available for sale. (b) Determine the ending inventory and the cost of goods sold under each of the as-

sumed cost flow methods (FIFO, LIFO, and average-cost). Prove the accuracy of the cost of goods sold under the FIFO and LIFO methods. (Round average unit cost to three decimal places.)

(c) Which cost flow method results in the lowest inventory amount for the balance sheet? The lowest cost of goods sold for the income statement?

P6-4A The management of Kuiper Inc. asks your help in determining the comparative effects of the FIFO and LIFO inventory cost flow methods. For 2012, the accounting records show these data.

Inventory, January 1 (10,000 units) $ 35,000 Cost of 120,000 units purchased 468,500 Selling price of 98,000 units sold 750,000 Operating expenses 124,000

Units purchased consisted of 35,000 units at $3.70 on May 10; 60,000 units at $3.90 on August 15; and 25,000 units at $4.20 on November 20. Income taxes are 28%.

Instructions (a) Prepare comparative condensed income statements for 2012 under FIFO and LIFO.

(Show computations of ending inventory.) (b) Answer the following questions for management in the form of a business letter.

(1) Which inventory cost flow method produces the inventory amount that most closely approximates the amount that would have to be paid to replace the inventory? Why?

(2) Which inventory cost flow method produces the net income amount that is a more likely indicator of next period’s net income? Why?

(3) Which inventory cost flow method is most likely to approximate the actual phys- ical flow of the goods? Why?

(4) How much more cash will be available under LIFO than under FIFO? Why? (5) How much of the gross profit under FIFO is illusionary in comparison with the

gross profit under LIFO?

Determine cost of goods sold and ending inventory using FIFO, LIFO, and average- cost with analysis.

(SO 2, 3), AP

Cost of goods sold: FIFO $105,000 LIFO $115,500 Average $109,601

Determine cost of goods sold and ending inventory using FIFO, LIFO, and average- cost in a periodic inventory system and assess financial statement effects.

(SO 2, 3), AP

Cost of goods sold: FIFO $14,500 LIFO $15,100 Average $14,824

Compute ending inventory, prepare income statements, and answer questions using FIFO and LIFO.

(SO 2, 3), AN

Gross profit: FIFO $378,800 LIFO $362,900

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 319

320 chapter 6 Reporting and Analyzing Inventory

P6-5A You have the following information for McBride Inc. for the month ended October 31, 2012. McBride uses a periodic method for inventory.

Unit Cost or Date Description Units Selling Price

Oct. 1 Beginning inventory 60 $24 Oct. 9 Purchase 120 26 Oct. 11 Sale 100 35 Oct. 17 Purchase 100 27 Oct. 22 Sale 60 40 Oct. 25 Purchase 70 29 Oct. 29 Sale 110 40

Instructions (a) Calculate (i) ending inventory, (ii) cost of goods sold, (iii) gross profit, and (iv) gross

profit rate under each of the following methods. (1) LIFO. (2) FIFO. (3) Average-cost. (Round cost per unit to three decimal places.)

(b) Compare results for the three cost flow assumptions.

P6-6A You have the following information for Prospector Gems. Prospector uses the periodic method of accounting for its inventory transactions. Prospector only carries one brand and size of diamonds—all are identical. Each batch of diamonds purchased is care- fully coded and marked with its purchase cost.

March 1 Beginning inventory 150 diamonds at a cost of $310 per diamond. March 3 Purchased 200 diamonds at a cost of $350 each. March 5 Sold 180 diamonds for $600 each. March 10 Purchased 330 diamonds at a cost of $375 each. March 25 Sold 390 diamonds for $650 each.

Instructions (a) Assume that Prospector Gems uses the specific identification cost flow method.

(1) Demonstrate how Prospector could maximize its gross profit for the month by specifically selecting which diamonds to sell on March 5 and March 25.

(2) Demonstrate how Prospector could minimize its gross profit for the month by selecting which diamonds to sell on March 5 and March 25.

(b) Assume that Prospector uses the FIFO cost flow assumption. Calculate cost of goods sold. How much gross profit would Prospector report under this cost flow assumption?

(c) Assume that Prospector uses the LIFO cost flow assumption. Calculate cost of goods sold. How much gross profit would the company report under this cost flow assumption?

(d) Which cost flow method should Prospector Gems select? Explain.

P6-7A This information (in millions) is available for the Automotive and Other Opera- tions Divisions of General Motors Corporation for a recent year. General Motors uses the LIFO inventory method.

Beginning inventory $ 13,921 Ending inventory 14,939 LIFO reserve 1,423 Current assets 60,135 Current liabilities 70,308 Cost of goods sold 166,259 Sales revenue 178,199

Calculate ending inventory, cost of goods sold, gross profit, and gross profit rate under periodic method; compare results.

(SO 2, 3), AP

Gross profit: LIFO $2,970 FIFO $3,310 Average $3,133

Compare specific identification, FIFO, and LIFO under periodic method; use cost flow assumption to influence earnings.

(SO 2, 3), AP

Gross profit: Maximum $162,500 Minimum $155,350

Compute inventory turnover ratio and days in inventory; compute current ratio based on LIFO and after adjusting for LIFO reserve.

(SO 5, 6), AP

Instructions (a) Calculate the inventory turnover ratio and days in inventory. (b) Calculate the current ratio based on inventory as reported using LIFO. (c) Calculate the current ratio after adjusting for the LIFO reserve. (d) Comment on any difference between parts (b) and (c).

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 320

Problems: Set B 321

*P6-8A Singer Inc. is a retailer operating in Edmonton, Alberta. Singer uses the perpet- ual inventory method. All sales returns from customers result in the goods being returned to inventory. (Assume that the inventory is not damaged.) Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following infor- mation for Singer Inc. for the month of January 2012.

Unit Cost or Date Description Quantity Selling Price

Dec. 31 Ending inventory 160 $20 Jan. 2 Purchase 100 22 Jan. 6 Sale 180 40 Jan. 9 Sale return 10 40 Jan. 9 Purchase 75 24 Jan. 10 Purchase return 15 24 Jan. 10 Sale 50 45 Jan. 23 Purchase 100 25 Jan. 30 Sale 130 48

Instructions (a) For each of the following cost flow assumptions, calculate (i) cost of goods sold,

(ii) ending inventory, and (iii) gross profit. (1) LIFO. (Assume sales returns had a cost of $20 and purchase returns had a cost

of $24.) (2) FIFO. (Assume sales returns had a cost of $20 and purchase returns had a cost

of $24.) (3) Moving-average. (Round cost per unit to three decimal places.)

(b) Compare results for the three cost flow assumptions.

*P6-9A Premier Center began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales.

Purchases

Date Units Unit Cost Sales Units

July 1 7 $62 July 6 5 July 11 3 $66 July 14 3 July 21 4 $71 July 27 3

Instructions (a) Determine the ending inventory under a perpetual inventory system using (1) FIFO,

(2) moving-average (round unit cost to three decimal places), and (3) LIFO. (b) Which costing method produces the highest ending inventory valuation?

Calculate cost of goods sold, ending inventory, and gross profit for LIFO, FIFO, and moving-average under the perpetual system; compare results.

(SO 3, 7), AP

Gross profit: LIFO $7,350 FIFO $7,700 Average $7,597

Determine ending inventory under a perpetual inventory system.

(SO 3, 7), AP

FIFO $213 Average $207 LIFO $195

Problems: Set B P6-1B Equitz Limited is trying to determine the value of its ending inventory as of Feb- ruary 28, 2012, the company’s year-end. The following transactions occurred, and the ac- countant asked your help in determining whether they should be recorded or not. (a) On February 26, Equitz shipped goods costing $800 to a customer and charged the

customer $1,000. The goods were shipped with terms FOB destination and the re- ceiving report indicates that the customer received the goods on March 2.

Determine items and amounts to be recorded in inventory.

(SO 1), AN

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 321

322 chapter 6 Reporting and Analyzing Inventory

(b) On February 26, Seller Inc. shipped goods to Equitz under terms FOB shipping point. The invoice price was $300 plus $25 for freight. The receiving report indicates that the goods were received by Equitz on March 2.

(c) Equitz had $500 of inventory isolated in the warehouse. The inventory is designated for a customer who has requested that the goods be shipped on March 10.

(d) Also included in Equitz’s warehouse is $400 of inventory that Meredith Producers shipped to Equitz on consignment.

(e) On February 26, Equitz issued a purchase order to acquire goods costing $750. The goods were shipped with terms FOB destination on February 27. Equitz received the goods on March 2.

(f) On February 26, Equitz shipped goods to a customer under terms FOB shipping point. The invoice price was $350 plus $25 for freight; the cost of the items was $260. The receiving report indicates that the goods were received by the customer on March 2.

Instructions For each of the above transactions, specify whether the item in question should be in- cluded in ending inventory, and if so, at what amount.

P6-2B Savage Distribution markets CDs of the performing artist Little Sister. At the beginning of October, Savage had in beginning inventory 1,200 Sister’s CDs with a unit cost of $5. During October, Savage made the following purchases of Sister’s CDs.

Oct. 3 4,000 @ $6 Oct. 19 2,500 @ $8 Oct. 9 3,000 @ $7 Oct. 25 2,000 @ $9

During October 9,400 units were sold. Savage uses a periodic inventory system.

Instructions (a) Determine the cost of goods available for sale. (b) Determine (1) the ending inventory and (2) the cost of goods sold under each of the

assumed cost flow methods (FIFO, LIFO, and average-cost). Prove the accuracy of the cost of goods sold under the FIFO and LIFO methods. (Round cost per unit to three decimal places.)

(c) Which cost flow method results in (1) the highest inventory amount for the balance sheet and (2) the highest cost of goods sold for the income statement?

P6-3B Trattner Company had a beginning inventory on January 1 of 100 units of Prod- uct SXL at a cost of $20 per unit. During the year, purchases were:

Mar. 15 300 units at $23 Sept. 4 290 units at $28 July 20 250 units at $25 Dec. 2 130 units at $30

Trattner Company sold 800 units, and it uses a periodic inventory system.

Instructions (a) Determine the cost of goods available for sale. (b) Determine the ending inventory and the cost of goods sold under each of the as-

sumed cost flow methods (FIFO, LIFO, and average-cost). Prove the accuracy of the cost of goods sold under each method. (Round cost per unit to three decimal places.)

(c) Which cost flow method results in the highest inventory amount for the balance sheet? The highest cost of goods sold for the income statement?

P6-4B The management of Howland is reevaluating the appropriateness of using its present inventory cost flow method, which is average-cost. The company requests your help in determining the results of operations for 2012 if either the FIFO or the LIFO method had been used. For 2012, the accounting records show these data:

Inventories Purchases and Sales

Beginning (10,000 units) $22,500 Total net sales (220,000 units) $862,000 Ending (20,000 units) Total cost of goods purchased

(230,000 units) 567,500

Determine cost of goods sold and ending inventory using FIFO, LIFO, and average- cost with analysis.

(SO 2, 3), AP

Cost of goods sold: FIFO $60,600 LIFO $70,400 Average $65,867

Determine cost of goods sold and ending inventory using FIFO, LIFO, and average- cost in a periodic inventory system and assess financial statement effects.

(SO 2, 3), AP

Cost of goods sold: FIFO $19,350 LIFO $21,260 Average $20,314

Compute ending inventory, prepare income statements, and answer questions using FIFO and LIFO.

(SO 2, 3), AN

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 322

Problems: Set B 323

Purchases were made quarterly as follows.

Quarter Units Unit Cost Total Cost

1 60,000 $2.30 $138,000 2 50,000 2.40 120,000 3 50,000 2.55 127,500 4 70,000 2.60 182,000

230,000 $567,500

Operating expenses were $147,000, and the company’s income tax rate is 32%.

Instructions (a) Prepare comparative condensed income statements for 2012 under FIFO and LIFO.

(Show computations of ending inventory.) (b) Answer the following questions for management in business-letter form.

(1) Which cost flow method (FIFO or LIFO) produces the inventory amount that most closely approximates the amount that would have to be paid to replace the inventory? Why?

(2) Which cost flow method (FIFO or LIFO) produces the net income amount that is a more likely indicator of next period’s net income? Why?

(3) Which cost flow method (FIFO or LIFO) is more likely to approximate the ac- tual physical flow of goods? Why?

(4) How much more cash will be available for management under LIFO than under FIFO? Why?

(5) Will gross profit under the average-cost method be higher or lower than FIFO? Than LIFO? (Note: It is not necessary to quantify your answer.)

P6-5B You have the following information for Wirth Inc. for the month ended June 30, 2012. Wirth uses the periodic method for inventory.

Unit Cost or Date Description Quantity Selling Price

June 1 Beginning inventory 25 $60 June 4 Purchase 85 63 June 10 Sale 60 90 June 11 Sale return 5 90 June 18 Purchase 35 66 June 18 Purchase return 15 66 June 25 Sale 55 95 June 28 Purchase 20 70

Instructions (a) Calculate (i) ending inventory, (ii) cost of goods sold, (iii) gross profit, and (iv) gross

profit rate under each of the following methods. (1) LIFO. (2) FIFO. (3) Average-cost. (Round cost per unit to three decimal places.)

(b) Compare results for the three cost flow assumptions.

P6-6B You have the following information for Gas Saver Plus. Gas Saver Plus uses the periodic method of accounting for its inventory transactions.

March 1 Beginning inventory 1,500 litres at a cost of 40¢ per litre. March 3 Purchased 2,200 litres at a cost of 45¢ per litre. March 5 Sold 1,800 litres for 60¢ per litre. March 10 Purchased 3,500 litres at a cost of 49¢ per litre. March 20 Purchased 2,000 litres at a cost of 52¢ per litre. March 30 Sold 5,000 litres for 70¢ per litre.

Instructions (a) Prepare partial income statements through gross profit, and calculate the value of

ending inventory that would be reported on the balance sheet, under each of the cost flow assumptions on the next page.

Gross profit: FIFO $324,000 LIFO $317,500

Calculate ending inventory, cost of goods sold, gross profit, and gross profit rate under periodic method; compare results.

(SO 2, 3), AP

Gross profit: LIFO $3,045 FIFO $3,320 Average $3,153

Compare specific identification, FIFO, and LIFO under periodic method; use cost flow assumption to justify price increase.

(SO 2, 3), AP

Gross profit: Specific identification $1,371 FIFO $1,471 LIFO $1,240

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 323

324 chapter 6 Reporting and Analyzing Inventory

(1) Specific identification method assuming: (i) the March 5 sale consisted of 800 litres from the March 1 beginning inven-

tory and 1,000 litres from the March 3 purchase; and (ii) the March 30 sale consisted of the following number of units sold from each

purchase: 400 litres from March 1; 500 litres from March 3; 2,600 litres from March 10; 1,500 litres from March 20.

(2) FIFO. (3) LIFO.

(b) How can companies use a cost flow method to justify price increases? Which cost flow method would best support an argument to increase prices?

P6-7B The following information is available for the automotive division of Ford Motor Company for 2009. The company uses the LIFO inventory method.

(in millions) 2009

Beginning inventory $ 6,988 Ending inventory 5,450 LIFO reserve 798 Current assets 40,560 Current liabilities 37,037 Cost of goods sold 100,016 Sales revenue 105,893

Instructions (a) Calculate the inventory turnover ratio and days in inventory. (b) Calculate the current ratio based on LIFO inventory. (c) After adjusting for the LIFO reserve, calculate the current ratio. (d) Comment on any difference between parts (b) and (c).

*P6-8B Morse Inc. is a retail company that uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory. (Assume that the inventory is not damaged.) Assume that there are no credit transactions; all amounts are settled in cash. You have the following information for Morse Inc. for the month of January 2012.

Unit Cost or Date Description Quantity Selling Price

January 1 Beginning inventory 40 $13 January 5 Purchase 90 16 January 8 Sale 75 25 January 10 Sale return 10 25 January 15 Purchase 30 18 January 16 Purchase return 5 18 January 20 Sale 80 25 January 25 Purchase 20 21

Instructions (a) For each of the following cost flow assumptions, calculate (i) cost of goods sold, (ii)

ending inventory, and (iii) gross profit. (1) LIFO. (Assume sales returns had a cost of $16 and purchase returns had a cost

of $18.) (2) FIFO. (Assume sales returns had a cost of $16 and purchase returns had a cost

of $18.) (3) Moving-average. (Round cost per unit to three decimal places.)

(b) Compare results for the three cost flow assumptions.

Compute inventory turnover ratio and days in inventory; compute current ratio based on LIFO and after adjusting for LIFO reserve.

(SO 5, 6), AP

Calculate cost of goods sold, ending inventory, and gross profit under LIFO, FIFO, and moving-average under the perpetual system; compare results.

(SO 3, 7), AP

Gross profit: LIFO $1,345 FIFO $1,395 Average $1,374

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 324

Comprehensive Problem 325

*P6-9B Dollar Saver Center began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales.

Purchases

Date Units Unit Cost Sales Units

July 1 7 $47 July 6 3 July 11 5 $50 July 14 4 July 21 3 $54 July 27 2

Instructions (a) Determine the ending inventory under a perpetual inventory system using (1) FIFO,

(2) moving-average, and (3) LIFO. (Note: For moving-average, round cost per unit to three decimal places.)

(b) Which costing method produces the highest ending inventory valuation?

Determine ending inventory under a perpetual inventory system.

(SO 3, 7), AP

FIFO $312 Average $304 LIFO $292

Problems: Set C Visit the book’s companion website, at www.wiley.com/college/kimmel, and choose the Student Companion site to access Problem Set C.

Comprehensive Problem CP6 On December 1, 2012, Ruggiero Company had the account balances shown below.

Debits Credits

Cash $ 4,800 Accumulated Depreciation—Equipment $ 1,500 Accounts Receivable 3,900 Accounts Payable 3,000 Inventory 1,800* Common Stock 10,000 Equipment 21,000 Retained Earnings 17,000

$31,500 $31,500

*(3,000 � $0.60)

The following transactions occurred during December.

Dec. 3 Purchased 4,000 units of inventory on account at a cost of $0.72 per unit. 5 Sold 4,400 units of inventory on account for $0.90 per unit. (It sold

3,000 of the $0.60 units and 1,400 of the $0.72.) 7 Granted the December 5 customer $180 credit for 200 units of inven-

tory returned costing $150. These units were returned to inventory. 17 Purchased 2,200 units of inventory for cash at $0.80 each. 22 Sold 2,000 units of inventory on account for $0.95 per unit. (It sold

2,000 of the $0.72 units.)

Adjustment data:

1. Accrued salaries payable $400. 2. Depreciation $200 per month. 3. Income tax expense was $215, to be paid next year.

Instructions (a) Journalize the December transactions and adjusting entries, assuming Ruggiero uses

the perpetual inventory method.

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 325

326 chapter 6 Reporting and Analyzing Inventory

(b) Enter the December 1 balances in the ledger T accounts and post the December trans- actions. In addition to the accounts mentioned above, use the following additional ac- counts: Cost of Goods Sold, Depreciation Expense, Salaries and Wages Expense, Salaries and Wages Payable, Sales Revenue, Sales Returns and Allowances, Income Tax Expense, and Income Taxes Payable.

(c) Prepare an adjusted trial balance as of December 31, 2012. (d) Prepare an income statement for December 2012 and a classified balance sheet at

December 31, 2012. (e) Compute ending inventory and cost of goods sold under FIFO, assuming Ruggiero

Company uses the periodic inventory system. (f) Compute ending inventory and cost of goods sold under LIFO, assuming Ruggiero

Company uses the periodic inventory system.

Continuing Cookie Chronicle (Note: This is a continuation of the Cookie Chronicle from Chapters 1 through 5.)

CCC6 Natalie is busy establishing both divisions of her business (cookie classes and mixer sales) and completing her business degree. Her goals for the next 11 months are to sell one mixer per month and to give two to three classes per week. Natalie has de- cided to use a periodic inventory system and now must choose a cost flow assumption for her mixer inventory.

Go to the book’s companion website, at www.wiley.com/college/kimmel, to see the com- pletion of this problem.

Financial Reporting and Analysis FINANCIAL REPORTING PROBLEM: Tootsie Roll, Industries Inc.

BYP6-1 The notes that accompany a company’s financial statements provide informative details that would clutter the amounts and descriptions presented in the statements. Refer to the finan- cial statements of Tootsie Roll and the accompanying Notes to Consolidated Financial Statements in Appendix A.

Instructions Answer the following questions. (Give the amounts in thousands of dollars, as shown in Tootsie Roll’s annual report.) (a) What did Tootsie Roll report for the amount of inventories in its Consolidated Balance Sheet

at December 31, 2009? At December 31, 2008? (b) Compute the dollar amount of change and the percentage change in inventories between

2008 and 2009. Compute inventory as a percentage of current assets for 2009. (c) What are the (product) cost of goods sold reported by Tootsie Roll for 2009, 2008, and 2007?

Compute the ratio of (product) cost of goods sold to net (product) sales in 2009.

COMPARATIVE ANALYSIS PROBLEM: Tootsie Roll vs. Hershey

BYP6-2 The financial statements of The Hershey Company appear in Appendix B, following the financial statements for Tootsie Roll in Appendix A.

Instructions (a) Based on the information in the financial statements, compute these 2009 values for each

company. (Do not adjust for the LIFO reserve.) (1) Inventory turnover ratio. (Use product cost of goods sold and total inventory.) (2) Days in inventory.

(b) What conclusions concerning the management of the inventory can you draw from these data?

broadening your perspective

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 326

Broadening Your Perspective 327

RESEARCH CASE

BYP6-3 The January 27, 2010, issue of the Wall Street Journal contains an article by Timothy Aeppel entitled “‘Bullwhip’ Hits Firms as Growth Snaps Back.”

Instructions Read the article and answer the following questions. (a) Explain why Caterpillar would more than double its purchases of steel this year even if its

own sales don’t rise relative to the previous year. (b) Why did Caterpillar meet with its key suppliers during the previous year? (c) What are some of the barriers and concerns that suppliers faced at the time of the article? (d) How rapidly did Caterpillar grow in recent years and what did it learn from that experience,

that is, what changes did it implement with regard to suppliers?

INTERPRETING FINANCIAL STATEMENTS

BYP6-4 The following information is from the 2009 annual report of American Greetings Corporation (all dollars in thousands).

The following information comes from the notes to the company’s financial statements.

Finished products, work in process, and raw material inventories are carried at the lower- of-cost-or-market. The last-in, first-out (LIFO) cost method is used for approximately 75% of the domestic inventories in 2009 and approximately 70% in 2008. The foreign subsidiaries principally use the first-in, first-out method. Display material and factory supplies are carried at average-cost.

Instructions (a) Define each of the following: finished goods, work in process, and raw materials. (b) What might be a possible explanation for why the company uses FIFO for its nondomestic

inventories? (c) Calculate the company’s inventory turnover ratio and days in inventory for 2008 and 2009.

(2007 inventory was $182,618.) Discuss the implications of any change in the ratios. (d) What percentage of total inventory does the 2009 LIFO reserve represent? If the company

used FIFO in 2009, what would be the value of its inventory? Do you consider this difference a “material” amount from the perspective of an analyst? Which value accurately represents the value of the company’s inventory?

(e) Calculate the company’s 2009 current ratio with the numbers as reported, then recalculate after adjusting for the LIFO reserve.

FINANCIAL ANALYSIS ON THE WEB

BYP6-5 Purpose: Use SEC filings to learn about a company’s inventory accounting practices.

Address: http://biz.yahoo.com/p/_capgds-bldmch.html, or go to www.wiley.com/college/kimmel

Feb. 28, Feb. 29, 2009 2008

Inventories Finished goods $232,893 $244,379 Work in process 7,068 10,516 Raw materials and supplies 49,937 43,861

289,898 298,756 Less: LIFO reserve 86,025 82,085

Total (as reported) $203,873 $216,671

Cost of goods sold $809,956 $780,771 Current assets (as reported) $561,395 $669,340 Current liabilities $343,405 $432,321

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 327

Steps

1. Go to this site and click on the name of an equipment manufacturer other than those dis- cussed in the chapter.

2. Click on SEC filings. 3. Under “Recent filings” choose Form 10K (annual report) and click on Full Filing at Edgar

Online. 4. Choose option “3,” Online HTML Version.

If the 10K is not listed among the recent filings then click on View All Filings on EDGAR Online.

Instructions Review the 10K to answer the following questions.

(a) What is the name of the company? (b) How has its inventory changed from the previous year? (c) What is the amount of raw materials, work in process, and finished goods inventory? (d) What inventory method does the company use? (e) Calculate the inventory turnover ratio and days in inventory for the current year. (f ) If the company uses LIFO, what was the amount of its LIFO reserve?

Critical Thinking DECISION MAKING ACROSS THE ORGANIZATION

BYP6-6 Crescent Electronics has enjoyed tremendous sales growth during the last 10 years. However, even though sales have steadily increased, the company’s CEO, Anne Healy, is concerned about certain aspects of its performance. She has called a meeting with the corporate controller and the vice presidents of finance, operations, sales, and marketing to discuss the company’s per- formance. Anne begins the meeting by making the following observations:

We have been forced to take significant write-downs on inventory during each of the last three years because of obsolescence. In addition, inventory storage costs have soared. We rent four additional warehouses to store our increasingly diverse inventory. Five years ago inventory represented only 20% of the value of our total assets. It now exceeds 35%. Yet, even with all of this inventory, “stockouts” (measured by complaints by customers that the desired product is not available) have increased by 40% during the last three years. And worse yet, it seems that we constantly must discount merchandise that we have too much of.

Anne asks the group to review the following data and make suggestions as to how the compa- ny’s performance might be improved.

(in millions) 2012 2011 2010 2009

Inventory Raw materials $242 $198 $155 $128 Work in process 116 77 49 33 Finished goods 567 482 398 257

Total inventory $925 $757 $602 $418

Current assets $1,800 $1,423 $1,183 $841 Total assets $2,643 $2,523 $2,408 $2,090 Current liabilities $600 $590 $525 $420 Sales revenue $9,428 $8,674 $7,536 $6,840 Cost of goods sold $6,328 $5,474 $4,445 $3,557 Net income $754 $987 $979 $958

Instructions Using the information provided, answer the following questions. (a) Compute the current ratio, gross profit rate, profit margin ratio, inventory turnover ratio, and

days in inventory for 2010, 2011, and 2012. (b) Discuss the trends and potential causes of the changes in the ratios in part (a). (c) Discuss potential remedies to any problems discussed in part (b). (d) What concerns might be raised by some members of management with regard to your sug-

gestions in part (c)?

328 chapter 6 Reporting and Analyzing Inventory

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 328

COMMUNICATION ACTIVITIES

BYP6-7 In a discussion of dramatic increases in coffee bean prices, a Wall Street Journal article noted the following fact about Starbucks.

Before this year’s bean-price hike, Starbucks added several defenses that analysts say could help it maintain earnings and revenue. The company last year began accounting for its coffee-bean purchases by taking the average price of all beans in inventory.

Source: Aaron Lucchetti, “Crowded Coffee Market May Keep a Lid on Starbucks After Price Rise Hurt Stock,” Wall Street Journal (June 4, 1997), p. C1.

Prior to this change the company was using FIFO.

Instructions Your client, the CEO of Supreme Coffee, Inc., read this article and sent you an e-mail message requesting that you explain why Starbucks might have taken this action. Your response should explain what impact this change in accounting method has on earnings, why the company might want to do this, and any possible disadvantages of such a change.

*BYP6-8 You are the controller of Emjay Inc. M. J. Danner, the president, recently mentioned to you that she found an error in the 2011 financial statements which she believes has corrected itself. She determined, in discussions with the purchasing department, that 2011 ending inventory was overstated by $1 million. M. J. says that the 2012 ending inventory is correct, and she assumes that 2012 income is correct. M. J. says to you, “What happened has happened—there’s no point in wor- rying about it anymore.”

Instructions You conclude that M. J. is incorrect. Write a brief, tactful memo to her, clarifying the situation.

ETHICS CASE

BYP6-9 Yelich Wholesale Corp. uses the LIFO cost flow method. In the current year, profit at Yelich is running unusually high. The corporate tax rate is also high this year, but it is scheduled to decline significantly next year. In an effort to lower the current year’s net income and to take advantage of the changing income tax rate, the president of Yelich Wholesale instructs the plant accountant to recommend to the purchasing department a large purchase of inventory for deliv- ery 3 days before the end of the year. The price of the inventory to be purchased has doubled dur- ing the year, and the purchase will represent a major portion of the ending inventory value.

Instructions (a) What is the effect of this transaction on this year’s and next year’s income statement and in-

come tax expense? Why? (b) If Yelich Wholesale had been using the FIFO method of inventory costing, would the presi-

dent give the same directive? (c) Should the plant accountant order the inventory purchase to lower income? What are the

ethical implications of this order?

“ALL ABOUT YOU” ACTIVITY

BYP6-10 Some of the largest business frauds ever perpetrated have involved the misstatement of inventory. Two classics were at Leslie Fay Cos, and McKesson Corporation.

Instructions There is considerable information regarding inventory frauds available on the Internet. Search for information about one of the two cases mentioned above, or inventory fraud at any other company, and prepare a short explanation of the nature of the inventory fraud.

FASB CODIFICATION ACTIVITY

BYP6-11 If your school has a subscription to the FASB Codification, go to http://aaahq.org/ ascLogin.cfm to log in and prepare responses to the following. (a) The primary basis for accounting for inventories is cost. How is cost defined in the Codification? (b) What does the Codification state regarding the use of consistency in the selection or employ-

ment of a basis for inventory? (c) What does the Codification indicate is a justification for the use of the lower-of-cost-or-market

for inventory valuation?

Broadening Your Perspective 329

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 329

Answers to Insight and Accounting Across the Organization Questions

p. 283 A Big Hiccup Q: What steps might the companies take to avoid such a serious disruption in the future? A: The manufacturer of the piston rings should spread its manufacturing facilities across a few locations that are far enough apart that they would not all be at risk at once. In ad- dition, the automakers might consider becoming less dependent on a single supplier.

p. 284 Falsifying Inventory to Boost Income Q: What effect does an overstatement of inventory have on a company’s financial statements? A: The balance sheet looks stronger because inven- tory and retained earnings are overstated. The income statement looks better because cost of goods sold is understated and income is overstated.

p. 294 Is LIFO Fair? Q: What are the arguments for and against the use of LIFO? A: Proponents of LIFO argue that it is conceptually superior because it matches the most recent cost with the most recent selling price. Critics contend that it artificially understates the company’s net income and consequently reduces tax payments. Also, because most foreign companies are not allowed to use LIFO, its use by U.S. companies reduces the ability of investors to compare U.S. companies with foreign companies.

p. 298 Improving Inventory Control with RFID Q: Why is inventory control important to man- agers such as those at Wal-Mart and Best Buy? A: In the very competitive environment of dis- count retailing, where Wal-Mart and Best Buy are the major players, small differences in price matter to the customer. Wal-Mart sells a high volume of inventory at a low gross profit rate. When operating in a high-volume, low-margin environment, small cost savings can mean the difference between being profitable or going out of business.

Answers to Self-Test Questions

1. d 2. a 3. b ($180,000 � $35,000) 4. c ((5,000 � $13) � (4,000 � $12)) 5. d ((8,000 � $11) � (1,000 � $12)) 6. d ((5,000 � $8) � (15,000 � $10) � (20,000 � $12)) � 40,000 � $10.75; $10.75 � 7,000 7. c 8. d 9. a 10. d 11. b ($285,000 � (($80,000 � $110,000) � 2) � 3; 365 � 3) 12. a *13. d *14. b *15. b

330 chapter 6 Reporting and Analyzing Inventory

IFRS A Look at IFRS The major IFRS requirements related to accounting and reporting for inventories are the same as GAAP. The major differences are that IFRS prohibits the use of the LIFO cost flow assumption and determines market in the lower-of-cost-or-market inventory valuation differently.

KEY POINTS • The requirements for accounting for and reporting inventories are more principles-based under

IFRS. That is, GAAP provides more detailed guidelines in inventory accounting.

• The definitions for inventory are essentially similar under IFRS and GAAP. Both define inven- tory as assets held-for-sale in the ordinary course of business, in the process of production for sale (work in process), or to be consumed in the production of goods or services (e.g., raw materials).

• Who owns the goods—goods in transit or consigned goods—as well as the costs to include in inventory, are accounted for the same under IFRS and GAAP.

• Both GAAP and IFRS permit specific identification where appropriate. IFRS actually requires that the specific identification method be used where the inventory items are not interchange- able (i.e., can be specifically identified). If the inventory items are not specifically identifiable, a cost flow assumption is used. GAAP does not specify situations in which specific identifica- tion must be used.

• A major difference between IFRS and GAAP relates to the LIFO cost flow assumption. GAAP permits the use of LIFO for inventory valuation. IFRS prohibits its use. FIFO and average-cost are the only two acceptable cost flow assumptions permitted under IFRS.

• IFRS requires companies to use the same cost flow assumption for all goods of a similar nature. GAAP has no specific requirement in this area.

• In the lower-of-cost-or-market test for inventory valuation, IFRS defines market as net realiz- able value. Net realizable value is the estimated selling price in the ordinary course of business,

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 330

less the estimated costs of completion and estimated selling expenses. In other words, net real- izable value is the best estimate of the net amounts that inventories are expected to realize. GAAP, on the other hand, defines market as essentially replacement cost.

• Under GAAP, if inventory is written down under the lower-of-cost-or-market valuation, the new value becomes its cost basis. As a result, the inventory may not be written back up to its original cost in a subsequent period. Under IFRS, the write-down may be reversed in a subsequent peri- od up to the amount of the previous write-down. Both the write-down and any subsequent reversal should be reported on the income statement as an expense. An item-by-item approach is generally followed under IFRS.

• An example of the use of lower-of-cost-or-net realizable value under IFRS follows.

• Unlike property, plant, and equipment, IFRS does not permit the option of valuing inventories at fair value. As indicated above, IFRS requires inventory to be written down, but inventory can- not be written up above its original cost.

• Similar to GAAP, certain agricultural products and mineral products can be reported at net real- izable value using IFRS.

LOOKING TO THE FUTURE One convergence issue that will be difficult to resolve relates to the use of the LIFO cost flow assumption. As indicated, IFRS specifically prohibits its use. Conversely, the LIFO cost flow assumption is widely used in the United States because of its favorable tax advantages. In addi- tion, many argue that LIFO from a financial reporting point of view provides a better matching of current costs against revenue and, therefore, enables companies to compute a more realistic income.

With a new conceptual framework being developed, it is highly probable that the use of the concept of conservatism will be eliminated. Similarly, the concept of “prudence” in the IASB liter- ature will also be eliminated. This may ultimately have implications for the application of the lower-of-cost-or-net realizable value.

IFRS Self-Test Questions 1. Which of the following should not be included in the inventory of a company using IFRS?

(a) Goods held on consignment from another company. (b) Goods shipped on consignment to another company. (c) Goods in transit from another company shipped FOB shipping point. (d) None of the above.

Mendel Company has the following four items in its ending inventory as of December 31, 2012. The company uses the lower-of-cost-or-net realizable value approach for inventory valuation following IFRS.

Item No. Cost Net Realizable Value

1320 $3,600 $3,400 1333 4,000 4,100 1428 2,800 2,100 1510 5,000 4,700

The computation of the ending inventory value to be reported in the financial statements at December 31, 2012, is as follows.

Lower-of-Cost-or- Item No. Cost Net Realizable Value NRV

1320 $ 3,600 $ 3,400 $ 3,400 1333 4,000 4,100 4,000 1428 2,800 2,100 2,100 1510 5,000 4,700 4,700

Total $15,400 $14,300 $14,200

A Look at IFRS 331

c06ReportingandAnalyzingInventory.qxd 8/14/10 2:24 PM Page 331

2. Which method of inventory costing is prohibited under IFRS? (a) Specific identification. (c) FIFO. (b) LIFO. (d) Average-cost.

3. Yang Company purchased 2,000 phones and has 400 phones in its ending inventory at a cost of $90 each and a current replacement cost of $80 each. The net realizable value of each phone in the ending inventory is $70. The ending inventory under lower-of-cost-or-net realizable value is: (a) $36,000. (c) $28,000. (b) $32,000. (d) None of the above.

4. Specific identification: (a) must be used under IFRS if the inventory items are not interchangeable. (b) cannot be used under IFRS. (c) cannot be used under GAAP. (d) must be used under IFRS if it would result in the most conservative net income.

5. IFRS requires the following: (a) Ending inventory is written up and down to net realizable value each reporting period. (b) Ending inventory is written down to net realizable value but cannot be written up. (c) Ending inventory is written down to net realizable value and may be written up in future

periods to its net realizable value but not above its original cost. (d) Ending inventory is written down to net realizable value and may be written up in future

periods to its net realizable value.

IFRS Concepts and Application IFRS6–1 Briefly describe some of the similarities and differences between GAAP and IFRS with respect to the accounting for inventories.

IFRS6–2 LaTour Inc. is based in France and prepares its financial statements in accordance with IFRS. In 2012, it reported cost of goods sold of C= 578 million and average inventory of C=154 million. Briefly discuss how analysis of LaTour’s inventory turnover ratio (and comparisons to a company using GAAP) might be affected by differences in inventory accounting between IFRS and GAAP.

IFRS6–3 Franklin Company has the following four items in its ending inventory as of December 31, 2012. The company uses the lower-of-cost-or-net realizable value approach for inventory valu- ation following IFRS.

Item No. Cost Net Realizable Value

AB $1,700 $1,400 TRX 2,200 2,300 NWA 7,800 7,100 SGH 3,000 3,700

Compute the lower-of-cost-or-net realizable value.

INTERNATIONAL FINANCIAL REPORTING PROBLEM: Zetar plc IFRS6–4 The financial statements of Zetar plc are presented in Appendix C. The company’s complete annual report, including the notes to its financial statements, is available at www.zetarplc.com. Using the notes to the company’s financial statements, answer the following questions.

Instructions (a) What cost flow assumption does the company use to value inventory? (b) What was the amount of expense that the company reported for inventory write-downs

during 2009? (c) What amount of raw materials, work in process, and finished goods inventory did the com-

pany report at April 30, 2009?

Answers to IFRS Self-Test Questions

1. a 2. b 3. c 4. a 5. c

332 chapter 6 Reporting and Analyzing Inventory

●●✓Remember to go back to the navigator box on the chapter opening page and check off your completed work.

c06ReportingandAnalyzingInventory.qxd 9/6/10 12:05 PM Page 332