Analysing a spreedsheet and write a report, business and finance homework help

User Generated

fffrivy

Business Finance

Description

please see specific in attachment.

Unformatted Attachment Preview

ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT Case Study Grevillea Ridge is a family operated winery on the Mornington Peninsula in Victoria. Michelle and Marcus Albertino own the property, which includes 20 hectares of grape plantings and a cellar door which is open to the public. Michelle and Marcus have been opening the cellar door to the public seven days per week. However, most of their cellar door sales are made on the weekend and they recently decided to close the cellar door on weekdays so that they could focus on building their clientele through online and telephone sales. Marcus tends to the grapes and supervises wine production. Michelle is responsible for all other winery operations. She employs two staff to assist her. Michael D'Angelo is employed on a full time basis and Eloise Simmons is employed two days per week. Customers who buy wine through the cellar door are encouraged to sign up to ‘Grevillea Ridge Wine Club’. They receive monthly emails regarding new vintages and special offers. Michelle and her team have also been marketing their wines to boutique wine stores. They now have several wholesale business customers (wine retailers) who purchase at trade pricing. Grevillea Ridge’s traditional customer base has been Victoria. Michelle sees the expansion into other states as a great marketing opportunity. Michelle expects staff to make regular contact with customers on the marketing list as well as developing new wholesale business customers. In an effort to increase sales, she has recently decided to include a Monthly Offer in her marketing emails. In February, she offered an extra 15% discount to all business retailers and in March she offered free delivery to all customers. Michelle has asked you to analyse the sales data and write a report with regards to the sales and in particular the effectiveness of the recent campaigns and her efforts to increase sales outside of Victoria. She realises there are other factors that may impact these results. Some of these issues should be outlined and considered before you make your recommendations to improve the business. A spreadsheet has been provided for you containing the data for sales during January, February and March. Business Report Semester 1, 2017 Page 1 PREPARING THE BUSINESS REPORT Report Content The analysis, findings and recommendations which you prepare for Michelle and Marcus should be outlined in a professional business report. This report should include: ▪ A brief Introduction that outlines clearly the purpose of the report. ▪ A brief presentation of the analysis you have carried out of the data contained in the spreadsheet. ▪ A discussion regarding the results of your analysis. ▪ Identification/discussion regarding other factors that may be affecting the results. ▪ A short concluding summary of the content of the report. ▪ Finally, at least two clear recommendations that Marcus and Michelle can adopt. These recommendations must be drawn from the analysis that you have carried out, and must have been discussed in the body of your report. Specifically you should: • Ensure your report is concise: 1000 words. This word count includes title page and TOC. It does not include appendices. (Note: a 10% variance is acceptable.) • Present the report in a professional, business format with no spelling or grammatical errors. • Use appropriate headings and subheadings throughout the body of the report. • Use Times New Roman 12 pitch point font, with 1.5 line spacing. • Align text using full justification. • Include a page header with a suitably formatted title (the header must not appear on the title page). • Include a footer with your name, id number and page number (the footer must not appear on the title page). • Include at least two appropriate charts – which you have created - either in the body of your report (appropriately labelled) or as an appendix at the end of the report. The material in the charts must be discussed as part of the paper. Business Report Semester 1, 2017 Page 2 Grevillea Ridge price list Retail Price Per Case (Dozen) Wholesale Price 2015 Pinot 2015 Shiraz 2016 Chardonnay 2016 Pinot Grigio Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz $ $ $ $ $ $ 360,00 384,00 360,00 312,00 456,00 480,00 DELIVERY CHARGES (per case - 12 bottles) Free Delivery Period $ 25,00 1-Mar-17 31-Mar-17 15% 1-Feb-17 28-Feb-17 Special Discount Discount Period $ $ $ $ $ $ 150,00 172,50 153,00 161,25 228,75 240,00 Cost Price $ $ $ $ $ $ 100,00 115,00 102,00 107,50 152,50 160,00 Date 1-Jan-17 2-Jan-17 3-Jan-17 25-Jan-17 3-Feb-17 5-Feb-17 5-Feb-17 16-Feb-17 19-Feb-17 23-Feb-17 3-Mar-17 17-Mar-17 28-Jan-17 2-Feb-17 24-Feb-17 24-Feb-17 25-Feb-17 25-Feb-17 25-Feb-17 25-Feb-17 25-Feb-17 25-Feb-17 25-Feb-17 25-Feb-17 5-Jan-17 12-Jan-17 2-Feb-17 7-Jan-17 14-Jan-17 22-Jan-17 29-Jan-17 7-Jan-17 8-Jan-17 8-Jan-17 1-Jan-17 5-Jan-17 10-Jan-17 10-Jan-17 30-Jan-17 2-Feb-17 2-Feb-17 2-Feb-17 22-Feb-17 22-Feb-17 22-Feb-17 24-Feb-17 Sales Period January January January January February February February February February February March March January February February February February February February February February February February February January January February January January January January January January January January January January January January February February February February February February February Salesperson Michael D'Angelo Michael D'Angelo Michael D'Angelo Eloise Simmons Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Michelle Albertino Michael D'Angelo Michael D'Angelo Michael D'Angelo Michelle Albertino Michael D'Angelo Eloise Simmons Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Customer Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Adelaide Wine bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Castle Hill Cellars Castle Hill Cellars Castle Hill Cellars Chris Gregory Chris Gregory Chris Gregory Chris Gregory Dan Roystein Dan Roystein Dan Roystein Dromana Cellars Dromana Cellars Dromana Cellars Dromana Cellars Dromana Cellars Dromana Cellars Dromana Cellars Dromana Cellars Dromana Cellars Dromana Cellars Dromana Cellars Dromana Cellars Wholesale Discount State Yes SA Yes SA Yes SA Yes SA Yes SA Yes SA Yes SA Yes SA Yes SA Yes SA Yes SA Yes SA Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW Yes NSW No VIC No VIC No VIC No VIC No NSW No NSW No NSW Yes VIC Yes VIC Yes VIC Yes VIC Yes VIC Yes VIC Yes VIC Yes VIC Yes VIC Yes VIC Yes VIC Yes VIC 2-Feb-17 7-Feb-17 14-Feb-17 22-Feb-17 4-Mar-17 4-Mar-17 6-Mar-17 6-Mar-17 9-Jan-17 6-Jan-17 10-Jan-17 11-Jan-17 2-Feb-17 3-Feb-17 6-Feb-17 7-Feb-17 3-Mar-17 20-Feb-17 20-Feb-17 7-Mar-17 20-Feb-17 20-Feb-17 22-Feb-17 22-Feb-17 26-Feb-17 27-Feb-17 27-Mar-17 22-Feb-17 7-Jan-17 21-Jan-17 14-Jan-17 22-Jan-17 22-Feb-17 22-Feb-17 22-Feb-17 23-Feb-17 24-Feb-17 24-Feb-17 24-Feb-17 24-Feb-17 26-Feb-17 31-Mar-17 2-Jan-17 18-Jan-17 25-Jan-17 7-Feb-17 7-Feb-17 9-Feb-17 25-Feb-17 26-Feb-17 February February February January March March March March January January January January February February February February March February February March February February February February February February March February January January January January February February February February February February February February February March January January January February February February February February Michael D'Angelo Michael D'Angelo Michael D'Angelo Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Michael D'Angelo Eloise Simmons Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Eloise Simmons Michelle Albertino Michael D'Angelo Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Michael D'Angelo Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Michael D'Angelo Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michael D'Angelo Michelle Albertino Michelle Albertino Euro Bar Euro Bar Euro Bar Euro Bar Euro Bar Euro Bar Euro Bar Euro Bar Geoff Mac Gina Rinebart Glenelg Fine Wines Glenelg Fine Wines Glenelg Fine Wines Glenelg Fine Wines Glenelg Fine Wines Glenelg Fine Wines Glenelg Fine Wines Hailey Wells James Pertile James Pertile Jan Gilmore Jan Gilmore Jan Gilmore Jo Barnes John Jury John Jury John Jury John Peters Keith Radd Keith Radd Mandy Smith Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Mentone Cellars Mentone Cellars Mentone Cellars Mentone Cellars Mentone Cellars Mentone Cellars Mentone Cellars Mentone Cellars Yes Yes Yes Yes Yes Yes Yes Yes No No Yes Yes Yes Yes Yes Yes Yes No No No No No No No No No No No No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes VIC VIC VIC VIC VIC VIC VIC VIC VIC NSW SA SA SA SA SA SA SA NSW VIC SA VIC VIC VIC QLD VIC VIC VIC VIC VIC VIC NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW VIC VIC VIC VIC VIC VIC VIC VIC 26-Feb-17 26-Feb-17 26-Feb-17 26-Feb-17 27-Feb-17 28-Feb-17 28-Feb-17 28-Feb-17 1-Mar-17 1-Mar-17 2-Mar-17 2-Mar-17 22-Feb-17 22-Feb-17 22-Feb-17 22-Feb-17 23-Feb-17 28-Mar-17 28-Mar-17 8-Mar-17 8-Mar-17 9-Mar-17 4-Jan-17 10-Jan-17 18-Jan-17 28-Jan-17 29-Jan-17 7-Jan-17 2-Feb-17 2-Feb-17 22-Feb-17 27-Feb-17 27-Feb-17 28-Feb-17 28-Feb-17 31-Mar-17 31-Mar-17 9-Mar-17 10-Mar-17 10-Mar-17 11-Mar-17 11-Mar-17 7-Jan-17 15-Jan-17 7-Mar-17 12-Mar-17 22-Jan-17 29-Jan-17 9-Feb-17 20-Feb-17 February February February February February February February February March March March March February February February February February March March March March March January January January January January January February February February February February February February March March March March March March March January January March March January January February February Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Michael D'Angelo Michael D'Angelo Michael D'Angelo Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Eloise Simmons Michael D'Angelo Michael D'Angelo Michelle Albertino Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Mentone Cellars Mentone Cellars Mentone Cellars Mentone Cellars Mentone Cellars Michael Long Michael Long Michael Long Miles Hyland Miles Hyland Miles Hyland Miles Hyland Opera House Fine Wines Opera House Fine Wines Opera House Fine Wines Opera House Fine Wines Opera House Fine Wines Opera House Fine Wines Opera House Fine Wines Peter Hadden Peter Hadden Peter Hadden Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Piccolo Wine Bar Robert Matherson Rosalie Green Rosalie Green Rosalie Green Rosalie Green Russ White Russ White Shirley Tran Simon Smerelli Simon Wallace Simon Wallace Sorrento Hotel Sorrento Hotel Yes Yes Yes Yes Yes No No No No No No No Yes Yes Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No No No No Yes Yes VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC NSW NSW NSW NSW NSW NSW NSW SA SA SA VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC SA SA SA SA SA VIC VIC QLD VIC VIC VIC VIC VIC 21-Feb-17 22-Feb-17 22-Feb-17 22-Feb-17 22-Feb-17 23-Feb-17 12-Mar-17 13-Mar-17 13-Mar-17 4-Jan-17 14-Jan-17 17-Jan-17 29-Jan-17 2-Feb-17 14-Feb-17 18-Feb-17 23-Feb-17 23-Feb-17 23-Feb-17 23-Feb-17 23-Feb-17 24-Feb-17 25-Feb-17 3-Mar-17 7-Mar-17 11-Mar-17 15-Mar-17 22-Mar-17 27-Mar-17 28-Mar-17 28-Mar-17 29-Mar-17 30-Mar-17 31-Mar-17 21-Jan-17 21-Jan-17 21-Jan-17 28-Jan-17 28-Jan-17 7-Feb-17 14-Feb-17 31-Mar-17 February February February February February February March March March January January January January February February February February February February February February February February March March March March March March March March March March March January January January January January February February March Michelle Albertino Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Michael D'Angelo Michael D'Angelo Michael D'Angelo Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Michelle Albertino Michelle Albertino Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Michael D'Angelo Michael D'Angelo Eloise Simmons Michelle Albertino Michelle Albertino Michael D'Angelo Michael D'Angelo Sorrento Hotel Sorrento Hotel Sorrento Hotel Sorrento Hotel Sorrento Hotel Sorrento Hotel Suzanne Waters Suzanne Waters Suzanne Waters Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Tim Cox Tim Cox Tim Cox Tim Cox Tim Cox Tim Cox Tim Cox Tran Ng Yes Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No VIC VIC VIC VIC VIC VIC SA SA SA VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC SA Number of Cases Purchased Description 2 Single Vineyard 2014 Chardonnay 3 2016 Pinot Grigio 4 2015 Shiraz 10 2015 Pinot 3 Single Vineyard 2014 Chardonnay 1 2016 Chardonnay 2 2016 Pinot Grigio 2 2016 Chardonnay 1 Single Vineyard 2013 Shiraz 3 Single Vineyard 2014 Chardonnay 3 Single Vineyard 2013 Shiraz 4 2016 Pinot Grigio 2 Single Vineyard 2014 Chardonnay 2 Single Vineyard 2013 Shiraz 9 2016 Chardonnay 3 Single Vineyard 2014 Chardonnay 3 2015 Pinot 5 2015 Shiraz 4 2015 Pinot 4 2016 Chardonnay 4 2016 Pinot Grigio 5 2016 Pinot Grigio 4 2016 Pinot Grigio 3 Single Vineyard 2013 Shiraz 2 Single Vineyard 2013 Shiraz 4 2015 Shiraz 10 2016 Pinot Grigio 1 2015 Pinot 1 Single Vineyard 2013 Shiraz 1 Single Vineyard 2014 Chardonnay 1 2015 Shiraz 1 2016 Chardonnay 1 2016 Chardonnay 1 2016 Chardonnay 1 Single Vineyard 2013 Shiraz 3 2016 Chardonnay 3 2016 Chardonnay 3 2016 Pinot Grigio 5 Single Vineyard 2014 Chardonnay 2 Single Vineyard 2013 Shiraz 5 2016 Chardonnay 10 Single Vineyard 2013 Shiraz 4 2016 Pinot Grigio 1 Single Vineyard 2013 Shiraz 2 Single Vineyard 2013 Shiraz 8 2015 Pinot 10 4 6 10 2 2 2 2 2 2 5 5 8 7 4 4 6 1 1 4 1 1 1 1 1 1 2 2 1 1 4 5 7 7 5 5 6 5 4 7 2 2 10 5 6 1 2 3 4 8 Single Vineyard 2014 Chardonnay 2015 Pinot 2015 Shiraz 2015 Shiraz Single Vineyard 2013 Shiraz Single Vineyard 2013 Shiraz 2016 Pinot Grigio Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2016 Pinot Grigio Single Vineyard 2014 Chardonnay 2015 Shiraz 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio 2016 Chardonnay Single Vineyard 2014 Chardonnay 2016 Chardonnay 2015 Shiraz 2015 Shiraz 2016 Pinot Grigio Single Vineyard 2014 Chardonnay 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2016 Chardonnay 2016 Chardonnay 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2016 Chardonnay Single Vineyard 2013 Shiraz 2016 Pinot Grigio 2016 Chardonnay 2015 Pinot Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2016 Pinot Grigio 2016 Pinot Grigio 2015 Shiraz 8 10 5 5 7 3 1 1 3 4 2 3 2 10 5 10 3 4 3 2 2 2 8 8 2 5 5 1 4 10 5 4 10 8 10 2 5 3 1 1 1 1 1 1 2 2 1 1 10 3 Single Vineyard 2013 Shiraz 2016 Chardonnay 2016 Chardonnay Single Vineyard 2014 Chardonnay 2016 Chardonnay 2015 Shiraz Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay 2016 Pinot Grigio Single Vineyard 2013 Shiraz Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay 2016 Chardonnay 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2016 Pinot Grigio 2016 Chardonnay 2015 Pinot 2016 Pinot Grigio 2016 Chardonnay Single Vineyard 2013 Shiraz 2016 Chardonnay 2016 Chardonnay 2016 Chardonnay 2016 Pinot Grigio 2015 Shiraz Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2015 Shiraz 2016 Chardonnay 2016 Chardonnay 2015 Shiraz Single Vineyard 2014 Chardonnay 2016 Chardonnay Single Vineyard 2013 Shiraz 2015 Pinot 2016 Pinot Grigio 2016 Chardonnay 2015 Pinot 2016 Chardonnay 2016 Chardonnay 2016 Pinot Grigio 2015 Shiraz 2015 Pinot Single Vineyard 2013 Shiraz Single Vineyard 2013 Shiraz Single Vineyard 2013 Shiraz 2015 Shiraz 2016 Pinot Grigio 2016 Chardonnay 2 10 5 6 9 15 4 4 2 3 5 8 3 10 3 1 4 10 4 4 3 5 2 8 2 8 2 6 6 4 4 10 3 8 1 2 3 1 3 3 1 3 2016 Chardonnay 2016 Pinot Grigio 2015 Pinot Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay 2016 Pinot Grigio 2015 Shiraz 2015 Shiraz 2015 Shiraz 2016 Chardonnay Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2015 Pinot 2016 Chardonnay 2016 Chardonnay 2015 Shiraz 2015 Shiraz Single Vineyard 2013 Shiraz 2016 Chardonnay 2016 Chardonnay 2016 Pinot Grigio 2016 Chardonnay Single Vineyard 2014 Chardonnay 2015 Pinot Single Vineyard 2013 Shiraz 2015 Pinot 2015 Pinot 2016 Pinot Grigio 2016 Chardonnay 2015 Pinot Single Vineyard 2014 Chardonnay 2015 Shiraz 2016 Pinot Grigio 2015 Pinot 2016 Pinot Grigio Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2015 Pinot 2016 Pinot Grigio 2015 Shiraz 2016 Chardonnay Single Vineyard 2013 Shiraz 2015 Pinot 2015 Shiraz 2016 Chardonnay 2016 Pinot Grigio Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz Date 1/1/2017 1/1/2017 1/2/2017 1/2/2017 1/3/2017 1/4/2017 1/4/2017 1/5/2017 1/5/2017 1/6/2017 1/7/2017 1/7/2017 1/7/2017 1/7/2017 1/7/2017 1/8/2017 1/8/2017 1/9/2017 1/10/2017 1/10/2017 1/10/2017 1/10/2017 1/11/2017 1/12/2017 1/14/2017 1/14/2017 1/14/2017 1/15/2017 1/17/2017 1/18/2017 1/18/2017 1/21/2017 1/21/2017 1/21/2017 1/21/2017 1/22/2017 1/22/2017 1/22/2017 1/25/2017 1/25/2017 1/28/2017 1/28/2017 1/28/2017 1/28/2017 1/29/2017 1/29/2017 1/29/2017 Salesperson Michael D'Angelo Michelle Albertino Michael D'Angelo Michael D'Angelo Michael D'Angelo Michelle Albertino Michelle Albertino Eloise Simmons Michelle Albertino Eloise Simmons Michael D'Angelo Eloise Simmons Michelle Albertino Michelle Albertino Eloise Simmons Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Michelle Albertino Eloise Simmons Michelle Albertino Michael D'Angelo Michael D'Angelo Michelle Albertino Michael D'Angelo Michelle Albertino Eloise Simmons Michelle Albertino Michael D'Angelo Eloise Simmons Michael D'Angelo Michael D'Angelo Michelle Albertino Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Michelle Albertino Eloise Simmons Michelle Albertino Michael D'Angelo Michelle Albertino Michelle Albertino Customer Adelaide Wine bar Dromana Cellars Adelaide Wine bar Mentone Cellars Adelaide Wine bar Piccolo Wine Bar Templestowe Cellars Castle Hill Cellars Dromana Cellars Gina Rinebart Chris Gregory Dan Roystein Keith Radd Piccolo Wine Bar Russ White Dan Roystein Dan Roystein Geoff Mac Dromana Cellars Dromana Cellars Glenelg Fine Wines Piccolo Wine Bar Glenelg Fine Wines Castle Hill Cellars Chris Gregory Mandy Smith Templestowe Cellars Russ White Templestowe Cellars Mentone Cellars Piccolo Wine Bar Keith Radd Tim Cox Tim Cox Tim Cox Chris Gregory Manly Vintage Cellars Simon Wallace Adelaide Wine bar Mentone Cellars Bronte Wine Bar Piccolo Wine Bar Tim Cox Tim Cox Chris Gregory Piccolo Wine Bar Simon Wallace Retailer Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No Yes No No No No Yes Yes Yes Yes Yes Yes No No Yes No Yes Yes Yes No No No No No Yes No Yes Yes Yes Yes No No No Yes No Number of Cases State Purchased 2 SA 1 VIC 3 SA 10 VIC 4 SA 8 VIC 3 VIC 2 NSW 3 VIC 2 NSW 1 VIC 1 NSW 1 VIC 1 VIC 1 VIC 1 NSW 1 NSW 2 VIC 3 VIC 3 VIC 5 SA 8 VIC 5 SA 4 NSW 1 VIC 4 NSW 5 VIC 1 VIC 8 VIC 5 VIC 2 VIC 1 VIC 1 VIC 2 VIC 3 VIC 1 VIC 5 NSW 1 VIC 10 SA 6 VIC 2 NSW 5 VIC 1 VIC 3 VIC 1 VIC 5 VIC 1 VIC 1/29/2017 1/30/2017 2/2/2017 2/2/2017 2/2/2017 2/2/2017 2/2/2017 2/2/2017 2/2/2017 2/2/2017 2/2/2017 2/2/2017 2/3/2017 2/3/2017 2/5/2017 2/5/2017 2/6/2017 2/7/2017 2/7/2017 2/7/2017 2/7/2017 2/7/2017 2/9/2017 2/9/2017 2/14/2017 2/14/2017 2/14/2017 2/16/2017 2/18/2017 2/19/2017 2/20/2017 2/20/2017 2/20/2017 2/20/2017 2/20/2017 2/21/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 Michelle Albertino Michelle Albertino Eloise Simmons Michael D'Angelo Eloise Simmons Eloise Simmons Michelle Albertino Michael D'Angelo Michael D'Angelo Michael D'Angelo Eloise Simmons Eloise Simmons Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Michelle Albertino Michael D'Angelo Michelle Albertino Michael D'Angelo Michael D'Angelo Michelle Albertino Michael D'Angelo Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Michelle Albertino Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Templestowe Cellars Dromana Cellars Bronte Wine Bar Castle Hill Cellars Dromana Cellars Dromana Cellars Dromana Cellars Euro Bar Glenelg Fine Wines Piccolo Wine Bar Piccolo Wine Bar Templestowe Cellars Adelaide Wine bar Glenelg Fine Wines Adelaide Wine bar Adelaide Wine bar Glenelg Fine Wines Euro Bar Glenelg Fine Wines Mentone Cellars Mentone Cellars Tim Cox Mentone Cellars Sorrento Hotel Euro Bar Templestowe Cellars Tim Cox Adelaide Wine bar Templestowe Cellars Adelaide Wine bar Hailey Wells James Pertile Jan Gilmore Jan Gilmore Sorrento Hotel Sorrento Hotel Dromana Cellars Dromana Cellars Dromana Cellars Euro Bar Jan Gilmore Jo Barnes John Peters Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Opera House Fine Wines Opera House Fine Wines Opera House Fine Wines Opera House Fine Wines Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes No Yes Yes Yes No No No No Yes Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes Yes VIC VIC NSW NSW VIC VIC VIC VIC SA VIC VIC VIC SA SA SA SA SA VIC SA VIC VIC VIC VIC VIC VIC VIC VIC SA VIC SA NSW VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC QLD VIC NSW NSW NSW NSW NSW NSW NSW 3 5 2 10 2 5 10 10 8 4 10 10 3 7 1 2 4 4 4 1 2 3 3 10 6 3 1 2 1 1 1 1 1 1 3 2 4 1 2 10 1 1 2 7 7 5 2 10 5 10 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/22/2017 2/23/2017 2/23/2017 2/23/2017 2/23/2017 2/23/2017 2/23/2017 2/23/2017 2/23/2017 2/23/2017 2/24/2017 2/24/2017 2/24/2017 2/24/2017 2/24/2017 2/24/2017 2/24/2017 2/24/2017 2/25/2017 2/25/2017 2/25/2017 2/25/2017 2/25/2017 2/25/2017 2/25/2017 2/25/2017 2/25/2017 2/25/2017 2/26/2017 2/26/2017 2/26/2017 2/26/2017 2/26/2017 2/26/2017 2/26/2017 2/27/2017 2/27/2017 2/27/2017 2/27/2017 2/28/2017 2/28/2017 2/28/2017 2/28/2017 2/28/2017 3/1/2017 3/1/2017 Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Michelle Albertino Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Piccolo Wine Bar Sorrento Hotel Sorrento Hotel Sorrento Hotel Sorrento Hotel Adelaide Wine bar Manly Vintage Cellars Opera House Fine Wines Sorrento Hotel Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Bronte Wine Bar Bronte Wine Bar Dromana Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Manly Vintage Cellars Templestowe Cellars Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Bronte Wine Bar Mentone Cellars Templestowe Cellars John Jury Manly Vintage Cellars Mentone Cellars Mentone Cellars Mentone Cellars Mentone Cellars Mentone Cellars John Jury Mentone Cellars Piccolo Wine Bar Piccolo Wine Bar Michael Long Michael Long Michael Long Piccolo Wine Bar Piccolo Wine Bar Miles Hyland Miles Hyland Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes No Yes Yes Yes No No No Yes Yes No No VIC VIC VIC VIC VIC SA NSW NSW VIC VIC VIC VIC VIC VIC NSW NSW VIC NSW NSW NSW NSW VIC NSW NSW NSW NSW NSW NSW NSW NSW VIC VIC VIC NSW VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC VIC 5 10 5 6 9 3 5 3 15 4 10 4 4 3 9 3 8 6 5 4 7 5 3 5 4 4 4 5 4 3 4 2 1 2 8 8 10 5 5 1 7 4 10 3 1 1 8 10 3 4 3/2/2017 3/2/2017 3/3/2017 3/3/2017 3/3/2017 3/4/2017 3/4/2017 3/6/2017 3/6/2017 3/7/2017 3/7/2017 3/7/2017 3/8/2017 3/8/2017 3/9/2017 3/9/2017 3/10/2017 3/10/2017 3/11/2017 3/11/2017 3/11/2017 3/12/2017 3/12/2017 3/13/2017 3/13/2017 3/15/2017 3/17/2017 3/22/2017 3/27/2017 3/27/2017 3/28/2017 3/28/2017 3/28/2017 3/28/2017 3/29/2017 3/30/2017 3/31/2017 3/31/2017 3/31/2017 3/31/2017 3/31/2017 Michelle Albertino Michelle Albertino Michael D'Angelo Michael D'Angelo Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Michael D'Angelo Michelle Albertino Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michael D'Angelo Michelle Albertino Michelle Albertino Michael D'Angelo Michael D'Angelo Michael D'Angelo Michelle Albertino Michael D'Angelo Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michelle Albertino Eloise Simmons Michelle Albertino Michelle Albertino Michelle Albertino Michael D'Angelo Miles Hyland Miles Hyland Adelaide Wine bar Glenelg Fine Wines Templestowe Cellars Euro Bar Euro Bar Euro Bar Euro Bar James Pertile Shirley Tran Templestowe Cellars Peter Hadden Peter Hadden Peter Hadden Robert Matherson Rosalie Green Rosalie Green Rosalie Green Rosalie Green Templestowe Cellars Simon Smerelli Suzanne Waters Suzanne Waters Suzanne Waters Templestowe Cellars Adelaide Wine bar Templestowe Cellars John Jury Templestowe Cellars Opera House Fine Wines Opera House Fine Wines Templestowe Cellars Templestowe Cellars Templestowe Cellars Templestowe Cellars Manly Vintage Cellars Piccolo Wine Bar Piccolo Wine Bar Templestowe Cellars Tran Ng No No Yes Yes Yes Yes Yes Yes Yes No No Yes No No No No No No No No Yes No No No No Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No VIC VIC SA SA VIC VIC VIC VIC VIC SA QLD VIC SA SA SA SA SA SA SA SA VIC VIC SA SA SA VIC SA VIC VIC VIC NSW NSW VIC VIC VIC VIC NSW VIC VIC VIC SA 2 3 3 6 8 2 2 2 2 4 2 2 2 2 2 3 1 1 1 1 8 2 4 4 2 2 4 6 2 6 4 3 4 4 10 3 2 2 5 8 3 Description Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2016 Pinot Grigio 2016 Pinot Grigio 2015 Shiraz 2016 Chardonnay 2016 Chardonnay Single Vineyard 2013 Shiraz 2016 Chardonnay Single Vineyard 2013 Shiraz 2015 Pinot 2016 Chardonnay 2015 Shiraz Single Vineyard 2013 Shiraz 2015 Shiraz 2016 Chardonnay 2016 Chardonnay Single Vineyard 2014 Chardonnay 2016 Chardonnay 2016 Pinot Grigio 2016 Pinot Grigio 2016 Chardonnay Single Vineyard 2014 Chardonnay 2015 Shiraz Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay Single Vineyard 2014 Chardonnay 2015 Pinot Single Vineyard 2013 Shiraz 2016 Chardonnay 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2015 Pinot 2015 Pinot Single Vineyard 2014 Chardonnay 2015 Shiraz 2015 Pinot 2016 Pinot Grigio 2015 Shiraz Single Vineyard 2014 Chardonnay 2015 Shiraz Charge per Case $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 228,75 240,00 161,25 161,25 172,50 153,00 153,00 240,00 153,00 480,00 360,00 360,00 384,00 240,00 384,00 360,00 360,00 456,00 153,00 161,25 161,25 153,00 228,75 172,50 480,00 456,00 228,75 360,00 240,00 153,00 161,25 312,00 312,00 456,00 480,00 456,00 161,25 480,00 150,00 150,00 228,75 172,50 360,00 312,00 384,00 228,75 384,00 Discount per case $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - 2015 Pinot Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2016 Chardonnay Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay 2015 Shiraz 2015 Shiraz 2016 Chardonnay 2016 Chardonnay Single Vineyard 2014 Chardonnay 2016 Pinot Grigio 2016 Chardonnay 2016 Pinot Grigio 2016 Pinot Grigio 2015 Pinot 2016 Pinot Grigio Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2015 Shiraz 2016 Pinot Grigio 2016 Pinot Grigio 2015 Shiraz 2016 Chardonnay 2016 Chardonnay 2016 Chardonnay 2015 Shiraz Single Vineyard 2013 Shiraz Single Vineyard 2013 Shiraz 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio 2016 Chardonnay 2016 Chardonnay 2016 Pinot Grigio Single Vineyard 2013 Shiraz Single Vineyard 2013 Shiraz 2015 Shiraz 2016 Pinot Grigio 2016 Pinot Grigio 2015 Shiraz 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio 2016 Chardonnay 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2016 Pinot Grigio $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 150,00 228,75 240,00 161,25 240,00 153,00 240,00 228,75 172,50 172,50 153,00 153,00 228,75 161,25 153,00 161,25 161,25 150,00 161,25 228,75 240,00 384,00 161,25 161,25 172,50 153,00 360,00 153,00 172,50 240,00 480,00 312,00 312,00 312,00 153,00 153,00 161,25 240,00 240,00 172,50 312,00 312,00 384,00 161,25 161,25 161,25 153,00 161,25 240,00 161,25 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 36,00 24,19 36,00 22,95 36,00 34,31 25,88 25,88 22,95 22,95 34,31 24,19 22,95 24,19 24,19 22,50 24,19 34,31 36,00 57,60 24,19 24,19 25,88 22,95 54,00 22,95 25,88 36,00 72,00 46,80 46,80 46,80 22,95 22,95 24,19 36,00 36,00 25,88 46,80 46,80 57,60 24,19 24,19 24,19 22,95 24,19 36,00 24,19 2016 Chardonnay 2016 Pinot Grigio 2015 Pinot Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2016 Chardonnay 2016 Pinot Grigio 2015 Shiraz Single Vineyard 2013 Shiraz 2016 Chardonnay 2016 Chardonnay 2016 Pinot Grigio 2016 Chardonnay Single Vineyard 2014 Chardonnay 2015 Pinot 2016 Chardonnay 2016 Chardonnay 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2016 Chardonnay 2015 Pinot 2015 Shiraz 2015 Pinot 2016 Chardonnay 2016 Pinot Grigio 2016 Pinot Grigio 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2016 Pinot Grigio Single Vineyard 2014 Chardonnay 2016 Chardonnay 2016 Chardonnay 2015 Shiraz Single Vineyard 2013 Shiraz 2016 Chardonnay 2016 Chardonnay Single Vineyard 2014 Chardonnay Single Vineyard 2014 Chardonnay 2016 Chardonnay 2015 Shiraz Single Vineyard 2014 Chardonnay 2015 Shiraz Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay 2016 Chardonnay Single Vineyard 2013 Shiraz 2016 Pinot Grigio Single Vineyard 2013 Shiraz $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 153,00 161,25 150,00 240,00 228,75 228,75 240,00 153,00 161,25 172,50 240,00 153,00 153,00 161,25 153,00 228,75 150,00 153,00 153,00 161,25 240,00 153,00 150,00 172,50 150,00 153,00 161,25 161,25 161,25 240,00 161,25 228,75 360,00 153,00 172,50 240,00 153,00 153,00 228,75 456,00 153,00 172,50 228,75 384,00 480,00 456,00 153,00 240,00 312,00 480,00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 22,95 24,19 22,50 36,00 34,31 34,31 36,00 22,95 24,19 25,88 36,00 22,95 22,95 24,19 22,95 34,31 22,50 22,95 22,95 24,19 36,00 22,95 22,50 25,88 22,50 22,95 24,19 24,19 24,19 36,00 24,19 34,31 54,00 22,95 25,88 36,00 22,95 22,95 34,31 68,40 22,95 25,88 34,31 57,60 72,00 68,40 22,95 36,00 - Single Vineyard 2013 Shiraz Single Vineyard 2014 Chardonnay Single Vineyard 2013 Shiraz 2016 Pinot Grigio 2015 Pinot Single Vineyard 2013 Shiraz Single Vineyard 2013 Shiraz 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2016 Pinot Grigio Single Vineyard 2013 Shiraz Single Vineyard 2013 Shiraz 2016 Chardonnay Single Vineyard 2013 Shiraz 2016 Chardonnay 2016 Chardonnay 2015 Pinot 2016 Chardonnay 2016 Chardonnay 2016 Pinot Grigio 2015 Pinot Single Vineyard 2013 Shiraz 2015 Shiraz 2015 Shiraz 2015 Shiraz 2015 Pinot 2016 Pinot Grigio 2016 Pinot Grigio 2016 Chardonnay 2016 Chardonnay 2015 Pinot 2016 Pinot Grigio 2015 Pinot Single Vineyard 2014 Chardonnay 2015 Shiraz 2016 Pinot Grigio Single Vineyard 2013 Shiraz 2015 Pinot 2016 Pinot Grigio 2015 Pinot Single Vineyard 2013 Shiraz $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 480,00 456,00 240,00 161,25 150,00 240,00 240,00 161,25 240,00 312,00 480,00 240,00 360,00 480,00 360,00 360,00 360,00 360,00 360,00 312,00 150,00 480,00 384,00 384,00 384,00 150,00 161,25 161,25 360,00 153,00 150,00 161,25 150,00 228,75 172,50 161,25 240,00 150,00 161,25 150,00 480,00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ -
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi, please find the attached file which includes the report. I have also attached the spreadsheet which was used as the working for the data analysis for your reference.

