Need Sunday @ 7:30pm EST Event Budget

profileuniqueone1463
BudgetTemplate.xlsx
Home>Business & Finance homework help>Marketing homework help>Need Sunday @ 7:30pm EST Event Budget

Expenses

Blue zeros may remain if you chose to not allocate funds to that particular expense. Follow the instructions in individual blue cells to properly complete the template.
Category Item Quantity Unit Cost Total Cost
Social Media Ads 0 $0.50 $0.00
Industry specific pulication website banner ads 0 $2.00 $0.00
Print publication 0 $200.00 $0.00
Newspaper ad 0 $150.00 $0.00
Posters 0 $0.65 $0.00
Flyers 0 $0.15 $0.00
Invites (group 2 only) 0 $1.00 $0.00
Save the date (group 2 only) 0 $0.85 $0.00
Press Kits (group 2 only) 0 $3.65 $0.00
Misc. Printing Banners 0 $175.00 $0.00
Thank you notes (group 2 only) 0 $0.85 $0.00
Postage Invites (group 2 only) 0 $0.55 $0.00
Save the Date (group 2 only) 0 $0.55 $0.00
Thank you notes (group 2 only) 0 $0.55 $0.00
Entertainment enter "tier #" here 0 Insert a "0" or a selected amount from the cost sheet $0.00
Insurance Insurance 1 $250.00 $250.00
Venue enter "tier #" here 1 Insert a "0" or a selected amount from the cost sheet $0.00
Merchandise Game 300 $6.00 $1,800.00
Hats 0 $5.00 $0.00
In-Game Downloadable Assets 0 $1.00 $0.00
Posters 0 $2.00 $0.00
Limited edition artwork 0 $5.00 $0.00
Electronic Ticketing Ticketing fees 0 $1.00 $0.00
Audio Visual enter "tier #" here 0 Insert a "0" or a selected amount from the cost sheet $0.00
Food enter "tier #" here or leave blank 0 Insert a "0" or a selected amount from the cost sheet $0.00
Beverage enter "tier #" here or leave blank 0 Insert a "0" or a selected amount from the cost sheet $0.00
Promotional Items Lighters 0 $2.00 $0.00
Keychains 0 $1.50 $0.00
Download cards 0 $0.12 $0.00
Miscellaneous Contingency percentage $7,500 5%
Tech Support: Tech Support: Currently set at 5%. This can be increased up to 10% based on your preference.		 $375.00
Service charge $0.00 23% $0.00
Tax $1,800.00 7% $126.00
Fixed Expenses $2,551.00
Variable Expenses $0.00
Total Expenses $2,551.00

&"Verdana,Bold"Student Name:_x000D_USE FORMULAS TO CALUCALTE ALL CELLS_x000D_

Break-even calculations

Break-even Point Worksheet
Anticipated Number of Paying Participants 275
Total Fixed Expenses $2,551.00
Total Variable Expenses $0.00
Total Expenses Total Fixed Costs + Total Variable Costs
$2,551.00 $0.00
Total Expenses $2,551.00
Break-even Point = Total Costs ÷ Anticipated Number of Participants
$2,551.00 ÷ 275
Break-even Point = $9.28 Ticket price per person to break-even.
*To adjust the break-even point change the highlighted numbers. This will help you evaluate adjustments to your budget or attendance.

Income

Income Category Item Quantity Unit Price Total
Reserves Reserves 1 enter your reserve amount $0.00
Participants Ticket (to include the game) 275 enter your ticket price $0.00
Hat enter "0" or number that was budgeted in your expense budget $10.00 $0.00
In-Game Downloadable Assets enter "0" or number that was budgeted in your expense budget $10.00 $0.00
Poster enter "0" or number that was budgeted in your expense budget $8.00 $0.00
Artwork enter "0" or number that was budgeted in your expense budget $18.00 $0.00
Sponsorship Enter sponsor company name enter "0" or "1" enter monetary level of support $0.00
Enter sponsor company name enter "0" or "1" enter monetary level of support $0.00
Enter sponsor company name enter "0" or "1" enter monetary level of support $0.00
Enter sponsor company name enter "0" or "1" enter monetary level of support $0.00
Total Income $0.00
Total Income $0.00
Total Expenses $2,551.00
Sub Total -$2,551.00
Less Reserves $0.00
Total Profit -$2,551.00