Open To Buy( OTB) retail rajnish kumar itc category management

50 %
50 %
Information about Open To Buy( OTB) retail rajnish kumar itc category management

Published on February 14, 2009

Author: rajnishkumar71

Source: slideshare.net

Open To Buy( OTB) Rajnish Kumar

Why OTB ? It has a Financial and a merchandising purpose Helps in optimizing working capital requirement Gives the customer what she wants not what you have in stock Takes cognizance of business environment Dynamic system that adjusts as per the sales and stock position Enhances profits by lowering Markdowns

It has a Financial and a merchandising purpose

Helps in optimizing working capital requirement

Gives the customer what she wants not what you have in stock

Takes cognizance of business environment

Dynamic system that adjusts as per the sales and stock position

Enhances profits by lowering Markdowns

Key Elements Sales Forecast – An estimation of sales during the Fianancial period broken by weeks,months,Qtrs etc taking view of the sales history and seasonality.The numbers would roll up to the Gross sales given in the Financial Budget Stock Cover – Usually spoken about in terms of sales periods such as 3 months stock and is decided on the basis of the product category, Footfalls etc.Sometimes also called as Inventory cover. Required Stock –Refers to stock holding or the stock required to optimize Sales.It is the addition of Sales forecasts of the following periods based on what is the cover. Opening stock – The stock held by the system at the beginning of the calculation period. Closing stock – The stock held by the system at the end of previous period.It could be the stock at the end of a certain financial period. Intake – Simply the difference between the Required stock and the opening stock On Order – Receipts due in the given period Open to Receive – Difference between Intake required and what is already on order.

Sales Forecast – An estimation of sales during the Fianancial period broken by weeks,months,Qtrs etc taking view of the sales history and seasonality.The numbers would roll up to the Gross sales given in the Financial Budget

Stock Cover – Usually spoken about in terms of sales periods such as 3 months stock and is decided on the basis of the product category, Footfalls etc.Sometimes also called as Inventory cover.

Required Stock –Refers to stock holding or the stock required to optimize Sales.It is the addition of Sales forecasts of the following periods based on what is the cover.

Opening stock – The stock held by the system at the beginning of the calculation period.

Closing stock – The stock held by the system at the end of previous period.It could be the stock at the end of a certain financial period.

Intake – Simply the difference between the Required stock and the opening stock

On Order – Receipts due in the given period

Open to Receive – Difference between Intake required and what is already on order.

An example Note – Intake matches with the sales during the period i.e. purchases match the sales 300 300 300 350 450 500 Closing Stock 100 100 100 100 0 200 Open To Receive 100 200 On Order 100 100 100 100 100 400 Intake 300 300 350 450 500 200 Opening Stock 300 300 300 350 450 500 Required Stock 3 3 3 3 3 3 Periods cover 100 100 150 200 150 100 Sales Forecast Period 6 Period 5 Period 4 Period 3 Period 2 Period 1 Term OTB Calculations

Flat or forward cover - Which is Better? In an ideal world we would order merchandise exactly when the previous stock is sold out. In reality it is impossible to forecast demand so accurately, and if we allow stocks to fall to near zero at, for example, a product group level, we have stock outs and lost "eye appeal". Lead times and re-order cycles therefore become significant to the success of the merchandising process Your reorder cycle will be determined by the lead time for supply of products. In essence these will be equal but could differ based on logistics issues such as processing time at the DC, In Transit time etc. Which essentially means that if you could get supplies on a weekly basis you would like to order at the same frequency thus minimizing inventory and not losing any sales. A flat cover would work better for products for which the demand is stable and homogenous such as grocery and FMCG products A Forward cover would be more suited for products which exhibit strong seasonality such as Fashion Apparel, Footwear etc. Demand increases with onset of season, Festivals ,Events etc. Failure to take a view of these fluctuations in demand may lead inefficient inventory position.

In an ideal world we would order merchandise exactly when the previous stock is sold out. In reality it is impossible to forecast demand so accurately, and if we allow stocks to fall to near zero at, for example, a product group level, we have stock outs and lost "eye appeal".

Lead times and re-order cycles therefore become significant to the success of the merchandising process

