JP Company Payroll Information

NUM FIRST LAST EMP# DIVISION DEPT DATE of HIRE BEN HRS
1 Sara Kling GW29 Maine Sales 24-Dec-1986 R 35.5
2 Sean Willis GBW09 Connecticut Sales 5-Jul-1985 D 35.5
3 Colleen Abel CW58 New Hampshire Sales 26-Jul-1990 DRH 42
4 Teri Binga AW55 Vermont Sales 7-Jun-1988 RH 40
5 Frank Culbert GBC07 Connecticut Development 12-Jun-1983 DRH 40
6 Kristen DeVinney GBS45 Connecticut Staff 5-Jun-1987 D 35
7 Theresa Califano CW19 New Hampshire Sales 26-Feb-1989 RH 35
8 Barry Bally GC04 Maine Development 15-Apr-1983 D 40
9 Cheryl Halal CA26 New Hampshire Research 1-Feb-1990 DR 35.5
10 Harry Swayne GC25 Maine Development 30-Dec-1990 40
11 Shing Chen GBC05 Connecticut Development 8-Aug-1984 R 35.5
12 Seth Rose CC76 New Hampshire Development 5-Apr-1990 DRH 32
13 Bob Ambrose GW14 Maine Sales 25-Jan-1985 DH 35.5
14 Chris Hume GBS59 Connecticut Staff 12-May-1988 DH 40
15 Robert Murray GBW47 Connecticut Sales 10-Jun-1987 DH 40
16 James Rich GBC11 Connecticut Development 11-Oct-1986 DH 35.5
17 George Gorski CA18 New Hampshire Research 7-May-1985 H 40
18 Paul Hoffman GBS57 Connecticut Staff 19-Dec-1987 H 40
19 Dean Kramer AC49 Vermont Development 23-Jun-1987 RH 40
20 Carol Hill GW18 Maine Sales 21-Jul-1986 35.5
21 Julia Smith GBA19 Connecticut Research 17-Feb-1984 RH 25
22 Jacqueline Banks AS03 Vermont Staff 2-Feb-1984 H 40
23 Jeffrey Strong GW04 Maine Sales 8-Mar-1981 R 40
24 Jeri Lynn MacFall AW07 Vermont Sales 8-Apr-1984 40
25 Sung Kim GA49 Maine Research 15-Nov-1989 DRH 40
26 Theodore Ness CA80 New Hampshire Research 4-Aug-1991 DRH 32
27 Brad Hinkelman GW15 Maine Sales 8-Nov-1985 H 40
28 Robert Cuffaro GBC08 Connecticut Development 18-Sep-1983 DRH 40
29 Donald Reese CS15 New Hampshire Staff 17-Aug-1984 H 32
30 Joanne Parker AW09 Vermont Sales 23-Aug-1984 H 40
31 Susan Drake GBA34 Connecticut Research 13-Dec-1989 R 25
32 James Abel GBC29 Connecticut Development 5-Feb-1991 35
33 Laura Reagan GBW77 Connecticut Sales 12-Aug-1990 RH 35
34 Brian Smith GS40 Maine Staff 5-Nov-1988 D 40
35 Mary Barber GW32 Maine Sales 25-Nov-1987 D 35.5
36 Peter Allen AW24 Vermont Sales 31-May-1986 40
37 Mary Altman GC12 Maine Development 9-Sep-1987 H 29.5
38 Fred Mallory CA06 New Hampshire Research 17-Jun-1983 D 38
39 Molly Steadman GBC65 Connecticut Development 15-Aug-1989 DH 40
40 Greg Connors GBC49 Connecticut Development 4-Nov-1987 38
41 Kathy Mayron GBA29 Connecticut Research 19-May-1986 DR 40
42 Bill Simpson GS07 Maine Staff 12-Jan-1982 40
43 Michael Richardson GBA28 Connecticut Research 23-Mar-1986 DH 35
44 Melanie Bowers AA35 Vermont Research 5-Dec-1986 DR 15.5
45 Kyle EarnhSales GBS16 Connecticut Staff 8-Oct-1984 H 40
46 Lance Davies GBC64 Connecticut Development 30-Dec-1988 DRH 32
47 Anne Davidson CC23 New Hampshire Development 6-Apr-1986 RH 25
48 Doug Briscoll CA40 New Hampshire Research 26-May-1987 R 38
49 George Feldsott GW37 Maine Sales 3-Dec-1987 DRH 35.5
50 Steve Singer AS29 Vermont Staff 5-Oct-1986 R 40
51 Carol Tucker GBA14 Connecticut Research 12-Apr-1984 38
52 Henry Paterson GC20 Maine Development 28-Oct-1987 RH 40
53 Brooks Hillen GBA21 Connecticut Research 15-Jan-1986 RH 35
54 Dominick Mazza GBC09 Connecticut Development 10-Oct-1986 40
55 Jennifer Snyder CW30 New Hampshire Sales 7-Jun-1988 25
56 Joshua Maccaluso AW69 Vermont Sales 23-Jan-1991 DRH 40
57 Bill Wheeler GBW05 Connecticut Sales 14-Aug-1981 R 38
58 Todd Masters GBS69 Connecticut Staff 23-Nov-1989 DR 40
59 Karina Abel GW30 Maine Sales 12-Jan-1987 DH 42
60 Edward Trelly AC27 Vermont Development 17-Jun-1986 DR 40
61 Christina Lillie GBA24 Connecticut Research 29-May-1987 RH 25
62 Michael Lewis AW58 Vermont Sales 27-Apr-1989 15.5
63 Jerry McDonald GA08 Maine Research 7-Jul-1982 DR 40
64 Lynne Simmons AC17 Vermont Development 23-Nov-1988 R 35
65 Lindsey Winger AA25 Vermont Research 1-Feb-1986 DR 35
66 Chris Reed CW03 New Hampshire Sales 27-Mar-1984 D 35.5
67 Paula Robinson GA23 Maine Research 7-Dec-1987 29.5
68 William Abel GBW66 Connecticut Sales 14-Oct-1989 DR 40
69 Shirley Dandrow CC45 New Hampshire Development 14-Mar-1991 DR 35
70 Kim Smith GS54 Maine Staff 27-Nov-1989 RH 42
71 Maria Switzer GC26 Maine Development 3-Jun-1991 RH 29.5
72 John Jacobs GA27 Maine Research 4-Oct-1986 DR 40
73 Bradley Howard GBW12 Connecticut Sales 14-Feb-1984 DR 40
74 Frieda Binga AA02 Vermont Research 17-Feb-1982 R 40
75 Holly Taylor GC07 Maine Development 17-Aug-1984 D 29.5
76 Tim BSaleshoff GW47 Maine Sales 27-Oct-1989 R 40
77 Esther Williams AW39 Vermont Sales 13-Dec-1986 R 40
78 Theresa Miller CS79 New Hampshire Staff 4-Mar-1991 H 40
79 Marianne Calvin AS23 Vermont Staff 23-Jul-1985 40
80 Sue Petty GW11 Maine Sales 30-Nov-1994 DRH 40
81 Grace Sloan AS12 Vermont Staff 2-Nov-1984 DH 40
82 Richard Gibbs GC24 Maine Development 23-Jan-1989 29.5
83 Lorrie Sullivan AW04 Vermont Sales 3-Mar-1981 DH 15.5
84 Ted Hayes GBA33 Connecticut Research 7-Dec-1986 R 32
85 Helen StewSales GA57 Maine Research 3-May-1990 42
86 Katie Smith CS32 New Hampshire Staff 5-Oct-1986 DH 40
87 Jane Winters GBA23 Connecticut Research 7-Nov-1989 DH 35
88 Paul MSalesin GC02 Maine Development 19-Apr-1979 DRH 40
89 Geoff Brown GBA48 Connecticut Research 1-Jul-1987 D 40
90 Alice Owens AW48 Vermont Sales 2-Mar-1987 RH 15.5
91 Greg Thomas AC53 Vermont Development 24-Dec-1987 DR 40
92 Sam Whitney GS09 Maine Staff 28-Nov-1983 R 40
93 Erin Binga AA70 Vermont Research 8-Apr-1991 RH 40
94 Amy Tooley AW59 Vermont Sales 1-Sep-1990 15.5
HOURLY RATE GROSS PAY
$12.50 $443.75
$13.30 $472.15
$16.75 $703.50
$8.75 $350.00
$12.60 $504.00
$24.00 $840.00
$12.10 $423.50
$21.50 $860.00
$13.30 $472.15
$21.50 $860.00
$13.30 $472.15
$5.50 $176.00
$12.50 $443.75
$7.22 $288.80
$12.60 $504.00
$13.30 $472.15
$22.00 $880.00
$22.00 $880.00
$15.00 $600.00
$12.50 $443.75
$8.52 $213.00
$8.75 $350.00
$19.50 $780.00
$21.50 $860.00
$15.50 $620.00
$5.50 $176.00
$19.50 $780.00
$12.60 $504.00
$5.50 $176.00
$21.50 $860.00
$8.52 $213.00
$12.10 $423.50
$24.00 $840.00
$19.50 $780.00
$12.50 $443.75
$8.75 $350.00
$6.50 $191.75
$15.50 $589.00
$22.00 $880.00
$15.50 $589.00
$8.22 $328.80
$19.50 $780.00
$24.00 $840.00
 $6.50 $100.75
