Sales Formatting

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 8

Sales Data 2021

Salesperson Division Q1 Q2 Q3 Q4 Current TOTAL


Adams, Emily West $14,650 $15,850 $30,500
Anderson, Monica East $4,325 $4,285 $8,610
Avery, Tom West $12,585 $13,550 $26,135
Becker, Robert South $9,880 $8,760 $18,640
Bell, Samantha East $5,256 $4,760 $10,016
Bolt, Edward North $6,510 $7,620 $14,130
Brady, Nick South $11,650 $9,740 $21,390
Brown, Amy West $15,660 $15,960 $31,620
Campbell, Steven South $12,850 $8,650 $21,500
Carter, Timothy West $14,560 $14,945 $29,505
Clarke, Silvia South $8,450 $7,450 $15,900
Cruz, Henry East $4,755 $5,150 $9,905
Douglass, Charles South $7,560 $7,245 $14,805
Duff, Morgan West $15,750 $16,250 $32,000
Flores, Tina South $9,640 $8,315 $17,955
Francis, Sam East $6,150 $5,895 $12,045
Gonzalez, Diego West $16,950 $17,655 $34,605
Greene, Eric South $10,250 $9,450 $19,700
Hernandez, Taylor North $7,525 $7,855 $15,380
Hill, Amber South $8,865 $7,825 $16,690
Hudson, Lucas West $14,650 $15,460 $30,110
Jackson, Katheryn East $5,865 $6,315 $12,180
Jones, Dorothy North $6,845 $8,240 $15,085
King, Nicole South $8,645 $7,245 $15,890
Lee, Owen East $6,845 $5,895 $12,740
Lopez, Patrick South $6,890 $5,845 $12,735
Martin, Jeff North $7,050 $7,950 $15,000
Martinez, Leah South $7,545 $7,215 $14,760
Meyer, Thomas West $12,485 $13,460 $25,945
Mitchell, David North $7,015 $8,345 $15,360
Moore, Henry East $5,365 $6,550 $11,915
Nelson, Emily South $8,650 $8,450 $17,100
Parker, Silvia North $6,545 $7,955 $14,500
Parnell, Heather East $5,145 $6,250 $11,395
Perez, Rachel North $6,285 $8,460 $14,745
Porter, Joesph West $15,460 $16,850 $32,310
Ramirez, Daniel South $10,580 $9,450 $20,030
Roberts, Emily East $6,045 $6,145 $12,190
Rogers, Steve West $14,980 $15,450 $30,430
Rudd, Nora South $7,840 $6,150 $13,990
Sanchez, Gregory West $17,650 $17,985 $35,635
Sanders, Marta North $7,250 $8,540 $15,790
Smith, Meredith South $9,645 $7,850 $17,495
Stevenson, Wesley North $6,540 $7,295 $13,835
Taylor, Rose East $7,520 $6,245 $13,765
Thomson, Steven South $9,645 $9,250 $18,895
Young, Amanda North $6,755 $7,160 $13,915
Target TOTAL % Progress
$80,000 38%
$50,000 17%
$70,000 37%
$50,000 37%
$25,000 40%
$30,000 47%
$50,000 43%
$50,000 63%
$60,000 36%
$80,000 37%
$35,000 45%
$20,000 50%
$40,000 37%
$60,000 53%
$35,000 51%
$50,000 24%
$50,000 69%
$50,000 39%
$40,000 38%
$30,000 56%
$70,000 43%
$50,000 24%
$40,000 38%
$25,000 64%
$60,000 21%
$40,000 32%
$50,000 30%
$40,000 37%
$50,000 52%
$30,000 51%
$30,000 40%
$30,000 57%
$50,000 29%
$20,000 57%
$40,000 37%
$50,000 65%
$50,000 40%
$25,000 49%
$50,000 61%
$20,000 70%
$80,000 45%
$40,000 39%
$35,000 50%
$30,000 46%
$40,000 34%
$45,000 42%
$35,000 40%
Sales Data 2021

Salesperson Division Q1 Q2 Q3 Q4 Current TOTAL


