Question: In the Lec 6 Transportation Problem example, assuming the cost structure remains the same, but the supplies and demands have changed to the following: Plant

In the Lec 6 Transportation Problem example,

In the Lec 6 Transportation Problem example, assuming the cost structure remains the same, but the supplies and demands have changed to the following: Plant Production Warehouse Requirement Sunnyvale Dublin Bangkok 60 145 125 Amarillo Teaneck Chicago Sioux Falls 100 84 77 69 (1) Use the greedy heuristic to solve this problem. Calculate the total cost. (2) Use the EXCEL Solver to solve this problem. Calculate the total cost. (provide a screenshot of your EXCEL results) (3) Assuming that the following routes are eliminated: Sunnyvale to Teaneck, Dublin to Chicago, and Bangkok to Amarillo. Solve again using your EXCEL Solver. What is the percentage increase in total shipping costs at the optimal solution due to the elimination of these routes? (provide a screenshot of your EXCEL results) (4) Assume the production in Sunnyvale has been reduced from 60 to 40. For this unbalanced problem, write out the seven constraints for linear programming. In the Lec 6 Transportation Problem example, assuming the cost structure remains the same, but the supplies and demands have changed to the following: Plant Production Warehouse Requirement Sunnyvale Dublin Bangkok 60 145 125 Amarillo Teaneck Chicago Sioux Falls 100 84 77 69 (1) Use the greedy heuristic to solve this problem. Calculate the total cost. (2) Use the EXCEL Solver to solve this problem. Calculate the total cost. (provide a screenshot of your EXCEL results) (3) Assuming that the following routes are eliminated: Sunnyvale to Teaneck, Dublin to Chicago, and Bangkok to Amarillo. Solve again using your EXCEL Solver. What is the percentage increase in total shipping costs at the optimal solution due to the elimination of these routes? (provide a screenshot of your EXCEL results) (4) Assume the production in Sunnyvale has been reduced from 60 to 40. For this unbalanced problem, write out the seven constraints for linear programming

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!

SIE462/562 HW 6 In the Lec 6 Transportation Problem example, assuming the cost structure remains the same, but the supplies and demands have changed to the following: Plant Production Warehouse...

The Pear Company assumes the following supplies and demands: Plant Production Warehouse Requirement Sunnyvale 60 Amarillo 100 Dublin 145 Teaneck 84 Bangkok 125 Chicago 77 Sioux Falls 69 Use Excel's...

If for some reason, the plant in Atlanta can only supply 300, what is the optimal solution? (formulate this problem in two ways) If the plan in Atlanta can only supply 300, and the demand in New...

need problem 43 and 45 pls and thank you 43. Consider Example 7.7 of the Pear Company assuming the following supplies and demands. Use Excel's Solver (or other linear programming code) to determine...

Supply Chain Management Introduction Outline What is supply chain management? Significance of supply chain management. Push vs. Pull processes utdallas.edu/~metin 1 A Generic Supply Chain Sources:...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

In the Intro to Purchasing and Supply Chain reading, Page 6, Figure 1-2, there is a comparison of Traditional Purchasing versus the Current Outlook. Provide three reasons why the Current Outlook is...

What other benefits will accrue with smart grids?

Linda is taking a five-course load her first semester: English, math, French, psychology, and history. In how many different ways can she earn three As and two Bs? Enumerate the entire set of...

Mom died on June 1 . 2 0 2 4 . At the time of her death, Mom's estate comisted of $ 1 5 M of stocks, 5 4 M of real estate, and $ 3 M of other assets. Mom's will left all her property to her kids. The...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...