Agency Capacity Forecaster — Utilization & Scope-Creep Change Request Kit — product cover

Category: Spreadsheets · Business Spreadsheets

About this product

Stop discovering overload the week someone quits. The Agency Capacity Forecaster turns your roster, your bookings, and your pipeline into a 12-week forward view of capacity vs demand.

WHAT'S INSIDE (everything verified, all counts exact):

  • TEAM sheet — 8-person sample roster (name, role, weekly capacity hours, billable target %, cost & bill rates). Example values, clearly labeled — replace with your own team.
  • ALLOCATIONS sheet — per-person × 12-week booked-hours grid with automatic utilization % per person-week: over 85% flags HOT, over 100% flags OVERLOADED, with team weekly totals.
  • PIPELINE sheet — 8 sample prospective projects with estimated hrs/week, duration, start week and win probability; probability-weighted weekly demand plus a win-all column set.
  • FORECAST dashboard — 12-week capacity vs booked vs weighted pipeline demand: total demand, gap/surplus per week, utilization %, OK/HOT/OVERLOADED status, HIRE TRIGGER flags (demand beats capacity 3 weeks running), "weeks until overload" callout, and avg utilization by person.
  • SCENARIOS sheet — what-if toggle: Weighted vs Win-all pipeline, with a win-all-minus-weighted delta row and clearly labeled assumptions.
  • CHANGE LOG — scope-creep change request tracker (date, client, change, extra hours, approved?, billed?) with totals: requested, approved, and approved-but-unbilled hours.
  • Change-Request-Form.docx — one-page client sign-off form so no out-of-scope work starts without written approval.
  • Quick-Start-Guide.pdf — 10-minute setup + the 5-minute weekly workflow.

WORKS IN: Microsoft Excel and Google Sheets (native formulas only, no macros, no add-ins).

DISCLOSURES: All sample names, clients, hours and rates are fictional. Team rates are example placeholders, not industry standards. All outputs are arithmetic on YOUR inputs; this tool makes no revenue, hiring or business-outcome guarantees and is not business, legal, financial or tax advice. Staffing, pricing and contract decisions remain yours.

What's included

  • Agency Capacity Forecaster workbook (.xlsx, 7 sheets, 100% native formulas, zero macros):
  • START HERE — setup and disclosures
  • TEAM — 8-person sample roster (name, role, weekly capacity hours, billable target %, cost & bill rates); example values, clearly labeled — replace with your own team
  • ALLOCATIONS — per-person × 12-week booked-hours grid with automatic utilization % per person-week: over 85% flags HOT, over 100% flags OVERLOADED, with team weekly totals
  • PIPELINE — 8 sample prospective projects with estimated hrs/week, duration, start week and win probability; probability-weighted weekly demand plus a win-all column set
  • FORECAST dashboard — 12-week capacity vs booked vs weighted pipeline demand: total demand, gap/surplus per week, utilization %, OK/HOT/OVERLOADED status, HIRE TRIGGER flags (demand beats capacity 3 weeks running), "weeks until overload" callout, and avg utilization by person
  • SCENARIOS — what-if toggle: Weighted vs Win-all pipeline, with a win-all-minus-weighted delta row and clearly labeled assumptions
  • CHANGE LOG — scope-creep change request tracker (date, client, change, extra hours, approved?, billed?) with totals: requested, approved, and approved-but-unbilled hours
  • Change-Request-Form.docx — one-page client sign-off form so no out-of-scope work starts without written approval
  • Quick-Start-Guide.pdf — 10-minute setup + the 5-minute weekly workflow
  • README/license — license terms + disclosures

Key features

  • 12-week forward view → capacity vs booked work vs probability-weighted pipeline demand, week by week, in one dashboard
  • Utilization flags that fire on their own → over 85% flags HOT and over 100% flags OVERLOADED per person-week, so overload shows up before it becomes a resignation
  • Hire triggers, not gut feel → a HIRE TRIGGER flags when demand beats capacity 3 weeks running, plus a "weeks until overload" callout
  • Weighted vs Win-all what-if → toggle the pipeline scenario and see the delta, with assumptions clearly labeled
  • Scope creep gets a paper trail → change-request tracker with requested/approved/approved-but-unbilled totals, plus a one-page client sign-off form (.docx)
  • 100% native formulas, zero macros → works in Microsoft Excel and Google Sheets, no add-ins

Frequently asked questions

Does the workbook work in Google Sheets?

Yes — it uses 100% native formulas with zero macros and no add-ins, and works in Microsoft Excel and Google Sheets.

Is the sample data real?

No — all sample names, clients, hours and rates are fictional and clearly labeled. Team cost/bill rates are example placeholders, not industry standards — replace all of it with your own numbers.

How does the hire trigger work?

The FORECAST dashboard flags a HIRE TRIGGER when demand beats capacity 3 weeks running, and shows a "weeks until overload" callout. It is arithmetic on your inputs, not a hiring guarantee.

What do the HOT and OVERLOADED flags mean?

On ALLOCATIONS, a person-week over 85% utilization flags HOT and over 100% flags OVERLOADED, with team weekly totals alongside.

How does the kit handle scope creep?

The CHANGE LOG tracks each change request (date, client, change, extra hours, approved?, billed?) with totals for requested, approved, and approved-but-unbilled hours, and the Change-Request-Form.docx is a one-page client sign-off form so no out-of-scope work starts without written approval. Have your own counsel review the form before use.

What if I need help with the files?

Message the seller through the Gumroad product page contact form.

Agency Capacity Forecaster — Utilization & Scope-Creep Change Request Kit — product image

Agency Capacity Forecaster — Utilization & Scope-Creep Change Request Kit

A 12-week capacity forecaster for 5–25 person agencies: team roster, per-person weekly allocations with utilization flags, probability-weighted pipeline demand, a hire-trigger dashboard, a Weighted vs Win-all what-if, and a scope-creep change-request kit.

$29

Buy Now on Gumroad

Related products

More Spreadsheets
TradeGuard — Contractor Job Costing, Price-Book & Change-Order OS — product image
Spreadsheets

TradeGuard — Contractor Job Costing, Price-Book & Change-Order OS

Stop losing margin to guesswork bids and unsigned change orders. TradeGuard is a no-macros Excel/Google-Sheets system for residential GCs and remodelers: a 312-item master price book, a markup-protected bid estimator that shows your TRUE gross margin, a client-ready proposal view, per-cost-code job costing with a subcontractor draw tracker, and a change-order log with automatic margin impact — plus 3 fillable change-order sign-off PDFs.

MakerMargin Pro — 3D Print & Craft Quote Engine — product image
Spreadsheets

MakerMargin Pro — 3D Print & Craft Quote Engine

Know your exact net profit on every single-color or multi-color 3D print — before you slice. A no-macros Excel/Google Sheets quote engine for print farms and custom makers: true per-job costing (filament by the gram with purge waste, machine depreciation, electricity, labor, hardware BOM, failure buffer), markup vs true-margin pricing, and a side-by-side fee simulator showing your real net on Etsy Organic, Etsy Offsite Ads, Shopify and Wholesale.