I have a need to predict when a large set of small tasks will close and therefore generate revenue. For each of 10 project types I know and average number of days to complete and the fixed invoice price for each. Each day I launch a few hundred of these tasks with an ever changing mix of the quantity of each type on any given day. What I need is a way to "place" the revenue value for each individual task into the predicted close date. The result would hopefully be a "next 90 days or so" calendar in which each date has an accumulated bucket of tasks originally predicted to close on that date. The $$ value of all of the projects expected to close on that day forms the forecast for that day. I would then roll up to weekly, monthly forecasts, etc.

Any help on the formulas for populating this calendar would be appreciated.