: Anticipated discounts or promotions that will reduce the retail value of your inventory.

: Inventory that has been purchased but not yet received. 3 Reasons to Use an OTB Spreadsheet

Alternatively, some retailers include stock in the deduction to find the exact remaining budget:

: Forecasted revenue based on historical data and current trends.

: The retail value of stock on hand at the start of the period.

OTB=Projected Sales+Planned Ending Inventory−Beginning Inventory−Already on OrderOTB equals Projected Sales plus Planned Ending Inventory minus Beginning Inventory minus Already on Order Key Components of an OTB Excel Template

Open To Buy Excel Spreadsheet Apr 2026

: Anticipated discounts or promotions that will reduce the retail value of your inventory.

: Inventory that has been purchased but not yet received. 3 Reasons to Use an OTB Spreadsheet

Alternatively, some retailers include stock in the deduction to find the exact remaining budget:

: Forecasted revenue based on historical data and current trends.

: The retail value of stock on hand at the start of the period.

OTB=Projected Sales+Planned Ending Inventory−Beginning Inventory−Already on OrderOTB equals Projected Sales plus Planned Ending Inventory minus Beginning Inventory minus Already on Order Key Components of an OTB Excel Template

Spectec 40 years logo

Request your no-obligation, personalised demo of AMOS-X today: 

Find out how you can bring your fleet asset management into one seamless platform 

Take the next step towards saving time, reducing risk, and powering insights. 

Want to speak to an AMOS-X expert? and we’ll get right back to you 

Your information will only be used to further your enquiry and is protected by our privacy policy.

Spectec 40 years logo

Book a no-obligation consultation with one of our SFI experts to find out how we can help you: 

  • Standardise data across your business
  • Improve compliance and audit readiness
  • Streamline maintenance and procurement
  • Take the next step towards making sure your data works for you

Prefer to call us? Speak to an expert on

Your information will only be used to further your enquiry and is protected by our privacy policy.

Spectec 40 years logo

Take the next step toward transforming your fleet’s operational performance with our 30-minute, no obligation demo.

Prefer to call us? Speak to an expert on

Your information will only be used to further your enquiry and is protected by our privacy policy.