Report and Spreadsheet

I need a report and spreadsheet ” Excel work.” Real World Experience 2 involves the development and marketing of a new ski helmet. Bob Guthrie, a retired physician and avid downhill skier, has an idea for a new ski helmet. He is going to go ahead with a pilot project for his new helmet. He has come to you for help in analyzing the potential payoffs from five alternative production / marketing strategies. Your task is to determine the potential payoffs from his alternatives. Then you must use the decision making techniques under uncertainty and risk to advise Bob as to the optimal decision, and the expected payoff from that decision. Bob is a bit of a puzzle, we don’t know if he is an optimists or a pessimist so you have to alert him to both decision criteria. He has provided you with his best estimated return from each alternative, and his thoughts on the market probabilities, so he will want to know about risk. However; Bob would be interested in paying for a market research report. He is sure he can buy such a report, so he wants to know the value of perfect information and how much he should pay for the report. Seems like RWE 2 is very much real world.