Question: No paperwork. please do it on excel with proper formulas step by step showing all the steps. Q8.(15 points) Olivia Annimali is planning her wedding
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
