Merchandise Financial Plan (MFP) Template

What this template is for

The Merchandise Financial Plan (MFP) Template provides a structured framework for apparel brands to set annual and seasonal financial targets — planned sales, gross margin percentage, inventory investment, and receipt budgets — before the seasonal planning process begins.

The MFP is the financial umbrella that all downstream planning decisions — OTB, assortment, buy — are measured against. Without it, brands plan in financial isolation: OTB is set without a sales target, assortment is built without a margin goal, and the buy is reconciled only after the fact.

Best for: Apparel brands with $5M–$50M in annual revenue planning two full seasons (SS + FW) across 2–5 departments. This template does not replace a connected planning system but provides the financial scaffolding that makes OTB and assortment templates meaningful.

---

Template structure

Tab 1: Annual Financial Plan

| Column | What to enter | |---|---| | Department | Category (e.g., Tops, Bottoms, Outerwear, Accessories) | | Planned net sales | Annual net sales target by department | | Sales % to total | Auto-calculated: dept sales ÷ total sales | | Planned gross margin % | Target GM% for the year | | Planned gross margin $ | Auto-calculated: planned net sales × planned GM% | | Planned inventory (cost) | Average inventory on hand at cost | | Inventory turns | Auto-calculated: planned net sales ÷ average inventory at retail | | Planned receipts (cost) | Total planned receipts for the year at cost | | GMROI | Gross margin ÷ average inventory cost |

Tab 2: Seasonal Plan (SS and FW)

| Column | What to enter | |---|---| | Season | SS (Feb–Jul) or FW (Aug–Jan) | | Department | Category | | Planned net sales | Season-level sales target | | Season % of annual | Season's share of annual sales | | Planned IMU % | Target initial markup at start of season | | Planned markdown % | Planned markdowns as % of sales | | Planned gross margin % | Net margin after markdowns: IMU% − markdown% | | BOS inventory (cost) | Beginning-of-season inventory at cost | | EOS inventory (cost) | Target end-of-season inventory at cost | | Planned receipts (cost) | OTB formula: EOS + Sales + Markdowns − BOS | | Planned turns | Season-level inventory turns |

Tab 3: Monthly Cadence

| Column | What to enter | |---|---| | Month | Feb through Jan (full year) | | Season | SS or FW | | Planned net sales | Monthly sales target | | Sales % to season | This month's share of season sales | | Planned markdowns | Markdown dollars in this month | | Planned receipts (cost) | Monthly receipt budget | | BOM inventory | Beginning-of-month inventory at cost | | EOM inventory | Target end-of-month inventory at cost | | Sell-through (actual) | In-season: actual STR for the month | | Receipt variance | Actual receipts vs. plan |

Tab 4: Margin Bridge

| Column | What to enter | |---|---| | Category | Department | | Planned IMU % | Target IMU at start of season | | Markdown % of sales | Planned markdown rate | | Alteration / shrink % | Other cost adjustments | | Planned MMU % | Maintained margin after all deductions | | Actual IMU % | Realized IMU (in-season or prior season) | | Actual markdown % | Realized markdown rate | | Actual MMU % | Realized maintained margin | | Gap | Actual MMU − planned MMU |

---

How to use this template

Step 1: Start with your annual sales target in Tab 1. Work top-down: total company target first, then allocate by department based on prior-year mix and strategic shifts (e.g., growing a new category).

Step 2: Set planned gross margin % by department. Use prior-season actuals as the baseline, then adjust for planned pricing changes, mix shifts, or vendor renegotiations.

Step 3: Calculate average inventory investment from GMROI targets. If you target a 2.5 GMROI and your annual GM$ is $2.5M, your planned average inventory at cost is $1M.

Step 4: Split the annual plan into SS and FW in Tab 2. Most apparel brands run 55–60% of annual sales in FW due to heavier AURs and holiday. Adjust based on your historical split.

Step 5: Build the monthly cadence in Tab 3. Map planned sales by month to the selling calendar — higher in peak months (November/December for FW, March/April for SS), lower in inter-season transition months.

Step 6: Transfer the seasonal receipt budget to your OTB template. The MFP receipt target by department and season becomes the top-level constraint in the OTB calculation.

Step 7: After each season, complete Tab 4 — the margin bridge. The gap between planned and actual MMU tells you where the plan broke down: at initial pricing (IMU gap) or at in-season execution (markdown gap).

---

Key planning relationships

MFP → OTB: The MFP sets the season's total receipt budget. The OTB template allocates that budget across periods and tracks commitments against it.

MFP → Assortment: The MFP's planned IMU % by department sets the margin floor for assortment decisions. Styles with IMU% below the planned department average drag down the season's financial plan.

MFP → Buy: Style-level buy quantities must aggregate to a total cost that fits within the MFP's planned receipt budget. The buy plan is the bottom-up reconciliation of the MFP's top-down target.

---

Template limitations

This template establishes the financial framework for seasonal planning but does not:

• →Auto-populate OTB or assortment plans from the financial targets
• →Reconcile actuals against plan in real time as the season progresses
• →Surface which style decisions are driving the margin gap
• →Connect receipt timing to vendor delivery schedules

The MFP template is a planning starting point. When the financial plan needs to stay connected to assortment, buy, and receipt decisions throughout the season — not just be reconciled after the fact — a connected planning platform replaces the template stack.