Open to Buy Inventory Planning for Hardware: Count Existing Orders Before New SKUs

Open to buy inventory planning is useful when a category buyer needs to decide whether an additional purchase commitment fits a defined merchandise receipt plan. For bathroom and home-storage hardware, the answer depends on the planning period, SKU or category, stock assumptions, planned receipts, and existing orders expected in that period. The buyer must recognize each commitment once on a consistent unit or valuation basis, then check supplier minimums, finish choices, and timing separately.

In open to buy inventory planning, a buyer must identify which existing commitments are already represented in the plan.

Open-to-buy (OTB) is a planning concept, not a bank balance, supplier promise, profitability result, or automatic purchase authorization. Different retailers and software systems can define and calculate it differently. The example in this guide is a clearly hypothetical unit-based illustration informed by one documented software model; it is not a universal formula, an accounting policy, or Koitor customer data. Koitor does not own a buyer’s inventory plan, demand forecast, finance approval, or ERP records.

Short answer: calculate receipt headroom without double-counting orders

First identify the plan and its unit of measure. Then determine the planned ending inventory and receipts for the relevant period, identify which open purchase-order lines are already included in those figures, and recognize the commitments once. Only after the remaining plan headroom is understood should the buyer compare it with the supplier’s actual MOQ, pack multiple, finish, production timing, and cash approval.

A simplified decision sequence is:

1. Freeze the planning version and receipt period.
2. Choose a compatible basis: units for a specific SKU, or a defined value basis for an appropriate category rollup.
3. Identify the plan’s ending inventory, planned receipts, and open orders.
4. Determine whether open orders have already been included in the plan calculation.
5. Reconcile remaining headroom and investigate any negative or unexpectedly large result.
6. Check whether the supplier’s minimum, pack, finish, and timing fit the available plan.
7. Route any purchase decision through the buyer’s normal authorization and finance process.

The key control is not a magic formula. It is a consistent plan definition and a clear rule for how commitments enter it. Subtracting an order that is already netted into another planning field can understate headroom. Failing to recognize an order that is not included can overstate it. Both errors can distort a proposed purchase quantity.

What does open-to-buy mean in a hardware assortment?

In retail planning, OTB generally describes planned buying room over a defined period based on a merchandise plan and existing commitments. Shopify’s guide describes a time-bound plan and emphasizes reconciling existing orders; Oracle’s historical fashion-planning documentation describes a product-specific OTB view using current and working-plan inventory, receipts, and net on-order fields. These examples demonstrate why the buyer must inspect the exact system definition. They are not a mandatory hardware procurement formula or financial recommendation.

The buyer should distinguish several related but different questions:

For distinct buyer decisions, see the hardware replenishment and ABC/XYZ classification guide, the sell-through versus sales-velocity guide, and the GMROI guide for bathroom-storage inventory. Those pages help answer neighboring questions; they do not replace the commitment-headroom reconciliation here.

Define the planning basis before doing arithmetic

A buyer can plan at the unit level for one SKU, at a value level for a defined class, or within a software-specific retail/cost profile. Those bases are not freely interchangeable. Do not add one shower-caddy unit to one towel-ring unit and label the result meaningful “category inventory” unless the model defines a valid aggregation. For a mixed assortment, the buyer may need a documented value basis, a controlled product-family rollup, or a separate calculation for each SKU.

Record the plan’s:

• Version name, owner, approval date, and planning period.
• Currency and valuation basis, if using monetary values.
• SKU, finish, pack configuration, and unit of measure.
• Beginning and expected ending inventory assumptions.
• Planned sales or consumption inputs, where the plan requires them.
• Planned receipts and the expected receipt dates.
• Open purchase-order lines and the period each line affects.
• Rule for recognizing committed orders once.
• Treatment of cancellations, delays, partial shipments, and revised quantities.
• Responsibility for any finance, budget, or purchase approval.

A period definition is especially important for imported hardware. A purchase order issued this month may not be expected to arrive in the same period. A supplier shipment date and a warehouse receipt date are not necessarily the same planning event. The buyer should use the organization’s chosen receipt convention consistently and avoid moving a commitment between periods simply to make a calculation appear more comfortable.

A transparent, hypothetical unit example

Oracle’s Release 19 fashion-planning guide documents an OTB view with current-plan ending inventory, working-plan ending inventory, planned receipts, and net on-order fields. One example under that system produces a 50-unit result from a 500-unit current-plan ending inventory, 500-unit working-plan ending inventory, 200 units of planned receipts, and 150 units of net on-order. Written for this article as a hypothetical single hardware SKU and period, the arithmetic is:

500 − 500 + 200 − 150 = 50 units of OTB under that documented model.

This does not make the calculation universal. The exact meaning of each field comes from the software model and plan configuration. If the open orders are already included in the receipt or working-plan value, subtracting them again would count the same commitment twice. If they are excluded, omitting them may make the remaining headroom look larger than it is. Buyers should map the source system fields before reusing an example formula.

For this buyer guide, open to buy inventory planning is a comparison phrase; it does not replace exact model, evidence, and acceptance criteria.

