Riipen

Category Market research + 3

Financial Model & Forecast

Internship Overview Interns: 1 Time Commitment for Each Intern: at least 13 hours/week Total Project Length: 4-6 weeks Project Overview We are building a brand-new approach to worldwide consumer marketing. Our service is currently in development and therefore in "stealth mode". We need a financial model that will help us understand our market, our business model and our value proposition for participants. Objective We need to design & build a financial model in Excel that will integrate macro-level (aka industry-wide) information regarding marketing expenditures and micro-level information regarding spending decisions by individual marketers, allow us to fine-tune assumptions over time, and output a complete financial forecast. Understanding our business model will be critical to helping fine-tune assumptions, creating meaningful KPIs and teasing actionable business intelligence from the model. Project Details This project will include: Spending time with our team to understand at a high level the service we are working to build and the marketplace in which it operates; Reviewing our existing analysis of macro- and micro-level marketing expenditures; Developing the high-level methodology that will drive the forecast and working with our team to refine that methodology; Building a detailed and flexible financial model that implements the final methodology; Working with our team to review & revise that model; and Doing a live presentation to explain that model to our team upon project completion. This will be a monthly 5-year model that rolls up into quarterly, annual, and trailing-12-month reports. It will include tabs for assumptions, revenue build-up, income statement, balance sheet, cash flows, schedules/supporting details and KPIs. We will give you access to organizational assets to support this project such as personnel, brand collateral and more. In addition, there will be opportunities to augment the modeling work with smaller projects around business strategy, competitive intelligence and technology selection. This project requires strong skills in financial modeling, financial analysis, accounting, communication and teamwork. In addition, the model will be built in Microsoft Excel, so a high level of experience and proficiency in Excel is required.

Matches 0

Financial Model & Forecast

Category Market research + 3

Level UP: Financial Model & Forecast

Level UP Internship Overview # of Teams: 1 Interns Per Team: 2-4 Time Commitment for Each Intern: at least 13 hours/week Total Project Length: 4-6 weeks Project Overview We are building a brand-new approach to consumer marketing. Our service is currently in development and therefore in "stealth mode". We need a financial model that will help us understand our market, our business model and our value proposition for participants. Objective We need to design & build a financial model in Excel that will integrate macro-level (aka industry-wide) information regarding marketing expenditures and micro-level information regarding spending decisions by individual marketers, allow us to fine-tune assumptions over time, and output a complete financial forecast. Project Details This project will include: Spending time with our team to understand at a high level the service we are working to build and the marketplace in which it operates; Reviewing our existing analysis of macro- and micro-level marketing expenditures; Developing the high-level methodology that will drive the forecast and working with our team to refine that methodology; Building a detailed and flexible financial model that implements the final methodology; Working with our team to review & revise that model; and Doing a live presentation to explain that model to our team upon project completion. This will be a monthly 5-year model that rolls up into quarterly, annual, and trailing-12-month reports. It will include tabs for assumptions, revenue build-up, income statement, balance sheet, cash flows and schedules/supporting details. We will give you access to organizational assets to support this project such as personnel, brand collateral and more. This project requires strong skills in financial modeling, financial analysis, accounting, communication and teamwork. In addition, the model will be built in Microsoft Excel, so a high level of experience and proficiency in Excel is required.

Category Market research + 3

Level UP: Competitive Analysis (Phase 2)

Level UP Internship Overview # of Teams: 1 Interns Per Team: 2 (interns can be from different schools) Time Commitment for Each Intern: half-time (20 hours/week) Total Project Length: 4 weeks Project Overview We are building a brand-new approach to consumer marketing that does not currently exist "in the wild". Having said that, there are a number of existing companies that have products or services that cover a portion of what we are building, and other companies that have announced adjacent projects that have not yet launched. It is critically important for us to have a better understanding of each of these companies, what features and benefits they offer, who they are owned by, who the founders are, what their launch status is and what their funding status is. This will impact both our development plans as well as our fundraising direction. Objective We hope to gain a comprehensive understanding of the current and potential competitors in or adjacent to our space and how we can differentiate ourselves through our product/service offering, and our messaging. We will give you access to organizational assets to support this project such as personnel, brand collateral and more. We will suggest names of potential competitors to get you started. We will provide you with a pre-built Excel model to use as a starting point for your matrix of features/benefits. Phase 1 Details This phase of the project will include: Spending time with our team to understand at a high level what we are working to build; Doing research to identify companies that currently offer competing or adjacent products/services or are reputed to be launching shortly; and Doing a deep dive to understand each of those companies, including their ownership structure, founders, funding status, development stage, corporate partnerships/customers, target audience, revenue model and features/benefits. Phase 2 Details This phase of the project will include: The creation of a matrix identifying features and benefits shared across the companies and those that are different, and listing the characteristics of each company; and A narrative summary of each such company with supporting materials (which could include a SWOT analysis, website screenshots, quotes from articles, app screenshots, etc.). Note Regarding Phase 1 / Phase 2 This project has 2 related Riipen posts: "Level UP: Competitive Analysis (Phase 1)" and "Level UP: Competitive Analysis (Phase 2)". This was done so that the 2 interns could work either at the same time or sequentially. If 2 interns are going to work at the same time as a team, they can both apply to the other post (Phase 1). If 2 interns are going to work sequentially, they can also both apply to the other post (Phase 1). But if a single intern would like to apply to complete the entire project, that student should apply to BOTH this post (Phase 2) and the other post (Phase 1).