$22.00 $880.00
$5.50 $176.00
$8.52 $213.00
$15.50 $589.00
$12.50 $443.75
$21.50 $860.00
$15.50 $589.00
$21.50 $860.00
$24.00 $840.00
$21.50 $860.00
$8.52 $213.00
$21.50 $860.00
$15.50 $589.00
$12.60 $504.00
$16.75 $703.50
$8.75 $350.00
$8.52 $213.00
$6.50 $100.75
$15.50 $620.00
$12.10 $423.50
$24.00 $840.00
$13.30 $472.15
$6.50 $191.75
$15.50 $620.00
$12.10 $423.50
$24.00 $1,008.00
$13.30 $392.35
$6.50 $260.00
$7.22 $288.80
$12.10 $484.00
$16.75 $494.13
$6.50 $260.00
$19.50 $780.00
$22.00 $880.00
$15.00 $600.00
$6.50 $260.00
$15.50 $620.00
$15.00 $442.50
$12.60 $195.30
$8.75 $280.00
$15.50 $651.00
$15.00 $600.00
$12.60 $441.00
$6.50 $260.00
$6.50 $260.00
$5.50 $85.25
$16.75 $670.00
 $7.22 $288.80
$12.10 $484.00
$6.50 $100.75
 Sales Figures
January 2020
Salesperson Week 1 Week 2 Week 3 Week 4
R.Smith $4,520 $3,620 $2,560 $2,750
H. James $3,220 $5,230 $4,550 $5,400
S.O'Brian $4,560 $2,320 $3,220 $2,320
L. Carrie $5,600 $6,510 $5,660 $4,500
K. Dunn $2,330 $4,520 $5,500 $4,510
 Pivot Table

