Case Study

Portfolio Redistribution App

An internal planning app for ARR redistribution scenarios and handoff planning — reducing multi-day manual workflows to minutes.

System: scenario planning, days → minutes
BEFORE — MANUALSpreadsheetsEmail threadsManual rebalanceDaysScenario Engineself-service · one surfacemodel · compare · commitAFTER — SELF-SERVICEMinutesREBALANCED ACROSS CSMsDays Min
01

Before / After

Territory movement without the spreadsheet rebuild

Book rebalancing and scenario planning required days of spreadsheet work, delaying coverage decisions and impacting customer continuity.

Before · The Problem

Territory planning was too manual and slow

When territory changes were needed — due to CSM departures, account growth, or strategic realignment — the planning process required manual data extraction, complex spreadsheet modeling, and days of iteration. This delayed coverage decisions and created risk during account handoffs.

After · The Solution

Self-service scenario planning

Live operating data, an interactive scenario builder, and generated handoff artifacts moved the planning workflow into one surface where leaders could model changes before executing them.

02

Scenario Trace

One territory move, from baseline to handoff

The scenario planning and redistribution flow is organized around one auditable movement rather than a generic systems diagram.

01

Baseline

Pull current operating data

A FastAPI backend pulls live ARR, account assignment, and CSM capacity data from Salesforce and internal systems, eliminating manual spreadsheet updates.

02

Move

Model the territory change

A TypeScript frontend lets leadership drag and drop accounts between CSMs instead of rebuilding the plan across spreadsheets.

03

Compare

Inspect portfolio impact

Each move immediately shows the impact on portfolio balance, coverage ratios, and handoff risk so multiple saved scenarios can be compared before execution.

04

Execute

Generate the handoff

The selected scenario generates structured handoff documents and CRM update scripts automatically, reducing the operational overhead of executing territory changes.

03

Results

Days of work to minutes

200+

Accounts modeled for redistribution

15

CSMs rebalanced in one planning surface

Days → Min

Planning cycle time reduced

04

Implementation

Technology stack

PythonFastAPITypeScriptReactSalesforce APIData WorkflowsInternal Tooling

Source & Artifacts