Overview of the Case
Throx sells higher-end custom-design socks in three-sock sets (rather than two). The company operates from a small packaging and distribution facility in Richmond, CA from which it ships product to customers. Given the company’s location and focus, 97% of sales are in California, primarily in the major urban areas of the San Francisco bay area, Los Angeles, Sacramento (and last but not least) San Diego. The company sells exclusively via online sales, at an average price of $15/three-sock set, plus shipping costs charged to the customer.
The company currently orders its product from the Chinese sock manufacturer Zhejiang Datang Hosiery Group Co., Ltd in so-called “Sock City.” Socks are shipped via truck to the port of Shanghai, from where they are shipped to the port at Los Angeles-Long Beach via ocean freight. Once offloaded in Los Angeles-Long Beach, the socks are shipped via truck to the Richmond facility. On average, shipment from the manufacturer to the Richmond facility takes 4 weeks. In addition to the transit time required for shipment, the lead time from when an order is placed with the manufacturer to when it is shipped from Zhejiang is 3 weeks. So, the total lead time is considered to be 7 weeks from when Throx places an order til it reaches the Richmond facility. Historically, the standard deviation of lead time has been 1 week.
Case Questions
1)Calculate measures of forecast accuracy (MFE, MAD and MAPE) using the data from FY2016 and FY2017. Do these forecasts seem adequate for the purposes of decision making? Why or why not? Note unlike your homework/tests where we utilized multiple months this is just for the two years.
2)Develop a forecast for FY2018 using the two forecasting methods currently employed by the company. Comment on which of the forecasts is likely to be more appropriate to support decisions based on your assessment of forecast accuracy from Q1. Based upon this, identify which forecast method that you will use going forward with the project.
3)This question will have you calculating 2 EOQ and ROP values and interpreting the results. For both EOQ and ROP, give your final answer in full sock sets (ROUND UP to the next whole number). The specific questions to answer are based in parts a-c. Tips to solve the EOQ and ROP are given below in bullet points.
a)Calculate EOQ and ROP for FY2017 based on the FY2017 forecast value that you recommended in Question #1.
b)Calculate the EOQ and ROP based upon actual demand for FY2017
c)Using the responses from parts a & b, indicate what the implications are for inventory management costs in FY2017. In other words, 1. Compare the total costs for both EOQ values and analyze what it shows you. 2. What if any are the implications of the ROP based on the forecast vs the ROP based on actual demand.
See additional tips below:
1.Use a service level of 95% (z=1.65) when calculating the ROP
2.Calculate average weekly demand () by dividing the forecast by 50 weeks
3.For the variance in weekly demand, use the data provided in the table on page 2 of the case with the FY2017 forecast for all approaches.
4.Remember that there is a difference between variance and standard deviation and how you apply these values in the ROP formula
5.Annual Inventory management costs will include the following: Annual Holding Costs, Annual Ordering Costs, and Purchase Cost.
6.Currently, the company is purchasing parts not using EOQ and ROP values determined by the tools we are using. These values are given in the case.
a)Using their current order quantity, calculate the current inventory management costs based upon actual demand in FY2017 aka use this as D.
b)Compare this cost to the costs to that would have been achieved if the company had used its forecast for FY2017 to calculate EOQ and ROP values (what you calculated in Question 3a). TIP: When calculating costs based upon the forecasted EOQ, use the actual demand as D in your total cost equation. This will ensure you find the true savings or increase that the company would have seen by using the EOQ value.
5)Provide the company with the following recommendations for FY2018 to improve SCM performance, based on analysis of available data and appropriate methods from SCM 301. Be sure to justify your recommendation. Use your forecast method / values from Question 2 as input into your decisions.
a)Indicate which of the three suppliers should be used for FY2018. Develop a supplier scorecard using the following scale: 3=best, 2=second best, 1=worst and the weights provided in the case to support your selection.
b)Calculate EOQ and ROP values for FY2018 based on your forecast from Question 2 and recommended supplier from Question 5a. (TIP: The selected supplier may change your S and P values.) Give your final answer in full sock sets (ROUND UP to the next whole number). What are the expected costs for inventory management based on your decisions? How does this compare to company’s current policy--your answers from 4a?
c)Indicate which transportation mode should be used for FY2018. You must complete an analysis of the transportation costs. You may develop a scorecard to support your answer, but it is not required. When supporting your recommendation, be sure to discuss other implications (such as inventory levels, safety stock, cost etc) to support your decision.
d)Indicate an appropriate location for a new facility if one is to be built using the weighted center of gravity approach. Round your final coordinates (X, Y) to two decimal places. Discuss other relevant factors that would influence the choice of a specific location once the (X,Y) coordinates have been identified.
6)Discuss potential issues with the implementation of your recommendations. What changes or resources would be necessary to implement them, and what might create challenges?