Customer Product Summary
Internal Table Name: SimulationOutputCustomerProductDetail
This table shows detailed information at the customer-product level, including order cycle time values. This table contains a unique record for each site, product, scenario, replication and period combination.
Scenario
Table: SimulationOutputCustomerProductDetail
Internal Name: Not Applicable (Scenario column not in table)
Displays the name of the scenario which generated the customer-product detail data.
Customer Name
Table: SimulationOutputCustomerProductDetail
Internal Name: CustomerName
Displays the name of the Customer referred to in the report.
Product Name
Table: SimulationOutputCustomerProductDetail
Internal Name: ProductName
Displays the specific item detailed in the report.
Average Order Cycle Time
Table: SimulationOutputCustomerProductDetail
Internal Name: AverageOrderCycleTime
Displays the average of the order cycle times (in DAYS) at this Customer and for this product in the specified period from all sources. Order cycle time is the difference between the time the entire order was filled and the Due Date. If the value is negative, this is a measure of how much more quickly the cycles are being fulfilled compared to when they are due. If the Due Date is not set, it is treated as the end of time and the order cycle time will be 0.
Due Dates are set in the Shipments or Productions tables.
where:
A = Final delivery date
D = Due Date
n = orders completely received
Maximum Order Cycle Time
Table: SimulationOutputCustomerProductDetail
Internal Name: MaximumOrderCycleTime
Displays the highest cycle time from all sources by customer and product in the specified period. See Average Order Cycle Time for more details.
On Time Rate
Table: SimulationOutputCustomerProductDetail
Internal Name: MaximumOrderCycleTime
Displays the ratio of orders successfully received on time at this customer versus all orders received. If there is no Due Date, the order is counted as on time. See Average Order Cycle Time for additional information about Due Date.
D/R
where:
D = Orders received at this customer before the Due Date.
R = Orders received at this customer.
On Time Qty Rate
Table: SimulationOutputCustomerProductDetail
Internal Name: OnTimeQtyRate
Displays the ratio of units received on time at this customer versus all units received. If there is no Due Date, the order is counted as on time. See Average Order Cycle Time for additional information about Due Date.
Q/R
where:
Q = Quantity received at this customer before the Due Date.
R = Quantity received at this customer.
Ending Orders
Table: SimulationOutputCustomerProductDetail
Internal Name: EndingOrders
Displays the number of outstanding upstream orders at the end of the period which have yet to be filled. A shipment that has not arrived is included in Ending Orders. An order partially filled will result in a percentage unfilled. For example, you have an original order for 10 that has 7 units filled, but 3 are still waiting – in this case Ending Orders will be 0.30.
Ending Order Qty
Table: SimulationOutputCustomerProductDetail
Internal Name: EndingOrderQty
Displays the total number of outstanding upstream units at the end of the period which have yet to be filled.
Total Orders
Table: SimulationOutputCustomerProductDetail
Internal Name: TotalOrders
Displays the total number of orders by this customer during this period.
Total Order Qty
Table: SimulationOutputCustomerProductDetail
Internal Name: TotalOrderQty
Displays the total number of product units ordered upstream by this customer during the specified period.
Period
Table: SimulationOutputCustomerProductDetail
Internal Name: Period
Displays the Period number for the summary values. ALL indicates the record for the complete model horizon.
Total Demand
Table: SimulationOutputCustomerProductDetail
Internal Name: TotalDemand
Displays the total demand for this product at this Customer during the specified period.
Total Revenue
Table: SimulationOutputCustomerProductDetail
Internal Name: TotalRevenue
Displays the total revenue generated during the specified period by product received by the customer. Product that is in-transit or otherwise not received before the end of the model is not added to revenue:
Total Revenue = (Sum of all product received by customers) * (Price per Product)
Lost Demand
Table: SimulationOutputCustomerProductDetail
Internal Name: LostDemand
Displays the number of demand units that were canceled or lost during the specified period. Lost demand occurs when a chosen source has the Allow Back Orders field in the Site Sourcing Policies table set to “No” and the source cannot fulfill an order. If the source has the Allow Partial Fill field in the Inventory Policies table set to “Yes”, the site will fill as much of the order as possible from available inventory and the balance will be added to Lost Demand. If the Allow Partial Fill field is set to “No” and the source cannot fill the entire order, the entire order is Lost Demand. Another way to generate lost demand is if the Cancel If Late field is set to "Yes" in the Demand or Shipments tables. Any remaining balance on an order when the time of order processing is greater than the Due Date will be added to lost demand.
Lost Revenue
Table: SimulationOutputCustomerProductDetail
Internal Name: LostRevenue
Displays the lost revenue due to canceled or lost demand units during the specified period. See Lost Demand for additional details.
Lost Revenue = (Sum or all product units in Lost Demand) * (Price per Product)
Average Age
Table: SimulationOutputCustomerProductDetail
Internal Name: AverageAge
This is the weighted average age of a product batch when it arrives at the destination. This column takes into consideration the transit times from the production site to this destination. For example, if you have a path from MFG -> DC -> CZ, the Average Age when it reaches the CZ includes both the travel time from MFG to DC and from DC to CZ.
Scenario ID
Table: SimulationOutputCustomerProductDetail
Internal Name: ScenarioID
Displays the identifier of the scenario for which the summary data was generated.
Sub-Scenario ID
Table: SimulationOutputCustomerProductDetail
Internal Name: StepNumber
Displays the identifier of the sub-scenario, if applicable, for which the summary data was generated.
Rep
Table: SimulationOutputCustomerProductDetail
Internal Name: Rep
Displays the replication number that the data on this row applies to.
Last modified: Wednesday May 15, 2024