Please note that part 2 needs to be answered in terms of units and not a percentage. Please show all of your work in an easy to follow format. Thank you. :)

The annual demand for a product is 17,400 units. The weekly demand is 335 units with a standard deviation of 80 units. The cost to place an order is $29.00, and the time from ordering to receipt is eight weeks. The annual inventory carrying cost is $0.20 per unit. a. Find the reorder point necessary to provide a 99 percent service probability. (Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places.)

Find reorder point in units

b. Suppose the production manager is asked to reduce the safety stock of this item by 60 percent. If she does so, what will the new service probability be? (Use Excel's NORM.S.DIST() function to find the correct probability for your computed z value. Round "z" value to 2 decimal places and final answer to 1 decimal place.)

Find service probability in units

The annual demand for a product is 17,400 units. The weekly demand is 335 units with a standard deviation of 80 units. The cost to place an order is $29.00, and the time from ordering to receipt is eight weeks. The annual inventory carrying cost is $0.20 per unit. a. Find the reorder point necessary to provide a 99 percent service probability. (Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places.) Reorder point units b. Suppose the production manager is asked to reduce the safety stock of this item by 60 percent. If she does so, what will the new service probability be? (Use Excel's NORM.S.DIST() function to find the correct probability for your computed z value. Round "z" value to 2 decimal places and final answer to 1 decimal place.) Service probability units