How do I calculate volume capabilities by ocean, truck, rail, air, $3$PL$?$ I need to fill in the yellow boxes and the rest will autopopulate. I am struggling to figure this out.How do I calculate volume capabilities by ocean, truck, rail, air, $3$PL$?$ I need to fill in the yellow boxes and the

rest will autopopulate. I am struggling to figure this out. Carrying Cost: $$0\mathrm{.}035$ Volume Capabilities Carrying

Speed Speed Cost Reliability By Week... Units Needed Ocean Truck Rail Air $3$PL B$.$ I Purch Usage E$.$ I. Cost Mode

Avg. Lead Time$*$ Avg. LT Weeks Cost$/$Unit Capacity$*$k On time $\%1$ Ocean $84120\mathrm{.}050180,00080\%2....$

Truck $710\mathrm{.}10040,00096\%3..$ Rail $2840\mathrm{.}070100,00085\%420,000-20,000(20,000)(700)$ Air

$100\mathrm{.}5005,00099\%520,000*20,000(40,000)3PL$

$710\mathrm{.}13540,00097\%620,000--20,000(60,000)720,000-20,000(80,000)820,000-20,000(100,000)(3,500)$

Note: Q$42$ must equal $580,000$ when complete $1120,000-$cdots$20,000(160,000)$ Note: Students can utilize gray

area to work through optimal cost exercise

$1220,000=20,000(180,000)(6,300)1320,000-20,000(200,000)1420,000-20,000(220,000)1520,000=26$

$ $-$ $ $-$ $ $-$ $ $-$ $ $-$ $ $84,000$