Spreadsheet: 99292d1297969068-if-statement-logic-determine-quota-sample_quota
Sheet: Summary

 |  |  |  | 2 |  | 2 |  |  | 2 |  | 2 |  |  | 2
 |  |  |  | Budgeted |  |  |  |  | Actual |  |  |  |  | Buffer (10%) |  |  | PC METHOD
 |  |  |  | Headcount |  | Quota |  |  | Headcount |  | Quota |  |  | Quota |  |  | Quota
 |  | Districts |  | P1 |  | P1 |  |  | P1 |  | P1 |  |  | P1 |  |  | P1
 |  | US Central |  | 38 |  | 38000 |  |  | 34.5 |  | 34500 |  |  | 34200 |  |  | 34500
 |  | [NAME] |  | 9 |  | 9000 |  |  | 6.5 |  | 6500 |  |  | 8100 |  |  | 8100
 |  | Chicago |  | 7 |  | 7000 |  |  | 4.5 |  | 4500 |  |  | 6300 |  |  | 6300
 |  | Milwaukee |  | 2 |  | 2000 |  |  | 2 |  | 2000 |  |  | 1800 |  |  | 2000
 |  | Dal-Shr |  | 6 |  | 6000 |  |  | 6 |  | 6000 |  |  | 5400 |  |  | 6000
 |  | Dallas |  | 5 |  | 5000 |  |  | 5 |  | 5000 |  |  | 4500 |  |  | 5000
 |  | Shreveport |  | 1 |  | 1000 |  |  | 1 |  | 1000 |  |  | 900 |  |  | 1000
 |  | [NAME]-GR |  | 5 |  | 5000 |  |  | 6 |  | 6000 |  |  | 4500 |  |  | 6000
 |  | Detroit |  | 3 |  | 3000 |  |  | 4 |  | 4000 |  |  | 2700 |  |  | 4000
 |  | Grand Rapids |  | 2 |  | 2000 |  |  | 2 |  | 2000 |  |  | 1800 |  |  | 2000
 |  | [NAME] |  | 7 |  | 7000 |  |  | 6 |  | 6000 |  |  | 6300 |  |  | 6300
 |  | Louisville |  | 3 |  | 3000 |  |  | 3 |  | 3000 |  |  | 2700 |  |  | 3000
 |  | Indianapolis |  | 4 |  | 4000 |  |  | 3 |  | 3000 |  |  | 3600 |  |  | 3600
 |  | OC-Wic |  | 5 |  | 5000 |  |  | 4 |  | 4000 |  |  | 4500 |  |  | 4500
 |  | Oklahoma City |  | 3 |  | 3000 |  |  | 2 |  | 2000 |  |  | 2700 |  |  | 2700
 |  | Wichita |  | 2 |  | 2000 |  |  | 2 |  | 2000 |  |  | 1800 |  |  | 2000
 |  | SXF-Oma-DM |  | 6 |  | 6000 |  |  | 6 |  | 6000 |  |  | 5400 |  |  | 6000
 |  | [NAME] |  | 2 |  | 2000 |  |  | 2 |  | 2000 |  |  | 1800 |  |  | 2000
 |  | Omaha |  | 2 |  | 2000 |  |  | 2 |  | 2000 |  |  | 1800 |  |  | 2000
 |  | Des Moines |  | 2 |  | 2000 |  |  | 2 |  | 2000 |  |  | 1800 |  |  | 2000
 |  | US Southeast |  | 33 |  | 33000 |  |  | 31.25 |  | 31250 |  |  | 29700 |  |  | 31250
 |  | Atl-Cha |  | 7 |  | 7000 |  |  | 6 |  | 6000 |  |  | 6300 |  |  | 6300
 |  | Atlanta |  | 5 |  | 5000 |  |  | 4 |  | 4000 |  |  | 4500 |  |  | 4500
 |  | Charleston |  | 2 |  | 2000 |  |  | 2 |  | 2000 |  |  | 1800 |  |  | 2000
 |  | Birmingham USA |  | 3 |  | 3000 |  |  | 4 |  | 4000 |  |  | 2700 |  |  | 4000
 |  | [NAME] |  | 6 |  | 6000 |  |  | 5.5 |  | 5500 |  |  | 5400 |  |  | 5500
 |  | Memphis |  | 3 |  | 3000 |  |  | 2.75 |  | 2750 |  |  | 2700 |  |  | 2750
 |  | Nashville |  | 3 |  | 3000 |  |  | 2.75 |  | 2750 |  |  | 2700 |  |  | 2750
 |  | Mia-FM |  | 6 |  | 6000 |  |  | 6 |  | 6000 |  |  | 5400 |  |  | 6000
 |  | Miami |  | 5 |  | 5000 |  |  | 5 |  | 5000 |  |  | 4500 |  |  | 5000
 |  | [NAME] |  | 1 |  | 1000 |  |  | 1 |  | 1000 |  |  | 900 |  |  | 1000
 |  | NO-Jac |  | 5 |  | 5000 |  |  | 4.25 |  | 4250 |  |  | 4500 |  |  | 4500
 |  | New Orleans |  | 4 |  | 4000 |  |  | 3.25 |  | 3250 |  |  | 3600 |  |  | 3600
 |  | [NAME] |  | 1 |  | 1000 |  |  | 1 |  | 1000 |  |  | 900 |  |  | 1000
 |  | Tam-Orl |  | 6 |  | 6000 |  |  | 5.5 |  | 5500 |  |  | 5400 |  |  | 5500
 |  | Tampa |  | 4 |  | 4000 |  |  | 3 |  | 3000 |  |  | 3600 |  |  | 3600
 |  | Orlando Branch | Orlando | 2 |  | 2000 |  |  | 2.5 |  | 2500 |  |  | 1800 |  |  | 2500
 |  | US West |  | 41 |  | 41000 |  |  | 34.75 |  | 34750 |  |  | 36900 |  |  | 36900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budgeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KPI (Actual)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10% Buffer