Grevillea Ridge - Business Report
Analysis of sales over the first quarter and effectiveness of the marketing
campaigns.
Name:

__________________________

ID Number: __________________________

Grevillea Ridge – Business Report

Introduction

Table of Contents
Introduction ................................................................................................................................................... 2
Data analysis ................................................................................................................................................. 3
Sales Volume and Average Price .............................................................................................................. 3
Sales Channel Mix .................................................................................................................................... 3
Repeat Customers ..................................................................................................................................... 4
Campaign Effectiveness............................................................................................................................ 5
Recommendations ......................................................................................................................................... 7
Shift focus to personal selling ................................................................................................................... 7
Change product mix .................................................................................................................................. 7
Conclusion .................................................................................................................................................... 8
Appendix ....................................................................................................................................................... 9

[Name]

1

[ID NUMBER]

Grevillea Ridge – Business Report

Introduction

Introduction
This main objective of this report is to provide the readers with an analysis, findings and
recommendations of Grevillea Ridge based on the sales data of the company over the period of 3
months from January to March.
Initially, an analysis of the sales data would be carried and briefly presented in the report which
would lay the foundation of the whole report. Based on sales data of the company, the report would
present to the readers the results and findings of the analysis carried out and eventually move on
to discussing the driving forces that contributed towards such results. The report would also
include a discussion of the company’s performance over the 3-month period and evaluate the
effectiveness of the campaigns carried out by the owners. Furthermore, it would assess the
company’s efforts to increase sales outside Victoria. Other external forces that affected the results
would also be identified and the results would be evaluated accordingly. Finally, the report would
make two recommendations that the owners could adopt which would be drawn from the analysis
and discussions carried out.

