Let's Talk

How Coastal Brought Its Monthly Revenue Forecast Variance Down to 4%  on Salesforce

Coastal built a resource forecasting and revenue analytics tool in Salesforce that enables project managers to set hours by individual resource and project line and see cross-project capacity in one place. We replaced the automated standard spread with granular, integrated forecasting to improve predictive revenue and achieve higher utilization. Since the launch, we’ve eliminated quarter-end write-offs, and monthly forecast variance is down to 4%.

Challenge

Every consultancy forecasts revenue based on a schedule, and every schedule drifts from the hours that are actually worked. Plans change: a client pushes a kickoff, a stakeholder gets sick, a consultant quits, and you shift some of the hours you expect to bill.

That drift is normal, and no project manager can prevent it. The problem was that our system had no way to record that drift, so hours accumulated invisibly until the quarter closed. Specific challenges included:

  • Automatic Hour Spreading: Our PSA platform distributed project hours evenly across an engagement, with no mechanism to record a week that didn't go as planned. If a client pushed a kickoff and a consultant's hours dropped, the software moved the shortfall into a future week and carried on as if the time would be made up.
  • Quarter-End Revenue Shortfalls: Unworked hours accumulated over time. By the end of a quarter, the schedule showed consultants booked beyond their available hours, creating revenue at risk of not being delivered.
  • Invisible Double-Bookings: Project managers on different projects might staff the same senior consultant for the same week without visibility into existing allocations, which could create capacity conflicts once delivery began.
  • Lagging Financial Data: Timecards and reconciliations took 14 to 20 days to close, leaving leadership working from a two-week-old snapshot.

We rebuilt how the schedule is made so it reflects active operational intent and monitors shifting conditions, rather than building on past actuals.

Solution

We needed a way for project managers to record weekly schedule changes, ensuring the forecast was updated the same day. We created the Forecast Builder — a scheduling layer on our PSA platform connected to Salesforce. Key Solution Features:

  • Week-Level Schedule Overrides: Project managers set explicit hours for each consultant and each project each week. Every hour reflects what the PM knows about that week, including what changed. When a client slips a kickoff, the PM zeroes the week and the forecast reflects it that afternoon.
  • Cross-Team Resource Totals: Unidentified cross-team double-bookings force last-minute scrambles that cause slipped delivery and margin leakage. A roll-up field totals each consultant's hours across all projects and teams simultaneously, turning over-allocations red and blocking the save before commitments are locked in.
  • Real-Time Variance Tracking: A PM's plan for the week and what a consultant actually works can diverge, and without real-time visibility that gap might not surface until the quarter closes. We built week-by-week variance tracking directly into the scheduling screen, so a PM sees the moment a plan and reality drift apart, not weeks later at billing.
  • Unified Revenue Forecast: Weekly delivery schedules feed into Salesforce alongside open opportunities, displaying committed delivery revenue and pipeline opportunities in a single view.

The result is a schedule leadership can read as a forecast, because it stays current with actual operational commitments.

Clouds & Products

  • Sales Cloud
  • Coastal Forecast Builder
  • Salesforce CRM Analytics
  • Tableau

Results

The change showed up in the first full quarter.

  • Accurate Monthly Forecasting: Monthly revenue lands within 4% of forecast, replacing our prior pattern of discovering the final number at close.
  • Eliminated Quarter-End Write-Offs: Weekly updates clear unworked hours as changes occur, ensuring the quarter ends on a number predicted by the schedule.
  • Prevented Double Bookings: Cross-team visibility surfaces capacity conflicts at the point of scheduling, protecting project margins and consultant workloads.
  • Earlier Staffing Gap Detection: Live utilization tracked alongside a 90-day pipeline flags capacity shortfalls weeks before they impact client delivery.
  • Consultant-Validated Forecasts: Consultants review their own forecasts and flag any errors to their PM, closing the loop rather than leaving variance to surface at close.

Any business that sells consulting capacity runs on a schedule that doubles as a revenue forecast, so when the schedule shifts, the financials do too. Most software absorbs that drift by pushing unworked hours forward and eroding project margins. We closed the gap by giving project managers an immediate way to record weekly commitments, ensuring the forecast stays aligned with field delivery.