AnyLogistix Assignment rev1

profilevasuvasa4748
AnylogistixData.xlsx
Home>Education homework help>AnyLogistix Assignment rev1

Scenario settings

startDate
endDate
description
type GFA
name My Supply Chain
creationDate 2017-05-31

Customers

Name Type Location Inclusion Type Icon
Phoenix Customer Phoenix location Include 4
Dallas Customer Dallas location Include 4
Boston Customer Boston location Include 4
Nashville Customer Nashville location Include 4
Orlando Customer Orlando location Include 4
San Antonio Customer San Antonio location Include 4
Denver Customer Denver location Include 4
Seattle Customer Seattle location Include 4
Philadelphia Customer Philadelphia location Include 4
Los Angeles Customer Los Angeles location Include 4
Chicago Customer Chicago location Include 4
Detroit Customer Detroit location Include 4
Jacksonville Customer Jacksonville location Include 4
San Jose Customer San Jose location Include 4
Kansas City Customer Kansas City location Include 4
Atlanta Customer Atlanta location Include 4
New York Customer New York location Include 4
Salt Lake City Customer Salt Lake City location Include 4
San Diego Customer San Diego location Include 4

DCs and Factories

Name Type Location Inclusion Type Icon

Demand

Customer Product Demand Type Time Period
Phoenix PeriodicDemand[period::2.0;quantity::108.0] (All periods)
Dallas PeriodicDemand[period::5.0;quantity::225.0] (All periods)
Boston PeriodicDemand[period::5.0;quantity::10.0] (All periods)
Nashville PeriodicDemand[period::3.0;quantity::68.0] (All periods)
Orlando PeriodicDemand[period::2.0;quantity::18.0] (All periods)
San Antonio PeriodicDemand[period::3.0;quantity::152.0] (All periods)
Denver PeriodicDemand[period::3.0;quantity::70.0] (All periods)
Seattle PeriodicDemand[period::5.0;quantity::10.0] (All periods)
Philadelphia PeriodicDemand[period::3.0;quantity::165.0] (All periods)
Los Angeles PeriodicDemand[period::1.0;quantity::138.0] (All periods)
Chicago PeriodicDemand[period::3.0;quantity::287.0] (All periods)
Detroit PeriodicDemand[period::2.0;quantity::48.0] (All periods)
Jacksonville PeriodicDemand[period::1.0;quantity::30.0] (All periods)
San Jose PeriodicDemand[period::5.0;quantity::179.0] (All periods)
Kansas City PeriodicDemand[period::5.0;quantity::83.0] (All periods)
Atlanta PeriodicDemand[period::3.0;quantity::48.0] (All periods)
New York PeriodicDemand[period::1.0;quantity::300.0] (All periods)
Salt Lake City PeriodicDemand[period::5.0;quantity::34.0] (All periods)
San Diego PeriodicDemand[period::1.0;quantity::50.0] (All periods)

Historic Demand

id date quantity

Groups

Name Description Customers Sites Suppliers Groups

Location Groups

Name Locations

Locations

Code Name Region Country Latitude Longitude Autofill Coordinates
Denver location USA 39.7391536 -104.9847033 FALSE
Salt Lake City location USA 40.7670126 -111.8904307 FALSE
Chicago location USA 41.8755546 -87.6244211 FALSE
Boston location USA 42.3604823 -71.0595677 FALSE
Dallas location USA 32.7762719 -96.7968558 FALSE
San Antonio location USA 29.4246002 -98.4951404 FALSE
Kansas City location USA 39.0844687 -94.5630297 FALSE
Jacksonville location USA 30.3321838 -81.6556509 FALSE
San Diego location USA 32.7174209 -117.1627713 FALSE
Seattle location USA 47.6038321 -122.3300623 FALSE
San Jose location USA 37.3361905 -121.8905832 FALSE
Detroit location USA 42.3486635 -83.0567374 FALSE
Los Angeles location USA 34.0543942 -118.2439408 FALSE
Atlanta location USA 33.7490987 -84.3901848 FALSE
Nashville location USA 36.1622296 -86.774353 FALSE
Phoenix location USA 33.4485866 -112.0773455 FALSE
Orlando location USA 28.5421175 -81.3790461 FALSE
New York location USA 40.7305991 -73.9865811 FALSE
Philadelphia location USA 39.9523993 -75.1635898 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
Product m³

Sourcing

Delivery Destination Product Source Time Period Inclusion Type

Suppliers

Name Type Location Products Inclusion Type Icon

ALXSettings

Property Value
Export version 2.7.1

Project units

Currency USD
Volume m³

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 Region region
Locations Country country
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

