Hartford Symphony Guild

Question: Hartford Symphony Guild is planning its annual Dinner dance. The dinner dance committee has assembled the following expected costs for the event:

Dinner (per person) …………………………. $ 20
Favors and program (per person) …………… 2
Orchestra …………………………………….. 2,000
Rental ballroom ……………………………… 900
Professional entertainment during intermission 1,000
Tickets and advertising ……………………… 1,300

The committee members would like to charge $ 35 per person for the evening activities.

1) Prepare a CVP graph for the dinner-dance from a zero level of activity up to 1000 tickets sold. Number of persons should be placed on the horizontal (x-axis), and dollars should be placed on the vertical (y-axis). What is the break-even point – persons and dollars (from your graph)? Use the graph to answer the following questions.

2) If the selling price goes up to $40, what is the new breakeven point – persons and dollars?

3) Management has decided to make some improvements that will push: Rental of the ballroom by $1,000, Professional entertainment during intermission by $2,000, and Tickets and advertising by $1,000. The Selling price is $40. What is the new break-even point – persons and dollars?

Draw three separate graphs in different worksheets name them QUES1, QUES2 and QUES3.

Put Selling Price, Variable Price and Fixed Price in three distinct cells so that you can make use of their cell references in the tables. Any variations on any of these cells will have an automatic effect on both the tables and graphs.

We help you get better grades, improve your productivity and get more fun out of college!!

Do my Assignment for me

Day(s)

:

Hour(s)

:

Minute(s)

:

Second(s)

How it works – it’s easy

Y

Place your Order

Submit your requirements through our small easy order form. Be sure to include and attach any relevant materials.

Make a payment

The total price of your order is based on number of pages, academic level and deadline.

i

Writing process

We assign the assignment to the most qualified tutor. When the tutor completes the assignment, it is transferred to one of our professional editors to make sure that the assignment meets all of your requirements.

Once complete, we’ll send your assignment via the email provided on the order form.

 

 

Achieve academic success with the best online tutors.