Question: 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

SIE462/562 HW 6 In the Lec 6 Transportation Problem example, assuming the

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 Requirement Sunnyvale 60 Amarillo 100 Dublin 145 Teaneck 84 Bangkok 125 Chicago Sioux Falls 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 Accounting Questions!

question. 1) If an economy produced twenty pizzas at $10 each and fifteen liters of cola at $5 each, the total value of these goods and services would be: 1) A) $75. B) $200. C) $2,750. D) $275.

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...

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:...

Controller, Judy Koch, in a recent speech said, "I rarely see a real variable cost or a truly fixed cost." What did she mean? Include in your response an explanation of the difference in behavior of...

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...

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...

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....

1. - Expain the motivations of Unilever in acquiring Inmarko. - Identify the risks Unilever faces in using acquisition as a mode for growth, as opposed to other modes discussed in the chapter. 2....

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...

1. - Expain the motivations of Unilever in acquiring Inmarko. - Identify the risks Unilever faces in using acquisition as a mode for growth, as opposed to other modes discussed in the chapter. 2....

In the following acid-base reactions, 1. Determine which species are acting as electrophiles (acids) and which are acting as nucleophiles (bases). 2. Use the curved-arrow formalism to show the...

Locate the position of the collector plates for singly ionized ions with mass numbers 16, 17, and 18 that have been accelerated through a potential differ- ence of 2000 volts, after which they enter...

8. If a superconducting particle collider is built, then the data yielded will benefi t scientists of all nations and it deserves international funding. Either a superconducting particle collider...

Elves are a mixed bunchsome are inherently good (born on the North Pole) and some are evil (born on the South Pole). The archenemy of Santa Claus, Anti Claus, lives in the South Pole and trains a...

Invested cash in business $10,000 Borrow $5000 money from bank. Purchase desk and chair for hairdresser shop for $300 from office work . Provide Party makeup for $130 to customers Paid rent $600 for...

You have an opportunity to buy the Newton Falls Paper mill for $15 million. Currently the mill sells standard paper reams and revenues total $5 million per year with fixed costs of $2 million and...

Assume standard atmospheric conditions The International Civil Aviation Organization (ICAO); (an ICAO atmosphere). 1). What is the maximum lift possible that can be produced by this aircraft at 300...

National Company issued a 7.5% bond, dated January 1, 2020 with a face amount of $600,000 on January 1, 2020. The bonds mature on December 31, 2026. The market yield for bonds of similar risk and...

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

I think there's little doubt that someone else is involved. Jason is not in a position to force Kelly's firing. In that case, he should have not spoken with Jason. He should have gone as high in the...

If she thinks explanation 2c is true, what can she do? a. Tell the IT person he doesn't know what he's doing? b. Ask the IT person to contact someone else in IT and find out if there are ever...

If Dee thinks explanation 2b is true, what can she do? a. Call the person lazy and say she's going to report him to her manager? b. Get permission to have Don install and support MySQL? c. If Dee...