ACME Toy Supplies

unit
price unit cost
Date customer Sales Rep Product Qty /retail /wholesale
Dec-30 Target Steve Nano Drone 43 $ 44 $ 21
Dec-02 Kmart Helen Barbie 65 $ 29 $ 20
Dec-23 Kmart Bob Nano Drone 97 $ 44 $ 21
Dec-18 ToysR'us Helen Barbie 47 $ 29 $ 20
Dec-22 ToysR'us Helen Barbie 78 $ 29 $ 20
Dec-24 Target Jane Barbie 118 $ 29 $ 20
Dec-27 Big W Bob Barbie 71 $ 29 $ 20
Dec-01 Big W Bob Star Wars 66 $ 39 $ 29
Dec-16 Kmart Jane Star Wars 68 $ 39 $ 29
Dec-24 Kmart Bob Star Wars 137 $ 39 $ 29
Dec-29 Kmart Helen Star Wars 59 $ 39 $ 29
Dec-08 Target Jane Selfie Star 46 $ 19 $ 11
Dec-04 Kmart Steve Nano Drone 27 $ 44 $ 21
Dec-04 Target Bob Nano Drone 32 $ 44 $ 21
Dec-22 Big W Helen Nano Drone 55 $ 44 $ 21
Dec-12 Kmart Jane Lego 37 $ 58 $ 45
Dec-23 Target Helen Nano Drone 125 $ 44 $ 21
Dec-23 ToysR'us Helen Nano Drone 109 $ 44 $ 21
Dec-21 Target Jane Lego 66 $ 58 $ 45
Dec-03 ToysR'us Helen Lego 25 $ 58 $ 45

Question 1: Customer Total sales

Target 16924
Kmart 19783
ToysR'us 9871
Big W 7053

Question 2: Sales representive Total sales

Steve 3080
Helen 21977
Bob 15652
Jane 12922

Question 3: Product Profit

Nano Drone 11224
Barbie 3411
Star Wars 3300
Selfie Star 368
Lego 1664

Question 4: Based on sales data, The best seller product is Nano Drone, the best sales representative is Helen
 total unit
total costs
sales /Retail /wholesale Profit
$ 1,892 $ 903 $ 989
$ 1,885 $ 1,300 $ 585
$ 4,268 $ 2,037 $ 2,231
$ 1,363 $ 940 $ 423
$ 2,262 $ 1,560 $ 702
$ 3,422 $ 2,360 $ 1,062
$ 2,059 $ 1,420 $ 639
$ 2,574 $ 1,914 $ 660
$ 2,652 $ 1,972 $ 680
$ 5,343 $ 3,973 $ 1,370
$ 2,301 $ 1,711 $ 590
$ 874 $ 506 $ 368
$ 1,188 $ 567 $ 621
$ 1,408 $ 672 $ 736
$ 2,420 $ 1,155 $ 1,265
$ 2,146 $ 1,665 $ 481
$ 5,500 $ 2,625 $ 2,875
$ 4,796 $ 2,289 $ 2,507
$ 3,828 $ 2,970 $ 858
$ 1,450 $ 1,125 $ 325

sentative is Helen
ACME Café Sales

Order time Customer

10:15 Jane
7:03 Bill
12:14 Jim
7:07 Jim
12:09 Jeff
7:55 Mary
8:31 Stuart
7:45 Alice
8:45 Steve
8:53 Mike
9:01 Rod
7:09 Bob
10:04 Jim
10:13 Gavin
11:55 Raj
12:04 Joe
8:34 Peter
10:02 Jeff
12:12 George
7:00 Jeff

Questions:
Q1
Q2
Q3
Q4
Drinks
Flat White
Flat White
Water
Cappucino
Latte
Flat White
Tea
Latte
Latte
Flat White
Latte
Latte
Cappucino
Tea
Latte
Coke
Flat White
Latte
Coke
Latte

Who are ACME Cafés best customer by total sales

Who is ACME Cafés best barrista/sales rep by quantities sold
What is the overall profit from each sale. (may require additional columns to be added)
Based on the sales data, identify a pattern or trend
 Qty Size
4 S
1 M
4 L
1 L
2 S
2 L
1 M
4 M
1 L
4 M
1 L
4 M
2 S
2 M
1 S
1 L
2 M
1 S
3 M
1 S

