Do calculations please

• What is the optimal order quantity Q*?
• What is the optimal Re-order point R?
• What is the optimal fill-rate service level (with two decimal places)?
• The backorder cost (p) is unreliable and should not be used. Rework the model using a 97%, in-stock service level requirement, What is the revised order quantity, Q?
• The backorder cost (p) is unreliable and should not be used. Rework the model using a 97%, fill rate service level requirement, What is the revised order quantity, Q?
• The backorder cost (p) is unreliable and should not be used. Rework the model using a 97%, fill rate service level requirement, How has the annual cost of backorders changed?
• The backorder cost (p) is unreliable and should not be used. Rework the model using a 97% (or 99%), fill rate service level requirement, What is the revised type 1 service level ( with two decimal places)?
• Finally, the management team would like to do some sensitivity analysis on the type 2 service level. By how much does Total Relevant Cost increase as the type 2 service level is changed from 97% to 99%?
• At the 99% type 2 service level, what is the average inventory level?

units 110,000 units per year 26,000 units per year 0.08 years 0.04 years D SD L SL alpha w V h A $ Order Quantity Annual demand Standard deviation of annual demand Mean lead time Standard deviation of lead time Type 1 Service Level Inventory holding cost factor (annual) Unit purchase cost Holding cost per unit per year Backordering cost per unit Ordering cost per order Std. deviation of demand during the lead time Mean demand during the lead time Standard normal variate Safety Stock Expected units out of stock during the lead time Type 2 Service Level Reorder point Annual Cost of Cycle Stock Annual Cost of Safety Stock Annual Ordering Cost Annual Backordering Cost Annual Total Relevant Cost a>