BUS501 - Business Analytics and Statistics | Good Harvest

BUS501 - Business Analytics and Statistics
Research Report
Student Name:
Student Number:
Tutor Name:
Word Count:
1

Table of Contents
List of figures.............................................................................................................................2
List of tables...............................................................................................................................3
Introduction................................................................................................................................3
Problem definition and business intelligence required..............................................................4
Visualise the descriptive statistics..............................................................................................5
Descriptive statistics...............................................................................................................5
Normality test.........................................................................................................................7
Results of the selected analytics methods and technical analysis..............................................8
What are the top/worst selling products in terms of sales?....................................................8
Is there a difference in payments methods?............................................................................9
Are the differences in sales performance based on where the product is located in the shop?
..............................................................................................................................................11
Is there a difference in sales between different months of the year?....................................13
Is there a difference in gross profits between different months of the year?........................14
Are their differences in sales performance between different seasons?...............................15
Discussion of the results and recommendations......................................................................16
Recommendations................................................................................................................17
References................................................................................................................................18
2

List of figures
Figure 1: Bar chart of the seasons of the year............................................................................7
Figure 2: Bar chart of the location of products in shop..............................................................7
Figure 3: Histogram of gross sales.............................................................................................8
Figure 5: Mean plot for the product location versus total sales received.................................13
Figure 6: Mean plot for the sales versus months in a year.......................................................14
Figure 7: Mean plot for the gross profits versus months in a year...........................................15
Figure 8: Mean plot for the total sales versus seasons.............................................................16
List of tables
Table 1: Descriptive statistics....................................................................................................6
Table 2: Descriptive Statistics....................................................................................................9
Table 3: Two-Sample Assuming Equal...................................................................................10
Table 4: Two-Sample Assuming Equal Variances..................................................................10
Table 5: ANOVA.....................................................................................................................11
Table 6: Test of Homogeneity of Variances............................................................................12
Table 7: Multiple Comparisons................................................................................................12
Table 8: ANOVA.....................................................................................................................14
Table 9: ANOVA.....................................................................................................................15
Table 10: ANOVA...................................................................................................................16
3

Introduction
Good Harvest is a business enterprise that is concerned with growing organic food.
The Good Harvest thrives in;
 Empowering the individual to make conscious decisions
 Inspiring dynamic and passionate communities
 Believing integrity is the essence of everything
The company offers a number of products which include:
 Organic farm boxes for students and singles
 Organic farm boxes for couples
 Organic farm boxes for families
 Organic cold pressed juices
 Organic farm fresh extras
The company delivers the products to the customers and they have specific days of
delivery
The CEO is greatly concerned with the business revenue (i.e. lead generation/new
business), Cost of Goods (COGS margins) and average sales. This study sought to
analyse the business standing of the company making recommendation to the CEO on
how best the revenues can be improved.
Problem definition and business intelligence required
The study sought to answer a number of research questions. The listed below are some
of the research questions that this study sought to answer;
1. What are the top/worst selling products in terms of sales?
To answer this research question, analysis of the product class had to be done. The
average sales of the different product classes are presented in order to compare the
total sales received from each and every product class.
4