The diagram illustrates a transportation network with nodes and arrows. The nodes represent cities: Jefferson City, Omaha, Des Moines, Kansas City, and St. Louis. The arrows between nodes indicate possible routes for transportation with associated costs per unit.**Details:**- **Supplies and Demands:** - Jefferson City has a supply of 30 units. - Omaha has a supply of 20 units. - Des Moines has a demand of 20 units. - Kansas City has a demand of 20 units. - St. Louis has a demand of 10 units.- **Transportation Costs:** - Jefferson City to Des Moines: $14/unit - Jefferson City to Kansas City: $16/unit - Jefferson City to St. Louis: $2/unit - Omaha to Des Moines: $10/unit - Omaha to Kansas City: $8/unit - Omaha to St. Louis: $5/unit**Optimal Solution Table:**| | Des Moines | Kansas City | St. Louis | Supply ||----------------|------------|-------------|-----------|--------|| Jefferson City | 20 | 0 | 10 | 30 || Omaha | 0 | 20 | 0 | 20 |**Demand:**| | Des Moines | Kansas City | St. Louis ||-------|------------|-------------|-----------|| Total | 20 | 20 | 10 |- **Total Cost:** $550.Students are encouraged to find an alternative optimal solution to minimize the cost under the given constraints. If necessary, answers should be rounded to the nearest whole number. If there's no cost, enter "0".Another table is provided for entering alternative solutions:| | Des Moines | Kansas City | St. Louis ||----------------|------------|-------------|-----------|| Jefferson City | | | || Omaha | | | |- To calculate the total cost for any alternative solution, fill in the table appropriately and compute the resulting total based on the transportation costs.

Linear programming, often known as linear optimization, is a method for obtaining the best result…

Answered: Des Moines 20 14 Jefferson 30 City 16…

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

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
Yu Amy Xia bas developed a specialized airtightvacuum bag to extend the freshness of seafood shipped to restaurants.She has put together the following demand cost data: You decides that the initial inventory of 250 units will incur the$0.20/unit cost from each prior quarter (unlike the situation inmost other companies, where a 0 unit cost is assigned).a) Find the optimal pla n using the transportation method.b) What is the cost of the plan?c) Does any regula r time capacity go unused? If so, how much in which periods?b) What is the extent of backordering in units and dollars?
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
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
Consider the transportation problem having the following parameter table: Source Demand 12 2 Destination 1 8 a6 6 3 2 5 4 3 Supply 4 2 (a) Use the transportation simplex method to solve the above problem
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