Can i get help with those questions please and thank you XYZ Corporation has a one-year contract to supply motors for all refrigerators produced by the IACorporation. IA manufactures the refrigerators at four locations around the country: Boston, Dallas, LosAngeles, and St. Paul. Plans call for the following number (in thousands) of refrigerators to be producedat cach location:Boston100Dallas80Los Angeles100St. Paul70XYZ's three plants are capable of producing the motors. The plants and production capacities (inthousands) are as follows:Denver80Atlanta200ChicagoBecause of varying production and transportation costs, the profit that XYZ earns on cach lot of 1000units depends on which plant produced the lot and which destination it was shipped to. The followingtable gives the accounting department estimates of the profit per unit (shipments will be made in lots of1000 units):150Shipped ToProduced AtBostonDallasLos AngelesSt. PaulDenver181310Atlanta201713Chicago7111516With profit maximization as a criterion, XYZ's management wants to determine how many motors shouldbe produced at each plant and how many motors should be shipped from cach plant to each destination.1. |Find the optimal solution and the maximum profit.2. In which plant there will be idle capacity and how many units (in thousands)?3. Do alternative optimal solutions exist? Justify your answer.4. If they exist, use the stepping stone algorithm and find the second optimal solution. Present youranalysis in a graphically neat manner. Use any drawing technique you like – just make sure it looks fairlyprofessional.5. Produce the third optimal solution by taking a combination of 20% of the first optimal solution and80% of the second one.Attach all relevant exhibits from Excel's Solver calculations. Use PrintScreen, edit/copy/paste, etc. –whatever you like.

TOTAL number of supply constraints : 3TOTAL number of demand constraints : 4Problem Table is…

XYZ Corporation has a one-year contract to supply motors for all refrigerators produced by the IA Corporation. IA manufactures the refrigerators at four locations around the country: Boston, Dallas, Los Angeles, and St. Paul. Plans call for the following number (in thousands) of refrigerators to be produced at cach location: Boston 100

XYZ Corporation has a one-year contract to supply motors for all refrigerators produced by the IA Corporation. IA manufactures the refrigerators at four locations around the country: Boston, Dallas, Los Angeles, and St. Paul. Plans call for the following number (in thousands) of refrigerators to be produced at cach location: Boston 100

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 100P

See similar textbooks

Similar questions

