BUS501 This assignment is based on fictional data.You are creating a business report for the CEO of Honeybee Fruit

This assignment is based on fictional data.You are creating a business report for the CEO of Honeybee Fruit. It must be professional in presentation and contain insightful content for them to make business decisions.

Task Instructions:

Use the statistical analyses you have learned to answer all of the questions below

This first dataset is labelled “Fruit shop data product mix”:

  • The variables include:
    • Product class
    • Product name
    • Product category
    • Total sales
    • Cost of Goods (COGs)
    • Net profit
    • Location in the shop – front, left, outside front, rear, right
    • Profit total

The second data set is labelled “Fruit shop data sales summary”:

  • The variables include:
    • Month (January, February, March, April, May, June, July, August, September, November, December)
    • Season (Spring, summer, autumn, winter)
    • Gross sales
    • Net sales
    • Cash total payments
    • Credit total payments
    • Total orders
    • Average sale
    • Staff cost
    • Profit total

Answer these main research questions:

  1. What are the best and worst selling products in terms of sales?
  2. Is there a difference in payments methods? (Cash vs Credit)
  3. Are the differences in sales performance based on where the product is located in the shop? How does this effect both profits and revenue?
  4. Is there a difference in sales and gross profits between different months of the year?
  5. Are their differences in sales performance between different seasons? (Summer, spring, autumn, winter)

For faster services, inquiry about  new assignments submission or  follow ups on your assignments please text us/call us on  +1(629)-237-5579