Reference no: EM13733552
Forecasting Sales
Advertising is often touted as key to success. In seeking to determine just how influential advertising is, the management of a recently established retail chain collected data on sales revenue and advertising expenditures from its stores over the last 15 weeks, with the results shown in the following table:
|
Advertising expenditure ($000s)
|
Sales ($000)
|
|
3.0
|
50
|
|
5.0
|
250
|
|
7.0
|
700
|
|
6.0
|
450
|
|
6.5
|
600
|
|
8.0
|
1000
|
|
3.5
|
75
|
|
4.0
|
150
|
|
4.5
|
200
|
|
6.5
|
550
|
|
7.0
|
750
|
|
7.5
|
800
|
|
7.5
|
900
|
|
8.5
|
1100
|
|
7.0
|
600
|
The management is contemplating to increase sales and wants to investigate the effect of increasing advertising expenditure. The marketing manager believes that if advertising expenditure is increased to $12,000, sales of approximately $1,400,000 can be achieved. You have successfully completed your Bachelor's degree and have joined the firm as analyst. Your first assignment is to write a report to the CEO of the company. Your report should consist of:
(a) an executive summary
(b) an introduction
(c) a brief literature review of factors influencing sales
(d) an analysis of the above data using data analysis techniques learned in your QM course to investigate the relationship between advertising expenditure and sales. You should also investigate the validity of the marketing manager's claim.
(e) an outline of the strengths and weaknesses of the techniques you have used in your analysis.
(f) the limitations of your analysis and a brief explanation of how your forecast can be made more accurate.
(g) a conclusion
(h) a list of references.
Adapted from Selvanathan&Selvanathan (2014)
Assignment guidelines
(i) The assignment is due on 20 May 2015.
(ii) The word limit is 1500 words excluding charts and appendices.
(iii) Each group must comprise of 3 members or less.
(iv) Each group should make an oral presentation of max 10 mins on 27 May 2015.
(v) Collusion will lead to immediate failure and plagiarism will be heavily penalized.
|
Explian what is an ultimate form of foreign involvement
: What is an ultimate form of foreign involvement and Which type of distribution relies on some intermediaries willing to carry a particular product
|
|
What is the after tax pv of this proposed investment
: Liberty Airways is considering an investment of $800,000 in ticket purchasing kiosks at selected airports. The kiosks have an expedited life of four years. Extra ticket sales are expected to be $60,000 per year at a discount price of $40 per ticket. ..
|
|
The incremental federal income tax rate
: If the incremental federal income tax rate is 34% and the incremental state income tax rate is 6%, what is the effective combined income tax rate (t)? if the satiate income taxes are 12% of taxable income, what now is the value of t?
|
|
What is data base method and judgmental method
: What is data base method? What is judgmental method? What are some of the difficulties on forecasting? When are these methods qualitative and quantitative?
|
|
Brief literature review of factors influencing sales
: Brief literature review of factors influencing sales - investigate the relationship between advertising expenditure and sales.
|
|
More economic cally developed countries
: 1. Less economically developed countries will experience higher birth rates than more economic cally developed countries due to : A. Decreased availability of sanitary water.B. Higher infant mortality rate.
|
|
Contribute to moving the discussion and analysis forward
: Prepare a two-paragraph position statement that describes your agreement or disagreement with the following statement: Contribute to moving the discussion and analysis forward
|
|
Draw a schema that represents consumer knowledge
: Interview five consumers and ask them what are the first five words that come into their minds when they hear the following brands listed below. Use the results to draw a schema that represents consumer knowledge of each brand
|
|
An experiment,a reseacher counts the number of oxygen
: In an experiment,a reseacher counts the number of oxygen bubbles produced by water plan placed under different colors of light. The researcher find that water plants place under white light release more oxygen bubbles than water plants placed under r..
|