Budgeting for a New Route Launch

profileMike34
BudgetSpreadsheet.xlsx

Expenses

Launching a New Route for an International Airport [Date]
Event Budget for Aiport/Airlines Partnerhip: (name of your airlines here)
Social Networks Estimated Actual Actual Cost Breakdown
Twitter $500.00 $300.00
Facebook
Pintrest
Other Internet
Total $500.00 $300.00
Traditional Media Estimated Actual
Newspapers $200.00 $500.00
Magazines
Cable TV
Radio
Direct Mail
Total $200.00 $500.00
Publicity Estimated Actual
Graphics work $500.00 $800.00
Photocopying/Printing
Postage
Total $500.00 $800.00
Miscellaneous Marketing Estimated Actual Estimated vs. Actual
Telephone $500.00 $600.00
Transportation
Stationery supplies
Fax services
Total $500.00 $600.00
Event Management Estimated Actual
Food $600.00 $800.00
Drinks
Supplies
Staff and gratuities
Total $600.00 $800.00
Program Estimated Actual
Performers $300.00 $500.00
Speakers
Travel
Hotel
Other
Total $300.00 $500.00
Prizes Estimated Actual
Free Air Travel Certificates $200.00 $300.00
Other gifts
Total $200.00 $300.00
Total Expenses Estimated Actual
$2,800.00 $3,800.00
* The numbers in each category are fictitious and have been provided as an example.
Estimated Social Networks Traditional Media Publicity Miscellaneous Marketing Event Management Program Prizes 500 200 500 500 600 300 200 Actual Social Networks Traditional Media Publicity Miscellaneous Marketing Event Management Program Prizes 300 500 800 600 800 500 300

$3,800.00

Social Networks Traditional Media Publicity Miscellaneous Marketing Event Management Program Prizes 300 500 800 600 800 500 300

Made in Office 2007 for office2007.com

Income

Launching a New Route for an International Airport
Event Budget for Event Name: INCOME
Admissions Estimated Actual Income Comparison
Estimated Actual
300 100 Adults @ $5.00 $1,500.00 $500.00
200 50 Children @ $2.00 $400.00 $100.00
100 50 Other @ $1.00 $100.00 $50.00
$2,000.00 $650.00
Ads in program Estimated Actual
Estimated Actual
300 100 Covers @ $20.00 $6,000.00 $2,000.00
200 50 Half-pages @ $10.00 $2,000.00 $500.00
100 50 Quarter-pages @ $5.00 $500.00 $250.00
$8,500.00 $2,750.00
Exhibitors/vendors Estimated Actual
Estimated Actual
100 50 Large booths @ $20.00 $2,000.00 $1,000.00
100 10 Med. booths @ $50.00 $5,000.00 $500.00
50 2 Small booths @ $5.00 $250.00 $10.00
$7,250.00 $1,510.00
Sale of items Estimated Actual
Estimated Actual
400 300 Items @ $20.00 $8,000.00 $6,000.00
300 200 Items @ $15.00 $4,500.00 $3,000.00
200 100 Items @ $10.00 $2,000.00 $1,000.00
100 0 Items @ $5.00 $500.00 $0.00
$15,000.00 $10,000.00
Total Income Estimated Actual
$32,750.00 $14,910.00
Estimated Admissions Ads in program Exhibitors/vendors Sale of items 2000 8500 7250 15000 Actual Admissions Ads in program Exhibitors/vendors Sale of items 650 2750 1510 10000

Profit - Loss Summary

Launching a New Route for an International Airport September 18, 2008
Event Budget for Event Name: PROFIT/LOSS SUMMARY
Estimated Actual Profit vs. Loss
Total income $32,750.00 $14,910.00
Total expenses $2,800.00 $3,800.00
Total profit (or loss)
$29,950.00 $11,110.00
Total income Estimated Actual 32750 14910 Total expenses Estimated Actual 2800 3800