The Martin-Beck Company operates a plant in St. Louis with an annual capacity of 30,000 units. Product is shipped to regional distribution centers located in Boston, Atlanta, and Houston. Because of an anticipated increase in demand, Martin-Beck plans to increase capacity by constructing a new plant in one or more of the following cities: Detroit, Toledo, Denver, or Kansas City. The estimated annual fixed cost and the annual capacity for the four proposed plants are as follows: Proposed Plant Annual Fixed Cost Annual Capacity Detroit $175,000 20,000 Toledo $300,000 30,000 Denver $375,000 40,000 Kansas City $500,000 10,000 The company’s long-range planning group developed forecasts of the anticipated annual demand at the distribution centers as follows: Distribution Center Annual Demand Boston 20,000 Atlanta 30,000 Houston 20,000 The shipping cost per unit from each plant to each distribution center is as follows: Distribution Centers Plant…
The Martin-Beck Company operates a plant in St. Louis with an annual capacity of 30,000 units. Product is shipped to regional distribution centers located in Boston, Atlanta, and Houston. Because of an anticipated increase in demand, Martin-Beck plans to increase capacity by constructing a new plant in one or more of the following cities: Detroit, Toledo, Denver, or Kansas City. The estimated annual fixed cost and the annual capacity for the four proposed plants are as follows: Proposed Plant Annual Fixed Cost Annual Capacity Detroit $175,000 20,000 Toledo $300,000 30,000 Denver $375,000 40,000 Kansas City $500,000 10,000 The company’s long-range planning group developed forecasts of the anticipated annual demand at the distribution centers as follows: Distribution Center Annual Demand Boston 20,000 Atlanta 30,000 Houston 20,000 The shipping cost per unit from each plant to each distribution center is as follows: Distribution Centers Plant…
A rapidly expanding company is looking to lease a small plant in Memphis, Tennessee, Biloxi, Mississippi, or Birmingham, Alabama. Prepare a cost benefit study for each of the three locations using the following data: The annual construction, facilities, and administration expenses for Memphis, Biloxi, and Birmingham will be $40,000, $60,000, and $100,000, respectively. In Memphis, labour and materials are estimated to cost $8 per month, $4 in Biloxi, and $5 in Birmingham. The Memphis site would add $50,000 a year to device transportation expenses, the Biloxi location would add $60,000 per year, and the Birmingham location would add $25,000 per year. The annual production is expected to be 10,000 units.
The Executive Furniture Corporation, which manufactures office desks at three locations: Des Moines, Evansville and Fort Lauderdale. The firm distributes the desks through regional warehouses located in Albuquerque, Boston and Cleveland. The production costs per desk are the same at each factory and hence the only relevant costs are those of shipping from each source to each destination. They are assumed to be constant regardless of their volume shipped. An estimate of the monthly production capacity at each factory and estimate of the number of desks required per month at each destination and the shipping cost ($) per desk from each source to each destination is given in the following table: Transportation table for Executive Furniture Corporation To From Albuquerque Boston Cleveland Factory capacity Des Moines 6 5 8 300 Evansville 5 9 8 400 Fort Lauderdale 4 5 6 350 Requirements 350 250 450…
Tommy Hilfiger is currently considering to source certain textile goods, Tommy Jeans, from Mexico. The estimated shipping time from Mexico to the U.S. for each shipment of Tommy Jeans is 4 days and the estimated freight cost of each shipment is $800. On the other hand, the current average shipping time from Vietnam to the U.S. for each shipment of Tommy Jeans is 23 days and the average freight cost is $2300. Even though the shipping time and freight cost seem to be much lower in case of Mexico, Tommy Hilfiger management is concerned about the production cost of each Jeans shipment. The management anticipates that the production cost of each Jeans shipment will be higher in Mexico compared to Vietnam. However, Tommy Hilfiger management has decided that even if the total cost (sum of production cost, freight cost, and holding cost) remain similar to Vietnam, Tommy Hilfiger will still source Jeans from Mexico because of the reduced shipping time, which, in turn, will result in better…
The Martin-Beck Company operates a plant in St. Louis with an annual capacity of 30,000 units. Product is shipped to regional distribution centers located in Boston, Atlanta, and Houston. Because of an anticipated increase in demand, Martin-Beck plans to increase capacity by constructing a new plant in one or more of the following cities: Detroit, Toledo, Denver, or Kansas City. The estimated annual fixed cost and the annual capacity for the four proposed plants are as follows: Plant Number Proposed Plant Annual Fixed Cost Annual Capacity 1 Detroit $150,000 10,000 2 Toledo $275,000 20,000 3 Denver $400,000 30,000 4 Kansas City $475,000 40,000 The company's long-range planning group developed forecasts of the anticipated annual demand at the distribution centers as follows. DistributionCenter Number DistributionCenter Annual Demand 1 Boston 20,000 2 Atlanta 30,000 3 Houston 30,000 The shipping cost per unit from each plant to each distribution center is as…
SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 5 states listed below. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,000, Tulsa is $131,000, Denver is $140,000, and Seattle is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown below. Each consultant is expected to take at most 40 trips each year.If at most 3 consultants are to be assigned to a home office, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network? Please generate the conceptual model and excel model to answer these questions.Travel cost ($)Los Angeles Tulsa Denver Seattle Number of trips requiredWashington 150 250 200 25 40Oregon 150 250 200 75 35California 75 200 150 125 100Idaho 150 200 125…
SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 5 states listed below. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,000, Tulsa is $131,000, Denver is $140,000, and Seattle is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown below. Each consultant is expected to take at most 40 trips each year. If at most 3 consultants are to be assigned to a home office, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network? Travel cost ($) Los Angeles Tulsa Denver Seattle Number of trips required Washington 150 250 200 25 40 Oregon 150 250 200 75 35 California 75 200 150 125 100 Idaho 150 200 125 125 25 Nevada 100 200 125 150 40 Tips: The limit number of consultants…
The Palestinian ministry of sports has four basketball games on a particular night. The ministry wants to assign four teams of officials to the four games in a way that will minimize the total distance traveled by the officials. The supply is always one team of officials and the demand is for only one team of officials at each game. The distances in km for each team of officials to each game location are shown in the following table officials 1 2 3 a 100 150 120 b 130 210 90 c 120 170 90 A) Formulate this problem as Assignment Model (the objective function and constraint equations for the demand and supply) . b) Use QM to solve the Model.
The Nature and Wildlife Corporation has manufacturing facilities in country A and an assembly plant in country B. In June 2020, the company will ship 1,000 units with a production cost of $65 per unit to its plant in country B. Its operating expenses in country A are $15,000 for the month. The income tax rate in country A is 20% and in country B it is 40%. The company plans to have a transfer price of $100 per unit. The final product can be sold in country B for $140. Country B’s operating expenses are $10,000 during the month. Could the company benefit by changing the transfer price to $120?
A logistics company plans to provide coal logistics transportation services to HY coal sales enterprise. HY coal sales enterprise has coal storage and sales points in B and D, with available coal quantities of 1600t and 8000t, respectively; A and C represents the locations of two coal users, with a demand of 8000t and 1600t respectively. The distribution of relevant locations and travel distances are shown in Figure 1. Based on the above conditions, try to calculate and explain from the perspective of transportation capacity consumption: How should logistics company HY plan transportation routes in order to make them more reasonable? (a transportation route planning scheme needs to be illustrated) . Note:The solution should not be hand written.
A sports apparel company has received an order for a college basketball team’snational championship T-shirt. The company can purchase the T-shirts from textile factoriesin Mexico, Puerto Rico, and Haiti. The shirts are shipped from the factories to companies inthe United States that silk-screen the shirts before they are shipped to distribution centers.Following are the production and transportation costs ($/shirt) from the T-shirt factories tothe silk-screen companies to the distribution centers, plus the supply of T-shirts at thefactories and demand for the shirts at the distribution centers (a) Formulate this problem in Excel and (b) determine the optimal shipments to minimize totalproduction and shipping costs for the apparel company.