Use the Polarbear-GBI Answer sheet to submit your answers. The two Excel file provide are called for as you go through the exercise.

PBNOLevel2Solution.xlsx

Home >Computer Science homework help >Use the Polarbear-GBI Answer sheet to submit your answers. The two Excel file provide are called for as you go through the exercise.

Scenario settings

description	Copy of scenario GFA Outbound 16.11.17. Type changed to NO Description of the original scenario:
type	NO
name	PB NO Level 2 Solution
creationDate	2017-11-16

Assets Constraints

Group

Min

Max

Time Period

Inclusion Type

BOM

Name

End Product

Quantity

Co-products

Components

CO2 from Facilities

Facility

CO2 Emissions

CO2 Produced

Time Unit

Product Unit

Time Period

CO2 from Processing

Facility

Product

Processing Type

Units

CO2 Produced

Time Period

Custom Constraints

Name

Left hand side

Type

Right hand side

Inclusion type

Customers

Name	Type	Location	Inclusion Type	Icon
Cologne	Customer	Cologne location	Include	4
Bremen	Customer	Bremen location	Include	4
Stuttgart	Customer	Stuttgart location	Include	4
Frankfurt am Main	Customer	Frankfurt am Main location	Include	4

DCs and Factories

Name	Type	Location	Initially Open	Inclusion Type	Icon
Nuremberg	Factory	Nuremberg location	TRUE	Consider	3
Steimelhagen	DC	Steimelhagen location	TRUE	Consider	2
Poland	Factory	Poland location	FALSE	Consider	3
Czech Rep.	DC	Czech Rep. location	FALSE	Consider	2

Demand

Customer	Product	Demand Type	Time Period	Revenue	Down Penalty	Up Penalty	Currency
Cologne	bicycle "all terrain"	PeriodicDemand[period::1.0;quantity::15.0]	(All periods)	499	5000	5000	USD
Cologne	bicycle "tour"	PeriodicDemand[period::1.0;quantity::10.0]	(All periods)	499	5000	5000	USD
Cologne	bicycle "urban"	PeriodicDemand[period::1.0;quantity::50.0]	(All periods)	499	5000	5000	USD
Cologne	bicycle "x-cross"	PeriodicDemand[period::1.0;quantity::2.0]	(All periods)	499	5000	5000	USD
Bremen	bicycle "all terrain"	PeriodicDemand[period::1.0;quantity::20.0]	(All periods)	499	5000	5000	USD
Bremen	bicycle "tour"	PeriodicDemand[period::1.0;quantity::20.0]	(All periods)	499	5000	5000	USD
Bremen	bicycle "urban"	PeriodicDemand[period::1.0;quantity::30.0]	(All periods)	499	5000	5000	USD
Bremen	bicycle "x-cross"	PeriodicDemand[period::1.0;quantity::7.0]	(All periods)	499	5000	5000	USD
Frankfurt am Main	bicycle "all terrain"	PeriodicDemand[period::1.0;quantity::4.0]	(All periods)	499	5000	5000	USD
Frankfurt am Main	bicycle "tour"	PeriodicDemand[period::1.0;quantity::5.0]	(All periods)	499	5000	5000	USD
Frankfurt am Main	bicycle "urban"	PeriodicDemand[period::1.0;quantity::5.0]	(All periods)	499	5000	5000	USD
Frankfurt am Main	bicycle "x-cross"	PeriodicDemand[period::1.0;quantity::6.0]	(All periods)	499	5000	5000	USD
Stuttgart	bicycle "all terrain"	PeriodicDemand[period::1.0;quantity::1.0]	(All periods)	499	5000	5000	USD
Stuttgart	bicycle "tour"	PeriodicDemand[period::1.0;quantity::40.0]	(All periods)	499	5000	5000	USD
Stuttgart	bicycle "urban"	PeriodicDemand[period::1.0;quantity::15.0]	(All periods)	499	5000	5000	USD
Stuttgart	bicycle "x-cross"	PeriodicDemand[period::1.0;quantity::15.0]	(All periods)	499	5000	5000	USD

Historic Demand

date

quantity

Facility Expenses

Facility	Expense Type	Value	Currency	Time Unit	Product Unit	Time Period
Steimelhagen	carryingCost	3	USD	day	pcs	(All periods)
Steimelhagen	otherCost	15000	USD	day	m³	(All periods)
Nuremberg	otherCost	15000	USD	day	m³	(All periods)
Czech Rep.	otherCost	5000	USD	day	m³	(All periods)
Czech Rep.	carryingCost	2	USD	day	pcs	(All periods)
Poland	otherCost	5000	USD	day	m³	(All periods)

Groups

Name	Description	Customers	Sites	Suppliers	Groups
Customers 1		List 1
DCs			List 2
Factories			List 3

