March 24, 2022
I am trying to develop a sales tracking tool to allow me to see the current sales going through the business over a time period. I would like to have the document live, so that as new work orders are created, the distribution slides across the time table. By time table I mean the first job open and last to close, this may be a few weeks to a few months.
Ideally, if I have for instance a $10,000 job, that has a kick off date to due date time period of 10 weeks, it is distributed into $1000/week.
I have attached the chart that I currently use, if anyone could help with the formula it would be a great help.