Producer Price Index Usage by Supermarkets to Increase Tax Deferral

Producer Price Index Usage by Supermarkets to Increase Tax Deferral

The use of Producer Price Indexes instead of Consumer Price Indexes (PPI & CPI) as the tax LIFO inflation measurement source is a tax planning idea that can significantly increase the amount of tax deferral for supermarkets.

Most supermarkets use the LIFO method for inventory valuation and almost all use the IPIC method for their tax LIFO calculations. Taxpayers were first able to use the IPIC method after the IPIC LIFO IRS Regulations were written in 1982. Most of the supermarkets that switched to the IPIC method initially used CPI indexes for these reasons:

  1. The IRS IPIC LIFO Regs. before 2002 required taxpayers using the retail LIFO method to use CPI indexes.
  2. The PPI inflation for supermarkets was not consistently higher than CPI inflation until the 2000s.
  3. There are fewer CPI commodity codes applicable to supermarkets than PPI codes and it requires less effort to obtain breakdowns by CPI codes.
  4. The Food Marketing Institute (FMI) wrote a guide in 1983 entitled Handbook for LIFO Tax Valuations-Inventory Price Index Computation Method (IPIC) that was a practical how-to guide that was used extensively by supermarkets electing the IPIC LIFO method and this guide described how to change to the IPIC method using CPI indexes.

The IPIC LIFO Regs. that were written in 2002 specifically permitted retailers to use either CPI or PPI indexes (non-retailers can only use PPI indexes). The CPI and PPI inflation for supermarkets had been about the same for years before 2002 but since then PPI inflation for supermarkets has been consistently higher than CPI inflation by an average of about 1.5% annual inflation. This means that supermarkets using PPI indexes during that time enjoyed annual tax deferral about 70% greater than if CPI indexes were used. Supermarket CPI inflation has not exceeded PPI inflation for any year since 2002.

1.5% additional inflation each year will increase the tax LIFO expense by $150,000 per year for a taxpayer with $10 million in inventory investment, by $1.5 million per year for $100 million of inventory and by $15 million per year for $1 billion of inventory.

Some of the large supermarkets switched to use PPI indexes in about 2005 and some smaller supermarkets now use PPI indexes but the majority (by numbers) of supermarkets continue to use CPI indexes.

Most publicly traded supermarkets use internal indexes for financial reporting LIFO but many privately owned supermarkets use the IPIC method for financial reporting as well as for tax purposes. Some supermarkets that switched to use PPI indexes continue to use CPI indexes for financial reporting and the IRS Regs. LIFO conformity rule specifically permits this.

CPI v. PPI Supermarket Inflation Comparison

The historical CPI v. PPI supermarket inflation spread through August ’22 is shown in the table below:

Inflation Rate PeriodPPI InflationCPI InflationDIFF: PPI vs. CPI
8 Months Ended August '227.5%8.5%-1.0%
7 Months Ended July '227.5%7.7%-0.3%
6 Months Ended June '227.1%6.5%0.7%
5 Months Ended May '226.1%5.5%0.6%
4 Months Ended April '225.3%4.5%0.9%
3 Months Ended March '224.0%3.5%0.5%
2 Months Ended February '222.8%2.4%0.5%
1 Month Ended January '221.6%1.2%0.3%
12 Months Ended December '215.1%3.7%1.4%
12 Months Ended December '201.0%1.8%-0.8%
12 Months Ended December '191.3%0.9%0.4%
12 Months Ended December '182.8%0.4%2.4%
12 Months Ended December '172.9%0.5%2.4%
12 Months Ended December '161.3%0.1%1.2%
12 Months Ended December '150.2%0.1%0.1%
12 Months Ended December '145.1%2.5%2.6%
12 Months Ended December '132.0%0.1%1.9%
12 Months Ended December '122.7%1.0%1.7%
12 Months Ended December '115.2%4.1%1.1%
12 Months Ended December '102.9%0.9%2.0%
3 Year Average Ended Dec. '212.5%2.1%0.4%
5 Year Average Ended Dec. '212.4%1.2%1.2%
10 Year Average Ended Dec. '212.5%1.1%1.3%