Groups List Contents

List 1	List 2	List 3
Cologne	Steimelhagen	Nuremberg
Bremen	Czech Rep.	Poland
Stuttgart
Frankfurt am Main

Indicator Constraints

Then

Inclusion Type

Linear Ranges

Name

Lower Bound

Expression

Upper Bound

Location Groups

Name

Locations

Code	Name	City	Region	Country	Address	Latitude	Longitude	Autofill Coordinates
	Nuremberg location					49.4538425943	11.1401367188	FALSE
	Cologne location					50.833697671	6.85546875	FALSE
	Bremen location					53.0544218655	8.8549804688	FALSE
	Stuttgart location					48.7779127555	9.2944335938	FALSE
	Frankfurt am Main location					50.0782945474	8.6352539063	FALSE
	Steimelhagen location					50.8386845756	7.6294898987	FALSE
	Poland location					52.3219108859	18.984375	FALSE
	Czech Rep. location					49.7670740737	15.4028320313	FALSE

Objective Members

Name	Expression	Add to Objective	Inclusion Type
Revenue	1.0*Total Revenue	TRUE	Include
Total Fixed Costs	-1.0*Total Fixed Cost	TRUE	Include
Total Inbound Costs	-1.0*Total Inbound Cost	TRUE	Include
Total Outbound Costs	-1.0*Total Outbound Cost	TRUE	Include
Total Penalty	-1.0*Total Penalties	TRUE	Include
Total Production Costs	-1.0*Total Production Cost	TRUE	Include
Total Storage Costs	-1.0*Total Storage Cost	TRUE	Include
Total Supply Costs	-1.0*Total Supply Cost	TRUE	Include
Total Transportation Costs	-1.0*Total Transportation Cost	TRUE	Include

Path Selection Mode

From

Selection Mode

Paths

From

Cost Calculation

Currency

Distance

Distance Unit

Transportation Time

Time unit

Straight

Vehicle Type

Transportation Policy

Min Load, ratio

Time Period

Inclusion Type

Factories

DCs

TransportationCostCalculatorVolumeDistance[unit::pcs;costPerUnit::0.01;co2PerUnit::0.0]

USD

0.0

day

FALSE

Truck 1

LTL

(All periods)

Include

DCs

Customers 1

TransportationCostCalculatorVolumeDistance[unit::pcs;costPerUnit::0.01;co2PerUnit::0.0]

USD

0.0

day

FALSE

Truck 1

LTL

(All periods)

Include

Period Groups

Name

Periods

Name	Start	End	Demand Coefficient
Basic period	2017-01-01	2017-12-31	1

Processing Cost

Source	Product	Type	Units	Cost	Currency	Time Period
Steimelhagen	(All products)	OutShipmProc	pcs	2	USD	(All periods)
Steimelhagen	(All products)	InShipmProc	pcs	2	USD	(All periods)
Czech Rep.	(All products)	OutShipmProc	pcs	1	USD	(All periods)
Czech Rep.	(All products)	InShipmProc	pcs	1	USD	(All periods)

Processing Time

Facility

Product

Type

Units

Time

Time Unit

Units

Name

Unit Conversions

Product

Amount from

Amount to

Unit to

Production

Label	Site	Product	BOM	Production Cost	Currency	Min Throughput	Max Throughput	Fixed	Fixed Value	Down Penalty	Up Penalty	CO2 per product	Time Period	Inclusion Type
	Nuremberg	bicycle "all terrain"		250	USD	0	0	FALSE	0	0	0	0	(All periods)	Include
	Nuremberg	bicycle "tour"		250	USD	0	0	FALSE	0	0	0	0	(All periods)	Include
	Nuremberg	bicycle "urban"		250	USD	0	0	FALSE	0	0	0	0	(All periods)	Include
	Nuremberg	bicycle "x-cross"		250	USD	0	0	FALSE	0	0	0	0	(All periods)	Include
	Poland	bicycle "all terrain"		150	USD	0	0	FALSE	0	0	0	0	(All periods)	Include
	Poland	bicycle "tour"		150	USD	0	0	FALSE	0	0	0	0	(All periods)	Include
	Poland	bicycle "urban"		150	USD	0	0	FALSE	0	0	0	0	(All periods)	Include
	Poland	bicycle "x-cross"		150	USD	0	0	FALSE	0	0	0	0	(All periods)	Include

Product Storages

Label

Facility

Expand Facilities

Product

Expand Products

Initial Stock, units

Min Stock

Safety Stock

Max Stock

Fixed

Fixed Value

Stock Down Penalty

Stock Safety Penalty

Stock Up Penalty

Currency

Product Unit

Time Period

Inclusion Type

