html5-img
1 / 18

Lennox Industries: Attrition Probabilities

Lennox Industries: Attrition Probabilities. Diana Batten and Maddie Kamp. Presentation Overview. Company Information The Opportunity Project Objective Our Approach Deliverables Test Cases Recommendations. Company Information. Residential & commercial heating and air-conditioning

jenis
Download Presentation

Lennox Industries: Attrition Probabilities

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lennox Industries: Attrition Probabilities Diana Batten and Maddie Kamp

  2. Presentation Overview Company Information The Opportunity Project Objective Our Approach Deliverables Test Cases Recommendations

  3. Company Information • Residential & commercial heating and air-conditioning • Seasonality of industry • 13-15% market share • Have business in 80 countries • Manufacturer & distributer • Direct relationship to customer • Customer is contractor

  4. The Opportunity • Enable sales force to predetermine attrition of customers • About 1,000 customers drive about 60% of revenue • Relations between data transactions and customer attrition • 2008-2010 transaction level data • “Proof of Concept”

  5. Project Objective • Determine a type of predictive model and analysis to predict attrition • Use the older historical data given to test and create our model • Address seasonality in sales

  6. Our Approach

  7. Deliverables • T-Tests • Excel spreadsheets – Attrition Predictors • Automation • “Plug and Chug” • Transition Probabilities • Percent Correct & Test Cases • Regional and Order Type Data

  8. Entering Data

  9. Transition Probabilities

  10. Conditionals for Decile Drops

  11. Percent Correct Example for 2010 Monthly Data

  12. Test Cases

  13. Entering Data – Order Type and Geographic Location

  14. Summary of Data

  15. Looking at Order Type - ZMPO

  16. Variability Did Not Decrease

  17. Recommendations & Functionality • Ability for expansion • Percent correctness • Use Three Period Outlook • Use red/orange to red/orange analysis • Allows for user to define attrition

  18. Questions?

More Related