The Cost of Damaged, Lost or Stolen Inventory

Recently I was walking through a warehouse with the owner of a small distributor, when one of his employees brought him a widget that had been damaged by a forklift. The owner told him to trash the widget, and tell accounting to write it off; the value of this widget, $170. This got me thinking, “are they aware of the cost to replace this widget?”

Later, I asked the warehouse person how much they would need in sales to replace this widget; he said $170. Well, not exactly, let me explain.

In order to replace the cost of the damaged widget, the money must come from the margin of future sales. This company earns a 2% margin for this widget, so they must sell 50 widgets, just to pay for the widget that was damaged! That is $8,500 in additional sales!

$170/.02 = $8,500 in new sales needed to replace damaged widget

$8,500/$170 = 50 widgets

This example doesn’t take into account carrying costs; if carrying costs were 30%, the replacement cost would be $11,050!

This chart illustrates additional sales required to make up for lost/stolen/damaged inventory:

Gross Margin

Item Value      2%        3%         4%         5%        6%

$25                $1,250   $833      $625     $500       $417

$50                $2500    $1,667    $1,250  $1,000    $833

$100              $5,000    $3,333   $2,500   $2,000   $1,667

$200              $10,000   $6,667   $5,000   $4,000   $3,333

$500              $25,000   $16,667  $12,500 $10,000 $8,333

$1,000           $50,000    $33,333 $25,000 $200,000 $16,667

Again, to breakeven on lost, damaged or stolen inventory, the replacement cost comes from future profits! How much harder must your sales team work to make up for damaged, lost or stolen inventory?

These little inventory costs that occur daily and weekly add up over time, and at the end of the year, these “little” costs can have a substantial effect on the bottom line. Therefore, it is important for employees to understand costs associated with inventory, and the impact it has on the company’s financials.

Votes: 0
E-mail me when people leave their comments –

Written by: Bob Swedroe, Former President and CEO at Expandable Software, Inc.

You need to be a member of ERPcommunity.com to add comments!

Join ERPcommunity.com


WRITE FOR US!

We're looking for high-quality unique content for ERP Community.

If you're interested in subimitting a post or article, please contact us.


Sponsors:

 

 

 


Looking for a Job?

Do you need an exit strategy?

The ITX M&A Marketplace and the ERP Community have a proprietary database of 50,000+ global buyers seeking IT Services firms, MSPs, MSSPs, Software-as-a-Service platforms and channel partners in the SAP, Microsoft, Oracle, ServiceNow and Salesforce space.

LEARN MORE

Ads

 




ERPcommunity.com is a 7LinksWeb.com project. You don't have to be big to be noticed.