I need to calculate and show the different formulas to answer these questions in Microsoft Excel. I would appreciate step by step solutions for a-g with accompanying explanation and/or pictures if possible. Thank you!
The Fish House (TFH) in Norfolk, Virginia, sells fresh fish and seafood. TFH receives daily shipments of farm-raised trout from a nearby supplier. Each trout costs $2.45 and is sold for $3.95. To maintain its reputation for freshness, at the end of the day, TFH sells any leftover trout to a local pet food manufacturer for $1.25 each. Daily demand for the trout is an integer between 10 and 20 (inclusive). The owner of TFH wants to determine how many trout to order each day. a. Construct a payoff table for this problem. [5 points] b. What purchase quantity should be made according to the maximax decision rule? [5 points] c. What purchase quantity should be made according to the maximin decision rule? [5 points] d. What purchase quantity should be made according to the Laplace (equally-likely) decision rule? [5 points] e. What purchase quantity should be made according to the minimax regret decision rule? [10 points Historically, the daily demand for trout is given in the following table. Demand 12 14 17 18 19 10 11 13 15 16 20 0.06 0.13 0.18 0.07 0.03 Probability 0.02 0.09 0.11 0.15 0.11 0.05 f. What purchase quantity should be made to maximize the expected daily profit? [10 points] g. How much should the owner of TFH be willing to pay to obtain a daily demand forecast that is 100% accurate? [10 points]