I am trying to forcast a the size of an agent’s funnel of orders based on the following criteria:
I know that:
– Each agent will be assigned around 105 new orders/month
– Each order will remain in that agent’s funnel for 69.7 days before it completes
By using these numbers, I would like to forecast how large of a funnel of orders the agent would have to manage as new ones come in for the month, and old orders would leave the funnel as they complete.
Can someone help me understand what types of formulas I would need to accomplish this forecast?
By: Dustin Svoboda