MM allocation and cost-plus ratios
Select a method. Product mix and COGs % follow Jan–Sep 2026 actuals.
MM by BU
BU cost-plus ratios
MFG and MGM as % of COGs DM. Total includes net margin.
Product detail
Each BU's 2027 GMV is spread over in-house / trading and product in the Jan–Sep 2026 mix. COGs DM keeps each line's Jan–Sep 2026 % of GMV.
Control checks
All four methods are checked on every change.
Methodology
- A.1 / A.2: SH takes the fixed MM, split MFG / MGM in the pool ratio. The rest of the pool goes to DMD, DMI and KK by 2027 GMV share.
- B.1 / B.2: all four BUs share MFG and MGM by 2027 GMV share.
- .1 uses the standard MGM pool, .2 the optimized MGM pool. The MFG pool is the same for both.
- MFG goes to each line by GMV within the BU.
- MGM is split in-house / trading by GMV. In-house = BU MGM × (IH% + absorbed × TR%); trading = BU MGM × (1 − absorbed) × TR%. Each is then spread to products by GMV.
- Line % = cost ÷ COGs DM. Total add-on = MFG % + MGM % + net margin.
CP comparison vs 2026
Summary — total add-on
MFG + MGM + net margin, by BU, in-house / trading and category. 2026 costing has no category split for trading, DMI, KK or SH, so its group % repeats in each category. n/a = no GMV in that category.
Difference
Positive = more added on top of COGs than the comparison; negative (red) = less. Shading shows size.
Ratio breakdown by method
MFG, MGM and net margin, and the change from the 2026 ratios.
Absolute amounts — MFG and MGM by BU
2026 = MM loaded in the 91M costing basis. 2027 = BU allocation of each method.
Difference in absolute amounts
How to read
- A.1 / A.2 / B.1 / B.2 follow the assumptions panel: .1 = standard MM, .2 = optimized MM.
- Every BU is shown by in-house / trading and category (FGMT, FGBD, Bed base/Box wood). 2026 has a category split only for DMD in-house; elsewhere its group % repeats. n/a = no GMV in that category.
- 2026 differences: SH not in use; KK trading MFG only; KK in-house margin 10%; DMD bedding margin removed. 2027: DMD in-house net margin 0%.
Top products — CP price 26 vs 27
Jan–Sep 2026 sales of costed lines, ranked by GMV within the BU and grouped Mattress → Bed Base / Box Wood → Bedding. FY27 volumes scale with the 2027 GMV in the assumptions panel; the FY27 CP price uses the cost-plus rate of each method you pick, side by side.
Selection by source and category
Products
Columns
How to read
- Source data: sheet “CP Price Simulation 26vs27”, costed lines only (In costing? = Yes), summed by BU + Item Code, the same keys the “Top Products 26vs27” sheet uses.
- Sales mix % = the item's Jan–Sep 2026 GMV as a share of the BU's total costed GMV, so it doesn't change with the source or category filter.
- Default list length follows the sheet: DMD top 100, KK top 50, DMI top 25, SH top 50. Searching looks through every item in the selection.
- CP price now = CP cost now ÷ Qty 26, the weighted average actually charged in Jan–Sep 2026.
- FY27 CP price = DM cost per unit × (1 + MFG % + MGM % + net margin) for the item's BU, source and category under each selected method, taken live from the Calculator. Select several methods to compare them side by side. Unit cost is held, so it is the same per-unit price for Jan–Sep 2026 and FY27.
- vs now = FY27 CP price ÷ CP price now − 1. Positive = the price has to rise.
- FY27 Qty, GMV and DM = Jan–Sep 2026 × BU factor, where the factor = 2027 GMV for the BU (assumptions panel) ÷ the BU's Jan–Sep 2026 costed GMV. FY27 CP cost = FY27 DM × (1 + total %).