Business Analytics and Statistics Research Report

You are creating a business report for the CEO of Harvest Kitchen. It must be professional in presentation and contain insightful content for them to make business decisions.

Both data sets are from a small health food shop on the Sunshine Coast. The business is divided into a number of areas including retail, wholesale a box delivery system (not included in the data), and Harvest Kitchen.

The data is inclusive of a whole year of trading. This is the second year of business and the business is still in a start-up phase. The reported high Cost of Goods (COGS) is reportedly consistent with the Organic industry.

The main challenges in the business are revenue (i.e. lead generation/new business), Cost of Goods (COGS margins) and average sales.

The business has a6 person team, 1 delivery van, a retail outlet and a cold store warehouse.

Task instructions:

1) Ensure the dataset is appropriately scaled (each measure in SPSS must be set correctly). Report on what you changed.

2) Produce descriptive statistics for the most appropriate variables to give an overview of how the business and its products are performing

3) Use the statistical analyses you have learned to answer all of the questions below

As guide - answer these main research questions:

1. What are the top/worst selling products in terms of sales?

a. Is there a difference in payments methods?

2. Are the differences in sales performance based on where the product is located in the shop? How does this effects both profits and revenue?

3. Is there a difference in sales and gross profits between different months of the year?

4. Are their differences in sales performance between different seasons?

a. How does this relate to rainfall and profits?

Report structure:

• Cover page/Title Page - Name, student number, tutor information, word count
• Table of contents (could also include a list of figures / diagrams / tables)
• Introduction - Introduce the business and its problems (see website link above for more information)
• Problem definition and business intelligence required - Outline the research questions and list what analytics methods you have chosen to answer each one and why
• Visualise the descriptive statistics - using what you have learned show the relevant descriptive statistics through data visualization/ graphical displays (Tables, graphs, pie charts etc.).
• Results of the selected analytics methods and technical analysis - use each research question as a heading then present the analysis findings and explain them. Higher marks for including extra research questions not defined here and creating nice tables/displays opposed to copy and pasting directly from SPSS output.
• Discussion of the results and recommendations - Based on the analyses what conclusions about the business can be summarized/drawn and what recommendations can be offered to the CEO.
• References - list of references in either Harvard or APA formatting (you must reference the business website - include other references in your answers).

Attachment:- Assignment Files.zip