Pear Creamery Sales

FY 2020
Month Year Type Salesperson Region Sales Units
January 2019 Ice Cream Bishop North $8,180 5453
January 2019 Frozen Yogurt Pullen Central $3,897 2598
January 2019 Tasty Treats Watson Central $12,371 8247
January 2019 Ice Cream Bishop Central $10,992 7328
January 2019 Popsicles Pullen Central $3,084 2056
February 2019 Ice Cream Watson Central $13,232 8821
February 2019 Frozen Yogurt Bishop West $8,832 5888
February 2019 Tasty Treats Pullen North $3,548 2365
February 2019 Ice Cream Bishop West $13,413 8942
February 2019 Popsicles Bishop West $4,026 2684
February 2019 Ice Cream Pullen West $3,239 2159
March 2019 Frozen Yogurt Watson Central $14,597 9731
March 2019 Tasty Treats Watson Central $8,793 5862
March 2019 Ice Cream Bishop West $2,396 1597
March 2019 Popsicles Pullen Central $3,554 2369
March 2019 Ice Cream Bishop North $11,762 7841
March 2019 Frozen Yogurt Bishop Central $8,943 5962
March 2019 Tasty Treats Pullen West $11,123 7415
April 2019 Ice Cream Watson North $13,428 8952
April 2019 Popsicles Watson West $7,481 4987
April 2019 Ice Cream Bishop West $4,887 3258
April 2019 Frozen Yogurt Pullen West $14,648 9765
April 2019 Tasty Treats Bishop West $14,619 9746
April 2019 Ice Cream Watson North $5,381 3587
April 2019 Popsicles Watson West $14,447 9631
April 2019 Ice Cream Bishop West $867 578
May 2019 Frozen Yogurt Pullen North $1,499 999
May 2019 Tasty Treats Pullen North $236 157
May 2019 Ice Cream Pullen North $11,838 7892
May 2019 Popsicles Bishop West $2,367 1578
May 2019 Ice Cream Watson Central $7,031 4687
May 2019 Frozen Yogurt Watson Central $2,046 1364
May 2019 Tasty Treats Bishop Central $6,881 4587
May 2019 Ice Cream Pullen North $11,979 7986
May 2019 Popsicles Pullen North $7,344 4896
May 2019 Ice Cream Pullen North $6,881 4587
May 2019 Frozen Yogurt Bishop North $747 498
May 2019 Tasty Treats Watson North $6,881 4587
May 2019 Ice Cream Watson West $9,486 6324

