The “Days Outstanding” formula in the spreadsheet highlighted in red does not make sense as it does not provide an accurate picture of how we will impact the backlog with the amount of incoming mail. Help and suggestions welcome! This is for a call center escalation backlog report taking into consideration daily capacity.
Hi, welcome to the forum
What did you expect the answer to be?
btw, you can shorten that formula to this...
=IFERROR((G5+E5)/(J5),0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks! Glad to be here. I just don't think that mathematically speaking we can get to days outstanding by taking production backlog count and dividing it by the backlog count at 8AM without even taking oldest date into consideration. It also will not tell me what my average backlog days will be within a week from the 26th with accuracy.
Make sense?
Well without bringing in hours on BOTH sides of the equation, then the "days prod" formula would be...
work to do/duration
which is pretty much what you have there.
Thanks! can you give me a mockup with BOTH hours being brought in to see if I can get those data points?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks