Margin Master Handbook
- Prerequisites
- Firewall and Network Requirements
- Microsoft Edge Download Block
- SQL Server Authentication Setup for IT Administrators
- Antivirus and Endpoint Security Exclusions
- SQL Server Tools
- Install or Upgrade SQL Server Express
- Install or Upgrade SQL Server Management Studio
- A Tour of the Main Window
- The Menus
- The Button Row
- The Main Data Grid
- The Summary Section
- Banners and Badges
- The Options Window
- Store Configuration
- Miscellaneous
- Export Options
- Vendor Settings
- POS / Connections Tabs
- Background Service
- AI Assistant (Experimental)
- How POS Import Works
- Supported Point-of-Sale Systems
- Data Import Workflows
- RockSolid POS Import
- Epicor Eagle FTP Import
- Epicor MySQL Compass Import
- Transact POS Import
- Paladin POS Import
- Falcon POS Import
- Spruce POS Import
- Bistrack POS Import
- RockSolid Max POS Import
- ECS POS Import
- Prosperity POS Import
- Catalyst POS Import
- Westlake POS Import
- MI9 POS Import
- AS/400 POS Import
- CounterWorks POS Import
- Dimension POS Import
- PacSoft POS Import
- ProStix POS Import
- Sympac POS Import
- Propello POS Import
- EagleVision POS Import
- MySQL/Compass Connection Configuration
- ECI VPN Requirement (Spruce, RockSolid MAX)
- Propello POS Integration Guide
- MI9 Data Pipeline — Import to Main Table
- Troubleshooting: Epicor Import Brought In 0 SKUs
- PACE POS Import
- Advantage POS Import
- General Store POS Import
- J-3 POS Import
- KeyStroke POS Import
- AutBusSystem POS Import
- Tomax POS Import
- Enterprise POS Import
- Computakey POS Import
- Redisell POS Import
- DART POS Import
- MIB POS Import
- Substruct POS Import
- DMAS POS Import
- RODS POS Import
- Procom POS Import
- Agility POS Import
- Acumen POS Import
- Cruise POS Import
- LSandE POS Import
- Retalix POS Import
- DIBCorp POS Import
- GMROI POS Import
- ECi Advantage POS Import
- Sunray POS Import
- ActivantAutomotive POS Import
- IBS POS Import
- Versys POS Import
- RMS POS Import
- TAMS POS Import
- Integrasoft POS Import
- Dynamic POS Import
- Microsoft ARS POS Import
- CDS POS Import
- Spartan POS Import
- Nitterhouse POS Import
- Jeds POS Import
- Theisens POS Import
- Emery Jensen POS Import
- SMS Pro POS Import
- Burdens POS Import
- Intact POS Import
- Bloom Retail POS Import
- NCR Counterpoint POS Import
- Horizon POS Import
- Cloud Vendor Data Sync
- Data Aging and Freshness Warnings
- Resetting Vendor and POS Data
- Rebuild Data and Rebuild Selection Lists
- Troubleshooting Vendor Sync
- Understanding the Strategy Hierarchy
- Pricing Strategies
- Creating a Strategy Step
- Updating and Deleting Steps
- Reviewing a Strategy and Running It
- Shared (Premade) Strategies
- SKU-Level Exceptions
- Manage Custom Groups
- Strategy Execution Cloud Tracking
- Importing from Excel
- Cost Break Analysis
- Cost Break Strategies
- Min/Max Strategies
- Strategy Backup & Restore
- Add Items from Catalog
- Store Grouping
- Data Diagnostics and Missing Index Recommendations
- System Diagnostics
- Margin Master Cannot Save Settings
- SQL Server 2025 Express vs. Full License
- Support Issue Management
- Catalog Lookup
- What's New After an Update
- Version History
- Documentation and the Help Buttons
- CTLD — Do It Best Catalog File
- MARGIN_MASTER — Ace Catalog File
- PCDITEMXREF — Do It Best SKU Classification File
- SAP_ZONE_PRICE_MARGIN_MASTER — Ace Zone Pricing File
- PCDPRODCLASS — Do It Best Product Classification Hierarchy File
- SAP_STORE_DEPT_ZONE_MARGIN_MASTER — Ace Store Zone Assignment File
- Taxonomy — Ace Product Classification File
- Mapp_Pricing — Ace MAP & IMAP Pricing File
- margin_mstr_plano — Ace Planogram File
On This Page
Cost Break Strategies
What is this?
A cost break model prices items by what they cost: cheap items carry a high margin, expensive items a lower one, in bands you define - the classic sliding scale of independent retail. Building the model is Cost Break Analysis; this page is about using a model inside a pricing strategy, where it becomes a step like any other.
How a cost break prices an item
The model is a table of cost ranges (From / To), each with either a Target Margin or a Fixed Price. When a step uses the model, every selected item's cost is looked up in the table and its future price is set to reach that band's margin (or the fixed price). Rounding is applied afterwards like any other step.
| Cost from | Cost to | Target margin |
|---|---|---|
| $0.00 | $1.00 | 60% |
| $1.01 | $5.00 | 50% |
| $5.01 | $25.00 | 42% |
| $25.01 | up | 35% |
Building the model - Manage Cost Breaks (Ctrl+B)
Strategy > Manage Cost Breaks opens Manage Cost Breaks. Choose a Cost Break Model or create one from the hamburger menu (Import Cost Break Models, Rename Current Cost Break Model, Export ... to Excel).
Model Options decide the bands: Model Manual with your own number of Break Points (2-15), or Simple-10 / Simple-13 for ready-made ten- and thirteen-band scales. Rebuild recalculates the bands; Auto Rebuild on Model/Break Count Change? does it as you change them, and Update Sku Data after From/To Range Change? refreshes the counts as you edit ranges.
The grid shows each level's From, To, Zero Sale Skus, Active Skus and Calculated Margin (the margin the band currently sits at), then the decision: Fixed Price with Fixed $, or Target Margin. Right-click a row to insert a level before or after it, or delete it. Save keeps the model; Reset discards edits; Delete removes the model.
The Calculated Margin and SKU counts are what make the model a strategy tool rather than a spreadsheet: you see, per band, how many items sit there and what margin they earn today before you decide the target.
Using the model in a step
- On the main window, select the SKUs the model should price (a department, a vendor, everything).
- On the Future Price panel choose Set Future Price to: Cost Break: ???; a Select Cost Break list appears - pick the model. The entry then reads Cost Break: name. The pencil beside it opens Manage Cost Breaks on that model.
- Set the rounding scheme and any Plus or Minus as usual, Apply to preview, then save the step with the camera - see Creating a Strategy Step.
A typical strategy uses one cost-break step as the broad first step (everything priced by cost band) and specific steps below it for sensitive lines, vendor levels and exceptions - see the hierarchy.
Tips
Start from Simple-10, run the strategy, read the Summary, then move to Manual only where a band needs a different edge.
Keep target margins descending as cost rises. A band with a higher margin than the one below it produces price jumps customers notice.
Common Questions
Q: An item was not priced by the cost-break step. A: Its cost falls outside every band (often $0.00 cost). Add a band that starts at $0.00, or price zero-cost items with a separate step.
Q: Can two strategies share a model? A: Yes. Models are stored in the database and any step in any strategy can select them.
Q: Fixed Price or Target Margin? A: Fixed Price for a band where you want one price point regardless of cost (impulse items at $0.99); Target Margin everywhere else.