Czech Rep.

TRUE

(All products)

TRUE

FALSE

USD

pcs

(All periods)

Include

Poland

TRUE

(All products)

TRUE

FALSE

USD

pcs

(All periods)

Include

Steimelhagen

TRUE

(All products)

TRUE

FALSE

USD

pcs

(All periods)

Include

Nuremberg

TRUE

(All products)

TRUE

FALSE

USD

pcs

(All periods)

Include

Product Flows

Label

Source

Expand Sources

Destination

Expand Destinations

Vehicle Types

Product

Expand Products

Min Throughput

Max Throughput

Fixed

Fixed Value

Product Unit

Down Penalty

Up Penalty

Currency

Distance Limit

Distance Unit

Time Limit

Time Unit

Time Period

Inclusion Type

Factories

TRUE

DCs

TRUE

Truck 1

(All products)

TRUE

FALSE

pcs

USD

day

(All periods)

Include

DCs

TRUE

Customers 1

TRUE

Truck 1

(All products)

TRUE

FALSE

pcs

USD

day

(All periods)

Include

Product Flows List Contents

Product Groups

Name

Products

Name	Unit	Selling Price	Cost	Currency
bicycle "all terrain"	pcs	499	30	USD
bicycle "tour"	pcs	499	30	USD
bicycle "urban"	pcs	499	30	USD
bicycle "x-cross"	pcs	499	30	USD

Sale Batch

Source

Product

Price (per unit)

Currency

Site States Changes

Site

Time Period

New Site State

Suppliers

Name

Type

Location

Inclusion Type

Icon

Vehicle Types

Name	Capacity	Capacity Unit	Speed	Speed Unit
Truck 1	80	pcs	80.0	km/h

ALXSettings

Property	Value
Export version	2.9.0

Project units

Currency	USD
Volume	m³
Distance	km
Time	day

Project units conversions

Field names settings

