Bob Richardson

Instructions:

  • Identify the year to date & 20 year average annual historical inflation rates for your company using the tables shown below the calculator
  • Enter the following values into the blue-colored cells:
    • Prior year end inventory balance at cost
    • Current year inflation rate
    • 20 year average annual inflation rate: used to calculate the 20 year projected tax savings
    • Combined federal & state tax rate
  • The green-colored cells will automatically update as soon as all values have been entered into the blue-colored input cells

Note: LIFO is adopted on a prospective basis & LIFO tax savings accrue beginning in the year of the change. Prior period benefits can NOT be retrospectively recaptured. 20 year cumulative taxable income reduction & after-tax cash savings shown in calculator are for analysis purposes only & is provided to project the potential tax savings from LIFO that could occur over the next 20 years based on your current year inventory balance at cost & the historical inflation rates.

BLS PPI Annual Inflation Rate Averages Table for Selected Commodities Through November 2024

 PPI CodeBLS PPI Category Description1M 11/24YTD 11/241YR 11/243YR 11/245Y 11/2410YR 11/2420Y 11/24
01FARM PRODUCTS6.4%7.9%6.2%4.4%7.3%1.6%3.4%
011Fruits & melons, fresh/dry vegs. & nuts23.1%21.6%18.6%4.3%5.6%3.9%3.3%
012Grains7.7%-11.4%-10.5%-10.2%2.2%1.1%3.7%
013Slaughter livestock2.6%18.6%14.4%14.3%11.8%1.1%4.0%
014Slaughter poultry-0.1%1.2%11.7%6.6%10.5%2.0%3.8%
015Raw cotton-0.8%-16.5%-13.4%-17.5%1.2%-0.3%2.0%
016Raw milk-10.4%12.9%11.8%10.9%6.2%0.7%2.3%
017Chicken eggs54.6%127.0%94.4%58.3%25.3%11.1%10.3%
018Hay, hayseeds and oilseeds1.2%-22.0%-26.4%-7.1%1.7%-0.4%3.1%
02PROCESSED FOODS AND FEEDS0.8%4.2%3.6%4.3%5.0%2.1%3.0%
021Cereal and bakery products-0.3%-0.7%-0.6%5.3%4.9%2.7%3.2%
022Meats, poultry, and fish2.6%9.8%9.1%2.0%5.6%1.5%2.9%
023Dairy products-0.7%6.9%5.4%4.7%3.2%0.9%2.3%
024Processed fruits and vegetables-1.2%0.5%0.9%9.6%7.1%4.1%3.9%
025Sugar and confectionery1.1%11.5%11.9%9.1%5.7%3.3%3.4%
026Beverages and beverage materials0.0%3.8%3.1%5.8%4.5%2.9%2.6%
027Fats and oils3.7%-4.4%-7.4%-4.8%6.9%2.6%3.1%
028Miscellaneous processed foods1.3%3.0%3.1%6.7%5.3%2.9%2.9%
029Prepared animal feeds-0.5%-4.8%-6.1%1.1%4.2%1.0%3.7%
03TEXTILE PRODUCTS AND APPAREL-1.1%0.0%-0.6%2.4%4.1%2.4%2.1%
031Synthetic fibers-5.9%-1.6%-5.2%0.4%3.7%2.4%1.9%
032Processed yarns and threads-0.1%0.7%-0.7%0.1%4.8%2.3%2.4%
033Greige fabrics0.0%-0.6%-0.4%2.3%3.9%1.8%2.0%
034Finished fabrics0.0%0.6%1.0%2.9%4.7%2.8%2.6%
038Apparel & other fabricated textile prods0.0%1.9%1.9%3.8%3.3%2.2%1.9%
039Miscellaneous textile products/services-2.5%-9.4%-7.7%3.1%6.5%2.2%1.8%
04HIDES, SKINS, LEATHER, AND RELATED PRODUCTS0.8%-0.1%-0.3%1.6%1.8%-2.7%0.4%
041Hides and skins, incl. cattle3.5%-8.8%-10.0%-7.1%-4.7%-12.0%-3.5%
042Leather0.8%0.0%0.2%0.8%2.4%-4.1%-0.4%
043Footwear0.0%1.8%1.9%4.9%4.0%2.9%2.8%
044Other leather and related products0.5%2.2%2.2%3.7%3.2%2.5%2.1%
05FUELS AND RELATED PRODUCTS AND POWER-2.3%-2.8%-10.1%-3.3%4.8%1.0%2.1%
051Coal-0.2%1.3%2.6%12.9%7.4%3.8%4.9%
053Gas fuels4.5%-10.1%-18.2%-26.4%1.6%-4.7%-4.9%
055Utility natural gas2.6%-2.7%-1.8%-4.6%7.4%3.1%1.3%
056Crude petroleum (domestic production)-3.8%1.5%-12.0%-6.1%3.8%-1.2%2.2%
057Petroleum products, refined-3.6%-5.2%-17.1%-4.7%4.6%0.1%2.9%
058Asphalt and other petroleum and coal products, n.e.c.-1.9%-11.3%-30.9%-5.7%2.4%-1.1%6.5%
06CHEMICALS AND ALLIED PRODUCTS-0.8%1.4%0.9%-0.3%4.0%2.2%3.3%
061Industrial chemicals-2.9%-0.4%-1.7%-4.3%4.2%0.6%2.7%
062Paints and allied products0.3%0.8%0.6%6.1%6.4%4.0%4.0%
063Drugs and pharmaceuticals0.1%2.4%2.4%2.8%2.4%3.7%4.4%
064Fats and oils, inedible0.8%11.3%7.6%-2.1%11.8%4.0%5.2%
065Agricultural chemicals and chemical products0.9%0.7%0.9%-2.3%6.1%2.0%3.3%
066Plastic resins and materials-0.6%3.1%2.8%-5.7%3.7%0.3%2.1%
067Other chemicals and allied products0.0%0.9%1.0%5.3%4.6%2.9%2.9%
07RUBBER AND PLASTIC PRODUCTS-0.3%0.9%1.1%2.7%5.4%2.9%3.1%
071Rubber and rubber products-0.4%2.0%1.8%4.3%4.6%2.4%3.0%
072Plastic products-0.3%0.6%0.9%2.3%5.6%3.1%3.2%
08LUMBER AND WOOD PRODUCTS0.3%1.4%1.4%-0.2%4.9%2.9%2.2%
081Lumber2.0%9.4%9.3%-4.3%4.6%2.2%1.5%
082Millwork-0.1%1.4%0.9%2.6%6.1%4.2%3.0%
083Plywood-0.4%-4.6%-5.7%-1.4%6.8%2.4%2.2%
084Other wood products-0.1%-3.4%-2.0%-0.1%3.4%2.5%2.2%
085Logs, bolts, timber, pulpwood, woodchips and other roundwood products-0.2%-1.5%-2.2%-0.7%1.8%0.7%1.4%
086Prefabricated wood buildings & components-0.5%1.2%1.5%3.8%7.4%5.0%3.3%
087Treated wood and contract wood preserving0.8%-0.3%0.8%5.0%5.8%3.1%2.7%
09PULP,PAPER, AND ALLIED PRODUCTS0.0%3.4%2.7%3.8%5.8%3.1%2.7%
091Pulp, paper, and prod., ex. bldg. paper-0.4%3.9%2.9%2.9%5.6%2.8%2.8%
092Building paper & building board mill prods.10.6%-0.6%-2.4%-4.8%10.2%5.4%3.3%
094Publications, printed matter & printing material0.0%2.5%2.6%7.4%6.0%3.5%
10METALS AND METAL PRODUCTS0.4%-0.3%1.6%-2.4%7.5%3.8%3.4%
101Iron and steel0.8%-9.6%-5.9%-11.8%7.8%2.8%2.5%
102Nonferrous metals-0.7%8.5%10.6%1.2%7.7%3.9%4.3%
103Metal containers-0.4%0.2%0.2%5.1%6.7%4.0%3.3%
104Hardware0.2%0.4%0.0%2.3%5.0%3.2%2.9%
105Plumbing fixtures and fittings0.0%1.6%1.6%4.3%4.0%3.0%2.9%
106Heating equipment0.0%2.3%2.5%6.9%7.4%5.0%4.3%
107Fabricated structural metal products1.2%-0.8%0.4%2.4%9.2%5.4%3.9%
108Miscellaneous metal products0.5%3.1%3.0%4.7%5.4%3.2%2.7%
11MACHINERY AND EQUIPMENT0.1%2.8%2.7%5.4%4.7%2.8%1.9%
111Agricultural machinery and equipment0.2%1.0%1.1%6.0%6.2%3.8%3.3%
112Construction machinery and equipment0.2%1.0%1.7%6.0%5.7%3.6%3.2%
113Metalworking machinery and equipment0.0%3.4%3.5%6.1%4.9%3.1%2.5%
114General purpose machinery and equipment0.0%3.2%3.0%7.5%6.7%4.4%3.8%
115Electronic computers and computer equipment-0.8%1.4%2.1%56.0%30.6%12.6%3.0%
116Special industry machinery and equipment0.0%2.8%2.9%6.0%6.1%3.7%2.6%
117Electrical machinery and equipment0.2%2.6%2.5%3.9%3.4%2.0%1.0%
118Miscellaneous instruments0.4%3.8%3.9%6.3%4.6%3.2%2.5%
119Miscellaneous machinery0.1%2.7%2.6%4.6%3.6%2.2%2.3%
12FURNITURE AND HOUSEHOLD DURABLES0.0%1.5%1.1%3.8%4.6%3.1%2.4%
121Household furniture0.0%1.4%1.4%2.8%4.3%3.1%2.6%
122Commercial furniture0.0%2.9%2.3%5.9%6.3%4.2%3.3%
123Floor coverings-1.2%2.2%0.8%0.6%1.9%1.6%2.1%
124Household appliances-0.3%-1.3%-1.6%3.6%3.8%2.5%1.9%
125Home electronic equipment0.0%1.5%1.5%3.1%3.8%2.1%0.0%
126Other household durable goods1.4%2.5%2.4%3.9%4.7%2.9%2.2%
13NONMETALIC MINERAL PRODUCTS-0.2%3.5%3.6%7.3%6.3%4.3%4.0%
131Glass-2.6%-1.3%-0.5%3.6%3.9%3.3%2.1%
132Concrete ingredients and related products0.2%6.9%7.2%9.1%7.1%5.5%4.7%
133Concrete products0.4%3.8%3.7%8.8%7.3%5.3%4.3%
134Clay construction products ex. refractories0.9%1.4%1.3%5.0%4.4%2.8%2.1%
135Refractories0.3%2.0%2.4%5.5%4.7%3.7%3.9%
136Asphalt felts and coatings-1.3%1.1%1.3%5.3%6.9%3.8%5.3%
137Gypsum products0.5%5.5%5.2%6.5%8.6%5.0%4.2%
138Glass containers-0.2%7.3%7.2%9.0%7.1%4.3%3.6%
139Other nonmetallic minerals-0.3%3.0%2.8%6.7%5.3%2.9%3.9%
14TRANSPORTATION EQUIPMENT0.2%1.7%1.7%2.8%2.6%1.7%1.6%
141Motor vehicles and equipment0.2%1.1%1.0%2.4%2.4%1.6%1.3%
142Aircraft and aircraft equipment0.2%3.6%3.8%3.9%2.9%2.0%2.3%
143Ships and boats0.1%1.7%1.8%3.6%3.2%2.4%2.5%
144Railroad equipment0.2%0.3%0.3%0.2%1.2%0.9%2.0%
149Transportation equipment, n.e.c.-0.1%-1.6%-1.8%2.4%3.1%2.5%1.8%
15MISCELLANEOUS PRODUCTS0.9%5.7%6.0%6.6%5.7%4.2%3.4%
151Toys, sporting goods, small arms, etc.0.0%3.0%2.9%6.6%6.0%3.6%2.6%
152Tobacco products, incl. stemmed & redried1.9%11.6%11.5%11.1%9.5%7.6%6.2%
153Notions0.0%-0.1%1.8%4.2%4.9%3.1%3.6%
154Photographic equipment and supplies9.6%8.6%17.3%7.9%6.0%3.8%3.1%
155Mobile homes0.1%1.6%0.8%3.1%8.4%6.2%4.6%
156Medical, surgical & personal aid devices0.3%2.0%2.2%3.0%2.2%1.6%1.3%
157Other industrial safety equipment0.1%3.7%3.7%6.0%5.6%3.2%2.5%
159Other miscellaneous products-0.3%4.7%5.3%6.9%6.2%4.3%3.1%

