Share
Report
15We have a vendor that gives us discounts based on the total number of items ordered, but the discount is different for each item. Item A may be a 2% discount where item B may be a 10% discount.
When the items were originally setup they were built with what purchasing thought would be the most common price (the price associated with 3-5 case orders (all items are ordered as a case)). For example, I can order 1 of Item A, 1 of Item B, and 1 of Item C and get the 3-5 cases pricing. This has proven to not be a good method as it causes our AP to approve a lot of variances when we get the invoice for the purchased items.
I am looking for a way to build out pricing tiers that would look at the total qty ordered and then apply the right price. Is it only possible to do this as a % or can we designate the specific price for an item within the qty discount bracket?
For Example
| < 3-Case Cost | 3-5 Case Cost | % Discount | > 5 Case Cost | % Discount | |
| Item A | 96.72 | 94.44 | 2.36% | 94.44 | 2.36% |
| Item B | 46.08 | 46.08 | 0.00% | 41.88 | 9.11% |
| Item C | 142.68 | 142.68 | 0.00% | 109.08 | 23.55% |
| Item D | 159.48 | 142.68 | 10.53% | 109.08 | 31.60% |
| Item E | 41.28 | 40.38 | 2.18% | 39.18 | 5.09% |
| Item F | 83.88 | 75.48 | 10.01% | 71.28 | 15.02% |
Thanks!
All responses (
Answers (
