PPI Category Updates

PPI Category Updates

IRS Reg. § 1.472-8(e)(3)(iii)(B)(2) requires taxpayers other than retailers to use indexes published by the BLS in PPI Detailed Report Table 6 unless a more appropriate index from Table 5 is published. The BLS renumbered their PPI detailed reports beginning January 2014 so that the data previously labelled Table 6 is now Table 9 and the data previously labelled Table 5 is now Table 11. IPIC LIFO taxpayers should now use indexes from PPI Detailed Report Table 9. Rarely will Table 11’s industry-based indexes be more appropriate than Table 9’s commodity-based indexes.

PPI Category Changes & Maintenance

The CPI Table 3 categories published by the BLS rarely change; the last significant change was made in 1998. There are only about 200 CPI commodity categories and indexes are published every month for these categories without exception.

The same is not true of the PPI Table 9 categories. The PPI Table 9 categories the Bureau of Labor Statistics publishes indexes for change twice a year making it difficult to maintain an official “list” of valid PPI categories that FIFO inventory balances should be assigned to for IPIC method LIFO calculations. Each January and July the BLS publishes a list of categories which will no longer have published indexes. There are usually about 100 categories (of a total of about 2,500) discontinued each year. There were over 500 categories discontinued after December 2003 but this was an abnormally high number that coincided with the implementation of the new NAICS industry codes

Categories are discontinued as the related products become obsolete. Many changes are also made because the BLS changes the organization of categories for a type of product. An example of this are changes in lumber categories from tree species identification (fir, pine and other) to stage of finishing (edge worked v. not edge worked). Another example is a change in soft drinks categories from flavors (cola, root beer, etc.) to bottling type (bottles v. can).

New categories are added because of new products being marketed or new variations of existing products. The number of new categories has been less than the number discontinued in recent years.

The BLS occasionally changes the category codes for existing products. For example, in July 1999 the BLS discontinued use of the 067506 and 067507 series of categories because the goods encompassed by them were reassigned to a new 067514 series.

Another challenge of working with PPI Table 9 categories is what we call “seasonally published” categories. This occurs often for products such as produce. There are also categories we describe as “sporadically published” which are categories for which the volume of transactions sampled is small enough that not enough price survey responses are returned to the BLS to constitute a valid sample. It is common for such categories to eventually be discontinued if indexes cannot be published on a regular basis

For companies using the 10% method, there is also a problem of PPI indexes being published for a category so obscure that the BLS weight is .000 which means the weight is less than .0005.

Assignment of FIFO inventory balances to discontinued PPI categories or categories with missing indexes presents a problem for IPIC calculations, especially when the most-detailed categories method is used because missing indexes are more common for PPI most-detailed categories.

IRS Regs. Requirements For Missing PPI Indexes

The IRS IPIC method Regs. revised in 2002 address both situations for which PPI indexes are not available:

Index not published but category not discontinued – IRS Reg. § 1.472-8(e)(3)(iii)(D)(2) addresses this. This section reads “If a BLS price index for a most-detailed or 10 percent BLS category is not otherwise available for the appropriate or representative month (but not because the BLS categories in the BLS table have been revised), the taxpayer must use the BLS price index for the next most-detailed BLS category that includes the specific item(s) in the most-detailed or 10 percent BLS category.” We refer to this treatment as the “substitute index method”. This is how our LIFO-PRO software handles these situations.

Index not published because category was discontinued – Reg. § 1.472-8(e)(3)(iii)(D)(4) states that “…If the BLS has revised the applicable BLS table for a taxable year, a taxpayer must compute the category inflation index for each BLS category for which the taxpayer cannot compute a category inflation index in accordance with paragraph (e)(3)(iii)(D)(3) of this section (affected BLS category) using a reasonable method, provided the method is used consistently for all affected BLS categories within a particular taxable year.” This Reg. paragraph goes on to say “The compound category inflation index described in paragraph (e)(3)(iii)(D)(4)(ii) of this section is a reasonable method of computing the category inflation index for an affected BLS category.” The compound inflation method entails the multiplication of partial year inflation rates for both the discontinued and replacement categories.

We believe the substitute index method is a reasonable method of handling discontinued categories. The substitute index method is more practical because it is simpler and should not produce indexes that are substantially different from those calculated using the compound inflation method in most cases.

Reassignment Of Inventory Balances For Discontinued Categories

