Practice exercise reorder point A company 'FFF" has a principal activity of selling and manufacturing tables and chairs. The company wants to determine the policy of supplying the wood material. The manufacture of one table needs approximately 20 kg of woods while for a chair needs approximately 4 kg of woods. This raw material is considered the principal used raw material in the manufacturing process and is frequently consumed. Part 1 1) What is the class type (A or B or C) of the wood material in this company by using the ABC classification method? Explain why. 2) What type of reorder point method do you advise the warehouse managers of this company to adopt for the supply of the wood material? Part 2 The sales of the company during the last 12 weeks of chairs and tables are as in the following: Sales of chairs Sales of Tables (unit) (unit) 180 40 190 50 200 55 300 60 260 80 45 220 55 320 65 220 55 280 60 350 70 220 Week t-12 Week 1-11 Week t-10 Week 1-9 Week 1-8 Week t-7 Week 1-6 Week 1-5 Week -4 Week 1-3 Week 1-2 Week 1-1 200 45 1) What is the total quantity of woods required for the current weekt 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 weekt 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 (1-3)) Part 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 (Lead Time * 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