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

Is this useful?