Measuring and Reporting Inventories

Read this chapter. For many organizations, inventory represents a large portion of their assets, so it is important to be familiar with measurement and reporting techniques. Inventory is a major cost for many businesses, and a big source of potential opportunity for firms looking to improve their financial results.

Departures from cost basis of inventory measurement

Generally, companies should use historical cost to value inventories and cost of goods sold. However, some circumstances justify departures from historical cost. One of these circumstances is when the utility or value of inventory items is less than their cost. A decline in the selling price of the goods or their replacement cost may indicate such a loss of utility. This section explains how accountants handle some of these departures from the cost basis of inventory measurement.

Companies should not carry goods in inventory at more than their net realizable value. Net realizable value is the estimated selling price of an item less the estimated costs that the company incurs in preparing the item for sale and selling it. Damaged, obsolete, or shopworn goods often have a net realizable value lower than their historical cost and must be written down to their net realizable value. However, goods do not have to be damaged, obsolete, or shopworn for this situation to occur. Technological changes and increased competition have caused significant reductions in selling prices for such products as computers, TVs, DVD players, and digital cameras.

To illustrate a necessary write-down in the cost of inventory, assume that an automobile dealer has a demonstrator on hand. The dealer acquired the auto at a cost of USD 18,000. The auto had an original selling price of USD 19,600. Since the dealer used the auto as a demonstrator and the new models are coming in, the auto now has an estimated selling price of only USD 18,100. However, the dealer can get the USD 18,100 only if the demonstrator receives some scheduled maintenance, including a tune-up and some paint damage repairs. This work and the sales commission cost USD 300. The net realizable value of the demonstrator, then, is USD 17,800 (selling price of USD 18,100 less costs of USD 300). For inventory purposes, the required journal entry is:

Loss Due to the Decline in Market Value of Inventory (-SE)

200

 

Merchandise Inventory (-A)

 

200

To write down inventory to net realizable value ($18,000 $17,800)

   

 

This entry treats the USD 200 inventory decline as a loss in the period in which the decline in utility occurred. Such an entry is necessary only when the net realizable value is less than cost. If net realizable value declines but still exceeds cost, the dealer would continue to carry the item at cost.

The lower-of-cost-or-market (LCM) method is an inventory costing method that values inventory at the lower of its historical cost or its current market (replacement) cost. The term cost refers to historical cost of inventory as determined under the specific identification, FIFO, LIFO, or weighted-average inventory method. Market generally refers to a merchandise item's replacement cost in the quantity usually purchased. The basic assumption of the LCM method is that if the purchase price of an item has fallen, its selling price also has fallen or will fall. The LCM method has long been accepted in accounting.

Under LCM, inventory items are written down to market value when the market value is less than the cost of the items. For example, assume that the market value of the inventory is USD 39,600 and its cost is USD 40,000. Then, the company would record a USD 400 loss because the inventory has lost some of its revenue-generating ability. The company must recognize the loss in the period the loss occurred. On the other hand, if ending inventory has a market value of USD 45,000 and a cost of USD 40,000, the company would not recognize this increase in value. To do so would recognize revenue before the time of sale.

LCM applied A company may apply LCM to each inventory item (such as Monopoly), each inventory class (such as games), or total inventory. To see how the company would apply the method to individual items and total inventory, look at Exhibit 62.

If LCM is applied on an item-by-item basis, ending inventory would be USD 5,000. The company would deduct the USD 5,000 ending inventory from cost of goods available for sale on the income statement and report this inventory in the current assets section of the balance sheet. Under the class method, a company applies LCM to the total cost and total market for each class of items compared. One class might be games; another might be toys. Then, the company values each class at the lower of its cost or market amount. If LCM is applied on a total inventory basis, ending inventory would be USD 5,100, since total cost of USD 5,100 is lower than total market of USD 5,150.

An annual report of Du Pont contains an actual example of applying LCM. The report states that "substantially all inventories are valued at cost as determined by the last-in, first-out (LIFO) method; in the aggregate, such valuations are not in excess of market". The term in the aggregate means that Du Pont applied LCM to total inventory.

 

An accounting perspective: Business insight

Procter & Gamble markets a broad range of laundry, cleaning, paper, beauty care, health care, food, and beverage products around the world. Procter & Gamble's footnote in its Notes to Consolidated Financial Statements in its annual report illustrates that companies often disclose LCM in their notes to financial statements. Inventories are valued at cost, which is not in excess of current market price. Cost is primarily determined by either the average cost or the first-in, first-out method. The replacement cost of last-in, first-out inventories exceeds carrying value by approximately USD 169 [million].

Item

Quantity

Unit Cost

Unit Market

Total Cost

Total Market

LCM on Item-by-Item Cost Market Basis

1

100 units

$10

$9.00

$1,000