When PPI categories are discontinued, FIFO inventory balances need to be reassigned from discontinued categories to appropriate replacement categories. This may not solve the problem of missing indexes for calculations in the year for which a category is discontinued. For example, the 15950301 Black graphite pencils category was discontinued after December 2001. A new category, 15950304 Nonmechanical pencils, crayons and chalk was introduced in December 2001. If an index calculation is made for a December 2002 year end and December is also the appropriate index month, FIFO inventory values can be assigned to 15950304 and indexes will be available for both December 2001 and 2002. If a November appropriate index month (or any month other than December) is used, there will be a November 2002 index published for 15950304 but not for November 2001 and there will be a November 2001 index published for 15950301 but not for November 2002. The alternatives for dealing with missing indexes are the compound inflation or substitute index methods described above or other reasonable method.

Our LIFO-PRO software automatically makes reassignments of inventory balances assigned to PPI categories that have been discontinued in the first period for which the new category can be used (indexes for the new category have been published for both the current and prior year appropriate index months). The inventory reassignments are to replacement categories that we have deemed appropriate.

Our software also alerts users to the fact that such a reassignment will be made the following year for a discontinued category. In both cases, a report is generated explaining these actual and future reassignments. While it is far more common for there to be a single appropriate replacement category for more than one category discontinued, in some cases there are more than one possible replacement category for a single discontinued category. An example of this was the changes made after December 2005 when these changes were made in the 0721 Construction products from plastic categories. 07210601 Plumbing products category was discontinued and these three new categories were added: 07210602 Other plastic construction products, 07210603 Plastics pipe and 07210604 Plastics pipe fittings and unions. The LIFO-PRO software alerts users to the fact that there are multiple possible replacement categories if inventory balances have been assigned to a category discontinued for which more than one possible replacement category exists.

Our LIFO-PRO software will automatically reassign discontinued categories that are replaced by a single replacement category. Software users should actually make the appropriate reassignments for new PPI categories in subsequent years’ Excel input files.

While our software automatically makes replacements for discontinued categories we also provide comprehensive documentation of new, discontinued and reassigned categories.

LIFO-PRO Information About New, Discontinued And Reassigned PPI Categories

We provide a PPI categories maintenance reference tool to our clients that has proven to be very helpful in dealing with changes in PPI categories and has saved countless hours of research. This tool is an Excel file which documents all changes in the PPI Table 9 categories for the past 20 years. This file not only lists the new and discontinued PPI categories but also the appropriate categories to be used in place of the discontinued categories. The BLS does not provide information about appropriate replacement categories in the PPI Detailed Reports. The information about appropriate replacement categories is based on our research and consultation with the BLS.

This Excel file documents our review of categories to determine which have been discontinued, added or reassigned by the BLS for every year since 1996.

When PPI categories are discontinued there are often new categories created at the same time that take the place of the discontinued categories. For example, the 0635 Prescription drugs and 0636 Over-the-counter drugs categories (and the more-detailed categories they include) were discontinued in June 2001. The 0638 Pharmaceutical preparations series of categories was introduced in June 2001 to replace the 0635 and 0636 series of categories. This change was made because the BLS believed the new categories better facilitated taking price surveys. This is a common reason for changes of this nature. In some cases, categories are discontinued because products become obsolete and some categories are added because of the creation of new products.

The replacement categories listed in these sheets are those judgmentally assigned by LIFO-PRO, Inc. based on our research and experience. These are not “official” BLS replacement categories. Please contact us if you feel any of the replacement categories we have designated are not proper. We have found BLS personnel to be quite helpful in answering questions about which PPI category is applicable to particular items. The phone number for the PPI analysts at the BLS is 202-691-7705. We update this file annually.

Companies wishing to determine which months’ indexes are published for any PPI Table 9 category can do so by reference to the LIFO-PRO .ppi files available on our web site and which are automatically downloaded by the LIFO-PRO software. These are text files which may be viewed in Excel or any text editor. This research can also be done by going to the BLS web page which displays indexes for any category selected for any period for which indexes have been compiled, going back as far as 1913. You can go to that page which they label as Commodity Data by clicking on the following link:
PPI Commodity Data

In 2005 the BLS changed the way PPI Table 9 categories are organized. Previously all PPI categories published, whether they were active or discontinued categories, were included at this Commodity Data (wp) web site. The discontinued categories and their index histories are no longer included at that web site. You can access the page for discontinued categories which they label as Commodity Data-Discontinued Series by clicking on the following link:

The indexes to request at both these sites are the “not seasonally adjusted indexes”. It should be noted that these indexes may not be the same as the indexes in the .ppi files used by LIFO-PRO since the BLS web page indexes are “final” indexes for all but the most recent four months and the .ppi file indexes are “preliminary” indexes for all periods to facilitate calculations sooner than would be possible using final indexes. Please contact us if you need preliminary PPI Table 9 indexes for any period since 1991.

LIFO-PRO Software Updates for Discontinued & Missing PPI Indexes

