Spreadsheet: 807085d1669733876-calculate-sum-each-month-based-on-two-variables-sales-team-goals-asm-commission-calculator-2023
Sheet: Master1

SALES PERSON | SALES TEAM | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL | DEFICIT
[NAME] | ASM | 6215 | 5840 | 6284 | 6817 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team [NAME] | 3800 | 2951 | 4905 | 3005 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | ASM | 2306 | 2971 | 3460 | 2350 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Zac | 2855 | 2245 | 2595 | 2060 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Seth | 1850 | 2115 | 3010 | 1926 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | ASM | 2410 | 970 | 2530 | 2185 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Andy | 1810 | 2886 | 3345 | 2183 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Seth | 1110 | 2100 | 2900 | 1230 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mitch Tharp | Team Andy | 1340 | 1350 | 1920 | 1070 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Andy | 1441 | 1150 | 1375 | 1496 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Zac | 2600 | 2305 | 2930 | 1155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Andy | 880 | 1455 | 1150 | 760 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | N/A |  |  | 240 | 715 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Seth | 1211 | 3245 | 1335 | 575 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Zac | 1540 | 330 | 2510 | 660 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | N/A |  |  | 340 | 700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Zac | 1300 | 775 | 1050 | 330 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | N/A |  |  | 240 | 210 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Team Seth | 420 | 657 | 346 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MRR Total
MRR Goal |  | 35416.66666666666 | 33291.67 | 37050 | 35625 | 35250 | 35250 | 35250 | 38000 | 40833.33333333334 | 41666.66666666666 | 35000 | 35000
% Goal Attainment
MRR Variance
Working Days Left in Month |  | 0 | 0 | 0 | 4 | 21 | 22 | 20 | 22 | 21 | 21 | 20 | 21
Revenue Needed Per Day
 | MRR Running Variance
ASM TEAM REVENUE/ASM COMMISSION
SALES TEAM |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
Team Andy MRR
Team [NAME] |  | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600
Team Andy  % Attainment
Team Andy ASM Commission
Team Seth MRR
Team [NAME] |  | 6600 | 6600 | 6600 | 4950 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600
[NAME] Attainment
Team Seth ASM Commission
Team Zac MRR
Team Zac Quota |  | 6600 | 6600 | 6600 | 4950 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600
[NAME] Attainment
Team Zac ASM Commission
Quota per rep | 1650
# of Reps | 4
Monthly Team Quota
% of Team Goal Achieved | $6600 Monthly Quota | Monthly Payout
125% + | $8250 or more | 2500
100 - 124.99% | $6600 - $8249 | 1667
75 - 99.99% | $4950 - $6599 | 1250
50 - 74.99% | $3300 - $4949 | 850
0-49% | $3299 or less | 0
NEW LOGOS
SALES PERSON | SALES TEAM | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL | DEFICIT
[NAME] | ASM | 14 | 13 | 9 | 9
[NAME] | N/A |  |  | 3 | 7
[NAME] | Team Zac | 8 | 11 | 13 | 7
[NAME] | Team Seth | 5 | 8 | 17 | 6
[NAME] | ASM | 6 | 3 | 10 | 7
[NAME] | N/A |  |  | 3 | 5
[NAME] | Team Andy | 4 | 5 | 4 | 5
[NAME] | Team Andy | 8 | 10 | 14 | 8
[NAME] | Team [NAME] | 10 | 8 | 7 | 4
[NAME] | Team Seth | 7 | 6 | 10 | 4
[NAME] | ASM | 10 | 5 | 10 | 4
[NAME] | Team Zac | 7 | 5 | 7 | 3
[NAME] | Team Zac | 8 | 8 | 11 | 4
[NAME] | Team Seth | 7 | 9 | 4 | 3
[NAME] | N/A |  |  | 3 | 2
[NAME] | Team Zac | 10 | 2 | 10 | 3
[NAME] | Team Andy | 4 | 4 | 7 | 3
Mitch Tharp | Team Andy | 4 | 7 | 7 | 2
[NAME] | Team Seth | 0 | 0 | 0 | 0
2022 New Logo Total
2021 New Logo Total |  | 147 | 119 | 120 | 113 | 100 | 110 | 118 | 122 | 133 | 115 | 128 | 92
% Goal Attainment
New Logo Variance
Working Days Left in Month |  | 0 | 0 | 0 | 5 | 21 | 22 | 20 | 22 | 21 | 21 | 20 | 21
Logos Needed Per Day
 | New Logo Running Variance
ASM TEAM NEW LOGOS
SALES TEAM |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
Team Andy
Team Seth
Team Zac