The starting solution using northwest-corner method is: (Note: You must enter a shipment in every cell, even if the shipment is 0.) To Los Angeles Calgary From Mexico City Detroit Ottawa Demand From Mexico City 50 Detroit 0 Ottawa Demand 0 50 $6 $17 0 □ $20 50 Los Angeles $6 50 $17 30 $20 0 80 a) The total cost of the initial solution developed using the northwest-corner method = $ 3120. The starting solution using the intuitive lowest-cost method is: $18 $13 80 $10 (Note: You must enter a shipment in every cell, even if the shipment is 0.) To Calgary $18 Panama City Supply $8 100 $13 0 $10 30 40 70 $19 $24 ☐ □ □ 70 60 Panama City Supply $8 100 $19 40 $24 60 40

The starting solution using northwest-corner method is: (Note: You must enter a shipment in every cell, even if the shipment is 0.) To Los Angeles Calgary From Mexico City Detroit Ottawa Demand From Mexico City 50 Detroit 0 Ottawa Demand 0 50 $6 $17 0 □ $20 50 Los Angeles $6 50 $17 30 $20 0 80 a) The total cost of the initial solution developed using the northwest-corner method = $ 3120. The starting solution using the intuitive lowest-cost method is: $18 $13 80 $10 (Note: You must enter a shipment in every cell, even if the shipment is 0.) To Calgary $18 Panama City Supply $8 100 $13 0 $10 30 40 70 $19 $24 ☐ □ □ 70 60 Panama City Supply $8 100 $19 40 $24 60 40

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Compute the following using excel. Use the formula given in the picture below.
Example 3: With the help of North-West Corner method, solve the following transportation problem: W1 W2 W3 W4 Supply P1 21 40 30 15 10 P2 60 25 50 55 8. P3 45 10 60 10 17 Demand 7 8 14 35
"Use the northwest corner method to find the starting solution, then determine the optimum solution by using (S.S) method for the following problem. S/D D1 D2 D3 ai S, 5 3 10 150 3 9 8 70 S3 S4 bj 11 10 7 80 13 6. 40 160 120 60 340\340
Here is the initial tableau (by the NorthWest method) of a Min transportation problem. 1 2 3 Demand 19 Dual(v) 1 15 9 S1: 11 10 14 0 S2: 0 S3: B 0 B 3 N 15 Demanders 2 8 0 9 12 188 15 9 21 5 N 0 B 0 B 13 10 8 8 20 3 0 20 -4 N -6 N 0 B 17 7 5 4 0 0 1 -14 N -8 N 0 B Supply Dual(u) 0 (188 188 188 188 Using the Loop method fill in the values of the next tableau Each 2x2 matrix is the relevant square in the tableau. 9 (For grading convenience, in bottom right corner of each box use 1 for "B" and 0 for "N") 22 188 188 188 30 -4 2
solve the following LP MODELS
Airport attract industries to be located nearby for example KLIA, Penang, Senai and Sepang. It is able to attract mostly light Industries with high value add such as electrical and electronics. For instance, some of the companies located in Bayan Lepas Intel, HP, Agilent, Braun, AMD, Renesas, Robert Bosch, NT and others. Good supporting Industries nearby create a conductive eco systems for these companies. į) Seaport such as Port Klang, Pasir Gudang, Port Tanjung Pelepas and Penang usually attract heavy industries like steel, cement and fertilizer as well as companies such as palm oil refinery, chemical plant, flour mill, sugar refinery and animal feed mill. Discuss possible why heavy and process-based industries choose to locate close to seaport.
2. By using the data below, use a transportation method to : COST in $ Assembly Plant Supply 210 Factory 2 A 8 9 400 10 6 12 8 190 Demand 120 620 60 A. Formulate this linear programming model B. If you are using VAM and NorthWest corner method, which solution is the best and how much is the best total cost ?
a company's business model was to operate through its facilities- Vancouver, Calgary, Winnipeg, Toronto(ontario), ottawa, Montreal and Halifax. Supply comes from South America, southeast Asia, and Florida. the company was shipping first to Toronto and then to each facility at a total cost of $23095.5 per week. The company is considering the possibility of opening a logistics facility in Miami. Toronto and Vancouver were already available as transshipment centres. What would be the cost savings if Miami centre was opened and what would be the optimal shipment plan?
*The Acme Company operates four factories that ship prod-ucts to five warehouses. The shipping costs, requirementscapacities, and optimal allocations are shown in Figure 13.14.What is the total cost of the optimal solution?
Milo Limited, South Africa, is a specialist manufacturer of security doors and gates. In seeking to expand its operations, it could acquire a Dutch subsidiary company, Nabby Guard, or set up a new division in its home market. The relevant figures for these two options are: Set up new division at home Rand Cost of setting up premises 25 000 000 Cost of machinery 14 000 000 Annual sales 41 500 000 Annual variable cost 13 000 000 Head office expenses o The Head office expense includes existing head office expense of R1 000 000 5 000 000 Depreciation: machinery 10% on cost annually 3 900 000 Acquisition Euro Acquire shares from existing shareholders 13 000 000 Redundancy costs 7 000 000 Annual Sales 27 000 000 Annual variable costs 15 000 000 Annual fixed costs 5 000 000 Consultants fees 6 300 500…
The Rae Mischel Company expanded its shipping capacity and the additional cost of doing this from each warehouse to terminal is highlighted in the following table. Determine theminimum cost to ship from each warehouse to terminal.
An auto company currently maintains plants in Cincinnati and Tulsa to supply two distributioncenters in Boston and Phoenix. The production and distribution costs, distribution demands aswell as facility capacities are given in the table attached. b) Using the intuitive lowest cost method, determines which of the candidate locations, inaddition to existing locations, gives the initial solution with a lower cost? c) Using the solutions obtained in b), identify which distribution center still faces a shortage. d) Suppose the company has chosen Houston as their third plant and would like to know the optimaltransportation strategy that minimizes overall costs by solving a minimum-cost flow problem.Terry has defined decision variables, represented as xij, to denote the number of items shippedfrom plant i to distribution center j wherei= C(Cincinnati), T(Tulsa), and H(Houston)j= B(Boston) and P(Phoenix)