Assets Constraints	Group	sites
Assets Constraints	Min	minSites
Assets Constraints	Max	maxSites
Assets Constraints	Time Period	timePeriod
Assets Constraints	Inclusion Type	inclusionType
BOM	Name	name
BOM	End Product	endProduct
BOM	Quantity	quantity
BOM	Co-products	subProducts
BOM	Components	components
CO2 from Facilities	Facility	facility
CO2 from Facilities	CO2 Emissions	expenseType
CO2 from Facilities	CO2 Produced	value
CO2 from Facilities	Time Unit	timeUnit
CO2 from Facilities	Product Unit	productUnit
CO2 from Facilities	Time Period	timePeriod
CO2 from Processing	Facility	facility
CO2 from Processing	Product	product
CO2 from Processing	Processing Type	type
CO2 from Processing	Units	unit
CO2 from Processing	CO2 Produced	value
CO2 from Processing	Time Period	timePeriod
Custom Constraints	Name	assignedName
Custom Constraints	Left hand side	lhs
Custom Constraints	Type	constraintType
Custom Constraints	Right hand side	rhs
Custom Constraints	Inclusion type	inclusionType
Customers	Name	name
Customers	Type	customType
Customers	Location	location
Customers	Inclusion Type	inclusionType
Customers	Icon	icon
DCs and Factories	Name	name
DCs and Factories	Type	customType
DCs and Factories	Location	location
DCs and Factories	Initially Open	initiallyOpened
DCs and Factories	Inclusion Type	inclusionType
DCs and Factories	Icon	icon
Demand	Customer	customerData
Demand	Product	product
Demand	Demand Type	customType
Demand	Time Period	timePeriod
Demand	Revenue	revenue
Demand	Down Penalty	downPenalty
Demand	Up Penalty	upPenalty
Demand	Currency	costUnit
Facility Expenses	Facility	facility
Facility Expenses	Expense Type	expenseType
Facility Expenses	Value	value
Facility Expenses	Currency	costUnit
Facility Expenses	Time Unit	timeUnit
Facility Expenses	Product Unit	productUnit
Facility Expenses	Time Period	timePeriod
Groups	Name	name
Groups	Description	description
Groups	Customers	customers
Groups	Sites	sites
Groups	Suppliers	suppliers
Groups	Groups	groups
Indicator Constraints	If	ifRange
Indicator Constraints	Then	thenRange
Indicator Constraints	Inclusion Type	inclusionType
Linear Ranges	Name	name
Linear Ranges	Lower Bound	lb
Linear Ranges	Expression	expression
Linear Ranges	Upper Bound	ub
Location Groups	Name	name
Location Groups	Locations	list
Locations	Code	code
Locations	Name	name
Locations	City	cityName
Locations	Region	region
Locations	Country	country
Locations	Address	address
Locations	Latitude	latitude
Locations	Longitude	longitude
Locations	Autofill Coordinates	autoFindCoordinates
Objective Members	Name	name
Objective Members	Expression	expression
Objective Members	Add to Objective	addToObjective
Objective Members	Inclusion Type	inclusionType
Path Selection Mode	From	from
Path Selection Mode	To	to
Path Selection Mode	Selection Mode	selectionMode
Paths	From	from
Paths	To	to
Paths	Cost Calculation	customType
Paths	Currency	costUnit
Paths	Distance	distance
Paths	Distance Unit	distanceUnit
Paths	Transportation Time	transportationTimeGenerator
Paths	Time unit	timeUnit
Paths	Straight	straight
Paths	Vehicle Type	vehicleType
Paths	Transportation Policy	transportationPolicy
Paths	Min Load, ratio	minLoad
Paths	Time Period	timePeriod
Paths	Inclusion Type	inclusionType
Period Groups	Name	name
Period Groups	Periods	list
Periods	Name	name
Periods	Start	startDate
Periods	End	endDate
Periods	Demand Coefficient	demandCoefficient
Processing Cost	Source	facility
Processing Cost	Product	product
Processing Cost	Type	type
Processing Cost	Units	unit
Processing Cost	Cost	value
Processing Cost	Currency	valueUnit
Processing Cost	Time Period	timePeriod
Processing Time	Facility	facility
Processing Time	Product	product
Processing Time	Type	type
Processing Time	Units	unit
Processing Time	Time	valueGenerator
Processing Time	Time Unit	valueUnit
Units	Name	name
Unit Conversions	Product	product
Unit Conversions	Amount from	coefficientFrom
Unit Conversions	Amount to	coefficientTo
Unit Conversions	Unit to	unitTo
Production	Label	assignedName
Production	Site	site
Production	Product	product
Production	BOM	bom
Production	Production Cost	cost
Production	Currency	costUnit
Production	Min Throughput	minProduction
Production	Max Throughput	maxProduction
Production	Fixed	fixed
Production	Fixed Value	fixedValue
Production	Down Penalty	downPenalty
Production	Up Penalty	upPenalty
Production	CO2 per product	co2Emissions
Production	Time Period	timePeriod
Production	Inclusion Type	inclusionType
Product Storages	Label	assignedName
Product Storages	Facility	site
Product Storages	Expand Facilities	expandSites
Product Storages	Product	products
Product Storages	Expand Products	expandProducts
Product Storages	Initial Stock, units	initialStock
Product Storages	Min Stock	minStock
Product Storages	Safety Stock	safetyStock
Product Storages	Max Stock	maxStock
Product Storages	Fixed	fixed
Product Storages	Fixed Value	fixedValue
Product Storages	Stock Down Penalty	stockDownPenalty
Product Storages	Stock Safety Penalty	safetyPenalty
Product Storages	Stock Up Penalty	stockUpPenalty
Product Storages	Currency	costUnit
Product Storages	Product Unit	productUnit
Product Storages	Time Period	timePeriod
Product Storages	Inclusion Type	inclusionType
Product Flows	Label	assignedName
Product Flows	Source	source
Product Flows	Expand Sources	expandSources
Product Flows	Destination	destination
Product Flows	Expand Destinations	expandDestinations
Product Flows	Vehicle Types	vehicleTypes
Product Flows	Product	products
Product Flows	Expand Products	expandProducts
Product Flows	Min Throughput	minThroughput
Product Flows	Max Throughput	maxThroughput
Product Flows	Fixed	fixed
Product Flows	Fixed Value	fixedValue
Product Flows	Product Unit	productUnit
Product Flows	Down Penalty	downPenalty
Product Flows	Up Penalty	upPenalty
Product Flows	Currency	costUnit
Product Flows	Distance Limit	distanceLimit
Product Flows	Distance Unit	distanceUnit
Product Flows	Time Limit	timeLimit
Product Flows	Time Unit	timeUnit
Product Flows	Time Period	timePeriod
Product Flows	Inclusion Type	inclusionType
Product Groups	Name	name
Product Groups	Products	list
Products	Name	name
Products	Unit	unit
Products	Selling Price	price
Products	Cost	mfgPrice
Products	Currency	costUnit
Sale Batch	Source	source
Sale Batch	Product	product
Sale Batch	Price (per unit)	pricePerUnit
Sale Batch	Currency	costUnit
Site States Changes	Site	facilityData
Site States Changes	Time Period	period
Site States Changes	New Site State	open
Suppliers	Name	name
Suppliers	Type	customType
Suppliers	Location	location
Suppliers	Inclusion Type	inclusionType
Suppliers	Icon	icon
Vehicle Types	Name	name
Vehicle Types	Capacity	capacity
Vehicle Types	Capacity Unit	capacityUnit
Vehicle Types	Speed	speedGenerator
Vehicle Types	Speed Unit	speedUnit

