So you have a floor planning system but you still can’t measure your space productivity? Suddenly, you are hearing more than you care about promotional locations, seasonal department areas and non-planogrammable products like apparel, produce and footwear?  Why isn’t it working?  You were supposed to be able to know the Gross Margin Return on Space down to the business line level. At least, that is what the software sales rep and your IT business case said.

    Here is how to integrate macro space management with assortments and promotional planning to get real space metrics.

    First, let’s assume that you have “micro space” planogramming software that links SKUs to Fixtures to Floor placement. (Even if it is at a prototype level.)  Therefore, for those areas, yo know the GMROS of your entire hierarchy.

    Here is the connection path for “bottoms up” Macro Space:

    SKU’s → ASSORTMENTS → FIXTURES (At this point, you have a PLANOGRAM) → FLOOR SPACE

    All of these relationships have a MANY to MANY relationship.

    For planograms (dog food, cereal, toys, headphones) the system assumes that the planogram exists 52 weeks a year on the missing TIME dimension.  The assortments may change more frequently. But in calculations, the planogram “always exists.”

    To be able to create Macro Space metrics that accurately reflect PROMOTIONAL locations, you need to add the TIME dimension to the FIXTURE.

    The FIXTURE exists 52 weeks a year. But the PLANOGRAM that is attached to it changes as frequently as once per week.  This will work for locations such as endcaps, check lanes, racetrack locations, dump bin locations, departmental H-Fixtures, etc.  The performance and the space allocation for the promotional location can be allocated back to the business line weekly and aggregated along with the standard in-line planogrammed space to reflect accurate space productivity.

    For Apparel, Produce and other Departmental areas where the department  and fixtures exist all year, but the assortments change, the TIME dimension needs to be added to the ASSORTMENTS.  First, you can know the fixture holding capacity.  Then, you can know the inventory allocation, sales rate and replenishment of that Assortment by store.  You can know the Assortment start and end date.  Therefore, you can know the Space Productivity of that assortment for its time period and allocate that back to the business lines accordingly.

    Finally, there are Seasonal Departments (Holiday, summer, Back to School, etc) that change their merchandise over time.  They typically have planograms or directed merchandising in the case of large items like grills, Christmas trees and lawn mowers. But they might be treated like the Apparel example above.

    It isn’t that hard to explain or understand.  And we have made this work.  In a real live retailer.  It can be done.  Want to find out more?

    As Yogi Berra said:

    ‘In theory, there is no difference between theory and practice.  In practice, there is.’