6 see picture A garage band wants to hold a concert. The expected crowd is 2,900. The averageexpenditure on concessions is $30. Tickets sell for $25 each, and the band's profit is75% of the ticket and concession sales minus a fixed cost of $17,00O.A spreadsheet has been developed to calculate the band's expected profit:1 Expected Crowd2 Average Concessions Expenditure2,900 people$30 per person3 Fixed Cost$17,000$25 per person4 Ticket Price5 Profit Percentage75%6 Ticket Revenue7 Concession Revenue$72,500.00$87,000.00$102,625.008 ProfitWhat formula is used in cell B8 to calculate the Profit?Start your formula with an "=" sign, just as you would if you were entering theformula in Excel. Do not use any spaces in your formula.11.

Given Expected Crowd 2900 Average concession expenditure 30

A garage band wants to hold a concert. The expected crowd is 2,900. The average expenditure on concessions is $30. Tickets sell for $25 each, and the band's profit is 75% of the ticket and concession sales minus a fixed cost of $17,00O. A spreadsheet has been developed to calculate the band's expected profit: 1 Expected Crowd 2 Average Concessions Expenditure 3 Fixed Cost 2,900 people $30 per personi $17,000 $25 per person 4 Ticket Price 5 Profit Percentage 6 Ticket Revenue 75% $72,500.00 $87,000.00 $102,625.00 7 Concession Revenue 8 Profit What formula is used in cell B8 to calculate the Profit? Start your formula with an "=" sign, just as you would if you were entering the formula in Excel. Do not use any spaces in your formula.