Your reorder cycle will be determined by the lead time for supply of products. In essence these will be equal but could differ based on logistics issues such as processing time at the DC, In Transit time etc. Which essentially means that if you could get supplies on a weekly basis you would like to order at the same frequency thus minimizing inventory and not losing any sales.

A flat cover would work better for products for which the demand is stable and homogenous such as grocery and FMCG products

A Forward cover would be more suited for products which exhibit strong seasonality such as Fashion Apparel, Footwear etc. Demand increases with onset of season, Festivals ,Events etc. Failure to take a view of these fluctuations in demand may lead inefficient inventory position.

OTB in Units, Sales Value COGS ? To each his own is the mantra … Creating a unit based open to buy means that the output can be related to logistical constraints such as warehouse and store capacity For financial control it appears more appropriate to use values. As sales are made at retail the most common approach is to create a retail value based sales forecast and generate a retail value of open to receive plus stock in hand. Caution !! It is important to calculate OTB in the same measure when we look at the Sales and Stock numbers. It will be inappropriate to have sales forecast at Retail and evaluate stock and open orders at Cost.

To each his own is the mantra …

Creating a unit based open to buy means that the output can be related to logistical constraints such as warehouse and store capacity

For financial control it appears more appropriate to use values.

As sales are made at retail the most common approach is to create a retail value based sales forecast and generate a retail value of open to receive plus stock in hand.

Caution !!

It is important to calculate OTB in the same measure when we look at the Sales and Stock numbers. It will be inappropriate to have sales forecast at Retail and evaluate stock and open orders at Cost.

In Season Stock Management Lower than plan Sales Delivery Failures Increase in Budget Sell Thru % Store Comps Sub Cat level Sale mapping Action Plan Reforecast based On measurement of actual Sales and Stock position Review and update OTB at Sub Cat Level Intake based on Sales and Stock Budget

What to do ? Sales Higher than Plan Rush Existing orders and place more orders for the same product If same product is not available look for similar products that can replace them Consider Inter store Transfers if the sales are uneven and move stocks from stores with higher stock to those where the stock has fallen below optimum level Plan for higher qty’s ,more suppliers. Evaluate capacities and Supply chain Sales Lower than Plan Cancel/renegotiate/defer existing orders Inter store Transfers from low sales stores to higher sale stores Drop Brands, Suppliers, Product lines if the overall performance is not satisfactory Investigate Product, Price and Quality Appropriateness, Design etc. and register learning

Sales Higher than Plan

Rush Existing orders and place more orders for the same product

If same product is not available look for similar products that can replace them

Consider Inter store Transfers if the sales are uneven and move stocks from stores with higher stock to those where the stock has fallen below optimum level

Plan for higher qty’s ,more suppliers. Evaluate capacities and Supply chain

Sales Lower than Plan

Cancel/renegotiate/defer existing orders

Inter store Transfers from low sales stores to higher sale stores

Drop Brands, Suppliers, Product lines if the overall performance is not satisfactory

Investigate

Product, Price and Quality

Appropriateness, Design etc. and register learning

Add a comment

Related presentations

Related pages

Category Management | LinkedIn

View 165205 Category Management posts, presentations, ... creative assets, etc.)? 25 years of Category Management: The retail industry has been ...
Read more

Otb | LinkedIn

... The open to buy (OTB) ... Open To Buy( OTB) retail rajnish kumar itc category management. 7,520 Views. otb. Tutorial OTB/Monteverdi Part 1. 7,776 Views.
Read more

Open-To-Buy Planning: Controlling Your Inventory

... right products at the right time by using an Open-To-Buy (OTB) plan ... $50,750 Open-To-Buy at retail. ... and Management; Open-To-Buy ...
Read more

OTB Check - Open-To-Buy (OTB) - SAP Library

With the complete OTB check, you can use OTB allocation. When creating a purchase order, it should be noted that you cannot enter an order date in the ...
Read more

Retailing: What is an Open-to-Buy? - Business Know-How

In the world of retail, Open-To-Buy is quite a ... and control function at a department or category ... management to track the progress as ...
Read more