Simulation Customer Summary

Internal Table Name: SimulationOutputCustomerSummary

Use this table to review statistics about orders, revenue and inbound flows to each customer per period.

Scenario

Table: SimulationOutputCustomerSummary

Internal Name: Not Applicable (Scenario column not in table)

Displays the name of the scenario which generated the customer summary data.

Customer Name

Table: SimulationOutputCustomerSummary

Internal Name: CustomerName

Displays the customer to which the summary applies.

Avg On Time Rate

Table: SimulationOutputCustomerSummary

Internal Name: AvgOnTimeRate

Displays the weighted average of the orders that were successfully delivered to the customer on time (before their due date) to the total number of orders received during this period.

Avg On Time Qty Rate

Table: SimulationOutputCustomerSummary

Internal Name: AvgOnTimeQtyRate

Displays the weighted average of the number of units that were delivered to the customer on time (before their due date) to the total number of orders received during this period.

Inbound Flow Units

Table: SimulationOutputCustomerSummary

Internal Name: InboundFlowUnits

Displays the total number of units of all products to this customer in this period.

Inbound Flow Weight

Table: SimulationOutputCustomerSummary

Internal Name: InboundFlowWeight

Displays the total weight of all products to this customer in this period.

Inbound Flow Cubic

Table: SimulationOutputCustomerSummary

Internal Name: InboundFlowCubic

Displays the total cubic volume of all products to this customer in this period.

Total Revenue

Table: SimulationOutputCustomerSummary

Internal Name: TotalRevenue

Displays the total revenue generated during the simulation by product being shipped to this customer.

Lost Revenue

Table: SimulationOutputCustomerSummary

Internal Name: LostRevenue

Displays the lost revenue due to canceled or lost demand units during the specified period.

Total Demand

Table: SimulationOutputCustomerSummary

Internal Name: TotalDemand

Displays the total number of demand units for all products at this customer in this period.

Lost Demand

Table: SimulationOutputCustomerSummary

Internal Name: LostDemand

Displays the number of demand units that were canceled or lost during the specified period.

Total Process Cost

Table: SimulationOutputCustomerSummary

Internal Name: TotalProcessCost

The total cost incurred for all processes.

Total Sourcing Process Cost

Table: SimulationOutputCustomerSummary

Internal Name: TotalSourcingProcessCost

The total cost incurred for all sourcing processes.

Total Transportation Process Cost

Table: SimulationOutputCustomerSummary

Internal Name: TotalTransportationProcessCost

The total cost incurred for all transportation processes.

Total Returns Process Cost

Table: SimulationOutputCustomerSummary

Internal Name: TotalReturnsProcessCost

The total cost incurred for all returns processes.

Total Return Cost

Table: SimulationOutputCustomerSummary

Internal Name: TotalReturnCost

The total cost incurred for all returns.

Period

Table: SimulationOutputCustomerSummary

Internal Name: Period

Displays the Period number for the summary values. ALL indicates the record for the complete model horizon.

Scenario ID

Table: SimulationOutputCustomerSummary

Internal Name: ScenarioID

Displays the identifier of the scenario for which the summary data was generated.

Sub-Scenario ID

Table: SimulationOutputCustomerSummary

Internal Name: StepNumber

Displays the identifier of the sub-scenario, if applicable, for which the summary data was generated.

Rep

Table: SimulationOutputCustomerSummary

Internal Name: Rep

Displays the replication number that the data on this row apply to.

Last modified: Wednesday May 15, 2024

Is this useful?