Limited-time offer! Save up to 50% Off | Solutions starting at $6 each  

BUS501 Assignment | Business Analysis and Statistics

Added on - 15 Mar 2020

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 17 pages
Running Head: BUS501 – BUSINESS ANALYSIS AND STATISTICSBUS501 – Business Analysis and StatisticsName of the StudentName of the UniversityAuthor Note
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
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 onwhere the product is located in theshop? How does this effect both profits and revenue?
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
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document