The QdiscSup.xlsx Model

Buying with quantity discounts

View the model
Download the model

We need to buy a specified number of units of a commodity.
Two vendors each offer their own price discount schedule.
How much should we buy from each to minimize total cost?
Vendor A gives discounts on all units. Vendor B gives discounts only on incremental units.

Keywords:

Non-convex Function | Linearization | Purchasing | Quantity Discount | Discount | Vendor selection |