Question: I need this solution on EXCEL. Thank you. 3-1. This transportation model, which deals with finding a least cost shipping schedule, comes from Dantzig's Linear

I need this solution on EXCEL. Thank you. 3-1.

I need this solution on EXCEL. Thank you.

3-1. This transportation model, which deals with finding a least cost shipping schedule, comes from Dantzig's Linear Programming and Extensions. A company has plants in Seattle and San Diego, with capacities 350 and 600 cases per week respectively. It has customers in New York, Chicago, and Topeka, which order 325, 300, and 275 cases per week. The distances involved are: New York Chicago Topeka Seattle 2500 1700 1800 San Diego 2500 1800 1400 The shipping cost is $90 per case per thousand miles. Formulate this model in AMPL and solve it to determine the minimum cost and the amounts to be shipped

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!

On Halloween night a 6-foot tall 12-year-old boy decided to dress up as a bank robber. His costume consisted of a ski mask and a toy gun. He went to numerous homes, and when the homeowner answered...

Briefly discuss the cost-volume-profit analysis model and how it is used. Use the attached PDF. APA Citation. 300 words. REVISED PAGES 3 Chapter Three 1 Fundamentals of Cost-Volume-Prot Analysis...

In the rest of this chapter, we lead the reader through the formulation of several more complicated linear programming models. The most important step in formulating an LP model is the proper choice...

MBA 701 Course Project 4 (75 points) Linear Programming and Applications 60 points. Question 1 (Case Study) : Supply Chain Design at Ryan Electronics Co. Ryan is an electronics company whose supply...

Hi I am needing assistance with a case study that requires an excel solution for Data Analysis Identify the linear programming problem apparent in the case, that will help the company achieve their...

Planning Demand and Supply in a Supply Chain Capacity Planning and Assignment 1 utdallas.edu/~metin Outline Capacity Planning Product-to-plant Assignment utdallas.edu/~metin 2 Deterministic Capacity...

Use the follow case as a basis for your case study assignment due Trans Pacific Oil Company (TPO) The Trans Pacific Oil Company is an international producer, refiner, transporter, and distributor of...

Identify the linear programming problem apparent in the case, that will help the company achieve their goals. Excel file with model and optimal solution (optimal purchasing, refining, shipping...

e eBook Collection Media & Culture Bedford/St. Martin's - ISBN 9781457628313 Bedford/St. Martin's - ISBN 9781457628313 CHAPTER 1 MASS COMMUNICATION___3 6 Culture and the Evolution of Mass...

Could I get the cost of capital calculation (WACC) broken out in excel for Amazon based on FY2015 financials? \fTo our shareowners: This year, Amazon became the fastest company ever to reach $100...

ITM 309: Business Information Technology and Systems Spring 2016 Watson and the new era of cognitive systems Jerry Haan IBM Cloud Ecosystem Development January 27, 2016 2013 International Business...

How does an increase in the value of the pound sterling affect American businesses?

Scott Co. acquired 70% of Gregg Co. for $525,000 on December 31, 2019, when Gregg's book value was $580,000. Gregg's shares were not actively traded. At the acquisition date, Gregg had equipment...

Reflect on the effect that diversification has on the expected return and risk of the companies chosen. Analyse how these companies use diversification to mitigate risks in their portfolios and...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...