Home | Download | Purchase | knowledge

 
 


INVENTORY MANAGEMENT ADJUSTED MARGIN: A BETTER GAUGE OF PROFITABILITY

  • SAFE Home Inventory Software (Secure Assets For Everyone)
  • Inventory Pro Online - Warehouse Management System Online
  • Inventory Pro for Windows - Warehouse Management System for Windows
  • Historic Building Inventory Forms, 1982-2001
  • ActivityBase Inventory Manager (AIM)
  • Accounting Department Equipment Inventory
  • an efficient system of counting and maintaining a stock of inventory
  • a simple, powerful and affordable inventory visibility and control system
  • Traker Systems Inventory Control Software Designed for the Future
  • an affordable, feature-rich Inventory System!
  • INVENTORY MANAGEMENT ADJUSTED MARGIN: A BETTER GAUGE OF PROFITABILITY
  • Achieving Success with Vendor-Managed Inventory
  • Liquidating Non-Moving Inventory
  • Your warehouse is probably filled with repair parts for the equipment you've sold. What profit do you make when you sell a part?

    Well, if you ask a salesman he may say, "That's easy, we average a 25% gross margin on all of the parts we sell!" But does your gross margin directly relate to your profitability? Don't you experience costs, besides what you pay the vendor, in maintaining inventory in your warehouse?

    Sure you do. The accumulation of costs you incur in maintaining inventory is called the inventory carrying cost. These costs include:

    • Putting received material in its proper bin location and moving it to other warehouse locations as necessary.
    • Insurance and taxes on the inventory.
    • A portion of the warehouse rent and utilities (the balance is considered a sales expense).
    • Physical inventory and cycle-counting.
    • Inventory shrinkage and obsolescence.
    • The opportunity cost of the money invested in inventory. That is, how much could you make if the money tied up in inventory was invested in a relatively safe, income-producing investment.

    Unfortunately the cost of carrying inventory is not considered in calculating gross margin. Gross margin is calculated by dividing gross profit dollars by sales dollars.

    At first glance, both lines are equally profitable and provide the "target return" our salesman previously mentioned. But the average inventory investment in product line "A" is $4,000, while the average investment in stock for product line "B" is $13,000.

    Are these product lines really equal when it comes to profitability? For the first product line, we receive $5,000 in profit for the $4,000 we have invested. The second product line provides a $7,500 return on an investment of $12,500.

    The adjusted gross margin percentage comes closer to measuring the true profitability of a product, product line, branch inventory or the entire company. It applies the cost of carrying inventory to the equation for calculating gross margin:

    Annual Gross Profit Dollars less Annual Carrying Cost Dollars

    Annual Sales Dollars

    A conservative annual carrying inventory is 25% of the average inventory investment. If we apply this percentage to the first product line, the annual carrying cost is $1,000 ($4,000 times 25%). Using the same percentage, the annual carrying cost of the second product line is $3,125 ($12,500 times 25%). Using this information let's calculate the adjusted margin percentage for the two product lines and see which is a better investment.

    The product lines aren't equally profitable. In fact, if our company experiences typical industry operating expenses of 15% of sales, we're actually losing money on product line "B." And that's not even considering the commissions we pay our salespeople!

    Many product lines, especially those that call for a tremendous inventory of repair parts, require a substantial investment in inventory. This investment must be considered when you establish your selling prices and the profit you must receive from each sale. Get your employees into the habit of talking about a product line's adjusted margin rather than its gross margin. They will have better job security as the adjusted margin concept helps guide your company to greater profitability!

    Jon Schreibfeder is president of Effective Inventory Management, Inc. He has over 20 years experience helping distributors improve their productivity and profitability. He may be reached at (214) 304-3325, fax (214) 393-1310, e-mail: jonsintx@aol.com. This article cannot be reprinted, in whole or in part, without the expressed written permission of Effective Inventory Management, Inc.