Homework11. The distribution system for the Herman Company consists of three plants, two ware-houses, and four customers. Plant capacities and shipping costs per unit (in S) from eachplant to each warehouse are as follows:c.PlantWarehouseDemand-25131485Customer demand and shipping costs per unit (in S) from each warehouse to each cus-tomer are as follows:a. Develop a network representation of this problem.b.Formulate a linear programming model of the problem.Solve the linear program to determine the optimal shipping plan.1Warehouse3300624CustomerCapacity4506003803003873004400

Answered: Image /qna-images/answer/b89f09bc-1f8e-42af-9082-3daed8cbb14c.jpg

Answered: 11. The distribution system for the…

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

4. Consider the following to illustrate a transshipment (Min) problem. Supply (1,000 tons) Fr\To F G H Fr\To D E D $23 $15 $29 A $15 $20 75 E $20 $17 $24 B $18 $16 108 Demand 93 83 123 C $22 $24 86 (1,000 tons) B. Identify a starting solution using Northwest Corner Method. Show complete solution.
a. Goods have to be transported from sources S1, S2 and S3, to destinations D1, D2 and D3. The transportation cost per unit capacities of the sources and requirements of destinations are given in the following table: Destination Source S1 S2 S4 D1 8 15 3 150 D2 5 10 9 Demand 80 50 Determine the transportation schedule so that cost is minimized. D3 6 12 10 Supply 120 80 80
2
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are Day M T W Th F S Su Requirements 7 3 5 5 6 2 2 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) Part 2 The minimum number of workers is _________workers. (Enter your response as a…
Problem 3 A shipping company is planning on purchasing three different types of boats: A, B and C. The relevant data is summarized in the following table: Cost (million $) per unit Seating capacity Expected profit ($) per unit A 6.5 • Required seating capacity: at least 660. • At most 8 type C boats may be purchased 45 150,000 B 7.8 75 218,000 The objective is to minimize the expansion costs under the following restrictions: • Required returns: $1,800,000. 60 175,000 с 9.2 • At most 12 boats in all. a. Formulate the linear program that represents this problem and solve it. For the purposes of this exercise you can assume that is possible to buy fractions of a boat, no need to make the variables integer. b. What is the optimal solution (purchase plan)? How many of each container should be purchased, and what should the resultant cost be? c. Suppose that the requirement of at least 660 for seating capacity is reduced to 650. Without resolving the problem, can you determine how this would…
A beer distributor needs to plan how to make deliveries from its warehouse (node 1) to a supermarket (node 7), as shown in the network below. s.t. Node 1 Flows Node 2 Flows Node 3 Flows Node 4 Flows Node 5 Flows Node 6 Flows 1 Node 7 Flows 3 Develop the LP formulation for finding the shortest route from the warehouse to the supermarket. (Let x₁, represent the flow from node i to node j.) +9x56 + Min 3x12 + 3x15 + 11x16 + 6x23 + 5x34 + 3x46 +4x47 3 Xij > 0 for all i and j 11 *12+*15 +*16 *12*23 *23 + x34 x47+x46 = 1 6 X *16*56 +46-67 *47 +x67 9 = 0 5 X 4 3 3x67 X
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
1. Ethan Steel, Inc. has two factories that manufacture steel components for two different rail projects located at two different sites. They would like to determine the number of steel components they need to transport from each factory to each project site. The demand for the steel components for the two projects, Project A, and Project B are 3000, and 4000, respectively. The production and shipping details are as below:Production details:Factory 12Maximum capacity 20005000Shipping details (with per-unit shipping cost in dollars):Project Factory A B 178265Develop a linear programming optimization model to determine the distribution plan (from factories to projects) that minimizes the total transportation cost. (Do NOT solve the model.)
h of the following entities may legally sell insurance in the state of Florid Religious institutions required with the state Risk management consultants Law firms specializing in insurance 1. Career agency systems anscribed Image Text: Which of the following entities may legally sell insurance in the state of Florida a. Religious institutions required with the state b. isk management consultants c. Law firms specializing in insurance d. Career agency systems ex L @ W
A fruit juice manufacturer has recently begun negotiations with brokers in the areas where it intends to distribute its products. Before finalizing the agreements, however, the manager wants to determine shipping routes and costs. The firm has three plants with the capacities as shown below: Estimate demands in each of the warehouse localities are: PLANT CAPACITY (PIECES PER WEEK) WAREHOUSE 1 2 3 400 800 600 A B C D DEMAND (PIECES PER WEEK) 900 200 400 300 The estimated ship cost per box for the various routes are: ΤΟ FROM A B C D 1 5 7 9 12 2 10 7 2 3 3 8 9 6 4 Row/Column Opportunity Cost Demand Row/Column Cell Total Cost Opportunity Cost Cost of the above Test of unallocated Cells allocation Supply Amount char
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 ?
Consider an assignment issue that has the following cost table. a. Draw a network representation of this assignment problem.b. Formulate this problem as a transport problem by drawing up the appropriate parameter table.c. Determine the optimal assignment solution using the Hungarian method!d. Use Excel Solver to get the optimal solution.

SEE MORE QUESTIONS

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