Navigation

Secondary sidebar

Saved Input… : Click to select

Temp
Search Unit:
Search results appear here
Add Calculator:

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

Objective:

Qty Type:

Backlog Policy:

Max Backlog PCT:

Service Level Floor PCT:

Stability Enabled:

Scenarios Enabled:

Show Zero:

Overtime Enabled:

Bom Enabled:

Procurement Enabled:

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:

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:

Sop Overtime:

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

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	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:

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:

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:

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