Production → Allocation → Sales curve → Financial KPIs
1) Production Costs
Mech $/unit
Define formats/variants you’re manufacturing. Totals feed the ROI / KPI math.
Format Variant Mfg Qty Unit Cost Total Cost
Totals
Fixed setup costs (optional) Lacquer Metalwork Plating Other
Tip: use TAB / Shift+TAB to move across cells.
2) Allocation Strategy PPD = wholesale • SRP = D2C
For each product: set SRP/PPD and allocate units into channels. D2C fulfillment sells at SRP; tour sells at PPD.
Product SRP PPD Unallocated Amped Integral UK Integral EU ShipRec (D2C) ShipRec (Tour) Ochre (D2C) Ochre (Tour)
3) Sales Time Series Drives unit sell-through over time
Advanced Assumptions (edit curves)
Uncheck “Use default curves” to edit monthly % per row. Percentages should sum to your Sell-through target.
Copy curve from to
Rounding: floors each month, then puts remainder into Street month.
4) Financial Performance KPI = Gross Revenue / Cost
Monthly revenue (bars) + cumulative KPI (line)
Format Variant Units Sold Revenue Mfg Cost Royalties Contribution KPI