Company Background Information 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 $18 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 until it reaches the Richmond facility Historically, the standard deviation of lead time has been 1 5 weeks Product Orders (Demand) Information The company provides you with the following information for the past two fiscal years Demand Characteristic 2019 2020 Annual Demand, sets 25,817 30,722 Average Weekly Demand 496 591 Standard Deviation of Weekly Demand 124 148 Product Forecasting Information Throx uses two main forecasting methods based on annual data to predict orders for the following year, a weighted moving average and exponential smoothing They provide you with the following information about forecasts for FY 2017 through FY2020 along with actual demand experienced in each of those years Actual Demand (Three Sock Sets) Weighted Moving AverageForecast (MA) Exponential Forecast (EXP) 2017 19,025 15,500 16,300 2018 22,450 16,915 18,753 2019 25,817 20,275 22,080 2020 30,722 23,785 25,443 Weighted Moving Average uses W t 0 6, W t 1 0 2 W t 2 0 2 Exponential Smoothing uses 0 9 and 1 0 1 Inventory Management Information The initial inventory for all sock styles combined at the beginning of FY 2021 is 2,250 units You also have information on current costs, which includes Order cost to Throx for an order placed with its current supplier, $ order S $300 Holding cost per set per year H $2 25 The company currently pays (P) $$8 00 for each set of socks The company uses a continuous review replenishment policy, and has IT systems in place that allow constant monitoring of key information Last year, the company used an ROP under this policy of 2,000 units for all sock styles and an order quantity Q of 5,000 units for all sock styles Potential Alternatives to Current Supply Chain Management The company has asked you to evaluate a number of alternatives to their current SCM practices, including at a minimum their choice of supplier, transportation modes, order quantities and safety stock, and warehouse capacity and location Supplier Information The table below provides information relating to important characteristics of the current supplier In addition, the table includes the same types of information for two potential alternative suppliers in China (A and B) that have been contacted by Throx The last column indicates the weights to be considered for each supplier characteristic Supplier Characteristic Current Alternative A Alternative B Weight Supplier Cost Per Stock Set $ 8 00 $ 7 00 $ 7 50 0 4 Order Cost, $ order $ 300 $ 325 $ 275 0 1 C pk Quality Capability Index TBD TBD TBD 0 3 Financial condition of the firm Good Poor Fair 0 2 TBD to be determined (calculated) by students Quality Performance Information To conduct a quality performance assessment for each of these suppliers, Throx would like you to determine the value of the Capability Index (C pk ) for each The table below includes information that will facilitate this analysis Also, Throx has set a Target Sock Thickness 7mm 5mm Measures in mm Current Alternative A Alternative B Mean Sock Thickness 7 00 6 7 7 1 Standard Deviation 0 14 0 13 0 11 Transportation Information Similar to the changes that have been contemplated with regard to product sourcing, Throx would like to use a single sourcing strategy for transportation As an alternative to their current use of Maersk Ocean Freight, Throx would like to consider UPS AirExpress which would significantly reduce actual shipping time from Shanghai to Richmond The table below provides information for evaluating a potential change of shipping from ocean to air Transportation Supplier Characteristics Maersk Ocean Freight (Current) UPS AirExpress (Alternative) Direct transportation cost $ sock set $ 2 00 4 00 Damage rate assume each sock set is valued at $8 3 0 0 75 Average Transit Time, weeks 4 0 5 No data is available about variation in transit times for air, so Throx assumes this is constant NOTE Ignore any current port capacity issues when making your decision recommendation Warehouse Location Information The company would also like to assess whether its current warehouse location is appropriate based on where customers are located For each of the key markets served by Throx , the table below indicates recent population figures and X and Y coordinates of the market locations Sales of Throx products in each location is roughly proportional to the size of the population Market Population X Y LA Long Beach 12,000,000 34 118 San Francisco 4,000,000 38 122 San Diego 2,000,000 33 117 Sacramento 1,000,000 39 121 The company has asked you to evaluate a number of alternatives to their current SCM practices, including at a minimum their choice of supplier, transportation modes, warehouse capacity, order quantities and safety stock Case Questions 1 Calculate measures of forecast accuracy MFE, MAD and MAPE using the data from FY2017 through FY2020 A) Which forecast is more accurate B) Do these forecasts seem adequate for the purposes of decision making Why or why not Note this is just for the four years (treat them like months) 2 Develop a forecast for FY2021 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 Are there any other considerations that you would recommend to Throx 3 This question will have you calculating 2 different 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 FY2020 based on the FY2020 forecast value that you determined to be most accurate in Question 1 B) Calculate the EOQ and ROP based upon actual demand for FY2020 C) Use the total inventory cost calculation to determine total inventory costs for each of the three EOQ results EOQ from part a, EOQ from part b, and the Q that Throx is currently using (given in the case) When determining the costs use 2020 actuals for your Demand (D) for all three scenarios i Compare the total inventory costs from the three results and analyze what it shows you ii What are the implications of the ROP Throx is currently using versus the ROP based on Actual Demand See additional tips below Use a service level of 95 (z 1 65) when calculating the ROP For the standard deviation of weekly demand, use the data provided in the table on page 2 of the case with the FY2020 forecast for all approaches Annual Inventory management costs will include the following Annual Holding Costs, Annual Ordering Costs, and Purchase Cost 4) Indicate which of the three suppliers should be used for FY2021 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 Are there any concerns Throx should consider with your selection Remember for your quality rating you must first determine the Capability Index (CPk) for each supplier Remember show your CPk results 5) Indicate which transportation mode should be used for FY2021 A) You must complete an analysis of the annual transportation costs B) When supporting your recommendation, be sure to discuss other implications (such as inventory levels, safety stock, and the resulting costs) to support justify your recommendation 6) Calculate EOQ and ROP values for FY2021 based on your forecast from Question 2 and recommendations for their sock supplier and transportation company from Question 4 5 (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 for Q ROP if they maintain that approach for the 2021 business plan 7) Determine the 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 8) Discuss considerations and potential issues with the implementation for each of your recommendations 2021 forecast, EOQ ROP, Supplier, Transportation , and Location What changes or resources would be necessary to implement them, and what decisions might create challenges and require additional leadership attention Write a few sentences on each recommendation

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 19, 2024

