Strategy set, you now need to plan the details.

[dropcap cap=A]s we discussed last month, your merchandising strategy determines your company’s future in terms of assortments, regardless of what you currently have in stock. The merchandise plan articulates your desired outcome by product groups — revenue, gross profit percentage. Once you have created your merchandising strategy, we can begin the next step of creating a merchandise plan.  [/dropcap]


A merchandise plan can be too detailed and therefore too unwieldy to implement. Conversely, if it is too top-level, it won’t direct your day-to-day inventory management and buying. I find it to be most effective to evaluate and plan your inventory by product groups such as designer collections, other collections or programs, and not by the merchandise hierarchy in your computer system. Many hierarchies seem to be based on materials or components (diamond, color, metal, etc.), which is too granular for a merchandise plan.

Depending on your inventory software you may need to code your SKUs with the product group name so you can easily extract the data needed for the plan, and to monitor your progress each month.

Your product groups should be based on style, look and feel, and should easily relate to your merchandising strategy goals. If one of your goals is “Expand bridal by 30 percent by creating three in-store branded collections by March, targeted to entry-level price points of $1,000,” you would add the three collections into the plan with no historical data, only projected.

The plan can easily be created in Excel as a worksheet. At the top you have your targets for 2011: sales revenue at cost, current inventory at cost, projected inventory at cost, margin percent and margin dollars. All your cells should balance to your objectives and adjust as you are working on your plan.

Your plan should have the following data by your designated product groups:


[li] Sales for 2010 at cost[/li]
[li] Percentage variance (increase/decrease) over 2009[/li]
[li] Projected sales for 2011[/li]
[li] Current inventory at cost[/li]
[li] Projected inventory at cost[/li]
[li] Variance in dollars and percent[/li]
[li] Gross margin percent and dollars for 2010[/li]
[li] Gross margin dollars variance over 2009[/li]
[li] Projected gross margin and dollars for 2011[/li]

The part that requires the most thought is your projections. This is not a rote numerical formula; rather you are creating your road map for your replenishment, new purchasing and aged inventory.

While working on your plan you should have your merchandising strategy available. You will decide if you want to add new product groups, discontinue others, grow sales, decrease sales, adjust margins or margin dollars, and which inventory levels need to be tweaked.

When the plan is completed and you have balanced your objectives, you can now break it down by month, so you can see your progress. Every purchasing or inventory management decision should be viewed through the lens of your plan. I think you will find it very rewarding as you see your progress toward having the type of offerings and assortments that your customers desire.

[smalltext]Sally Furrer is a merchandising consultant with 20-plus years of jewelry industry experience. E-mail her at This email address is being protected from spambots. You need JavaScript enabled to view it., or visit[/smalltext]

[span class=note]This story is from the March 2011 edition of INSTORE[/span]


Your text...