WILL LEAVE GOOD RATING IF CORRECT. Please answer in an Excel sheet and post screenshot.

Complete the following exercises in an Excel Workbook (one sheet per exercise): nean 1. Weekly demand for Tesla phones at the Tesla store is normally distributed with a mea of 400 and a standard deviation of 100. The phone assembler takes three weeks to supply Tesla store an order. Tesla is targeting a CSL of 96 percent and monitors its inventory continuously. How much safety inventory of phones should the Tesla store carry? What should its ROP be? 2. Weekly demand for Large Trash Bags at a Costco store is normally distributed with a mean of 2800 boxes and a standard deviation of 650. The store manager continuously monitors Large Trash Bag inventory and places a replenishment order for 9,000 units when there are 7000 units in inventory. The supplier takes two weeks to supply a Costco order. What CSL does the store achieve? What fill rate does the store achieve? 3. Weekly demand for paper towels at a Malmart store is normally distributed with a mean of 1,200 and a standard deviation of 350. The supplier takes two weeks to supply a Malmart order, which is for a batch size of 5000. Malmart is aiming for a fill rate of 99 percent and monitors its inventory continuously. How much safety inventory of paper towels should Malmart carry? What should its ROP be