Construction Bids. Gamma Construction Company has been asked to bid on the construction of 21 lighted tennis courts for State University. Each court will cost $20,000 in construction costs, and, in addition, there will be a fixed expense of $12,000 to cover the preparation and submittal of the bid. Gamma is considering five different bid levels. Each level involves a different profit margin, calculated as a percentage above total construction cost (TCC). Fixed expenses are excluded from this calculation, but they are relevant for profitability that it will win the bid at each level being considered. The bids and the probabilities are summarized in the following table.

	Amount of Bid	Probability of Winning
Bid 1	TCC + 5%	0.76
Bid 2	TCC + 10%	0.65
Bid 3	TCC + 15%	0.54
Bid 4	TCC + 20%	0.43
Bid 5	TCC + 25%	0.32

a. What is the optimal bid for Gamma to make?

b. What is the expected profit associated with the optimal bid?

c. What is the risk profile for the optimal bid?

please solve this problem in Excel sheet using decision tree