Question

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

Answer 1

attend to have $ 10000 C) No. of Paid Registrants need to a profitot B Required Profit Fired Cost + Speaker Payment Cost Required contribution 32000 contribution perunit 600 + Toooo 150.00 7000 !__ No of Registrants et Iotal contribution contribution Per unit 32000 600 53,