Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to solve this question on excel, kindly explain step wise, and do share screenshots of codes and solver. National Foods Company has five

I need to solve this question on excel, kindly explain step wise, and do share screenshots of codes and solver.

image text in transcribed
National Foods Company has five plants where it processes and packages fruits and vegetables. It has suppliers in six cities in California, Texas, Alabama, and Florida. The company owns and operates its own trucking system for transporting fruits and vegetables from its sup pliers to its plants. However, it is now considering outsourcing all its shipping to outside trucking firms and getting rid of its own trucks. It currently spends $245,000 per month to operate its own trucking system. It has determined monthly shipping costs (in thousands of dollars per ton) of using outside shippers from each of its suppliers to each of its plants, as shown in the following table: Processing Plants ($1,000slton) Supply Suppliers Denver St. Paul Louisville Akron Topeka (tons) Sacramento $3.7 $4.6 $4.9 $5.5 $4.3 18 Bakerseld 3.4 5.1 4.4 5.9 5.2 15 San Antonio 3 .3 4.1 3.7 2.9 2.6 10 Montgomery 1 .9 4.2 2.7 5.4 3.9 12 Jacksonville 6. l 5.1 3.8 2.5 4. 1 20 Ocala 6.6 4.8 3.5 3.6 4.5 15 Demand (tons) 20 15 15 15 20 90 (a) Should National Foods continue to operate its own shipping network or sell its trucks and out- source its shipping to independent trucking firms? (b) National Foods would like to know what the effect would be on the optimal solution and the commy's decision regarding its shipping if it negotiates with its suppliers at San Antonio and Montgomery to increase their capacity to 25 tons per month. What would be the effect of this negotiation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ordinary Differential Equations

Authors: William A Adkins, Mark G Davidson

1st Edition

1461436184, 9781461436188

More Books

Students also viewed these Mathematics questions