Level UP: Animate & Produce Explainer Videos

Level UP Internship Overview # of Teams: 1 Interns Per Team: 1 Time Commitment: half-time (20 hours/week) Total Project Length: 4 weeks (80 hours total) Project Overview We are building a brand-new approach to consumer marketing. Our service is currently in development and therefore in "stealth mode". We will eventually need a simple way to introduce our service to 3 different groups of people. To do this, we would like to create 3 animated explainer videos that are each 1-2 minutes in length to tell our story in a way that is appropriate and compelling for each group. We have broken down the creation of these videos into 2 separate projects. The first project is creating the stories and writing the scripts for these videos. The second project consists of taking those scripts and creating the videos. We are open to one student tackling both projects if they possess the right mix of skills and experience, but think it is more likely that we will end up with separate teams. This listing is for the second project only (animation & production) . If you are also interested in the first part, please search the Riipen projects for “Level UP: Written Content for Explainer Videos” and apply for that project separately. Objective This 1-person team will take 3 previously written scripts and turn them into 3 separate 1-2 minute explainer videos. Project Details This project will include: Spending time with our team to understand at a high level the service we are working to build, who the audiences are for the 3 videos and what we want the videos to communicate; Reading the scripts created by the writing team and reviewing their creative notes; Building on the work of the writing team, you will pitch a graphic look/feel that you would like to use to bring the scripts to life (should be consistent across videos), including style, colors, fonts, characters, etc.; Getting buy-in regarding the software/platform to be used for creation, presenting pros/cons of available options (note that we have a strong preference for software that is part of the Adobe Creative Cloud suite); Storyboarding all scenes; Creating style frames to insure we are all on the same page with the visual direction; Creating major graphical elements that will be used across videos; Making recommendations regarding required voiceover talent, music and sound; and Creating the final explainer videos (including delivery of all component parts). We will give you access to organizational assets to support this project such as personnel, brand collateral and more. This project requires strong skills in animation, graphic arts and video production along with great empathy to understand what each audience is looking for and therefore how to deliver it.

Level UP: Written Content for Explainer Videos

Level UP Internship Overview # of Teams: 1 Interns Per Team: 2 (interns can be from different schools) Time Commitment for Each Intern: half-time (20 hours/week) Total Project Length: 4 weeks (80 hours total per intern) Project Overview We are building a brand-new approach to consumer marketing. Our service is currently in development and therefore in "stealth mode". We will eventually need a simple way to introduce our service to 3 different groups of people. To do this, we would like to create 3 animated explainer videos that are each 1-2 minutes in length to tell our story in a way that is appropriate and compelling for each group. We have broken down the creation of these videos into 2 separate projects. The first project is creating the stories and writing the scripts for these videos. The second project consists of taking those scripts and creating the videos. We are open to one student tackling both projects if they possess the right mix of skills and experience, but think it is more likely that we will end up with separate teams. This listing is for the first project only (content creation) . If you are also interested in the second part, please search the Riipen projects for “Level UP: Animate & Produce Explainer Videos” and apply for that project separately. Objective This 2-person team will collaborate to write the scripts for 3 separate 1-2 minute explainer videos. Project Details This project will include: Spending time with our team to understand at a high level the service we are working to build, who the audiences are for the 3 videos and what we want the videos to communicate; Researching different explainer video styles to get a feel for how our videos should look & feel; Developing story ideas for each video, pitching those ideas to the company (possibly including reference to explainer videos for other companies that you think have the right feel) and integrating feedback to develop a final story for each; Outlining each story, including the amount of screen time that will be spent on each section and the key messages for each section, the characters to be featured, etc.; Writing the full script for each story, which should read like a fully-detailed script for a feature film; Making recommendations regarding the type of person for each voice role and the background music; and Preparing detailed creation notes to hand off to the animation/production team. We will give you access to organizational assets to support this project such as personnel, brand collateral and more. This project requires strong skills in creative writing and great empathy to understand what each audience is looking for and therefore how to deliver it.

Level UP: Website Design & Construction

Matches 2

Level UP: Competitive Analysis (Phase 1)

