NIKE INC. AVERTON Ore. March 21 2013 NIKE Inc. today reported financial results for its fiscal...

Transcribed Image Text:

NIKE INC. AVERTON Ore. March 21 2013 NIKE Inc. today reported financial results for its fiscal 2013 third quarter ended February 28, 2013. For continuing operations, strong demand for NIKE Inc brands propelled double digit revenue growth on a currency neutral basis, and diluted earnings per share count "Our team delivered strong results in Q3. We did it with relentless flow of innovation into our grew faster than revenue due to gross margin expansion, a lower tax rate and a lower average share key categories" said Mark Parker, President and CEO of NIKE Inc. "Given the diversity of our portfolio, we're able to capture big opportunities that drive sustainable, profitable growth. At the same time we continue to invest in new ways to enhance athletic performance, build strong consumer communities and improve how we design and manufacture our products. That's how we increase our potential and drive shareholder value" Below are some statistics involving NIKE Australia you are required to develop the following: • Perform a trend analysis (forecast) (PC1.1) ⚫ Calculate a mean based monthly Sales figures (PC1.1) Calculate a correlation (PC 1.1) ⚫ Past sales in both states is listed below along with past advertising spends. Sales & Advertising spends are millions Data is per month for the last financial year 2012 Month MELBOURNE ADELAIDE Sales (x) Ad Spend (y) Sales (x) Ad Spend (y) Jul 3.5 0.8 4.6 0.6 Aug 3.8 0.5 3.9 0.3 Sep 4.8 0.4 3.1 0.7 Oct 6.0 60 0.7 7.2 0.6 Nov 8.6 0.3 7.8 0.2 Dec 4.2 0.5 4.3 0.4 Jan 3.81 0.6 5.4 0.6 Feb 4.9 00 0.4 5.9 0.2 Mar 6.2 0.5 3.9 0.3 Apr 3.5 0.4 5.0 0.5 May 7.8 0.8 5.6 0.6 June 8.7 0.6 4.3 0.4 e budgeting to spend 0.6 million on advertising in the future Analyse the trend analysis for their potential impact on the business (PC 1.2) Use mean and correlation to quantify comparative sets of data. (PC1.3) Perform qualitative analysis on the mean and correlation as a basis of reviewing business performance. (PC1.4). (Perform the items above in Microsoft Excel). 3. Create a positioning statement to analyse the market performance of existing and potential competitors and their products. Identify and state potential opportunities and threats of competitors. (PC1.5) 4. Analyse performance data from all areas of the business to determine success of marketing objectives. Eg Advertising, Promotions, Endorsements/Sponsorship. (PC2.1)(Internet research) 5. Identify overperforming or underperforming products to be considered for redevelopment or withdrawal. (PC2.2) What sectors or divisions of NIKE Australia could do with this redevelopment or withdrawal. 6. Create a survey (surveymonkey.com) (minimum of 6 questions) to forecast existing and emerging (innovation)market needs based on information available. (PC2.3) 7. Give the survey to 3 peers (friends) to gain answers to their needs in the future. Record results. 8. As an appendix hard copy display trend analysis (forecast), average(mean) monthly sales figures along with correlation calculation in a visual slide presentation (powerpoint presentation) as if you were giving a presentation to the CEO. Explain briefly what the forecast/trends is showing in your slides. (Minimum of 4 slides). (PC3.1.). Explain why a visual presentation is necessary and any corrective action necessary (PC3.2) 9. Write a short formal report on analysis of market data to meet organisational requirements in terms of content, (What goes into the report)format, esp. ethics and legislation codes of conduct ADMA Direct Marketing Code of Practice, level of detail and scheduling. (How often reports are done, content etc)(PC3.3) uggested websites to be used in this assessment NIKE Inc - NIKE Australia. NIKE INC. AVERTON Ore. March 21 2013 NIKE Inc. today reported financial results for its fiscal 2013 third quarter ended February 28, 2013. For continuing operations, strong demand for NIKE Inc brands propelled double digit revenue growth on a currency neutral basis, and diluted earnings per share count "Our team delivered strong results in Q3. We did it with relentless flow of innovation into our grew faster than revenue due to gross margin expansion, a lower tax rate and a lower average share key categories" said Mark Parker, President and CEO of NIKE Inc. "Given the diversity of our portfolio, we're able to capture big opportunities that drive sustainable, profitable growth. At the same time we continue to invest in new ways to enhance athletic performance, build strong consumer communities and improve how we design and manufacture our products. That's how we increase our potential and drive shareholder value" Below are some statistics involving NIKE Australia you are required to develop the following: • Perform a trend analysis (forecast) (PC1.1) ⚫ Calculate a mean based monthly Sales figures (PC1.1) Calculate a correlation (PC 1.1) ⚫ Past sales in both states is listed below along with past advertising spends. Sales & Advertising spends are millions Data is per month for the last financial year 2012 Month MELBOURNE ADELAIDE Sales (x) Ad Spend (y) Sales (x) Ad Spend (y) Jul 3.5 0.8 4.6 0.6 Aug 3.8 0.5 3.9 0.3 Sep 4.8 0.4 3.1 0.7 Oct 6.0 60 0.7 7.2 0.6 Nov 8.6 0.3 7.8 0.2 Dec 4.2 0.5 4.3 0.4 Jan 3.81 0.6 5.4 0.6 Feb 4.9 00 0.4 5.9 0.2 Mar 6.2 0.5 3.9 0.3 Apr 3.5 0.4 5.0 0.5 May 7.8 0.8 5.6 0.6 June 8.7 0.6 4.3 0.4 e budgeting to spend 0.6 million on advertising in the future Analyse the trend analysis for their potential impact on the business (PC 1.2) Use mean and correlation to quantify comparative sets of data. (PC1.3) Perform qualitative analysis on the mean and correlation as a basis of reviewing business performance. (PC1.4). (Perform the items above in Microsoft Excel). 3. Create a positioning statement to analyse the market performance of existing and potential competitors and their products. Identify and state potential opportunities and threats of competitors. (PC1.5) 4. Analyse performance data from all areas of the business to determine success of marketing objectives. Eg Advertising, Promotions, Endorsements/Sponsorship. (PC2.1)(Internet research) 5. Identify overperforming or underperforming products to be considered for redevelopment or withdrawal. (PC2.2) What sectors or divisions of NIKE Australia could do with this redevelopment or withdrawal. 6. Create a survey (surveymonkey.com) (minimum of 6 questions) to forecast existing and emerging (innovation)market needs based on information available. (PC2.3) 7. Give the survey to 3 peers (friends) to gain answers to their needs in the future. Record results. 8. As an appendix hard copy display trend analysis (forecast), average(mean) monthly sales figures along with correlation calculation in a visual slide presentation (powerpoint presentation) as if you were giving a presentation to the CEO. Explain briefly what the forecast/trends is showing in your slides. (Minimum of 4 slides). (PC3.1.). Explain why a visual presentation is necessary and any corrective action necessary (PC3.2) 9. Write a short formal report on analysis of market data to meet organisational requirements in terms of content, (What goes into the report)format, esp. ethics and legislation codes of conduct ADMA Direct Marketing Code of Practice, level of detail and scheduling. (How often reports are done, content etc)(PC3.3) uggested websites to be used in this assessment NIKE Inc - NIKE Australia.

Answer rating: 100% (QA)

Trend Analysis Forecast To perform a trend analysis you can use the sales figures for Melbourne and Adelaide over the past financial year By plotting ... View the full answer