The result is also not an automatic purchase order. If the plan shows 50 units of headroom, a supplier that requires a 100-unit MOQ does not create an entitlement to buy 100. The buyer can revise the plan, reconsider the assortment or quantity, investigate timing, or decline the purchase. The organization’s authorization process decides what is approved. Do not round the OTB result upward to match MOQ without a separate decision.

Buyer approval and sourcing controls

Recognize purchase orders once and only once

The most common source of an unreliable result is a mismatch between what the buyer thinks “on order” means and what the plan already includes. A system might display gross open orders, net open orders after cancellations, expected receipts by period, or working-plan inventory that already incorporates some commitments. The field label alone may not reveal the relationship.

Build a reconciliation table:

Do not use placeholder quantities in the live plan; the table structure simply shows which questions must be answered. For each commitment, confirm whether it is still valid, whether it is partially shipped, which finish or pack it covers, and which receipt date governs the buyer’s planning model. A delayed order might move to a different period, but the buyer should retain the source and approval for that change.

Cancellations require particular care. A buyer should not remove an order from the plan merely because someone asked about cancelling it. Verify its actual status, contractual terms, supplier acknowledgment, and internal approval. This guide does not determine whether a purchase order may be cancelled or whether a supplier must accept a change.

When data is unclear, label it unresolved. A provisional calculation can be useful for planning discussion, but should not be represented as approved headroom until the open-order source and inclusion rule are confirmed. Assign an owner and due date to close the discrepancy rather than silently forcing the number to balance.

Translate plan headroom into a supplier conversation

Once the buyer has an approved planning basis, the supplier conversation can be specific. Identify the intended SKU, material, finish, packaging configuration, requested quantity, receipt window, sample status, and any minimum or pack multiple to confirm. Ask for the actual offer on that configuration rather than assuming a product family has one universal MOQ or lead time.

The supplier can confirm whether the described quantity and timing are feasible within the stated project scope. That confirmation does not determine the buyer’s budget or order approval. The importer remains responsible for deciding whether the purchase fits its inventory plan, financial constraints, commercial strategy, and market obligations.

If the supplier’s MOQ exceeds the plan headroom, options may include a smaller qualified run if available, a different timing, a shared or standard configuration if suitable, a revised assortment decision, or no order. Each option must be confirmed rather than presumed. There is no universal Koitor MOQ guarantee in the project facts; MOQ and production feasibility depend on the actual product and project details.

A finish or pack variant can create a separate inventory commitment. Buyers should not count a shared design as one stock item when black, chrome, brushed, or package-specific variants are tracked separately in the plan. Likewise, shared components may not make finished SKUs interchangeable. Use the buyer’s own item master and supplier-confirmed configuration to determine whether quantities can be aggregated.

Account for finish variants, split receipts, and amendments

Hardware plans often use a sellable SKU that combines a base design with a finish, package, or market-specific label. The buyer should confirm how each variant is represented in the planning file. If the system tracks brushed nickel and matte black as separate stock items, a total for the shared product family may hide a shortage in one finish and excess in another. A buyer can review both a family summary and SKU-level headroom, but should not treat the summary as a substitute for the item-level decision.

Split receipts also need a consistent rule. A purchase order for 500 units may be scheduled as two deliveries, but the plan might treat the commitment as 500 units in one period, divide the expected receipts by date, or use a separate open-order field. Confirm the organization’s convention and use it consistently. Do not count the full PO in both periods unless the planning system specifically defines that treatment. If the quantity or date changes, keep the original and revised records linked so the plan owner can see what changed and when.

A PO amendment can affect both the supplier relationship and the planning calculation. A requested increase, decrease, finish substitution, or date change is not final until the authorized parties confirm it. The buyer should update the commitment only after verifying the amendment status and its expected receipt period. Keep any cancellation request, supplier acknowledgement, and internal approval with the purchasing record. This article does not establish contractual cancellation rights or assume that an amendment is accepted because it appears in an internal spreadsheet.

If the buyer holds multiple supplier commitments for equivalent products, do not net them against each other casually. Confirm whether they cover identical SKUs, whether substitutions are authorized, and whether each is a valid open commitment. A backup order that has not been cancelled may still represent exposure in the plan. A forecast or purchase requisition is not the same as a released PO; the planning owner should follow the system’s own states instead of treating every document as an order.

For a new SKU, the initial order can also create future replenishment implications. A small launch purchase might be below the quantity required for efficient packaging or production, while the next reorder may occur before initial stock has been sold through. OTB does not solve that lifecycle decision by itself. Buyers may need a separate launch plan, sales evidence, and supplier feasibility discussion, with MOQ and receipt timing confirmed for each order. Do not treat the first commitment as proof that the product will repeat successfully.

Keep cash and receipt headroom distinct

A receipt plan is not the same as available cash. An order may fit a merchandise plan but require deposit, balance, freight, duties, or other payments at different times. Conversely, money may be available while the buyer’s category plan does not authorize another receipt. The finance team and purchasing authority should evaluate their respective approvals using the organization’s records.