Company Background Information 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

Company Background Information

Throxsells 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 $18/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 whenThroxplaces an order until it reaches the Richmond facility. Historically, the standard deviation of lead time has been 1.5 weeks.

Product Orders (Demand) Information

The company provides you with the following information for the past two fiscal years:

Demand Characteristic	2019	2020
Annual Demand, sets	25,817	30,722
Average Weekly Demand	496	591
Standard Deviation of Weekly Demand	124	148

Product Forecasting Information

Throx uses two main forecasting methods based on annual data to predict orders for the following year, a weighted moving average and exponential smoothing. They provide you with the following information about forecasts for FY 2017 through FY2020: along with actual demand experienced in each of those years

	Actual Demand (Three Sock Sets)	Weighted Moving AverageForecast (MA)	Exponential Forecast (EXP)
2017	19,025	15,500	16,300
2018	22,450	16,915	18,753
2019	25,817	20,275	22,080
2020	30,722	23,785	25,443

Weighted Moving Average uses W_t= 0.6, W_t-1=0.2 W_t-2=0.2

Exponential Smoothing uses = 0.9. and 1- = 0.1

Inventory Management Information

The initial inventory for all sock styles combined at the beginning of FY 2021 is 2,250 units. You also have information on current costs, which includes:

Order cost toThroxfor an order placed with its current supplier, $/order = S = $300
Holding cost per setper year= H = $2.25
The company currently pays (P) $$8.00 for each set of socks

The company uses a continuous review replenishment policy, and has IT systems in place that allow constant monitoring of key information. Last year, the company used an ROP under this policy of 2,000 units for all sock styles and an order quantity Q of 5,000 units for all sock styles.

Potential Alternatives to Current Supply Chain Management

The company has asked you to evaluate a number of alternatives to their current SCM practices, including at a minimum their choice of supplier, transportation modes, order quantities and safety stock, and warehouse capacity and location.

Supplier Information

The table below provides information relating to important characteristics of the current supplier. In addition, the table includes the same types of information for two potential alternative suppliers in China (A and B) that have been contacted by Throx. The last column indicates the weights to be considered for each supplier characteristic.

Supplier Characteristic	Current	Alternative A	Alternative B	Weight
Supplier Cost Per Stock Set	$ 8.00	$ 7.00	$ 7.50	0.4
Order Cost, $/order	$ 300	$ 325	$ 275	0.1
C_pk- Quality Capability Index	TBD*	TBD*	TBD*	0.3
Financial condition of the firm	Good	Poor	Fair	0.2

