Urgenthomework logo
UrgentHomeWork
Live chat

Loading..

Business Analytics Assignment One

  62 Download     📄   6 Pages / 1391 Words

Business Analytics - Assignment One

Part 1 – Excel Analysis

Question 1

Table 1: Summary Statistics – Gross Profit

Sum of GrossProfit $m

140.0179

GrossProfit $m

Mean

0.933

Standard Error

0.055

Median

0.884

Mode

0.937

Standard Deviation

0.675

Sample Variance

0.456

Kurtosis

-0.259

Skewness

0.561

Range

2.854

Minimum

0.018

Maximum

2.872

Sum

140.018

Count

150.000

Q1

0.404

Q3

1.399

IQR

0.995

Lower Fence

-1.088

Upper Fence

2.891

Graph 1: Differentiation of Gross Profit between stores

Business Analytics Assignment One img1

Question 2

Table 2: Gross Profit – Stores Open/ Closed on Sundays

Open/ Close

Sum of GrossProfit $m

Close

47.3049

Open

92.713

Total Profit

140.0179

Graph 2: Gross Profit – Stores Open/ Closed on Sunday

Business Analytics Assignment One img2

Table 3: Descriptive Statistics – Sunday (Open)

Open

Mean

0.996913978

Standard Error

0.074448313

Median

0.976

Mode

1.018

Standard Deviation

0.717953533

Sample Variance

0.515457275

Kurtosis

-0.5148244

Skewness

0.424231921

Range

2.854

Minimum

0.018

Maximum

2.872

Sum

92.713

Count

93

Q1

0.403

Q3

1.496

IQR

1.093

Lower Fence

-1.2365

Upper Fence

3.1355


Graph 3: Gross Profit – Open Sunday

Business Analytics Assignment One img3

Table 4: Descriptive Statistics – Sunday (Closed)

Close

Mean

0.829910526

Standard Error

0.078304954

Median

0.813

Mode

0.937

Standard Deviation

0.591189439

Sample Variance

0.349504953

Kurtosis

0.373557726

Skewness

0.751489208

Range

2.5741

Minimum

0.0459

Maximum

2.62

Sum

47.3049

Count

57

Q1

0.408

Q3

1.168

IQR

0.76

Lower Fence

-0.732

Upper Fence

2.308

Graph 4: Gross Profit – Closed Sunday

Business Analytics Assignment One img4

Question 3

Table 5: Count of Online Channel Start-up

Type of Store

Count of Online Channel

Country

 

No

18

Yes

30

CountryTotal

48

Mall

 

No

19

Yes

43

Mall Total

62

Strip

 

No

8

Yes

32

Strip Total

40

Grand Total

150

Graph 5: Online Channel – Store type comparison

Business Analytics Assignment One img5

Question 4a

Table 6: Wastage levels between all stores (High/ Medium/ Low)

 

Count of Wastage

High

46

Low

23

Medium

81

Grand Total

150

Graph 6: Comparison of total wastage levels between stores

Business Analytics Assignment One img6

Question 4b

Table 7: Wastage levels between states (only high-level wastage shown)

States

Count of Wastage

High

 

ACT

1

NSW

8

NT

1

Qld

11

SA

11

Tas

3

Vic

9

WA

2

High Total

46

Grand Total

46

Graph 7: High wastage between state comparison

Business Analytics Assignment One img7

Question 5a

Table 7: Advertising expenses compared to percentage of total sales ($m) associated

Advertising expenses $'000

Count of Sales $m

0-24

0.67%

25-49

4.00%

50-74

8.00%

75-99

10.67%

100-124

22.67%

125-149

12.67%

150-174

8.67%

175-199

9.33%

200-224

10.67%

225-249

4.00%

250-274

2.67%

275-299

3.33%

300-324

1.33%

325-349

0.67%

350-374

0.67%

Grand Total

100.00%

Table 8: Descriptive Statistics – Advertising expenses

Adv.$'000

Mean

147.2733

Standard Error

5.551708

Median

130.5

Mode

213

Standard Deviation

67.99427

Sample Variance

4623.22

Kurtosis

0.328003

Skewness

0.733271

Range

349

Minimum

20

Maximum

369

Sum

22091

Count

150

Graph 8: Comparison – advertising expenses & count of total sales (%)

Business Analytics Assignment One img8

Question 5b

Table 9: Number of staff compared to percentage of total sales ($m)

Number of staff

Count of Sales $m

30-39

2.00%

40-49

16.67%

50-59

34.00%

60-69

22.00%

70-79

14.00%

80-89

7.33%

90-99

2.67%

100-109

0.67%

110-119

0.67%

Grand Total

100.00%

Graph 9: Comparison – number of staff & Sales ($m)

Business Analytics Assignment One img9

Question 5b

Table 10: Number of car spaces to percentage of total sales ($m)

Question 5 Sales & Number of car spaces

Car Spaces

Count of Sales $m

0-9

1.33%

10-19

6.67%

20-29

22.00%

30-39

20.00%

40-49

16.67%

50-59

12.00%

60-69

8.00%

70-79

5.33%

80-89

4.00%

90-99

2.00%

100-109

1.33%

110-119

0.67%

Grand Total

100.00%

Graph 10: Comparison – number of car spaces & percentage of total sales

Business Analytics Assignment One img10

Question 5d

Table 11: Number of trading hours compared to count of total sales %

Trading hours per week

Count of Sales %

70-79

12.67%

80-89

17.33%

90-99

18.00%

100-109

15.33%

110-119

13.33%

120-129

9.33%

130-139

8.67%

140-149

2.67%

150-159

2.00%

160-169

0.67%

Grand Total

100.00%

Graph 11: Comparison – trading hours & count of total sales (%)

