Attrition Measurement Update Year End 2008: Continuing to Develop Meaningful Trends - PowerPoint PPT Presentation

attrition measurement update year end 2008 continuing to develop meaningful trends n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Attrition Measurement Update Year End 2008: Continuing to Develop Meaningful Trends PowerPoint Presentation
Download Presentation
Attrition Measurement Update Year End 2008: Continuing to Develop Meaningful Trends

play fullscreen
1 / 17
Attrition Measurement Update Year End 2008: Continuing to Develop Meaningful Trends
72 Views
Download Presentation
saad
Download Presentation

Attrition Measurement Update Year End 2008: Continuing to Develop Meaningful Trends

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Attrition Measurement Update Year End 2008:Continuing to Develop Meaningful Trends Prepared By: TRG Associates, Inc. ph: 860-395-0548 fax: 860-388-5300 www.trgassociates.com

  2. Gross Attrition The loss of existing customers and their associated recurring revenue for contracted services during a particular customer / calendar cycle Net Attrition Gross Attrition plus the add back of “like customer” gains thru resigns of the existing locations – - The Home/Business location is your ultimate customer - Price increases for inflation - Price increases for additional services or technology Defining Attrition www.trgassociates.com

  3. The Short Version The measurement of customer dissatisfaction with or need for the system Why Measure? Attrition measures customer dissatisfaction which, for the most part, is company caused. The Attrition Tracking Process should be managed to identify, focus on, and rectify those causes within each organization. Defining Attrition www.trgassociates.com

  4. Weighted Ending RMR Attrition Method Step 1: Cancelled RMR for the Reporting Period = Monthly Attrition Sum of Ending RMR for Each Month Step 2: Monthly Attrition (from Step 1)* 12 = Annualized Attrition Attrition Measurement Methodology www.trgassociates.com

  5. Pro’s & Con’s of Weighted Ending RMR Method www.trgassociates.com

  6. Continuing to Refine the Database • Existing Geography • NE/Mid Atlantic • Southeast • Midwest • Southwest • West • International www.trgassociates.com

  7. www.trgassociates.com

  8. Annual TrendDollars of RMR Region 2006 2007 2008 Northeast $ 16,593,689 $ 20,104,889 $ 26,123,886 Southeast $ 10,924,380 $ 15,859,705 $ 27,431,022 Midwest $ 11,906,640 $ 13,866,967 $ 20,986,270 Southwest $ 4,025,962 $ 5,545,528 $ 12,796,693 West $ 9,243,889 $ 24,353,124 $ 34,401,075 International $ 7,576,043 $ 999,570$ 1,433,570 Total $60,270,603 $ 80,729,783 $123,172,516 www.trgassociates.com

  9. Annual TrendDollars of RMR Size 2006 2007 2008 3-50 $ 412,984 $ 302,151 $ 307,553 51-100 $ 492,274 $ 689,884 $ 648,286 101-200 $ 3,970,284 $ 4,097,988 $ 3,609,618 201-500 $ 9,311,380 $13,031,388 $ 13,652,480 501+ $46,083,681$62,608,372$104,954,579 Total $60,270,603 $80,729,783 $123,172,516 www.trgassociates.com

  10. Annual TrendDollars of RMR Customer Source 2006 2007 2008 Dealer $13,796,698 $11,901,416 $ 28,435,828 Traditional $31,669,657 $49,548,497 $ 67,312,383 Mass Market $14,804,248 $19,279,871 $ 27,424,305 Total $60,270,603 $80,729,783 $123,172,516 www.trgassociates.com

  11. Annual TrendDollars of RMR Customer Type 2006 2007 2008 Residential $ 31,947,955 $42,026,724 $ 71,194,117 Commercial $ 28,322,648$38,703,059$ 51,978,399 Total $60,270,603 $80,729,783 $123,172,516 www.trgassociates.com

  12. Attrition Updatethrough Year End 2008 2006 2007 2008 Region Gross Net Gross Net Gross Net Northeast 10.32% 7.23% 9.41% 6.92% 9.82% 7.37% Southeast 12.55% 9.07% 11.48% 8.29% 11.71% 9.26% Midwest 11.79% 7.79% 11.47% 8.44% 11.47% 8.51% Southwest 12.76% 9.16% 12.33% 9.13% 12.89% 9.96% West 11.64% 8.26% 10.90% 8.63% 11.62% 8.74% International 11.74% 8.07% 10.46% 9.05% 10.42% 8.21% www.trgassociates.com

  13. Attrition Updatethrough Year End 2008 2006 2007 2008 Company Size Gross Net Gross Net Gross Net 3-50 10.36% 6.88% 11.67% 8.28% 11.78% 8.67% 51-100 14.79% 9.24% 9.64% 7.09% 11.57% 8.74% 101-200 12.09% 8.94% 11.35% 8.14% 11.12% 7.57% 201-500 12.15% 8.38% 11.22% 8.05% 11.65% 8.47% 501+ 11.37% 7.92% 10.73% 8.18% 11.31% 8.71% www.trgassociates.com

  14. Attrition Updatethrough Year End 2008 2006 2007 2008 Source Gross Net Gross Net Gross Net Dealer 11.41% 8.09% 12.60% 9.09% 12.95% 10.20% Traditional 11.62% 8.07% 10.42% 8.00% 10.77% 8.25% Mass Market 11.57% 8.03% 10.82% 7.92% 11.12% 8.01% www.trgassociates.com

  15. Attrition Updatethrough Year End 2008 2006 2007 2008 Customer Type Gross Net Gross Net Gross Net Residential 11.54% 8.19% 10.90% 7.93% 11.67% 8.91% Commercial 11.57% 7.93% 10.76% 8.38% 10.91% 8.28% www.trgassociates.com

  16. Reason Code Analysis 2005 2006 2007 2008 Cancellation Reason %%% ____%____ • Collection – Non-payment 18.6% 13.3% 13.1% 14.7% • Moved within Market 23.5% 17.0% 10.5% 13.5% • Moved Outside of Market 27.1% 29.0% 28.6% 16.4% • Poor Service 1.5% 2.0% 3.8% 2.6% • Lost to Competition 5.6% 11.6% 12.3% 16.6% • No Longer Using System 11.0% 11.3% 10.8% 11.1% • Sold/Out of Business 3.4% 4.6% 4.8% 12.8% • Financial Difficulties 2.7% 6.3% 7.0% 4.9% • Property Abandoned/Vacant 0.1% 0.1% 1.2% 0 .3% • End of Contract Term 0.5% 1.4% 3.4% 2.2% • Deceased/Rest home 0.6% 1.7% 1.5% 1.3% • Price Increase Rescinded 4.0% 1.3% 3.0% 3.4% • Natural Disaster 1.4% 0.4% 0.1% 0.2% www.trgassociates.com

  17. TRG Maintains Full Confidentiality Of Participants’ Figures • Summary results as presented will be available on CSAA Web-Site TRG Web-Site (www.trgassociates.com) • Next update for 2009 – April 2010 Posted in June 2010 www.trgassociates.com