Liquidating Non-Moving Inventory
Calculating Your Target Inventory Investment
Encouraging Inventory Accuracy
Vendor Managed Inventory There More To It Than Just Selling Products
Make This Year Physical Inventory More Accurate and Less Painful
Implementing Effective Inventory Management
Why Is Inventory Turnover Important?
Do You Monitor Your Residual Inventory?
Put Your Time to the Best Use The Myth of Disposing of Dead Inventory
There's No Such Thing as Free Inventory
Can You Predict if Inventory Will Die in Your Warehouse?
Does Your New Inventory Contribute to Dead Stock?
The Cascading Effect of Effective Inventory Management
Controlling Open-Stock Inventory
A Questionnaire for New Inventory Items
Liquidate All Slow-Moving Inventory?
Analyzing Inventory Adjustments
Consider if Some Inventory Will Need To Be Buried
The Mysterious Cost of Carrying Inventory
The carrying cost of inventory is the cost of maintaining your average
inventory investment of inventory in your warehouse, storeroom, stockroom, or
other location where you stock raw materials or finished goods. What costs do
you incur in carrying inventory?
-
Cost of putting away stock receipts and moving material within the
warehouse. How much of your employees' time is spent in these
activities?
-
Rent and utilities for the portion of your warehouse used to store stock
inventory.
-
Insurance and taxes on inventory. If it's in your warehouse, you have
to insure it, and it may be subject to tax.
-
Physical inventory and cycle counting. The more material in your
warehouse, the longer it takes to count.
-
Inventory shrinkage and obsolescence. The more material in your
warehouse, the higher the possibility of shrinkage and obsolescence. After all,
it's hard to steal something that isn't there!
-
Opportunity cost of the money invested in inventory. How much could
you make if you were to take the money you're investing in inventory and invest
it in a more traditional investment (such as treasury bills)? Or if you are
financing your inventory, how much interest are you currently paying the
bank?
The carrying cost percentage is calculated by dividing the sum of these
expenses (along with the opportunity cost) by the average inventory value. It is
the amount of money it takes to maintain one dollar's worth of inventory for an
entire year.
For years many industry consultants have maintained that determining your
company's actual carrying cost is too difficult to calculate in a reasonable
amount of time, and that you should use a rule of thumb such as "current prime
rate plus 20%." One inventory "guru" recently suggested that you should adjust
your carrying cost percentage so that the economic order quantity formula
suggests "reasonable" reorder quantities.
This is backwards thinking. The economic order quantity formula is designed
to calculate the lowest total cost reorder quantity (i.e. your "best buy
quantity") based, in part, on the cost of carrying inventory. If it costs you
less to maintain inventory in your warehouse, you will tend to stock more. If
your carrying costs are high, you will probably want to keep just enough
inventory in your warehouse to protect customer service. Guessing at your
carrying cost will not ensure that you are buying the quantity that will
minimize your firm's total cost of inventory.
Just as important, using an approximate carrying cost does not help you
identify areas for potential improvement in your warehouse operations. In these
days of increased competition, lower margins, and greater customer demand of
product availability, it is important to lower operating costs and increase
productivity wherever possible. By closely examining the specific components of
the inventory carrying cost and comparing the numbers to other firms in your
industry and region, you can identify areas that are candidates for
improvement.
With all of this in mind, EIM would like to help you calculate your cost of
carrying inventory. If you will print and fill out the attached questionnaire
and send it to us by email, mail, or fax, we will calculate your carrying cost
and send you a comparison of your answers to each question to others in your
region and industry. There is no charge for this service as long as you agree to
let us add your information to our database. Please note that all responses
are confidential. Data we present to other companies will not identify your
company name or location.
Even if you don't fill out the questionnaire, please review it, as it
includes most (if not all) of the factors you must consider as you calculate
your own inventory carrying cost.
-
What was your average inventory value over the past 12 months (sum of
month-ending inventory values divided by 12)?______
-
What was your total warehouse labor expense (wages, taxes, and benefits)
during the past 12 months (including the expense of inspection, putting away
stock, moving from bin to bin as necessary, assembling kits, and filling
customer orders)?______
-
What percentage of warehouse activity is dedicated to filling customer orders
and transfers?______
-
Is this warehouse owned or rented?______
-
If the warehouse is rented, what is the monthly rent?______
-
If the warehouse is owned, what is the rental cost of comparable warehouse
space under a "triple net" lease (i.e. a lease where the tenant pays all
utilities, maintenance, and property taxes)?______
-
How many square feet (or meters) is your facility?______
-
How many square feet (or meters) is your warehouse?______
-
What were the total warehouse utilities you paid last year?______
-
What were the total property taxes you paid last year?______
-
What was your total warehouse maintenance expense last year?______
-
What was your total warehouse supply expense, excluding shipping materials
(that is, storage boxes and other supplies used in the process of receiving and
stocking material)?______
-
What was the cost of warehouse equipment that was expensed (i.e. not
capitalized) last year?______
-
What was your total depreciation expense for warehouse equipment last
year?______
-
What was the value of written-off inventory last year?______
-
What was the value of inventory shrinkage last year (not included in the
written-off inventory value)?______
-
How much current inventory is in excess of a 12-month supply (a value equal
to monthly demand x 12)?______
-
What was the cost of insuring your warehouse and equipment last
year?______
-
What was the cost of insuring your inventory last year?______
-
What was the cost of any inventory taxes you paid last year?______
-
If additional labor was necessary to conduct physical counts of your
inventory, what was the cost of this labor (including taxes and
benefits)?______
-
If you borrow money to finance your inventory, what was the average
outstanding balance over the past 12 months?______ What is the annual interest
rate?______
-
If you borrow money to finance warehouse equipment or improvements, what was
the average outstanding balance over the past 12 months?______ What is the
annual interest rate?______
-
If you finance your own inventory purchases, what interest rate could you
expect to receive if you invested that money in a relatively safe
income-producing investment?______
Please use this information to calculate an inventory
carrying cost for our company. We agree to allow Effective Inventory Management,
Inc. (EIM) to use this data for comparative purposes, but acknowledge that EIM
will not reveal our company name or location to any other party without our
expressed written permission.
|