Planning: S&OP Optimization (optima_sop)

Optimize a multi-period production and inventory plan from demand, product economics, and capacity data. The model can minimize cost, maximize service level, or minimize inventory. Optional overtime and procurement companion modules can be enabled for modular planning workflows.

Click here to Learn more about: Planning: S&OP Optimization

Sop Product Master:

Product	Opening Inventory	Safety Stock	Production Cost	Holding Cost	Max Production	Backlog Penalty	Setup Cost
A	20	5	7.0	1.4	65	12	20
B	10	4	6.5	1.0	55	10	15
C	15	6	7.5	1.2	60	14	18

Row:Col:

Sop Demand:

Period	Product	Demand
1	A	50
1	B	45
2	A	55
2	B	40
3	A	60
3	B	50

Row:Col:

Sop Capacity:

Period	Capacity
1	120
2	115
3	125

Row:Col:

Objective:

Qty Type:

Backlog Policy:

Max Backlog PCT:

Service Level Floor PCT:

Stability Enabled:

Stability Penalty:

Max Change PCT:

Sop Previous Plan:

Period	Product	Previous Production
1	A	48
1	B	44
1	C	40
2	A	52
2	B	41
2	C	43
3	A	58
3	B	49
3	C	47

Row:Col:

Enable Scenarios:

Scenarios Enabled:

Sop Scenarios:

Scenario	Demand Multiplier	Capacity Multiplier	Production Cost Multiplier	Holding Cost Multiplier	Backlog Penalty Multiplier
Base	1.0	1.0	1.0	1.0	1.0
Demand +10%	1.1	1.0	1.0	1.0	1.0
Demand -10%	0.9	1.0	1.0	1.0	1.0
Capacity -10%	1.0	0.9	1.0	1.0	1.0

Row:Col:

Show Zero:

Overtime Enabled:

Sop Overtime:

Period	Overtime Capacity	Overtime Cost
1	0	0
2	0	0
3	0	0

Row:Col:

Bom Enabled:

Sop Material Requirements:

Product	Material	Qty per Unit
A	RM1	1.2
A	RM2	0.4
B	RM1	1.0
B	RM3	0.8
C	RM2	0.6
C	RM3	1.1

Row:Col:

Procurement Enabled:

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	RM1	11	100
S1	RM2	13	80
S1	RM3	12	60
S2	RM1	10	100
S2	RM2	14	80
S2	RM3	13	60
S3	RM1	12	100
S3	RM2	12	80
S3	RM3	11	60

Row:Col:

Procurement Max Suppliers:

Procurement Material Qty Type:

Procurement Budget Limit:

Procurement Min Avg Quality:

Procurement Max Avg Risk:

Result:

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

Supplier	Item	Unit Cost	Max Qty
S1	RM1	11	100
S1	RM2	13	80
S1	RM3	12	60
S2	RM1	10	100
S2	RM2	14	80
S2	RM3	13	60
S3	RM1	12	100
S3	RM2	12	80
S3	RM3	11	60

Supplier	Item	Unit Cost	Max Qty
S1	RM1	11	100
S1	RM2	13	80
S1	RM3	12	60
S2	RM1	10	100
S2	RM2	14	80
S2	RM3	13	60
S3	RM1	12	100
S3	RM2	12	80
S3	RM3	11	60

Supplier	Item	Unit Cost	Max Qty
S1	RM1	11	100
S1	RM2	13	80
S1	RM3	12	60
S2	RM1	10	100
S2	RM2	14	80
S2	RM3	13	60
S3	RM1	12	100
S3	RM2	12	80
S3	RM3	11	60