Module 8 Assignment This Module Assignment is a little different than previous Module Assignments. You will apply skills you learned in your School of Business prerequisites (specifically math, business communication, accounting/finance/Excel, and lower-division business classes) to a "real world" marketing scenario. I will be evaluating two of the Undergraduate Business Program Learning Goals, Problem Solving & Decision Making and Business Communication (LG1 & LG3). Detailed formatting guidelines and grading rubrics for each Learning Goal can be found at the end of this document. You are a digital marketing intern at a small footwear company located in Portland, OR. You have been asked to evaluate the financial performance of your social media advertising campaigns and make recommendations about how to allocate your digital advertising budget. Your manager gave you the following information: Online sales earn a 12% profit margin. Your monthly social media advertising budget is $20,000 You currently allocate 30% to Facebook, 30% to Instagram, 20% to TikTok, and 20% to Twitter. Part 2: Executive Summary Now that you have completed your Marketing Data Analysis, consolidate your findings into a 1- page executive summary. I have provided a couple examples attached to the Assignment Dropbox. You should at least answer the following questions in your executive summary: How is our social media advertising performing? Should we increase our social media advertising budget? Why/why not? Should we allocate more of our budget to a specific platform? Which one(s)? Why? . Should we allocate less of our budget to a specific platform? Which one(s)? Why? Should we allocate more of our budget to specific days of the week? Which one(s)? Why? Should we allocate less of our budget to a specific day of the week? Which one(s)? Why? . . Bonus Question: If we didn't increase our total budget, but we allocated the funds from the worst performing platform to our best performing platform (to the best performing day of the week) how would it impact our total ROAS? (Pro Tip: You will need to make a copy of the original data, modify the data based on your findings, and recalculate ROAS). PHOTO HOTODE Final Deliverables: 1. Submit your Executive Summary (1 page + appendices) to the Module 8 Executive Summary dropbox. Grading: Your grade will be based on four criteria: 1. Your executive summary (based on the Learning Goals 3: Business Communication Rubric) 2. Your answers to the questions in your Executive Summary Pro Tip: Don't always just paste screenshots of excel cells into your executive summary. Use graphs when they are appropriate. *Review the Learning Goal objectives and rubrics below for guidelines and expectations of this assignment. Learning Goal 1: Problem Solving & Decision Making Graduates of the Business Administration Baccalaureate program will have the capacity to recognize and understand a wide range of common and novel business problems and to follow a systematic approach to solve them effectively. Learning Objectives: 1. Problem definition: Students will construct clear and specific problem statements using contextually relevant evidence. 2. Research techniques and data analysis: Students will employ in-depth information and data from relevant sources throughout the problem-solving process. 3. Solution evaluation: Students will thoroughly evaluate solutions from multiple dimensions using appropriate analytical tools. 4. Decision making: Students will make decisions based on a synthesis of research, data analysis, and evaluation of solutions. Exceeds Expectations Meets Expectations Does Not Meet Expectations Problem definition Clearly and thoroughly defines the problem using most relevant contextual factors. Sufficiently defines the problem using most relevant contextual factors. Does not construct a clear problem statement. Research techniques & data analysis Organizes and synthesizes in- depth data and information from a wide range of research resources. Thorough synthesis of data and information. Uses a range of sources and a range of analytical tools. Evidence of synthesis of data and information from these Does not use relevant data or analytical tools appropriately. sources. Insufficiently Solution evaluation evaluates solutions. Thoroughly evaluates solutions in an elegant manner with creative consideration of relevant factors. Sufficiently evaluates solutions in an adequate manner with appropriate consideration of relevant factors. Decision Cogently presents decisions, Sufficiently presents Does not present a reasonable or decisions based on a basic making using a rich synthesis of research, data analysis, and evaluation of solutions. synthesis of research, data appropriate decision. analysis, and evaluation of solutions Learning Goal 3: Business Communication Graduates of the Business Administration Baccalaureate program will effectively communicate complex information with a variety of stakeholders to increase knowledge and achieve objectives. Learning Objectives: 1. Context, purpose and audience: Students will demonstrate a thorough consideration of context, purpose, and audience in the communication. 2. Manner of presentation: Students will present a central message in a clear, concise, and convincing manner. 3. Delivery of complex information: Students will skillfully articulate complex information in a manner that allows the message to be understood by multiple stakeholders. 4. Use of sources: Students will demonstrate a consistent use of credible, relevant sources that supports the message or credibility of the communicator. Exceeds Expectations Meets Expectations Does Not Meet Expectations Context, purpose & Demonstrates a thorough and creative understanding of context, audience, and purpose. Demonstrates adequate consideration of context, audience, and purpose. audience Does not demonstrate appropriate attention to context, audience, and purpose. Does not present the message in a clear or appropriate manner. Manner of presentation Message is skillfully delivered with a clear, concise and. persuasive authority. Very professional. Message is delivered in a clear and concise manner. Demonstrates consistent use of professional communication conventions. Articulates complex information in an appropriate way that it can be understood by the targeted audience. Delivery of complex information Skillfully conveys complex information that is easily understandable by the targeted audience. Delivery engages and teaches. Does not synthesize complex information. or deliver it in a manner that can be understood by the targeted audience. Does not appropriately or effectively use Use of Demonstrates a skillful use of high-quality, credible, sources Demonstrates a consistent use of credible and relevant sources that support the relevant sources that enhance the communication. credible or relevant communication. sources that support Module 8 Assignment This Module Assignment is a little different than previous Module Assignments. You will apply skills you learned in your School of Business prerequisites (specifically math, business communication, accounting/finance/Excel, and lower-division business classes) to a "real world" marketing scenario. I will be evaluating two of the Undergraduate Business Program Learning Goals, Problem Solving & Decision Making and Business Communication (LG1 & LG3). Detailed formatting guidelines and grading rubrics for each Learning Goal can be found at the end of this document. You are a digital marketing intern at a small footwear company located in Portland, OR. You have been asked to evaluate the financial performance of your social media advertising campaigns and make recommendations about how to allocate your digital advertising budget. Your manager gave you the following information: Online sales earn a 12% profit margin. Your monthly social media advertising budget is $20,000 You currently allocate 30% to Facebook, 30% to Instagram, 20% to TikTok, and 20% to Twitter. Part 2: Executive Summary Now that you have completed your Marketing Data Analysis, consolidate your findings into a 1- page executive summary. I have provided a couple examples attached to the Assignment Dropbox. You should at least answer the following questions in your executive summary: How is our social media advertising performing? Should we increase our social media advertising budget? Why/why not? Should we allocate more of our budget to a specific platform? Which one(s)? Why? . Should we allocate less of our budget to a specific platform? Which one(s)? Why? Should we allocate more of our budget to specific days of the week? Which one(s)? Why? Should we allocate less of our budget to a specific day of the week? Which one(s)? Why? . . Bonus Question: If we didn't increase our total budget, but we allocated the funds from the worst performing platform to our best performing platform (to the best performing day of the week) how would it impact our total ROAS? (Pro Tip: You will need to make a copy of the original data, modify the data based on your findings, and recalculate ROAS). PHOTO HOTODE Final Deliverables: 1. Submit your Executive Summary (1 page + appendices) to the Module 8 Executive Summary dropbox. Grading: Your grade will be based on four criteria: 1. Your executive summary (based on the Learning Goals 3: Business Communication Rubric) 2. Your answers to the questions in your Executive Summary Pro Tip: Don't always just paste screenshots of excel cells into your executive summary. Use graphs when they are appropriate. *Review the Learning Goal objectives and rubrics below for guidelines and expectations of this assignment. Learning Goal 1: Problem Solving & Decision Making Graduates of the Business Administration Baccalaureate program will have the capacity to recognize and understand a wide range of common and novel business problems and to follow a systematic approach to solve them effectively. Learning Objectives: 1. Problem definition: Students will construct clear and specific problem statements using contextually relevant evidence. 2. Research techniques and data analysis: Students will employ in-depth information and data from relevant sources throughout the problem-solving process. 3. Solution evaluation: Students will thoroughly evaluate solutions from multiple dimensions using appropriate analytical tools. 4. Decision making: Students will make decisions based on a synthesis of research, data analysis, and evaluation of solutions. Exceeds Expectations Meets Expectations Does Not Meet Expectations Problem definition Clearly and thoroughly defines the problem using most relevant contextual factors. Sufficiently defines the problem using most relevant contextual factors. Does not construct a clear problem statement. Research techniques & data analysis Organizes and synthesizes in- depth data and information from a wide range of research resources. Thorough synthesis of data and information. Uses a range of sources and a range of analytical tools. Evidence of synthesis of data and information from these Does not use relevant data or analytical tools appropriately. sources. Insufficiently Solution evaluation evaluates solutions. Thoroughly evaluates solutions in an elegant manner with creative consideration of relevant factors. Sufficiently evaluates solutions in an adequate manner with appropriate consideration of relevant factors. Decision Cogently presents decisions, Sufficiently presents Does not present a reasonable or decisions based on a basic making using a rich synthesis of research, data analysis, and evaluation of solutions. synthesis of research, data appropriate decision. analysis, and evaluation of solutions Learning Goal 3: Business Communication Graduates of the Business Administration Baccalaureate program will effectively communicate complex information with a variety of stakeholders to increase knowledge and achieve objectives. Learning Objectives: 1. Context, purpose and audience: Students will demonstrate a thorough consideration of context, purpose, and audience in the communication. 2. Manner of presentation: Students will present a central message in a clear, concise, and convincing manner. 3. Delivery of complex information: Students will skillfully articulate complex information in a manner that allows the message to be understood by multiple stakeholders. 4. Use of sources: Students will demonstrate a consistent use of credible, relevant sources that supports the message or credibility of the communicator. Exceeds Expectations Meets Expectations Does Not Meet Expectations Context, purpose & Demonstrates a thorough and creative understanding of context, audience, and purpose. Demonstrates adequate consideration of context, audience, and purpose. audience Does not demonstrate appropriate attention to context, audience, and purpose. Does not present the message in a clear or appropriate manner. Manner of presentation Message is skillfully delivered with a clear, concise and. persuasive authority. Very professional. Message is delivered in a clear and concise manner. Demonstrates consistent use of professional communication conventions. Articulates complex information in an appropriate way that it can be understood by the targeted audience. Delivery of complex information Skillfully conveys complex information that is easily understandable by the targeted audience. Delivery engages and teaches. Does not synthesize complex information. or deliver it in a manner that can be understood by the targeted audience. Does not appropriately or effectively use Use of Demonstrates a skillful use of high-quality, credible, sources Demonstrates a consistent use of credible and relevant sources that support the relevant sources that enhance the communication. credible or relevant communication. sources that support