You are managing a conference at your college. Your fixed costs are $15,000. You must pay the 10 speakers $700 each and the college union $300 per conference participant for food and lodging costs. You are charging each conference participant who is not also a speaker $900, which includes the conference fee and food and lodging costs. (a) Develop a spreadsheet model to calculate the total profit of the conference if you have 100 paid registrants. (b) How many paid registrants need to attend for you to break even? (c) How many paid registrants need to attend for you to guarantee a profit of at least $10,000? (c) Use data tables to evaluate profit for range of paid to attends varying from 30 to 120 (in increments of 10) (e) Define and run some reasonable scenarios using the Scenario Manager to evaluate profitability for the following scenarios: Likely Optimistic Pessimistic Paid to attend 75 100 50 Attend fee 700 900 600 Ficced Cost 15000 10000 18000 per speaker College Conference Fixed Cost Price per Speaker Number of Speakers Total Speaker Cost College Union Fee Total College Union Cost Conference Fee Registrants Total Revenue Total Profit per participant per registrant