Supply House Times logo Supply House Times
search
cart
facebook instagram twitter linkedin youtube
  • Sign In
  • Create Account
  • Sign Out
  • My Account
Supply House Times logo Supply House Times
  • NEWS
    • ASA NEWS
    • Company News
  • PRODUCTS
    • Interactive Spotlights
  • COLUMNS
    • Natalie Forster: From the Editor
    • Alicia Branham: Marketing Matters
    • Brad Williams: Succession Planning
    • Melissa Rasico: Luxury Plumbing Lounge
    • Letter from ASA President
    • Guest Columnists
    • Safety Columnists
  • MARKETS
    • Codes & Legislation
    • Heating & Cooling
    • Industrial PVF
    • Plumbing
    • Radiant & Hydronics
    • Solar Thermal | Geothermal
    • Technology
    • Women in Industry
  • BATH & KITCHEN PRO
    • Bath & Kitchen News
    • Bath & Kitchen Products
  • SPECIAL EDITIONS
    • B.I.G. Book Directory
    • Premier 150
    • Rep Locator Directory
  • MEDIA
    • Podcasts
    • Videos
    • eBooks
    • Webinars
  • RESOURCES
    • Radiant Comfort Report
    • Industry Calendar
    • Industry Links
    • Custom Content & Marketing Services
    • Market Research
    • Supply House Times Store
  • EMAG
    • EMAGAZINE
    • ARCHIVE ISSUES
    • CONTACT
    • ADVERTISE
  • SIGN UP!
Columnists

TECH TIPS BY FRIEDMAN: How To Modify A System To Maximize Inventory-based Customer Service And ROI

By Dick Friedman
July 6, 2007
These changes can improve your business with little or no human intervention.



If you are a PHCP, PVF and/or HVACR distributor who is using inventory management software that can be modified, you may want to change it in a way that will reduce inventory shortages and excess. That, in turn, will increase the level of customer service and decrease inventory investment. Other benefits include reduced purchasing efforts, rush orders, expediting, clearance sales and returns to vendors. Also, warehouse space would be freed up; less effort would be needed for receiving, put-away and counting; and staffing might be reduced.

Listed below are some of the possible changes that can be made to inventory management systems. They are all meant to function automatically, so little or no human intervention is needed.

  • Analyze order history data for unusual data that would distort inventory levels. If a condition is within a pre-defined tolerance, adjust the data; if a condition is outside the tolerance, list the item on an action report.

  • Calculate safety stock based on target service level and the factors that can result in not having enough planned stock on hand when it’s needed.

  • Allow for trends when calculating lead time.

  • If the history data for an item is outside the tolerance, don’t calculate safety stock or lead time or a forecast; list the item on an action report.

  • If the history data for an item contains too many gaps, don’t calculate safety stock or lead time or a forecast; list the item on an action report.

  • Treat very slow-moving items differently than items that move fast, but don’t require human intervention - treat them automatically.

  • Let the system determine the most accurate method of forecasting.

  • The system can determine the most profitable service level.

  • Identify items for which the service level is too high.

  • Calculate the true cost of buying more than is needed now vs. waiting and buying later.

  • Calculate whether a deal is too good to be true for the distributor (it’s always good for the supplier).
  • Share This Story

    Looking for a reprint of this article?
    From high-res PDFs to custom plaques, order your copy today!

    For more than 40 years, Dick Friedman has been helping PHCP, HVAC and PVF supply houses prevent inventory shortages and warehouse mistakes that lose sales and customers; and helping select ERP, e-commerce and WMS systems, while avoiding the problems and pitfalls. Dick does not sell systems, software or warehouse technology. He is a certified management consultant and is objective and unbiased. Dick can be reached at 847/256-1410 for a free consultation, or visit www.GenBusCon.com for more information or to send e-mail.

    Recommended Content

    JOIN TODAY
    to unlock your recommendations.

    Already have an account? Sign In

    • Stock financial index show successful investment on property business and construction industry with graph and chart for presentation and report background.

      2025 predictions: Twelve trends supply houses should know

      As 2024 ends, I’ll review last year’s predictions and...
      Plumbing
      By: Brad Williams
    • Background of aerial view of Industrial container port part of shipping in nighttime with a blue overlay.

      2025 Next Gen ALL-STARS: Top 20 Under 40 PHCP-PVF Professionals

      The future of the PHCP-PVF industry is being shaped by a...
      Market Sectors
      By: Natalie Forster
    • Premier 150: The top PHCP-PVF Distributors of 2026

      Premier 150: The Top PHCP-PVF Distributors of 2026

      Combined revenue across this year’s Premier 150 once...
      Premier 150
      By: Natalie Forster
    Manage My Account
    • eMagazine
    • Newsletters
    • Manage My Preferences
    • Online Registration
    • Subscription Customer Service

    More Videos

    Popular Stories

    Premier 150: The top PHCP-PVF Distributors of 2026

    Premier 150: The Top PHCP-PVF Distributors of 2026

    Jeff Dice

    Built to Scale, Designed to Stay Local: Lessons From Winsupply at 70

    Erin McCusker, Chief Impact Officer, LIXIL

    LIXIL Elevates Impact Strategy to the Next Phase, Appoints Chief Impact Officer

    2026 Premier Rankings

    Events

    December 30, 2030

    Webinar Sponsorship Information

    For webinar sponsorship information, visit www.bnpevents.com/webinars or email webinars@bnpmedia.com.

    View All Submit An Event

    Poll

    Identifying Daily Time Loss Areas for Your Team

    Where does your team lose the most time each day?
    View Results Poll Archive

    Products

    The Water Came To A Stop

    The Water Came To A Stop

    See More Products

    Download the FREE 2025 Water Conservation, Quality & Safety eBook

    Download the Fifth annual Bath & Kitchen Pro eBook

    Related Articles

    • TECH TIPS BY FRIEDMAN: How To Avoid A Warehouse Management System Horror Story

      See More
    • TECH TIPS BY FRIEDMAN: Why Some Systems are Decreasing Customer Service, Margins and Inventory Profitability

      See More
    • TECH TIPS BY FRIEDMAN: Don't Sign That System Contract - Until It's Changed To Include Protections

      See More
    ×

    Stay in the know on the latest PHCP-PVF industry trends.

    Get tailored content delivered your way.

    JOIN TODAY!
    • RESOURCES
      • Advertise
      • Contact Us
      • Directories
      • Store
      • Want More
      • Plumbing & Mechanical
    • SIGN UP TODAY
      • Create Account
      • eMagazine
      • Newsletter
      • Customer Service
      • Manage Preferences
    • SERVICES
      • Marketing Services
      • Reprints
      • Market Research
      • List Rental
      • Survey/Respondent Access
    • STAY CONNECTED
      • LinkedIn
      • Facebook
      • Instagram
      • YouTube
      • X (Twitter)
    • PRIVACY
      • PRIVACY POLICY
      • TERMS & CONDITIONS
      • DO NOT SELL MY PERSONAL INFORMATION
      • PRIVACY REQUEST
      • ACCESSIBILITY

    Copyright ©2026. All Rights Reserved BNP Media, Inc. and BNP Media II, LLC.

    Design, CMS, Hosting & Web Development :: ePublishing