Finance
Project: Find a database with financial data and write a creative case around the data. Use the Pivot Table function in Excel, to create solutions to the given problem at hand.
- This is a summary version of the quick case study I created.
Human Resource Management
Project: Critique a job posting and develop a performance appraisal.
|
Job Posting: Assistant Coordinator, Sport & Athlete Services
|
Sponsorship
Project:
Asset Inventory: The asset inventory was created in Excel and included the asset categories for signage, intellectual property, naming rights, merchandise, media, and entertainment. The table included an asset name, asset ID #, feature, function, benefit, quantity, cost of asset, cost note, value, and value note. A cost page allowed us to visualize the supplier, cost per item, and total cost of the assets. A value note page allowed us to the total value of our assets by using value per impression, total impressions per sponsor, value per sponsor, cost per 1000, and quantity available. These metrics allowed us to create a gold, silver, and bronze sponsorship packages.
Sponsorship Proposal: The sponsorship proposal includes a letter to introduce the event and its history, our goals, and the promotional benefits. An executive summary is used to describe the event and the sponsorship benefits. The event property details include the history of the event, our mission, goals, and objectives, and capabilities of the event, as well as the date, time, location, projected attendance, and ticket cost. The proposal continues to go into great detail about the target markets and promotional plan. Creative leverage ideas such as sponsorship needs, resolutions, and good corporate social responsibility are then introduced. Finally, the proposal discusses our budget and investment in detail.
- Part 1: Create an asset inventory for an event that you will host in the Niagara Region.
- Part 2: Create a sponsorship proposal.
Asset Inventory: The asset inventory was created in Excel and included the asset categories for signage, intellectual property, naming rights, merchandise, media, and entertainment. The table included an asset name, asset ID #, feature, function, benefit, quantity, cost of asset, cost note, value, and value note. A cost page allowed us to visualize the supplier, cost per item, and total cost of the assets. A value note page allowed us to the total value of our assets by using value per impression, total impressions per sponsor, value per sponsor, cost per 1000, and quantity available. These metrics allowed us to create a gold, silver, and bronze sponsorship packages.
Sponsorship Proposal: The sponsorship proposal includes a letter to introduce the event and its history, our goals, and the promotional benefits. An executive summary is used to describe the event and the sponsorship benefits. The event property details include the history of the event, our mission, goals, and objectives, and capabilities of the event, as well as the date, time, location, projected attendance, and ticket cost. The proposal continues to go into great detail about the target markets and promotional plan. Creative leverage ideas such as sponsorship needs, resolutions, and good corporate social responsibility are then introduced. Finally, the proposal discusses our budget and investment in detail.
Marketing
Project: Following the National Hockey League has announced that Seattle will be getting an expansion franchise to begin play for the 2021-2022 season, your group has been hired by the Seattle ownership group to develop the team’s marketing and fanbase. Your job is to develop a marketing plan to target the city’s rapidly-growing population in order to build the team’s fan-base and market the team to a burgeoning, diverse city.
Task: To work as marketing consultants for the Seattle ownership group. Produce a sport marketing plan for the employer and include recommendations for a comprehensive sport marketing mix strategy, according to the market research conducted. Identify which best corresponds with the core consumer segment(s).
Vision and Objectives: The Seattle Kraken are proud to be the thirty-second franchise in the National Hockey League (NHL). Our mission is to bring the sport of professional hockey to the American northwest and run the franchise in such a way that represents the people and the culture of the city of Seattle. The Kraken’s immediate financial goal is to be a top 10 NHL team in terms of value after our second season. This objective is measurable through the yearly NHL franchise valuation by Forbes. The Kraken will accomplish both these goals through partnerships with successful, relevant Seattle based companies.
Position Analysis: The history of hockey in Seattle is important to understand our position when trying to market an NHL expansion team. Given the achievements that the city of Seattle experienced the with the Metropolitans as a professional hockey team and considering how close they were to getting an NHL expansion team in 1976 means that becoming the 32nd NHL franchise means a lot to the city.
Formulation and Selection: The Seattle Kraken have decided to partner with Seattle based companies such as Amazon, Microsoft, Starbucks, and Boeing. As well as Kraken Black Spiced Rum. All the companies that the Kraken are partnering with will be beneficial in contributing to the marketing scheme of the franchise as a whole.
Implementation & Management:
Evaluation and Change: Evaluating and making the necessary changes to be a successful organization.
Highlights:
Task: To work as marketing consultants for the Seattle ownership group. Produce a sport marketing plan for the employer and include recommendations for a comprehensive sport marketing mix strategy, according to the market research conducted. Identify which best corresponds with the core consumer segment(s).
Vision and Objectives: The Seattle Kraken are proud to be the thirty-second franchise in the National Hockey League (NHL). Our mission is to bring the sport of professional hockey to the American northwest and run the franchise in such a way that represents the people and the culture of the city of Seattle. The Kraken’s immediate financial goal is to be a top 10 NHL team in terms of value after our second season. This objective is measurable through the yearly NHL franchise valuation by Forbes. The Kraken will accomplish both these goals through partnerships with successful, relevant Seattle based companies.
Position Analysis: The history of hockey in Seattle is important to understand our position when trying to market an NHL expansion team. Given the achievements that the city of Seattle experienced the with the Metropolitans as a professional hockey team and considering how close they were to getting an NHL expansion team in 1976 means that becoming the 32nd NHL franchise means a lot to the city.
Formulation and Selection: The Seattle Kraken have decided to partner with Seattle based companies such as Amazon, Microsoft, Starbucks, and Boeing. As well as Kraken Black Spiced Rum. All the companies that the Kraken are partnering with will be beneficial in contributing to the marketing scheme of the franchise as a whole.
Implementation & Management:
- Draft day, Home Opener, Community Engagement Events, Theme Nights and Giveaways
- Get kids into the game by sponsoring youth teams, sending players to interact with school to build relationships.
- Environmental Sustainability
- Loyalty Program and Ticket Packages
Evaluation and Change: Evaluating and making the necessary changes to be a successful organization.
Highlights:
- This 95-page group project was completed in my second year (March, 2019).
- Seattle ownership officially announced the team would be named the Kraken in July, 2020.
Event Management
|
|