A spreadsheet that allows you to plug in any combination of price changes as well as changes in your discount rate and/or the length of time to pay.
This is a tool that Bill Swarens, VP, Credit at Leggett & Platt uses to analyze different scenarios when considering:
- price reductions
- changes in the cash discount offered
- changes in the time offered for a cash discount, and
- the cost of money
You can change any of the above variables to see what is best for your company - it’s structured so you can plug in any scenario you want.
In addition, the spreadsheet is easy to modify to suit your own needs.
Tip: This is something you can pass on to your company's purchasing agent or buyer, as it's equally valuable for their calculations in negotiating and paying your suppliers.
|