|
<< Click to Display Table of Contents >> Navigation: MLS 2026 Operations & Reference Guide > Inventory > Inventory Price Management |
Maintaining accurate inventory pricing is critical for:
•profitability
•consistency
•inventory valuation
•customer confidence
•long-term business stability
MLS 2026 includes a comprehensive:
👉 Inventory Price Management system
that allows pricing to be adjusted:
•individually
•globally
•by vendor
•by manufacturer
•by cost range
•by pricing tables
throughout inventory.
The system is designed to help businesses:
•maintain proper margins
•respond to supplier cost changes
•standardize pricing
•automate markup structures
•simplify wholesale pricing
while reducing:
•manual calculations
•pricing inconsistencies
•operator error
throughout operations.
Prices may be adjusted:
👉 manually
through:
•the Inventory Editor
or:
👉 automatically
using:
•pricing utilities
•markup tables
•percentage adjustments
•vendor-based updates
•manufacturer-based updates
throughout MLS 2026.
The:
👉 Fixed Percentage
utility increases:
👉 retail pricing
for:
👉 ALL inventory parts.
The system uses the formula:
Retail=Current×(1+Increase%)Retail = Current \times (1 + Increase\%)Retail=Current×(1+Increase%)
Example:
10×(1+0.10)=11.0010 \times (1 + 0.10) = 11.0010×(1+0.10)=11.00
A part with a current retail price of:
•$10.00
increased by:
•10%
results in:
•$11.00 retail pricing.
This method is especially helpful when:
•suppliers issue broad price increases
•inflation affects inventory costs
•labor overhead increases
•general retail adjustments are needed
throughout inventory.
Because:
👉 all parts are adjusted
this method should be used carefully and reviewed before processing.
MLS 2026 also allows:
👉 vendor-specific price increases.
This utility applies:
•percentage adjustments
only to parts associated with:
👉 a selected vendor.
The system checks:
•Vendor 1
•Vendor 2
•Vendor 3
•Vendor 4
within inventory records.
This is extremely valuable when:
•only one supplier changes pricing
•manufacturer programs change
•specific vendor costs increase
without affecting all inventory.
Pricing adjustments may also be applied:
👉 by manufacturer.
MLS 2026 compares:
👉 the exact manufacturer name
within inventory records.
⚠️ Because this requires:
👉 exact text matching
manufacturer names must be entered consistently.
This is one of the major reasons:
👉 lookup lists
should always be used for manufacturer entry whenever possible.
One of the most powerful pricing tools in MLS 2026 is:
👉 Cost Range Pricing.
Rather than increasing existing retail prices:
👉 the system recalculates pricing
based on:
👉 inventory cost.
The formula used is:
Retail=Cost×(1+Increase%)Retail = Cost \times (1 + Increase\%)Retail=Cost×(1+Increase%)
Example:
10×(1+1.00)=20.0010 \times (1 + 1.00) = 20.0010×(1+1.00)=20.00
A $10 part with:
•100% markup
becomes:
•$20 retail.
Not all parts should use:
👉 the same markup percentage.
Low-cost items often require:
👉 higher markup percentages
because:
•handling costs are proportionally larger
•inventory management still requires labor
•packaging and storage remain constant
while high-cost items often require:
👉 lower markup percentages
to remain:
•competitive
•marketable
•practical for customers.
Typical markup structures may resemble:
Cost Range |
Suggested Markup |
Under $0.25 |
500% |
$0.25 – $0.99 |
200% |
$1.00 – $4.99 |
100% |
$5.00 – $19.99 |
90% |
$20.00 – $49.99 |
80% |
$50.00 – $99.99 |
70% |
$100.00 – $199.99 |
60% |
Over $200.00 |
50% |
These values are:
👉 examples only.
Each business should establish pricing structures appropriate for:
•local markets
•inventory costs
•overhead
•competition
•service policies
within their own operation.
MLS 2026 supports:
👉 four wholesale pricing levels
in addition to:
👉 standard retail pricing.
These levels may be used for:
•wholesale clients
•fleet accounts
•commercial customers
•employee pricing
•discount programs
•special account pricing
throughout the system.
Wholesale prices are calculated as:
👉 a percentage discount from retail pricing.
The formula used is:
Price=Retail×(100−Discount%100)Price = Retail \times \left(\frac{100 - Discount\%}{100}\right)Price=Retail×(100100−Discount%)
Example:
100×(100−10100)=90.00100 \times \left(\frac{100 - 10}{100}\right) = 90.00100×(100100−10)=90.00
A:
•$100 retail item
with:
•10% discount
results in:
•$90 wholesale pricing.
MLS 2026 includes:
👉 Price Markup Tables
which allow businesses to automate:
•retail pricing
•wholesale pricing
•markup structures
throughout inventory.
Each pricing table:
•has a unique 2-character code
•may contain multiple markup ranges
•may define wholesale discounts
•can be assigned to inventory parts individually
There is:
👉 no limit
to the number of pricing tables that may be created.
Markup tables provide:
👉 consistent automated pricing
while allowing:
•different inventory categories
•vendor lines
•product types
•specialty items
to follow:
👉 completely different pricing strategies.
Some businesses use:
•one master table
while others use:
•many specialized tables
depending on operational requirements.
Markup tables calculate retail pricing using:
Retail=Cost×MarkupRetail = Cost \times MarkupRetail=Cost×Markup
Example:
•$10 cost
•2.5 markup
results in:
•$25 retail pricing.
Wholesale prices are then calculated using:
Level=Retail×Ratio%Level = Retail \times Ratio\%Level=Retail×Ratio%
Where:
Ratio=100−Discount%Ratio = 100 - Discount\%Ratio=100−Discount%
Example:
•4% discount
results in:
•96% pricing ratio.
MLS 2026 can recalculate pricing:
👉 by markup table.
When prompted:
•entering a specific table code
recalculates:
👉 only parts assigned to that table.
Entering:
👉 XX
causes MLS 2026 to:
👉 recalculate ALL inventory pricing
using:
👉 each part's assigned markup table.
If:
•no table is assigned
then:
👉 no pricing change occurs.
Without standardized pricing:
👉 businesses often experience:
•inconsistent profit margins
•incorrect markup
•underpriced inventory
•employee pricing errors
•outdated retail values
Automated pricing systems help maintain:
•profitability
•pricing consistency
•operational efficiency
•accurate resale pricing
throughout inventory operations.
•Use pricing tables whenever possible
•Standardize markup strategies across inventory groups
•Review pricing regularly during supplier cost increases
•Maintain consistent manufacturer naming
•Test markup structures before applying globally
•Use wholesale levels consistently for account pricing
•Review low-cost items carefully for adequate markup
•Avoid excessive manual pricing overrides
•Update retail pricing whenever supplier costs increase
•Audit pricing periodically for profitability
•Use vendor-specific pricing changes during supplier increases
•Preserve pricing consistency throughout the organization
This section works closely with:
•Inventory Editor
•Pricing Flags & Vendors
•Purchase Orders
•Stock Input
•Inventory Reports
•Vendor Management
•Workorders
•Accounting Integration
•Inventory Utilities
•Non-Stocking Parts
•Parts Sales Reporting
Together, these sections provide a complete inventory pricing and profitability management system within MLS 2026.