In which of the following instances would the use of gross profit method in estimating inventory be not useful?

What is the Gross Profit Method?

The gross profit method estimates the amount of ending inventory in a reporting period. This is of use for interim periods between physical inventory counts. It is also useful when inventory was destroyed and you need to estimate the ending inventory balance for the purpose of filing a claim for insurance reimbursement. The gross profit method is not an acceptable method for determining the year-end inventory balance, since it only estimates what the ending inventory balance may be. It is not sufficiently precise to be reliable for audited financial statements.

How to Use the Gross Profit Method

Follow these steps to estimate ending inventory using the gross profit method:

  1. Add together the cost of beginning inventory and the cost of purchases during the period to arrive at the cost of goods available for sale.

  2. Multiply (1 - expected gross profit %) by sales during the period to arrive at the estimated cost of goods sold.

  3. Subtract the estimated cost of goods sold (step #2) from the cost of goods available for sale (step #1) to arrive at the ending inventory.

In addition, it is useful to compare the resulting cost of goods sold as a percentage of sales to the recent trend line for the same percentage, to see if the outcome is reasonable.

Example of the Gross Profit Method

Amalgamated Scientific Corporation (ASC) is calculating its month-end inventory for March. Its beginning inventory was $175,000 and its purchases during the month were $225,000. Thus, its cost of goods available for sale are:

$175,000 beginning inventory + $225,000 purchases = $400,000 cost of goods available for sale

ASC's gross margin percentage for all of the past 12 months was 35%, which is considered a reliable long-term margin. Its sales during March were $500,000. Thus, its estimated cost of goods sold is:

(1 - 35%) x $500,000 = $325,000 cost of goods sold

By subtracting the estimated cost of goods sold from the cost of goods available for sale, ASC arrives at an estimated ending inventory balance of $75,000.

Problems with the Gross Profit Method

There are several issues with the gross profit method that make it unreliable as the sole method for determining the value of inventory over the long term, which are noted below.

Historical Basis Could Be Incorrect

The gross profit percentage is a key component of the calculation, but the percentage is based on a company's historical experience. If the current situation yields a different percentage (as may be caused by a special sale at reduced prices), then the gross profit percentage used in the calculation will be incorrect.

Assumes Inclusion of Inventory Losses

The calculation assumes that the long-term rate of losses due to theft, obsolescence, and other causes is included in the historical gross profit percentage. If not, or if these losses have not previously been recognized, then the calculation will likely result in an inaccurate estimated ending inventory (and probably one that is too high).

Limited Applicability

The calculation is most useful in retail situations where a company is simply buying and reselling merchandise. If a company is instead manufacturing goods, then the components of inventory must also include labor and overhead, which make the gross profit method too simplistic to yield reliable results.

Short-Term Usage Period

In general, any inventory estimation technique is only to be used for short periods of time. A well-run cycle counting program is a superior method for routinely keeping inventory record accuracy at a high level. Alternatively, conduct a physical inventory count at the end of each reporting period.

Rina Dhillon; Mitchell Franklin; Patty Graybeal; and Dixon Cooper

A business must sometimes estimate inventory values. These estimates could be needed for interim reports, when physical counts are not taken. The need could result from a natural disaster that destroys part or all of the inventory or from an error that causes inventory counts to be compromised or omitted (for example theft or spoilage). Some specific industries (such as retail businesses) also regularly use these estimation tools to determine cost of goods sold.

In the above cases, businesses can estimate its ending inventory using the gross profit (margin) method or the retail method. Although these methods are predictable and simple, and both rely on gross profit margins (also known as mark ups), it is also less accurate since it is based on estimates rather than actual cost figures. Let’s look at each of this method closely.

Gross profit method

The gross profit method is used to estimate inventory values by applying a standard gross profit percentage to the company’s sales totals when a physical count is not possible. The resulting gross profit can then be subtracted from sales, leaving an estimated cost of goods sold. Then the ending inventory can be calculated by subtracting cost of goods sold from the total goods available for sale. To illustrate the gross profit method, assume that In Style Fashion is preparing financial statement and need to estimate the cost of goods sold and ending inventory. In Style Fashion has generated $400000 of sales and historically, the gross profit percentage has averaged 45%. Assuming that this financial period is similar to previous periods, In Style Fashion can estimate that gross profit on current sales is $180000:

In which of the following instances would the use of gross profit method in estimating inventory be not useful?

In Style Fashion can then use this estimated gross profit to estimate the cost of goods sold for the period to be $220000:

In which of the following instances would the use of gross profit method in estimating inventory be not useful?

With this estimated cost of goods sold, In Style Fashion can calculate its ending inventory using the general cost of goods model. Based on prior financial reports, In Style Fashion can determine that the business started the period with $200000 in inventory. Looking at purchase records, they can make out how much inventory they purchased during the period, in this instance $90000 of inventory. This means that In Style Fashion has $290000 in inventory available for sale during the period. With the estimated $220000 cost of goods sold, they can estimate ending inventory to be $70000:

In which of the following instances would the use of gross profit method in estimating inventory be not useful?

Let’s now turn our attention to the retail inventory method.

Retail Inventory method

Likewise, the retail inventory method estimates the cost of goods sold, much like the gross profit method does, but uses the retail value of the portions of inventory rather than the cost figures used in the gross profit method. Essentially, once ending inventory is counted (usually through a stock take), the total sales value of the inventory is reduced by the profit margin. Clothing shops often use the retail inventory method, utilising the current selling price of the garment (say a dress) and reducing prices to cost by the application of average department mark-up ratios. We can usually determine the selling price from price list or cash register or Point Of Sale (POS) system. To illustrate using a simple example, if a business has a gross profit margin of 45.25% (calculated by gross profit/operating revenue), then cost of goods sold is 54.75% (100%-45.25%).

You can read more about the retail method in AASB 102 Inventories paragraph 22.

Lower-of-Cost-and-Net-Realisable-Value

Reporting inventory values on the balance sheet using the accounting concept of conservatism (which discourages overstatement of net assets and net income) requires inventory to be calculated and adjusted to a value that is the lower of the cost calculated using the business’ chosen valuation method or the market value based on the market or replacement value of the inventory items.

Thus, if traditional cost calculations produce inventory values that are overstated, the lower-of-cost-and-net-realisable-value LCNRV (sometimes called the lower of cost or market) requires that the balance in the inventory account should be decreased to the more conservative replacement value rather than be overstated on the balance sheet.

LCNRV is applied at the end of each accounting period by comparing inventory costs to net realisable value (NRV). AASB 102 Inventories does not allow decreases in one category of inventory to be offset against gains in another. In addition, the loss on inventory is usually reported as part of cost of goods sold in the income statement, and in the balance sheet, inventory is reported as a current asset at LCNRV.

Test your knowledge

Why would a business use the gross profit method to estimate inventory?

The gross profit method estimates the value of inventory by applying the company's historical gross profit percentage to current‐period information about net sales and the cost of goods available for sale. Gross profit equals net sales minus the cost of goods sold.

When should the gross profit method of inventory valuation not be used because it is invalid?

The GP method will be invalid in the case where GP margin on sales differs from the margin on closing inventory. This states that on a notable difference in the GP margin, this method will be invalid since the primary assumption to use it is that the GP margin will not change.

Why is the gross profit method not acceptable for year end financial reporting purposes?

As outlined earlier, the gross profit method is not appropriate for annual reports because it only estimates what the ending inventory balance may be and is not conclusive.

What is the importance of gross profit method?

Gross Profit is one of the most important measures to determine the profitability and the financial performance of a business. It reflects the efficiency of a business in terms of making use of its labor, raw material and other supplies.