How do I calculate volume capabilities by ocean, truck, rail, air, 3PL? I need to fill in the yellow boxes and the rest will autopopulate. I am struggling to figure this out. Carrying Cost: $0.035 Volume Capabilities Carrying Speed Speed Cost Reliability By Week... Units Needed Ocean Truck Rail Air 3PL B.I Purch Usage E.I. Cost Mode Avg. Lead Time* Avg. LT Weeks Cost/Unit Capacity** On time % 1 Ocean 84 12 0.050 180,000 80% 2 - - - - Truck 7 1 0.100 40,000 96% 3 - - - - Rail 28 4 0.070 100,000 85% 4 20,000 - - 20,000 (20,000) (700) Air 1 0 0.500 5,000 99% 5 20,000 - - 20,000 (40,000) 3PL 7 1 0.135 40,000 97% 6 20,000 - - 20,000 (60,000) 7 20,000 - - 20,000 (80,000) 8 20,000 - - 20,000 (100,000) (3,500) 9 20,000 - - 20,000 (120,000) 10 20,000 - - 20,000 (140,000) Note: Q42 must equal 580,000 when complete 11 20,000 - - 20,000 (160,000) Note: Students can utilize gray area to work through optimal cost exercise 12 20,000 - - 20,000 (180,000) (6,300) 13 20,000 - - 20,000 (200,000) 14 20,000 - - 20,000 (220,000) 15 20,000 - - 20,000 (240,000) 16 20,000 - - 20,000 (260,000) (9,100) 17 20,000 - - 20,000 (280,000) 18 20,000 - - 20,000 (300,000) 19 20,000 - - 20,000 (320,000) 20 20,000 - - 20,000 (340,000) (11,900) 21 20,000 - - 20,000 (360,000) 22 20,000 - - 20,000 (380,000) 23 20,000 - - 20,000 (400,000) 24 20,000 - - 20,000 (420,000) (14,700) 25 20,000 - - 20,000 (440,000) 26 20,000 - - 20,000 (460,000) 27 20,000 - - 20,000 (480,000) 28 20,000 - - 20,000 (500,000) (17,500) 29 20,000 - - 20,000 (520,000) 30 20,000 - - 20,000 (540,000) 31 20,000 - - 20,000 (560,000) 32 20,000 - - 20,000 (580,000) (20,300) - - - - - - $- $- $- $- $- $(84,000) Total Cost $(84,000) Total Cost/Unit #DIV/0! Carrying Cost: $0.035 Volume Capabilities Carrying By Units Week...Needed Speed Speed Cost Avg. Avg. Lead LT Cost/Unit Time* Weeks 84 12 0.050 7 1 0.100 28 4 0.070 1 0 0.500 7 1 0.135 Reliability ueaoo Rail Air 3PL B.I PurchUsage E.I. Cost Mode Capacity** On time % 1 2 3 4 20,000 520,000 620,000 720,000 20,000 9 20,000 1020,000 1120,000 12 20,000 13 20,000 1420,000 1520,000 1620,000 1720,000 1820,000 1920,000 2020,000 2120,000 22 20,000 2320,000 24 20,000 25 20,000 2620,000 27 20,000 2820,000 29 20,000 3020,000 3120,000 3220,000 Ocean 180,000 40,000 100,000 5,000 40,000 80% 96% 85% %66 97% Rail Air 3PL 20,000 (20,000) 20,000 {40,000) 20,000 (60,000) 20,000 (80,000) 20,000 (100,000) 20,000 (120,000) 20,000 (140,000) 20,000 (160,000) 20,000 (180,000) 20,000 (200,000) 20,000 (220,000) 20,000 (240,000) 20,000 (260,000) 20,000 (280,000) 20,000 (300,000) 20,000 (320,000) 20,000 (340,000) 20,000 (360,000) 20,000 (380,000) 20,000 (400,000) 20,000 (420,000) 20,000 (440,000) 20,000 (460,000) 20,000 (480,000) 20,000 (500,000) 20,000 (520,000) 20,000 (540,000) 20,000 (560,000) 20,000 (580,000) (700) (3,500) Note: Q42 must equal 580,000 when complete Note: Students can utilize gray area to work through optimal cost exercise (6,300) (9,100) (11,900) {14,700} {17,500) (20,300) S - - S S S s {84,000) Total Cost Total Cost/Unit S {84,000 iO/AIC#