Open to Buy

01

The same buying plan, in two different tools

Look Cloud · OTB Module

Open To Buy (OTB) is coming to Look Cloud: the new merchandise planning module designed to answer exactly how much you can buy and why you deviated from the plan.

Traditionally, buying planning required maintaining manual Excel spreadsheets for each season, making them prone to errors and disconnected from actual execution.

Look Cloud OTB - Excel vs Look Cloud

With the OTB module in Look Cloud, there are no formulas to maintain: the plan, actuals, variance, and exceptions are automatically calculated using real ERP data.

Look Cloud OTB - Excel vs Look Cloud
02

How OTB is calculated: planned vs. actual

Formula · Metrics

The system applies the same logic to two versions of the data: what was planned and what was reported by the ERP.

OTB = Sales + Markdowns + Target Ending Stock − Beginning Stock − On Order

Sales & Markdowns

You need to replenish what sells; markdowns reduce inventory value.

Target Ending Stock

Defines the desired merchandise level at the end of the period.

Beginning Stock & On Order

Subtracts what you already have in inventory and what is already committed through purchase orders.

Look Cloud OTB Detail Rows and Columns

The detail can be dynamically expanded across both rows and columns, allowing you to compare the plan against actuals in dollars or units.

03

A plan tailored to your brand

Configuration · OTB Assistant

The module includes an intuitive creation assistant organized into four simple steps:

Assistant Steps
1. Scope 2. Data Source 3. Calculation Parameters 4. Review

You can define seasons, monthly or weekly segmentation, select clusters, and build the product dimension hierarchy in whatever order you prefer.

Eligible Dimensions
Department Category Brand Product Group Collection Season
04

All the functionality at your fingertips

Workflow · Actions

Four key actions are centralized on a single screen to manage the plan over time:

  • Seed Plan: Distributes a strategic growth target across the entire product hierarchy.
  • Reforecast: Adjusts open periods by channel based on each channel's current trend.
  • Recalculate: Automatically rebuilds the OTB from end to end after any change.
  • Approve: Closes the working version and freezes the plan as the official reference.
Look Cloud OTB Plan Actions
05

Edit wherever it makes sense, and the numbers stay aligned

Planning · Hierarchy

It doesn't matter which level you modify: whether department, category, brand, or cluster, change a value and the module distributes and recalculates the entire hierarchy.

Look Cloud Editing and Hierarchy Impact

Change a leaf value and its parent levels are automatically recalculated upward, instantly updating the total plan.

06

The season moves forward, and the plan keeps its history

History · Versions (V1, V2, V3...)

Each month that ends is closed. That actual history is exactly what is used to replan the remaining open months.

Season Status
June · CLOSED July · CLOSED August · CLOSED September · OPEN (Reforecast) October · OPEN (Reforecast)

The past cannot be rewritten: when a month ends, its plan is locked with the actuals reported by the ERP. No one can go back and adjust the numbers. Open months are rebuilt using the variance revealed by the past.

Every approval creates a snapshot: every time the plan is reforecast and approved, the module freezes a complete version of the plan (V1, V2, V3...). At the end of the season, you can review what was decided at each point in time and what changed afterward.

07

What was planned vs. what actually happened

Summary · Exceptions

You can analyze the information by period or across the entire season, in dollars or units, with the automatic branches ranked by their contribution to the variance.

Look Cloud Variance Summary

Where the variance comes from, ingredient by ingredient: the system shows plan vs. actual for each metric and the exact contribution of each one to the OTB. The five contributions add up exactly to the variance; nothing is assigned to an "other" category.

Look Cloud Variance Summary
08

And when more detail is needed, it doesn't stop at the cluster level

Look Intelligence · SKU Level

While the OTB Module plans purchases by period and cluster, with a single click you can move to Look Intelligence to perform seasonal analytics and demand planning at the SKU level.

Every authorized purchasing dollar has a number behind it. And at the end of the season, you can see with complete precision whether that number was the right one.