RFP Pipeline and Capacity Tracker

Every bid tracker is the same object: buyer, value, due date, owner, and a red-amber-green dot somebody sets by feel. It answers what is due soonest, which is a question nobody actually has. The one people do have is what will not get done. A deadline cannot answer that, because a deadline is a date and the thing that runs out is a particular person's particular week.

So this pack estimates hours by role instead of in total, then spreads them across the weeks before each deadline on a profile that differs by role. Writing rises toward the deadline. Technical input falls away from the start, because the writer cannot draft what the engineers have not yet explained. Pricing lands in the final fortnight and review in the last week. Sum that across every live bid and you have hours demanded per person per week against the hours they actually have.

What that says first is that the bid breaking a week is often not the bid due that week. In the worked example the engineering pool runs 6.3 hours short in week 3 because of a bid not due for another six, and four of the fifteen shortfalls have that shape. Bid or no-bid then becomes a selection rather than a score, because sets compete: the same bid is nearly free in a quiet week and ruinous in a full one. The biggest opportunity on the board loses to three smaller ones by $526,494.