The company would like to fix a reorder point for the supply of the woods. It decides to use a reorder point with a fixed quantity to reorder for this material. The average Supplier Lead Time is approximately 2 weeks. The quantity ordered to the supplier is fixed by (LeadTime * average weekly demand during the last 12 weeks). 1) Determine the fixed quantity of woods that is ordered to the supplier. 2) Determine the reorder point of the wood material by considering a variable demand during the last 12 weeks. 3) Determine the safety stock that can be considered to protect the company from the fluctuation of demand. 4) Determine the maximum quantity of this material by considering Maximum Quantity = Quantity ordered to the supplier + Material for 1 week + Safety Stock 5) Determine the minimum quantity to be considered for the wood material to avoid any out of stock. Minimum Quantity= Average weekly Demand * LeadTime The sales of the company during the last 12 weeks of chairs and tables are as in the following: Week t-12 Week t-11 Week t-10 Week t-9 Week t-8 Week t-7 Week t-6 Week t-5 Week t-4 Week t-3 Week t-2 Week t-1 Sales of chairs Sales of Tables (unit) (unit) 180 40 190 50 200 55 300 60 260 80 200 45 220 55 320 65 220 55 280 60 350 70 220 45 1 1) What is the total quantity of woods required for the current week t by using a simple moving average forecast taking into account sales of the last 12 weeks? 2) What is the total quantity of woods required for the current week t by using a weighted moving average forecast by considering only the last three weeks using the following weights ( 50% for week (t-1), 30% for week (t-2) and 20% for the week (t-3)) The company would like to fix a reorder point for the supply of the woods. It decides to use a reorder point with a fixed quantity to reorder for this material. The average Supplier Lead Time is approximately 2 weeks. The quantity ordered to the supplier is fixed by (LeadTime * average weekly demand during the last 12 weeks). 1) Determine the fixed quantity of woods that is ordered to the supplier. 2) Determine the reorder point of the wood material by considering a variable demand during the last 12 weeks. 3) Determine the safety stock that can be considered to protect the company from the fluctuation of demand. 4) Determine the maximum quantity of this material by considering Maximum Quantity = Quantity ordered to the supplier + Material for 1 week + Safety Stock 5) Determine the minimum quantity to be considered for the wood material to avoid any out of stock. Minimum Quantity= Average weekly Demand * LeadTime The sales of the company during the last 12 weeks of chairs and tables are as in the following: Week t-12 Week t-11 Week t-10 Week t-9 Week t-8 Week t-7 Week t-6 Week t-5 Week t-4 Week t-3 Week t-2 Week t-1 Sales of chairs Sales of Tables (unit) (unit) 180 40 190 50 200 55 300 60 260 80 200 45 220 55 320 65 220 55 280 60 350 70 220 45 1 1) What is the total quantity of woods required for the current week t by using a simple moving average forecast taking into account sales of the last 12 weeks? 2) What is the total quantity of woods required for the current week t by using a weighted moving average forecast by considering only the last three weeks using the following weights ( 50% for week (t-1), 30% for week (t-2) and 20% for the week (t-3))
