Excel Mon 1:06 AM E File Edit View Insert Format Tools Data Window Help HES AutoSave OFF Lastname_ISE350FINAL-2 Home Insert Draw Page Layout Formulas Data Review View Tell me Share X 12 - A Insert v ab P = General Calibri (Body) BI U OM 28-Ou 8 Paste GO V C.A. = $ % ) 2. Delete Format .00 0 Ideas AV Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? A1 fx A H i J L L M N B D E F G (20 points) Daily demand for Harley-Davidson motorcycles is normally distributed. Various parts come together from across the globe. The engine is manufactured in India with a lead time of L days. Mean for demand is D with a standard deviation of OD. Ordering cost is C dollars per order, the annual holding cost is H dollars per engine. Currently Harley-Davidson has a safety stock level for engines based on a 90 percent cycle service level. If Harley- Davidson is willing to spend 50 percent more on managing safety stock, what service level could be achieved? z (normal distribution). 1.28 1.65 2.05 2.33 Percent 90 95 98 99 Assume continuous review system. Actual data is provided below. 3 4 L (days) 22 L (days) 5 Demand (engines) 3 Demand (engines) 6 Standard Deviation 2 Standard Deviation 7 Ordering cost C($/order) 354 Ordering cost ($/order) 8 Holding cost S ($/unit) 27 Holding cost ($/unit) 9 10 11 12 Instructions Problem 1 Problem 2 Problem 3 Problem 4 Prolem 5 + 53,271 14 A P W WW