SoPoly Pricing Review v. 2.8
Window Trailing 60 Days
Loading…

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 columns — Wholesale/MAP/MSRP by default, but fully renameable/addable/removable on the Manage Pricelist tab as of 2026-07-27 — and shows N/A for any column/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 columns as Current Pricing, 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) into whichever column that channel's own "Margin source" (also on the Manage Pricelist tab) currently points at — by default Dealer → Wholesale and Commercial → MSRP, each the only channel reading that column, so each solves exactly; Retail and Online both default to MAP and now read it identically (unadjusted), so when their two Target Margins differ, the shared column's Recommended value is the average of what each would need — as close to both as one shared price allows, not an exact solve for either (reassigning a channel to its own column via Margin source makes it solve exactly too). Margins are shown per channel (Retail/Online/Dealer/Commercial), each derived from that channel's current Margin-source column: Retail = column as-is, Online = column as-is, Dealer = column net of a rep commission (rate editable, 10% by default) and a material surcharge (rate and on/off editable, 10% by default), Commercial = column as-is (MSRP by default, a placeholder, subject to change) — see BUILD_CONTEXT.md for the exact formulas. Retail no longer has a flat markdown of its own (removed 2026-07-27). The Recommended ("R") margin re-applies that same channel-specific derivation to Recommended Pricing instead of Current Pricing — a channel that's the only one reading its column lands exactly on its own target; one sharing a column with another lands close, but not always exactly on theirs, when their Target Margins disagree (a direct consequence of sharing one Recommended price between two differently-targeted channels). 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.