Question: please do not use previous answers for this question. use Excel and provide the formula. Thank you in advance! 3. Oranges are grown, picked and

please do not use previous answers for this question. use Excel and provide the formula. Thank you in advance!

please do not use previous answers for this

3. Oranges are grown, picked and then stored in warehouses in Tampa and Fresno. Theses warehouses supply oranges to markets in New York, Chicago, and Boston. The following table shows the shipping costs per truckload (in $100s), supply, and demand. Because of an agreement between distributors, shipments are prohibited from Tampa to New York: From Tampa Fresno Demand ETTE New York Chicago Boston Supply 12 16 14 350 16 12 20 500 250 210 180 The objective is to minimize the total shipping cost. (a) Formulate a lincar programming model for this problem. (b) Find the optimal objective value and the optimal solution point in (a) by using the computer. (c) What is the new optimal solution if the prohibition of the shipment from Tampa to New York were removed from the original model formulation in (a)? (d) Formulate a lincar programming model for the original problem with the amount of orange supply from Fresno as 200. (e) Find the optimal objective value and the optimal solution point in (d) by using the computer Solution

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

please do not use previous answers for this question. use Excel and provide the formula. Thank you in advance! 4. Walsh's Fruit Company contracts with growers in Ohio, Pennsylvania, and New York to...

please do not use previous answers for this question. use Excel and provide the formula. Thank you in advance! 2. Northwoods Backpackers is a retail catalog store in Vermont that specializes in...

Hello Experts- I need help with the following question please!!. All previous answers were incorrect or answered incomplete. Please provide a detailed, clear and step by step answer in excel and show...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

I have provided all of the information that was given to me. there is no excel sheet provided, as the question requires me to create an excel model. please help me and let me know where I can help or...

Part one :Identify the following( Just state them) Independent and dependent variables Population of interest Study sample Data-gathering instruments Brief Critical Analysis Summary Major findings...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

I need help with the Final Project presentation. (The last part) I attached my previous presentations to it as well Milestones 1, 2, 3 and the interview research. Please help, and please cite all...

Nicoles Yogurt Shoppe, Inc. has two liabilities on January 1, 2106 First, she owes $20,000 on a vehicle loan with payments of $1,000 per month (no interest for this problem). Second, she owes...

Professor Smith conducted a class exercise in which students ran a computer program to generate random samples from a population that had a mean of 50 d a standard deviation of 9 mm. Each of Smith's...

Which of the following statements is a defining characteristic of the weak - form efficient market hypothesis? Investors will always behave rationally. Only publicly available information influences...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...