[Name]

2

[ID NUMBER]

Grevillea Ridge – Business Report

Data analysis

Data analysis
Based on the data provided which contains the sales of the company during January, February and
March, several aspects on company’s performance could be analyzed.

Sales Volume and Average Price
Figure 1 shows the number of cases sold monthly and along with average price. Sales volume is
significantly higher in February compared to the other months. One of the reasons that contributed
to this result could be the discount campaign run by the company during the month of February.
With regards to the average price however, the month of February reported the lowest of the 3
months. This is probably due to the change in the sales and product mix and perhaps due to the
surge in demand amongst the retailers for lower priced wine (see Annexure A). Understanding this
is important since it would help evaluate the extent to which the company’s profit margins are

Number/Price in $

affected.
500
450
400
350
300
250
200
150
100
50
-

460

246.43

224.76
157

188.29

Jan

Feb
Number of Cases

146

Mar
Average Price

Figure 1

Sales Channel Mix
In addition, it is important to understand the proportion of overall sales made between consumers
and retailers. It could be noted that the prices offered through each channel are significantly
different and therefore maintaining a good balance between the sales channels is important in order
to report a healthy margin. Figure 2 illustrates the proportion over the three months and it infers
that in February, retailers accounted for a much larger proportion of sales compared to the other
[Name]

