Question: MUST USE GOAL SEEK excel function!! I am managing a conference at my college. My fixed costs are $15,000. I must pay the 10 speakers

MUST USE GOAL SEEK excel function!!

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? Using Goal Seek function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

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....

Q:

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....

Q:

I expect to earn 10 percent per year on my retirement investments. At the end of each of the next 40 years, I want to put the same amount of money in my retirement portfolio. How much money do I need...

Q:

Q 4 . I am managing a conference at my college. My Fixed Costs are $ 2 0 , 0 0 0 . I must pay 8 speakers $ 1 0 0 0 each and the college union $ 2 5 0 per conference participant for food and lodging...

Q:

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...

Q:

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...

Q:

For the "mortgage payment" example in Chapter 1 7 , use the Scenario Manager to create a report tabulating monthly payments for the following scenarios: \ table [ [ Scenario , Amount borrowed,Annual...

Q:

Please answer the questions using excel formulas only. Most of the questions are straight forward but become challenging when you have to utilize the formula so please show all work using that 1. As...

Q:

I am having trouble creating the formulas for number 11 and 13. Excel File Edit View Insert Format Tools Data Window Help Seminar Budget.xlsx Q Search Sheet cut AutoSum A | Fill Calibri Light Wrap...

Q:

Assignment RapidBus is a commuter bus company.On regional route A, RapidBus currently charges $10 per passenger (fare).Monthly revenue for this route is $108,000.Currently variable cost is $5 per...

Q:

Write an essay on the diversity of the seed plants (Spermatophytes), with reference to their key apomorphies and the environments in which they diversified.

Q:

When funds from operations are Rs. 65,000 and depreciation on plant is Rs. 7,500, the amount of net profit A B C D Is Rs. 65,000 Is Rs. 72.500 Is Rs. 57,500 Cannot be computed

Q:

Question Content Area Recognition is a . the ability of a company to use its financial resources to adapt to change. b . the process of measuring, recording, and reporting an element in the financial...

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...