Question 5. Recommended Order Policies (12 pts) Note: the historical demand data for this question is provided in the "OPMA301 W24 Al Historical Demand Data" file posted on D2L in this assignment's folder. Umket Corporation has recently expanded into distributing small electronic components to nearby manufacturers. Annual holding costs are slightly lower at 20% as components have less obsolescence risk than finished products in the appliances industry. Now that a few months of historical demand data is available, Umket Corporation has asked you to recommend order policies (how much and when) for the following three items: Item # Unit Cost 75-4538-9 55-4687-2 $2.80 $5.20 87-3719-5 $9.00 Order Cost $60.00 $84.00 $40.00 Supplier Lead Time 6 5 12 Desired Service Level 95% 90% 99% Show your work for full marks. Include your formulas used - in Microsoft Excel, Press CTRL + (grave accent). Don't replace the actual calculations - copy the formulas into a neighboring cell and display both. Activate the printing of the "row and column headings" in page setup.