Delivery Orders
The data model includes measures such as total delivery orders, on-time delivery orders, late delivery orders, closed delivery orders, and delivery orders in progress. It also captures quantities related to Consumed Units, containers, and accuracy percentage of deliveries. Additionally, various attributes like article code, number of order lines, and deadline times for different days are integrated, supporting route optimization and shipment processing. Views like Rounds and Waves aid in visualizing delivery order breakdowns and grouping for efficient processing.
Benefits of This Data Model
- Improved delivery efficiency: Route optimization based on round breakdowns from the Rounds view and groupings from the Waves view leads to more efficient shipment processing.
- Enhanced order accuracy: Tracking progress within waves through the Waves Follow-Up view and identifying discrepancies in product quantities per delivery order line with the Shortage Per DO Lines view improves order accuracy.
- Predictive delivery status: The Expected Status view predicts delivery order status based on historical data and current trends, helping in proactive management of delivery expectations.
- Streamlined distribution planning: Consolidating delivery orders into standardized rounds through the Generic Rounds view supports distribution planning for smoother logistics operations.
- Optimized delivery timelines: Estimating delivery dates based on order processing and logistics timelines with the Expected delivery view aids in setting and meeting efficient delivery schedules.
Key Performance Indicators (KPIs)
- Ordre de livraison Total: Total number of delivery orders.
- Maquette Niveau le plus bas: Lowest level of mockup.
- Ordre de livraison À temps: Number of delivery orders delivered on time.
- Ordre de livraison À temps (%): Percentage of delivery orders delivered on time.
- Ordre de livraison En retard: Number of delivery orders delivered late.
- Ordre de livraison En retard (%): Percentage of delivery orders delivered late.
- Ordre de livraison Fermé: Number of closed delivery orders.
- Ordre de livraison En cours: Number of delivery orders in progress.
- Quantité UC: Quantity of Unit of Consumption.
- Quantité total Total Shipped CU: Total quantity of shipped Consumed Units.
- Quantité Transferred CU: Quantity of Consumed Units transferred.
- Quantité Picked CU: Quantity of Consumed Units picked.
- Quantité Canceled Shipping CU: Quantity of Consumed Units with canceled shipping.
- Quantité Cross-Docking CU: Quantity of Consumed Units processed through cross-docking.
- Quantité UC Kit: Quantity of Unit of Consumption in kit form.
- Quantité Not Transferred CU: Quantity of Consumed Units not transferred.
- Quantité Launch CU: Quantity of Consumed Units launched.
- Quantité Postponed CU: Quantity of Consumed Units postponed.
- Quantité Stock Shortage CU: Quantity of Consumed Units impacted by stock shortage.
- Quantité Contenant: Quantity of containers.
- Quantité Shipped CU: Quantity of Consumed Units shipped.
- Livraison Précision %: Accuracy percentage of deliveries.
- Article Code: Code of the article.
- Order Nombre de lignes: Number of lines in the order.
- Tournée générique Heure limite du lundi: Deadline time for Monday's generic tour.
- Tournée générique Heure limite du mardi: Deadline time for Tuesday's generic tour.
- Tournée générique Heure limite du mercredi: Deadline time for Wednesday's generic tour.
- Tournée générique Heure limite du jeudi: Deadline time for Thursday's generic tour.
- Tournée générique Heure limite du vendredi: Deadline time for Friday's generic tour.
- Ordre de livraison Expédié: Number of orders shipped.
- Ordre de livraison Non-expédié: Number of orders not shipped.
- Ordre de livraison Taux de service: Service rate of delivery orders.
Available Visualizations
| View Name | Description |
|---|---|
| Rounds | Provides a breakdown of delivery orders by rounds for route optimization. |
| Waves | Displays delivery orders grouped together for efficient shipment processing. |
| Waves Follow-Up | Tracks progress and status updates for delivery orders within waves. |
| Shortage Per DO Lines | Identifies discrepancies in product quantities per delivery order line. |
| Generic Rounds | Consolidates delivery orders into standardized rounds for distribution planning. |
| Expected delivery | Estimates delivery dates based on order processing and logistics timelines. |
| Expected Status | Predicts delivery order status based on historical data and current trends. |