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$**$ 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)3$PL $710\mathrm{.}13540,00097\%620,000--20,000(60,000)720,000--20,000(80,000)820,000--20,000(100,000)(3,500)920,000--20,000(120,000)1020,000--20,000(140,000)$ Note: Q$42$ must equal $580,000$ when complete $1120,000--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--20,000(240,000)1620,000--20,000(260,000)(9,100)1720,000--20,000(280,000)1820,000--20,000(300,000)1920,000--20,000(320,000)2020,000--20,000(340,000)(11,900)2120,000--20,000(360,000)2220,000--20,000(380,000)2320,000--20,000(400,000)2420,000--20,000(420,000)(14,700)2520,000--20,000(440,000)2620,000--20,000(460,000)2720,000--20,000(480,000)2820,000--20,000(500,000)(17,500)2920,000--20,000(520,000)3020,000--20,000(540,000)3120,000--20,000(560,000)3220,000--20,000(580,000)(20,300)------$ $$-$ $$-$ $$-$ $$-$ $$-$ $$(84,000)$ Total Cost $$(84,000)$ Total Cost$/$Unit #DIV$/0!$