3. Transportation Model (Solve using Excel Solver) BOM Manufacturing has four plants P1, P2, P2, and P4 located throughout a state with production capacities of 1000, 750, 850, and 900 units, respectively. Lately, because of the higher demand, the company needs to supply its four retail shops B1, B2, B3, and B4 with 1300, 900, 750, and 1550 units, respectively. The current transportation costs per unit are illustrated below. Сарacity 1100 950 850 B1 B2 B3 B4 P1 7 6 3 P2 P3 6. 8 4 10 4 P4 7 4 980 1200 950 1050 1750 Between the three identified possible locations, L1, L2, and L3, given the estimated transportation costs per unit as shown below, which location will you choose to build the new plant and why? B1 B2 B3 7 B4 L1 L 2 4 5 7 8 L3 3 4 10 6.

3. Transportation Model (Solve using Excel Solver) BOM Manufacturing has four plants P1, P2, P2, and P4 located throughout a state with production capacities of 1000, 750, 850, and 900 units, respectively. Lately, because of the higher demand, the company needs to supply its four retail shops B1, B2, B3, and B4 with 1300, 900, 750, and 1550 units, respectively. The current transportation costs per unit are illustrated below. Сарacity 1100 950 850 B1 B2 B3 B4 P1 7 6 3 P2 P3 6. 8 4 10 4 P4 7 4 980 1200 950 1050 1750 Between the three identified possible locations, L1, L2, and L3, given the estimated transportation costs per unit as shown below, which location will you choose to build the new plant and why? B1 B2 B3 7 B4 L1 L 2 4 5 7 8 L3 3 4 10 6.

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

SOLVE THE FOLLOWING PROBLEM OF TRANSPORTATION.Fertimex manufactures fertilizer for general application in 3 different plants located in Acayucan, Ver., Celaya, Gto. andSaltillo, Coah. and sends the final product to 4 different warehouses, 1,2,3 and 4. Since some manufacturing operationshave been around longer than others, there are different production costs at different plants. (TheNewer plants use more modern and up-to-date processes that result in lower costs of ownership.production). The table shows the production costs in pesos per ton and the capacity ofproduction in tons of each plant: Table 1 The requirements in tons of warehouses 1, 2, 3 and 4 are 300, 450, 500 and 600, respectively. Due toSince each warehouse operates separately, the sales prices per ton differ a little, being $62.00,$63.00, $64.00 and $64.00, respectively. How Fertimex managers want to maximize profitscompany totals; for this they must consider the transportation costs associated with the shipment of the…
Maximal Flow a. Write the linear program for this problem. b. Create a spreadsheet model to find the maximal flow from node 1 to 6
Q: When we solve the given transportation problem according to the lowest cost method, which warehouse and/or warehouses are suitable for shipment from f3 (F: Factory M: Customer)A) no needb) M1, M2, M3c) M1 and M2d) M3 and M1E) M3
9-43. Northwest University is in the process of complet-ing a computer bus network that will connect com-puter facilities throughout the university. The prime objective is to string a main cable from one endof the campus to the other (nodes 1–25) throughunderground conduits. These conduits are shownin the network below; the distance between them isin hundreds of feet. Fortunately, these undergroundconduits have remaining capacity through which thebus cable can be placed.(a) Given the network for this problem, how long (inhundreds of feet) is the shortest route from node1 to node 25?(b) In addition to the computer bus network, a newphone system is also being planned. The phonesystem would use the same underground conduits. If the phone system were installed, the follow-ing paths along the conduit would be at capacity and would not be available for the computer busnetwork: 6–11, 7–12, and 17–20. What changes(if any) would you have to make to the pathused for the computer bus if the phone…
Baton Rouge's Mt. Cedar Hospital is a large, private, 600-bed facility complete with laboratories, operating rooms, and X-ray equipment. In seeking to increase revenues, Mt. Cedar's administration has decided to make a 90-bed addition on a portion of adjacent land currently used for staff parking. The administrators feel that the labs, operating rooms, and X-ray department are not being fully utilized at present and do not need to be expanded to handle additional patients. The addition of 90 beds, however, involves deciding how many beds should be allocated to the medical staff (for medical patients) and how many to the surgical staff (for surgical patients). The hospital's accounting and medical records departments have provided the following pertinent information. The average hospital stay for a medical patient is 8 days, and the average medical patient generates $2,280in revenues. The average surgical patient is in the hospital 5 days and generates $1,515 in…
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.)
Suppose the company has received a proposal for setting up another warehouse(Warehouse E) with a capacity of 900 units. The location of the warehouse is such thatthe unit costs of transporting to the six cities are as follows: Hyderabad–45, Mysore–75, Chennai–30, Kochi–65, Pune–90 and Vizag–80. The company would like to knowhow the allocation will change if the warehouse is made operational and the likely costimpact on the operation of the system.
The network in the figure, shows the routes for shipping cars from three (3) plants (nodes, 1,2 and 3) to three (3) dealers (nodes, 6, 7, 8) by way of two (2) distribution centers (nodes 4and 5). The shipping costs per car (in $100) are shown on the arcs. Solve the problem as a transshipment model.1. Formulate the Linear Programming model 2. Choose one among the three methods for the starting/initial basic solution 3. Solve for the optimal solution using Method of Multipliers
4. Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. Set up the solution in Excel and solve with Solver. What are total costs?
A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be $.50 per load meter moved. An analyst has prepared the following flow and distance matrices: Distances (meters) Flows (Loads per week) From/To I II III From/To X Y Z I - 10 20 X - 0 80 II - - 10 Y 30 - 150 III - Z 100 130 -If the company were to locate departments X, Y, and Z in areas 1, 2, and 3, respectively, what would be the total distance (in meters) loads would be moved each week?A. 3,100B. 3,600C. 6,200D. 7,200E. 8,200 Work must…
Please I want to solve the point 3
Suppose the company has received a proposal for setting up another warehouse(Warehouse E) with a capacity of 900 units. The location of the warehouse is such thatthe unit costs of transporting to the six cities are as follows: Hyderabad–45, Mysore–75, Chennai–30, Kochi–65, Pune–90 and Vizag–80. The company would like to knowhow the allocation will change if the warehouse is made operational and the likely costimpact on the operation of the system. After balancing above table by which method we should solve this problem