$900

  $900

2

200 units

8

8.75

1,600

1,750

1,600

3

500 units

5

5.00

2,500

2,500

2,500

 

 

 

 

$5,100

$5,150

$5,000

 

Exhibit 62: Application of lower-of-cost-or-market method

 

Merchandise inventory, 2010 January

 

$40,000

Net cost of purchases

 

480,000

Cost of goods available for sale

 

$520,000

Less estimated cost of goods sold:

 

 

Net sales 

$700,000

 

Gross margin (30% of $700,000)

210,000

 

Estimated cost of goods sold

 

490,000

Estimated inventory, 2010 December 31

 

$30,000

 

Exhibit 63: Inventory estimation using gross margin method

 

A company using periodic inventory procedure may estimate its inventory for any of the following reasons:

  • To obtain an inventory cost for use in monthly or quarterly financial statements without taking a physical inventory. The effort of taking a physical inventory can be very expensive and disrupts normal business operations; once a year is often enough.
  • To compare with physical inventories to determine whether shortages exist.
  • To determine the amount recoverable from an insurance company when fire has destroyed inventory or the inventory has been stolen.

Next, we introduce two recognized methods of estimating the cost of ending inventory when a company has not taken a physical inventory - the gross margin method and the retail inventory method.

Gross margin method The steps in calculating ending inventory under the gross margin method are:

  • Estimate gross margin (based on net sales) using the same gross margin rate experienced in prior accounting periods.
  • Determine estimated cost of goods sold by deducting estimated gross margin from net sales.
  • Determine estimated ending inventory by deducting estimated cost of goods sold from cost of goods available for sale.

Thus, the gross margin method estimates ending inventory by deducting estimated cost of goods sold from cost of goods available for sale.

The gross margin method assumes that a fairly stable relationship exists between gross margin and net sales. In other words, gross margin has been a fairly constant percentage of net sales, and this relationship has continued into the current period. If this percentage relationship has changed, the gross margin method does not yield satisfactory results.

To illustrate the gross margin method of computing inventory, assume that for several years Field Company has maintained a 30 per cent gross margin on net sales. The following data for 2010 are available: The January 1 inventory was USD 40,000; net cost of purchases of merchandise was USD 480,000; and net sales of merchandise were USD 700,000. As shown in Exhibit 63, Field can estimate the inventory for 2010 December 31, by deducting the estimated cost of goods sold from the actual cost of goods available for sale.

An alternative format for calculating estimated ending inventory uses the standard income statement format and solves for the one unknown (ending inventory):

Net sales

 

$700,000

 

Less cost of goods sold:

 

 

 

Merchandise inventory, 2010 January 1

$40,000

 

 

Net cost of purchases

480,000

 

 

Cost of goods available for sale

$520,000

 

 

Less estimated inventory, 2010 December 31

 

 

 

Estimated cost of goods sold

 

490,000

(70% of net sales)

Estimated gross margin

 

$210,000

(30% of net sales)

 

We know that:

\text{Costs of goods available for sale - Ending inventory} = \text{Cost of goods sold}

\text{Therefore (let X} = \text{Ending inventory):}

\begin{array}{rl} \text {USD 520,000-X} & = \text{USD ~ 490,000} \\ \text{X} & =\text{USD ~ 30,000} \end{array}

The gross margin method is not precise enough to be used for year-end financial statements. At year-end, a physical inventory must be taken and valued by either the specific identification, FIFO, LIFO, or weighted-average methods.

Retail inventory method Retail stores frequently use the retail inventory method to estimate ending inventory at times other than year-end. Taking a physical inventory during an accounting period (such as monthly or quarterly) is too time consuming and significantly interferes with business operations. The retail inventory method estimates the cost of the ending inventory by applying a cost/retail price ratio to ending inventory stated at retail prices. The advantage of this method is that companies can estimate ending inventory (at cost) without taking a physical inventory. Thus, the use of this estimate permits the preparation of interim financial statements (monthly or quarterly) without taking a physical inventory. The steps for finding the ending inventory by the retail inventory method are:

  • Total the beginning inventory and the net amount of goods purchased during the period at both cost and retail prices.
  • Divide the cost of goods available for sale by the retail price of the goods available for sale to find the cost/retail price ratio.
  • Deduct the retail sales from the retail price of the goods available for sale to determine ending inventory at retail.
  • Multiply the cost/retail price ratio or percentage by the ending inventory at retail prices to reduce it to the ending inventory at cost.

 

Cost

Retail

Merchandise inventory, 2010 January 1

$22,000

$40,000

Purchases

182,000

303,000

Purchase returns

(2,000)

(3,000)

Purchase allowances

(3,000)

 

Transportation-in

5,000

 

Goods available for sale

$204,000

$340,000

Cost/retail price ratio:

$204,000/$340,000=60%

 

 

Sales

 

280,000

Ending inventory at retail prices

 

$60,000

Times cost/retail price ratio

 

x 60%

Ending inventory at cost, 2010 March 31

$36,000

 


Exhibit 64: Inventory estimation

 

In Exhibit 64, we show the retail inventory method. In the exhibit, the cost (USD 22,000) and retail (USD 40,000) amounts for beginning inventory are available from the preceding period's computation. The amounts for the first quarter purchases, purchase returns, purchase allowances, and transportation-in came from the accounting records. The amounts for purchase allowances and transportation-in appear only in the cost column. The first quarter sales amount (USD 280,000) is from the Sales account and stated at retail (sales) prices. The difference between what was available for sale at retail prices and what was sold at retail prices (which is sales) equals what should be on hand (March 31 inventory of USD 60,000) expressed in retail prices. The retail price of the March 31 inventory needs to be converted into cost for use in the financial statements. We do this by multiplying it times the cost/retail price ratio. In the example, the cost/retail price ratio is 60 per cent, which means that on the average, 60 cents of each sales dollar is cost of goods sold. To find the 2010 March 31, inventory at cost (USD 36,000), we multiplied the ending inventory at retail (USD 60,000) by 60 per cent.

Once the March 31 inventory has been estimated at cost (USD 36,000), we deduct the cost of the inventory from cost of goods available for sale (USD 204,000) to determine cost of goods sold (USD 168,000). We can also find the cost of goods sold by multiplying the cost/retail price ratio of 60 per cent by sales of USD 280,000.

For the next quarterly period, the USD 36,000 and USD 60,000 amounts would appear on the schedule as beginning inventory at cost and retail, respectively. We would include other quarterly data regarding purchases, purchase returns, purchase allowances, and transportation-in to determine goods available for sale at cost and at retail. From these amounts, we could compute a new cost/retail price ratio for the second quarter.

At the end of each year, merchandisers usually take a physical inventory at retail prices. Since the retail prices are on the individual items (while the cost is not), taking an inventory at retail prices is more convenient than taking an inventory at cost. Accountants can then compare the results of the physical inventory to the calculation of inventory at retail under the retail inventory method for the fourth quarter to determine whether a shortage exists.

Both the gross margin and the retail inventory methods can help you detect inventory shortages. To illustrate how you can determine inventory shortages using the retail method, assume that a physical inventory taken at year end, showed only USD 62,000 of retail-priced goods in the store. Assume that use of the retail method for the fourth quarter showed that USD 66,000 of goods should be on hand, thus indicating a USD 4,000 inventory shortage at retail. After converting the USD 4,000 to USD 2,400 of cost (USD 4,000 X 0.60) you would report this as a "Loss from inventory shortage" in the income statement. Knowledge of such shortages may lead management to reduce or prevent them, by increasing security or improving the training of employees.

 

An ethical perspective: Dorsey hardware

Terry Dorsey started Dorsey Hardware, a small hardware store, two years ago and has struggled to make it successful. The first year of operations resulted in a substantial loss; in the second year, there was a small net income. His initial cash investment was almost depleted because he had to withdraw money for living expenses. The current year of operations looked much better. His customer base was growing and seemed to be loyal. To increase sales, however, Terry had to invest his remaining funds and the proceeds of a USD 40,000 bank loan into doubling the size of his inventory and purchasing some new display shelves and a new truck.

At the end of the third year, Terry's accountant asked him for his ending inventory figure and later told him that initial estimates indicated that net income (and taxable income) for the year would be approximately USD 80,000. Terry was delighted until he learned that the federal income taxes on that income would be about USD 17,250. He told the accountant that he did not have enough cash to pay the taxes and could not even borrow it, since he already had an outstanding loan at the bank.

Terry asked the accountant for a copy of the income statement figures so he could see if any items had been overlooked that might reduce his net income. He noticed that ending inventory of USD 160,000 had been deducted from cost of goods available for sale of USD 640,000 to arrive at cost of goods sold of USD 480,000. Net sales of USD 720,000 and expenses of USD 160,000 could not be changed. But Terry hit on a scheme to reduce his net income. The next day he told his accountant that he had made an error in determining ending inventory and that its correct amount was USD 120,000. This lower inventory amount would increase cost of goods sold by USD 40,000 and reduce net income by that same amount. The resulting income taxes would be about USD 6,000, which was just about what Terry had paid in estimated taxes.

To justify his action in his own mind, Terry used the following arguments: (1) federal taxes are too high, and the federal government seems to be taxing the little guy out of existence; (2) no harm is really done because, when the business becomes more profitable, I will use correct inventory amounts, and this loan from the government will be paid back; (3) since I am the only one who knows the correct ending inventory I will not get caught; and (4) I bet a lot of other people do the same thing.