Table names settings

Assets Constraints	AssetsConstraint_TableName
BOM	BOM_TableName
CO2 from Facilities	Facility_CO2
CO2 from Processing	ProcessingDataCO2_TableName
Custom Constraints	Custom Constraints
Customers	CustomerData_TableName
DCs and Factories	SiteDataNO_TableName
Demand	DemandDataNO_TableName
Facility Expenses	FacilityExpense_TableName
Groups	FacilityGroup_TableName
Indicator Constraints	Indicator Constraints
Linear Ranges	Linear Ranges
Location Groups	LocationList_TableName
Locations	Location_TableName
Objective Members	Objective Members
Path Selection Mode	PathSelectionMode_TableName
Paths	PathDataNO_TableName
Period Groups	TimePeriodGroup_TableName
Periods	TimePeriodGFA_NO_TableName
Processing Cost	ProcessingDataCost_TableName
Processing Time	ProcessingDataTime_TableName
Units	MeasurementUnit_TableName
Unit Conversions	MeasurementUnitsConversionRule_TableName
Production	LinearProductionConstraintTableName
Product Storages	LinearSiteConstraint_TableName
Product Flows	LinearFlowConstraint_TableName
Product Groups	ProductGroup_TableName
Products	ProductNO_TableName
Sale Batch	SaleBatchNO_TableName
Site States Changes	SiteChangeState_TableName
Suppliers	SupplierData_TableName
Vehicle Types	VehicleType_TableName

Experiment 1

searchType

Find N best

demandVariationType

95% - 100%

nBest

timeLimit

600

mipGap

0.000001

useBigM

Use Big M

ignoreNotRealRoutes

FALSE

parallelThreadsNumber

name

type

NetworkOptimization

scenario

PB NO Level 2 Solution

statisticsSettings

LINEAR_COSTS::true;d;f

Flows Details::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Sites Initial::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Sites Fix::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Storage by Product::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Production cost::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Production flows::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Multiple Flows Constraints::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Working Sites::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Multiple Storages Constraints::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Demand::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

VEHICLES_FLOWS::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Named Expressions::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Objective Members::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Overall Stats::true;d,Type,Object,Product,Vehicle type,Sale batch,BOM,Period,Destination,Zone,Staff type;f

Flows Amount::true;d;f

Units settings

Currency::USD

Pcs::pcs

Time::day

Distance::km

timeType

All periods

startPeriod

endPeriod

startDate

2017-01-01T00:00

stopDate

2017-12-31T00:00

dashboardData

Page name

Chart type

Accumulative

Stats names

Layout data

Detalization

Filters

Chart name

dashboardData

All

CUSTOM_TABLE

TRUE

Flows Details

0,0,12,8

Flows details

dashboardData

All

CUSTOM_TABLE

TRUE

Sites Initial

12,0,12,8

Sites initial

dashboardData

All

CUSTOM_TABLE

TRUE

Sites Fix

24,0,12,8

Sites fix

dashboardData

All

CUSTOM_TABLE

TRUE

Working Sites

0,8,12,8

Working sites

dashboardData

All

CUSTOM_TABLE

TRUE

Storage by Product

12,8,12,8

Storage by product

dashboardData

All

CUSTOM_TABLE

TRUE

Production cost

24,8,12,8

Production cost

dashboardData

All

CUSTOM_TABLE

TRUE

Production flows

0,16,12,8

Production flows

dashboardData

All

CUSTOM_TABLE

TRUE

Multiple Flows Constraints

12,16,12,8

Multiple flow constraints

dashboardData

All

CUSTOM_TABLE

TRUE

Multiple Storages Constraints

24,16,12,8

Multiple storage constraints

dashboardData

All

CUSTOM_TABLE

TRUE

Demand

0,24,12,8

Demand

dashboardData

All

CUSTOM_TABLE

TRUE

VEHICLES_FLOWS

12,24,12,8

Vehicle flows

dashboardData

All

CUSTOM_TABLE

TRUE

Named Expressions

24,24,12,8

Named expressions

dashboardData

All

CUSTOM_TABLE

TRUE

Objective Members

0,32,12,8

Objective Members

dashboardData

All

CUSTOM_TABLE

TRUE

Overall Stats

12,32,12,8

Overall stats

dashboardData

Flows details

CUSTOM_TABLE

TRUE

Flows Details

0,0,36,8

Flows details

dashboardData

Sites initial

CUSTOM_TABLE

TRUE

Sites Initial

0,0,36,8

Sites initial

dashboardData

Sites fix

CUSTOM_TABLE

TRUE

Sites Fix

