2.The GOODBABY Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants 1,2 and 3 produce 20, 22 and 18 shipments per month, respectively. Each distribution center needs to re ceive 15 shipments per month. The distance from each plant to the respective distributing centers is given in the following table. The shipping cost for each shipment is $10 per mile. The question is: How mu ch should be shipped from each plant to each of the distribution centers to mi nimize the total shipping cost? Please construct the proper parameter table an d formulate this problem as a transportation problem model. Distance Distribution center 1 2 3 4 Plant 1 60 miles 130 miles 30 miles 75 miles Plant 2 90 miles 130 miles 60 miles 120 miles Plant 3 50 miles 90 miles 100 miles 120 miles

2.The GOODBABY Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants 1,2 and 3 produce 20, 22 and 18 shipments per month, respectively. Each distribution center needs to re ceive 15 shipments per month. The distance from each plant to the respective distributing centers is given in the following table. The shipping cost for each shipment is $10 per mile. The question is: How mu ch should be shipped from each plant to each of the distribution centers to mi nimize the total shipping cost? Please construct the proper parameter table an d formulate this problem as a transportation problem model. Distance Distribution center 1 2 3 4 Plant 1 60 miles 130 miles 30 miles 75 miles Plant 2 90 miles 130 miles 60 miles 120 miles Plant 3 50 miles 90 miles 100 miles 120 miles

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

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
(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…
solve the following LP MODELS
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 ?
J 2 An electronics store wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given in the accompanying table. Develop a model to find the best location, assuming that straight-line distances can be used between the locations. Experiment with the model by testing each of the possible best solutions, included, to find the best location. Click here to view the data for the store locations and annual numbers of truckloads. Click here to view some possible best solutions. The best location is at____. (Type an ordered pair. Round each coordinate to the nearest integer as needed.)
Please help me with part b
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
A bank has its head office in the financial district in the middle ofa city. A bank has six branches, three in the north of the city and threein the south all 5 km from the centre and spaced 3 km apart. The bankwishes to link all its branches via private leased lines but mustdecide between providing an individual line to each branch via anumber of inter-branch links and a smaller number of multiplexed linesto the centre. If a modem costs £100, a multiplexer/demultiplexercosts £200 and leased lines cost £100 per km per year to rent, suggesta design that will yield the most cost effective solution if theinstallation is to remain in operation for four years. 1st option is - link all branches by providing individual line to each branch via a number of inter branch links to the centre. 2nd option is - link all branches by providing smaller number of multiplexed lines to the centre Please calculate both options and choose the most cost effective solution for four years?
2.) Your business provides technical support for very complex and specialized machinery used by companies throughout the country, and you currently have support centers at 5 locations. However, due to a poor market, you have been forced to close your centers in Houston and San Diego. You will have to relocate all of your technicians in these two centers to your other three centers in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, and travel and retraining times, the cost for relocating an employee varies depending on where the employee is moving. These costs are given in the following table: To: From: Cleveland Seattle Charlotte $5,000 | $7,000 $7,000 $4,000 $6,000 $8,000 Houston San Diego You currently have 40 employees in Houston and 55 employees in San Diego, which all need to be relocated. Cleveland is able to take in at most 35 relocated employees, Seattle can take in at most 32 employees, and Charlotte is able to take in at most 50 employees.…
I need the answer as soon as possible
Please solve this Optimization problem using VAM method manually
Solve the attachment