Optimization: Supplier Selection (optima_supplier_selection)

Minimize procurement cost with supplier capacities, optional budget, and risk/quality controls. Use this for sourcing decisions, vendor mix planning, and cost-risk-quality trade-off problems.

Click here to Learn more about: Optimization: Supplier Selection

Material Demand:

Item	Demand
I1	100
I2	80
I3	60

Row:Col:

Supplier Master:

Supplier	Capacity	Fixed Cost	Risk	Quality
S1	180	500	4	82
S2	160	650	7	75
S3	140	450	3	88

Row:Col:

Supplier Item Cost:

Supplier	Item	Unit Cost	Max Qty
S1	I1	11	100
S1	I2	13	80
S1	I3	12	60
S2	I1	10	100
S2	I2	14	80
S2	I3	13	60
S3	I1	12	100
S3	I2	12	80
S3	I3	11	60

Row:Col:

Max Suppliers:

Material Qty Type:

Budget Limit:

Min Avg Quality:

Max Avg Risk:

Show Zero:

Result:

Calculator: optima_supplier_selection, Created by: qcalc, V#0: , Variant owner: , Link, Core

Supplier	Item	Unit Cost	Max Qty
S1	I1	11	100
S1	I2	13	80
S1	I3	12	60
S2	I1	10	100
S2	I2	14	80
S2	I3	13	60
S3	I1	12	100
S3	I2	12	80
S3	I3	11	60

Supplier	Item	Unit Cost	Max Qty
S1	I1	11	100
S1	I2	13	80
S1	I3	12	60
S2	I1	10	100
S2	I2	14	80
S2	I3	13	60
S3	I1	12	100
S3	I2	12	80
S3	I3	11	60

Supplier	Item	Unit Cost	Max Qty
S1	I1	11	100
S1	I2	13	80
S1	I3	12	60
S2	I1	10	100
S2	I2	14	80
S2	I3	13	60
S3	I1	12	100
S3	I2	12	80
S3	I3	11	60