3

[ID NUMBER]

Grevillea Ridge – Business Report

Data analysis

months. This could be the primary cause for the average selling price to be lower as identified in
Figure 1.

Sales Channel Mix
Jan

80%

Feb

20%

96%

Mar

4%

67%
0%

10%

20%

30%

33%
40%

50%

Retailers

60%

70%

80%

90%

100%

Consumers

Figure 2

Repeat Customers
Furthermore, it is important to identify the percentage of repeat customers to help redirect the
marketing efforts towards attracting the loyal customers. Over a given month, it was identified that
out of the total of 36 customers (both retail and end-consumers), a larger portion of consumers
ordered 2 to 4 times while approximately 28% of customers ordered just once over the 3-month
period (see Figure 3). It is therefore important to identify these customers and market accordingly
to make them more loyal to the company.

[Name]

4

[ID NUMBER]

Grevillea Ridge – Business Report

Data analysis

Repeat Customers

19%
28%
More than 10 times
5 to 9 times

14%

2 to 4 times
Once

39%

Figure 3

Campaign Effectiveness
The 15% discount campaign that was run in February seem to have attracted a sizable portion of
the consumers. However, it must also be noted that February is nevertheless a high-seasonal month
for wine producers given the Valentine’s Day in February. As such given the limited data available,
the real effectiveness of the campaign cannot be ascertained.
On the other hand, the “Free Delivery” campaign that was run in March was probably targeted to
attract non-Victorian customers in the company’s effort to increase sales outside Victoria.
However, according to Figure 4, the proportion of Victorian to Non-Victorian customers remained
almost the same and no significant increase could be noted. It therefore leads us to conclude that
the “Free Delivery” campaign was not very effective.