A garage band wants to hold a concert. The expected crowd is 2,900. The average expenditure on concessions is $30. Tickets sell for $25 each, and the band's profit is 75% of the ticket and concession sales minus a fixed cost of $17,00O. A spreadsheet has been developed to calculate the band's expected profit: 1 Expected Crowd 2 Average Concessions Expenditure 3 Fixed Cost 2,900 people $30 per personi $17,000 $25 per person 4 Ticket Price 5 Profit Percentage 6 Ticket Revenue 75% $72,500.00 $87,000.00 $102,625.00 7 Concession Revenue 8 Profit What formula is used in cell B8 to calculate the Profit? Start your formula with an "=" sign, just as you would if you were entering the formula in Excel. Do not use any spaces in your formula.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Star Symphony would like to perform for a neighbouring city. Fixed costs for the performance total $5,000. Tickets will sell for $15 per person, and an outside organization responsible for processing ticket orders charges the symphony a fee of $2 per ticket. Star Symphony expects to sell 500 tickets. How many tickets must Star Symphony sell to break even? How many tickets must the symphony sell to earn a profit of $7,000? How much must Star Symphony have in sales dollars to break even? How much must Star Symphony have in sales dollars to earn a profit of $7,000? What is the symphony’s margin of safety in units and in sales dollars?
Concordia College is planning a concert. Maximum capacity for the concert venue is 3,000. tickets will be sold for $25 per ticket. The college estimates that costs of producing the concert to be 2,500 plus the cost of the band. Alternative A a fee of $8,000 and $5 per tickets; or Alternative B - $8.00 per ticket sold at what tickets sales level will the two proposal provide the same profite of loss result? 2.What is the breakeven point in terms of tickets sold for Alternative A 3. What is the breakeven point in terms of tickets sold for Alternative B (Use the Equation Method)? 4. If you expect to see 3,000 tickets, which alternative produces the highest profit?
Roseberg Theater sells tickets for dinner and a show for $60 each. The cost of providing dinner is $31 per ticket and the fixed cost of operating the theater is $65,000 per month. The company can accommodate 15,000 patrons each month. What is the contribution margin ratio? 51.67% 207% 48.33% 40.00%
The Marla and Kerry Theatre Group operates five discount movie theatres in the Chicago area. All tickets are priced at P1.75. Variable costs are P1.10 per patron, and the fixed costs per year total P900,000. The fixed costs include concessions, but the variable costs do not. The concessions earn an average contribution margin of P.60 per patron. a. How many patrons are required to break even? b. If 800,000 patrons are expected for the year, what ticket price would be necessary to earn a profit of P150,000? Determine the number of units to be sold of each of the products to breakeven.
Wild-Water Works Water Park provides for a fun day by offering a variety of rides. Wild-Water Works Water Park sells tickets at $74 per person as a one-day entrance fee. Variable costs per person are $34 and fixed cost amount to $222,300 per month.Wild-Water Works Water Park expects to sell 7,900 tickets. Find break-even first, then compute the margin of safety in tickets and sales in dollars.
A drive in movie theater has been selling popcorn, and the small concession stand has normally reported a monthly profit of $18,000 on sales of $48,000, fixed costs are currently about $18,000, and variable costs of $0.80 per popcorn order. Next year, the company plans to start selling pretzels for $4 each. Pretzels will have a variable cost of $0.92 and new equipment and personnel to produce nachos will increase monthly fixed costs by $7,288.80. Initial sales of pretzels should total 3,000 units per month. Determine the monthly break-even sales during the first month of pretzel sales, assuming a constant sales mix of 1 unit of pretzels and 3 units of popcorn.
The College is planning a concert. Maximum capacity for the concert venue is 3,000. tickets will be sold for $25 per ticket. The college estimates that costs of producing the concert to be 2,500 plus the cost of the band. Alternative A a fee of $8,000 and $5 per tickets; or Alternative B - $8.00 per ticket sold Question 1. If you expect to see 3,000 tickets, which alternative produces the highest profit?
Who Done It Mystery Theater sells tickets for dinner and a show for $55 each. The cost of providing dinner is $40 per ticket and the fixed cost of operating the theater is $100,000 per month. The company can accommodate 15,000 patrons each month. What is the contribution margin ratio?
- Gordon Helps is planning a function. There are two possible venues.• TCG club which have fixed rental cost of $2000 plus a charge of $50 per person for its own catering of meals andserving of drinks and hors d'oeuvres.• TT Hall, which have a fixed rental cost of $4000.The cost to hire a caterer for meals and drinks will cost $45 perperson.* Gordon Helps budget $4000 for admin and marketing. The band will cost a fixed amount of $3200. The tickets costfor this event is $200 per person. Requirement:• Compute the break even for each venue in term of tickets sold• Compute the operating income on the bill if 138- At what level of tickets sold will the two (2) venues have the same operating income?
Wild-Water Works Water Park provides for a fun day by offering a variety of rides. Wild-Water Works Water Park sells tickets at $79 per person as a one-day entrance fee. Variable costs per person are $33 and fixed cost amount to $131,000 per month.Wild-Water Works Water Park expects to sell 7,300 tickets. Estimate the operating income if sales increase by 15%.Calculate the degree of operating leverage.(Round your answers to two decimal places when needed and use rounded answers for all future calculations.)
A traveling production of The Lion KingThe Lion King performs each year. The average show sells 1 comma 2001,200 tickets at $ 50 per ticket. There are 125 shows each year. The show has a cast of 60, each earning an average of $ 320 per show. The cast is paid only after each show. The other variable expense is program printing costs of $ 8 per guest. Annual fixed expenses total $ 1,185,600 1. Compute revenue and variable expenses for each show. 2. Use the income statement equation approach to compute the number of shows needed annually to breakeven. 3. Use the shortcut unit contribution margin approach to compute the number of shows needed annually to earn a profit of $3,369,600 Is this goal realistic? Give your reason. 4. Prepare The Lion KingThe Lion King's contribution margin income statement for 125 shows each year. Report only two categories of expenses: variable and fixed.
Rocky Mountain Waterpark sells half of its tickets for the regular price of $75. The other half go to senior citizens and children for the discounted price of $35. Variable cost per guest is $15 for both groups, and fixed costs total $60,000 per month. What is Rocky Mountain’s breakeven point in total guests? Regular guests? Discount guests? a. 2,000; 1,000; 1,000 b. 800; 400; 400 c. 750; 375; 375 d. 1,500; 750; 750

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS