BUS501 Business Analytics and Statistics | Assignment

BUS501 - Business Analytics and Statistics
Name:
Lecturer name:
5th October 2017
1

Table of Contents
1. Introduction..............................................................................................................................4
2. Problem definition and business intelligence required.............................................................4
3. Results and findings.................................................................................................................5
Analysis 1: What are the worst and top selling products in terms of sales?................................5
Analysis 2: Is there a difference in payments methods?..............................................................6
Hypothesis 1:............................................................................................................................6
Hypothesis 2:............................................................................................................................7
Analysis 3: How does location of the product in the shop affect the sales performance?...........8
Hypothesis 4:............................................................................................................................8
Analysis 4: How does sakes compare based on the different months of the year?......................8
Hypothesis 5:............................................................................................................................9
How does gross profits compare based on the different months of the year?.............................9
Hypothesis 6:............................................................................................................................9
Analysis 5: How does sales performance compare between different seasons?........................10
Hypothesis 7:..........................................................................................................................10
4. Discussion of the results and recommendations.....................................................................11
References......................................................................................................................................12
2

Table 1: Top selling products..........................................................................................................4
Table 2: Worst selling products.......................................................................................................5
Table 3: t-Test: Two-Sample Assuming Equal Variances..............................................................6
Table 4: t-Test: Two-Sample Assuming Equal Variances..............................................................7
Table 5: Analysis of variance (ANOVA) for the total sales versus product location.....................8
Table 6: Analysis of variance (ANOVA) for the net sales versus months......................................8
Table 7: Analysis of variance (ANOVA) for the gross profits versus months................................9
Table 8: Analysis of variance (ANOVA) for the net sales versus seasons...................................10
3

1. Introduction
It is always a desire of each and every organization to maximize on their profits and that is the
key reasons as to why they are in business. This is the case of a young upcoming start up by
the name Good Harvest. The start-up deals in organic farming and as well as sale of their
products direct to their customers. The CEO is concerned about the cost of goods incurred by
the start up as well as the sale performance and revenues generated by the enterprise. Business
analytics can be used to give clear insights on how the enterprise is performing and probably
advise on key areas of improvement. Using the one-year data for the company, we sought to
present the CEO with the key analysis related to key areas mentioned.
2. Problem definition and business intelligence required
Good Harvest has not been to the market for so long; actually they have been barely two
years. The CEO of the company would want to improve the performance of the company but
he has to do it through key data insights gained from analyzing the one year that is available.
However, the CEO has pointed six key research questions he would want to see answered in
the report. His main concern is to understand;
 What are the worst and top selling products?
 Do payment methods have variation in terms of total cash received?
 Do location of the product in the shop have impact on total sales generated?
 How do sales performance compare for the different months in a year?
 How do profits of the company compare for the different months in a year?
 How do sales performance compare for the four seasons?
4