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

SALES PERSON | SALES TEAM | S1 | JAN | S2 | FEB | S3 | MAR | [NAME] | APR | S5 | MAY | S6 | JUN | S7 | JUL | S8 | AUG | S9 | SEP | S10 | OCT | S11 | NOV | S12 | DEC | TOTAL | DEFICIT
[NAME] | ASM | A | 6215 | A | 5840 | A | 6284 | A | 7317 | A | 6852 | A | 4608 | A | 7947 | A | 8231 | A | 6535 | A | 6674 | A | 5494 | A | 0
[NAME] | ASM | A | 2410 | A | 970 | A | 2530 | A | 2605 | A | 4025 | A | 3196 | A | 2160 | A | 3004 | A | 2640 | A | 2363 | A | 2858 | A | 0
[NAME] | ASM | A | 2306 | A | 2971 | A | 3460 | A | 2880 | A | 3175 | A | 3420 | A | 2536 | A | 3262 | A | 1860 | A | 2640 | A | 1883 | A | 0
[NAME] | N/A | A | 3800 | A | 2951 | A | 4905 | A | 3455 | A | 3575 | A | 2881 | A | 1700 | A | 1950 | A | 1219 | A | 2050 | A | 2041 | A | 0
[NAME] | N/A | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I | 2050 | I | 3850 | I | 739 | A | 0
[NAME] | Team Andy | A | 1810 | A | 2886 | A | 3345 | A | 2858 | A | 2305 | A | 2660 | A | 1905 | A | 2469 | A | 2445 | A | 1339 | A | 2452 | A | 0
[NAME] | Team Andy | A | 1441 | A | 1150 | A | 1375 | A | 1496 | A | 2100 | A | 1219 | A | 1120 | A | 1862 | A | 1266 | A | 725 | A | 1191 | A | 0
Mitch Tharp | Team Andy | A | 1340 | A | 1350 | A | 1920 | A | 1430 | A | 610 | A | 1875 | A | 1051 | A | 1652 | A | 1330 | A | 1410 | A | 1030 | A | 0
[NAME] | Team Andy | A | 880 | A | 1455 | A | 1150 | A | 1060 | A | 680 | A | 910 | A | 1045 | A | 1590 | A | 1585 | A | 1865 | A | 985 | A | 0
[NAME] | Team Andy | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I | 80 | I | 320 | I | 0
[NAME] | Team Seth | A | 1211 | A | 3245 | A | 1335 | A | 1475 | A | 1435 | A | 1510 | A | 861 | A | 1890 | A | 1710 | A | 1549 | A | 2010 | A | 0
[NAME] | Team Seth | A | 1110 | A | 2100 | A | 2600 | A | 1380 | A | 1415 | A | 1940 | A | 3335 | A | 2588 | A | 2075 | A | 2720 | A | 1949 | A | 0
[NAME] | Team Seth | A | 1850 | A | 2115 | A | 3010 | A | 2531 | A | 1939 | A | 2215 | A | 1935 | A | 1468 | A | 1830 | A | 1469 | A | 1220 | A | 0
[NAME] | Team Seth | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I | 800 | I | 1160 | I | 815 | A | 0
[NAME] | Team Seth | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I | 1250 | I | 1290 | I | 1530 | A | 622 | A | 0
[NAME] | Team Zac | A | 2600 | A | 2305 | A | 2930 | A | 1785 | A | 2455 | A | 4046 | A | 2925 | A | 3565 | A | 3425 | A | 4560 | A | 4975 | A | 0
[NAME] | Team Seth | I |  | I |  | I | 240 | I | 210 | I | 240 | A | 340 | A | 160 | A | 230 | I | 0 | I | 0 | I | 0 | I | 0
[NAME] | Team Seth | A | 420 | A | 657 | A | 346 | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I
[NAME] | Team Zac | A | 2855 | A | 2245 | A | 2595 | A | 3040 | A | 2495 | A | 1795 | A | 4305 | A | 910 | A | 3530 | A | 1698 | A | 1860 | A | 0
[NAME] | Team Zac | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I |  | I | 1420 | I | 2140 | I | 1145 | A | 0
[NAME] | Team Zac | A | 1540 | A | 330 | A | 2510 | A | 810 | A | 470 | A | 860 | A | 1180 | A | 1530 | A | 600 | A | 1600 | A | 780 | A | 0
[NAME] | Team Zac | A | 1300 | A | 775 | A | 1050 | I | 330 | A | 1180 | A | 675 | A | 810 | A | 300 | A | 2810 | A | 700 | A | 750 | A | 0
[NAME] | Team Andy | I |  | I |  | I | 240 | I | 715 | I | 560 | A | 605 | A | 330 | A | 310 | A | 495 | I |  | I | 0 | I | 0
[NAME] | Team Zac | I |  | I |  | I | 340 | I | 700 | I | 320 | A | 518 | I |  | I |  | I |  | I |  | I |  | I
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 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 2 |  | 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]
Team Andy  % Attainment
Team Andy ASM Commission
Team Seth MRR
Team [NAME]
[NAME] Attainment
Team Seth ASM Commission
Team Zac MRR
Team Zac Quota
[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
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mitch Tharp
[NAME]
[NAME]
[NAME] -N/A
[NAME] -N/A