industry
Business Services

Modeling gross margin across 100,000+ business sites

Context

A janitorial services company with 70k+ locations outgrew its gross margin forecasting and budgeting process. It needed a scalable planning tool that could forecast at the location level without performance issues.

Value Created

Accelerated planning
through a scalable Anaplan model planning 70k+ locations
Improved data quality
with NetSuite billing and revenue feeding the model
Delivered on a tight timeline
with close finance and IT collaboration

People

VALUE LEVERS

  1. Finance and IT alignment

HOW WE DID IT

  • Partnered with finance and IT teams to define the solution framework

Process

VALUE LEVERS

  1. Location-level margin planning
  2. Workforce cost modeling
  3. Flexible expense planning

HOW WE DID IT

  • Built location-level forecasting and budgeting
  • Modeled workforce costs from service plan data
  • Enabled trend- or driver-based expense planning

Technology

VALUE LEVERS

  1. Scalable Anaplan model
  2. NetSuite data integration
  3. Variance reporting dashboards

HOW WE DID IT

  • Implemented an Anaplan model built to plan at 70k+ location scale
  • Integrated location-level billing and revenue data from NetSuite
  • Designed dashboards for forecast, budget, and variance analysis