In preparation for this assignment, consult the Providence T.F. Green Airport (h

In preparation for this assignment, consult the Providence T.F. Green Airport (https://www.providence-airport.com) website.
Read the following articles:
Air Service Development Fund (Warwick Beacon) https://warwickonline.com/stories/4-airlines-get-3375m-to-promote-16-new-routes-irish-trade-mission-slated,127652
How to… market new routes as an airline (Routes Online) https://aviationweek.com/air-transport/airports-networks/how-market-new-routes-airline
(Optional: Blog Articles for Marketing Ideas) Aviation Marketing Insights (Simplifying) https://issuu.com/airlinemarketingmonthly
You are hired as a marketing intern at Green Airport. It’s your first week on the job, and your boss just walked into your office announcing the recipients of the Air Service Development Fund—a $3.375 million incentive program to promote 16 new routes. The challenge is “Airlines open new routes every day but don’t always market them effectively” (Routes Online, 2017, para 2). Your boss has asked you to put your marketing knowledge to the test and develop a budget to assist one of the four airlines with a launch campaign to promote one of their new domestic air travel routes. The commercial route will transport both passengers and cargo.
Your budget to promote this launch was $200,000 (which included a 10% contingency for unexpected costs). As you develop the breakdown of estimated expenses, remember to consider the role of public relations and aviation interest groups in your launch strategy. Thankfully, your superior management skills resulted in actual expenses of $5,000 under budget.
Additionally, your boss said the anticipated revenue forecast after six months was $1,000,000. According to IATA (https://www.iata.org/en/programs/cargo/). (2018), on average, the cargo business generates 9% of airline revenues, representing more than double the revenues from the first-class segment.
Six Months Later
Your boss is asking for a summary of the launch event. This requires two components: A budget spreadsheet and a two-page business memo.
1) Budget Spreadsheet
Document the estimated and actual costs using the Budget Spreadsheet attached.
Note: The template content (campaign tactics, income sources, and figures) are examples and should be updated during the planning process to align with your campaign strategy.
2) Two-Page Business Memo
Explain the differences between the estimated and actual expenses.
Reveal whether the new route launch campaign was successful. Provide rationale by referencing components within the budget spreadsheet.