Report | Harvest Kitchen Shop and Management

Harvest Kitchen shop Report
Course Name...........................................................
School ............................................................
Department....................................................
Lecturer name...........................................................
Task Name............................................................
Date........................................................................
1

Contents
Introduction................................................................................................................ 2
Definition of problem and necessary business intelligence.......................................................2
Results of Selected Business analytics................................................................................3
Descriptive statistics................................................................................................... 3
Analytics one: Which products are best selling and worst selling?..........................................4
Analysis two: Is sales affected by different seasons?...........................................................5
Analysis three: Does rainfall affect sales and profit?...........................................................6
Analysis Four: Does gross profit between different months significant different?........................8
Analysis five: Is there a difference in payments methods?.....................................................8
Results discussion and recommendations............................................................................ 9
References................................................................................................................ 10
2

Introduction
Harvest kitchen is a small health food shop. It is located on the Sunshine Coast. It is a point
where customers come to collect their organic food stuffs. The harvest Kitchen is under a
business that is divided into retail, wholesale and box delivery system. The Harvest Kitchen
makes sale to retailers for different commodities that are organically produced. Most of the
customers prefer farm products that are chemical free to ensure that they prevent cancer of
different parts of the body. The business that Harvest kitchen is under has been in operation for
the last two years. These are the initial stage of a starting business and it is having some
challenges.
Major challenge that the Harvest kitchen has been undergoing through is inadequate capital.
Most of the customers don’t have information about the services that are being provided at
Harvest Kitchen. The sales made at Harvest Kitchen the profit are insufficient to run the
business. The cost of running the business is thus tough enough. Organic farming and products
are expensive to grow since they are naturally grown (Good Harvest, 2017).
Harvest Kitchen located at Sunshine coast has created opportunity through employment of six
employees, one delivery van, a retail outlet and a cold warehouse. Data entry is important and
important in making inference about the future of the business.
Definition of problem and necessary business intelligence
The study adopted inferential and descriptive business analytic method to answer challenges
facing Harvest Kitchen shop. Descriptive statistics and data presentation method were used to
describe the distribution of variable of interest while inferential statistics were used to answer
business problems under study such analysis of variance, regression analysis and confidence
intervals (Desaro S., 2011). The study problems were:
 Which products are best selling and worst selling?
 How does the location of products in shop affect profit?
 Does gross profit between different months differ?
 Does gross sales between different months significant different?
 Is sales affected by different seasons?
 Does rainfall affect sales and profit?
3

Results of Selected Business analytics
Descriptive statistics
The first task was to check the variable on data set if they were properly scaled. There were no
missing cases in data set. Weekday, month, seasons and date were ordinal and the rest variables
were scale variable. Below is screenshot of data used in analysis of this report.
The nets sales of products were normally distributed. There were no outliers that very high
number of sales or too low number of sales in the data. The actual number of sales did not vary
much with mean net sales; the standard deviation of mean net sales was small. The mean net
sales were not significance different in different seasons of the year. Below is box plot of mean
net sales in different season of year.
4