Unformatted Attachment Preview
New Perspectives Excel 2013
Tutorial 5: SAM Project 1b
Fit Kix Footwear
WORKING WITH TABLES, PIVOTTABLES, AND PIVOTCHARTS
Author:
Abdullah Alessa
Note: Do not edit this sheet. If your name does not appear in cell B6,
please download a new copy of the file from the SAM website.
Fit Kix Footwear - Westview Store Employees
LastName
FirstName
Store
Position
Phillips
Walters
Vandergrift
Wang
Patterson
Khatri
Harris
DiCristina
Langman
Pandey
Potter
Rosich
Bajwa
Freiberg
Gabinelli
Casey
Morgan
Adam
Kevin
Kiley
Samir
Zachary
Jordan
Emily
Akasha
Michael
Mallory
Guhan
Gregory
Jesse
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Floor
Floor
Floor
Register
Register
Manager
Asst Manager
Asst Manager
Floor
Register
Floor
Floor
Register
Floor
Floor
2018 Hourly 2018 Weekly
Rate
Hours
$8.00
15
$8.25
15
$8.00
25
$10.00
15
$10.25
20
$25.00
40
$18.75
35
$17.75
30
$8.50
10
$11.00
12
$8.25
15
$8.25
12
$10.50
25
$8.75
12
$8.25
12
2016 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,584
6,769
9,251
45,125
29,613
3,836
5,957
5,584
4,467
11,845
4,738
4,468
2017 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,700
5,878
7,125
9,738
47,500
31,172
25,294
4,038
6,270
5,878
4,703
12,469
4,988
4,703
2018 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
6,000
6,188
10,000
7,500
10,250
50,000
32,813
26,625
4,250
6,600
6,188
4,950
13,125
5,250
4,950
Fit Kix Footwear - Fontaine Store Employees
LastName
FirstName
Store
Position
Foss
Peterson
Hu
Lowe
Little
Kamiredi
Jeffers
Hirata
Weaver
Schultz
Perez
Silva
George
Diaz
Griffiths
Lee
Ellen
Kyle
Alex
Stephen
Jenna
Sonali
Sonya
Yuki
Cassie
Max
Nina
Alex
Walter
Gabriella
Sandy
Sammy
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Floor
Register
Floor
Register
Floor
Manager
Asst Manager
Floor
Floor
Register
Floor
Register
Register
Asst Manager
Asst Manager
Register
2018 Hourly 2018 Weekly
Rate
Hours
$8.00
15
$10.50
18
$8.00
12
$9.75
10
$8.75
20
$24.00
40
$15.75
24
$8.00
24
$8.25
12
$11.00
24
$8.25
24
$11.50
12
$10.50
10
$17.00
24
$17.00
24
$11.50
10
2016 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
8,529
4,400
7,897
43,320
17,057
4,467
11,913
8,935
6,227
4,738
18,411
18,411
5,189
2017 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,700
8,978
4,560
4,631
8,313
45,600
17,955
4,703
12,540
9,405
6,555
4,988
19,380
19,380
5,463
2018 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
6,000
9,450
4,800
4,875
8,750
48,000
18,900
9,600
4,950
13,200
9,900
6,900
5,250
20,400
20,400
5,750
Fit Kix Footwear - Willow Store Employees
LastName
FirstName
Store
Position
Larsen
Doherty
Phelan
Whitney
Escada
Kramer
Yang
Huang
Ryan
DeSouza
Kong
Rocha
Shields
Crowley
Reinhardt
Alisa
Meghan
Amrit
Michael
Julio
Lars
Doris
Caitlin
Elizabeth
Jonathan
Jason
Angel
Robert
Declan
Bettina
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Floor
Floor
Register
Register
Floor
Manager
Register
Asst Manager
Floor
Register
Floor
Floor
Register
Register
Asst Manager
2018 Hourly 2018 Weekly
Rate
Hours
$8.00
15
$8.25
15
$10.50
25
$10.00
15
$9.00
20
$23.00
40
$11.00
24
$16.50
30
$8.50
10
$11.00
12
$8.25
15
$8.25
12
$10.50
25
$11.75
10
$18.00
24
2016 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,584
11,845
6,769
8,123
41,515
11,913
22,337
3,836
5,957
4,467
11,845
5,302
19,494
2017 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,878
12,469
7,125
8,550
43,700
12,540
23,513
4,038
6,270
5,878
4,703
12,469
5,581
20,520
2018 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
6,000
6,188
13,125
7,500
9,000
46,000
13,200
24,750
4,250
6,600
6,188
4,950
13,125
5,875
21,600
Fit Kix Footwear - Highgate Store Employees
LastName
FirstName
Store
Position
Coughlin
Joyce
McLaughlin
Kumar
Cote
Kelly
Martin
Jiang
McLaughlin
Datta
Sabot
Rejto
Silva
Foster
Boheim
Meyers
Andrew
Liam
Greg
Ashok
Francis
Ryan
Christina
Wendy
Greg
Anjali
Isaac
Isabelle
Daniela
Paul
Adin
Kristin
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Floor
Floor
Floor
Register
Register
Manager
Asst Manager
Asst Manager
Floor
Floor
Register
Floor
Floor
Register
Floor
Floor
2018 Hourly 2018 Weekly
Rate
Hours
$8.00
12
$8.25
15
$8.00
25
$10.00
15
$10.25
20
$25.00
40
$18.75
35
$17.75
30
$8.00
25
$8.50
10
$11.00
12
$8.25
15
$8.25
12
$10.50
25
$8.75
12
$8.25
12
2016 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,584
9,025
6,769
9,251
45,125
29,613
24,029
9,025
3,836
5,957
11,845
4,738
4,468
2017 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,700
5,878
9,500
7,125
9,738
47,500
31,172
25,294
9,500
4,038
6,270
5,878
12,469
4,988
4,703
2018 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
4,800
6,188
10,000
7,500
10,250
50,000
32,813
26,625
10,000
4,250
6,600
6,188
4,950
13,125
5,250
4,950
Fit Kix Footwear - All Store Employees
LastName
FirstName
Store
Position
Phillips
Walters
Vandergrift
Wang
Patterson
Khatri
Harris
DiCristina
Langman
Pandey
Potter
Rosich
Bajwa
Freiberg
Gabinelli
Foss
Peterson
Hu
Lowe
Little
Kamiredi
Jeffers
Hirata
Weaver
Schultz
Perez
Silva
George
Diaz
Griffiths
Lee
Larsen
Doherty
Phelan
Whitney
Escada
Kramer
Yang
Huang
Ryan
DeSouza
Kong
Rocha
Casey
Morgan
Adam
Kevin
Kiley
Samir
Zachary
Jordan
Emily
Akasha
Michael
Mallory
Guhan
Gregory
Jesse
Ellen
Kyle
Alex
Stephen
Jenna
Sonali
Sonya
Yuki
Cassie
Max
Nina
Alex
Walter
Gabriella
Sandy
Sammy
Alisa
Meghan
Amrit
Michael
Julio
Lars
Doris
Caitlin
Elizabeth
Jonathan
Jason
Angel
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Westview
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Fontaine
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Willow
Floor
Floor
Floor
Register
Register
Manager
Asst Manager
Asst Manager
Floor
Register
Floor
Floor
Register
Floor
Floor
Floor
Register
Floor
Register
Floor
Manager
Asst Manager
Floor
Floor
Register
Floor
Register
Register
Asst Manager
Asst Manager
Register
Floor
Floor
Register
Register
Floor
Manager
Register
Asst Manager
Floor
Register
Floor
Floor
2018 Hourly 2018 Weekly
Rate
Hours
$8.50
15
$8.25
15
$8.00
25
$10.00
15
$10.25
20
$25.00
40
$18.75
35
$17.75
30
$8.50
10
$11.00
12
$8.25
15
$8.25
12
$10.50
25
$8.75
12
$8.25
12
$8.00
15
$10.50
18
$8.00
12
$9.75
10
$8.75
20
$24.00
40
$15.75
24
$8.00
24
$8.25
12
$11.00
24
$8.25
24
$11.50
12
$10.50
10
$17.00
24
$17.00
24
$11.50
10
$8.00
15
$8.25
15
$10.50
25
$10.00
15
$9.00
20
$23.00
40
$11.00
24
$16.50
30
$8.50
10
$11.00
12
$8.25
15
$8.25
12
Shields
Crowley
Reinhardt
Billings
Coughlin
Joyce
McLaughlin
Kumar
Cote
Kelly
Martin
Jiang
McLaughlin
Datta
Sabot
Rejto
Silva
Foster
Boheim
Meyers
Robert
Declan
Bettina
Christian
Andrew
Liam
Greg
Ashok
Francis
Ryan
Christina
Wendy
Greg
Anjali
Isaac
Isabelle
Daniela
Paul
Adin
Kristin
Willow
Willow
Willow
Willow
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Highgate
Register
Register
Asst Manager
Floor
Floor
Floor
Floor
Register
Register
Manager
Asst Manager
Asst Manager
Floor
Floor
Register
Floor
Floor
Register
Floor
Floor
$10.50
$11.75
$18.00
$8.00
$8.00
$8.25
$8.00
$10.00
$10.25
$25.00
$18.75
$17.75
$8.00
$8.50
$11.00
$8.25
$8.25
$10.50
$8.75
$8.25
25
10
24
12
12
15
25
15
20
40
35
30
25
10
12
15
12
25
12
12
2016 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,584
6,769
9,251
45,125
29,613
3,836
5,957
5,584
4,467
11,845
4,738
4,468
8,529
4,400
7,897
43,320
17,057
4,467
11,913
8,935
6,227
4,738
18,411
18,411
5,189
5,584
11,845
6,769
8,123
41,515
11,913
22,337
3,836
5,957
4,467
2017 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,700
5,878
7,125
9,738
47,500
31,172
25,294
4,038
6,270
5,878
4,703
12,469
4,988
4,703
5,700
8,978
4,560
4,631
8,313
45,600
17,955
4,703
12,540
9,405
6,555
4,988
19,380
19,380
5,463
5,878
12,469
7,125
8,550
43,700
12,540
23,513
4,038
6,270
5,878
4,703
2018 Wages
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
6,375
6,188
10,000
7,500
10,250
50,000
32,813
26,625
4,250
6,600
6,188
4,950
13,125
5,250
4,950
6,000
9,450
4,800
4,875
8,750
48,000
18,900
9,600
4,950
13,200
9,900
6,900
5,250
20,400
20,400
5,750
6,000
6,188
13,125
7,500
9,000
46,000
13,200
24,750
4,250
6,600
6,188
4,950
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
11,845
5,302
19,494
5,584
9,025
6,769
9,251
45,125
29,613
24,029
9,025
3,836
5,957
11,845
4,738
4,468
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
12,469
5,581
20,520
5,700
5,878
9,500
7,125
9,738
47,500
31,172
25,294
9,500
4,038
6,270
5,878
12,469
4,988
4,703
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
13,125
5,875
21,600
4,800
4,800
6,188
10,000
7,500
10,250
50,000
32,813
26,625
10,000
4,250
6,600
6,188
4,950
13,125
5,250
4,950
Row Labels
Bajwa
Billings
Boheim
Cote
Coughlin
Crowley
Datta
DeSouza
Diaz
DiCristina
Doherty
Escada
Foss
Foster
Freiberg
Gabinelli
George
Griffiths
Harris
Hirata
Hu
Huang
Jeffers
Jiang
Joyce
Kamiredi
Kelly
Khatri
Kong
Kramer
Kumar
Langman
Larsen
Lee
Little
Lowe
Martin
McLaughlin
Meyers
Pandey
Patterson
Perez
Peterson
Phelan
Total 2016 Wages Total 2017 Wages Sum of 2018 Wages
$11,845
$12,469
13125
$0
$0
4800
$4,738
$4,988
5250
$9,251
$9,738
10250
$0
$5,700
4800
$5,302
$5,581
5875
$3,836
$4,038
4250
$5,957
$6,270
6600
$18,411
$19,380
20400
$0
$25,294
26625
$5,584
$5,878
6187.5
$8,123
$8,550
9000
$0
$5,700
6000
$11,845
$12,469
13125
$4,738
$4,988
5250
$4,468
$4,703
4950
$4,738
$4,988
5250
$18,411
$19,380
20400
$29,613
$31,172
32812.5
$0
$0
9600
$0
$4,560
4800
$22,337
$23,513
24750
$17,057
$17,955
18900
$24,029
$25,294
26625
$5,584
$5,878
6187.5
$43,320
$45,600
48000
$45,125
$47,500
50000
$45,125
$47,500
50000
$0
$5,878
6187.5
$41,515
$43,700
46000
$6,769
$7,125
7500
$3,836
$4,038
4250
$0
$0
6000
$5,189
$5,463
5750
$7,897
$8,313
8750
$4,400
$4,631
4875
$29,613
$31,172
32812.5
$18,050
$19,000
20000
$4,468
$4,703
4950
$5,957
$6,270
6600
$9,251
$9,738
10250
$8,935
$9,405
9900
$8,529
$8,978
9450
$11,845
$12,469
13125
Phillips
Potter
Reinhardt
Rejto
Rocha
Rosich
Ryan
Sabot
Schultz
Shields
Silva
Vandergrift
Walters
Wang
Weaver
Whitney
Yang
Grand Total
$0
$5,584
$19,494
$0
$4,467
$4,467
$3,836
$5,957
$11,913
$11,845
$6,227
$0
$5,584
$6,769
$4,467
$6,769
$11,913
$624,983
$5,700
$5,878
$20,520
$5,878
$4,703
$4,703
$4,038
$6,270
$12,540
$12,469
$6,555
$0
$5,878
$7,125
$4,703
$7,125
$12,540
$716,586
6375
6187.5
21600
6187.5
4950
4950
4250
6600
13200
13125
11850
10000
6187.5
7500
4950
7500
13200
788825
Row Labels
Total 2016 Wages Total 2017 Wages Total 2018 Wages
Fontaine
$159,494
$178,149
$197,125
Asst Manager
$53,879
$56,715
$59,700
Floor
$21,299
$32,680
$44,000
Manager
$43,320
$45,600
$48,000
Register
$40,996
$43,154
$45,425
Highgate
$169,265
$189,751
$203,488
Asst Manager
$53,642
$56,466
$59,438
Floor
$36,676
$50,184
$56,575
Manager
$45,125
$47,500
$50,000
Register
$33,821
$35,601
$37,475
Westview
$137,237
$175,454
$195,063
Asst Manager
$29,613
$56,466
$59,438
Floor
$28,678
$35,887
$48,150
Manager
$45,125
$47,500
$50,000
Register
$33,821
$35,601
$37,475
Willow
$158,987
$173,233
$193,150
Asst Manager
$41,831
$44,033
$46,350
Floor
$22,010
$29,046
$41,375
Manager
$41,515
$43,700
$46,000
Register
$53,631
$56,454
$59,425
Grand Total
$624,983
$716,586
$788,825