* TBD = to be determined (calculated) by students

Quality Performance Information

To conduct a quality performance assessment for each of these suppliers, Throx would like you to determine the value of the Capability Index (C_pk) for each. The table below includes information that will facilitate this analysis.Also, Throx has set a Target Sock Thickness: 7mm +/- .5mm.

Measures in mm	Current	Alternative A	Alternative B
Mean Sock Thickness	7.00	6.7	7.1
Standard Deviation	0.14	0.13	0.11

Transportation Information

Similar to the changes that have been contemplated with regard to product sourcing, Throx would like to use a single-sourcing strategy for transportation. As an alternative to their current use of Maersk Ocean Freight, Throx would like to consider UPS AirExpress which would significantly reduce actual shipping time from Shanghai to Richmond. The table below provides information for evaluating a potential change of shipping from ocean to air.

Transportation Supplier Characteristics	Maersk Ocean Freight (Current)	UPS AirExpress (Alternative)
Direct transportation cost - $/sock set	$ 2.00	4.00
Damage rate - assume each sock set is valued at $8	3.0%	0.75%
Average Transit Time, weeks*	4	0.5

* No data is available about variation in transit times for air, so Throx assumes this is constant.

NOTE: Ignore any current port capacity issues when making your decision/recommendation Warehouse Location Information

The company would also like to assess whether its current warehouse location is appropriate based on where customers are located. For each of the key markets served by Throx, the table below indicates recent population figures and X and Y coordinates of the market locations. Sales of Throx products in each location is roughly proportional to the size of the population.

Market	Population	X	Y
LA-Long Beach	12,000,000	34	118
San Francisco	4,000,000	38	122
San Diego	2,000,000	33	117
Sacramento	1,000,000	39	121

The company has asked you to evaluate a number of alternatives to their current SCM practices, including at a minimum their choice of supplier, transportation modes, warehouse capacity, order quantities and safety stock.

Case Questions

1. Calculate measures of forecast accuracy: MFE, MAD and MAPE using the data from FY2017 through FY2020.

A) Which forecast is more accurate?
B) Do these forecasts seem adequate for the purposes of decision making? Why or why not?

Note this is just for the four years (treat them like months).

2. Develop a forecast for FY2021 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. Are there any other considerations that you would recommend to Throx.

3. This question will have you calculating 2 different 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 FY2020 based on theFY2020 forecast valuethat you determined to be most accurate in Question #1.
B) Calculate the EOQ and ROP based uponactual demand for FY2020
C) Use the total inventory cost calculation to determine total inventory costs for each of the three EOQ results: EOQ from part a, EOQ from part b, and the Q that Throx is currently using (given in the case) When determining the costsuse 2020 actuals for your Demand(D) for all three scenarios.
i. Compare the total inventory costs from the three results and analyze what it shows you.
ii. What are the implications of the ROP Throx is currently using versus the ROP based on Actual Demand.
See additional tips below:
Use a service level of 95% (z=1.65) when calculating the ROP
For the standard deviation of weekly demand, use the data provided in the table on page 2 of the case with the FY2020 forecast for all approaches.
Annual Inventory management costs will include the following: Annual Holding Costs, Annual Ordering Costs, and Purchase Cost.

4) Indicate which of the three suppliers should be used for FY2021. 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. Are there any concerns Throx should consider with your selection?

Remember for your quality rating you must first determine the Capability Index (CPk) for each supplier. Remember show your CPk results

5) Indicate which transportation mode should be used for FY2021.

A) You must complete an analysis of the annual transportation costs.
B) When supporting your recommendation, be sure to discuss other implications (such as inventory levels, safety stock, and the resulting costs) to support/justify your recommendation.

6) Calculate EOQ and ROP values for FY2021 based on your forecast from Question 2 and recommendations for their sock supplier and transportation company from Question 4 & 5. (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 for Q & ROP if they maintain that approach for the 2021 business plan?

7) Determine the 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.

8) Discuss considerations and potential issues with the implementation for each of your recommendations: 2021 forecast, EOQ &ROP, Supplier, Transportation , and Location What changes or resources would be necessary to implement them, and what decisions might create challenges and require additional leadership attention?Write a few sentences on each recommendation.