Q8. (15 points) Olivia Annimali is planning her wedding and needs to select a facility. Olivia is a risk-taker

by nature. She knows there is a chance of rain on the chosen date, which is six months away. She has

invited 200 people, and there is a chance the attendance will exceed 100. Olivia's choices are:

1- An outdoor wedding.

Park rental fee $100 No refund for bad weather.

If it does rain, she can get a small hotel ballroom that seats 100 for $1000 or a large ballroom

seating 200 for $3000.

2- Church social hall. Seats 300 and costs $500.

3- Select the indoor hotel facility in advance.

Small ballroom for $800, large for $1500. If the attendance exceeds 100, the party can be moved

to the large room for a total cost of $3000.

Olivia must make reservations now and will know the attendance and the weather only two days before

her wedding.

Required

Develop a payoff table for the cost of the facility.

please provide answer on excel with workings