Pricing Review by SKU
MRP cost, sales price by pricing tier, and margin by channel · one row per parent SKU
| SKU | MRP Actual Cost | MRP Planned Cost | Current Pricing | Recommended Pricing | Margins (A/P/R) |
|---|---|---|---|---|---|
| Loading data… | |||||
Each row is a parent SKU, averaged across its color/variant children. Current Pricing shows the raw uploaded pricelist tiers (Wholesale/MAP/MSRP) and shows N/A for any tier/SKU combination missing from the pricelist data (edit it on the Manage Pricelist tab; see BUILD_CONTEXT.md) — this report intentionally does not use MRPeasy's own catalog selling price as a stand-in. Recommended Pricing shows the same three tiers as Current Pricing (Wholesale/MAP/MSRP), but solved backwards from a Target Margin set per real sales channel on the Manage Pricelist tab (Retail/Online/Dealer/Commercial, 50% by default for all four until adjusted): Dealer's target solves Wholesale exactly, Commercial's target solves MSRP exactly (each is the only channel reading that tier). Retail and Online both read MAP, so when their two targets don't imply the same MAP price, Recommended MAP is the average of what each would need — as close to both as one shared price allows, not an exact solve for either. Margins are shown per channel (Retail/Online/Dealer/Commercial), each derived from a pricelist tier: Retail = MAP − 20%, Online = MAP, Dealer = Wholesale net of a 10% rep commission and a material surcharge (rate and on/off editable on the Manage Pricelist tab, 10% by default), Commercial = MSRP (placeholder, subject to change) — see BUILD_CONTEXT.md for the exact formulas. The Recommended ("R") margin re-applies that same channel-specific derivation to Recommended Pricing instead of Current Pricing — Dealer and Commercial land exactly on their own target; Retail and Online land close, but not always exactly on theirs, a direct consequence of sharing one Recommended MAP between a discounted and an undiscounted channel (even when both targets are set equal, Retail's 20% markdown means it needs a higher MAP than Online to hit the same realized margin — the average necessarily lands between the two). This test build includes any order line that is booked or further along (Delayed/Expected on time/Ready for shipment/Delivered/Received/Expected — excludes only "Not booked" and "Requested"), not just finished ones. MRP Actual Cost is averaged across this SKU's own real, in-window MOs from mo-history.json and left blank until an order's own MO is Done. MRP Planned Cost is a single figure per SKU, computed straight from that Item's own BOM and Routing template (Materials, Direct Labor, and Overhead, the latter using each workstation's own real hourly rate) — not from any specific MO — see the Methodology tab for the full formula and its known caveats. SKUs marked with * have at least one cost input that could not be fully resolved.