Avoid using a simple OTB calculation to make borrowing, margin, markdown, tax, or accounting decisions. The examples cited here describe merchandise planning concepts and a software-specific view. They do not replace the company’s accounting policy, financial controls, or professional advice. The intended use of this article is to make hardware receipt commitments more transparent before a buyer requests a quotation or raises a purchase approval.

What if headroom is negative or unexpectedly high?

A negative result is a signal to investigate the plan inputs and existing commitments, not an automatic instruction to cancel an order. Check whether a receipt was assigned to the wrong period, an order was entered twice, a cancellation was not reflected, a SKU conversion changed, or the planned ending inventory was revised. Ask the plan owner to explain the cause and document any approved correction.

A surprisingly high result deserves the same discipline. Confirm that all open orders, delayed receipts, finish variants, and planned replenishment are included as intended. Check for a missing SKU, wrong unit conversion, duplicate adjustment, or stale plan version. A large number may be correct, but it is not evidence by itself that additional inventory will sell or produce a profit.

The buyer can classify the result as provisional, validated, or awaiting approval. That is an internal governance choice, not a universal OTB standard. Record the plan owner, data source, exception, and decision before converting a calculation into a purchase commitment.

Common mistakes in open-to-buy inventory planning

• Treating OTB as cash or borrowing capacity.
• Treating available receipt headroom as an approved purchase.
• Subtracting an order that is already included in the system’s net-on-order or receipt field.
• Omitting open orders that the plan has not yet recognized.
• Mixing unit counts, cost value, and retail value without conversion rules.
• Combining unlike hardware SKUs as if each unit were equivalent.
• Moving an expected receipt between periods without recording the basis.
• Rounding a proposed order up to supplier MOQ automatically.
• Assuming one MOQ applies to every product, finish, or packaging version.
• Using sell-through, ABC, or GMROI as a replacement for commitment reconciliation.
• Treating a hypothetical software example as Koitor or customer data.
• Assuming a supplier can cancel, delay, split, or combine production without agreement.

Good planning keeps assumptions visible and responsibilities clear. A result should state the time period, the measurement basis, and how the existing orders were counted. If any of those are unknown, the answer is not yet ready to support a purchase authorization.

After the plan is reviewed, preserve a dated snapshot or approved export with the purchase request. This makes it possible for finance, category management, and the supplier-facing buyer to discuss the same period and commitment set. If the underlying plan changes, state whether the order decision used the old or revised version, and rerun the headroom review through the authorized process.

Checkliste für Käufer

• Freeze the plan version and receipt period.
• Choose a single SKU/unit basis or documented compatible value basis.
• Identify planned ending stock and receipts under the system’s actual definition.
• List each open PO by SKU, quantity/value, status, and expected receipt period.
• Confirm whether each commitment is already reflected in the planning fields.
• Count each commitment once under the plan’s rule.
• Investigate negative or unexpectedly high results before changing records.
• Compare headroom with supplier-confirmed MOQ, pack, finish, and timing constraints.
• Keep cash, finance, and purchase authorization as separate approval steps.
• Record assumptions, source files, unresolved data, and decision owner.
• Do not infer demand, margin, ROI, or cash savings from OTB alone.
• Ask the supplier to confirm feasibility for the actual product and order brief.

Häufig gestellte Fragen

Does open-to-buy show how much cash I can spend?

No. OTB is a merchandise planning concept under a defined model. Cash, payment schedules, finance approval, and purchase authorization are separate.

Should I subtract every open purchase order from the plan?

Only according to the planning model’s definition. First determine whether those orders are already included in a net-on-order or receipt field. Recognize each commitment once, not twice.

Can I use one OTB unit total for towel bars and shower baskets?

Only if the plan defines a valid aggregation basis. Unit counts for different SKUs are not automatically equivalent. A specific SKU plan or documented value basis may be more appropriate.

If OTB is below the supplier MOQ, should I order up to the MOQ?

Not automatically. The buyer should revise the plan, quantity, timing, assortment, or decline the order through its normal approval process. Supplier flexibility must be confirmed for the specific project.

Is the example formula universal?

No. The example reflects one documented software model. Other systems and organizations may define fields differently. Use the current plan documentation and avoid double-counting existing orders.

Does Koitor decide whether a buyer has inventory headroom?

No. Koitor does not control buyer forecasts, inventory, budgets, cash flow, or authorization. It can confirm a defined hardware project’s manufacturing feasibility within its established capabilities.

Sources

• Shopify: Open-to-buy plans — retail buying-plan concept, time period, and reconciliation context.
• Oracle Retail Allocation, Release 19: In-season planning — software-specific OTB fields and historical product-planning example.
• Koitor hardware replenishment questions — distinct SKU priority and variability decision.
• Koitor sell-through versus sales velocity — distinct sales-rate interpretation.
• Koitor GMROI inventory investment guide — distinct gross-margin return diagnostic.
• Koitor contact — project discussion.

Arbeiten Sie mit Koitor Hardware zusammen