The Process of Merchandise Planning

1. CHAPTER 3 The Process of Merchandise Planning TMH Swapna Pradhan Retail Merchandising

2. Chapter Objectives • The dimensions of merchandise planning • The concept of range planning • The six month merchandise plan • The concept of open to buy TMH Swapna Pradhan Retail Merchandising

3. The Merchandise Planning Process TMH Swapna Pradhan Retail Merchandising

4. Dimensions of Merchandise Planning TMH Swapna Pradhan Retail Merchandising

5. Step 1 The Sales Forecast • The projection of achievable sales revenue, based on historical sales data, analysis of market surveys and trends, and salespersons’ estimates is termed as a sales forecast. Also called sales budget. • A sales forecast may be made by the merchandiser based on the targets given by the top management or may be handed down by the top management itself depending on the retail organisation. TMH Swapna Pradhan Retail Merchandising

6. Sales Forecast Forecasts are typically developed to answer the following questions: • How much of each product will need to be purchased? • Should new products be added to the merchandise assortment? • What price should be charged for the product? TMH Swapna Pradhan Retail Merchandising

7. The process of developing sales forecasts • Review past sales • Analysing the economic conditions and the market opportunities • Analysing the changes in the marketing strategies of the retail organisation and the competition • Creating the sales forecast TMH Swapna Pradhan Retail Merchandising

8. The influences of the Sales Forecast Process TMH Swapna Pradhan Retail Merchandising

9. Step 2 Determining the Merchandise Requirements • The merchandise budget is the first stage in the planning of merchandise. It is a financial plan, which gives an indication of how much to invest in product inventories, stated in monetary terms. TMH Swapna Pradhan Retail Merchandising

10. The Merchandise Budget The merchandise budget usually comprises of : • The sales plan • The stock support plan • The planned reductions • The planned purchase levels • The gross margins TMH Swapna Pradhan Retail Merchandising

11. The Range Plan • Range plans are at the level of the company & the department level. • The aim of the range plan is to create a balanced range for each category of products that the retailer chooses to offer. • The process of range planning ensures that the goals of the merchandise plan fall into specific lines, many a times the SKUs. TMH Swapna Pradhan Retail Merchandising

12. A Good Range Plan Good range planning should essentially take care of the following: • Ensure that sufficient number of items/ options available to the customer, • Ensure that over buying and under buying is limited, and • Ensure that sufficient quantities of the product are available. TMH Swapna Pradhan Retail Merchandising

13. The Six-Month Merchandise Plan • The six-month merchandise plan is a tool that translates the profit objectives into a framework of merchandise planning and then control. • The main objective of creating this plan is to prepare a month-by-month purchasing schedule for the retail organisation. TMH Swapna Pradhan Retail Merchandising

14. Creating Six-Month Merchandise Plan Points to be kept in mind: • The merchandise budget should be prepared in advance of the selling season. • The language of the budget should be easy to understand. • Since the economy is ever changing, the merchandise budget must be planned for a relatively short period of time- six months is the normal norm. • The budget should be flexible enough so that changes are not impossible. TMH Swapna Pradhan Retail Merchandising

15. TMH Swapna Pradhan Retail Merchandising

16. Key Components of the Six-Month Merchandise Plan Planned Sales • Planned Sales are the projected sales for the period that is planned. Planned Purchases • It represent the merchandise that is to be purchased during any given period. • Planned purchases are calculated by using the following formula: Planned Purchases = Planned Sales + Planned Reductions + Planned EOM- Planned BOM TMH Swapna Pradhan Retail Merchandising

17. Key Components of the Six-Month Merchandise Plan Cont… Planned Reductions • Markdowns, employee discounts and inventory shrinkage come under the heading of planned reductions. Planned Markdowns • Markdowns are deductions in prices and may occur because of many reasons ranging from bad quality of merchandise, competitive products, change in trends, etc. Employee Discounts • The discounts given to the employees for buying the company’s products. TMH Swapna Pradhan Retail Merchandising

18. Key Components of the Six-Month Merchandise Plan Cont… Shrinkage • It is the loss of merchandise due to theft or pilferage. Planned Markup • Markups vary depending on the type of the product, the audience that it is targeted and the market trends. • Markup in Rupees= Selling price-Cost price Gross Margin • It is the difference between the selling price and the cost of the product, less reductions for markdowns, shrinkage and employee discounts. • To determine the GM for each month, all purchases and inventories must be converted to cost price. TMH Swapna Pradhan Retail Merchandising

19. B.O.M & E.O.M Planned Inventory Levels • Planning End-of-Month (E.O.M.) or Beginning-of-Month (B.O.M) inventory levels is another important element of the six-month merchandising plan. • Four methods of Inventory Planning are: • Stock-to-Sales Method • Basic Stock Method • Percentage Variation Method • Week’s Supply Method TMH Swapna Pradhan Retail Merchandising

20. Stock-to-Sales Method • The Stock-to-Sales (S/S) is a ratio of the amount of inventory on hand at a particular date to the sales for the same period. S/S ratio= Stock on hand E.O.M. (at retail value) Sales for the same month • A pre-requisite for calculating the Stock-to-sales ratio is for the retailer to have a beginning of the month stock/sales ratio. Stock-sales ratio= Value of inventory/Actual sales Planned BOM Inventory= Stock-sales ratio X Planned sales TMH Swapna Pradhan Retail Merchandising

21. Basic Stock Method • In this method the buyer believes that he needs to carry certain fixed amount of inventory in the store at all times. • It is calculated using the following formula: TMH Swapna Pradhan Retail Merchandising

22. Percentage Variation Method • This method of inventory calculation is used in case the stock turnover typically exceeds six times a year. • It is calculated using the following formula: BOM Stock= Avg. stock for season*1/2* [1+ (Planned sales for the month/Average monthly sales)] TMH Swapna Pradhan Retail Merchandising

23. Week’s Supply Method • Retailers who need to maintain a control on the inventories on a weekly basis may use this method. • It can be calculated by using the following formula: TMH Swapna Pradhan Retail Merchandising

24. Once the buyer and retailer have determined the method of inventory planning, the six-month merchandise plan can be finalised. TMH Swapna Pradhan Retail Merchandising

25. Example: Creating the Six-Month Merchandise Plan TMH Swapna Pradhan Retail Merchandising

26. Example: Creating the Six-Month Merchandise Plan Cont… TMH Swapna Pradhan Retail Merchandising

27. Step 3 Merchandise Control- The Open to Buy The purpose • Depending on the sales for the month and the reductions the merchandise buying can be adjusted. • The planned relation between the stock and sales can be maintained. TMH Swapna Pradhan Retail Merchandising

28. Open to Buy ensures that the buyer • Limits overbuying and under buying • Prevents loss of sales due to unavailability of the required stock. • Maintain purchases within the budgeted limits • Reduce markdowns, which may arise due to excess buying. TMH Swapna Pradhan Retail Merchandising

29. Calculating Open to Buy Open to Buy= Planned EOM Stock- Projected EOM Stock Open to Buy is always calculated for current and future periods. TMH Swapna Pradhan Retail Merchandising