Inventory Assignment: The entire assignment needs to be done in Excel; do the following two problems in two separate "sheets" within the same file. Clearly label the sheets as Problem 1 and Problem 2, respectively. Q. 1. The local supermarket buys lettuce each day to ensure fresh produce. Each morning any lettuce that is left from the previous day is sold to a dealer who resells it to farmers who use it to feed their animals. This week the supermarket can buy fresh lettuce for $4.00 a box. The lettuce is sold for $10.00 a box, and the dealer that sells the old lettuce is willing to pay $1.50 a box. History says that tomorrow's demand for lettuce averages 250 boxes with a standard deviation of 34 boxes. Here are the specific questions: (a) How many boxes of lettuce should the supermarket purchase tomorrow? (b) Reflect on the service level and comment on the lettuce quality and pricing, given the problem context. How can pricing considerations be changed to generate a better service level. Conduct a sensitivity chart by providing different cost structures and associated service levels. Show an associated graph. Finally, throw your insights on capacity considerations while commenting