Business Analytics Assignment One img11

Part 2 – Email

To: Grace Wong

From: Stephen Hennigsson

Subject: Analysis of Store Data

Dear Grace,

I have taken on your challenge of the specific requirements you have asked me to investigate and have found some very interesting results. The information found will not only be able to show you where to focus on improving certain areas, but also look at where we as a company are striving which will allow for goal management and obtainment. As a courtesy, I have provided my answers to your questions underneath each question.

1. Can you provide me with an overall summary of Gross Profit?

  • Average across all stores = $933,452.67
  • Highest earning store = $2,872,000
  • Lowest earning store = $18,000
  • Majority of stores earned between $250,000 & $500,000
  • Total gross profit amongst all stores = $140,000,000

2. The board wants to revisit the issue of whether it should now be compulsory for our stores to be open every day of the week, including Sunday, to aggressively compete with our major competitors. Can you provide a gross profit comparison for our stores that open on Sunday and those that do not?

  • Closed Sunday earned gross profit of $47,304,900
  • Open Sunday earned gross profit of $92,713,000
  • Average gross for closed on Sunday is $829,911
  • Average gross for open on Sunday $996,914
  • Difference between average gross is $167,003
  • Highest gross profit for open Sunday store is $2,872,000
  • Lowest gross profit for open Sunday store is $18,000
  • Highest gross profit for close Sunday store is $2,620,000
  • Lowest gross profit for close Sunday store is $45,900

3. As you know, our latest initiative has been the creation of our store online channel. I know many of our stores have included the online channel as part of their business operations. I have heard that Mall stores are leading the way when it comes to setting up online stores. Is there any evidence of this?

  • Country Stores
    • 18 stores have not set up an online channel
    • 30 stores have set up an online channel
  • Mall Stores
    • 19 stores have not set up an online channel
    • 43 stores have set up an online channel
  • Strip Stores
    • 8 stores have not set up an online channel
    • 32 stores have set up an online channel

Based on the evidence above, it is obvious that the Mall stalls are leading the way when it comes to setting up online stores.

4. Wastage (unsold stock) is expensive to the organisation, especially if maintained at high levels. 

  1. Can you provide me with an overall breakdown of wastage?
    • High à 46 stores
    • Medium à 81 stores
    • Low à 23 Stores
  2. I would also be interested in how the States compare when it comes to high levels of wastage in their stores?
    • ACT = 1 store
    • NSW = 8 stores
    • NT = 1 store
    • QLD = 11 stores
    • SA = 11 stores
    • TAS = 3 stores
    • VIC = 9 stores
    • WA = 2 stores
    • Queensland and South Australia both have the highest ‘high’ wastage levels, 23.91%.
    • Northern Territory and ACT have lowest levels of ‘high’ wastage, 2.17%.

5. I would like to see whether factors listed below provide any explanation in the variation of Sales between stores. If so, can you also indicate which factor is the most important?

  1. Advertising expenses
    1. Average spending on advertising expenses amongst all stores = $147,273
    2. The more amount spent on advertising does not necessarily mean that there will be an increase in sales.
    3. Top store with $23,000,000 in sales, spent $348,000 on advertising
    4. The store which spent $369,000 on advertising only had $19,500,000 in sales
  2. Number of staff
    1. Stores which had approximately 50-59 employees generated the highest sales, 34% of all sales.
    2. Stores with 100-109 & 110-119 employees generated the least amount of sales, 0.67% of total sales each.
    3. As the number of employees increases, this does not necessarily mean that the number of sales will increase accordingly. This progression stops around 60-69 employees, as the number of employees increase from this figure, the number of sales decreases.
  3. Number of car spaces
    1. 20-29 available car spaces showed the highest percentage of sales, 22%
    2. 110-119 car spaces showed the lowest percentage of sales, 0.67%
    3. As the number of car spaces increases this does not influence the in amount of sales generated. This could be due to Supermart being located within a Mall where there are other stores, meaning there would be a lot of car spaces available. However, for the stores with 20-29 car spaces, this could mean that the car spaces are only for Supermart, meaning whoever parks here would purchase something from the store.
  4. Number of trading hours
    1. 90-99 opening hours presented highest total sales percentage, 18%
    2. 160-169 opening hours presented lowest total sales percentages, 0.67%
    3. The correlation between these two could be that if stores had a low number of opening hours, this would mean they would only be open during peak times. However, for the stores that have over 120 trading hours, this could mean that they would be open late at night or 24/7. Overnight, the sales would decrease drastically lowering their total sales percentage.
  5. Most important Factor
    1. From most important to least important
      1. Number of trading hours
      2. Advertising expenses
      3. Number of staff
      4. Number of car spaces

I have attached the requested dashboard to this email, it includes various dimensions which you can explore our Sales and Gross Profit performance. Hopefully you like it and it suits your demands.

Don’t hesitate to ask any questions if you have any.

Kind Regards,

Stephen Hennigsson

Data Analyst

Buy Business Analytics Assignment Answers Online

Talk to our expert to get the help with Business Analytics Assignment to complete your assessment on time and boost your grades now

The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.

Get Online Support for Business Analytics Assignment Help Online


Resources

  • 24 x 7 Availability.
  • Trained and Certified Experts.
  • Deadline Guaranteed.
  • Plagiarism Free.
  • Privacy Guaranteed.
  • Free download.
  • Online help for all project.
  • Homework Help Services

Testimonials

Urgenthomework helped me with finance homework problems and taught math portion of my course as well. Initially, I used a tutor that taught me math course I felt that as if I was not getting the help I needed. With the help of Urgenthomework, I got precisely where I was weak: Sheryl. Read More

Copyright © 2009-2023 UrgentHomework.com, All right reserved.