Destination:Source123Demand3243Unit Cost (S)27434333638263842522Supply52323a. Draw the network representation of this problem.b. Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimalsolution.

Answered: Destination: Source 1 2 3 Demand 1 324…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section6.5: Set-covering And Location-assignment Models

Problem 34P

See similar textbooks

Similar questions

Consider the following linear program: Max 3A + 3B S.t. 2A + 4B < 12 6A + 4B < 24 A, B > 0 Find the Optimal Solution using the graphical solution procedure If the objective function is changed to 2A + 6B, what will the optimal solution be? How many extreme points are there? What are the values of A and B at each extreme point?
Modify the warehouse location model as suggested inModeling Issue 2. Specifically, assume that the samefour customers have the same annual shipments, butnow, there are only two possible warehouse locations,each with distances to the various customers. (Thesedistances, along with other inputs, are in the fileP07_27.xlsx.) The company can build either or bothof these warehouses. The cost to build a warehouseis $50,000. (You can assume that this cost has beenannualized. That is, the company incurs a buildingcost that is equivalent to $50,000 per year.) If onlyone warehouse is built, it will ship to all customers. However, if both warehouses are built, then the com-pany must decide which warehouse will ship to each customer. There is a traveling cost of $1 per mile.a. Develop an appropriate model to minimize totalannual cost, and then use Solver to optimize it.Is this model an NLP or an IP model (or both)?b. Use SolverTable with a single input, the traveling costper mile, to see how large…
Optimal solution 4T+3C=240 2T+1C=100 →T=30, C-40 Can you please explain to me the solution and way of how he did get the exact coordinate points in the graph? I know there is a formula or way to calculate since it is hard to find out the exact point when manually plotting a graph
the Problem. The DISTRIBUTION UNLIMITED CO. will be producing the same new product at two different factories, and then the product must be shipped to two warehouses, where either factory can supply either warehouse. The distribution network available for shipping this product is shown in Fig. 3.13, where F1 and F2 are the two factories, W1 and W2 are the two warehouses, and DC is a distribution center. The amounts to be shipped from F1 and F2 are shown to their left, and the amounts to be received at W1 and W2 are shown to their right. Each arrow represents a feasible shipping lane. Thus, F1 can ship directly to W1 and has three possible routes (F1 → DC → W2, F1 → F2 → DC → W2, and F1 → W1 → W2) for shipping to W2. Factory F2 has just one route to W2 (F2 → DC → W2) and one to W1 (F2 → DC → W2 → W1). The cost per unit shipped through each shipping lane is shown next to the arrow. Also shown next to F1 → F2 and DC → W2 are the maximum amounts that can be shipped through these lanes. The…
General Ford produces cars at L.A. and Detroit and hasa warehouse in Atlanta; the company supplies cars tocustomers in Houston and Tampa. The cost of shipping a carbetween points is given in Table 60 (“—” means that ashipment is not allowed). L.A. can produce as many as1,100 cars, and Detroit can produce as many as 2,900 cars.Houston must receive 2,400 cars, and Tampa must receive1,500 cars.a Formulate a balanced transportation problem thatcan be used to minimize the shipping costs incurred inmeeting demands at Houston and Tampa.b Modify the answer to part (a) if shipments betweenL.A. and Detroit are not allowed.c Modify the answer to part (a) if shipments betweenHouston and Tampa are allowed at a cost of $5.
1. True/FalseA company wants to hire 4 vendors for the sale of 4 products, they could only sell one type of product. The following table (image) indicates what each seller charges for selling each of the products. The company wants to assign each seller a product, find all possible optimal assignments by pinpointing their optimal cost. answer the following:a) It is an allocation model T() F()b) It is not a transportation model T() F()c) The model is not balanced T() F()d) The problem has exactly 24 feasible points T() F()
Consider the followingg linear programming problem: Max 3A + 3Bst. 2A + 4B ≤ 12 6A + 4B ≤ 24 A, B ≥ 0 The point (4.0,0.0) is: a. unbounded. b. is one of the extreme points. c. the optimal solution. d. infeasible.
Solve the following linear programming problem graphically: Maximize Z=3X+5Y Subject to: 4X+4Y ≤48 C1 1X+2Y ≤20 C2 Y ≥2 C3 X, Y ≥0 Part 2 1) Using the line drawing tool, plot constraint C1 by picking two endpoints for the line. 2) Using the point drawing tool, plot the corner points which define the feasible region. The optimal solution is X= ____ and Y= _______ ( round your responses to whole numbers) Maximum Profit is $ _____ ( round your responses to whole numbers)
Consider the followingg linear programming problem: Max 3A + 3Bst. 2A + 4B ≤ 12 6A + 4B ≤ 24 A, B ≥ 0 The point (0.0,6.0) is: a. the optimal solution. b. is one of the extreme points. c. infeasible. d. unbounded.
A manufacturer produces two types of calculator; each requiring material and labour as shown below: Input Scientific Calculator Graphic Calculator Availability Labour (hrs) 4 5 200 Inspection time 2 1 80 Material (cm2) 10 12 600 PROFIT $200 $300 Write the objective function and he constraints Diagram the constraint and identify the feasible region Using the corner point method, identify the production level that meets the objective of maximum profit
3. Two poultry farms supply companies with chicken feeds. The unit costs of shipping from the farms to the companies are given in the table below. The farm's goal is to minimize the cost of meeting customers' demands. a) Generate a mathematical model for finding the least cost way of shipping chicken feeds from the farms to the companies.(b) if the demand of company number 2 increased by 3 units. By how much would the costs increase? Show your solution. (c). Solve the total cost using the solver add-in in excel. From Company 1 Company 2 Company 3 Supply Farm A 55 65 80 35 Farm B 10 15 25 50 Demand 10 10 10
For the linear program Max 2A + 3Bs.t. 1A + 2B <= 6 5A +3B <= 15 A, B >= 0 find the optimal solution using excel. What is the value of theobjective function at the optimal solution?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

Destination: Source 1 2 3 Demand 1 324 3 Unit Cost (5) 2 7 4 3 3 3 638 6 3 8 2 4 425 2 Supply S 2 3 523 a. Draw the network representation of this problem. b Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimal solution.