BLS CPI Historical Annual Inflation Rate Averages Through November 2024 Table for Selected Categories

BLS CPI CodeBLS CPI Category Description1M 11/241Y 11/243Y 11/245Y 11/2410Y 11/2420Y 11/24
SAFFOOD & BEVERAGES0.1%2.3%2.3%5.1%5.0%3.0%
SAF11Food at home-0.1%1.6%1.6%5.0%5.0%2.5%
SAF114Nonalcoholic beverages & beverage materials0.5%2.7%2.8%6.2%5.4%2.8%
SEFNJuices & nonalcoholic drinks0.4%2.6%3.1%6.5%5.8%3.3%
SEFN01Carbonated drinks-0.2%2.6%3.1%6.4%6.3%3.8%
SEFN03Nonfrozen noncarbonated juices & drinks0.9%2.3%2.9%6.4%5.4%2.9%
SEFPBeverage materials including coffee & tea0.6%3.0%2.2%5.5%4.3%1.8%
SEFP01Coffee1.0%3.4%1.9%5.3%4.4%1.6%
SEFP02Other beverage materials including tea0.1%2.4%2.6%6.0%4.2%2.2%
SAF115Other food at home-0.4%0.7%0.7%5.8%5.2%2.8%
SEFT06Other miscellaneous foods-0.1%0.3%-0.1%5.7%5.0%2.6%
SEFWAlcoholic beverages at home-0.4%1.2%1.1%2.3%2.2%1.4%
SEFW01Beer, ale & other malt beverages at home-0.2%2.5%2.6%4.3%3.6%2.5%
SEFW02Distilled spirits at home-0.1%0.5%0.1%1.0%1.8%0.8%
SEFW03Wine at home-0.8%0.3%0.2%1.2%1.2%0.7%
SEHEFUEL OIL & OTHER FUELS-0.2%-7.4%-10.7%0.7%4.8%1.2%
SAH3HOUSEHOLD FURNISHINGS & OPERATIONS0.0%0.8%0.4%3.0%3.6%1.9%
SAAAPPAREL-2.7%3.0%1.1%1.9%1.0%0.0%
SAM1MEDICAL CARE COMMODITIES-0.1%0.5%0.4%2.8%1.5%1.7%
SEMFMedicinal drugs-0.1%0.5%0.3%2.7%1.5%1.7%
SEMF01Prescription drugs-0.4%1.1%0.7%2.1%1.1%1.8%
SEMF02Nonprescription drugs0.6%-0.5%-0.4%4.2%2.3%1.2%
SEMGMedical equipment and supplies-0.4%-0.1%1.2%4.5%1.4%1.0%
SARRECREATION0.2%1.1%1.5%2.9%2.7%1.9%
SEEAEDUCATIONAL BOOKS & SUPPLIES6.3%9.0%10.6%3.5%2.2%1.8%
SEGATOBACCO & SMOKING PRODUCTS1.0%6.7%6.6%6.9%6.8%5.7%
SEGBPERSONAL CARE PRODUCTS-0.1%1.6%0.5%4.0%2.2%1.0%
SEGEMISCELLANEOUS PERSONAL GOODS-0.6%-2.0%-2.4%2.5%2.3%0.2%
SAGOTHER GOODS AND SERVICES0.3%3.6%3.4%5.3%4.4%3.3%
SEREOther recreational goods-1.2%-2.4%-3.1%-1.0%-1.1%-3.8%
SERGRecreational reading materials-4.9%-0.9%-1.3%0.9%1.5%1.7%

