Imagine Joy is the sales manager in a computer retail company and has summarized for each sales transaction the following information:
- Sales person
- Date of sales
- Units sold or returned
- Total price received or paid out for returns
The data appear below. Joy needs you to find out the following with appropriate titles for the items specified above:
a) The total $ amount of items sold by each salesperson
b) The # of units returned
c) The total $ amount of sales in or after 2005
d) The total $ amount of sales made by someone other than Tim.
e) Among transactions involving at least 40 units, the average # of Inspiron in each sale made by Zaret.
|
Trans #
|
Name
|
Date
|
Product
|
Units
|
Dollars
|
|
1
|
Betsy
|
4/1/2004
|
Inspiron
|
45
|
$ 137.20
|
|
2
|
Jim
|
3/10/2004
|
Vostro
|
50
|
$ 152.01
|
|
3
|
Ashley
|
2/25/2005
|
XPS
|
9
|
$ 28.72
|
|
4
|
Jim
|
5/22/2006
|
Inspiron
|
55
|
$ 167.08
|
|
5
|
Zaret
|
6/17/2004
|
Inspiron
|
43
|
$ 130.60
|
|
6
|
Tim
|
11/27/2005
|
Adamo
|
58
|
$ 175.99
|
|
7
|
Joe
|
3/21/2004
|
Adamo
|
8
|
$ 25.80
|
|
8
|
Tim
|
12/17/2006
|
Inspiron
|
72
|
$ 217.84
|
|
9
|
Ashley
|
7/5/2006
|
Adamo
|
75
|
$ 226.64
|
|
10
|
Betsy
|
8/7/2006
|
Inspiron
|
24
|
$ 73.50
|
|
11
|
Ashley
|
11/29/2004
|
Latitude
|
43
|
$ 130.84
|
|
12
|
Ashley
|
11/18/2004
|
Inspiron
|
23
|
$ 71.03
|
|
13
|
Joe
|
8/31/2005
|
Inspiron
|
49
|
$ 149.59
|
|
14
|
Jim
|
1/1/2005
|
Adamo
|
18
|
$ 56.47
|
|
15
|
Zaret
|
9/20/2006
|
Vostro
|
-8
|
$ (21.99)
|
|
16
|
Joe
|
4/12/2004
|
Latitude
|
45
|
$ 137.39
|
|
17
|
Tim
|
4/30/2006
|
Latitude
|
66
|
$ 199.65
|
|
18
|
Tim
|
8/31/2005
|
Inspiron
|
88
|
$ 265.19
|
|
19
|
Betsy
|
10/27/2004
|
Adamo
|
78
|
$ 236.15
|
|
20
|
Zaret
|
11/27/2005
|
Inspiron
|
57
|
$ 173.12
|
|
21
|
Joe
|
6/2/2006
|
XPS
|
12
|
$ 38.08
|
|
22
|
Tim
|
9/24/2004
|
Latitude
|
28
|
$ 86.51
|
|
23
|
Betsy
|
2/1/2006
|
Adamo
|
25
|
$ 77.31
|
|
24
|
Zaret
|
5/2/2005
|
Vostro
|
29
|
$ 88.22
|
|
25
|
Ashley
|
11/7/2004
|
XPS
|
-4
|
$ (9.94)
|