Output Format Guide
Output Format Guide
Overview
The Delivery Schedule Optimization application generates two main output tables that provide the optimized delivery schedule and associated costs.
Output Tables
1. Demand Output
Contains detailed order assignments:
| Column | Description |
|---|---|
| demand_id | Original order identifier |
| origin_site_name | Warehouse fulfilling the order |
| destination_site_name | Customer location |
| product_name | Product being shipped |
| transportation_mode | Mode of transportation used |
| transportation_date | Planned shipping date |
| quantity | Quantity to be shipped |
| cost | Transportation cost for this shipment |
2. Transportation Output
Contains consolidated shipment information:
| Column | Description |
|---|---|
| origin_site_name | Warehouse identifier |
| destination_site_name | Customer identifier |
| product_name | Product identifier |
| transportation_mode | Mode of transportation |
| transportation_date | Shipping date |
| transportation_quantity | Total quantity shipped |
| cost | Total transportation cost |
Output Interpretation
Demand Output
- One row per order-shipment combination
- Shows how each order is fulfilled
- Includes cost allocation for each shipment
- Useful for:
- Order tracking
- Customer communication
- Cost analysis by order
Transportation Output
- Consolidated view of shipments
- One row per unique shipment
- Shows total quantities and costs
- Useful for:
- Warehouse planning
- Transportation scheduling
- Cost analysis by route
Key Metrics
1. Order Fulfillment
- Number of orders assigned
- Total order volume assigned
- Percentage of orders fulfilled
2. Cost Analysis
- Total transportation cost
- Cost per order
- Cost per unit shipped
- Cost by transportation mode
3. Warehouse Utilization
- Daily warehouse capacity utilization
- Total volume shipped per warehouse
- Number of shipments per warehouse
4. Transportation Analysis
- Shipments by mode
- Average shipment size
- Number of consolidated shipments
Export Options
-
Excel Export
- Separate sheets for each output table
- Formatted for easy reading
- Includes summary statistics
-
CSV Export
- Raw data format
- Suitable for further analysis
- Compatible with other systems
Using the Output
1. Operational Planning
- Use transportation_date for scheduling
- Check transportation_mode for carrier selection
- Use transportation_quantity for loading plans
2. Cost Analysis
- Analyze cost by route
- Compare costs across warehouses
- Identify cost-saving opportunities
3. Performance Monitoring
- Track order fulfillment rates
- Monitor warehouse utilization
- Analyze transportation efficiency
Best Practices
- Review output for reasonableness
- Check for any unassigned orders
- Verify capacity constraints are respected
- Analyze cost distribution
- Export and save results for future reference