You are trying to calculate the amount of safety stock inventory that a company needs to hold onto. One of the key inputs is the service level, which is dened as the probability that the company will be in-stock on the item. For example, a 95% service level means that the company will be in-stock on that item 95% of the time. You'd like to do an analysis to gure out how the service level (cell D7) affects the amount of safety stock (cell D8). You've begun to set up a data table to try out a range of service levels from 90% to 96%: m mean demand 328.06 per week 90.0% stdev of demand 67.65 per week 90.5% review period 1 week 91.0% lead time 10 days 91.5% service level 95.00% 92.0% safety stock 173.41 92.5% 93.0% 93.5% 94.0% 94.5% 95.0% 95.5% 96.0% Click here i, if you can't see the image above. Use this information to answer questions 15-17: You now want to use Goal Seek to figure out what the service level would be if you wanted to maintain a safety stock inventory of 200. Here's a screenshot of the Goal Seek dialog box: Goal Seek ? X Set cell: To value: By shanging cell: OK Cancel Click here & if you can't see the image above. What would you enter in each cell? Set cell: To value: By changing cell