Traveler Corporation is just as concerned that its U.s. d shipments in the minimum amount of time as they are about minimizing their shipping costs. Suppose that each U.S. distributor receives one major container shipment each month. Following are summaries of the shipping times (in days) between each of the embarkation and destination points along Traveler’s overseas supply chain. These times encompass not only travel time but also processing, loading, and unloading times at each port:
https://d2vlcm61l7u1fs.cloudfront.net/media%2F5b8%2F5b8e7923-85c7-4cf5-a6dc-effde72ea8f2%2FphpGlo1cN.png
https://d2vlcm61l7u1fs.cloudfront.net/media%2F1a8%2F1a87cb70-9a44-4974-9739-00e8e130d19b%2FphpgN6dWM.png
Expert Answer
https://d2vlcm61l7u1fs.cloudfront.net/media%2F386%2F38635bc9-22a7-4d9c-af01-7b6adde0aad8%2FphpBUgtwX.png
https://d2vlcm61l7u1fs.cloudfront.net/media%2Fb78%2Fb78ef765-3f98-4641-be60-7fcfe1620430%2FphpZ4aHWY.png
Formula: N24 =SUMPRODUCT(B4:E6,I4:L6)+SUMPRODUCT(B11:D14,I11:K14)+SUMPRODUCT(B19:F21,I19:M21)