1. SAMCIS Automobile Company manufactures automobiles in three plants and then ships them to four regions of the country. The manufacturing plants A, B, and C supplies 450, 600 and 500 cars respectively. The projected customer demand per region is 450, 200, 300 and 300 units for region 1, 2, 3 and 4 respectively. The transportation cost from the different plants going to the different regions in the Country are presented in the table below. Region 3 266 263 Region 1 131 250 Region 2 218 116 Region 4 120 278 180 Plant A Plant B Plant C 178 132 122 Generate the mathematical model for finding the least cost way of shipping the automobiles from the different plants to selected regions in the country. What will be the optimal solution to the given problem? Submit the result in the excel solver and the manual computation to arrive at the ptimal solution.

1. SAMCIS Automobile Company manufactures automobiles in three plants and then ships them to four regions of the country. The manufacturing plants A, B, and C supplies 450, 600 and 500 cars respectively. The projected customer demand per region is 450, 200, 300 and 300 units for region 1, 2, 3 and 4 respectively. The transportation cost from the different plants going to the different regions in the Country are presented in the table below. Region 3 266 263 Region 1 131 250 Region 2 218 116 Region 4 120 278 180 Plant A Plant B Plant C 178 132 122 Generate the mathematical model for finding the least cost way of shipping the automobiles from the different plants to selected regions in the country. What will be the optimal solution to the given problem? Submit the result in the excel solver and the manual computation to arrive at the ptimal solution.

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

1. Evaluate the current China/Taiwan logistics costs. Assume a current total volume of 190,000CBM and that 89 percent is shipped direct from the supplier plants in containers. Use the datafrom the case and assume that the supplier-loaded containers are 85 percent full. Assume thatconsolidation centers are run at each of the four port locations. The consolidation centers useonly 40-foot containers and fill them to 96 percent capacity. Assume that it costs $480 to ship a20-foot container and $600 to ship a 40-foot container. What is the total cost to get thecontainers to the United States? Do not include U.S. port costs in this part of the analysis.2. Evaluate an alternative that involves consolidating all 20-foot container volumes and using onlya single consolidation center in Shanghai/Ningbo. Assume that all the existing 20-foot containerUU- SCM-1200 Introduction to Supply Chain Management Page 2volumes and the existing consolidation center volumes are sent to this single…
A single facility is needed to meet the demands of four markets. The locations and demands ofthese four markets are shown below. Market Coordinates Demand A (8,6) 10 B (4,12) 15 C (3,2) 10 D (9,6) 6 1.Using the data in the table above, identify an optimal location for the new facility. 2. A manufacturing firm is considering three potential locations for a new parts manufacturing facility. Aconsulting firm has assessed three sites based on the four factors supplied by management as critical tothe location's success. Management-supplied the factor weights and the consultant team scores as seen as in the table below. Scores are based on 50 = best. Location Factor Weight A B C Labour climate 10 35 45 20 taxes 30 30 40 40 utilities 20 25 20 45 wages 40 10 25 25 Which location should be selected and why?
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 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.
1. Transportation Problem: The Navy has 9,000 pounds of material in Albany, Georgia that it wishes to ship to three installations: San Diego, Norfolk, and Pensacola. They require 4,000, 2,500, and 2,500 pounds, respectively (Destination or Demand amounts). Government regulations require equal distribution of shipping among the three carriers (Supply nodes). Note: This means the supply is the same for each type of transportation. The shipping costs per pound for truck, railroad, and airplane transit are shown below. Formulate and solve a linear program to determine the shipping arrangements (mode, destination, and quantity) that will minimize the total shipping cost.DestinationMode San Diego Norfolk PensacolaTruck $12 $ 6 $ 5Railroad 20 11 9Airplane 30 26 28 2. Transshipment Problem The Northside and Southside facilities of Zeron Industries supply three…
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…
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…
A supply chain manager faced with choosing among four possible locations has assessed each location according to the following criteria, where the weights reflect the importance of the criteria. Location Criteria Weight 1 2 3 4 Raw material availability 0.06 P VG OK VG Infrastructute 0.07 P G VG OK Transportation costs 0.33 G P OK P Labor relations 0.25 VG G P OK Quality of life 0.29 G OK P VG VG = Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts ; P = Poor 1 pt. Using this information, determine the best and the worst location. Round your answers to two decimal places. Location Total Points 1 2 3 4 ______ is the best location and _______ is the worst location.
To From Los Angeles Calgary Panama City Supply Mexico City $6 $18 $8 100 Detroit $17 $13 $19 60 Ottawa $20 $10 $24 40 Demand 50 80 70 B) The toral cot of initial solution developed using the intuitive lowest- method: C) The total Cost of The optimal solution:
In Myanmar (formerly Burma), 6 laborers, eachmaking the equivalent of $3 per day, can produce 40 units perday. In rural China, 10 laborers, each making the equivalentof $2 per day, can produce 45 units. In Billings, Montana,2 laborers, each making $60 per day, can make 100 units.Based on labor costs only, which location would be most economical to produce the item?
A new airline has decided to join the market. It is considering offering flights out of Cagayan, and would initially like to travel to three different locations: Cebu, Palawan, and Bohol. The distances of each round-trip flight going out of Cagayan are (approximately): 720 miles, 1500 miles, and 1140 miles, respectively. The company would like to use the slogan, “the average price per flight is never more than P10, 000.” As for costs, it anticipates flights to Cebu will run about 10% of airfare. Similarly, Palawan will run 12% and Bohol will run 14% of airfare. The company wants to ensure that the overall average cost is no more than 10% of earned airfare. Recent market research allows the company to conclude that it could probably sell about 1900 Cebu tickets, 700 Palawan tickets, and 1000 Bohol tickets. Under these conditions and assuming that all tickets sold are round-trip flights, how much should the company charge per ticket in order to maximize its total revenue?a. Define the…
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