BOTTOM OF GRAPH X: AXIS = NUMBER OF PEOPLE

Y - AXIS = TOTAL DOLLARS

SOLVE ALL

The Hartford Symphony Guild is planning its annual dinner and dance. The committee has assembled the following expected costs for the event: The committee members would like to charge $60 per person for the evening's activities. Required: 1. Compute the break-even point for the dinner and dance (in terms of the number of people who must attend). 2. Assume that last year 280 people attended the dinner and dance. If the same number attend this year, what price per ticket must be charged in order to break even? 3. Refer to the original data ( $60 ticket price per person). Prepare a CVP graph for the dinner and dance from a zero level of activity up to 700 tickets sold, in increments of 100. Number of people should be put on the horizontal (X) axis, and dollars should be put on the vertical ( Y ) axis. Instructions: 1. Use the line tool (Total Sales Revenue line, plot 2 points) to draw the total sales revenue line and extend the line to maximum in the graph. 2. Use the line tool (Total Expenses line, plot 2 points) to draw the total expenses line and extend the line to maximum in the graph. 3. Use the line tool (Total Fixed Expenses, plot 2 point) to draw the total fixed expenses line and extend the line to maximum in the graph. 4. Use the point tool (Break-Even Point, plot 1 point) to show the break-even point. 5. Once all points have been plotted, click on the line (not individual points) and a tool icon will pop up. You can use this to enter exact co-ordinates for your points as needed. 6. Plot the graph exactly using the tool to get full marks