1) Determine the optimal quantity for Bev to bake each morning if unsold breads can be sold in the day-old store.

2)What is the optimal quantity for Bev to bake if the unsold breads cannot be sold to the day-old store at the end of the day (so that unsold leaves are a total loss)?

3)Construct an Excel expected value payoff table.

4)What is the basic model for this case?

all info is provided below

Bev's Bakery specializes in sourdough bread. Early each morning, Bev must decide how many loaves to bake for the day. Each loaf costs $0.75 to make and sells for $2.85. Bread left over at the end of the day can be sold the next for $1.00. Past data indicate that demand is distributed as follows: Demand Probability 100 0,01 200 0,02 300 0,05 400 0,07 500 0.30 600 0.20 700 0,12 Bev's Bakery specializes in sourdough bread. Early each morning, Bev must decide how many loaves to bake for the day. Each loaf costs $0.75 to make and sells for $2.85. Bread left over at the end of the day can be sold the next for $1.00. Past data indicate that demand is distributed as follows: Demand Probability 100 0,01 200 0,02 300 0,05 400 0,07 500 0.30 600 0.20 700 0,12