Q4. A company has three warehouses (W1, W2, W3) supplying four retail stores (S1, S2, S3, S4) with their respective demands. The transportation costs per unit from each warehouse to each store are giver as follows: The capacities of the warehouses and the demands of the stores are as follows: S1 S2 S3 S4 W1 = 100, W2 = 150, W3 = 200 Store demands: W1 3 5 7 6 W2 4 6 3 S1 = 80, S2 = 120, S3 = 70, S4 = 180 W3 2 5 7 8 6 Warehouse capacities: Find the initial solution to minimize transportation cost using minium cost method and improve the solution with transportation simplex algorithm to find optimal solution.

Q4. A company has three warehouses (W1, W2, W3) supplying four retail stores (S1, S2, S3, S4) with their respective demands. The transportation costs per unit from each warehouse to each store are giver as follows: The capacities of the warehouses and the demands of the stores are as follows: S1 S2 S3 S4 W1 = 100, W2 = 150, W3 = 200 Store demands: W1 3 5 7 6 W2 4 6 3 S1 = 80, S2 = 120, S3 = 70, S4 = 180 W3 2 5 7 8 6 Warehouse capacities: Find the initial solution to minimize transportation cost using minium cost method and improve the solution with transportation simplex algorithm to find optimal solution.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Generate the Sensitivity Report in EXCEL for the model that you built. Interpret, in context, the Shadow Price for the Leather and the Satin constraints. Include units in your interpretations.
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)
9. The VP of manufacturing for the N. L. Hyer Company is ready to decide on her sales and oper- ations plan for next year. The firm's single product (known throughout the adult puzzle trade as "Hyer's Hexagon") is "red hot," according to the VP of marketing, so she insists that backorders are not acceptable next year. Since the United Puzzlemakers Union is trying to organize the plant, the manufacturing VP decided the number of employees must remain constant (i.e., level) throughout all four quarters. Pertinent information is as follows: Quarter 1 I™ 2 3 Production Days 60 58 61 70 Demand Forecast 12,000 13,000 13,590 9,000 4 Beginning inventory = 1,000 units Regular time output rate = 10 units/day employee a. What daily production rate and number of employees will be required? b. How many units will be in inventory at the end of quarter 4?
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Clearly state the decision variables, objective function and constraints. The objective function and constraints should be written as inequality or equality formulas. b) Generate the Answer Report using SOLVER in EXCEL. Then, clearly answer what is the optimal solution? What is the resulting profit?
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Generate the Answer Report using SOLVER in EXCEL. Then, clearly answer what is the optimal solution? What is the resulting profit?
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Suppose the feasible region from a set of constraints in a linear programing problem is given in the shaded region of the attached graph. If the objective function is to minimize Cost = 9x + 4y, what would be the optimal solution? What is the resulting minimized cost? SOLVER is not used in this question. Explain your reasoning.
A company that has cement factories in Denizli, İzmir and Uşak will transport the cements to theconsumption region 1, 2 and 3. The cement production capacities of the factories are 200 tons forthe factory in Denizli, 300 tons for the factory in İzmir and 450 tons for the factory in Usak.Demand of the first consumption region is 250, demand of the second region is 100, demand of thethird region is 225 and demand of fourth region is 325 tons of cement. The transportation costbetween factories and consumption areas is as below table per ton:Factories 1. Region 2. Region 3. Region 4. RegionDenizli 15 18 12 13İzmir 10 10 11 9Usak 8 5 7 8According to these data;1) Make the initial distribution of the enterprise according to the Vogel’s Approximation Method(VAM) and calculate the total transportation cost. 2) Determine the distribution that minimizes the total transportation cost according to the (MODI)method.
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?
Data collected on the yearly demand for 50- pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Estimate demand for vear 12 with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other two years are each given a weight of 1. Year Demand (Bags) 4 6. 3 4. 4. 10 6 8. 8. 8. 12 10 14 11 15 O A. 13.67 O B. 14.00 OC. 14.87 O D. 11.79 Click to select your answer. Us MacBook Air 888 * ES F2 F4 F6 F7 4) F9 F10 %23 2$ & * 4 6. 7 8 9. Q W R T Y F C V В alt command command option %#3