1. Solve the following problem by using Solver in your spreadsheet: Steelco | manufactures three types of steel at different plants. The time required to manufacture 1 ton of steel (regardless of type) and the costs at each plant are shown in Table 8. Each week, 100 tons of each type of steel (1, 2, and 3) must be produced. Each plant is open 40 hours per week. Formulate a balanced transportation problem to minimize the cost of meeting Steelco's weekly requirements. TABLE 8 Plant 1 23 2 3 Steel 1 60 50 43 Cost (S) Steel 2 40 30 20 Steel 3 28 30 20 Time (minutes) 20 16 15 a. Write down the problem formulation ! b. Write down your conclusion ! 2. Write down the formal LP Formulation from Problem No. 1. 3. Solve the LP formulation from No.2 by using Excel Solver ! 4. Compare Problem No. 1 solution and Problem No. 2's solution, and then explain your conclusion !

1. Solve the following problem by using Solver in your spreadsheet: Steelco | manufactures three types of steel at different plants. The time required to manufacture 1 ton of steel (regardless of type) and the costs at each plant are shown in Table 8. Each week, 100 tons of each type of steel (1, 2, and 3) must be produced. Each plant is open 40 hours per week. Formulate a balanced transportation problem to minimize the cost of meeting Steelco's weekly requirements. TABLE 8 Plant 1 23 2 3 Steel 1 60 50 43 Cost (S) Steel 2 40 30 20 Steel 3 28 30 20 Time (minutes) 20 16 15 a. Write down the problem formulation ! b. Write down your conclusion ! 2. Write down the formal LP Formulation from Problem No. 1. 3. Solve the LP formulation from No.2 by using Excel Solver ! 4. Compare Problem No. 1 solution and Problem No. 2's solution, and then explain your conclusion !

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section: Chapter Questions

Problem 68P

See similar textbooks

Similar questions

Enable x roctorio.com/secured#lockdown NEY G. O Facebook O Instagram O YouTube O 69 Dashboard C The Impact of E-.. ng Enabled: Chapter 6 Network Optimi. 1 Saved Help Save & Exit Sub A minimum-cost flow problem has 8 supply nodes, O transshipment nodes, and 7 demand nodes. If each supply node can ship to every demand node, how many arcs will be included in the model? Number of arcs Mc Graw Hill 888 % & 3 3 4 7 8. R.
A company normally ships to a customer by rail at a cost of $500 per load. The transittime is 14 days. The goods can be shipped by truck for $700 per load and a transit timeof 4 days. If transit inventory cost is $35 per day, what does it cost to ship each way?
A manufacturer has two shipments to make from Minneapolis to Chicago. Both shipments weigh 8500 pounds. The two shipments can be shipped separately to Chicago at a cost of $2.00 per mile for a total of 409 miles and will take one day for each shipment. The company has a warehouse in Milwaukee where they can consolidate the freight. It would take two LTL shipments at $2.00 per mile to get the freight to Milwaukee for 337 miles and then one full TL shipment from Milwaukee to Chicago at $1.50 per mile for 92 miles. The consolidation cost in Milwaukee is $200 and it takes two days for the trip through Milwaukee. What is the lowest cost to ship the freight and which approach would you select?
2. Unbalanced. Provide the transportation model for the calculation of cost given the following data: Use the Stepping Stone Method to solve the following. Use degeneracy method or dummy method if necessary.
Sanchez Trucking has been experiencing delays at its ware-house operations. Management hired a consultant to findout why service deliveries to local businesses have takenlonger than they should. The consultant narrowed down theproblem to the number of work crews loading and unload-ing trucks. Each crew consists of six employees who workas a team on a variety of tasks; each employee works a full40 hours a week. However, costs are also a concern. Theconsultant advised management that they could supplementwork crews with short-term employees, at a higher cost, tocover unexpected needs on a weekly basis. Each work crewpermanently hired by Sanchez costs $3,200 per week inwages and benefits, while a crew of short-term employeescosts $5,000 per week. Complicating the decision is the factthat the weekly hourly requirements for work crews is uncer-tain because of the volatility in the number of deliveries to bemade. Deliberating with management, the consultant arrivedat the following data:
Which is the most preferred type of transportation for the transportation of light but heavy loads? Lutfen birini seçin: O a Pipeline O b. Highway O c. Airline O d. Seaway O e Railroad
Logistics Managememt Question "Organizations must continually improve its logistics in order to remain competitive.’’ Critically analyse this statement.
Timely Transport provides local delivery service for a number of downtown and suburban businesses. Delivery charges are based on distance and weight involved for each delivery: 10 cents per pound and 15 cents per mile. Also, there is a $10 handling fee per parcel. a. Develop an expression that summarizes delivery charges.
Cal's Manufacturing Ltd, is a manufacturing and distributing company in Kingston Jamaica they manufacture bottle syrup, lime juice, vinegar, bag Juices and premium fruit wine. Please answer base on what they do please, they dont sell furnitures
Dr. Vicki Belya is traveling from Yangoon to Los Angeles. She needs to change planes in Bangkok and board another airline’s flight in Tokyo. However, the ariline she is flying does not have interline agreements. Provide a basic explanation of what she can expect at every point of her journey.
Qn1. Find the optimal solution to the transportation problem using MODI method. Warehouses Supply WI W2 W3 W4 P1 19 30 50 12 Plants 5. 2. P2 70 30 40 60 P3 40 10 60 20 3. 15 Demand 4)
BETTER PRODUCTS COMPANY has decided to start manufacturing four new products in three plants that currently have excess production capacity. The products require comparable production effort per unit, so the available production capacity in the plants is measured by the number of units of any product that can be manufactured per day. a)Formulate this problem as a transportation problem by constructing the appropriate parameter table. I already have an optimal solution (it's from the book). (I dont understand)-------------------------------------------------------------------------OPTIMAL SOLUTION:It has basic variables (assignments) X₁₂ = 30, X₁₃ = 30, X₁₅ = 15, X₂₄ = 15, X₂₅ = 60, X₃₁ = 20 and X₃₄ = 25, so that: Plant 1 produces all of products 2 and 3.Plant 2 produces 37.5% of product 4.Plant 3 produces 62.5% of product 4 and all of product 1. The total cost of Z = $3 260 per day.-------------------------------------------------------------------------Instructions:Please explain this…