Inventory Cathegories
Holding Cost
From Jay Heizer, Barry Render – Operations Management, 7th edition, Pearson&Prentice Hall, Pearson Education International, NJ, 2004, p 456
The table below shows the kinds of costs that need to be evaluated to determine holding costs. Many firms fail to include all of the inventory holding costs. Consequently, inventory holding costs are understated.
Category
Cost (and Range) as a Percent of
Inventory Value
Housing costs (building rent or depreciation, operating cost, taxes, insurance)
6% (3-10%)
Material handling costs (equipment lease or depreciation, power, operating cost)
3% (1-3.5%)
Labor costs
3% (3-5%)
Investment costs (borrowing costs, taxes, and insurance on inventory)
11% (6-24%)
Pilferage, scrap, and obsolescence
3% (2-5%)
Overall carrying cost
26% (15 – 47.5% or even more)
Note: All numbers are approximate, as they vary substantially depending on the nature of the business, location and current interest rates. Any inventory holding cost of less than 15% is suspect, but annual inventory holding costs often approach 40% of the value of inventory.
Solving the Linear Programming Problem with MSExcel
The previous paragraphs illustrated the way to build a Linear Programming model in order to make decisions on the production plan at Lemnco. The model developed was:
[max] f = 20×1 +30×2 + 25×3
subject to: 0.6×1 + 0.8×2 + x3 ≤ 120
x1 + 2×2 + x3 ≤ 420
x2 ≤ 90
x1 ≥ 0, x2 ≥ 0, x3 ≥ 0.
The Linear Programming (LP) model looks good, but why do we need it and how to solve it?
In this paragraph we introduce several methods to use the model, from the simplest one (“naĂŻve”), to the most sophisticated.
1. NaĂŻve approach of the Test Problem
We first notice that the contribution to profit f can increase no matter how much if no constraints on the resources are imposed. For example, a mix of
x1 = 60 pieces of TA,
x2 = 50 pieces of TB,
x3 = 50 pieces of TC
contributed to profit with the amount
f = 20·60 + 30·50 + 25·50 = 3,950 lei.
Although, if the manager