FP&A & Financial Modeling3 min readUpdated September 2026

Cube vs. Mosaic for a Solar EPC's Project Pipeline Forecast

A commercial solar or energy EPC contractor plans around a pipeline of projects moving through development, procurement, and construction stages, each with its own equipment lead time, permitting timeline, and percentage-of-completion revenue schedule once construction starts. A forecast that only looks at signed contracts misses the projects still moving through permitting that will convert to revenue two or three quarters out.

Here's a step-by-step approach to building that forecast, and where Cube and Mosaic each fit into it.

Vendors Covered in this Article

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

How do you build a stage-weighted pipeline, not a signed-contract list?

Every project in development, from initial proposal through signed contract to notice to proceed, carries a different probability of actually reaching construction. Apply a stage-based conversion rate to each project's expected value rather than treating every pipeline entry as equally likely to close, so your forecast reflects the real uncertainty in projects still working through permitting or financing. Recalculate those conversion rates periodically against your own actual close history rather than setting them once and leaving them fixed, since a rate that was accurate a year ago may no longer reflect your current sales process or the markets you're bidding into.

Step two: separate equipment lead time from construction timeline

Panels, inverters, and switchgear often have to be ordered months before a project's construction start date, which means a delay in permitting doesn't necessarily delay the equipment order, and a delay in equipment delivery doesn't necessarily delay permitting. Model these as separate tracks feeding into the same project timeline rather than one combined project duration, so a bottleneck in either one shows up clearly instead of getting averaged away. A procurement delay on a single large order can quietly push back several projects at once if your model doesn't track which projects share a common equipment order.

Step three: pick Cube if your project accountant already models this in Excel

If your team already builds stage-weighted pipeline forecasts and separates equipment lead time from construction schedule in a spreadsheet, Cube's approach of syncing that model against your project management and procurement data keeps the logic where it's understood, without asking anyone to rebuild it inside a new interface.

Step four: pick Mosaic if you need one dashboard across a growing project count

Once you're running enough concurrent projects that tracking each one's stage, equipment status, and percentage-of-completion revenue in a single spreadsheet gets unwieldy, a dashboard rolling all of that into one view can help. Confirm in a demo that Mosaic's revenue recognition matches percentage-of-completion accounting rather than a simpler milestone or subscription-style model, since EPC revenue recognition has real nuance a generic template can miss.

How do you stress-test the forecast against a permitting delay?

Permitting timelines are the single least predictable variable in most solar and energy projects, varying by jurisdiction in ways that are hard to model precisely. Run the pipeline forecast at a baseline permitting timeline and a delayed case for your jurisdictions with historically slower approval processes, so a stretch of permitting delays across a few projects doesn't blow a hole in your revenue plan without warning. Keep the delayed case updated with your own recent experience by jurisdiction rather than a generic assumption applied uniformly across every market you operate in.

Step six: bring in Jirav once project and crew headcount need to scale together

Jirav's driver-based forecasting is useful once you're planning to grow project volume and need the model to show how many additional installation crews, project managers, and procurement staff that growth actually requires, rather than assuming existing headcount can absorb an expanding pipeline. That tie between project volume and staffing capacity is often the real constraint on how fast an EPC contractor can actually grow, more so than sales pipeline alone.

Step seven: separate interconnection risk from construction risk

A project can finish construction on time and still sit waiting on utility interconnection approval before it can actually be energized and revenue fully recognized, and interconnection timelines are frequently outside your control and outside the EPC contract's own schedule. Track interconnection status as its own forecast variable separate from construction completion, so a queue backlog at the utility doesn't quietly delay revenue recognition in a way your model never anticipated.

Step eight: confirm either platform can handle change orders on an active project

Scope changes during construction, a site condition that requires additional engineering, a customer-requested equipment change, are common enough on solar and energy projects that your forecast needs a clean way to update a project's expected revenue and cost mid-build. Confirm in a demo how change orders flow through either Cube's spreadsheet model or Mosaic's dashboard, since a tool that makes this a manual override rather than a structured update will drift out of sync with reality on your most complex projects.

Check these points in a demo before you choose:

  • Ask how a change order updates a project's expected revenue and cost in Cube's spreadsheet model versus Mosaic's dashboard.
  • Confirm the platform's revenue recognition follows percentage-of-completion accounting rather than a simpler milestone or subscription-style method.
  • Check that stage-based conversion probabilities can be applied to each project in the pipeline.
  • Verify that interconnection status can be tracked as its own variable, separate from construction completion.
  • Run a delayed permitting case alongside the baseline to see whether the forecast still holds.
Executive Capability Standard

What Good Looks Like

A well-run EPC contractor forecasts revenue off a stage-weighted pipeline that reflects real conversion probability by project stage, with equipment lead time and construction timeline tracked as separate variables.

Building The Capability (5-Stage Skill Ladder)

1. Learn:Learn how your current pipeline forecast weights projects by stage, and whether equipment lead time is modeled separately from construction schedule.
2. Do Manually:Build a spreadsheet applying stage-based conversion rates to pipeline value and tracking equipment lead time against construction start dates, updated monthly by hand.
3. Delegate:Assign a project accountant or pipeline manager to own the stage-weighting review and flag any project whose timeline assumptions look stale.
4. Automate:Sync project management and procurement data into Cube or Mosaic so stage-weighted pipeline and equipment lead time update without a manual pull each month.
5. Buy:Standardize project management, procurement, and forecasting on one connected platform so crew and project manager staffing plans reflect real pipeline conversion.

How to Get Started

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

Frequently Asked Questions

Should a project in the permitting stage be included in the revenue forecast at all?

Yes, but weighted by its stage-based conversion probability, not at full expected value. Excluding pipeline projects entirely understates future revenue, while including them at full value overstates near-term certainty; a weighted approach reflects the real range of outcomes.

How far in advance should equipment be ordered relative to construction start?

That depends on current lead times for your specific equipment and suppliers, which shift with market conditions. Track your own historical lead times by equipment type rather than relying on a fixed rule, since lead times for panels, inverters, and switchgear don't always move together.

Do Cube or Mosaic track permitting status directly?

No, permitting and project management status typically live in a separate project management system. Both forecasting tools can incorporate that stage data once it exists somewhere, but neither one tracks permitting or interconnection approval on its own.

About the numbers

This guide doesn't quote a sourced benchmark. Figures in it are estimates or general guidance, so check them against your own numbers.

Related Guides