Create excel answers to the question like the sample temples below to answer the questions.

The Public Budgeting and Finance Association is planning its annual conference. The conference hotel has quoted the following prices for services: Thursday afternoon Conference facilities rental: $425 Coffee-break service: $10 per person Audiovisual equipment rental: $55 Evening reception: $25 per person Friday Conference facilities rental: $750 Coffee-break service, morning and afternoon: $15 per person Continental breakfast: $15 per person Luncheon: $20 per person Audiovisual equipment rental: $150 Saturday morning Conference facilities rental: $375 Continental breakfast: $15 per person Coffee-break service: $10 per person Audiovisual rental: $75 Program materials and marketing would cost about $550. The association charged $130 for each participant last year and would like to use the same price this year. a. Prepare a break-even chart for the conference and determine the break-even attendance level. b. Suppose the association wanted to encourage student participation by charg- ing a rate that would cover only the costs directly caused by their attendance. What price would you charges Fised Costs 50 Facility Rentals Equipment Rentals Materials 300 100 200 50 200 100 700 250 1000 50 Subtotal Grand Total Break-Even Analysis Each attendee charge for: 350 uit variable cost 280 TR TC Attendees Fixed Cost Variable Cost Net Profit/ Loss 350 1,180 1 1,000 180 -830 700 1,360 2 1,000 360 -660 1050 1,540 3 1,000 540 -490 1400 1,720 4 1,000 720 320 1750 1,900 5 1,000 900 -150 2100 2,080 6 1,000 1,080 20 2450 2,260 7 1,000 1,260 190 2800 2,440 8 1,000 1,440 360 3150 2,620 9 1,000 1,620 530 3500 2,800 10 1,000 1,800 700 3850 2,980 11 1,000 1,980 870 Variable Costs coffee break Reception coffee break Breakfast Luncheon Breakfast coffee break Total per person 10 60 20 50 100 25 15 280 Total Costa 1000+(28.00 Total Revenue 350Q Total Cost = Total Revenue for Brcat Eren Variable costuit 280 Extra per participant 280 Fixed Cost 1000 Break-Even Point 3.571428571 350 Budget for 6 Attendees Revenue Expenses Conference Facilities AV Rental Materials and Marketing Food (meals and coffee) Profit Loss Amount 2,100 2,680 700 250 50 1,680 -580 The Public Budgeting and Finance Association is planning its annual conference. The conference hotel has quoted the following prices for services: Thursday afternoon Conference facilities rental: $425 Coffee-break service: $10 per person Audiovisual equipment rental: $55 Evening reception: $25 per person Friday Conference facilities rental: $750 Coffee-break service, morning and afternoon: $15 per person Continental breakfast: $15 per person Luncheon: $20 per person Audiovisual equipment rental: $150 Saturday morning Conference facilities rental: $375 Continental breakfast: $15 per person Coffee-break service: $10 per person Audiovisual rental: $75 Program materials and marketing would cost about $550. The association charged $130 for each participant last year and would like to use the same price this year. a. Prepare a break-even chart for the conference and determine the break-even attendance level. b. Suppose the association wanted to encourage student participation by charg- ing a rate that would cover only the costs directly caused by their attendance. What price would you charges Fised Costs 50 Facility Rentals Equipment Rentals Materials 300 100 200 50 200 100 700 250 1000 50 Subtotal Grand Total Break-Even Analysis Each attendee charge for: 350 uit variable cost 280 TR TC Attendees Fixed Cost Variable Cost Net Profit/ Loss 350 1,180 1 1,000 180 -830 700 1,360 2 1,000 360 -660 1050 1,540 3 1,000 540 -490 1400 1,720 4 1,000 720 320 1750 1,900 5 1,000 900 -150 2100 2,080 6 1,000 1,080 20 2450 2,260 7 1,000 1,260 190 2800 2,440 8 1,000 1,440 360 3150 2,620 9 1,000 1,620 530 3500 2,800 10 1,000 1,800 700 3850 2,980 11 1,000 1,980 870 Variable Costs coffee break Reception coffee break Breakfast Luncheon Breakfast coffee break Total per person 10 60 20 50 100 25 15 280 Total Costa 1000+(28.00 Total Revenue 350Q Total Cost = Total Revenue for Brcat Eren Variable costuit 280 Extra per participant 280 Fixed Cost 1000 Break-Even Point 3.571428571 350 Budget for 6 Attendees Revenue Expenses Conference Facilities AV Rental Materials and Marketing Food (meals and coffee) Profit Loss Amount 2,100 2,680 700 250 50 1,680 -580