hi , is there anyone who can help me on this question ???

BSTA____________ Assignment 1 Semester Computer Tool: TreePlan Excel AddIn. Case Problem: Klean Corporation Waste Management. The Klean Corporation is involved with waste management. During the past 10 years it has become one of the largest waste disposal companies in Eastern Canada, serving primarily Quebec and Ontario. Chris Klean, president of the company, is considering the possibility of establishing a waste treatment plant in British Columbia. From past experience, Chris believes that a small plant in Southern B. C. would yield a $500 000 profit regardless of the market for the facility. The success of a mid-size waste treatment plant would depend on the market. With a low demand for waste treatment, Chris expects a $100 000 return. A medium demand would yield a $600 000 return in Chris's estimation, and a high demand would return $800 000. A large facility is much riskier and because of its size would also be subject to a mandatory environmental review. Such a review has the potential of stopping the building of the large facility project. If the result of the environmental review is unfavorable, Klean would have no choice, due to the delay, but to cancel the project and abandon any further work on waste facilities in British Columbia ( $0 net return). If the large facility is given the go-ahead (environmental review is favorable), the estimated return with high demand would be a 1.4 million dollars. With a medium demand, the large facility should return $400 000. But Chris estimates that the large facility would be a big loser if there is a low demand for waste treatment. He estimates that he would lose approximately $200 000 with a large treatment facility if demand is indeed low. Chris is fairly confident that the probability of an unfavorable environmental review would only be about 0.25. Looking at the economic conditions for the southern part of the province of British Columbia and using his experience in the field, Chris estimates that the probability of a low demand for treatment plants is 0.15. The probability of a medium- demand for a waste treatment facility is approximately 0.35, and the probability of a high demand for a waste treatment facility is 0.5. Because of the large potential investment and the possibility of a loss, Chris has decided to hire a market research firm \"Humber Research and Optimization\" that is based in Brampton, ON. This firm will perform a survey to get a better feeling for the probability of a low, medium, or high demand for a waste treatment facility. The cost of the survey is $35 000 and the survey will have two possible outcomes: 1Adapted from Render, Stair, Balakrishnan, Smith, \"Managerial Decision Modelling\