Task: Assessment 1 comprises an individual case analysis written response (30 marks). A Read the following supply chain reconfiguration case, make assumptions as necessary but do state the assumptions made clearly, and answer the following questions provided at the end of the case description. The case company (referred to as ABC) is a leading supplier of maintenance, repair and operating (MRO) products to businesses and institutions in the United States, Canada and Mexico with an expanding presence in Japan, India, China and Panama. The company works with more than 3,000 suppliers and offers nearly 900,000 products ranging from the industrial adhesive used in manufacturing, to hand tools, janitorial supplies, lighting equipment, and power tools. When something is needed by one of their 1.8 million customers, it is often needed quickly. So, quick service and product availability are key drivers to ABC's success. Your assignment involves studying the US distribution network in ABC's supply chain. ABC works with over 250 suppliers in China and Taiwan regions. The suppliers produce products to ABC's specifications and ship to the US using ocean freight carriers from four major ports in China and Taiwan. From these ports, products are shipped to US entry ports in either Seattle or Los Angeles. ABC currently has free on board (FOB) shipping contracts with Chinese and Taiwanese suppliers by which the supplier is responsible for all costs incurred until the product is delivered to the US entry ports. Approximately 35% of the containers enter Seattle and 65% enter the Los Angeles port. Upon arrival at the port cities, containers are inspected by federal agents. After passing through customs, products are loaded onto the 20-foot and 40-foot containers and shipped by rail to ABC's central distribution centre in Kansas City. Variable processing costs at both Los Angeles and Seattle ports are $5 per cubic meter (CBM). The rate for shipping the containers to Kansas City is $0.002 per CBM per mile (this rate applies to all shipping by rail)." In Kansas City, the containers are unloaded and processed through a quality assurance check. This costs $3 per CBM processed. A negligible percentage of the material may need to be sent back to the supplier. Errors in quantity and package size are often found requiring accounting adjustments. Items are stored in the Kansas City distribution centre, which serves nine warehouses in the US. The nine warehouses each place orders at the distribution centre that contains all the items to be replenished. Kansas City consolidates the items on order onto pallets and ships them on 53-foot trucks to warehouses. Truck freight cost $0.025 per CBM (this rate applies to all shipping by truck) per mile. The demand forecasts for the items purchased from China/Taiwan for next year and shipping distances are given in Table 1.4 Table 1: Demand and distance data- Demand (CBM) Distances (Miles) % of total Warehouse From Kansas From Los From Average Demand City Angeles Seattle Kansas City 20,900 11% 02 1,6204 1,8702 Cleveland 17,1004 8004 2,3504 2,4102 New Jersey 24,7004 13% 12004 2,7804 2,8902 Jacksonville 15,2004 8% 11504 2,4204 2,990 Chicago 22,800 12% 5204 2,0204 2,0604 Greenville 15,200 8% 2,3204 2,9504 Memphis 17,100 9% 5104 1,790 2,3304 Dallas 22,8004 12% 500 1,4302 2,1304 Los Angeles 34,2004 18% 16204 1,1404 Total 190,000 %9 9404 04 Although a high percentage of demand was from warehouses in south and east of Kansas City, the question has surfaced concerning the 18% that will be shipped to Kansas City and then shipped back to the Los Angeles warehouse. This double-transportation could potentially be eliminated if ABC builds a new distribution centre in Los Angeles. The idea is to ship material arriving at the Seattle port by rail to a new Los Angeles distribution centre, which would be located at the current location of the Los Angeles warehouse. + It is estimated that the Los Angeles facility could be upgraded at a one-time cost of $1,500,000 and then operated for $350,000 per year. In the new Los Angeles distribution centre, containers would be unloaded and processed through a quality assurance check, just as is now done in Kansas City. The cost for doing this would be $5 per CBM processed. The cost associated with transporting the containers from the Los Angeles port to the Los Angeles distribution centre is negligible. After the material is processed in Los Angeles, the amount needed to replenish the Los Angeles warehouse (approximately 18%) would be kept and the rest sent by rail to Kansas City. It would then be stocked in the Kansas City distribution centre and used to replenish the other warehouses. ABC management feels that it may be possible to make the change, but they are unsure if this would be an economical decision and whether it would be a strategic change for better. Questions to be addressed:- 1. Map, draw and explain the existing supply network, as well as calculate the annual cost associated with running the existing system? (6 marks) Note: In the existing system 35% of the volume arrives in Seattle and 65% in Los Angeles. All material is transferred to the Kansas City distribution centre by rail, where it is unloaded and quality checked. All volume is then transferred by truck to the nine existing warehouses in the US. 2. Map, draw and explain the upgraded supply network formed by changes made in the case, and calculate the annual running cost associated with it? (6 marks) 4 Note: In the new system, the Los Angeles warehouse is upgraded to include a distribution centre capable of processing all the volume coming into the US. Containers coming into Seattle would be inspected by federal officials (it needs to be done at all port locations) and then immediately shipped by rail in their original containers to Los Angeles. The entire volume would be unloaded and quality checked in Los Angeles. 18% of the volume would then be kept in Los Angeles for distribution through that warehouse and the rest transhipped by rail to the Kansas City warehouse. The material sent to Kansas City would not need to go through another quality check and would be directly stored to supply the eight remaining warehouses in the US. 3. Analyse the US supply network, identify and explain other SSCM strategies that can be applied to optimise network costs? Using Linear/Integer or other Programming mathematical problem solving techniques research other distribution cost and network design methods. 4 Determine answers to the following questions. i. Should the new Los Angeles distribution centre be added as a new node in the network? Is this strategically something that ABC should do? (8 marks) Note: For the upgraded supply chain network, you need to consider Los Angeles as another distribution centre (this means you have now two distribution centres Kansas City and Los Angeles) and you need to optimise the distribution network and minimise the total cost and make a strategic decision on Los Angeles as the distribution centre. ii. If there are multiple distribution centres in Kansas City, Los Angeles and Seattle, what would be the optimal decision on distribution and total cost for this? Assume any additional data you require. (5 marks) Note: This one is the extension of number (ii), considering an additional distribution centre in Seattle. You may need to assume some additional data such as facility and operating cost. Please mention those assumptions in your report. iii. What factors have ABC not considered that might be important in moving strategically to the new SC configuration. Base your arguments on academic evidence of concepts or practices that can be applied in designing an optimal network, and then map out the new solutions? (5 marks)- Please Note: Calculation logic and embedded processes must be evident, documented and explained clearly. Written Assignment Submission structure:- 1) Individual Assignment Title page (Provided cover sheet through Canvas) 2) Answer to question 14 3) Answer to question 24 4) Answer to question 34 Assignment Submission Format:- 1) If you are typing your answers, use font 12 times, New Romans, using A4 paper. If you are using hand-drawn pictures or tables then scan them with good quality, and embed them in your Word doc file this assignment should be submitted as one file only. + 2) All assignments must include a cover sheet which is available via the Study guide on Canvas. 3) No word limit has been set, however, you need to demonstrate stages of your calculations and be accurate in your calculations, as well as succinct and academically robust in your arguments (use top tier journal articles for citations as required and include them in the bibliography in Harvard Style). 4) Assessment marking criteria includes (1) relevance of your answer to the question or task set, (2) clarity of expression, (3) clearly documented analysis and mathematical methods used, (4) citations beyond the given subject material, (5) logical planning and sequence, and (6) appropriate written presentation of the work including drawing maps ensuring learning objectives are attained. See the Marking Criteria rubric sheet on which marks will be allocated and feedback will be provided. Task: Assessment 1 comprises an individual case analysis written response (30 marks). A Read the following supply chain reconfiguration case, make assumptions as necessary but do state the assumptions made clearly, and answer the following questions provided at the end of the case description. The case company (referred to as ABC) is a leading supplier of maintenance, repair and operating (MRO) products to businesses and institutions in the United States, Canada and Mexico with an expanding presence in Japan, India, China and Panama. The company works with more than 3,000 suppliers and offers nearly 900,000 products ranging from the industrial adhesive used in manufacturing, to hand tools, janitorial supplies, lighting equipment, and power tools. When something is needed by one of their 1.8 million customers, it is often needed quickly. So, quick service and product availability are key drivers to ABC's success. Your assignment involves studying the US distribution network in ABC's supply chain. ABC works with over 250 suppliers in China and Taiwan regions. The suppliers produce products to ABC's specifications and ship to the US using ocean freight carriers from four major ports in China and Taiwan. From these ports, products are shipped to US entry ports in either Seattle or Los Angeles. ABC currently has free on board (FOB) shipping contracts with Chinese and Taiwanese suppliers by which the supplier is responsible for all costs incurred until the product is delivered to the US entry ports. Approximately 35% of the containers enter Seattle and 65% enter the Los Angeles port. Upon arrival at the port cities, containers are inspected by federal agents. After passing through customs, products are loaded onto the 20-foot and 40-foot containers and shipped by rail to ABC's central distribution centre in Kansas City. Variable processing costs at both Los Angeles and Seattle ports are $5 per cubic meter (CBM). The rate for shipping the containers to Kansas City is $0.002 per CBM per mile (this rate applies to all shipping by rail)." In Kansas City, the containers are unloaded and processed through a quality assurance check. This costs $3 per CBM processed. A negligible percentage of the material may need to be sent back to the supplier. Errors in quantity and package size are often found requiring accounting adjustments. Items are stored in the Kansas City distribution centre, which serves nine warehouses in the US. The nine warehouses each place orders at the distribution centre that contains all the items to be replenished. Kansas City consolidates the items on order onto pallets and ships them on 53-foot trucks to warehouses. Truck freight cost $0.025 per CBM (this rate applies to all shipping by truck) per mile. The demand forecasts for the items purchased from China/Taiwan for next year and shipping distances are given in Table 1.4 Table 1: Demand and distance data- Demand (CBM) Distances (Miles) % of total Warehouse From Kansas From Los From Average Demand City Angeles Seattle Kansas City 20,900 11% 02 1,6204 1,8702 Cleveland 17,1004 8004 2,3504 2,4102 New Jersey 24,7004 13% 12004 2,7804 2,8902 Jacksonville 15,2004 8% 11504 2,4204 2,990 Chicago 22,800 12% 5204 2,0204 2,0604 Greenville 15,200 8% 2,3204 2,9504 Memphis 17,100 9% 5104 1,790 2,3304 Dallas 22,8004 12% 500 1,4302 2,1304 Los Angeles 34,2004 18% 16204 1,1404 Total 190,000 %9 9404 04 Although a high percentage of demand was from warehouses in south and east of Kansas City, the question has surfaced concerning the 18% that will be shipped to Kansas City and then shipped back to the Los Angeles warehouse. This double-transportation could potentially be eliminated if ABC builds a new distribution centre in Los Angeles. The idea is to ship material arriving at the Seattle port by rail to a new Los Angeles distribution centre, which would be located at the current location of the Los Angeles warehouse. + It is estimated that the Los Angeles facility could be upgraded at a one-time cost of $1,500,000 and then operated for $350,000 per year. In the new Los Angeles distribution centre, containers would be unloaded and processed through a quality assurance check, just as is now done in Kansas City. The cost for doing this would be $5 per CBM processed. The cost associated with transporting the containers from the Los Angeles port to the Los Angeles distribution centre is negligible. After the material is processed in Los Angeles, the amount needed to replenish the Los Angeles warehouse (approximately 18%) would be kept and the rest sent by rail to Kansas City. It would then be stocked in the Kansas City distribution centre and used to replenish the other warehouses. ABC management feels that it may be possible to make the change, but they are unsure if this would be an economical decision and whether it would be a strategic change for better. Questions to be addressed:- 1. Map, draw and explain the existing supply network, as well as calculate the annual cost associated with running the existing system? (6 marks) Note: In the existing system 35% of the volume arrives in Seattle and 65% in Los Angeles. All material is transferred to the Kansas City distribution centre by rail, where it is unloaded and quality checked. All volume is then transferred by truck to the nine existing warehouses in the US. 2. Map, draw and explain the upgraded supply network formed by changes made in the case, and calculate the annual running cost associated with it? (6 marks) 4 Note: In the new system, the Los Angeles warehouse is upgraded to include a distribution centre capable of processing all the volume coming into the US. Containers coming into Seattle would be inspected by federal officials (it needs to be done at all port locations) and then immediately shipped by rail in their original containers to Los Angeles. The entire volume would be unloaded and quality checked in Los Angeles. 18% of the volume would then be kept in Los Angeles for distribution through that warehouse and the rest transhipped by rail to the Kansas City warehouse. The material sent to Kansas City would not need to go through another quality check and would be directly stored to supply the eight remaining warehouses in the US. 3. Analyse the US supply network, identify and explain other SSCM strategies that can be applied to optimise network costs? Using Linear/Integer or other Programming mathematical problem solving techniques research other distribution cost and network design methods. 4 Determine answers to the following questions. i. Should the new Los Angeles distribution centre be added as a new node in the network? Is this strategically something that ABC should do? (8 marks) Note: For the upgraded supply chain network, you need to consider Los Angeles as another distribution centre (this means you have now two distribution centres Kansas City and Los Angeles) and you need to optimise the distribution network and minimise the total cost and make a strategic decision on Los Angeles as the distribution centre. ii. If there are multiple distribution centres in Kansas City, Los Angeles and Seattle, what would be the optimal decision on distribution and total cost for this? Assume any additional data you require. (5 marks) Note: This one is the extension of number (ii), considering an additional distribution centre in Seattle. You may need to assume some additional data such as facility and operating cost. Please mention those assumptions in your report. iii. What factors have ABC not considered that might be important in moving strategically to the new SC configuration. Base your arguments on academic evidence of concepts or practices that can be applied in designing an optimal network, and then map out the new solutions? (5 marks)- Please Note: Calculation logic and embedded processes must be evident, documented and explained clearly. Written Assignment Submission structure:- 1) Individual Assignment Title page (Provided cover sheet through Canvas) 2) Answer to question 14 3) Answer to question 24 4) Answer to question 34 Assignment Submission Format:- 1) If you are typing your answers, use font 12 times, New Romans, using A4 paper. If you are using hand-drawn pictures or tables then scan them with good quality, and embed them in your Word doc file this assignment should be submitted as one file only. + 2) All assignments must include a cover sheet which is available via the Study guide on Canvas. 3) No word limit has been set, however, you need to demonstrate stages of your calculations and be accurate in your calculations, as well as succinct and academically robust in your arguments (use top tier journal articles for citations as required and include them in the bibliography in Harvard Style). 4) Assessment marking criteria includes (1) relevance of your answer to the question or task set, (2) clarity of expression, (3) clearly documented analysis and mathematical methods used, (4) citations beyond the given subject material, (5) logical planning and sequence, and (6) appropriate written presentation of the work including drawing maps ensuring learning objectives are attained. See the Marking Criteria rubric sheet on which marks will be allocated and feedback will be provided