US Sales Summary
Annual Sales
First Name Last Name Employee ID Region Q1 Q2 Q3 Q4
Simone Arman S1001 Northeast $14,815 $13,100 $11,580 $17,300
Barbara Bartholomew S1002 North $24,500 $25,600 $22,000 $19,000
Alice Childs S1003 Southwest $20,900 $22,600 $20,140 $24,400
Linda Greenburg S1004 Northeast $15,900 $22,700 $17,600 $20,000
Sam Lundquist S1005 North $25,000 $34,000 $21,000 $35,000
Michael Mc Tague S1006 Northeast $24,110 $54,812 $15,200 $25,600
Orlando Rivena S1008 South $22,600 $58,445 $16,800 $22,700
Oscar Stark S1009 Southwest $22,700 $48,648 $36,855 $35,000
Maria Unger S1010 Southwest $23,300 $24,600 $21,380 $15,937
Caroline Hanover S1011 Northeast $23,800 $27,700 $12,600 $35,000
Enrique Jaen S1012 Southwest $54,826 $59,224 $24,100 $28,000
Alana Monder S1013 Southwest $31,200 $23,100 $17,700 $29,300
Chika Innoue S1014 Northeast $50,224 $17,300 $15,200 $14,600
Maureen Ryan S1015 North $15,500 $19,000 $30,300 $22,600
John Clark S1017 North $14,815 $13,100 $11,580 $17,300
Amanda Rapp S1018 North $24,500 $25,600 $22,000 $19,000
Cathy Booth S1019 Southwest $20,900 $22,600 $20,140 $24,400
Jim Diehl S1028 Southwest $15,900 $22,700 $17,600 $20,000
Elizabeth Smith S1021 Northeast $25,000 $34,000 $21,000 $35,000
Katie Merkley S1022 Southwest $24,110 $54,812 $15,200 $25,600
Beth Cuzens S1023 South $25,600 $48,752 $30,300 $22,600
Regional
Data:
North South N. East S.West
$297,200 $120,545 $408,612 $706,239
les Summary
nnual Sales
Total Average Highest Lowest Commission
$56,795 $14,199 $17,300 $11,580 $3,976 Employees:
$91,100 $22,775 $25,600 $19,000 $6,377 Employees with Region data:
$88,040 $22,010 $24,400 $20,140 $6,163 Commission rate:
$76,200 $19,050 $22,700 $15,900 $5,334
$115,000 $28,750 $35,000 $21,000 $8,050
$119,722 $29,931 $54,812 $15,200 $8,381 Top 3 Employees:
$120,545 $30,136 $58,445 $16,800 $8,438 Enrique $41,537.50
$143,203 $35,801 $48,648 $22,700 $10,024 Oscar $35,800.75
$85,217 $21,304 $24,600 $15,937 $5,965 Antonio $31,813.00
$99,100 $24,775 $35,000 $12,600 $6,937
$166,150 $41,538 $59,224 $24,100 $11,631
$101,300 $25,325 $31,200 $17,700 $7,091
$97,324 $24,331 $50,224 $14,600 $6,813
$87,400 $21,850 $30,300 $15,500 $6,118
$56,795 $14,199 $17,300 $11,580 $3,976
$91,100 $22,775 $25,600 $19,000 $6,377
$88,040 $22,010 $24,400 $20,140 $6,163
$76,200 $19,050 $22,700 $15,900 $5,334
$115,000 $28,750 $35,000 $21,000 $8,050
$119,722 $29,931 $54,812 $15,200 $8,381
$127,252 $31,813 $48,752 $22,600 $8,908
24
21
7
Canadian Sales Summary
First Name Last Name Employee ID Region Q1 Q2 Q3 Q4
Aidan Quionski C2200 East $76,543.00 $15,342.00 $9,000.00 $12,973.00
Abby Johnson C2201 West $23,689.00 $22,569.00 $2,222.00 $24,973.00
Alice Trembleye C2202 East $45,962.00 $24,458.00 $6,543.00 $12,973.00
Adame Clarke C2203 Central $56,654.00 $32,147.00 $45,413.00 $12,647.00
Alysa Jones C2204 East $56,542.00 $23,945.00 $5,448.00 $21,873.00
Adolp Lee C2205 Central $54,778.00 $35,913.00 $2,148.00 $21,478.00
Alexis Quayle C2206 West $12,365.00 $25,413.00 $2,145.00 $21,635.00
Total
$100,885.00
$48,480.00
$76,963.00
$134,214.00
$85,935.00
$92,839.00
$39,923.00
Mexican Sales Summary
First Name Last Name Employee ID Region Q1 Q2 Q3 Q4
Abrille Aravia M3901 MC $21,973.00 $92,456.00 $1,242.00 $12,411.00
Alamar Bazalde M3902 CH $54,126.00 $22,315.00 $4,234.00 $2,141.00
Camiria Trembleye M3903 CH $73,915.00 $22,231.00 $23,424.00 $24,121.00
Consuelo Clarisse M3904 MC $25,413.00 $12,191.00 $24,234.00 $21,421.00
Alysa Ronalze M3905 NL $25,636.00 $11,135.00 $8,532.00 $1,124.00
Total
$115,671.00
$80,675.00
$119,570.00
$61,838.00
$45,303.00