[Name]

5

[ID NUMBER]

Grevillea Ridge – Business Report

Data analysis

VIC vs Non-VIC Sales Proportion
Jan

68%

32%

Feb

63%

37%

Mar

63%

37%

0%

10%

20%

30%

40%

50%

VIC

60%

70%

80%

90%

100%

Non-VIC

Figure 4

[Name]

6

[ID NUMBER]

Grevillea Ridge – Business Report

Recommendations

Recommendations
Shift focus to personal selling
It was noted that a higher portion of the sales made were to retailers whose average selling prices
were significantly lower than the end-consumers thereby reducing the margins and leading to a
lower profitability. As such, it is recommended to focus more on personal selling, that is, selling
to the end consumers and the marketing efforts should be directed more towards this strategy. One
of the recommended strategies is to introduce a loyalty scheme whereby consumers are rewarded
for repeated purchases. This would eventually improve customer relationship and increase the
number of repeat customers too as discussed above.
Change product mix
Maintaining a brand image is key to any business and Grevillea Ridge is no exception. The
company currently seems to be stuck in the middle with their product portfolio containing items
with different price ranges. Instead it would be better for Grevillea Ridge to gradually focus on
selling products that are on the higher range such as the “Single Vineyard” range. This would not
only help enhance the company’s brand but also improve the average selling price, as noted in
Figure 1, and eventually increase company’s margins. Currently, the company markets to boutique
wine stores and they should continue to do so.