Level UP Internship Overview # of Teams: 1 Interns Per Team: 2 (interns can be from different schools) Time Commitment for Each Intern: half-time (20 hours/week) Total Project Length: 4 weeks Project Overview We are building a brand-new approach to consumer marketing that does not currently exist "in the wild". Having said that, there are a number of existing companies that have products or services that cover a portion of what we are building, and other companies that have announced adjacent projects that have not yet launched. It is critically important for us to have a better understanding of each of these companies, what features and benefits they offer, who they are owned by, who the founders are, what their launch status is and what their funding status is. This will impact both our development plans as well as our fundraising direction. Objective We hope to gain a comprehensive understanding of the current and potential competitors in or adjacent to our space and how we can differentiate ourselves through our product/service offering, and our messaging. We will give you access to organizational assets to support this project such as personnel, brand collateral and more. We will suggest names of potential competitors to get you started. We will provide you with a pre-built Excel model to use as a starting point for your matrix of features/benefits. Phase 1 Details This phase of the project will include: Spending time with our team to understand at a high level what we are working to build; Doing research to identify companies that currently offer competing or adjacent products/services or are reputed to be launching shortly; and Doing a deep dive to understand each of those companies, including their ownership structure, founders, funding status, development stage, corporate partnerships/customers, target audience, revenue model and features/benefits. Phase 2 Details This phase of the project will include: The creation of a matrix identifying features and benefits shared across the companies and those that are different, and listing the characteristics of each company; and A narrative summary of each such company with supporting materials (which could include a SWOT analysis, website screenshots, quotes from articles, app screenshots, etc.). Note Regarding Phase 1 / Phase 2 This project has 2 related Riipen posts: "Level UP: Competitive Analysis (Phase 1)" and "Level UP: Competitive Analysis (Phase 2)". This was done so that the 2 interns could work either at the same time or sequentially. If 2 interns are going to work at the same time as a team, they can both apply to this post (Phase 1). If 2 interns are going to work sequentially, they can also both apply to this post. If a single intern would like to apply to complete the entire project, that student should apply to BOTH this post (Phase 1) and the other post (Phase 2).

Matches 2

Consumer Marketing Aggregate Spending Analysis

It is estimated that marketers will spend $1.3 trillion in 2020 on media and marketing services. By any measure, that is a great deal of money. Where will all those dollars go? If we look at the total amount spent on consumer marketing, how does it break down by type of spend, intended distribution channel and region? For example, type of spend could be broken down into content creation, targeting, production/delivery, and validation. Distribution channel could be broken down into different forms of media (internet, TV, radio, magazine/newspaper, etc.) versus marketing services (sales promo, telemarketing, direct mail, events, etc.). The “internet” category is important enough that it merits further breakdown (e.g., search, video, desktop web, mobile web, app, etc.). How much of these costs were paid directly by marketers versus purchased through agencies, and what was the associated markup? This data set should be built out by geography, starting with US/NA, then Europe, etc., and finally global. This is a top-down analysis. The resulting data set and analysis will provide groundbreaking visibility into the world of consumer marketing.

Matches 0

Brand Identity, Graphical Design and App GUI For Startup-GU

If we’re being kind, we would call our startup's app design "functional". If we are being honest, perhaps "rough" or even "ugly". As for our choice of colors and fonts, "sophomoric". Ditto for our logo. And don’t even get us started on how well the app implements our UI/UX vision, which is ill-defined. As you can see, we need some branding and graphic design help! This is an opportunity for students to really dig in to a greenfield startup in an emerging industry and have a meaningful impact on the consumer-facing elements of our brand. App design to-date has been done in Adobe XD with graphical elements generally built in Illustrator and Photoshop. If there is a good fit, this project could lead to a second in which the brand is extended to the business-facing portions of our interface and identity.

Matches 2

Brand Identity, Graphical Design and App GUI For Startup-Suffolk

Brand Identity, Graphical Design and App GUI For Startup

Matches 0

Consumer Marketing Aggregate Spending Analysis-Rochester

Unit Economics of Marketing to Consumers-MacEwan

Every day, marketers face the same basic question: How much should I spend to get a specific offer in front of a specific consumer (or specific type of consumer), and what is my expected return on that investment? How should I allocate that spend by type of offer & distribution channel, and how does expected efficiency and ROI differ by type/channel? For example, if you type “warm winter socks” into Google, you will be greeted with a plethora of ads for that product type. When this description was written, one ad was from HeatHolders. How much did HeatHolders pay to show me that ad? How much did they pay when I clicked on it? What is their expectation of the percent of people who see the ad that will click on it, and the percentage of those that click who will actually buy? How much did they spend to create the ad/offer? How much did they spend to target it, and how much to deliver it? How many data sources did they utilize, and how robust was their targeting? That is a single example based on a search query, but illustrates our vision of how to build out a model of unit-economics in the marketing space. The results will look quite different for app-based digital ad delivery, TV, radio, print, direct mail, couponing, etc. This research will require both bottoms-up and top-down analysis.

Brand Identity, Graphical Design and App GUI For Startup-Mohawk