Emily Adams West $14,650 $15,850 $15,965 $16,445 $62,910
Monica Anderson East $4,325 $4,285 $4,760 $4,110 $17,480
Tom Avery West $12,585 $13,550 $13,985 $14,650 $54,770
Robert Becker South $9,880 $8,760 $7,650 $6,445 $32,735
Samantha Bell East $5,256 $4,760 $3,950 $5,640 $19,606
Edward Bolt North $6,510 $7,620 $8,645 $9,610 $32,385
Nick Brady South $11,650 $9,740 $7,560 $5,200 $34,150
Amy Brown West $15,660 $15,960 $16,015 $16,485 $64,120
Steven Campbell South $12,850 $8,650 $6,545 $5,275 $33,320
Timothy Carter West $14,560 $14,945 $15,115 $15,635 $60,255
Silvia Clarke South $8,450 $7,450 $7,245 $5,890 $29,035
Henry Cruz East $4,755 $5,150 $4,765 $5,450 $20,120
Charles Douglass South $7,560 $7,245 $6,845 $5,545 $27,195
Morgan Duff West $15,750 $16,250 $16,450 $17,015 $65,465
Tina Flores South $9,640 $8,315 $7,635 $6,815 $32,405
Sam Francis East $6,150 $5,895 $4,615 $5,240 $21,900
Diego Gonzalez West $16,950 $17,655 $17,845 $18,000 $70,450
Eric Greene South $10,250 $9,450 $8,945 $7,510 $36,155
Taylor Hernandez North $7,525 $7,855 $9,125 $9,125 $33,630
Amber Hill South $8,865 $7,825 $7,210 $6,930 $30,830
Lucas Hudson West $14,650 $15,460 $15,445 $15,860 $61,415
Katheryn Jackson East $5,865 $6,315 $6,545 $5,140 $23,865
Dorothy Jones North $6,845 $8,240 $8,765 $8,945 $32,795
Nicole King South $8,645 $7,245 $6,200 $5,845 $27,935
Owen Lee East $6,845 $5,895 $6,110 $6,345 $25,195
Patrick Lopez South $6,890 $5,845 $5,210 $4,860 $22,805
Jeff Martin North $7,050 $7,950 $9,050 $9,315 $33,365
Leah Martinez South $7,545 $7,215 $6,845 $6,575 $28,180
Thomas Meyer West $12,485 $13,460 $13,985 $14,650 $54,580
David Mitchell North $7,015 $8,345 $8,750 $9,550 $33,660
Henry Moore East $5,365 $6,550 $7,120 $5,860 $24,895
Emily Nelson South $8,650 $8,450 $8,210 $7,565 $32,875
Silvia Parker North $6,545 $7,955 $7,895 $9,675 $32,070
Heather Parnell East $5,145 $6,250 $5,785 $5,990 $23,170
Rachel Perez North $6,285 $8,460 $9,620 $9,435 $33,800
Joesph Porter West $15,460 $16,850 $17,020 $17,450 $66,780
Daniel Ramirez South $10,580 $9,450 $8,445 $7,940 $36,415
Emily Roberts East $6,045 $6,145 $5,965 $6,445 $24,600
Steve Rogers West $14,980 $15,450 $15,640 $16,850 $62,920
Nora Rudd South $7,840 $6,150 $5,990 $5,640 $25,620
Gregory Sanchez West $17,650 $17,985 $18,150 $18,540 $72,325
Marta Sanders North $7,250 $8,540 $9,410 $9,800 $35,000
Meredith Smith South $9,645 $7,850 $7,260 $6,150 $30,905
Wesley Stevenson North $6,540 $7,295 $8,935 $8,990 $31,760
Rose Taylor East $7,520 $6,245 $5,865 $5,540 $25,170
Steven Thomson South $9,645 $9,250 $9,130 $8,330 $36,355
Amanda Young North $6,755 $7,160 $8,265 $9,245 $31,425
Target TOTAL % Progress Category
$80,000 79% 70%-80%
$50,000 35% 30%-40%
$70,000 78% 70%-80%
$50,000 65% 60%-70%
$25,000 78% 70%-80%
$30,000 108% 100%+
$50,000 68% 60%-70%
$50,000 128% 100%+
$60,000 56% 50%-60%
$80,000 75% 70%-80%
$35,000 83% 80%-90%
$20,000 101% 100%+
$40,000 68% 60%-70%
$60,000 109% 100%+
$35,000 93% 90%-100%
$50,000 44% 40%-50%
$50,000 141% 100%+
$50,000 72% 70%-80%
$40,000 84% 80%-90%
$30,000 103% 100%+
$70,000 88% 80%-90%
$50,000 48% 40%-50%
$40,000 82% 80%-90%
$25,000 112% 100%+
$60,000 42% 40%-50%
$40,000 57% 50%-60%
$50,000 67% 60%-70%
$40,000 70% 70%-80%
$50,000 109% 100%+
$30,000 112% 100%+
$30,000 83% 80%-90%
$30,000 110% 100%+
$50,000 64% 60%-70%
$20,000 116% 100%+
$40,000 85% 80%-90%
$50,000 134% 100%+
$50,000 73% 70%-80%
$25,000 98% 90%-100%
$50,000 126% 100%+
$20,000 128% 100%+
$80,000 90% 90%-100%
$40,000 88% 80%-90%
$35,000 88% 80%-90%
$30,000 106% 100%+
$40,000 63% 60%-70%
$45,000 81% 80%-90%
$35,000 90% 90%-100%

You might also like