Budget Analysis

profiledesmond95
HFT3791PWPineappleBallBudget20141.xlsx

Pineapple Ball 2014

The Pineapple Ball - October 11, 2014
REVENUE STREAMS 2014 Projected 2014 Actual Notes
Sponsorships
Pineapple Pledge Level Five: $15,000 $30,000.00 Two Available
Pineapple Pledge Level Four: $10,000 $30,000.00 Three Available
Pineapple Pledge Level Three @$7,500 $22,500.00 Three Available
Pineapple Pledge Level Two @$5,000 $30,000.00 Unlimited, Budget to sell 6
Pineapple Pledge Level One (Tables) @ $3,000 $60,000.00 Unlimited, Budget to sell 20
Regular ticket sales at $175 each w/tax $22,400.00 Budget to sell: 128 (revenue: $164.32/ticket)
Total $194,900 $0.00
EXPENSES
COST TO DELIVER SPONSOR BENEFITS Projected Actual Notes
Level 5 F&B Cost $1,568.00 $98/person @ 16 guests
Level 4 F&B Cost $2,352.00 $98/person @ 24 guests
Level 3 F&B Cost $2,352.00 $98/person @24 guests
Level 2 F&B Cost $4,704.00 $98/person @ 48 guests
Level 1 F&B Cost $15,680.00 $98/person @ 160 guests
Level 5: taxes w/held from orig collected @ $231.48 each $462.96 Accounts for selling (2) at this level
Level 4: taxes w/held from orig collected @ $122 each $366.00 Accounts for selling (3) at this level
Level 3: taxes w/held from orig collected @ $122 each $366.00 Accounts for selling (3) at this level
Level 2: taxes w/held from orig collected @ $122 each $732.00 Accounts for selling (6) at this level
Level 1: taxes w/held from orig collected @$122 each $2,440.00 Accounts for selling (20) at this level
Individual tickets - taxes w/held from collection @ 10.68 each $1,367.04 Accounts for selling (128) at this level
Appreciation plaque for Levels 5,4 and 3 @ $50 each $400.00 If we sell as outlined above
Complete Meeting package to Level 5 @ $1,000 each $2,000.00 NEED TO ASK SEAIRA/estimated $1000 each x 2 sold
Total $34,790.00 $0.00
COST TO DELIVER SINGLE TICKET F&B Projected Actual Notes
Reception, Awards, Dinner package 12,544.00 128 guests @ $98/person total
Total $12,544.00 $0.00
SITE & SET Projected Actual Notes
Room Rental - Gatlin B/C, Gatlin B/C Foyer, Gatlin Reg, Galin Terrace 0.00 0.00 Comped per Harris Rosen/Amy Lenz
Overnight parking fees 126.00 Premila/Perry (2 nights each, total 4 nights). Leaves (2) nights for other staff (Dean?)
Easels 0.00 Estimated need of a few that will be comped by Shingle Creek
Table linen 1,200.00 Rental linen for 100 tables @ $12/table
Table overlays 700.00 Rental linen overlay for 100 tables @ $7/table
Table napkins 800.00 Rental napkin for 800 people (both rooms) @ $1/person
Chair covers 2,400.00 Rental chair covers for 800 chairs @ $3/chair
Chair sashes/tie backs` 1,200.00 Rental sashes/tie backs for 800 chairs @ $1.50/chair
Total $6,426.00 $0.00
AUDIO VISUAL/ELECTRICAL/RIGGING Projected Actual Notes
Labor - A/V techs $32,400.00 ROUGH Estimated 18 total @ $150/hour for 12 hours each (set up/break down, rehearse)
Staging, other equipment $0.00 Anticipating comped from PSAV
Total $32,400.00 $0.00
Hard Drive Production Company Projected Actual Notes
F&B for entertainment & labor personnel $2,940.00 $98/person @ 30 staff
Hotel stays $600.00 $99/night at a total of six rooming nights needed per Hardrive
Overnight parking for their staff @$21/night $126.00 $21/night for (6) room nights.
Design, calling the show, actors/actresses, props $80,000.00 Based on our conversations after seeing initial budget
Total $83,666.00 $0.00
Publicity & Materials Projected Actual Notes
Graphic Artist - All graphic word for all collateral/website $1,500.00 $75/hour. Estimated 20 hours
Save the Date - printing $0.00 $0.00 In house at Rosen
Save the Date - card stock $0.00 $0.00 In house at Rosen - card stock on hand
Invitation - electronic $0.00 $0.00 Electroincally sent via Kathy Dorf
Programs for event $800.00 Estimated 600 hard copy, heavy weight, glossy front, full color 5 x 7 - UCF Printing
Pineapple Pledge - card stock/printing $200.00 Estimated 600 cards needed in full color, maybe die cut. UCF Printing
Table tent cards $15.00 Estimated based on cost of card stock package. Print in house at Rosen
Place cards $15.00 Estimated 400 needed. Print in house at Rosen
Assigned seating chart near registration counter $50.00 Print one foam core sign - UCF Printing or Freeman?
Total $2,580.00 $0.00
Registration Projected Actual Notes
Preforated ticket for event admittance ? $1,200.00 Estimate 600 to be printed w/graphic work @ $2.00/ticket
Crystal pineapple, scarf or something for past/present honorees $400.00 Estimate 20 @ $20 each
Registration Software or Platform $0.00 $0.00 Using Foundation, no charge
Reg counter/headers (Freeman??) $700.00 Rough estimate based on CF charges. (2) counters w/headers including our logo
Total $2,300.00 $0.00
Student/Volunteer Needs Projected Actual Notes
Boxed dinner/snack $400.00 20 students @ $20/boxed dinner??
Uniform shirt (wear own slacks/skirts) $500.00 20 students wearing own bottoms and "our" shirt ordered from R'Devie @ $25 each
Transportation (staff, volunteers, vendors) 500.00 Estimated for one mini bus or coach to and from Rosen College/Shingle Creek (8 hours)
Total $1,400.00 $0.00
ROOM DÉCOR/CENTERPIECES Projected Actual Notes
Greenery across all three rooms $1,000.00 Plant rental from ???
Miscellaneous: special lighting, other props $4,000.00 Rough guess at this point. Might need extra props if Hardrive can't provide
Total $5,000.00 $0.00
Miscellaneous Projected Actual Notes
Contingency fund to cover unexpected items $5,000.00 $793.85 $793.85 printing invites $0.00
Total $5,000.00 $793.85
TOTALS Projected Actual Notes
Total Expenses Including Taxes and Gratuity $186,106.00 $793.85
Projected Balance (Profit/Loss) $8,794.00 -$793.85 Profit/Loss
*This does not take into account money collected via Pineapple Pledge Cards
*Budget is based upon 400 guests, our staff
student volunteers and other volunteers acconted for separately
** Anticipate being able to get many items with an 'in-kind'
sponsorship, but budgeted for what we think is worst case.

TPB Budget

The Pineapple Ball - October 11, 2014
REVENUE STREAMS Unit Price Expected Sales of # of Units 2014 Projected 2014 Actual Notes
Sponsorships
Pineapple Pledge Level Five $15,000.00 0 $0.00 $15,000.00 (as of 10/9/14 - 1 total)
Pineapple Pledge Level Four $10,000.00 0 $0.00 $0.00 (as of 10/9/14 - 0 sold)
Pineapple Pledge Level Three $7,500.00 2 $15,000.00 $7,500.00 (as of 10/9/14 - 1 total)
Pineapple Pledge Level Two $5,000.00 10 $50,000.00 $55,000.00 Unlimited sales (as of 10/9/14 - 11 total)
Pineapple Pledge Level One (Tables) $3,000.00 31 $93,000.00 $69,000.00 Unlimited sales (as of 10/9/14 - 23 total)
Regular ticket sales at $175 each w/tax $175.00 16 $2,800.00 $5,075.00 Total of 29 seats
Staff Tickets at $125 each w/tax $125.00 16 $2,000.00 $2,250.00 Total of 18 sold
Unsolilcited Donations $0.00 0 $0.00 $12,500.00 Massey: $500, Sysco: $1000, Covelli/Panera: $3000, Gatorland: $3000, Dick Nunis: $5,000
Total $162,800 $166,325.00
EXPENSES
COST TO DELIVER SPONSOR BENEFITS Unit Price Expected Sales of # of Units Projected Actual Notes
Level 5 F&B Cost $72.52 0 $0.00 $0.00 Accounted for in Cost to Pay Rosen Hotels
Level 4 F&B Cost $72.52 0 $0.00 $0.00
Level 3 F&B Cost $72.52 16 $1,160.32 $0.00
Level 2 F&B Cost $72.52 80 $5,801.60 $0.00
Level 1 F&B Cost $72.52 248 $17,984.96 $0.00
Level 5: taxes w/held from orig collected $231.48 0 $0.00 $231.48 Per each sponsorship sold (1 sold)
Level 4: taxes w/held from orig collected $122.00 0 $0.00 $0.00 Per each sponsorship sold (none sold)
Level 3: taxes w/held from orig collected $122.00 2 $244.00 $122.00 Per each sponsorship sold (1 sold)
Level 2: taxes w/held from orig collected $122.00 10 $1,220.00 $1,342.00 Per each sponsorship sold (11 sold)
Level 1: taxes w/held from orig collected $122.00 31 $3,782.00 $2,806.00 Per each sponsorship sold (23 sold)
In Kind donor F&B cost $72.52 26 $1,885.52 $0.00 LLP (2), Kirby (2), Cheryl Florist (4), Videographer (2), PSAV (8), Hardrive (8) COVERED IN ROSEN PMT
Individual tickets - taxes w/held from collection $10.68 16 $170.88 $501.96 Per invidivudal ticket sold, based on 29, plus the staff of 18 = 47
Appreciation plaque for Levels 5, 4, 3 $75.00 2 $150.00 $80.00 Total of 2 purchased
Total $32,399.28 $5,083.44 `
COST TO DELIVER SINGLE TICKET F&B Unit Price Expected Sales of # of Units Projected Actual Notes
Reception, Awards, Dinner package PD individual seats $72.52 16 1,160.32 0.00 Based on a total of 53 tickets 9/29/14
Comp tickets: 32 $72.52 48 3,480.96 0.00 Past HOF winner, Current HOF Winner, Abe/UCF, Planning Committee etc. (32)
Cost to pay Rosen Hotels $0.00 0 0.00 12,400.00 Includes: fire watch, hotel stays, parking, lamps, visqueen for bus, volunteer/band meals
Total $4,641.28 $12,400.00
SITE & SET Unit Price Expected Sales of # of Units Projected Actual Notes
Room Rental - Gatlin B/C, Gatlin B/C Foyer, Gatlin Reg, Galin Terrace $0.00 1 0.00 0.00 Comped per Harris Rosen/Amy Lenz
Overnight parking fees $21.00 6 126.00 0.00 Premila/Perry (2 nights each, total 4 nights). Leaves (2) nights for other staff (Dean?)
Hotel stays $99.00 2 198.00 0.00 Premila/Perry each (1) room, one night - COMPED
Easels $0.00 15 0.00 0.00 Comped via Shingle Creek
Table linen $12.00 100 1,200.00 0.00 Using in house linen at Shingle
Table overlays $7.00 100 700.00 0.00 Using in house linen at Shingle
Table napkins $1.00 800 800.00 0.00 Using in house linen at Shingle
Chair covers $3.00 800 2,400.00 2,438.42 Kirby: Chair covers/sash for both rooms, ropes/stanchions - delivered set RS/students drop and strike CC
Chair sashes/tie backs` $1.50 800 1,200.00 0.00 Included in above chair cover rental from Kirby
Total $6,624.00 $2,438.42
AUDIO VISUAL/ELECTRICAL/RIGGING Unit Price Expected Sales of # of Units Projected Actual Notes
Labor - A/V techs $150.00 216 $32,400.00 $35,368.00
Staging, other equipment $0.00 0 $0.00 $0.00
Total $32,400.00 $35,368.00
Hard Drive Production Company Unit Price Expected Sales of # of Units Projected Actual Notes
F&B for entertainment & labor personnel $80.00 10 $800.00 $0.00 Michael Andrews band and Latin Fusion COVERED IN ROSEN PAYMENT
Pizza and sodas for kids' choir $0.00 0 $0.00 $396.80 Pizza party before they went on stage
Hotel stays $99.00 6 $594.00 $0.00 6 room nights for Hardrive - COVERED IN ROSEN PAYMENT
Overnight parking for their staff @$21/night $21.00 6 $126.00 $0.00 COMPED
Design, calling the show, actors/actresses, props $50,000.00 1 $50,000.00 $50,000.00
Total $51,520.00 $50,396.80
Publicity & Materials Unit Price Expected Sales of # of Units Projected Actual Notes
Graphic Artist - All graphic word for all collateral/website $75.00 20 $1,500.00 $1,237.50 $75/hour. Estimated 20 hours
Save the Date - printing $0.00 0 $0.00 $0.00 In house at Rosen
Save the Date - card stock $0.00 0 $0.00 $0.00 In house at Rosen - card stock on hand
Invitation - electronic $0.00 0 $0.00 $0.00 Electroincally sent via Kathy Dorf
Programs for event $1.35 500 $675.00 $1,627.00 Heavy weight, glossy front, full color 5 x 7 - UCF Printing (used gold foil, preforation)
Pineapple Pledge - card stock/printing $0.50 500 $250.00 $0.00 Printing on the back of the program, using a card stock, preforation
Table tent cards $15.00 1 $15.00 $149.89 Total cost of all card stock used for table tents/etc
Place cards $15.00 2 $30.00 $0.00
Thank you notes (handwritten) to sponsors $0.00 0 $0.00 $122.59 Decided last minute to do gold foil pineapple stationery/handwritten notes
Assigned seating chart near registration counter $50.00 1 $50.00 $0.00 Printing of one, foam core sign: Didn't do this
Total $2,520.00 $3,136.98
Registration Unit Price Expected Sales of # of Units Projected Actual Notes
Preforated ticket for event admittance $2.00 600 $1,200.00 $45.16 Lump sum pricing from UCF Printing. Glossy, card stock, full color, no preforation
Crystal pineapple, scarf or something for past/present honorees $20.00 20 $400.00 $0.00 Ran out of time to do something for this year. Medal could not be produced.
Registration Software or Platform $0.00 1 $0.00 $0.00 Using Foundation, no charge
Reg counter/headers (Freeman) $0.00 0 $0.00 $0.00 No need for reg counters - use built in at hotel. Above signage donated by Freeman
Total $1,600.00 $45.16
Student/Volunteer Needs Unit Price Expected Sales of # of Units Projected Actual Notes
Boxed dinner/snack $10.00 40 $400.00 $0.00 Final cost - COVERED IN ROSEN PAYMENT
Uniform shirt (wear own slacks/skirts) $0.00 0 $0.00 $0.00 All students wear their own, professional attire
Transportation (staff, volunteers, vendors) $0.00 2 0.00 382.50 Mears provided shuttle duration of event at a discount
Total $400.00 $382.50
ROOM DÉCOR/CENTERPIECES Unit Price Expected Sales of # of Units Projected Actual Notes
Greenery across all three rooms $250.00 4 $1,000.00 $2,195.96 All greenery foyer, A, B, suwannee 11 from Wizard Connection
Miscellaneous: special lighting, other props $750.00 4 $3,000.00 $0.00 No additional needed
Centerpieces $0.00 0 $0.00 $882.00 Black/Gold Lamps from Shingle @ total fee as outlined for 59
Total $4,000.00 $3,077.96
Miscellaneous Unit Price Expected Sales of # of Units Projected Actual Notes
Contingency fund to cover unexpected items $2,500.00 1 $2,500.00 $1,442.95 $793.85 printing invites, $68.60 postage, $325 patent/trademark, $73 OC fire Rescue permit, $182.50 11th air star $0.00
Fire Marshall - County $0.00 0 $0.00 $0.00 COVERED IN ROSEN PAYMENT
On site radio use $0.00 0 $0.00 $0.00 COVERED IN ROSEN PAYMENT
Miscellaneous bus/visqueen labor $1,250.00 1 $1,250.00 $0.00 COVERED IN ROSEN PAYMENT
Krystal - Video for Mears and Landwirth after show $0.00 0 $0.00 $150.00
Krystal - Videographer for sponsor videos $0.00 0 $0.00 $771.75
Total $3,750.00 $2,364.70
TOTALS Projected Actual Notes
Total Expenses Including Taxes and Gratuity $139,854.56 $114,693.96
Projected Balance (Profit/Loss) $22,945.44 $51,631.04 Profit/Loss
*This does not take into account money collected via Pineapple Pledge Cards
*Budget is based upon 400 guests, our staff
student volunteers and other volunteers acconted for separately
** Anticipate being able to get many items with an 'in-kind'
sponsorship, but budgeted for what we think is worst case.
*** Entire budget is based on a total of 408 people in attendance

blank