Please make an excel.

Atwater Capital, a company that is ruthlessly run by its CEO {nicknamed "The Warthog\"? and specializes in telecommunication devices, has been invited to bid on an open government contract. These telecommunication devices must be delivered throughout next year. All bids are sealed to prevent the bidding companies om knowing the amounts, and the lowest bid wins the contract. Atwater Capital estimates that it will cost $5,000 to prepare a bid and $95,000 to supply the instruments if it wins the contract. Based on past similar contracts, Anvater Capital believes that the possible lov.r bids om the competition {if competitors decide to bid) and associated probabilities are those shown in the table below. Due to a strong working relationship with the local government, if Atwater Capital's bid equals the lowest bid of the competitors then Anvater Capital will be awarded the contract. In addition, Atwater Capital believes there is a 30% chance that there will be no competing bids. Lowest Bid from Unknown Com I etor Probabili ' Less than $115,000 Between $120,000 and $125,000 - Between $115,000 and $120,000 Greater than $125,000 _ Atwater lCapital is considering not bidding as well as possible bids of $115,000, $120,000, or $125,000. Create a payoff table with all decision alternatives and states of nature. You do not have to create a decision tree, but it might help to answer the problem. a. 1What is the optimal strategy for the company that maximizes estimated profit? b. If the probabihty that a competitor does not bid drops to 5% instead of 30%, hov.r does that affect the expected value of each of the decision alternatives? Compared to part a, is Atwater Capital better or worse off (and by how much)