logo

BUS501 Assignment | Business Analysis and Statistics

17 Pages2563 Words70 Views
   

Business Analytics and Statistics (BUS501)

   

Added on  2020-03-16

BUS501 Assignment | Business Analysis and Statistics

   

Business Analytics and Statistics (BUS501)

   Added on 2020-03-16

ShareRelated Documents
Running Head: BUS501 – BUSINESS ANALYSIS AND STATISTICSBUS501 – Business Analysis and StatisticsName of the StudentName of the UniversityAuthor Note
BUS501 Assignment | Business Analysis and Statistics_1
1BUS501 – BUSINESS ANALYSIS AND STATISTICSTable of Contents1.0 Introduction................................................................................................................................22.0 Definition of the problem and requirement of business intelligence.........................................23.0 Results of the selected analytics methods and technical analysis..............................................34.0 Conclusions and Recommendations........................................................................................14References......................................................................................................................................16
BUS501 Assignment | Business Analysis and Statistics_2
2BUS501 – BUSINESS ANALYSIS AND STATISTICS1.0 IntroductionA huge range of products are produced by the company Good Harvest Organic Farm andMarket. Most of the products produced by the company are organic (Good Harvest Organics,2017). The main aim of this organization is to produce good quality of organic foods and deliverthem to its customers. The company also provides its customers with a facility of home delivery.The company is also engaged in providing education to the people about their seasonal productsand its nutritional values. The business of this company is now running for only two years. The company isinterested to analyze its retail market business. The company wants to improve its average sales,average revenue and also wants to investigate on the high COGS. Though the company considersthe fact that the organic products do come at a price higher than the price of the usual products,improving the average sales of the company is a matter of concern. 2.0 Definition of the problem and requirement of business intelligenceThe company, Good Harvest has collected some data from one of its outlets and that hasbeen provided to run this analysis. The data has been collected from a health Food Shop in theSunshine Coast. Descriptive analysis and predictive analysis will be used to run the analysis ofthe data provided. The analysis will be conducted keeping in mind the following researchquestions:What are the top and the worst selling products in terms of sales?Are the differences in sales performance based on where the product is located in theshop? How does this effect both profits and revenue?
BUS501 Assignment | Business Analysis and Statistics_3
3BUS501 – BUSINESS ANALYSIS AND STATISTICSIs there a difference in sales and gross profits between different months of the year?Are their differences in sales performance between different seasons?3.0 Results of the selected analytics methods and technical analysisThe descriptive statistics required to answer the first research question “What are the topand the worst selling products in terms of sales” re given below in table 1. Table 1: Necessary descriptive statistic measures for Total SalesProduct ClassMeanMedianStd. DeviationMinimumMaximumAyurvedic226.25164.75252.67710504Bakery432.6766.43884.01673793Chocolates & Slices37.0131.0016.0291961Coconut Water514.23380.55562.668211794Dairy619.05259.431473.7931010814Drinks574.25136.771729.244511910Dry Goods341.26121.99604.43923300Freezer202.4591.63421.30153252Fridge354.21211.95389.32691535Fruit1048.68356.472469.413317276Grocery108.7472.73108.2605597Harvest Kitchen44.9738.1524.1972480Health products332.7879.90757.809152914Herbal Teas17.968.1324.373254Household196.2346.50255.5207987Juicing5.005.0055Market88.7588.7597.22720158Meats Smallgoods176.7297.98259.02551423Milks non dairy224.55120.75297.14912968Oils & Vinegars310.8197.30421.68791815Other33.5333.9025.949088Packaging62.2728.41105.6202320Pasta114.2259.50138.5218488Pastas35.8035.803636Personal Products84.3846.71114.3182676Salad Greens24.5024.502525Snacks20.3320.33.7422021
BUS501 Assignment | Business Analysis and Statistics_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
BUS501 - Business Analytics and Statistics | Good Harvest
|19
|3672
|28

Accounting Fundamentals Assignment
|19
|2314
|86

BUS501 - Business Analytics and Statistics Assignment
|14
|2578
|66

Assignment BUS501 | Business Analytics and Statistics
|17
|3164
|169

Assignment BUS501 - Business Analytics and Statistics
|14
|2525
|105

Business Analytics and Statistics Research Report - Desklib
|27
|4777
|498