Detailed tasks1. Analysis of sales and country data, forecasting of sales figures until 2020• Provide a statistical overview of the data provided in the excel sheets for each country(you can also do a comparison analysis)• Conduct a correlation analysis between sales development and:o (i) advertisements, (ii) number of stores and (iii) the survey results• Conduct a multi regression time series analysis and use the results to forecast the salesuntil 2020.o Hint: You should use natural logs (ln) for your analysis as discussed in yourassignment of Module 5.o For your reasonable assumptions which are required for the forecasting, youshould apply hypothesis testing techniques for the GDP, Prices and Populationdevelopments. For example, if you forecast a GDP growth of 3.5%, knowing the pastGDP growth figures, is the forecast of 3.5% an acceptable growth figurefor the forecast or should that Null hypothesis be rejected?2. Market place Sweden – Estimate of potential sales figures in 2016 and forecast to 2020• Based on your analysis in part 1, which country (Industria, Federated Islands,Nokaragua) is closest related to Sweden? Justify your selection.o Hint: Look at average GDP per capita statistics (GDP divided by Population) andPrice Index.• Once you have identified the country that is closet related to Sweden, use thatcountry’s characteristics of the analysis undertaken in the first part toestimate/forecast the potential sales for the Swedish market.o Use the forecasts from the IMF to project GDP growth rates and a potentialprice index (CPI or Inflation rate) for the years 2016 to 2020. See pg 40 of the ‘IMF 2015 ARTICLE IV CONSULTATION’ report forSweden for the data.Assessment 2 Briefs: Presentation Page 4 of 93. Other suggestions- Based on your analysis in parts 1 and 2, are there any other suggestions you have forthe Board on how Schmeckt Gut can boost sales in the countries?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here