A change from CPI to PPI indexes is an automatic approval method change which means that the required IRS Form 3115 Application for Change in Accounting Method can be filed with the tax return for the year of the change. Once this change has been made a taxpayer cannot switch back to use CPI indexes for 5 years. There is no guarantee that supermarket PPI inflation will continue to substantially exceed CPI inflation.

Some possible reasons for PPI inflation for supermarkets being consistently higher than CPI inflation include:

  1. Drugs – PPI drug inflation has been 2% to 3% higher than CPI inflation (about double) for each of the 3, 5 and 10 year periods ending December 2013. It is likely that the CPI sampling methods used for drugs produces less CPI inflation. When drugs change from branded to generic or from prescription to nonprescription they typically decrease in price. After such change, if a drug is not considered a new item for CPI price samples but is for PPI samples this could contribute to lower CPI drug inflation compared to PPI drug inflation.
  2. Nonfoods – PPI inflation for items other than food and drugs has been substantially higher than CPI inflation and this is why almost all department store and discount store retailers use PPI indexes for tax LIFO. PPI indexes are a measurement of the selling price of goods produced by domestic producers in the U.S. CPI indexes are a measurement of the marked selling prices for retail stores located in the U.S. A logical inference is that the many less-expensive imported goods now available in American stores results in lower CPI inflation.
  3. Food and beverages – PPI food and beverages inflation has been at least 1% more than CPI inflation for each of the 3, 5 and 10 year periods ending December 2013. I do not know why this difference exists and the BLS offers no explanation either.

There are about 100 most-detailed CPI commodity codes applicable to the typical supermarket’s inventory but a substantially greater number of most-detailed PPI commodity codes apply. The IRS IPIC LIFO Regs. provide for a shortcut known as the 10% method which allows taxpayers to use less-detailed CPI and PPI commodity codes which reduces the minimum number of LIFO count codes to 33 for CPI and 55 for PPI.

Some larger supermarkets now use perpetual inventory systems that facilitate getting CPI and PPI LIFO count codes breakdowns. This is typically accomplished by mapping classes of inventory (which represent groups of similar items) to CPI or PPI codes. If these classes are not detailed enough for a single CPI or PPI count code to be assigned to a class, then CPI or PPI count code assignments may need to be made on an item-by-item basis.

Most smaller supermarket chains use the retail inventory method for non-perishable inventories which means that the required CPI or PPI code breakdowns must be obtained from physical inventory counts. There are procedures used by companies and their inventory services all across the U.S. that facilitate the required breakdowns whether the physical inventories are scanned or not.

The two guides LIFO-PRO, Inc. has written to describe the ways in which supermarkets can get the required breakdowns by PPI count codes are Inventory Accounting Requirements for Supermarkets using the Simplified LIFO (IPIC) Method and Guide for Planning & Implementation of the IPIC LIFO Method for Supermarket Chains.

Here are different ways supermarkets can get inventory balance breakdowns by CPI or PPI count codes:
Supermarket LIFO Count Procedures

Contact LIFO-PRO to obtain more information on the subject of PPI Index Usage by Supermarkets to Increase Tax Deferral.

Resources

Sec. 473 Relief Estimate Request Form
Read more
Auto Dealer IPIC LIFO Case Study
Read more
2023 Top LIFO Opportunities & Strategies Guide
Read more
How LIFO Works: A Beginner’s Guide to LIFO
Read more
How to Identify Clients that are Good LIFO Election Candidates
Read more
How to Easily Implement LIFO
Read more
Complimentary Interim LIFO Estimate Request Form
Read more
Best LIFO Practices & Review
Read more
Auto Dealer LIFO Case Study
Read more
LIFO Election Benefit Analysis
Read more
Downloads

Get information about LIFO-PRO’s offerings, valuable guides & white papers & sample LIFO reports!

Read more
IPIC LIFO Guide

Get educated on the Inventory Price Index Computation (IPIC) method, including the origins, advantages & disadvantages, calculation procedures, options & much more!

Read more
Service Organization Control Report

Learn how LIFO-PRO receives an annual review of our policies & procedures to provide required assurances to our clients.

Read more
LIFO Tax Benefit Calculator

Calculate the potential tax savings from using LIFO & determine your company’s historical inflation percentages!

Read more
Secure File Upload Portal

Here you can send us all files needed for us to seamlessly give you the best LIFO results possible. We look forward to working with you!

