BUS501 - Business Analytics and Statistics | Good Harvest

Added on -2020-02-19

| 19 pages| 3672 words| 28 views

Trusted by 2+ million users,
1000+ happy students everyday

Showing pages 1 to 4 of 19 pages

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

Found this document preview useful?

You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss

Premium

$45

Q&A Library Access

Chat support

12

Document Unlocks

4

Answer Unlocks

Students who viewed this