The Goal Seek Command
Not what you're looking for?
I am managing a conference at my college. My fixed costs are $15,000. I must pay the 10 speakers $700 each, and the college union $300 per conference participant for food and lodging costs. I am charging each conference participant who is not also a speaker $900, which includes the conference fee and their food and lodging costs. How many paid registrants need to attend for me to break even?
Purchase this Solution
Solution Summary
This solution of 295 words calculates the break-even point for a conference, taking into account fixed costs, speaker costs, food and lodging costs. All steps and formulas are shown in an Excel file.
Solution Preview
Please see the attached Excel sheet as well as the explanation below, and let me know if you have questions.
-----------------
The idea of this problem is to equate costs to revenues. There is one variable: the number of paying (non-speaker) participants. By varying the number of paying participants, we can find the number necessary to make costs equal revenues -- or in other words, to break even.
We have ...
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.