Page 8
 Pivot Table

June 2019 Popsicles Bishop West $7,343 4895

June 2019 Ice Cream Pullen North $7,319 4879
June 2019 Ice Cream Bishop North $8,435 5623
June 2019 Frozen Yogurt Pullen Central $3,897 2598
June 2019 Tasty Treats Watson Central $12,371 8247
June 2019 Ice Cream Bishop Central $10,992 7328
June 2019 Popsicles Pullen Central $3,084 2056
July 2019 Ice Cream Watson Central $13,232 8821
July 2019 Frozen Yogurt Bishop West $8,832 5888
July 2019 Tasty Treats Pullen North $3,548 2365
July 2019 Ice Cream Bishop West $13,413 8942
July 2019 Popsicles Bishop West $4,026 2684
July 2019 Ice Cream Pullen West $3,239 2159
July 2019 Frozen Yogurt Watson Central $14,597 9731
August 2019 Tasty Treats Watson Central $8,793 5862
August 2019 Ice Cream Bishop West $2,396 1597
August 2019 Popsicles Pullen Central $3,554 2369
August 2019 Ice Cream Bishop North $11,762 7841
August 2019 Frozen Yogurt Bishop Central $8,943 5962
August 2019 Tasty Treats Pullen West $11,123 7415
August 2019 Ice Cream Watson North $13,428 8952
August 2019 Popsicles Watson West $7,481 4987
September 2019 Ice Cream Bishop West $4,887 3258
September 2019 Frozen Yogurt Pullen West $14,648 9765
September 2019 Tasty Treats Bishop West $14,619 9746
September 2019 Ice Cream Watson North $5,381 3587
September 2019 Popsicles Watson West $14,447 9631
September 2019 Ice Cream Bishop West $867 578
October 2019 Frozen Yogurt Pullen North $1,499 999
October 2019 Tasty Treats Pullen North $236 157
October 2019 Ice Cream Pullen North $11,838 7892
October 2019 Popsicles Bishop West $2,367 1578
October 2019 Ice Cream Watson Central $7,031 4687
October 2019 Frozen Yogurt Watson Central $2,046 1364
November 2019 Tasty Treats Bishop Central $6,881 4587
November 2019 Ice Cream Pullen North $11,979 7986
November 2019 Popsicles Pullen North $7,344 4896
November 2019 Ice Cream Pullen North $6,881 4587
November 2019 Frozen Yogurt Bishop North $747 498
December 2019 Tasty Treats Watson North $6,881 4587
December 2019 Ice Cream Watson West $9,486 6324
December 2019 Popsicles Bishop West $7,343 4895
December 2019 Ice Cream Pullen North $7,319 4879
January 2020 Ice Cream Bishop North $12,269 8180
January 2020 Frozen Yogurt Pullen Central $5,846 3897

Page 9
 Pivot Table

January 2020 Tasty Treats Watson Central $18,556 12371

