assume group number equal to 5

Please solve it typed not handwritten, thank you

Q4) An electronic store uses continuous review policy to manage the inventory of its high selling monitor model. The monitor has the following characteristics. The weekly demand for the monitor is (200 * your group number) units per week with standard deviation of (15* your group number). The monitors are bought from an offshore supplier with a lead time of 16 weeks at a price of 8000 AED per unit and each order costs 40000 AED. The holding cost of laptops is 20% of the value of the product. The store would like to achieve 85% cycle service level. a) Calculate the weekly demand and standard deviation of weekly demand using your group number. b) What is the average demand during lead time and standard deviation of the demand during lead time? c) what is the annual demand for the monitor? d) What is the economic order quantity? EOQ? e) What would be the average time between orders (in weeks)? f) What is the required safety stock level to achieve 85% cycle service level? g) What is the reorder point for this monitor? h) What is the cycle stock level and pipeline inventory? i) What is the total cost of managing the inventory for this monitor? j) How much safety stock is needed if the store wants to use cycle service level of 80%? FORMULAE 1 year = 365 days; 1 year = 52 weeks Inventory Formulas 2DS EOQ = * = Total Cost (TC) = S*D/Q +H*(Q/2 +ss), ss=zVLO, = DQ * H NORM.S.INV(0.95) = 1.65 NORM.S.INV(0.92) = 1.41 NORM.S.INV(0.90) = 1.28 NORM.S.INV(0.88) = 1.17 NORM.S.INV(0.85) = 1.04 NORM.S.INV(0.80) = 0.84