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

profilemoiz
PBGFALevel2withSolutions.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 PB GFA Level 1. Description of the original scenario:
type GFA
name PB GFA Level 2 with Solutions
creationDate 2018-06-19

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 Inclusion Type Icon

Demand

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

Historic Demand

id date quantity

Groups

Name Description Customers Sites Suppliers Groups

Location Groups

Name Locations

Locations

Code Name City Region Country Address Latitude Longitude Autofill Coordinates
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

Units

Name

Unit Conversions

Product Amount from Amount to Unit to

Period Groups

Name Periods

Periods

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

Product Groups

Name Products

Products

Name Unit
bicycle "all terrain" pcs
bicycle "tour" pcs
bicycle "urban" pcs
bicycle "x-cross" pcs

Sourcing

Delivery Destination Product Source Time Period Inclusion Type

Suppliers

Name Type Location Products Inclusion Type Icon

ALXSettings

Property Value
Export version 2.9.0

Project units

Currency USD
Volume m³
Distance km
Time day

Project units conversions

Field names settings

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 Inclusion Type inclusionType
DCs and Factories Icon icon
Demand Customer customerData
Demand Product product
Demand Demand Type customType
Demand Time Period timePeriod
Groups Name name
Groups Description description
Groups Customers customers
Groups Sites sites
Groups Suppliers suppliers
Groups Groups groups
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
Units Name name
Unit Conversions Product product
Unit Conversions Amount from coefficientFrom
Unit Conversions Amount to coefficientTo
Unit Conversions Unit to unitTo
Period Groups Name name
Period Groups Periods list
Periods Name name
Periods Start startDate
Periods End endDate
Periods Demand Coefficient demandCoefficient
Product Groups Name name
Product Groups Products list
Products Name name
Products Unit unit
Sourcing Delivery Destination destination
Sourcing Product product
Sourcing Source source
Sourcing Time Period timePeriod
Sourcing Inclusion Type inclusionType
Suppliers Name name
Suppliers Type customType
Suppliers Location location
Suppliers Products products
Suppliers Inclusion Type inclusionType
Suppliers Icon icon

Table names settings

Customers CustomerData_TableName
DCs and Factories SiteDataGFA_TableName
Demand DemandDataGFA_TableName
Groups FacilityGroup_TableName
Location Groups LocationList_TableName
Locations Location_TableName
Units MeasurementUnit_TableName
Unit Conversions MeasurementUnitsConversionRule_TableName
Period Groups TimePeriodGroup_TableName
Periods TimePeriodGFA_NO_TableName
Product Groups ProductGroup_TableName
Products ProductGFA_TableName
Sourcing SourcingDataGFA_TableName
Suppliers SupplierData_TableName

Experiment 1

maxDist 20
minimizeSitesNumber FALSE
destinations (All customers)
nSitesConstr 2
distanceUnit km
productUnit pcs
sourcingPriority FALSE
toSiteTranspCoeff 0.9
statsDistanceStep 100
latLonOffset 1
newSiteIcon 2
name
type GFA
scenario PB GFA Level 2 with Solutions
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
Units settings Currency::USD Volume::m³ Time::day Distance::km
timeType Custom period
startPeriod
endPeriod
startDate 2017-11-01T00:00
stopDate 2017-12-31T00:00
dashboardData Page name Chart type Accumulative Stats names Layout data Detalization Filters Chart name
dashboardData Flows CUSTOM_TABLE TRUE GFA_FLOWS 0,0,36,8 Flows
dashboardData New sites CUSTOM_TABLE TRUE GFA_NEW_SITES 0,0,36,8 New sites
dashboardData Distance by demand CUSTOM_TABLE TRUE GFA_DISTANCE_BY_DEMAND 0,0,36,8 Distance by demand
dashboardData Demand by distance CUSTOM_TABLE TRUE GFA_DEMAND_BY_DISTANCE 0,0,18,8 Demand by distance
dashboardData Demand by distance CUSTOM_TABLE TRUE GFA_TOTAL_DEMAND_BY_DISTANCE 0,0,18,8 Total demand by distance
preProcessor
postProcessor

Experiment 2

minPopulation 50000
destinations (All customers)
ignoreNotRealRoutes FALSE
nSitesConstr 1
distanceUnit km
productUnit m³
sourcingPriority FALSE
toSiteTranspCoeff 0.5
statsDistanceStep 100
latLonOffset 100
newSiteIcon 2
name
type GFAWithRoads
scenario PB GFA Level 2 with Solutions
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
Units settings Currency::USD Volume::m³ Time::day Distance::km
timeType All periods
startPeriod
endPeriod
startDate 2018-01-01T00:00
stopDate 2018-12-31T00:00
dashboardData Page name Chart type Accumulative Stats names Layout data Detalization Filters Chart name
dashboardData Product Flows CUSTOM_TABLE TRUE GFA_FLOWS 0,0,36,8 Product Flows
dashboardData New Site Locations CUSTOM_TABLE TRUE GFA_NEW_SITES 0,0,36,8 New Site Locations
dashboardData Distance Coverage by Demand CUSTOM_TABLE TRUE GFA_DISTANCE_BY_DEMAND 0,0,36,8 Distance Coverage by Demand
dashboardData Demand Coverage by Distance CUSTOM_TABLE TRUE GFA_DEMAND_BY_DISTANCE 0,0,18,8 Demand Coverage by Distance
dashboardData Demand Coverage by Distance CUSTOM_TABLE TRUE GFA_TOTAL_DEMAND_BY_DISTANCE 0,0,18,8 Total Demand Coverage by Distance
preProcessor
postProcessor

Experiment 3

customType
name
type Custom
scenario PB GFA Level 2 with Solutions
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
Experiment:GFA 2