Please make a excel file.

Do not make a decision tree using the software mentioned in the problem description. Instead, recreate the payoff table in your worksheet and use Excel functions to determine which decision alternative is optimal. Also determine whether Stephanie Mille should pay the $7,000 for perfect information. Show your work.

Stephanie Mills plans to open a hair salon close to Purdue campus. She has three difference strategies: opening a small-size shop, medium-size shop, and a large- size shop. She estimates the profit and probability for difference favorable markets: Good Market, Fair Market, and Bad Market (refer to the table). Additionally, ZS Consulting Co. offers Stephanie a deal to marketing research for her. If Kim pays them $7,000, she can get the perfect information provided by ZS. Do you agree to accept this offer or not?

FAVORABLE MARKET SHOP SIZE GOOD (S,) FAIR ($2) BAD ($3) SMALL (d,) $10,000 $8,000 $5,000 MEDIUM (d2) $30,000 $20,000 $0 HIGH (d3) $50,000 $10,000 -$5,000 PROBABILITY 35% 40% 25%