Built for
Strategic Stan · Network Strategy Lead · great in Excel · no access to optimization models
— built for him by Maria on his team
Launch Private Fleet?
Assets on local fleet
0
Assets one-way
1
Pallet utilization
16.3
Total cost
974
Total Assets Used
DEPOT-CHI
30
Decision Summary
Scenario: Signature Scenario|
decision: Fleet characteristics exceed cost or service level limits. Attempt new configuration.|
sum_total_cost: 973.6499999999999|
unrouted_pallets: 0|
decision_status: No
What Maria deliberately left out
- Page-level filters — this is the whole plan, not a slice of it
- Legal / driver hours config — uniform across the network, Stan shouldn't have to touch it
- Columns that would always be blank — every field visible has a value
- Parameter sweep / auto-scenarios — Stan builds one scenario at a time to grow his mental model
Transportation Carrier
Input table · editable
Carriers available to the model. Set active to TRUE to let the optimizer use one.
| carrier_id | carrier_name | mode | ownership | active | rate_basis |
|---|---|---|---|---|---|
| CAR-001 | Midwest Freight LLC | TL | one-way | TRUE | distance |
| CAR-002 | Lakeshore Carriers | TL | one-way | TRUE | distance |
| CAR-003 | Prairie Logistics | LTL | one-way | TRUE | weight |
| FLEET-CHI | Chicago Private Fleet | TL | private | FALSE | fixed + distance |
| CAR-004 | Great Lakes Express | TL | one-way | TRUE | distance |
| CAR-005 | Heartland Transport | TL | one-way | TRUE | distance |