Examples
Examples
Try the starting example
- Units actually needed
- 190
- Minimum order quantity
- 1
- All-units price tiers: quantity threshold, unit price $
- 1,10 200,8
- Holding cost per excess unit over chosen horizon ($)
- 1
- Maximum order quantity to consider
- 500
- Candidate order quantity: total cost ($)
- 190: 1900.00; 200: 1610.00
- Minimum-cost candidate order units
- 200
- Excess units above stated need
- 10
- Merchandise cash for chosen order ($)
- $1,600.00
- Merchandise plus entered holding cost ($)
- $1,610.00
Try another scenario
- Units actually needed
- 190
- Minimum order quantity
- 1
- All-units price tiers: quantity threshold, unit price $
- 1,10 200,8
- Holding cost per excess unit over chosen horizon ($)
- 50
- Maximum order quantity to consider
- 500
- Candidate order quantity: total cost ($)
- 190: 1900.00; 200: 2100.00
- Minimum-cost candidate order units
- 190
- Excess units above stated need
- 0
- Merchandise cash for chosen order ($)
- $1,900.00
- Merchandise plus entered holding cost ($)
- $1,900.00
Calculation method
Calculation method
Candidate order quantity: total cost ($)
Evaluate max(need,MOQ) and every higher price-break threshold within the maximum; total=all units×applicable tier price+excess units×holding cost.
Minimum-cost candidate order units
Choose minimum total, tie by smaller quantity. With nonnegative unit/holding costs, each tier segment’s minimum lies at its lower feasible endpoint.
Excess units above stated need
Chosen quantity−need.
Merchandise cash for chosen order ($)
Chosen quantity×its all-units tier price.
Merchandise plus entered holding cost ($)
Merchandise+holding on excess units; the holding horizon is implicit in the supplied per-unit amount.
Symbols and units
- a
- Units actually needed
- b
- Minimum order quantity
- c
- All-units price tiers: quantity threshold, unit price $
- d
- Holding cost per excess unit over chosen horizon ($)
- e
- Maximum order quantity to consider
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- An exact bounded all-units price-break cost comparison, not marginal-tier pricing or a demand forecast. Storage, obsolescence and financing effects must already be represented in the entered holding amount.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Background reading; this does not imply endorsement or independent review of SumFizz.