Connected Planning

What is connected planning?

Connected planning is a planning methodology where all stages of the merchandising planning process — OTB financial planning, assortment architecture, buy planning, allocation, and in-season management — operate on a shared data model that maintains referential integrity across every decision. When a financial target changes, assortment constraints update. When an assortment changes, buy plans reflect new requirements. When actual performance data arrives, variance analysis runs automatically against the original plan.

In apparel, connected planning stands in direct contrast to the dominant model of spreadsheet-based planning, where each planning stage exists in a separate file with manual data transfers between them.

Why connected planning matters in apparel

The apparel planning workflow is inherently sequential and interdependent. The OTB sets financial guardrails. The assortment plan determines which styles to carry within those guardrails. The buy plan determines how many units of each style to purchase. Allocation determines where those units go. Every downstream decision depends on upstream inputs.

In a disconnected planning environment — which describes the majority of mid-market apparel brands — these dependencies are maintained manually. A planner exports OTB targets to a spreadsheet, emails it to the buyer, who builds a buy plan in a different spreadsheet, which is then manually reconciled back to the OTB. This manual reconciliation introduces three problems that connected planning eliminates.

First, latency. Every manual handoff adds days. A change to the OTB may not reach the buy plan for a week. During that week, the buyer is working against stale targets.

Second, version conflict. When the OTB exists in one file and the buy plan in another, there is no guarantee they agree. Connected planning enforces consistency by storing both in the same data model.

Third, error. Manual data transfer between spreadsheets is a reliable source of formula errors, copy-paste mistakes, and overwritten cells. Connected planning eliminates the manual transfer entirely.

Connected planning in practice: apparel example

A sportswear brand plans its spring season using a connected planning approach. The VP of Merchandising sets the OTB: $12M in receipts across four categories with target gross margin of 58%. The assortment team builds a 150-style architecture within those financial constraints — the connected system prevents them from planning more receipts than the OTB allows.

Mid-planning, the VP revises the denim category target upward by $500K based on a trend signal. In a connected system, the assortment plan for denim immediately shows the additional receipt capacity. The buy team sees the new target in their workflow and can add depth to existing styles or introduce additional options. The allocation module adjusts projected inventory levels for denim doors.

In a disconnected environment, this $500K revision would require manual updates to four separate spreadsheets, each maintained by a different team member, with email follow-ups to confirm everyone is working from the same number. The revision that takes minutes in connected planning takes days in spreadsheets.

Common mistakes

Connecting systems but not processes. Integrating software without redesigning the planning workflow creates connected data but disconnected people. Connected planning requires both a shared data model and a shared process that defines who makes which decisions and when.

Assuming connected means centralized control. Connected planning does not mean the VP of Merchandising dictates every decision from the top. It means that decisions made at each level are immediately visible to all other levels — enabling faster collaboration, not tighter control.

Implementing connected planning incrementally by module. Connecting OTB to assortment but leaving buy planning in spreadsheets creates a partially connected system that still requires manual reconciliation at the remaining handoff points. The value of connected planning scales with the number of stages connected.

Underestimating the change management effort. Planning teams that have operated in spreadsheets for years have workflows, shortcuts, and habits built around disconnected files. Transitioning to connected planning requires explicit process design and training, not just software deployment.