As of 2/10/2001, corresponding to LIFO-PRO Version 2.2, our software was changed with respect to the way in which missing PPI indexes or BLS weights are treated. In versions prior to 2.2, the index, BLS weights and/or FIFO dollars for these categories were excluded from that pool’s index calculation. LIFO-PRO was programmed to make calculations this way because the missing indexes typically occur for some of the more obscure categories in which companies are not as likely to have significant inventory amounts. With 2.2 we changed the software to use substitute indexes instead of excluding these categories. We call this method the “substitute index method”. The default setting for LIFO-PRO for versions 2.2 and higher for missing PPI indexes is now to use the indexes (current and prior year) of the next-less-detailed category which includes the missing index category. For example, if December is the index month and the December 2000 index is present but the December 1999 index is missing for category 02780102, the index used for 02780102 will be the Dec. 2000/Dec. 1999 indexes for 027801. The BLS weight for 02780102 will still be used if required for 10 percent method calculations. The LIFO-PRO IPIC calculation Reports 23 & 24 will include notations explaining which categories are using substitute indexes, which category’s indexes are being substituted and which index (current or prior year or both) is missing. LIFO-PRO users will have the option to use the old category exclusion method if they choose (at the bottom of the IPIC Settings screen) but we would not recommend that clients use this. This option is available primarily to provide a means to make past years calculations in the same manner as older versions of LIFO-PRO.

For categories with BLS weights which are zero (less than .0005), these categories will be excluded for 10 percent method calculations, as before, because we don’t think it would be appropriate to use the greater weight of the next-less-detailed category. The process of obtaining the most current months’ PPI indexes for our software also updates the official list of PPI categories and appropriate replacement categories. The download of the most recent month’s CPI or PPI index files that LIFO-PRO reads is automated in software versions 3.2 and higher. These files can be manually downloaded from our Downloads web page for earlier software versions or for situations where automatic file downloads from web servers are blocked by a firewall.

Preliminary v. Final PPI Table 9 indexes

IRS Reg. § 1.472-8(e)(3)(iii)(D)(2) permits taxpayers to use either preliminary or final PPI indexes provided there is consistent use of one or the other. A change from final to preliminary is an automatic approval accounting method change. If a taxpayer makes this change, however, they cannot switch back to the previous method for five years from the date of change.

The PPI Table 9 indexes published during the third week following a month end are “preliminary” indexes. Four months later, “final” indexes are published. The final indexes include price surveys received after the normal month end cutoff and corrections of errors found after the preliminary indexes are published. The differences between the preliminary and final are typically small. The great majority of taxpayers use preliminary indexes so they can complete their LIFO calculations sooner than if final indexes are used. The fact that there are both preliminary and final PPI indexes published causes some confusion.

The indexes published in PPI Detailed Report Table 9 are preliminary indexes. These reports also show the final indexes for the index published five months ago. For example, in the March 2007 PPI Detailed Report, the March and February 2007 preliminary indexes are shown but the November 2006 final indexes are also shown because this is the first month for which the final indexes were compiled. These reports also have two columns for percent changes. The March 2007 book shows the percentage change to March 2007 from March 2006 and February 2007. The percent change from March 2006 to March 2007 cannot be used for IPIC method LIFO calculations because this percent is calculated by dividing the March 2007 preliminary indexes by the March 2006 final indexes and the Regs specify that although you can use either of preliminary or final indexes, you must do so consistently.

The paper version of the PPI Detailed Reports are not available until at least a couple of months after the indexes are compiled however these reports are now available online (starting with the June 2005 reports) at http://www.bls.gov/ppi/ppi_dr.htm on the BLS Web site during the third week following a month end.

The BLS maintains a database of all PPI indexes published for all periods going back to before the 1920s in some cases. The URLs for the PPI Table 9 categories on the BLS web site are:

Active categories:

Discontinued categories:

The “seasonally adjusted” check box should be unchecked because the IRS Regs. specify that “not seasonally adjusted” indexes be used. The indexes displayed from this URL have a (P) note by the latest four months’ indexes denoting that these are preliminary indexes. All other indexes displayed are final indexes. The BLS does not make available a database of preliminary PPI table 9 indexes which is inconvenient since most IPIC LIFO taxpayers use preliminary indexes. For months prior to June 2005 — when the BLS started making PDF versions of the PPI Detailed Reports available online — the only way to know what the preliminary indexes were if you did not save the preliminary indexes within that four month time frame was by reference to the printed PPI Detailed Reports.

BLS PPI table 9 Preliminary Index Database


PPI Commodity Code Structure Change – Addition Of Services Table 9 Codes

There was a major change introduced into the organization of the PPI Table 9 codes by the Bureau of Labor Statistics (BLS) starting with the July 2009 PPI Detailed Report.

Click here for a detailed description of the changes


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

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

Read more

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

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