[Name]

7

[ID NUMBER]

Grevillea Ridge – Business Report

Conclusion

Conclusion
The analysis was based on the sales data of Grevillea Ridge over the period from January to March
which focused on several aspects such as average selling prices, sales channels and customer
loyalty. Other factors such as the effect of Valentine’s Day was discussed as a possible contributor
towards the spike in sales in February. The effect of the discount on sales in February could
therefore not be determined given the limited data. It was also noted that the “free delivery” was
not effective especially in attracting customers outside of Victoria. Finally, it was recommended
to the owners of the company that they focused more on personal selling and redirect the marketing
accordingly. It was also suggested that they re-brand to the upper segment of the market by
changing the product mix to include higher priced wines.

[Name]

8

[ID NUMBER]

Grevillea Ridge – Business Report

Appendix

Appendix
Annexure A - Average Selling Price
Monthly Sales Volume and Sales Revenue by Price
Jan

Charge per
Case

Sales Volume

$150.00
$153.00
$161.25
$172.50
$228.75
$240.00
$312.00
$360.00
$384.00
$456.00
$480.00
Grand Total

19
30
28
13
24
12
5
6
4
9
7
157

[Name]

Feb
Sales
Revenue
$2,850
$4,590
$4,515
$2,243
$5,490
$2,880
$1,560
$2,160
$1,536
$4,104
$3,360
$35,288