nSitesConstr 1
maxDist 200
distanceUnit km
minimizeSitesNumber FALSE
destinations (All customers)
productUnit m³
sourcingPriority FALSE
toSiteTranspCoeff 0.5
statsDistanceStep 100
realRoads FALSE
latLonOffset 100
minPopulation 50000
newSiteIcon 2
name
type GFA
scenario My Supply Chain
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 2017-01-01T00:00
stopDate 2017-12-31T00:00
preProcessor
postProcessor
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

Experiment 2

customType
name
type Custom
scenario My Supply Chain
statisticsSettings 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 MAX_CAPACITY_INTERNAL::true;d,Type,Object,Period;f STORING_COST_PER_M3_STATS::true;d,Type,Object,Product,Period;f FACILITY_COST_STATS::true;d,Type,Object,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 PROCESSING_COST_INPUT_STATS::true;d,Type,Object,Product,Period;f PROCESSING_COST_OUTPUT_STATS::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 Shipments schedule::false;d,Object;f PRODUCTION_COSTS::true;d,Type,Object,Product;f PRODUCED::true;d,Type,Object,Product;f PRODUCTION_REQUESTS::true;d,Type,Object,Product;f PRODUCTION_LINE_BUSY_TIME::true;d,Type,Object,Product;f PRODUCTION_LINE_IDLE_TIME::true;d,Type,Object,Product;f PRODUCED_ORDERS::true;d,Type,Object,Product;f PRODUCTION_REQUEST_ORDERS::true;d,Type,Object,Product;f Cash (Cash-to-Serve)::true;d,Period;f Interests (Cash-to-Serve)::true;d,Period;f Account Payable (Cash-to-Serve)::true;d,Period;f Loan (Cash-to-Serve)::true;d,Period;f STAFF_BUSY_TIME::true;d,Type,Object;f STAFF_IDLE_TIME::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 DC rating::true;d,Type,Object;f CUSTOMER_REVENUE::true;d,Type,Object,Product,Period;f CUSTOMER_DELAYED_ORDERS::true;d,Type,Object,Product,Period;f CUSTOMER_IN_TIME_ORDERS::true;d,Type,Object,Product,Period;f CUSTOMER_ORDERS_TOTAL::true;d,Type,Object,Product,Period;f CUSTOMER_DELAYED_PRODUCTS::true;d,Type,Object,Product,Period;f CUSTOMER_IN_TIME_PRODUCTS::true;d,Type,Object,Product,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,Period;f DROPPED_ORDERED_PRODUCTS::true;d,Type,Object,Product,Period;f LEAD_TIME::true;d,Type,Object,Product;f SUCCESSFUL_ORDERS_SIZE::true;d,Type,Object,Product,Period;f SUCCESSFUL_ORDERS::true;d,Type,Object,Product,Period;f UNSUCCESSFUL_ORDERS_SIZE::true;d,Type,Object,Product,Period;f UNSUCCESSFUL_ORDERS::true;d,Type,Object,Product,Period;f Account Receivable (Cash-to-Serve)::true;d,Type,Object,Product;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 TOTAL_COSTS::true;d,Object;f EBITDA::true;d,Object;f FACILITY_COSTS::true;d,Object,Period;f CARRYING_COSTS::true;d,Object,Product,Period;f INVENTORY_MINUS_BACKLOG_AMOUNT::true;d,Object,Product;f INPUT_PROCESSING_COSTS::true;d,Object,Product,Period;f OUTPUT_PROCESSING_COSTS::true;d,Object,Product,Period;f GENERAL_ORDERS_SERVICE_LEVEL_ALPHA_TYPE::true;d,Object,Product,Period;f GENERAL_PRODUCTS_SERVICE_LEVEL_ALPHA_TYPE::true;d,Object,Product,Period;f GENERAL_MONEY_SERVICE_LEVEL_BETA_TYPE::true;d,Object,Product,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,Period;f GENERAL_PRODUCTS_SERVICE_LEVEL_BY_ELT::true;d,Object,Product,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,Period;f AVAILABLE_INVENTORY_VOLUME_INTEGRAL::true;d,Object,Product,Period;f MEAN_LEAD_TIME::true;d,Object,Product;f PRODUCTION_UTILIZATION::true;d,Object,Product;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;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;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 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 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 2017-01-01T00:00
stopDate 2017-12-31T00:00
preProcessor
postProcessor
dashboardData Page name Chart type Accumulative Stats names Layout data Detalization Filters Chart name
dashboardData Log

Icons

Experiment:GFA 2

ESRI_MAPINFO_SHEET

DO NOT EDIT For Esri use only