Tricky Cost Savings Calculations
PurchTips edition #301
By Charles Dominick, SPSM, SPSM2, SPSM3
Are Your Cost Savings Calculations Defensible?
If you repeatedly purchased an item, the price of that item went down on January 1 of every year, and you bought the same quantity every year, calculating your cost savings for that item would be easy. But for items for which pricing changes less predictably and quantities vary from year to year, calculating cost savings can be trickier. In this edition of PurchTips, I will share formulas for calculating cost savings for items whose prices and purchased quantities are more volatile.
The first thing you have to do when calculating cost savings for an item that fits into this category is to calculate Last Year's Average Price for each item, which is done with Calculation A. In all calculations, "year" refers to the fiscal year.
Calculation A: Last Year's Average Price = Total Spent Last Year / Number of Units Purchased Last Year
Then, you should calculate This Year's Average Price for the item using Calculation B.
Calculation B: This Year's Average Price = Total Spent This Year / Number of Units Purchased This Year
You can now calculate This Year's Cost Savings for the item using Calculation C.
Calculation C: This Year's Cost Savings = (Last Year's Average Price - This Year's Average Price) × Number of Units Purchased This Year
Some procurement professionals like to keep a running tally of cost savings with each purchase order. To do that for a particular item, you can use Calculation D.
Calculation D: This Order's Cost Savings = (Last Year's Average Price - Price Paid on This Order) × Quantity Purchased
Then, add up the cost savings for each order to arrive at a total for the year. One caveat of using the order-by-order approach: You must include in your tally all orders even those where you paid more than last year's average price - for your total to match the total from Calculation C. Otherwise, it will not match and your savings claims can be legitimately disputed.
Do You Want a More Rewarding Procurement Career?
Are you tired of not getting enough opportunities, respect, and money out of your procurement career? Well, guess what? Nothing will change unless you take action towards becoming a world-class procurement professional.
Earning your SPSM® Certification is the action to take if you want to bring the most modern procurement practices into your organization and achieve your career potential. Download the SPSM® Certification Guide today to learn how to get started on your journey to a more rewarding procurement career!
Need Better Performance From Your Procurement Team?
Are you a procurement leader whose team isn't achieving the results you know are possible? Maybe it's not enough cost savings. Or frustrating performance from the supply base. Or dissatisfied internal customers.
You need a performance improvement plan that's easy to implement and quick to produce results. The NLPA can help.
Download our whitepaper "The Procurement Leader's Guide To A More Successful Team." You'll learn the 7 steps for transforming your staff into a results-producing, world-class procurement team.
Are You Getting The Most Out of Your NLPA Membership?
Members of the NLPA get more than just articles like this by email. As a member, you also get access to:
- The Procurement Training & Certification Starter Kit
- The latest Purchasing & Supply Management Salaries Report
- Leading-Edge Supply Management™ magazine
- Members-only webinars 10x per year
- And more!
If you haven't been taking advantage of these benefits, why not log in and start now?
Copyright 2014. This article is the property of Next Level Purchasing and may not be copied or republished in any form without the express written consent of Next Level Purchasing.
Click here to request republishing permission.