Retail Category Management & Merchandising
Retail Planogram Linear-Foot Margin & Slotting Formula
Calculate Allocated Planogram Linear Shelf Feet, Weekly Gross Margin per Linear Foot (GM/LF), Space-to-Margin Productivity Index, and New-SKU Slotting Allowance Payback Weeks.
Allocate retail facings by Gross Margin per Linear Foot—not raw unit velocity!
Supermarket and mass-retail category buyers ration scarce eye-level gondola space by Linear Shelf Feet LF = (Facings_Count * Pack_Width_in) / 12, not by unit volume alone! A bulky 8-inch economy carton selling 80 units/week at $1.00 margin consumes twice the shelf frontage of a compact 4-inch pouch while generating far less Weekly Gross Margin per Linear Foot GM_per_LF = (Weekly_Units * Unit_Gross_Margin) / LF! Comparing GM_per_LF against Category_Target_GM_per_LF yields the Space-to-Margin Productivity Index = GM_per_LF / Category_Target (where > 1.00 justifies adding facings and < 1.00 flags facing reduction or delisting), while upfront vendor Slotting Allowance amortization tracks Slotting_Fee / (Weekly_Units * Unit_Gross_Margin) weeks of category gross profit!
Verify in a shared category-reset workbook—SKU_Facings = 6 facings (B2), Pack_Width = 4.0 inches (B3 -> Linear Shelf Space = 24 / 12 = 2.00 linear ft in E2), Weekly_Unit_Velocity = 120 units/wk (B4), Retail_Unit_Margin = $2.50 (B5 -> Weekly Gross Margin = $300.00), Category_Target_GM_LF = $125.00/ft/wk (B6), and Upfront_Slotting_Fee = $1,500 (B7): Gross Margin per Linear Foot is $300.00 / 2.00 = $150.00/LF/wk (E3); Space Productivity Index is 150 / 125 = 1.20x (E4); and Margin Equivalence Weeks to match the $1,500 slotting fee is 1,500 / 300 = 5.00 weeks (E5)! When a vendor account manager invited as a suggester proposes expanding to 10 facings without higher velocity, peer reviewers test B2 = 10 first: LF rises to 3.33 ft and GM/LF drops to $90.00 (0.72x < 1.00x hurdle)!
| Planogram Productivity Metric (6 Facings x 4 in, 120 Units @ $2.50, $125 Target, $1,500 Fee) | Formula | Verified Output |
|---|---|---|
| Allocated Linear Shelf Space (LF) | (Facings * Pack_Width_in) / 12 | 2.00 linear ft (3.33 ft @ 10 facings) |
| Gross Margin per Linear Foot | (Weekly_Units * Unit_Margin) / LF | $150.00 / LF / wk ($90.00 @ 10 facings) |
| Space Productivity Index | GM_per_LF / Category_Target_GM_LF | 1.20x (> 1.00x Accretive) |
| Slotting Fee Margin Weeks | Slotting_Fee / (Weekly_Units * Unit_Margin) | 5.00 weeks |
Gross Margin per Linear Shelf Foot (GM/LF) Formula
Validate Facings >= 1, Pack_Width_in > 0, Weekly_Units > 0, Unit_Margin > 0, and Category_Target > 0!
=LET(fc_n, B2, wd_i, B3, vl_w, B4, mg_u, B5, tg_m, B6, sl_f, B7, IF(OR(fc_n < 1, wd_i <= 0, vl_w <= 0, mg_u <= 0, tg_m <= 0, sl_f < 0), "Invalid Planogram Input", LET(lf_s, (fc_n * wd_i) / 12, ROUND((vl_w * mg_u) / lf_s, 2))))Space-to-Margin Productivity Index Formula
Audit over-spaced SKUs where Space Productivity Index falls below 1.00x during quarterly planogram resets!
=IF(ISTEXT(E3), E3, ROUND(E3 / B6, 2))Try the example
Use the original values or change them to test your understanding.