Sales Volume
24
115
132
50
46
74
5
2
8
2
2
460

9

Mar
Sales
Revenue
$3,600
$17,595
$21,285
$8,625
$10,523
$17,760
$1,560
$720
$3,072
$912
$960
$86,612

Sales Volume
36
6
29
10
4
13
8
12
10
3
15
146

[ID NUMBER]

Sales
Revenue
$5,400
$918
$4,676
$1,725
$915
$3,120
$2,496
$4,320
$3,840
$1,368
$7,200
$35,978


Customer
Jan
Feb
Mar
Grand Total
Adelaide Wine bar
3.131
2.394
1.365
6.890
Bronte Wine Bar
458
7.884
8.342
Castle Hill Cellars
1.170
1.613
2.783
Dromana Cellars
2.786
6.210
8.996
Euro Bar
5.648
1.763
7.410
Glenelg Fine Wines
1.950
3.799
968
6.716
Manly Vintage Cellars
806
8.578
480
9.864
Mentone Cellars
3.278
9.647
12.925
Opera House Fine Wines
5.190
1.084
6.274
Piccolo Wine Bar
5.017
9.587
1.106
15.710
Sorrento Hotel
10.658
10.658
Templestowe Cellars
3.973
8.182
9.989
22.144
Grand Total
22.568...


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags