Reference no: EM13848578
Breakeven Analysis Procrastinators Anonymous (PA) is hosting their annual convention this coming year in Dallas, TX. Although this is not typical of this organization, they wish to plan ahead to determine what the cost of the keynote banquet ticket should be. The ticket cost then can be included in materials that will be sent out prior to the convention. The banquet coordinator has determined the following costs:
Rental of banquet facility $2,500
Entertainment for banquet $1,200
Cost of meal $12
Decorations $400
Printing costs $500
Favors per attendee $2
1. Given the above information and assuming no profit will be made, what ticket price should be set if 500 procrastinators attend? If 750 people attend?
2. If a ticket price of $35 is set, how many procrastinators need to attend for PA to break even on their banquet? If the ticket price was $50? Use the roundup function to round up to the next integer (eg. 344.24 would be 345)
3. If fixed costs can be reduced by 10%, what is the breakeven point (in number of attendees) if the ticket price is $35. Use the roundup function to round up to the next integer.
4. If PA wishes to make a profit of $1,000 on the banquet and the ticket price is $35, how many procrastinators need to attend? Assume that fixed costs do not change from the initial amounts. Use the roundup function to round up to the next integer.
5. Using Goal Seek:
a. How many attendees need to attend for the banquet to net EXACTLY $955 in profit (assuming $35 ticket price)? Format attendees to 5 decimal places.
b. For a breakeven, what should be the EXACT ticket price (do not round) if EXACTLY 455 attendees show up at the banquet. Format the ticket price to 5 decimal places.
c. Verify that your answers are correct by “plugging” the answers into an income statement
Please Show All Work,
|
What is the research problem the paper attempts to address
: What is the research problem the paper attempts to address
|
|
Change in depreciation affect net income in current year
: Assume you work as an assistant accountant in the head office of a national movie rental business, a la Blockbuster Inc. With the increasing popularity of online movie rental operations, your company has struggled to meet its earnings targets for the..
|
|
Write program that fills two arrays with number sequence
: Calculate the first 10 numbers of the sequence and place - Write a program that fills two arrays with the number sequence defined by the expression.
|
|
Describe how you would make two l of glycine buffer
: Describe how you would make 2L of a 0.1M glycine buffer, pH 9, using glycine and 1.0M NaOH. For glycine the pKa is 9.6.
|
|
Breakeven analysis procrastinators anonymous
: Breakeven Analysis Procrastinators Anonymous (PA) is hosting their annual convention this coming year in Dallas, TX. Although this is not typical of this organization, they wish to plan ahead to determine what the cost of the keynote banquet ticket s..
|
|
The expected return on any asset is dependent upon its beta
: The expected return on any asset is dependent upon its beta. Explain what Beta is, why it is used and its relevance to investment decisions.
|
|
Calculate the amount of budgeted purchases
: The pizza is expected to cost $4 per pizza. It expects to pay 70% in the month of purchase and the remainder in the following month. Calculate the amount of budgeted purchases for its first quarter.
|
|
Considering project which will provide annual cash inflows
: You are considering a project which will provide annual cash inflows of $4,500, $5,700, and $8,000 at the end of each year for the next three years, respectively. what is the net present value of these cash flows, given a 9 percent discount rate?
|
|
What spring scale register before elevator starts to move
: What does the spring scale register before the elevator starts to move, during the first 0.800 s, while the elevator is traveling at constant speed and during the time it is slowing down?
|