Read more
CPA Firm LIFO Opportunities & Training Guide

Learn about LIFO opportunities abound for CPA firms, how to increase the scope of your LIFO offerings & learn how to easily identify good LIFO candidates!

Read more
Interim Estimate Options

Learn how to easily make interim LIFO estimates manually or within our software!

Read more
Non-disclosure Agreement Request Form

Get a NDA generated electronically in less than a minute using LIFO-PRO’s online request form page & avoid having to print, sign & scan a paper NDA!

Read more
IPIC LIFO Resources

Learn how the IPIC LIFO Method works, find valuable Bureau of Labor Statistics (BLS) links and stay up to date on all changes related to the IPIC Method!

Read more
LIFO Success Stories

Learn about LIFOPro’s past roles in partnering with companies & CPA firms to deliver great value by finding solutions to the most challenging LIFO issues!

Read more
IPIC LIFO Overview

The Inventory Price Index Computation (IPIC) method allows taxpayers to use published external indexes to calculate inflation for the purpose of valuing LIFO inventories.

Read more
LIFO Methods, Rules & Regulations

Your comprehensive resource for authoritative LIFO guidance, LIFO election requirements, and method alternatives!

Read more
Supermarket Physical Count Procedures

Find helpful information on how IRS regulations effect grocery LIFO Count Procedures for CPI & PPI taxpayers on our Supermarket Count Procedures page.

Read more
Special Challenges for Supermarkets

Supermarkets face LIFO calculation issues unique to the industry. Find out why & answers to how they are dealt with Special Challenges for Supermarkets page.

Read more
Why the Double-extension LIFO Index Calculation Method is Unreliable

Facts describing why the double-extension LIFO index calculation method is unreliable and examples proving how this method creates unpredictable results.

Read more
Addition of Services Table 9 Codes

Find recent important changes & BLS addition of Table 9 Wherever-provided Services & Construction PPI Indexes & Important Change in PPI Code Structure page.

Read more
CPI Category Updates

Find information on CPI Category Changes & Bureau of Labor Statistics Consumer Price Index update information such as new medical commodity codes here!

Read more
PPI Category Updates

Learn IRS Regulations Requirements for missing PPI Indexes, procedures for reassigning discontinued PPI Categories at LIFO-PRO’s PPI Category Changes page.

Read more
Producer Price Index Usage by Supermarkets to Increase Tax Deferral

Learn how drugs, non-foods & food/beverage indexes cause increase LIFO tax benefits at our PPI Index Usage by Supermarkets to Increase Tax Deferral page.

Read more
BLS CPI & PPI Inflation History

Get the most up to date Bureau of Labor Statistics Consumer & Producer Price Index inflation data from LIFOPro!

Read more
IPIC LIFO Advantages

Switching from the double-extension to link-chain method? Want to achieve higher possible inflation indexes? Learn more at the IPIC LIFO Advantages page.

Read more
LIFO Repeal Updates

Get the latest LIFO repeal updates including the latest news on corporate tax reform at LIFO-PRO’s LIFO Repeal Updates page.

Read more
LIFOPro Videos

LIFO-PRO Company Overview – Quick 1 minute video explaining LIFO-PRO’s service and software offerings.

Read more
Request Forms Page

Request a software trial, LIFO Election Benefit Analysis, Best LIFO Practices Methods Review or cost estimate. All of our requests are complimentary & free of obligation!

Read more
FAQ’s

View some of our frequently asked questions to learn more about LIFO

Read more
LIFO Glossary

Accounting and financial professionals who work with LIFO need to understand the jargon associated with LIFO. Below are a number of LIFO-related terms.

Read more
What Makes a Good LIFO Candidate?

Get answers to who should use the LIFO method, how much LIFO may benefit your company or client & good LIFO candidates by industry & principal business activity along with historical inflation data.

Read more
How LIFO Works

Hundreds of companies & CPA firms utilize our LIFO outsourcing solutions or the LIFO-PRO software for turnkey LIFO solutions.

Read more

Schedule a Call or Demo Today

Have a phone call or WebEx with the LIFO-PRO team to get started today or learn more about our offerings. Schedule online using our easy-to use booking tool.

Subscribe Today

Sign up today to receive industry news & promotional offers from LIFO-PRO