Get a Free LIFO Election Benefit Analysis
Top LIFO Candidates & 2021 LIFO Lookout Guide
Get a Free LIFO Election Benefit AnalysisSample LIFO Election Benefit Analysis ReportLIFO Election Benefit Analysis Documentation Request

LIFOPro's OfferingsTurnkey Outsourcing SolutionsCPA Firm Offerings

LIFO Election Benefit Analysis Questionnaire

Get a complimentary, no obligation LIFO Election Benefit Analysis & turnkey outsourcing solutions fee quote emailed to you within one week of submitting the request form below!

Click or drag files to this area to upload. You can upload up to 20 files.
For example, a company with a December year end sending us these reports in December of 2021 would send us their November 2021 & December 2020 item detail reports. Please upload reports that include the following fields 1. Item/part/product code or number 2. Item/part description 3. Current period quantity on hand/weight 4. Current period item/unit cost. 5. Any product hierarchy fields if they are available, such as: category/subcategory, class/subclass, type, group, line, division, cost/profit center, business segment/unit, etc. Including product hierarchies will provide for a more accurate estimate of the projected tax savings from LIFO & will also likely reduce the turnkey outsourcing solutions fee quote. You will receive a complimentary LIFO benefit analysis report & turnkey outsourcing solutions fee quote within one week of submitting this form. See a sample item detail report file & product hierarchies by downloading this file: https://lifopro.com/publicdownloads/LIFOPro_Sample_Item_Detail_Report.xlsx Alternatively, you can email your item detail reports to lifopro@lifopro.com after submitting this request form.
=