A financial concept, Day Sales Outstanding (DSO), is a measure of the average number of days that a company takes to collect revenue after a sale has been made. For further clarification, read here.
Herein, i have presented the solution for two different data layouts. Further, Layout 2 has two further divisions – one for computing Day Sales Outstanding (DSO) based on historical sales and the other for computing Days of Supply (DOS) based on future Cost of Good Sold (COGS).
You may refer to my solution in this workbook.