Metalworks Case

2012 KLU Metalworks shimmy study Students Introduction Metalwork is a company supplying cabinets and rubber eraser boxes. At the moment it has dickens lay downs and two w arhouses which argon Des Moines and capital of Delaware. Metalwork to a fault uses an external provider in case they fuckt stomach the demand. However in the case Metalwork has to corrupt products from provider it doesnt make any win since the selling terms $75 for the cabinet and $107 equals the buying price.Regarding this office staff Metalwork has decided to cleanse its logistical efficiency by either increasing its message in Des Moines or habilitateing in Juarez, Mexico by building up a new factory. Our job in this condition is to analyze the beaver option, to optimize the logistic efficiency and help Metalwork make a decision. At initial we will depict and optimize the current logistic system and then we will set ab come on to run the two solutions. And discover which one is the go aro und in order to give Metalwork the better possible attend to. Baseline scenario 1 without outstrip constrains and with compute shipment from supplier to customers.The offset job we had to do was to actualize either data and manipulate everything was correct. This work consisted in adding the data for the 3 time periods missing (2011-2012-2013). So we added the data regarding warehouse capacity, production capacity, production speak tos, and customers demand. We allowed result shipment from the supplier to customers. We overly checked the flows between every actor of the logistic passage (exhibit 1). We use the Rail Warehouses Midwest between warehouses and ABC fleet carrier wave from warehouses to customers. Then we made the software run for a first try and saw the results.So as a result we keister take that first the scenario is executable. Hopefully by the way since it is how the Metalwork is supposed to work. We rouse dupe that the total cost (which contains man ufacturing, battery-acid, warehousing, variables, and holding be) is $321741907 75 and total profit of $2001748527 44. So the situation is pretty good since the company realizes profits. We peck also go over that in this baseline scenario we order 629398 84 units to our supplier. Units on which we take ont make any profit. So we can clearly attend to that there is a need to invest in order to meet the demand thanks to our products.Baseline scenario 2 without space constrains and without rent shipment from supplier to customers. In this scenario we will try to put one across if it is possible work without direct shipment from the supplier to the customers. That is wherefore the lane visual changes compared to the first one. The answer in this case is that this scenario is not feasible, because of warehouses capacity. Indeed we begin to see that it is requisite to work with more than 2 warehouses. Baseline scenario with direct shipment and with distance constrains for ware house to customer. In this scenario we will introduce constraints regarding the maximum distance to customers.Indeed tall quality service and responsiveness is highly important to Metalwork that is why we add a distance constraint of maximum 800 miles to Tier 1 customers and 1000 miles to Normal customers. We keep the aforesaid(prenominal) data and the same lanes and logistic system. Except that we allow this time delivery from the supplier to the customers. Because if not we would shit add the same problem as in the second scenario since the situation is tear down harder regarding the distance constraints. That is why we decided to run it with this scenario. So we can see that the two warehouses supply the customers in within the 1000 miles away.That is why the supplier has to send directly to the other customers and also to supply the dwell that is needed by the customers. We can see that only having two warehouses is sincerely not enough. In this situation the supplier has much more impressiveness and that has huge effects on the costs. Dual supply On the diagram bellow we can see that the supplier has a huge immensity on the production since it produces even more than the Plant in Dover. So in this situation we can see that the total costs realize dramatically increased from $341741907 75 to $887796558, 11 and the profit has gone wad to $1435693607, 07.The manufacturing cost is really high 749750420 $ compared to 138145001$ in the first scenario. Regarding the new constraint we really realize that Metalwork needs to invest in new plant and in new warehouses. Baseline scenario with direct shipment and with distance constrains for warehouse to customer and supplier to customer. The scenario is not feasible because the warehouse capacity is limited and the distance from supplier to some customers is greater than the distance restriction. We decided to befool this restriction because we fought it was necessary to apply the distance constraints to t he supplier also.Indeed the service level must be equal for every product to every customer. Indeed the customer doesnt need to greet and dont care if the product is from the supplier plant or Metalwork plant. Increased demand scenario in Des Moines We increase capacity of Des Moines. The production capacity of the safety boxes increases by 25% and cabinets by 50%. We set the additional $1250 000 operation costs. And we decrease the cost for each unit produced in Des Moines by 50 cents. We apply these directives into our data base for every time period. We also add the accident to go from 2 warehouses to 4 warehouses for the 4 time period.Two of the warehouses are fixed. unmatched in Des Moines and one in Dover. So in this scenario we can see that the total cost has decreased compared to the first baseline scenario. straight we have a total cost of $248104881 97 and a profit of $2075385283 22 which is much higher than in the first baseline scenario. We can also notice that with these enthronizations the supplier is no perennial needed. So the objective achieved. confident(p) we have 100% of the demand met. We clearly see that the Plant in Des Moines is the main motor of Metalwork. Plus even with the distance constraint we see that the scenario is feasible.This is able thanks to the 2 more warehouses available. So as we see on the map bellow, all the customers are supplied and the 4 warehouses are dispatched on every side of the United States. Plus there are only a few customers supplied by two warehouses, because of warehouse capacity. So clearly the result is conclusive. The demand is met the costs go down and the profit rises. Double supply Mexican Plant scenario In this scenario the objective of Metalwork is to improve the network of its plants and also to relocate its investment into a low labor cost country.The opening cost of this plant opening is $5000000. In order to make this scenario work we had to fix the data for the 4 time period, that is to say cancel the downsize in costs and production capacity in Des Moines. We also forbid the direct shipment from supplier to customer if needed. And used the railway West transportation for Railway warehouses West to supply our products to the warehouses. But we still have the same problem as in the previous scenario that is to say that some customers are supplied by two warehouses. Double supplyAs we can see can see in the chart below, our total cost is $ 243950541 68 which is smaller than in the previous scenario. The profit is also a little bit higher, with $2079539623 51. 100% of the demand is met so we can say that the objective is met. And with better results on every side whether it is financial or quality we can say that we would recommend this investment rather than the first one. However this also depends on the image the brand wants to have, something such as made in America and avoid social problems in the plants.When the activity is relocated. We can see on the last chart that the production almost equally equilibrate between Des Moines and Juarez. The good thing is that the supplier is no longer needed. So every unit sold makes the company make profit. closedown 1. After comparing the different scenarios based on the guidelines we had, we found that the scenario that elusive building a plant in Juarez, Mexico turns out to be the best one. 2. While comparing the increased capacity scenario and the Mexico scenario we found that they are close the same.In both of these scenarios we find that we dont need an external supplier, we would be able to supply the demand on our own. 3. Compared to the baseline scenario we can see that increasing the number of warehouses decreases the overall total costs. 4. While optimizing the solution, we figured out that having to use two given warehouses might not be the optimum choice, those two warehouses should be catalogued as potential, the maximum number of warehouses should be increased. 5. We notice base line scenarios cant compete with the improved capacity scenario or the Mexico scenario since the cost of buying from a supplier is too high.