please include the formulas to type in excel. thanks!

Problem 2 (25 Points): For the Fixed Time Period Model of inventory management, find the values for z, the Standard deviation of T+L, and the Quantity Ordered for the given values of average demand, the time between orders, lead time, stock-out risk, standard deviation of demand, and current inventory. Make a one-way table showing how the Quantity Ordered would change for changing values of the stock-out risk from 3% to 18% in steps of 3%. Make a two-way table to showing how the Quantity Ordered would change if time between ordered varied from 3 days to 13 days in steps of 2 days, and the stock-out risk varied from 3% to 18% in steps of 3%. Place your results in the spaces provided. All terms have their usual meaning. Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 18 EE = ab Wrap Text General + A A A Inse Paste BIU Morge & Center De UNE Conditional Format Cell Formatting as Table Styles For W28 II M Problem 2 (25 Points) Q Fixed Time Period Model Stock-out Risk Quantity Ordered 25 15 5 6% units days days Stock-out Risk 9% 12% 3% 6% 15% 18% Average Daily Demand Time Between Orders Lead Time Stock-out Risk Z Std. Dev. of Demand Current Inventory Std Dev of T+L Quantity Ordered 3% 6% 9% 12% 15% 18% Time Between Orders (days) 3 5 7 9 11 13 4 55 units units units units 10 12 14 15 16 17 Problem 2 (25 Points): For the Fixed Time Period Model of inventory management, find the values for z, the Standard deviation of T+L, and the Quantity Ordered for the given values of average demand, the time between orders, lead time, stock-out risk, standard deviation of demand, and current inventory. Make a one-way table showing how the Quantity Ordered would change for changing values of the stock-out risk from 3% to 18% in steps of 3%. Make a two-way table to showing how the Quantity Ordered would change if time between ordered varied from 3 days to 13 days in steps of 2 days, and the stock-out risk varied from 3% to 18% in steps of 3%. Place your results in the spaces provided. All terms have their usual meaning. Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 18 EE = ab Wrap Text General + A A A Inse Paste BIU Morge & Center De UNE Conditional Format Cell Formatting as Table Styles For W28 II M Problem 2 (25 Points) Q Fixed Time Period Model Stock-out Risk Quantity Ordered 25 15 5 6% units days days Stock-out Risk 9% 12% 3% 6% 15% 18% Average Daily Demand Time Between Orders Lead Time Stock-out Risk Z Std. Dev. of Demand Current Inventory Std Dev of T+L Quantity Ordered 3% 6% 9% 12% 15% 18% Time Between Orders (days) 3 5 7 9 11 13 4 55 units units units units 10 12 14 15 16 17