Product Delivery#
Overview#
The Product Delivery dashboard provides insights into the performance of production order execution and delivery timeliness. It helps monitoring delivery performance, identifying bottlenecks, and ensuring commitments are met on schedule.
Folder#
Performance.
Database#
- CDM (queried via OData).
- DWH (queried via OData).
Data#
- On Time Delivery
- Volume Fulfillment
- Production Orders
Example#
Data Breakdown#
| KPI | Description | Formula | Datasource |
|---|---|---|---|
| On Time Delivery (%) | Percentage of completed production orders finished before their due date. | (On-time completed POs ÷ Total completed POs) × 100 | Production.ProductionOrder table in CDM from ProductionOrder (IoT Event Definition) |
| Volume Fulfillment (%) | Overall percentage of completed quantity vs. planned quantity. | (Sum of Completed Quantity ÷ Sum of Planned Quantity) × 100 | Production.ProductionOrder table in CDM from ProductionOrder (IoT Event Definition) |
| Production Orders | Overview of orders across states: completed, in progress, or overdue. | Count by state (Completed, InProgress, Released) | Production.ProductionOrder table in CDM ProductionOrder (IoT Event Definition) and ProductionOrdersInProgress and PendingLateProductionOrders tables in DWH ProductionOrdersInProgress and PendingLateProductionOrders |
Data Visualization#
| Panel | Description | Threshold Values | Datasource |
|---|---|---|---|
| On Time Delivery | KPI card showing percentage of orders delivered before due date. | As high as possible. | Production.ProductionOrder table in CDM from ProductionOrder (IoT Event Definition) |
| Volume Fulfillment | KPI card showing percentage of completed and planned orders, considering released, in-progress, and completed production orders. | As high as possible. | Production.ProductionOrder table in CDM from ProductionOrder (IoT Event Definition) |
| Completed Production Orders | KPI card showing the total number of completed orders. | N/A | Production.ProductionOrder table in CDM |
| Total Production Orders | KPI card showing the number of total orders (released, in progress, completed). | N/A | Production.ProductionOrder table in CDM from ProductionOrder (IoT Event Definition) |
| Production Orders in Progress | Horizontal bar chart showing progress of each ongoing production order. | Orders in green are on time; red indicates overdue. | ProductionOrdersInProgress table in DWH ProductionOrdersInProgress |
| Pending Late Production Orders | Breakdown of overdue production orders, including Order, Product, Description, Quantity, Units, Customer, Due Date, and Delay. | N/A | PendingLateProductionOrders table in DWH PendingLateProductionOrders |
Entity Filters#
Single selection:
- Enterprise
- Site
- Facility
Multiple/All selection:
- Production Order
- Product Group
- Product
Time/Date Filter#
The system provides a time/date filter with an Absolute time range option and a list of quick ranges, which you can apply as shown in the image below.
Date Filter Options#
- Changing Time Zone
- Changing Fiscal Year
Refresh Button Options#
The system provides a Refresh button with various options to select.