20OmahaJeffersonCityJefferson CityDemandOmahaOmahaJefferson City16Total Cost:10SuppliesDemandsThe supplies, demands, and transportation costs per unit are shown on the network. The optimal (cost minimizing) distribution plan is given below.101020DesMoines0KansasCity2020LouisDes Moines Kansas City St.Louis Supply1020200201010Total Cost: $490.Find an alternative optimal solution for the above problem.If required, round your answer to nearest whole number and if your answer is zero enter "0".Des Moines Kansas City St.Louis30

Effective distribution planning the organization to minimize transportation costs, warehousing…

Answered: 20 30 Jefferson City Omaha Jefferson…

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

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.
Formulate a linear program using LP Model Formulation. Miguel hauls mangoes between Manila mango plantation and packing plants in Clark. Miguel’s schedule this week calls for 500 boxes with locations and costs as follows.
A company has three existing warehouses to which it will ship furniture from a new factory whose location must be decided. The factory will receive raw materials from its wood supplier and fabric supplier. The annual number of shipments, shipment costs and the location of the suppliers and warehouses are shown below Existing facilities Annual L to or from fact cost Coordinate location Wood supplier 120 10 (100, 400) Fabric supplier 200 10 (800,700) Ware h 1 61 10 (300, 600) Ware h 2 40 10 (200, 100) Ware h 3 70 10 (600, 200) Using the median load answer the following questions –Where the factory should be located to minimize annual transportation cost –What will be the minimum annual transportation cost
JN Company manufactures two products that use material 1, material 2, and material 3. Consider the following table: Resources needed Material 1 Material 2 Material 3 Price per Unit in Pesos Requirement per Unit Product 1 2 2 0 150 Product 2 3 1 4 200 a. Write the linear programming model for this problem. b. Present the optimal solution and interpret the result. Maximum Availability (units) 1200 1000 800 c. Determine the status of each resource. d. Determine the dual prices for the materials 1, 2 and 3. Explain each value. e. Determine the feasibility ranges for the dual prices obtained in (d). f. If the available number of material 1 is increased to 1300 units, find the new optimum solution. g. Find the range of optimality for (i.) product 1 and (ii.) product 2 for which the optimal. solution remains valid.
1 3 Supply: 4 1 60 40 28 10 120 2 50 30 30 20 150 3. 43 20 20 10 160 Demand: 100 100 100 130 The transportation table of a company that sends products is given below. According to the least cost method what is the value for the first cell to be assigned ?
: x v fx C DE в F G H K M Consider the linear distribution and the from-to diagram shown in the figure. Assuming that the goal is to minimize the total distance traveled, determine the final distribution recommended by CRAFT using the peer-to-peer trading method. 30 m 30 m from A A B A 2 6 B 3 A В 80 m 20 m
Destination Destination Destination Supply Source 1 75 8 320 Source 2 6 160 13120 4. Source 3 6.5 Demand 160 200 240 Based on the transportation table shown, total transportation cost using North- West Corner Method will be: a. 3040 Ob. 4100 O c. 2640 O d. 1920
V3 Supply 1 10 U₁ 4 20 112 4 2 30 U3 Demand 15. 20 25 Find a basic feasible solution, by using - Northwest corner method. Check if the initial solution is optimal if not find it, by using method of A) B) multipliers 153 23212 V1
J 2 PLEASE SOLVE USING EXCEL SOLVER
Dexter Company has been approached by a new customer with an offer to purchase 1,400 units of Dexter's product at a price of P3 each. The new customer is graphically separated from Dexter's other customers, and there would be no effect on existing sales. Dexter normally produces 10,000 units but only plans to produce and sell 8,000 in the coming year. The normal sales price is P5 per unit. Unit cost information is as follows: Direct materials PO.75 Direct labor 0.80 Variable overhead 0.40 Fixed Overhead 2.00 Total 3.95 If Dexter accepts the order, no fixed manufacturing activities will be affected because there is sufficient excess capacity. However, the distribution center at the warehouse is operating at full capacity and would need to add capacity costing P1,000 for every 5,000 units to be packed and shipped. BY HOW MUCH WILL PROFIT INCREASE/ DECREASE IF THE ORDER IS ACCEPTED?
Please solve this Optimization problem using VAM method manually
An auto compant 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 Using the northwest-corner method, determine the initial allocated quantity for eachshipping route as well as the overall cost.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS