Forecasting the size of an order funnel based on new orders and ones that complete out

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

Leave a Reply

Your email address will not be published. Required fields are marked *