0,0,36,8

Sites fix

dashboardData

Working sites

CUSTOM_TABLE

TRUE

Working Sites

0,0,36,8

Working sites

dashboardData

Storage by product

CUSTOM_TABLE

TRUE

Storage by Product

0,0,36,8

Storage by product

dashboardData

Production cost

CUSTOM_TABLE

TRUE

Production cost

0,0,36,8

Production cost

dashboardData

Production flows

CUSTOM_TABLE

TRUE

Production flows

0,0,36,8

Production flows

dashboardData

Multiple flow constraints

CUSTOM_TABLE

TRUE

Multiple Flows Constraints

0,0,36,8

Multiple flow constraints

dashboardData

Multiple storage constraints

CUSTOM_TABLE

TRUE

Multiple Storages Constraints

0,0,36,8

Multiple storage constraints

dashboardData

Demand

CUSTOM_TABLE

TRUE

Demand

0,0,36,8

Demand

dashboardData

Vehicle flows

CUSTOM_TABLE

TRUE

VEHICLES_FLOWS

0,0,36,8

Vehicle flows

dashboardData

Named expressions

CUSTOM_TABLE

TRUE

Named Expressions

0,0,36,8

Named expressions

dashboardData

Objective Members

CUSTOM_TABLE

TRUE

Objective Members

0,0,36,8

Objective Members

dashboardData

Overall stats

CUSTOM_TABLE

TRUE

Overall Stats

0,0,36,8

Overall stats

preProcessor

postProcessor

Experiment 2

customType

name

type

Custom

scenario

PB NO Level 2 Solution

statisticsSettings

GFA_FLOWS::true;d;f

GFA_NEW_SITES::true;d;f

GFA_DISTANCE_BY_DEMAND::true;d;f

GFA_DEMAND_BY_DISTANCE::true;d;f

GFA_TOTAL_DEMAND_BY_DISTANCE::true;d;f

LINEAR_COSTS::true;d;f

Flows Details::true;d;f

Sites Initial::true;d;f

Sites Fix::true;d;f

Storage by Product::true;d;f

Production cost::true;d;f

Production flows::true;d;f

Multiple Flows Constraints::true;d;f

Working Sites::true;d;f

Multiple Storages Constraints::true;d;f

Demand::true;d;f

VEHICLES_FLOWS::true;d;f

Named Expressions::true;d;f

Objective Members::true;d;f

Overall Stats::true;d;f

Flows Amount::true;d;f

DAILY_VEHICLES_SHIPPED::true;d,Type,Object,Vehicle type;f

DAILY_VEHICLES_USAGE::true;d,Type,Object,Vehicle type;f

TRAVELLED_DISTANCE::true;d,Type,Object,Vehicle type;f

DAILY_PRODUCTS_SHIPPED_INTERNAL::true;d,Type,Object,Vehicle type;f

AVAILABLE_INVENTORY_AMOUNT::true;d,Type,Object,Product,Period;f

CURRENT_BACKLOG_PRODUCTS::true;d,Type,Object,Product,Period;f

MAX_CAPACITY_VOLUME::true;d,Type,Object;f

ON_HAND_INVENTORY_VOLUME::true;d,Type,Object,Product,Period;f

FACILITY_CO2_STATS::true;d,Type,Object,Period;f

STORING_CO2_PER_M3_STATS::true;d,Type,Object,Product,Period;f

MAX_CAPACITY_INTERNAL2::true;d,Type,Object,Period;f

FACILITY_COSTS::true;d,Type,Object,Period;f

CARRYING_COSTS::true;d,Type,Object,Product,Period;f

TRANSPORTATION_COSTS::true;d,Type,Object,Vehicle type,Destination;f

OTHER_COSTS::true;d,Type,Object;f

REVENUE::true;d,Type,Object,Product;f

PRODUCTS_LOST::true;d,Type,Object,Product;f

ORDERS_LOST::true;d,Type,Object,Product;f

DAILY_INCOMING_REPLENISHMENT_PRODUCTS::true;d,Type,Object,Product,Period;f

DAILY_INCOMING_REPLENISHMENT_ORDERS::true;d,Type,Object,Product,Period;f

DAILY_PRODUCTS_SHIPPED::true;d,Type,Object,Product,Vehicle type,Period,Destination;f

PRODUCT_FLOWS_TABLE::true;d,Object;f

INVENTORY_PURCHASES::true;d,Type,Object,Product;f

INITIAL_COSTS::true;d,Type,Object;f

DAILY_ITEMS_RECEIVED::true;d,Type,Object,Product,Period;f

DAILY_ORDERS_RECEIVED::true;d,Type,Object,Product,Period;f

INTERESTS_STATS::true;d,Type,Object;f

