In some situations, it is impossible to determine the actual cost of the ending inventory. For example, if a firm’s inventory is destroyed in a fire and the cost of the lost inventory must be estimated, it is difficult to do so accurately.

The gross margin method can be used in such circumstances. For a retail store, taking the inventory at cost is difficult, if not impossible. Therefore, the inventory is valued at retail and then converted to cost. This is referred to as the retail inventory method.

Methods of Estimating Ending Inventory

1. Gross Margin Method

The gross margin method is used when a firm wishes to estimate its ending inventory without actually taking a count. For example, firms that wish to determine their ending inventories on a monthly basis certainly do not want to take a physical inventory.

Some firms have inventories in so many locations that a complete physical count would be impossible. And when there are losses from such disasters as fire or flood, it may be impossible to take an ending inventory.

In all these cases, the gross margin method can be used to estimate ending inventories.

The gross margin method is based on the fact that most firms have a gross margin percentage that remains stable. The firm’s past gross margin percentage, therefore, can be used to estimate ending inventories.

To illustrate, assume that the Wong Company began the month of January with an inventory of $20,000 and made net purchases of $170,000 during January.

Net sales for the month totaled $200,000 and the firm’s gross margin percentage remained at 20%. A 20% gross margin implies that the cost of goods sold is 80% of the sales price.

If we put this data into the normal formula to calculate the cost of goods sold, we can easily show how to use the gross margin percentage.

Goods available for sale of $190,000 can be determined from existing records by adding the amount of beginning inventory to the purchases for the period.

The cost of goods sold is equal to 80% of sales, or $160,000. The ending inventory of $30,000 is the difference between the goods available for sale of $190,000 and the coat of goods sold of $160,000.

2. Retail Inventory Method

Retail firms such as department stores and grocery stores use the retail method to determine their ending inventories. In essence, the inventory is taken at retail prices and then converted to cost.

Since the inventories that are displayed on the shelf are priced at retail, the entire inventory for a store, such as a large market, can be taken at retail in just a few hours.

Two or three individuals read the quantity of the items and their retail prices into tape recorders. The tapes are then transcribed and extended, and the result is the total inventory at retail prices.

That is to say, a listing of the tape noting the quantity and prices is made. When the prices and quantities are multiplied, the total inventory at retail is determined. This inventory is then converted to cost by using a cost-to-retail percentage.

This process is considerably less time-consuming than trying to determine the cost of each particular item, even using some cost flow assumptions.

The heart of the retail method is determining a cost-to-retail percentage. This percentage is often calculated by dividing goods available for sale at cost by goods available for sale at retail.

This means that a firm using the retail method must keep track of both inventories and purchases at cost and at retail. This is not as difficult as it seems because most retailers know the retail prices they are going to set on the goods they buy.

The retail method can be used to estimate ending inventories even if a physical inventory has not been taken. This is done by first determining goods available for sale at retail and then subtracting retail sales.

The result is an estimated ending inventory at retail. The ending inventory at cost is then determined by applying a cost-to-retail percentage to the ending inventory at retail.

Let’s illustrate this process using the example of the Martinez Grocery Store.

The cost-to-retail percentage is 80% (i.e., goods available for sale at a cost amounting to $190,000 divided by goods available for sale at retail amounting to $237,500).

The ending inventory at retail of $37,500 is multiplied by this ratio to determine the ending inventory at a cost of $30,000.

Although this example is a simplified version of the retail method, it does indicate the theory behind its application.

In practice, different cost percentages can be used to cost inventories at FIFO, LIFO, and average cost, and other complications are considered in intermediate accounting textbooks.

Frequently Asked Questions

What is meant by ending inventory?

An ending inventory is the last inventory count of a business after all sales and purchases have been recorded for a period. It represents the value of goods leftover in stock at the end of an accounting period.

What are the methods of estimating ending inventory?

The methods used to estimate ending inventory are: a) gross margin method b) retail inventory method

What is the gross margin method?

The gross margin method is used when the company does not maintain an inventory of items that can be resold. This method helps you estimate inventory by using figures from the income statement; specifically, your calculation will use your net sales and your cost of goods sold (COGS).

What is the retail inventory method?

A retail inventory method is a practical approach in determining your ending inventory when your business periodically lists all its merchandise at wholesale prices. This method involves two steps: 1) Determine the value of merchandise available for sale at the end of the accounting period, and 2) determine the value of goods that will be leftover at the end of the accounting period.

What is the purpose of estimating ending inventory?

The purpose of estimating ending inventory is to report the value of your retail merchandise that will be left over at the end of an accounting period. Your business can then use this figure when preparing Financial Statements.

True is a Certified Educator in Personal Finance (CEPF®), a member of the Society for Advancing Business Editing and Writing, contributes to his financial education site, Finance Strategists, and has spoken to various financial communities such as the CFA Institute, as well as university students like his Alma mater, Biola University, where he received a bachelor of science in business and data analytics.

To learn more about True, visit his personal website, view his author profile on Amazon, his interview on CBS, or check out his speaker profile on the CFA Institute website.