Jim
Latte
Latte
Based on the sales data, Latte is the best-seller drink and Jim is the best custormer
unit price unit cost total sales total unit
/retail /wholesale /Retail costs /wholesale Profit
$ 3.00 $ 2.20 $ 12.00 $ 8.80 $ 3.20
$ 3.80 $ 2.90 $ 3.80 $ 2.90 $ 0.90
$ 4.00 $ 3.20 $ 16.00 $ 12.80 $ 3.20
$ 4.00 $ 3.00 $ 4.00 $ 3.00 $ 1.00
$ 3.00 $ 2.20 $ 6.00 $ 4.40 $ 1.60
$ 4.00 $ 3.00 $ 8.00 $ 6.00 $ 2.00
$ 3.50 $ 1.50 $ 3.50 $ 1.50 $ 2.00
$ 3.00 $ 2.20 $ 12.00 $ 8.80 $ 3.20
$ 4.00 $ 3.00 $ 4.00 $ 3.00 $ 1.00
$ 3.80 $ 2.90 $ 15.20 $ 11.60 $ 3.60
$ 4.00 $ 3.00 $ 4.00 $ 3.00 $ 1.00
$ 3.80 $ 2.90 $ 15.20 $ 11.60 $ 3.60
$ 3.00 $ 2.20 $ 6.00 $ 4.40 $ 1.60
$ 3.50 $ 1.50 $ 7.00 $ 3.00 $ 4.00
$ 3.00 $ 2.20 $ 3.00 $ 2.20 $ 0.80
$ 4.20 $ 3.50 $ 4.20 $ 3.50 $ 0.70
$ 3.80 $ 2.90 $ 7.60 $ 5.80 $ 1.80
$ 3.00 $ 2.20 $ 3.00 $ 2.20 $ 0.80
$ 3.80 $ 3.10 $ 11.40 $ 9.30 $ 2.10
$ 3.00 $ 2.20 $ 3.00 $ 2.20 $ 0.80
ACME Snack Supplies

Date Customer
Jan-25 7 Eleven
Jan-03 IGA
Jan-30 Coles
Jan-28 IGA
Jan-05 7 Eleven
Jan-09 BP
Jan-12 Coles
Jan-31 IGA
Jan-24 Coles
Jan-23 Coles
Jan-24 BP
Jan-29 Coles
Jan-24 7 Eleven
Jan-25 IGA
Jan-27 Coles
Jan-02 Coles
Jan-27 Shell
Jan-25 Coles
Jan-19 Coles
Jan-22 IGA

Questions:
Q1
Q2
Q3
Q4

Question 3:
Sales Rep Product
Pam Twisties
Alice Smiths
Jimmy CC's
Alice Twisties
Jimmy Twisties
Jimmy Kettle
Pam Twisties
Ahmed Kettle
Pam Smiths
Craig Smiths
Jimmy CC's
Ahmed Smiths
Pam Smiths
Pam Smiths
Ahmed Smiths
Craig Smiths
Alice CC's
Pam Twisties
Alice CC's
Craig CC's

Who are ACME Snack Supplies best customer by total sales Coles
Who is ACME Snack Supplies best sales rep by quantities sold Pam
What is the overall profit from each sale. (may require additional columns to be added)
Based on the sales data, identify a pattern or trend Coles has the largest overall sales, T

Sale Profit
Twisties 415
Smiths 348
CC's 354
Kettle 34
 unit price unit cost total sales total unit
Qty /retail /wholesale /Retail costs /wholesale Profit
19 $ 15 $ 10 $ 285 $ 190 $ 95
11 $ 19 $ 17 $ 209 $ 187 $ 22
7 $ 24 $ 18 $ 168 $ 126 $ 42
8 $ 15 $ 10 $ 120 $ 80 $ 40
9 $ 15 $ 10 $ 135 $ 90 $ 45
4 $ 22 $ 18 $ 88 $ 72 $ 16
16 $ 15 $ 10 $ 240 $ 160 $ 80
3 $ 24 $ 18 $ 72 $ 54 $ 18
39 $ 19 $ 17 $ 741 $ 663 $ 78
36 $ 19 $ 17 $ 684 $ 612 $ 72
11 $ 24 $ 18 $ 264 $ 198 $ 66
9 $ 19 $ 17 $ 171 $ 153 $ 18
20 $ 19 $ 17 $ 380 $ 340 $ 40
33 $ 19 $ 17 $ 627 $ 561 $ 66
11 $ 19 $ 17 $ 209 $ 187 $ 22
15 $ 19 $ 17 $ 285 $ 255 $ 30
6 $ 24 $ 18 $ 144 $ 108 $ 36
31 $ 15 $ 10 $ 465 $ 310 $ 155
21 $ 24 $ 18 $ 504 $ 378 $ 126
14 $ 24 $ 18 $ 336 $ 252 $ 84

as the largest overall sales, Twisties is the product that generates the most profit, Pam is the greatest seller.