DAILY_OUTGOING_REPLENISHMENT_PRODUCTS::true;d,Type,Object,Product,Period;f

DAILY_OUTGOING_REPLENISHMENT_ORDERS::true;d,Type,Object,Product,Period;f

DAILY_ORDERS_SHIPPED::true;d,Type,Object,Product,Vehicle type,Period,Destination;f

LOADING_TIME_VEHICLE::true;d,Type,Object,Vehicle type;f

UNLOADING_TIME_VEHICLE::true;d,Type,Object,Vehicle type;f

GATES_BUSY::true;d,Type,Object,Staff type;f

GATES_IDLE::true;d,Type,Object,Staff type;f

CURRENT_BACKLOG_ORDERS::true;d,Type,Object,Product,Period;f

CLOSURE_COSTS::true;d,Type,Object;f

ORDERED_PRODUCTS_SENT::true;d,Type,Object,Product,Period;f

PRODUCTS_BULLWHIP_EFFECT::true;d,Type,Object,Product;f

INPUT_PROCESSING_COSTS::true;d,Type,Object,Product,Period;f

PROCESSING_CO2_INPUT_STATS::true;d,Type,Object,Product,Period;f

PROCESSING_CO2_OUTPUT_STATS::true;d,Type,Object,Product,Period;f

CLOSURE_CO2::true;d,Type,Object;f

INITIAL_CO2::true;d,Type,Object;f

OTHER_CO2::true;d,Type,Object;f

TRANSPORTATION_CO2::true;d,Type,Object,Vehicle type,Destination;f

TOTAL_COSTS::true;d,Type,Object;f

OUTPUT_PROCESSING_COSTS::true;d,Type,Object,Product,Period;f

Shipments schedule::false;d,Object;f

PRODUCTION_COSTS::true;d,Type,Object,Product,Period;f

PRODUCED::true;d,Type,Object,Product,Period;f

PRODUCTION_REQUESTS::true;d,Type,Object,Product,Period;f

PRODUCTION_LINE_BUSY_TIME::true;d,Type,Object,Product,Period;f

PRODUCTION_LINE_IDLE_TIME::true;d,Type,Object,Product,Period;f

PRODUCED_ORDERS::true;d,Type,Object,Product,Period;f

PRODUCTION_REQUEST_ORDERS::true;d,Type,Object,Product,Period;f

PRODUCTION_CO2::true;d,Type,Object,Product,Period;f

STAFF_BUSY_TIME::true;d,Type,Object;f

STAFF_IDLE_TIME::true;d,Type,Object;f

Utilized Volume (Yogurt Factory)::true;d,Type,Object,Product;f

Delayed Batches (Yogurt Factory)::true;d,Type,Object;f

DC Rating (Online Shop)::true;d,Type,Object;f

ZONE_LOAD::true;d,Type,Object,Zone;f

BUSY_STAFF::true;d,Type,Object,Staff type;f

ZONE_CAPACITY::true;d,Type,Object,Zone;f

STAFF_TOTAL::true;d,Type,Object,Staff type;f

CUSTOMER_REVENUE::true;d,Type,Object,Product,Period;f

CUSTOMER_DELAYED_ORDERS::true;d,Type,Object,Product,Source,Period;f

CUSTOMER_IN_TIME_ORDERS::true;d,Type,Object,Product,Source,Period;f

CUSTOMER_ORDERS_TOTAL::true;d,Type,Object,Product,Period;f

CUSTOMER_DELAYED_PRODUCTS::true;d,Type,Object,Product,Source,Period;f

CUSTOMER_IN_TIME_PRODUCTS::true;d,Type,Object,Product,Source,Period;f

CUSTOMER_PRODUCTS_TOTAL::true;d,Type,Object,Product,Period;f

ORDERS::true;d,Type,Object,Product,Period;f

ORDERED_PRODUCTS::true;d,Type,Object,Product,Period;f

DROPPED_ORDERS::true;d,Type,Object,Product,Source,Period;f

DROPPED_ORDERED_PRODUCTS::true;d,Type,Object,Product,Source,Period;f

LEAD_TIME::true;d,Type,Object,Product,Source;f

SUCCESSFUL_ORDERS_SIZE::true;d,Type,Object,Product,Source,Period;f

SUCCESSFUL_ORDERS::true;d,Type,Object,Product,Source,Period;f

UNSUCCESSFUL_ORDERS_SIZE::true;d,Type,Object,Product,Source,Period;f

UNSUCCESSFUL_ORDERS::true;d,Type,Object,Product,Source,Period;f

Negative Feedback (Online Shop)::true;d,Type,Object;f

Positive Feedback (Online Shop)::true;d,Type,Object;f

No Feedback (Online Shop)::true;d,Type,Object;f

