I have management science question, please help me to do it on excel, kindly upload screenshots of each code and solver with explanation stepwise. so that i could solve it by myself easily. Thanks In advance.
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? The FAA has granted a license to a new airline, Omni air, and awarded it several routes between Los Angeles and Chicago. The flights per day for each route are shown in the following network: Kansas City Chicago Salt Lake City 6 8 8 6 2 7 5 4 10 7 7 1 8 5 Denver 7 Los Angeles 5 St. Louis 4 6 5 3 Dallas Phoenix Determine the maximum number of flights the airline can schedule per day from Los Angeles to Chicago and indicate the number of flights along each route
