6.3American Airlines Uses Should-Cost Modeling to Assess the Uncertainty of Bids for Shipment Routes
1.Primary (e.g., interviews) and secondary (e.g., Internet) sources were scouted for base-case and range data that would inform cost variables that affect an FTL bid.
2.Cost variables were chosen so that they were mutually exclusive and collectively exhaustive.
3.The DPL decision analysis software was used to model the uncertainty.
Application Case6.5Metro Meals on Wheels Treasure Valley Uses Excel to Find Optimal Delivery Routes
- What were the challenges faced by Metro Meals on Wheels Treasure Valley related to meal delivery before adoption of the spreadsheet-based tool?
- Explain the design of the spreadsheet-based model.
- What are the intangible benefits of using the Excel-based model to Metro Meals on Wheels?