Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As an e-commerce retailer, you have obtained some information from several comparable competitors regarding their levels of advertising expenditures and their sales. If you have

As an e-commerce retailer, you have obtained some information from several comparable competitors regarding their levels of advertising expenditures and their sales. If you have a goal for $750,000 in sales next year, use regression to determine the best amount of advertising dollars you should invest to hit your goal.

Online Store Monthly E-commerce Sales (in 1000 s) Online Advertising Dollars (1000 s)
1 368 1.7
2 340 1.5
3 665 2.8
4 954 5
5 331 1.3
6 556 2.2
7 376 1.3

Given the historical data of company sales, using linear regression, make a prediction for 2020 sales revenue.

Year Sales (In millions)
2012 2.611
2013 2.688
2014 3.022
2015 3.133
2016 3.743
2017 3.698
2018 3.997
2019 4.436

Develop a brief memorandum to management summarizing your projections with appropriate support. Advise management about the relative risk of relying on historical sales trends to predict sales in recent years. Be sure to describe your linear model and its limitations. Can you say anything about the cause-effect relationship between the variables in the correlation analysis? Advise management on what conditions might call for revisiting the prediction.

 

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Marketing And Export Management

Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr

8th Edition

1292016922, 978-1292016924

More Books

Students also viewed these General Management questions

Question

13. What are two mechanisms by which CCK increases satiety?

Answered: 1 week ago