solve according to the instructions.!

Marks will be deducted for late submission and poor formatting Use excel for calculations and interpret your answers in word document. Zero marks will be awarded in case of cheating or copy paste. Assignment Topic & Details: Assignment Topic: Decision Analysis Assignment Detail: T.S. Amer's Ski Shop in Nevada has a 100-day season. T.S. has established the probability of various store traffic, based on historical records of skiing conditions, as indicated in the table to the right. T.S. has four merchandising plans, each focusing on a popular name brand. Each plan yields a daily net profit as noted in the table. He also has a meteorologist friend who, for a small fee, will accurately tell tomorrow's weather so T.S. can implement one of his four merchandising plans. TRAFFIC IN STORE BECAUSE (STATES OF NATURE) DECISION ALTERNATIVES (MERCHANDISING PLAN FOCUSING ON:) Patagonia North Face Cloud Veil Columbia 60 Probabilities .25 a) What is the expected monetary value (EMV) under risk? b) What is the expected value with perfect information (EVwPI)? c) What is the expected value of perfect information (EVPI)? d) What will be the decision under uncertainty? e) Use TreePlan and develop a decision tree for this problem. OF SKI CONDITIONS 2 92 84 $40 50 20 48 52 10 35 45 80 72 25 40 10 30 20