The PieceWiseSOS2e.xlsx Model

Purchasing with a Nonlinear Price Schedule

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 curve (piecewise linear).						
How much should we buy from each to minimize total cost?

Keywords:

Piecewise Linear | Interpolation | Non-convex Function | Linearization | SOS2 | Purchasing | Quantity Discount | Excel | WhatsBest | What'sBest | What'sBest! | What's Best | Nonlinear | Special ordered set |