Reference no: EM132195980

Assignment: Return on Marketing Plan Information

Assignment details

You have been asked to plan a marketing campaign for "Le Grill", where you must specify your anticipated marketing investment and translate that figure into a return on investment (ROI)percentage. There are two parts of this assignment:

1. The ROI Excel spreadsheet, where you will use the assumptions and the marketing expense worksheet located in the ROI spreadsheet to help you fill out the information required to calculate the ROI of your planned marketing campaign.

2. This document, where you will justify your marketing budget decisions and exercise critical thinking and analysis related to each assumption. Once you have arrived at your ROI percentage, please answer the questions related to each assumption below. Please review the assumptions and questions below BEFORE you start the spreadsheet.

3. In Assumption 10, you'll be asked to change some inputs in the Excel spreadsheet that will change your ROI. See submission instructions below.

Submission instructions

Submit both this worksheet and your case study to Canvas. You do not need to submit a different Word doc--you may answer the questions asked of you below within this document. You must however, be extraordinarily thorough and specific in your responses. Quality over quantity always, and please use examples from your readings and assignments to help you be as specific as possible. Please submit the Excel spreadsheet using Assumptions 1-9, not reflecting the information asked of you in Assumption 10. You will answer Assumption 10 below.

Directions to answer assumption questions

Using the assumptions and the ROI percentage generated from your Excel calculations, please answer the questions related to each assumption below. Be as specific and detailed as possible, and answer each question asked below each assumption thoroughly. If you have any questions, please let me know.

Assumption 1: Marketing Budget

You have been allotted a maximum of $165,000 for marketing expenses, not including staff and must decide which marketing channels will receive money from the $165,000 marketing budget.

1. Select at a minimum 2 areas where you will spend the majority of your marketing budget. Social media and campaign development.

2. Provide detail as to your logic and reasoning behind why you selected these areas, the amounts you allotted to each, and why you think this strategy will be the most successful. First social media, for a new product that is new to the market (Le Grill), it need to be seen by many people as possible for them to decide if this grill could replace the old one they have or not. Second campaign development, after the decision on looking for a new grill for the customer, he should be willing to look for information or how good is this grill and its features for the customer to buy it.

3. Reflect those figures in the "Marketing Expenses (excluding offer costs)" area of the spreadsheet.

Assumption 2: Staff Expense Budget

There are three employees that will be working on this campaign, one with an annual salary of $112,500, the second with an annual salary of $72,830, and the third with an annual salary of $36,400. Assume it will take approximately 6.25 days to complete the campaign. Use the marketing staff expense worksheet to calculate the daily rate of each employee.

1. Please explain why you (hypothetically) need three employees at three different rates.

The first employee oversees the campaign development and arranging the events. The second employee has two things he will work on the social media and the email marketing for sending emails after the customers putting their emails through the ads or buying emails data from partners.

2. Further, explain why you might have selected the duration of 6.25 days.

I choose 6.25 days because the events will be between 4th of July and Father's Day. Also, the events will take place as a barbecue parties.

Assumption 3: Offers/Incentives/Temporary Discounts

While you do not need to reflect this in your spreadsheet because we assume there are no other offers/incentives/temporary discounts applicable to this marketing campaign:

1. Why might a company promote special offers, incentives, and temporary discounts to drive traffic? To attract more potential customers who are looking for discounts and hopefully increase profit. Also, to compete with other products for a better price and quality.

2. What would be a reason they would not? High production cost and low profit.

3. If a company offers incentives or discounts, does that increase or decrease ROI and why? Increase return on investment because more selling means more profit growth.

Assumption 4: Other Expenses Outside Marketing Budget

While for this assignment we assume there are no other expenses outside of the marketing budget that are applicable to this marketing campaign, what could these other expenses look like in real life?

1. Provide three examples and explain what can happen to marketing ROI and why.
marketing analytics, marketing research, marketing training

2. In what instances could this increase ROI and in what instances could it potentially decrease ROI?

3. What mistakes do you think marketers make by focusing on the wrong things, or alternatively, thinking outside the box?

Assumption 5: Marketing Impact

Assume you want this marketing campaign to reach a target of 27,000 people (meaning the number of people you want to drive to your website to buy "Le Grill").

1. What key pieces of information would help you arrive at deciding 27,000 people is important to this campaign? Please be as specific as possible in describing your logic and steps you would have taken to arrive at this hypothetical figure. _______

Assumption 6: Net Conversion Rate of Incremental Sales

Assume that of the 27,000 people who go to the website, you will have a conversion rate of 2.2%.

1. Hypothetically, why would you set a goal for a 2.2% conversion rate? ______

2. Is that a good conversion rate for a marketing campaign? Why or why not? ______

3. What does the ROI percentage tell us about the joint influence of marketing impact and net conversion rates? _____

4. How do we estimate and calculate conversion rates to help us plan our marketing campaigns? _____

Assumptions 7& 8: Average Revenue per Sale or Customer (NPV)/Gross Margin

Assume your NPV of each "Le Grill" Sale will net you $875 and a gross margin of 38%.

1. What do net sales and gross margin have to do with return on marketing investment? _____

2. If either margins or incremental sales were lower than 38% and $875 respectively, what would happen to the ROI? _____

3. How does this information help you make decisions in allocating your marketing budget? _____

Assumption 9: Reduction to Gross Margin from New Sales

Assume that 30% of the profit from incremental sales is refunded to customers who filed complaints within the money-back guarantee period.

1. Why do things like product quality and money-back guarantees ultimately influence the return on marketing investment? _____

2. In what ways do you think the various divisions of a company can work together to ensure marketing dollars are well spent? _____

3. What does collaboration have to do with marketing, especially where shared data is concerned? _____

Assumption 10: Product Quality Improvement and A/B Testing

You assume that if the product quality of Le Grill had been better, this marketing campaign would have been successful. Previously, you had not run an A/B test, and because you know product quality has been improved, you run an A/B test using your current website as the control. You relaunch a marketing campaign after product improvements are made. You find that your conversion rate increases to 3.8% and refunds drop to 7%.

1. What is conversion optimization? _____

2. How do we calculate how long a test should run? _____

3. What information does the p-value give us? _____

4. Why is it better to test ahead of time rather than after the fact? _____

5. How does conversion optimization and testing help us improve ROI? _____

6. What methods of analysis can we use to improve ROI? _____

7. What is the ROI of your marketing campaign now that the conversion rate has increased from 2.2% to 3.8% and refunds have dropped 23%?_____

8. Explain the difference between the two ROI percentages and why marketers would want to use this information across organizational divisions to increase shared data within a company to present the success of a planned marketing campaign. _____

Information related to above question is enclosed below:

Attachment:- MKT365ROMIFinal2.rar