January 2020 Ice Cream Bishop Central $16,488 10992
January 2020 Popsicles Pullen Central $4,626 3084
February 2020 Ice Cream Watson Central $19,847 13232
February 2020 Frozen Yogurt Bishop West $13,248 8832
February 2020 Tasty Treats Pullen North $5,321 3548
February 2020 Ice Cream Bishop West $20,120 13413
February 2020 Popsicles Bishop West $6,039 4026
February 2020 Ice Cream Pullen West $4,858 3239
March 2020 Frozen Yogurt Watson Central $21,895 14597
March 2020 Tasty Treats Watson Central $13,190 8793
March 2020 Ice Cream Bishop West $3,593 2396
March 2020 Popsicles Pullen Central $5,330 3554
March 2020 Ice Cream Bishop North $17,642 11762
March 2020 Frozen Yogurt Bishop Central $13,415 8943
March 2020 Tasty Treats Pullen West $16,684 11123
April 2020 Ice Cream Watson North $20,142 13428
April 2020 Popsicles Watson West $11,221 7481
April 2020 Ice Cream Bishop West $7,331 4887
April 2020 Frozen Yogurt Pullen West $21,971 14648
April 2020 Tasty Treats Bishop West $21,929 14619
April 2020 Ice Cream Watson North $8,071 5381
April 2020 Popsicles Watson West $21,670 14447
April 2020 Ice Cream Bishop West $1,301 867
May 2020 Frozen Yogurt Pullen North $2,248 1499
May 2020 Tasty Treats Pullen North $353 236
May 2020 Ice Cream Pullen North $17,757 11838
May 2020 Popsicles Bishop West $3,551 2367
May 2020 Ice Cream Watson Central $10,546 7031
May 2020 Frozen Yogurt Watson Central $3,069 2046
May 2020 Tasty Treats Bishop Central $10,321 6881
May 2020 Ice Cream Pullen North $17,969 11979
May 2020 Popsicles Pullen North $11,016 7344
May 2020 Ice Cream Pullen North $10,321 6881
May 2020 Frozen Yogurt Bishop North $1,121 747
May 2020 Tasty Treats Watson North $10,321 6881
May 2020 Ice Cream Watson West $14,229 9486
June 2020 Popsicles Bishop West $11,014 7343
June 2020 Ice Cream Pullen North $10,978 7319
June 2020 Ice Cream Bishop North $12,652 8435
June 2020 Frozen Yogurt Pullen Central $5,846 3897
June 2020 Tasty Treats Watson Central $18,556 12371
June 2020 Ice Cream Bishop Central $16,488 10992
June 2020 Popsicles Pullen Central $4,626 3084
July 2020 Ice Cream Watson Central $19,847 13232

Page 10
 Pivot Table

July 2020 Frozen Yogurt Bishop West $13,248 8832

July 2020 Tasty Treats Pullen North $5,321 3548
July 2020 Ice Cream Bishop West $20,120 13413
July 2020 Popsicles Bishop West $6,039 4026
July 2020 Ice Cream Pullen West $4,858 3239
July 2020 Frozen Yogurt Watson Central $21,895 14597
August 2020 Tasty Treats Watson Central $13,190 8793
August 2020 Ice Cream Bishop West $3,593 2396
August 2020 Popsicles Pullen Central $5,330 3554
August 2020 Ice Cream Bishop North $17,642 11762
August 2020 Frozen Yogurt Bishop Central $13,415 8943
August 2020 Tasty Treats Pullen West $16,684 11123
August 2020 Ice Cream Watson North $20,142 13428
August 2020 Popsicles Watson West $11,221 7481
September 2020 Ice Cream Bishop West $7,331 4887
September 2020 Frozen Yogurt Pullen West $21,971 14648
September 2020 Tasty Treats Bishop West $21,929 14619
September 2020 Ice Cream Watson North $8,071 5381
September 2020 Popsicles Watson West $21,670 14447
September 2020 Ice Cream Bishop West $1,301 867
October 2020 Frozen Yogurt Pullen North $2,248 1499
October 2020 Tasty Treats Pullen North $353 236
October 2020 Ice Cream Pullen North $17,757 11838
October 2020 Popsicles Bishop West $3,551 2367
October 2020 Ice Cream Watson Central $10,546 7031
October 2020 Frozen Yogurt Watson Central $3,069 2046
November 2020 Tasty Treats Bishop Central $10,321 6881
November 2020 Ice Cream Pullen North $17,969 11979
November 2020 Popsicles Pullen North $11,016 7344
November 2020 Ice Cream Pullen North $10,321 6881
November 2020 Frozen Yogurt Bishop North $1,121 747
December 2020 Tasty Treats Watson North $10,321 6881
December 2020 Ice Cream Watson West $14,229 9486
December 2020 Popsicles Bishop West $11,014 7343
December 2020 Ice Cream Pullen North $10,978 7319

Page 11