A bakery must decide how many pies to prepare for the upcoming weekend. The bakery has the option to make 50, 100, or 150 pies. Assume that demand for the pies can be 50, 100, or 150. Each pie costs $5 to make and sells for $7. Unsold pies are donated to a nearby charity center. Assume that there is no opportunity cost for lost sales.

7) Refer to the information above.

a. Which alternative should be chosen based on the maximax criterion?

b. Which alternative should be chosen based on the maximin criterion?

c. Which alternative should be chosen based on the Lapalce criterion?

d. Which alternative should be chosen based on criterion of realism with alpha = 0.8?

e. Which alternative should be chosen based on the minimax regret criterion?

(PLEASE ANSWER IN EXCEL SPREADSHEET)