You are producing an Indy 500 party for 500 guests in Las Vegas.

You are purchasing a band for an estimated cost of $3,000. You are estimating your racing flag

centerpiece cost (material and labor) to be $20 per table (50 tables). You are renting black and

white checked chair covers ($4.95 each) from a local linen company who will install the covers.

You are estimating your dragster car rental fees to be $850. You estimate the lights will

cost you $1,200, sound will cost you $1,500 and staging will cost you $700. You estimate

your tech labor to cost you $900. All of the room decor is owned by you, and you are

charging the client $1,800 for the room decor. You are assigning a cost of $400 for labor,

maintenance and storage to the decor. Your environmental entertainers include two Las

Vegas showgirls, four roller blade girls, and two pit crew members, costing you $300

each. Each environmental performer will need to be costumed. You are renting the

costumes from Williams Costume Shop at $65 per costume. You are charging your client

a mark-up of 20% (exception: room dcor, as it is owned by you)

However:

The linen company neglected to inform you of the additional $1.50-per-chair

installation cost

The showgirls will cost you $450 each

The labor came in at $800

Williams Costume Shop raised the price of their costumes to $80 each

However, the showgirl costumes are $150 each

Lights came in at $1,100

A $100 pick-up and delivery fee ($100 includes pick-up and delivery) was added to

the dragster car rental cost

All other costs were as estimated

REQUIRED (Excel file):

1.Fill in the attached Excel spreadsheet to calculate the profit on the event

2.What was your projected revenues over expenses (budgeted) dollar amount on this

event?

3.If the additional catering charges were $120 inclusive per-person, what ticket price would

need to be charged for this event to break-even?

4.What would the break-even ticket price need to be if this were a fund raising event that

needed to raise $68,000?

IMPORTANT NOTE: Show all your calculations (Excel file)

1. SPREADSHEET Fill in only the blue cells BUDGET Estimated costs REAL Actual costs Client cost Variance Profit/Loss Description 100 Entertainment 101 Band 102 Environment 200 Dcor 201 Centerpieces 202 Room Dcor 203 Dragster 204 Chair covers 300 Costumes 301 Entertainers 400 Tech 401 Sound 402 Lights 403 Staging 404 Labor TOTALS 2. Projected revenue over budgeted expenses (2 decimals) 3. Ticket price for breakeven (2 decimals) 4. New break-even ticket price (2 decimals) PLEASE SHOW ALL YOUR CALCULATIONS BELOW