Need to know how do i work out on reducing the DSO ....what are the steps involved in working out the same.
Six Sigma For Reducing DsoLean Six Sigma in Sales & Marketing
Posted 18 August 2009 - 02:18 PM
As you will be aware that DSO (Days Sales Outstanding) provides an average (aggregate) time in days it takes to convert accounts receivables into cash. Hence as a first step, it should be tracked over time and compared to previous company results or industry/competitor benchmarks. Setting an unrealistic DSO target which gets difficult to improve (or reduce) is the bigges pitfall in this project.
Secondly, for a simpler measure like DSO, the process of tracking and improving should also be simple. Since in most of the cases DSOs have direct corelation with No. of contractual violations. Hence its important to communicate and reinforce Sales Contracts with customers are regular intervals. Also communicate their historical payment performance for their perusal (Just as Credit Card companies do).
Lastly, improving human efficiency. Sales Managers, Executives, Reps, etc must be made accountable for DSO targets and should be made part of their performance appraisal. Unless they take ownership of their client's timely payments, it will difficult for one person (Sales Head) to take ownership of improving DSO for all customers.
Hope it serves your purpose.
Posted 18 August 2009 - 09:23 PM
Punit has provided some ideas to reduce DSO. If DSO improves by implementing such ideas, you may benefit immediately. However, this would not be considered a Six Sigma project.
In most companies, high DSO is a chronic issue and requires a detailed improvement project that uses data driven techniques. Six Sigma is specifically needed when common sense approaches have already been tried. Six Sigma is of specific use if causes of the problem are unknown and solution is unknown.
If you attend Benchmark Six Sigma Green Belt training, there is a case study that focuses on reducing DSO.
The case study is DMAIC based. Appropriate output parameter (DSO) is selected initially in DEFINE phase. A team is chosen for the project. Curr net status is assessed in MEASURE phase. Also reliability of data is verified. In the ANALYZE phase, study various factors are considered which could have impact on DSO.
- Order Size
- Billing Errors
- Customer type
- ]Product type
- Invoice categorization
- Experience of the person doing follow ups for payments
Hope this helps.
Posted 23 August 2009 - 05:16 PM
To begun with i do have the data for my accounts and this being a new line for me , i have did my Green belt way back in 2004-05 and now i actually got an oppurtunity to go complete one project as Green Belt .
Now as said earlier i have the data with me for the accounts that im handling...as of day the average DSO sums up to 80 - 95 days range. I need to work out and get it to around 40 -45 days... Personally speaking i wud need proper guidance in taking this forward.
Lookng forward for your assitance in drving this...
Posted 25 August 2009 - 02:24 PM
Have prepared the Project Charter ?
What analysis have you already done ?
Have you plotted the histogram of the existing data ?
Have you stratified the data ?
Posted 30 August 2009 - 05:31 PM
what is the benefit he is going to get out of histogram graph.
This question is to undestand about the benefits in histogram
Posted 30 August 2009 - 06:35 PM
Moreover, DSO is an implied matrics derived from Outstanding Invoices. Surely he must have collected data by selecting Invoices which are overdue.
DSO = Amount Outstanding / (Avg Sales/Day )
Amount Outstanding = SUM(Invoice Outstanding X Invoice Amount)
So, findout how many outstanding invoices were settled in 7-days, 15-days etc and Amount Settled respectively
Therefore, one must plot a histogram and find out whether it follows normal distribution and calculate Mean and Std Deviation from basic statistics.
This will help in setting the realistic target ( 45-Days if lies beyond 2-sigma is not practical )
Hope it is clear !
Posted 01 September 2009 - 12:34 PM
Excellent analysis of DSO, good learning. Sr.dbt is a issue in all the organisation and needs a detailed study ???
All the Best.
Posted 04 September 2009 - 10:38 PM
Good explanation to understand about the histogram. Thank you so much.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users