Spreadsheet: 116284d1311717969-sumprod_index-issue-sample_sumprod_index
Sheet: Chicago

 |  |  |  |  | P1W1 | P1W2 | P1W3 | P1W4 | P1W5 | P2W1 | P2W2 | P2W3 | P2W4 | P3W1 | [NAME] | P3W3 | P3W4 | P4W1 | P4W2 | P4W3 | P4W4 | P4W5 | P5W1 | P5W2 | P5W3 | P5W4 | P6W1 | P6W2 | P6W3 | P6W4 | P7W1 | P7W2 | P7W3 | P7W4
 |  |  |  |  | Period 1 |  |  |  | Period 2 |  |  |  | Period 3 |  |  |  | Period 4 |  |  |  |  | Period 5 |  |  |  | Period 6 |  |  |  | Period 7 |  |  |  |  | Period 8 |  |  |  | Period 9 |  |  |  | Period 10 |  |  |  |  | Period 11 |  |  |  | Period 12
 |  |  | Source |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Budget
 |  | Headcount
 |  | - SEs | Finance
 |  | - ISEs | Finance
 |  | Total | Finance
 |  | KPI NAR (Box 7) | Finance
 |  | KPI NAR (Box 8) | Finance
 |  | KPI NAR (Box 9) | Finance
 |  | Auto revenue | Finance
 |  | Purge revenue | Finance
 |  | National Account revenue | Finance
 |  | Off-site revenue | Finance
 |  | Total revenue
 |  | Actuals
 |  | Headcount
 |  | - SEs | KPIs report
 |  | - ISEs | KPIs report
 |  | Total
 |  | KPI NAR
 |  | Auto revenue | KPIs report / P&L for Periods
 |  | Purge revenue | KPIs report / P&L for Periods
 |  | National Account revenue | KPIs report / P&L for Periods
 |  | Off-site revenue | KPIs report / P&L for Periods
 |  | Total revenue
 |  | Auto revenue % achieved of budget | Calc.
 |  | Purge revenue % achieved of budget | Calc.
 |  | National Account revenue % achieved of budget | Calc.
 |  | Off-site revenue % achieved of budget | Calc.
 |  | Total revenue % achieved of budget
 |  | SWAT DATA | Chicago
 |  | # of SEs | SWATs |  | 6 | 6 | 6 | 6 | 0 | 6 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  | # of ISEs | SWATs |  | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  | SEs
 |  | Days Worked | SWATs |  | #N/A
 |  | Cold Calls | SWATs
 |  | Telepros.* | SWATs
 |  | Appts Booked | SWATs
 |  | # of Sched. First Auto Appts | SWATs
 |  | # of Follow-up Auto Appts | SWATs
 |  | # of No Shows | SWATs
 |  | # of Completed Auto Appts | SWATs
 |  | Referrals | SWATs
 |  | Data Security Audits | SWATs
 |  | Trials Left | SWATs
 |  | # of [NAME] (CSAs) | SWATs
 |  | # of Auto Service Locations | SWATs
 |  | New Auto Revenue | SWATs
 |  | Client Care Calls | SWATs
 |  | # of Purges Sold | SWATs
 |  | Est. [NAME] | SWATs
 |  | Roadside Coaching (Yes/No) | SWATs
 |  | # of LVO’s won | SWATs
 |  | Combined Annual LVO $ [NAME] | SWATs
 |  | [NAME]. LVO $ value | SWATs
 |  | Key metrics
 |  | Booked appointment Conversion rate (cold calls + teleprospecting) / appointments | Calc.
 |  | Win conversion (CSAs / # of completed appointments) | Calc.
 |  | Avg. NAR per CSA | Calc.
 |  | cold calls / SE / wk. | Calc.
 |  | teleprospecting / SE / wk. | Calc.
 |  | appointments / SE / wk. | Calc.
 |  | CSAs / SE / wk. | Calc.
 |  | ISEs
 |  | Days worked
 |  | # of Outbound Calls (Dials) | SWATs
 |  | # of Incoming Calls | SWATs
 |  | Total Calls | SWATs
 |  | # Appts Set for SE | SWATs
 |  | # Appts Closed by SE | SWATs
 |  | # New Cust. [NAME] | SWATs
 |  | $ New Cust. [NAME] | SWATs
 |  | # Existing Cust. [NAME] | SWATs
 |  | $ Existing Cust. [NAME] | SWATs
 |  | # of Total Purge Opportunities Quoted | SWATs
 |  | $ of Total Purge Opportunities Quoted | SWATs
 |  | # New Cust. [NAME] | SWATs
 |  | $ New Cust. [NAME] | SWATs
 |  | # Existing Cust. [NAME] | SWATs
 |  | $ Existing Cust. [NAME] | SWATs
 |  | # of Total Purge Opportunities Sold | SWATs
 |  | $ of Total Purge Opportunities Sold | SWATs
 |  | Key Metrics
 |  | Outbound dials as % of total dials | Calc.
 |  | Appointments set per week | Calc.
 |  | Total new purge quoted | Calc.
 |  | Total purge won / total purge quoted | Calc.