PLEASE SHOW EXCEL SOLUTION WITH FORMULAS

Y Calibri (Body) 12 v A General Insert v === 22 == = Conditional Formatting Format as Table Cell Styles AY DX Delete v Paste BIU v ar Ar v $ %) V 0-99 Format v Sort & Filter E17 x fix D E F G H I K L M N O P Q R S T U U B Demand 12 14 13 11 14 12 15 13 13 11 12 15 12 Calculate the reorder point and the optimum order quantity from a supplier where 1. the actual demand of past 22 days is given in column B, 2. The supplier's lead time is 3 days, 3. Fixed ordering cost is $100, 4. Holding cost per unit per day is $5.0, 5. The company work for 365 day per year. A A 1 2 Day 1 3 Day 2 4 Day 3 5 Day 4 6 Days 7 Day 6 8 Day 7 8 9 Day B 10 Day 9 11 Day 10 12 Day 11 13 Day 12 14 Day 13 15 Day 14 16 Day 15 17 Day 16 18 Day 17 19 Day 18 20 Day 19 21 Day 20 22 Day 21 23 Day 22 24 25 26 27 28 29 30 31 32 33 34 Forecast the demand by exponential smoothing. 10 13 13 15 12 15 13 13 14 35 36 37