The solution to the following problems is to be submitted in a single file. Acceptable formats are pdf, MS-word, or Excel. Use the first 7 letters (or less for shorter names) of your last name followed bythehomework number to name the file. Upload the assignment to the Homework 3 Box on Canvas. 1. Consider a product with the following lead time demand: Demand per week Probability 15 0.10 16 0.25 17 0.10 18 0.05 19 0.15 20 0.25 21 0.10 Lead time is one week. Given the following data , per unit per year, and assuming52weeks per year, if management sets the reorder point to R=19 units a. Find the probability of satisfying demand in a cycle. (1pt) b. Find the mean demand during the lead time. (1pt) c. Given the order quantity as the mean demand during the lead time, find the fill rate. (1pt) d. Given the order quantity as the mean demand during the lead time, what is the reorder point if management wants a 92% probability of satisfying demand per cycle? (1 pt) e. Referring to part d, what is the expected number of units short per cycle? (1 pt) Please do it using ex cel