Demand Placed (Dropped Late Orders) by Customer (Online Shop)::true;d,Type,Object;f

PRODUCT_VOLUMES::true;d,Product;f

PRODUCT_COSTS::true;d,Product;f

PRODUCT_PRICES::true;d,Product;f

VEHICLE_VOLUMES::true;d,Vehicle type;f

CASH::true;d,Period,Account;f

INTERESTS::true;d,Period,Account;f

ACCOUNT_PAYABLE::true;d,Period,Account;f

LOAN::true;d,Period,Account;f

ACCOUNT_RECEIVABLE::true;d,Period,Account;f

EVENTS_TABLE::true;d,Object;f

TOTAL_INTERESTS_PAID::true;d,Period,Account;f

TOTAL_CO2::true;d,Object;f

EBITDA::true;d,Object;f

FACILITY_CO2::true;d,Object,Period;f

CARRYING_CO2::true;d,Object,Product,Period;f

INVENTORY_MINUS_BACKLOG_AMOUNT::true;d,Object,Product;f

INPUT_PROCESSING_CO2::true;d,Object,Product,Period;f

OUTPUT_PROCESSING_CO2::true;d,Object,Product,Period;f

GENERAL_ORDERS_SERVICE_LEVEL_ALPHA_TYPE::true;d,Object,Product,Source,Period;f

GENERAL_PRODUCTS_SERVICE_LEVEL_ALPHA_TYPE::true;d,Object,Product,Source,Period;f

GENERAL_MONEY_SERVICE_LEVEL_BETA_TYPE::true;d,Object,Product,Source,Period;f

OPPORTUNITY_COSTS::true;d,Object,Product;f

GENERAL_COST_PER_ORDER::true;d,Object;f

GENERAL_COST_PER_PRODUCT::true;d,Object;f

GENERAL_ORDERS_SERVICE_LEVEL_BY_ELT::true;d,Object,Product,Source,Period;f

GENERAL_PRODUCTS_SERVICE_LEVEL_BY_ELT::true;d,Object,Product,Source,Period;f

AVERAGE_ON_HAND_INVENTORY_DAYS::true;d,Object,Product,Period;f

AVERAGE_ON_HAND_INVENTORY_IN_PRODUCT_UNITS_DAYS::true;d,Object,Product,Period;f

ELT_SERVICE_LEVEL_BY_REVENUE::true;d,Object,Product,Source,Period;f

AVAILABLE_INVENTORY_VOLUME_INTEGRAL::true;d,Object,Product,Period;f

MEAN_LEAD_TIME::true;d,Object,Product,Source;f

PRODUCTION_UTILIZATION::true;d,Object,Product,Period;f

TRANSPORT_UTILIZATION::true;d,Type,Object,Vehicle type;f

VEHICLES_USAGE::true;d,Object,Vehicle type;f

MAX_VEHICLES_USAGE::true;d,Object,Vehicle type;f

Max lead time::true;d,Object,Product,Source;f

GATES_UTILIZATION::true;d,Object,Staff type;f

AVAILABLE_INVENTORY_CUSTOM::true;d,Object,Product,Period;f

AVAILABLE_INVENTORY_INTEGRAL_CUSTOM::true;d,Object,Product,Period;f

PRODUCED_CUSTOM::true;d,Type,Object,Product,Period;f

CASH_MINUS_LOAN::true;d,Period,Account;f

CASH_MINUS_INTERESTS::true;d,Period,Account;f

CASH_MINUS_LOAN_INTERESTS::true;d,Period,Account;f

LOAN_PLUS_INTERESTS::true;d,Period,Account;f

STAFF_UTILIZATION_DC_WITH_STAFF::true;d,Object;f

STAFF_UTILIZATION_EXTENDED_DC::true;d,Object,Staff type;f

SPACE_UTILIZATION::true;d,Object,Zone;f

PROFIT_AND_LOSS_STATEMENT::true;d,Object;f

SAFETY_STOCK_INVENTORY_BASED::true;d,Type,Object,Product,Period;f

DC with capacity::true;d;f

GENERATED_MILK_RUNS::true;d;f

GENERATED_MILK_RUN_SEGMENTS::true;d;f

TO_SKIPPED_CUSTOMERS::true;d;f

ITERATION_SEEDS::true;d;f

Units settings

Currency::USD

Volume::m³

Time::day

Distance::km

timeType

All periods

startPeriod

endPeriod

startDate

2019-01-01T00:00

stopDate

2019-12-31T00:00

dashboardData

Page name

Chart type

Accumulative

Stats names

Layout data

Detalization

Filters

Chart name

dashboardData

Log

preProcessor

postProcessor

Icons

Customer	4
Factory	3
DC	2