You are creating a business report for the CEO of Harvest Kitchen (see: http://www.goodharvest.com.au). It must be professional in presentation and contain insightful content for them to make business...

1 answer below »
You are creating a business report for the CEO of Harvest Kitchen (see: http://www.goodharvest.com.au). 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 a 6 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 (see lecture 1) 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?

    1. 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 effect 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?

    1. How does this relate to rainfall and profits?







There might be other research questions you should consider considering the business challenges (you will get higher marks for identifying other issues the CEO should be aware of)




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 (2 marks) –
    Introduce the business and its problems (see website link above for more information)


  • Problem definition and business intelligence required (2 marks) –
    Outline the research questions and list what analytics methods you have chosen to answer each one and why


  • Visualise the descriptive statistics (5 marks)
    – 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 (20 marks)
    – 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 (5 marks)
    – 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)




Report formatting (5 marks):

Font size 12 Times New roman, double spacing, word count 1,500-2,000.
Note.
The word count does not include headings, tables, graphs/figures or the reference list.


See below for the marking criteria sheet




































































Levels of Achievement

Criteria

High Distinction

Distinction

Credit

Pass

Fail

Criteria 1:



Introduction



(2 marks)



85 to 100 %

Demonstrates comprehensive and insightful knowledge of the business with an in-depth introduction and the problems clearly outlined in terms of where the business is in regard to its industry.
75 to 84 %

Demonstrates mostly comprehensive and insightful knowledge of the business. The website is well referenced.
65 to 74 %

Demonstrates some knowledge of the business with the problems mostly outlined.
50 to 64 %

Basic knowledge of the business demonstrated with the assignment information given but no extra information included.


0 to 49 %

Little or no knowledge of the business with the website not referred to or consulted. Does not introduce the business or fails to explain the business and its problems.

Criteria 2:



Problem definition and business intelligence required



(2 marks)

85 to 100 %

Each problem and the business intelligence/statistics required are described and explained with references where appropriate to literature.
75 to 84 %

Each problem and the business intelligence/statistics required are mostly explained with some references where appropriate to literature.
65 to 74 %

Demonstrates some knowledge of the problems and the business intelligence/statistics required. With minimal references to literature.
50 to 64 %

Basic knowledge of the business questions and the statistics used are outlined with some explanation as to why these were used.
0 to 49 %

Little information concerning the report questions and the statistics used to answer them. The analyses are outlined but no explanations given.

Criteria 3:



Visualisations of the descriptive statistics



(5 marks)

85 to 100 %

Demonstrates comprehensive and insightful knowledge of data visualizations with each type being appropriate for the type of data.
75 to 84 %

Demonstrates mostly comprehensive and insightful knowledge of data visualizations with minimal errors or some variables missing.
65 to 74 %

Demonstrates some knowledge of data visualizations with several errors or variables missing.

50 to 64 %

Basic knowledge of data visualizations shown, what is shown is not appropriate or here are errors or variables missing.
0 to 49 %

Little or no knowledge of data visualizations. If anything is shown it has errors, is inappropriate or is missing information or variables.

Criteria 4:

Results of the selected analytics methods and technical analysis



(20 marks)


Demonstrates comprehensive and insightful knowledge of the use of business analytic tools to answer the report questions and others identified in the data set. Use of statistical terminology is extensive and correct. The level of interpretation of the statistics meets professional standards of the discipline with no errors in interpretation and/or presentation.Demonstrates mostly comprehensive and insightful knowledge of the use of business analytic tools to answer the report questions and others identified in the data set. Use of statistical terminology is extensive and largely correct. The level of interpretation of the statistics mostly meets professional standards of the discipline with little errors in interpretation and/or presentation.Demonstrates some knowledge of the use of business analytic tools to answer the report questions. Use of statistical terminology mostly correct. The level of interpretation of the statistics meets standards but some errors in interpretation or presentation.Basic knowledge of the use of business analytic tools to answer the report questions. Use of statistical terminology fairly correct. The level of interpretation of the statistics meets standards but some errors in interpretation or presentation.Little or no knowledge of the use of business analytic tools to answer the report questions. Use of statistical terminology inconsistent and not correct. The level of interpretation of the statistics fails in terms of presentation and interpretation.

Criteria 5:

Discussion of the results and recommendations (5 marks)
The recommendations are highly appropriate, integrated with the results, and supported by results/literature. The entire report is presented as a consistent whole.The recommendations are appropriate, integrated with the results, and supported.The recommendations are fairly appropriate and fairly supported. With some instances missing.The recommendations are appropriate, however lacking some instances and needing more. Or inappropriate suggestions are made.The recommendations are lacking and are not supported. Inappropriate suggestions are made or there are no suggestions at all.

Criteria 6:


Report formatting



(5 marks)


The meaning is consistently clear. Use of discipline terminology is confident and assured. The level of presentation meets professional standards of the discipline, and there is a high level of attention to detail regarding the results tables and graphics (not just cut and paste from SPSS output. Little/no errors in grammar, syntax and spelling. Referencing and citations are appropriate and integrated.The meaning is clear. Use of discipline terminology is extensive and largely correct. The level of presentation meets professional standards of the discipline, and there is attention to detail. SPSS output has not been copied and pasted into the results. The grammar, syntax and spelling are near perfect. Referencing and citations are appropriate.Overall meaning is clear though there are minor instances of awkward/ambiguous expression. Use of discipline terminology is adequate. The level of presentation mostly meets professional standards of the discipline, with some lapses in detail in e.g. SPSS output not used, grammar, syntax and spelling good. Referencing and/or citation errors.The intended meaning can be discerned but lacks clarity and/or examples of awkward/ambiguous expression. Limited discipline terminology with minor inaccuracies. Some use of SPSS output in the report. Some professionalism but significant lapses in grammar syntax and spelling. Referencing and/or citation errors.Use of language fails to make meaning clear; many errors of grammar, syntax and spelling, range of mistakes indicating lack of editing and proofreading. Limited or incorrect use of discipline terminology. Poor referencing and citation errors.
005_ix7oa5o-h5rjxooi.sav 005_b37oa5o-f4illsw2.sav 005_oa5o-wyq445wi.docx
Answered Same DayDec 27, 2021

Answer To: You are creating a business report for the CEO of Harvest Kitchen (see:...

Robert answered on Dec 27 2021
120 Votes
Introduction
This is a business report for the CEO of Harvest Kitchen. this is based on 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.
Research Questions
My various research questions of interest are as follows.
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 effect 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?
Descriptive Statistics
Descriptives
Statistic Std.
Error
Total Sales
($)
Mean 369.96 31.556
95% Confidence
Interval for Mean
Lower
Bound
308.04
Upper
Bound
431.88
5% Trimmed Mean 207.81
Median 85.15
Variance
1029654.50
7
Std. Deviation 1014.719
Minimum 0
Maximum 17276
Range 17276
Interquartile Range 248
Skewness 8.511 .076
Kurtosis 105.970 .152


The average value of total sales is $ 369.96. The value of standard deviation (1014.719)
is high indicating that mean is not reliable. The distribution of total sales is positively skewed.
Here median is $85.15 which is considered as best measure of central tendency. The box plot for
total sales for each product location is given below.

There are many outliers present in the sales for each product location. I should replace
these outliers by median which is best measure of central tendency.
Statistics
Average_Sal
e
Rainfall Profit
Total
N
Valid 358 365 366
Missing 8 1 0
Mean 18.52 3.98 30.7098
Median 18.31 .00 25.0300
Std. Deviation 3.985 9.811 30.05661
Skewness 3.758 3.421 3.274
Std. Error of
Skewness
.129 .128 .128






Mean for average sale, rainfall and profit total is 18.52, 3.98 and 30.7098. The value of
standard deviation Is 3.985, 9.811 and 30.05661 indicating that mean is not reliable.
The distribution of all variables namely average sale, rainfall as well as profit total is
positively skewed. Median for average sale, rainfall and profit total is 18.31, .00 and 25.03
respectively and is considered as the best measure of central tendency
Analysis
Analysis 1:
The top selling products is of type 30. The worst selling products is of type 14. The mean
for top and worst selling product is 1866.88 and 17.96 respectively.
Product Class (number) Statistic
Total Sales ($) 1 Mean 226.25
2 Mean 432.67
3 Mean 37.01
4 Mean 514.23
5 Mean 635.62
6 Mean 574.25
7 Mean 341.26
8 Mean 108.27
9 Mean 354.21
10 Mean 979.93
11 Mean 108.74
12 Mean 44.98
13 Mean 332.78
14 Mean 17.96
15 Mean 196.23
16 Mean 176.72
17 Mean 224.55
18 Mean 310.81
19 Mean 33.53
20 Mean 62.27
21 Mean 109.32
22 Mean 84.38
23 Mean 242.11
24 Mean 18.99
25 Mean 113.60
26 Mean 32.29
27 Mean 88.55
28 Mean 48.09
29 Mean 871.49
30 Mean 1866.88
Analysis 2:
Ho: there is no significant difference in the sales performance between different
locations. V/s h1: there is significant difference in the sales performance between different
locations.
ANOVA
Total Sales ($)
Sum of
Squares
df Mean Square F Sig.
Between
Groups
134299725.0
24
4 33574931.256 37.176 .000
Within Groups
929333380.8
17
1029 903142.255
Total
1063633105.
841
1033
With F = 37.176 and p-value being less than 0.05, I reject ho at 5% level of significance
and conclude that there is significant difference in the sales performance between different
locations. To test which pairs differs significantly I apply Tukey HSD.
Multiple Comparisons
Dependent Variable: Total Sales ($)
Tukey HSD
(I) Location of
product in shop
(J) Location of
product in shop
Mean
Difference (I-
J)
Std.
Error
Sig. 95% Confidence
Interval
Lower...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?