Spreadsheet: 857168d1706207984-commission-table-lookup-if-statement-breakout
Sheet: Bobby.Digital (4)

Back to Index
Southwest Region |  |  |  |  |  |  |  |  |  | Net Revenue
Commission Earned | Based on Sales Quota |  | Time of Sale Service | Spiffs | [NAME] | Open Territory | Quarterly Order Achievement | Other | Total | YTD WF | YTD CONFOCAL | YTD SALES | % QUOTA ACHIEVED | Paid | Balance
 | [NAME] | Confocal
January
February
March
April
May
June
July
August
September
October
November
December
Total
 |  |  |  |  |  | 2023 QUOTA |  |  |  | Commission Rate 2023 |  | [NAME]
 |  |  |  |  |  | Sales | Orders | Orders | Achievement | 0-80% | 0.014 | 1184320 |  |  | Q1 Orders SPIFF
 |  |  |  |  | Q1 | 934837.8578530162 | 621083.65 | 1132033.56 |  | 80-100% | 0.025 | YTD Achieved |  |  | Orders | Orders Target | Achievement
 |  |  |  |  | Q2 | 809754.5573645739 | 703988.2 | 595024.1 |  | above annual quota | 0.055 |  |  | Q1 | 484131.91 | 481000 | Yes
 |  |  |  |  | Q3 | 950027.8400112566 | 872387.94 | 706971.88
 |  |  |  |  | Q4 | 1111089.744771153 | 887054.6 |  |  |  |  |  |  | Example prior  YTD of >>>> | 3183691.34
 |  |  |  |  | TOTAL | 4142932 |  |  |  |  |  |  |  |  |  |  |  |  | 80% of G25
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total |  |  |  | Total
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 7375.48
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 21043.36
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 3276.73
1W |  |  |  |  |  |  |  |  |  |  | 0.014 | 0.025
1W |  |  |  |  |  |  |  |  |  | 3314345.6 |  |  |  | 4924.65
1C |  |  |  |  |  |  |  |  |  |  |  |  |  | 273112.55
 |  |  |  |  |  |  |  |  |  | 1.4 |  |  |  | 471.46
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1103.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1003.68
JANUARY
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total
FEBRUARY
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total
3C
3C
3C
3C
3C
3TOS
3TOS
3TOS
3OTH
[NAME]
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total
4SP
APRIL
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total
MAY
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paid out in July on special payment
[NAME]
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
7W
7W
7W
7W
7W
7W
7W
7W
7W
7W
7W
7W
7C
7OT
JULY
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8SP
AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4373.940000000001
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
9W
9W
9W
9W
9W
9W
9W
9W
9W
9C
9C
9W
9W
9OT
9OT
9OT
9OT
9OT
9OT
9OT
9OT
9OT
9C
9C
9SP
9SP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amt due
SEPTEMBER
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name/Contract # | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
10W
10W
10W
10W
10W
10W
10W
10W
10W
10W
10W
10W
10C
10W
10C
10C
10OT
10OT
10OT
10OT
10OT
10OT
10OT
10SP
10OTH
OCTOBER
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
11W
11W
11W
11W
11W
11W
11W
11W
11W
11W
11W
11W
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11C
11C
11SP
NOVEMBER
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
12W
12W
12W
12W
12W
12W
12W
12W
12W
12C
12C
12C
12C
12C
12C
12C
12C
12C
12C
DECEMBER