Which product categories are making the most profit

Assignment Help Business Management
Reference no: EM132120593

Business Analytics and Statistics Research Report Assignment -

You are creating a business report for the CEO of a retail company called, Athlete Panda. It must be professional in presentation and contain insightful content for them to make business decisions.

Both data sets are from a small retail store that sells athletic clothing, shoes and products. The business is divided into a number of areas including Men's, Women's, Boys, Girls, and Customisation. The product range includes shoes, clothing, accessories and sporting equipment. The customisation section allows customers to customise their sneakers depending on use, such as lifestyle, running, gym & training, football, basketball and skateboarding. There are also options to customise the children's line.

The shops stocks brands such as Nike, Adidas, Puma, New Balance, Under Armour, ASICS, and Converse.

The brick and mortar shop has been open for about five years and has just started trading online for one year.

You have been given two data sets and the data is inclusive of a whole year of trading.

1. The first dataset labelled "Customer attributes" lists the results of an online survey given to customers.

a. The variables include:

i. "User_Group" which shows how often people visit the store, where "Not often" is defined as less than once a fortnight/month, "Moderate" is once a fortnight, "Often" is more than once a week.

ii. "Gender" - male or female

iii. The dataset also lists the customer attitudes which is six variables consisting of: "Knowledge", "Satisfaction", "Preference", "Purchase intentions", "Loyalty" and "Recommend"

These items were measured on a 7-point Likert scale. See values column for exact wording.

2. The second dataset lists the Shop sales.

a. The variables include:

b. Month of purchase

c. Product category (1= men shoes, 2 = men's clothing, 3 = women's shoes, 4 = women's clothing, 5 = customise, 6 = boys shoes, 7 = boys clothing, 8 = girls shoes, 9 = girls clothing)

d. The costs of the goods (COGS)

e. Whether the total purchases were paid with Cash or Credit card

f. The profit total

g. The location ( 1 = front, 2 = middle, 3 = back, 4 = online)

h. Whether it was on the website or in the store (1 = website, 2 = store)

The CEO states that the main challenges in the business are profit, Cost of Goods (COGS margins) and how to increase sales. They want to know how to increase sales and how their customers feel about the store.

Task instructions:

Using what you have learned in the lectures and the tutorials answer the main research questions below. Then consider the dataset and answer any other research questions you can identify that are meaningful to the CEO.

As guide - answer these main research questions:

1. Which product categories are making the most profit?

2. Which product category costs the most (COGS)?

3. Is there a difference in payments methods?

4. Is there a difference in store location and sales?

5. Are there any differences in the user groups on all of the customer attitudes?

6. Are there any differences in gender on all of the customer attitudes?

There are other research questions you should consider and report on at least one.

Do not worry if you are using a lot of the same analysis to report on the research questions.

There are right and wrong answers when it comes to statistical analysis. You must know and demonstrate your knowledge of this. Hint: Do not confuse t-tests with ANOVA.

Report structure:

Cover page/Title Page - Name, student number, tutor information, word count.

Table of contents (could also include a list of figures / graphs / tables).

Introduction - Introduce the business and its problems. Describe the company, what does it do, what is the company profile. Paraphrase this information and add to it as it is an imaginary company.

Problem definition and business intelligence required: List each of the research questions and list what analytics methods you have chosen to answer each question and why. Use references to academic definitions of the statistics, such as textbooks and journal articles. For example, if you used an ANOVA - list the research question, explain why an ANOVA was most appropriate by defining what an ANOVA is and does (use references to statistical textbooks and websites).

Results of the selected analytics methods and technical analysis: Use each research question as a heading.  Present the relevant descriptive statistics through data visualization/ graphical displays (Tables, graphs, pie charts etc.).  Present the main analysis results and explain them. Higher marks for including extra research questions not defined in this document and creating nice tables/displays opposed to copy and pasting directly from SPSS output.

Discussion of the results and recommendations: 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.

Appendix - Include copies of the output from SPSS exactly as it is.

Reference no: EM132120593

Questions Cloud

Determine how large is the demographic : (Introductory) Who is in Gen Z and how large is this demographic? (Advanced) List and briefly describe at least four generalizations or qualities of Gen Z.
Produce the level of output : "In order to maximize profits a firm should produce the level of output which yields the largest vertical gap between TR and TC curves."
Describe what you think creativity is : Post an example of (or link to) something related to your personal or academic interest that you think is particularly creative.
Supreme court ruling in christy brzonkala j morrison : What was the Supreme court ruling in christy Brzonkala J Morrison .et al. the case in the text involving the constitutionally of the section of the violence
Which product categories are making the most profit : BUS501-Business Analytics and Statistics Research Report Assignment, University of the Sunshine Coast. Which product categories are making most profit
Staff liaison for neighborhood association for downtown : You work as a property manager and staff liaison for a neighborhood association for a downtown neighborhood that recently has undergone urban renewal.
Develop a new diversity policy and training series : Design a presentation that you will use to present your training plans to your supervisor and the HR department.
How sections come together to produce a comprehensive plan : This assignment entails development of a comprehensive strategic marketing plan for a new product or service that is ready to "go to market".
Real price of milk : Therefore, the real price of milk in 2010 expressed in 1995 dollars was ?$ nothing. (Enter your answer rounded to two decimal? places.)

Reviews

len2120593

9/23/2018 11:47:29 PM

This is an individual assessment. Report formatting: 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. This assignment is based on fictional data - do not contact the company listed below. Demonstrates comprehensive and insightful knowledge of the business with an in-depth introduction to the business and the problems. The introduction covers who the company is and what it does.

len2120593

9/23/2018 11:47:22 PM

Each problem and the business intelligence/statistics required are described and explained with references where appropriate to literature. Demonstrates comprehensive and insightful knowledge of the use of business analytic tools to answer the report questions and others identified by the student in the data set. The selected methods are first presented with the use of descriptive statistics and data visualisation. Then the main analysis is presented. 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.

len2120593

9/23/2018 11:47:17 PM

The recommendations are highly appropriate, integrated with the results, and supported by results/literature. The entire report is presented as a consistent whole. 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.

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd