Cost Attributes

Fixed Cost

Sheets on which it appears

Location Period, Supplier, Supplier Product, Production, Warehouse, Warehouse Product

Possible inputs

Any number equal or greater than 0

How it affects the model

Fixed Cost is independent of the inbound or outbound volume. Fixed Cost remains the same no matter how much the volume is.

Variable Cost

Sheets on which it appears

Supplier, Supplier Product, Production, Warehouse, Warehouse Product, Inventory, Inventory Product, Customer Product Data

Possible inputs

Any number equal or greater than 0

How it affects the model

Variable Cost depends on the volume of Supplier/Warehouse/Production. For example if the variable cost of a supplier is 10 and volume is 200, the total variable cost for the supplier will be 200*10=2000. There are 2 models for variable cost: Incremental and All Steps (see below). In the incremental model each capacity steps has its own variable cost:

Step	Minimum Capacity	Maximum Capacity	Variable Cost
1	0	100	10
2	100	500	20
3	500	1000	30

If the actual flow is 1000 the total variable cost with the Incremental model: 100*10+(500-100)*20+(1000-500)*30=100*10+400*20+500*30=1000+8000+15000=24000.

Variable Cost for all steps

Sheets on which it appears

Supplier, Supplier Product, Production, Warehouse, Warehouse Product, Stepwise Transport Cost

Possible inputs

Binary (0 or 1), it should be 1 for all steps if you want to use this model.

How it affects the model

Variable Cost depends on the volume of Supplier/Warehouse/Production. There are 2 models for variable cost: Incremental (see above) and All Steps. This attribute indicates if the variable cost of the last step in use is applied for all units in all steps. It should be 1 for all steps (except the first) if you want to use the All Steps model. In the “All Steps” costing model all capacity step has a common variable cost, that is the cost of the last used step. On the Stepwise Transport Cost sheet the attribute works with the same logic for Cost Per UOM.

Step	Minimum Capacity	Maximum Capacity	Variable Cost	Variable Cost for all steps
1	0	100	10	1
2	100	500	20	1
3	500	1000	30	1

If the actual flow is 1000 the total variable cost with the All Steps model: 1000*30=30000.

Closing Cost

Sheets on which it appears

Supplier, Supplier Product, Production, Production Routing, Warehouse, Warehouse Product

Possible inputs

Any number equal or greater than 0

How it affects the model

The cost of closing the Supplier / Supplier Product / Production / Production Routing / Warehouse / Warehouse Product. If the Supplier/Warehouse/Production has closing cost in the given period the closing cost is considered active, then the closing cost will be added to the total cost of the Supplier/Warehouse/Production. The closing cost is active if the Supplier/Warehouse/Production was opened in the previous period but in the given period is closed. Additionally, within a Supplier/Warehouse, every product also has its own closing cost. If a product was active in the previous period but becomes inactive in the current period at a given location, the closing cost of the product is added to the total cost of the Supplier Product / Warehouse Product. Similarly, in Production Routing, each BOM can have its own closing cost. If a BOM was active at a given location in the previous period but becomes inactive in the current period, the BOM’s closing cost is added to the total cost of the Production Routing. For example if the supplier has closing cost (10) in period 2 and in “period 1” the supplier was opened but in “period 2” the supplier is closed, then the closing cost for the supplier will be 10.

Opening Cost

Sheets on which it appears

Supplier, Supplier Product, Production, Production Routing, Warehouse, Warehouse Product

Possible inputs

Any number equal or greater than 0

How it affects the model

The cost of opening the Supplier / Supplier Product / Production / Production Routing / Warehouse / Warehouse Product. If the Supplier/Warehouse/Production has opening cost in the given period and the opening cost is considered active, then the opening cost will be added to the total cost of the Supplier/Warehouse/Production. The opening cost is active if the Supplier/Warehouse/Production was closed in the previous period but in the given period is opened. Additionally, within a Supplier/Warehouse, every product also has its own opening cost. If a product was inactive in the previous period but becomes active in the current period at a given location, the opening cost of the product is added to the total cost of the Supplier Product / Warehouse Product. Similarly, in Production Routing, each BOM can have its own opening cost. If a BOM was inactive at a given location in the previous period but becomes active in the current period, the BOM’s opening cost is added to the total cost of the Production Routing. For example, if the supplier has opening cost (10) in period 2 and in “period 1” the supplier was closed but in “period 2” the supplier is opened, then the opening cost for the supplier will be 10.