Consider the transportation problem having the following data: c) write the algebraic formulation of this problem. Unit Cost (S)Destination:123SupplySource642121033662Demand42a. Draw the network representation of this problem.k Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimalsolution.3.

Find the Given details below: Given details: Destination Source 1 2 3 Supply 1 9 6 8 4…

Destination: Source 1 2 3 Demand 1 9 7 6 4 Unit Cost (S) 2 12 7 2 3 8 10 6 3 Supply 432 a. Draw the network representation of this problem. & Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimal solution.

Destination: Source 1 2 3 Demand 1 9 7 6 4 Unit Cost (S) 2 12 7 2 3 8 10 6 3 Supply 432 a. Draw the network representation of this problem. & Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimal solution.

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 without the use of excel.
At the end of a cycle of schedules, a trucking firm has a surplus of one vehicle each in cities A, B, C, D, E, and F and a deficit of one vehicle each in cities 1, 2, 3, 4, 5, and 6. The distances between cities with a surplus and the cities with a deficit are shown below. Find an assignment of surplus vehicles to deficit cities that will result in a minimum total distance. What is the total distance? -Solve the following transportation models using Excel Solver. -Find the optimal solution for the transportation problem having the cost and requirement tablebelow.
7. The BD restaurant chain purchases materials from four different food suppliers. The company wants to construct a new central distribution center to process and package the materials before shipping them to their various restaurants. The suppliers transport items in 40-foot truck trailers, each with a capacity of 38,000 lbs. The locations of the four suppliers and the annual number of trailer loads that will be transported to the distribution center are shown in the following table (distance in miles). Using the center-of-gravity method, determine a possible location for the distribution center. A B с D X Y 200 200 100 500 250 600 500 300 Load 75 105 135 60 BD wants to evaluate three different sites it has identified for its new distribution center relative to the four suppliers identified. The coordinates of the three sites under consideration are as follows: Site 1: x1 = 360, y₁ = 180 Site 2: X2 = 420, y2 = 450 Site 3: X3 = 250, y3 = 400
Task 1: An oil refining company ships the following gasoline volumes from its refining plant in Long beach to its major distributors: Coordinates (x, y) 400, 150 450, 350 350, 400 25, 450 Distributor Gallons (in millions) Anaheim 150 LaHabra 350 Glendale 250 Thousand Oaks 450 The location coordinates of the refining plant in Long Beach are: (325, 75). Under a new proposed distribution setting, the company wants to setup an intermediate holding facility, such that gasoline will first get transported to this holding facility, and then, from there, to the distributors. What will be the ideal location (coordinates) for the intermediate holding facility? (Round to 2 decimal places.)
Davis Inc. produces three product lines in its manufacturing facility in St. John's, NL: Product Line (1), Product Line (2), Product Line (3). Davis is considering dropping Product Line (2) because it has been unprofitable for the past two years. Which of the following items is (are) irrelevant to Davis' decision to drop/keep Product Line (2)? O a) Total cost of rent on the manufacturing facility. O b) Customer demand for Product Line (2). Oc) Savings in direct materials cost associated with Product Line (2). O d) All of the above items are considered relevant in the decision.
Rauschenberg Manufacturing is investigating which locations would best position its new plant relative to three important customers (located in cities A, B, and C). As shown in the table below, all three customers require multiple daily deliveries. Management limited the search for this plant to those three locations and compiled the following information: Location A B C Coordinates (miles) (200,100) (400,200) (300,100) a. Which of these three locations yields the smallest load-distance score, based on Euclidean distances? Location one decimal place.) b. Which of these locations is best, based on rectilinear distances? yields the smallest load-distance score of Location whole number.) c. What are the coordinates of the center of gravity? is the best, yielding a load-distance score of * The center of gravity is x = decimal place.) * Deliveries per day miles, y = 5 7 9 (Enter your response rounded to (Enter your response as a miles. (Enter your responses rounded to one
Consider the transporatio table below: (a) Use the Northwest-Corner Method, the Least-Cost Method and the VAM to get the starting feasible solution. (b) Find the optimal solution by considering the smalles value of the oibjective function computed in (a).
Sarah has a startup business that makes two distinct bird feeders that she has designed. Sarah is planning on operating a small factory to build the bird feeders. She is looking at two possible locations, A and B. If she chooses location A, the lease on the building will be higher than location B, thus leading to higher fixed costs than what she would have with location B. However, if she makes more than 20,000 units, both locations will likely have to be expanded, both the physical buildings and the manufacturing equipment. Variable costs to produce each unit will vary by location as well as by product. For example, the first design will have variable costs of $10 and $15 in locations A and B respectively, while the second bird feeder design will have variable costs of $20 and $25 respectively depending on location. However, she thinks that variable costs will decrease if she sells more than 5,000 units, as she will receive discounts from her suppliers at that point. She is unsure of…
Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity Tons Available Volume per Ton (cu.ft.) Profit per Ton ($)1 4,000 40 702 3,000 25 503 2,000 60 604 1,000 50 80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions: Cargo Hold Weight Capacity (tons) Volume Capacity (cu.ft.)Forward 3,000 100,000Center 5,000 150,000Rear 2,000 120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…
Suppose as many as 300 cars per hour can travelbetween any two of the cities 1, 2, 3, and 4. Set up amaximum-flow problem that can be used to determine howmany cars can be sent in the next two hours from city 1 tocity 4. (Hint: Have portions of the network represent t 0,t 1, and t 2.)
Give one example of linear bus bay in Chicago
(2) Find an optimal solution for the following transportation problem. Town To Valley FROM Madison (M) Yonkers (1) Pittsburgh (P) Demand FROM Madison (M) Yonkers Pittsburgh FROM 3.50 Madison (M) Yonkers FROM $8 350 Madison (M) Yonkers (1) Pittsburgh $5 SIS 350 Valley (5) $8 $5 $15 Using the Stepping-Stone method to find an optimal plan. Tol Valley Town Junction (7) $8 Pittsburgh Demand 350 Part (a) Find the new TC= $5 $15 50 350 The above feasible plan is obtained by applying the Northwest Corner Rule (e.g., 300 from M to V, etc.), and its total cost = 350($8) +50($10)+150($12) +250($4)+200($11) +250($14) = $11.800, 150 $8 200 $5 The improvement indices below are determined as follows: Supply row M first, then sows Y and P) MJ: 9-4+12-10-2 400 MB: 6-11+12-10=-3 rv: 5-12+10-8-5 600 PP: 15-14+11-12-10-8-2 PT: 6-14+11-12- PA 11-14+11-4-4 Demand 350 200 the "most negative index" We focus on cell PT (index=-9). Its closed path is: PT to PB to YB to YT, and back to PT. To increase the…