Annual planning for proposal teams: the three-sheet model
A three-sheet annual plan — bid forecast, capacity forecast, skill-gap sheet — that a small proposal team can build in a week and revise quarterly. Due by mid-January if you want it to matter.
Every proposal team I have ever run or advised has built some version of an annual plan. Most of them were too detailed to maintain and got abandoned by March. A few were useful. The useful ones had three sheets and no more, and they got revised every quarter without being rewritten.
This is that model. Three sheets. A week of work to build, an hour a quarter to revise. If it is going to matter for 2026 it needs to be done by mid-January, before the first major Q1 RFP lands.
Sheet one — the bid forecast
The bid forecast is the list of opportunities you expect to respond to in the year ahead, with enough structure to be decision-useful and not so much structure that it stays accurate.
The columns I use: opportunity name, expected issue date (even if approximate), expected submission date, estimated effort in hours, win probability, confidence in the estimate, and the bid-or-no-bid decision (yes / probable / hold / no). That is seven columns and it is enough.
The two things to get right are the effort estimate and the confidence. Effort in hours is more durable than “small / medium / large” because it composes with the capacity forecast on sheet two. Confidence is more honest than a single win-probability number because it separates “I have seen four of these and know how much they take” from “this is a new buyer and I am guessing.” Two proposals with the same effort and win probability but different confidence levels should be staffed differently. The confidence column is how you see that.
Expect the bid forecast to be about 70% accurate by count in Q1 and 50% accurate by Q4. That is fine. The purpose is not to predict the year; it is to have a baseline that revisions can improve on. A forecast you revise every quarter beats a forecast you build once and defend.
Sheet two — the capacity forecast
The capacity forecast answers the question “can we actually do the work on sheet one.” Simple arithmetic: available proposal-team hours per quarter, minus overhead (KB maintenance, training, admin, coverage for vacations and illness), minus committed hours on active opportunities, gives you free capacity per quarter. Compare that to the effort-hours sum on sheet one for the same quarter.
If the ratio is above 1.0, you are over-committed. If it is below 0.6, you are under-deployed. In between is workable, with the reality that hit-rate and effort both vary from the forecast.
The trap on sheet two is counting overhead honestly. The mature proposal shops I have worked with run overhead at 25% to 35% of nominal capacity. The immature ones run it at 10% on the plan and 40% in reality, and they blow up in Q2 when the overhead accrues faster than the plan admitted. Count it honestly at the plan stage or pay for it later.
The second trap is capacity that exists on paper but not in practice. A senior proposal manager who is also the primary SME for three of your top opportunities is not fully available for response work even when the calendar says they are. Mark the overlaps. A 50% available senior is better accounting than a 100% available senior who is actually 50%.
Sheet three — the skill-gap sheet
The skill-gap sheet is the one that gets skipped most often, which is why the teams that skip it miss the capture window for a target vertical and notice in June that they have nobody who can write healthcare DDQs.
The sheet has two sections. The first is the capability matrix: for each target vertical (healthcare, federal civilian, federal defense, enterprise SaaS, financial services, state and local, etc.), which team members can lead a response, support a response, or need to skill up. The second is the planned interventions: hires, training, partnerships, or deliberate staffing of smaller bids as development opportunities.
The matrix is easy to build and useful to revise. The interventions section is the one that forces real decisions. If healthcare is a 2026 target and the matrix shows that no one on the team can lead a healthcare response, you have three choices: hire, partner with someone who can, or drop healthcare as a 2026 target. All three are viable. Pretending that someone on the team will figure it out under deadline pressure is not.
How to maintain these
Three rules I have followed and seen work.
Revise quarterly, not weekly. Weekly revisions mean the plan is noise. Quarterly revisions mean the plan is a decision instrument. The end-of-quarter review takes two hours and updates all three sheets against actuals.
One person owns each sheet. The bid forecast lives with the capture lead or proposal director. The capacity forecast lives with the proposal ops or proposal manager. The skill-gap sheet lives with whoever does talent planning — often a director or VP. Single-owner sheets get maintained. Multi-owner sheets get orphaned.
Keep the history. When you revise a sheet, save the prior version. The skill-gap sheet in particular benefits from being able to look back at what last year’s plan said and what actually happened. That is how you get better at the plan over time.
The thing this is not
This is not a portfolio-management tool. It does not replace a CRM, a resource-planning system, or the opportunity-tracking you do with sales. It sits on top of those and answers proposal-team-specific questions: what are we going to respond to, can we do it, and what do we need that we do not have.
A team of five can run the whole thing in a shared spreadsheet. A team of 20 benefits from putting it in a more durable tool. A team of 50 will have outgrown the three-sheet model and moved to something more structured. That is fine. The three-sheet model is the minimum useful plan. Everything above it is a refinement, and everything below it is guessing.
Due by mid-January. The first Q1 RFP that lands after the plan is in place is the one that tells you whether it was the right plan. Iterate from there.