Dedicated Fleet Sizing — Lyric Studio

Principle 2 · Built for Strategic Stan · Network Strategy Lead · great in Excel · no access to optimization models — built for him by Maria on his team

1 The problem: should we stand up a private local fleet in Chicago, or keep shipping oneway?

4 First 30s: Stan opens the app and sees the current reality — 100% oneway, $974

Launch Private Fleet?

PERCENT_ASSETS_LOCAL

0

PERCENT_ASSETS_ONEWAY

1

PALLET_UTILIZATION

16.3

SUM_TOTAL_COST

974

5 Decision, not report: the app lands on a yes/no question — not a spec sheet

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

3 Principle 3 · 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