Sir, I would appreciate if you could do it in Excel. Thank you.

Question 4 (10 marks) Snow White is planning a fund-raising party for the Seven Dwarfs. The group has put the following costs together for the event: Buffet dinner (per Person) $14 Drinks (Per Person) $6 Band $3600 Hall rental $8400 Servers and collectors $2400 Tickets and advertising $1600 The suggested price is $60 per person for the event. Required: ALL CALCULATIONS MUST BE SHOWN 1. Compute the break-even point for the event. 2. Last year only 250 people attended the event. If we assume the same number of people will attend this year, what must the price of each ticket be to break even? 3. If you were given a budget of $30,000 for the party with 300 people planning to be invited, could you have the party? If so, what could you do with any excess money