Inventory Management: Types and Costs
Inventory Management: Types and Costs
Definition:
Classification of inventory:
Raw-material inventory
Work-in-process inventory
Finished goods inventory
1. Raw-material inventory:
The raw material inventory removes dependency between suppliers and plants.
2. work-in-process inventory:
The process inventory removes dependency between various machines of a product line.
The finished- good- inventory removes dependency between plants and its customers or market.
Inventory decisions: the following ‘2’ basis ‘decisions’ are generally taken as managers
Purchase price/unit
Ordering cost/order
Carrying cost/unit/period
Shortage cost/unit/period
Carrying cost
Total cost ACC=AOC
Ordering cost
Order
Order quantity
In the above diagram for an increase in order size (Q) the carrying cost increases and the ordering
cost decreases. The cost curve represents the sum of ordering cost and carrying cost for each order
size.
The order size of which the total cost minimum then it is called “Economic Order Quantity”
(E.O.Q) or optimal order size (Q)”.
Models of inventory
There are different models of inventory. The inventory models can be classified into deterministic
inventory models & probabilistic models
Model-I
The objective this model is to find the economic lot size for the optimum production quantity (Q*)
per cycle of a single product so as to minimize the total average cost per unit time where.
In this inventory model orders of equal size are placed at periodical intervals the items against
an order replenished instantaneously and the items are consumed at a constant rate. The
purchase price per unit is same irrespective of order size.
Inventory level
Max. Inventory
level
Q Q Q
Order quantity
Q = R (t)
0 Time
t t t t t
Q
Avg .inventory =
2
[Link] 1
the no orders D
year
=
Q
[Link] 2
cost of ordering D
year
=
Q
Co [Link] 3
cost of carrying Q
year
=
2
Cc [Link] 4
purchace of price
year
= D.P [Link] 5
D Q
T.C =
Q
Co + 2
Cc + D.P [Link] 6
d
dQ (T.C) =
d D
dQ Q [ Q
Co+ Cc + D . P
2 ]
=
d D
dQ Q ( )
Co + d Q
dQ 2 ( )
Cc + d
dQ
(D.P)
d
dQ (T.C) = -
DCo
Q
2 ( ) + ( Cc2 ) [Link] 7
{[ ] [ ]} = - [ ]+ [ ]
2
d d −DCo Cc d 1 d Cc
( T . C )= + DCo.
dQ
2
dQ Q
2
2 dQ Q2 dQ 2
DCo 2 DCo
= 3
2 ( 1 ) +0 = 3
Q Q
2
d ( 2 DCo
2
T .C )= 3 [Link] 8
dq Q
Since the 2nd derivative is +ve the optimal value of Q obtained by equating the 1st derivative to “o”
−DCo CC DCo Cc
O= 2 + 2 2 =
Q Q 2
Q C c = 2 DCo
2
2 2 DCo
Q =
Cc
Q=
√ 2 DCo
Cc
I.
II.
The optimal order size Q* =
√
2 CoD
Cc
Total no. Of orders pr year (N)* optimum no. Of orders = D/Q*
III. Time b/w orders or optimum ordering interval (t*) = Q*/D
IV. Optimum inventory cost = √ 2× D× Co× Cc
D Q∗¿
V. Total cost is given by TC* = (
Q∗¿ ¿
) Co + ( 2
¿) Cc + D.P
Problems on model -I
Cost per price = RS.250/- inventory holding cost =20% of average inventory
Cc= carrying cost /unit/year = (cost per piece) × (inventory holding cost)× (material holding cost)
2
= Rs 250×0.20×1 = 250× × 1 = 50×1 = Rs.50/-
10
EOQ = Q* = 20
Problem -2 A textile will buys its raw material from a vendor. The annual demand of the raw-
material is 9000 units. The ordering cost is R.s100/- per order and the carrying cost is 20% of the
purchase price per unit per month, where the purchase price per unit is Rs.1 find the following
Solution:
20 2
Cc = carrying cost /unit/year = 20% purchase rice = × Rs 1= × Rs 1
100 10
Cc = Rs 2.4/units/year
( )
¿
D Q
ii. Total cost (TC)* = ¿ Co + ( )Co+D.P
Q 2
= (( ) ) [( )( ) ]
9000
866
×100 +
866
2
2.4 + (2000×1)
= ( 9000
866 )
+ 433(2.4) +9000 = 1039.26+1039.2+9000
(TC)* = Rs11078.46/year
D 9000
Number of orders /year (N)* = ¿ = = 10.39 orders / year
Q 866
¿
Q 866
Time between ‘2’ consecutive orders = = = 0.0962 year
D 9000
Model-2
Manufacturing model without shortages
If a company “manufacturers” an item which is required for its main product then the corresponding
model of inventory is called “manufacturing model”.
In this model shortage are not required the rate of consumption of the item is assumed to be
uniform throughout the year. The item is produced and consumed simultaneously for a portion of the
cycle time. During the remaining cycle time, only the consumption of the item taxes place and the cost of
production per unit are same irrespective of production lot size.
The operation of the manufacturing model without shortage is shown in the following figure.
Units
(K-R) (K-R)
r Q r
Stock Q
level
During the period t 1 the item is produced at the rate of “K” units per period and simultaneously it
is consumed at the rate of “r” units per period during this period, the inventory is built at the rate of (k-r) units
period during the period t 2 the production of the items is discontinued but the consumption of the same item is
continued. Hence the inventory is decreased at the rate of ‘r’ units per period during this time ‘ t 2’.
Q Q
t1 = t 1=¿ [Link].1
k−r r
Since the total quantity produces during the production period t 1 is q and the quantity which is
consumed during the period t 1 is Rt 1
Q=q-R (t 1)
Q Q
Q = q-R ( ) {from [Link] 1 t 1 = }
k−r k−r
Q ( k−R ) Q+ RQ
Q = Q+R ( k−r ) = q = = (K-R) q = (KQ – RQ) + RQ
(K−R)
( k−R )
(K-R) q = KQ = Q = q [Link].2
K 1
∆ ABC= × base × height
2
Holding cost for the time period‘t’ is
MN = Q OB =t from diagrom
Carrying cost (or) holding coast = ( ∆ ONB ) × C c
= ( 12 MN × OB) ×C c
= ( 12 × (Q ) × t )× C c
Qt
Holding cost = ×C c [Link].3
2
Ordering per the period‘t’ = C o [Link].4
[ ]
Qt
= 2
×C c
t
+ ( C2 )
o
{from 3 & 4}
[{ ( ) ] } [ ]
Since Q or q =Rt
1 K−R
q × C c ×t
= 2 K Co t = q/R
+
t t
=[ ( ) ] [ ] [ ( ) ] [ ]
1 K−R C
q ×C c + o 1 K−R Co R
2 K q = q ×C c +
2 K q
r
C (q) =
[( ) ][ ]
1 K−R
2 K
q ×C c +
Co R
q
[Link].5
For the optimum value of q, first we derivate the ‘5’ W.R.T to ‘q’ on B.S
d
dq
C ( q )=
d
dq {[ (2 ] [ ]}
1 K −R
K )
q × Cc +
Co R
q d 1 d −2
= x
dx x 2 dx
1
=2 ( ) [ ] [ ]
K−R
K
Cc
d
dq
(q ) +
d Co R
dq q = (-2). x−2−1 = -2 x−3 =
−2
x
3
=
[ ( [ ]) ]
1
2
1−
R
k
−1
×C c + ( C o R ) 2
q ( )
dc
dq
==
1
2
1−
[ ( [ ]) ]
R
k
Co R
Cc - 2
q
[Link].6
{[ [ ] ] [ ]}
2
d c d 1 R C R
2
= 1− C − o2
d q dq 2 k c q
¿
d
dq {[ [ ] ] [ ]}
1
2
1−
R
C −
d Co R
k c dq q2
2
d c Co R 2
d c
2
=¿ 2+ 3 = 3 >0 [Link].7
dq q dq
the optimum value of q is obtained by equating 1st derivating to ‘o’
dc
dq
1
=0=¿ 1−
2
R
[ [] ]
C R
C − o2 = 0
k c q
Co R 1 R Co R (k−R)Cc
¿
q
2 = 2 ×1− k C
c
= q
2
=
2K
2 2 c o (RK)
¿ q ( K −R ) C c =2 K (C o R) = q 2 =
Cc ¿ ¿
¿ q=
√ (
2 c o RK
Cc K−r )
Or
√
2 co R K
C c K −r ( )
FORMULAS∈ MODEL:−¿
[ ]
R
3. period of consumption only t 2* = Q*
1−( )
R
K =
( K−R ) t 1 Q∗¿ K−R
R
+
R K ( ¿ )
Q∗¿ Q∗¿
4. cycle time t = t 1*+t 2* or t* = ¿ or ¿
R D
R D
5. number of orders/ year (or) optimum number of production cycles/year = or
Q∗¿ ¿ Q∗¿ ¿
√
6. total minimum production inventory cost is C min= 2 R C c C o
(K −R)
K
Note 1:
1. if K= R then C min= 0 i.e. there will be no holding cost & carrying cost
2. if K= ∞ i.e production is finite this model reduces to model –I
Problem-1: an automobile factory manufactures a particular type of gear within the factory. This
gear is used in the final assembly. The particular of this
Solution:
=
√ 2 ×14000 × 500
15
35000
35000−14000
=
√
14000000 35000
15 21000
= √ 9 , 33,333.33 (1.67 )
Q* = 1247
Q∗¿
The period of production as well as consumption t 1* = ¿
K
t 1* = 13 approximately
Q∗¿ K−R
t 2* = ¿( ¿
R K
t 2*= 20 days
R
The number of setups orders per year = = 14,000/1247 = 11.23
Q∗¿ ¿
Problem – 2: company manufacturers a low cost bearing which is used in its main production the
demand of the bearing is 19000 units per month and the production rate of the bearing is 25000 units
per month. The carrying cost as the bearing is Rs0.02 per bearing per year and the Setu cost is Rs.18
per setup find the economic batch quantity (EBQ) and cycle time (t*)
Q* = 18974 units
Q∗¿
The cycle time is t* = ¿
R
t* = 57 days
Q∗¿ 1 Q∗¿
t∗¿ 1 ¿= ¿ 18974/300000 = 0.0632 = 2 t∗¿ 2 ¿= ¿ (K-R/K)
K R
Model [Link]
Notations in model-II
Back ordering: If there is no stock at the time of receiving a request for the item, it is assumed that it
will be satisfied at a later date with a penalty. This is called “back ground”.
units
Q1
Q2
Q Time
t1
t2
t3
Problem-I: The annual demand for a component is 7200 units. The carrying cost is
Rs.1500/unit/year. The ordering cost is Rs.1500/order and the shortage cost is Rs.2000/unit/year. Find
the optional values of economic order quantity maximum inventory, maximum shortage quantity, cycle
time (t), inventory period(60) and shortage period(t 2).
Solution:
D = 72000 units/year C c = Rs.500/unit/year
C o = Rs.1500/order C s = Rs.2000/unit/year
2600 ) √ ( 4 )
= √ ( 43200 ) × (
2500 21600
=
√ 5 ) = √34560 = 185.90
= (
172800
= Q1∗¿ = 186
Maximum stock out Q2∗¿ = Q* - Q1∗¿
= 232 – 186 = 46 units
Q∗¿ 232
Cycle time t* = ¿= = 0.0322 year = 0.0322×365 days
D 7200
t* = 12 days
1∗¿ 186
Period of positive stock t 1 * = Q ¿= = 0.0258 year = 0.0258 ×365days
D 7200
= 9.45 = 10 days
Period of shortage 2 * = t* - t 1 *
t
= 12-10
= 2 days
D∗¿ 7200
Number of orders per year = ¿= = 31.03 = N* = 31.03
Q 232
Problem – 2: The demand of a bought out item in a store is 12000 units per year the carrying cost is
Rs.2 per unit per year and the ordering cost is Rs.600 per order. The shortage cosat is Rs.10 per unit per
year. Find the 70Q and the corresponding number of orders per year, the maximum inventory and
maximum shortage quantity.
Solution: Given that
√
= ( 7200000 ) ×( ) = √ ( 8 , 64,000 )
12
10
= 2939.39 = Q* 2940 units
D∗¿ 1200
Number of orders per year = ¿= = 4.0816 orders/ year
Q 2940
= N* =4.0816 orders/year
Maximum shortage quantity/year = (maximum stock-out)× (No. Of orders/year)
= 490× 4.0816 = 1999.98
Shortage quantity/year = 200 units.
Model – IV:
Manufacturing model with shortage
Notations in model –IV:
The variables which are used in this model are given below.
t 3 = period of shortage
In this model, an item is Produced and consumed simultaneously for a portion of the cycle time.
During the remaining cycle time, only the consumption of the item takes place. The cost of production
per unit is same irrespective of the production lot size.
Back ordering:
Stock out is permitted in this model and it is assumed that the stock out units will be satisfied from the
units which will be produced at a late date with”penalty”. This is called “back ordering”.
Inventory
A
(K-R)
Q1 R
C D
Q
E
B
t3 T4
O Time
t1 t2
Q2
F
Production cycle time
c
c
Q1* = (
K )
K−R
Q*- Q2*
Q∗¿
IV. cycle time t* = ¿
R
Q∗¿
V. period of production & consumption t1* = ¿
( K −R)
1∗¿
VI. period of consumption t2* = Q ¿
R
2∗¿
VII. period of shortage t3* = Q ¿
R
2∗¿
VIII. period of back-order t4* = Q ¿
(K−R)
Problems on model – IV
√ ( K−R
R
× )(
C c +C s
Cs )
Problem-I the demand for an item is 600 units per year. Its production rate is 1000 units per month.
The carrying cost is Rs.50/unit/year and the setup cost is Rs.200 per setup. The shortage cost is Rs.
1000 per unit per year. Find various parameters of the inverters system.
SOLUTION:
Given that
R = 600 units/year
K = production rate/year = 1000 units/month
= 1000 × 12 /year = 12,000 units/month
C o = ordering cost/order = Rs.2000/order
C c = ordering cost/unit/year = Rs.50/unit/year
C s = shortage cost/unit/year = Rs.1000/unit/year
√ ( 180000 ) × ( 12000
6000 ) ( 1000 )
×
1050 =
√ ( 8 ) × ( 120 ) × ( 150 ) = √ ( 1008000 ) = 1003.99
Q∗¿ 1004 units
(√ 2 ×6001000×2000 )( 12000−6000
12000 )( 50+ 1000 )
50
√ ( 24000000/1000 ) × ( 12000
6000
)× ( 1050
50 =
) √ 24000 × ( 0.5 ) × ( 0.0476 ) = √ 571.4286 = 23.90
24 units .
Q1* = ( K−R
K )
Q*- Q2* = (
12000−6000
12000 ) (1004) – 24 = ( 12000
6000
) (1004 )- (24)
=(
2 )
1004
- (24) = 502-24 = 478 units.
t* =
Q∗¿
R
׿ 365 =
1004
6000( )
× 365 = 0.1674×35 = 61.0 = 61 days
t1* =
Q∗¿
( K −R)
¿ × 365 =
478
(
12000−6000
× 365 =
478
6000 )
×365 = 0.07967 ×365 = 29.07 = 29 days.
t2* = Q
1∗¿
R ( )
× ¿ 365 =
478
6000
×365 = 0.07967×365 = 29.07 = 29days
× ¿ 365 = (
6000 )
2∗¿ 24
t3* = Q ×365 = 0.004×365 = 1.46 = 1.5 days
R
× ¿ 365 = ( ) × 365 = (
6000 )
2∗¿ 24 24
t4* = Q ×365 = 0.004×365 = 1.46 = 1.5 days.
(K−R) 12000−6000
Problem-2 in a ‘2’ wheeler manufacturing company pistons are being fed into main assembly line
from a product line situated. In the next day, the annual demand fro the pistons are 8000 units and the
annual production capacity of the product line manufacturing the piston is 12,000 units. The set up cost
is Rs.125 per setup and the carrying cost is Rs.4 per piston per year. The shortage cost is Rs.8 per
pistons. Find Q*,Q1*,Q2*,t*,t1*,t2*,t3* & t4*
t* =
Q∗¿
R
¿=
1500
8000(=
1500
8000 )( )
× 365 = 0.1875×365 = 68.4 = 68.4 days
t1* =
Q∗¿
( K −R)
¿= (
333
12000−8000
×365 = )
333
12000−8000
×365 = 0.0832 ×365 = 30.4= 30.4 days.
t2* = Q
1∗¿
R
¿=( )( )
333
8000
=
333
8000
×365 = 0.0416×365 = 15.2 = 15.2days
¿= (
8000 )
2∗¿ 167
t3* = Q = 0.0209×365 = 7.6 = 7.6 days
R
¿= ( )=(
4000 )
2∗¿ 167 167
t4* = Q × 365 = 0.0417×365 = 15.2= 15.2 days.
(K−R) 12000−8000
Introduction: For the ‘deterministic inventory’ models, it was assumed that the unit ‘production
cost’ or ‘purchase cost’ was ‘constant’ over the range of possible order sizes. So there was no need to
consider this cost directly.
But in this model we shall consider a class of inventory problem in which each cost is a
variable cost.
However, to obtain a higher sales volume, many companies (industries) offer reduced
purchasing costs for large purchases such discounts are typical referred to ‘ quantity discounts ‘ or ‘ rice
breaks’.
To purchase large questions on reduce price, the organization must decide between the EOQ
qe and quality discount (QD*). The overall approaches is to decide which option qe* or qd* minimizes the
total costs.
( QD ) C +( Q2 ) c + D . P
√ √
T.C = o c 2 RCo 2 RCo
Q*D = or
Cc C× p
T.C = ( QD ) C +( Q2 ) c .( p)+ D . P
o
I. Purchase inventory model with one price break suppose the following price discount schedule
is quoted ‘bo’ a supplier in which a price break(quality discount) occurs at quality ‘b1’ this means
Q≤Q1 <b1 C1
b1≤Q2 C2(<C1)
Step-1: consider the lowest C2 and determine Q2* by using the EOQ formula.
Q2* =
√ 2 DCo
C 1× C 2
or Q2* =
√ 2 DCo
Cc √
or Q2* =
2 DCo
C ×P2
Case -1:
Q* = Q2*
Then calculate the Q1 with the price C1 and the corresponding total coast(TC) at Q1* compare TC (b1)
& TC(Q1*)
Q1* =
√ 2 RCo
Cc
or Q1* =
√ 2 RCo
C ×C 1
Sub case-II: otherwise Q*=b1 is the required EOQ = TC(b1) < tc (Q1*)
Problems:
Problem- no 1: find the optimum order quantity for a product for which the price breaks are given
below.
Monthly demand for the product is 250 units cost of carrying is 2% of the unit cost and cost of ordering
is Rs.300
Solution:
Q
= = 0.02
100
C2 = 14.50
Q2* = 719
Problem-2:
The annual demand of a product is 10,000 units. Unit cost is Rs100 if the orders placed in
quantities below 200 units but for orders of 200 or above the price is Rs.95 the annual inventory holding
cost is 10% of the value of the item and the ordering cost is Rs.5 per order. Find the economic lot size.
10
Holding cost or carrying cost/unit/year = 10% item = = R.s 0.10/unit/year.
100
Rs.100 0≤q1≥200
Rs.95 q2 ≥ 200
Q1* =
√ 2 × R × Co
C×C2 √
=
2 ×10000 × 5
0.10 × 100
=
√
100000
100
= √ 10000 = Q1* = 100 units
Problem-3: Find the EOQ for the following financial demand =400 units ordering cost is R.s20,
inventory cost carrying changes =20% cost per unit. The unit cost is Rs.50 if q<100 and Rs.49 if q≥100.
Solution:
Given that
R.s 50 O<q1<100
Rs. 49 q2 ≥ 100
units
√ 2 × R × Co
C×C2
=
√ 2 × 400 ×200
0.20× 49
=
√ 1600
9.8
= √ 1632.6531 = 40.40 =Q2* = 40
Q1* =
√ 2 × R × Co
C×C1 √
=
2 × 400 ×20
0.20 ×50
=
√
1600
10
= √ 1600 = 40 = Q1* = 40 units
EOQ = 40 units.
Purchase inventory model with-two price breaks
Suppose that the following price discount schedule is quated by a supplier, in which a rice break occur at
quantity b1 & b2.
O<q1<b1 C1
b1≤q2<d2 C2
b2≤q3 C3
Note: C3<C2<C1
The optimum purchase quantity can be determined by the procedure given below
Algorithm
Thus, there are only 2 possible when Q2*≤b2. i.e either Q2*≥b1 or Q2*<b1
CASE-1:
Then proceed as in the case of the area price break only i.e, compare the costs C(Q2*) and C(b2) to
obtain the optimum purchase quantity .the quantity with lower cost will naturally be the optimum.
Case -2:
Then Q1* which will satisfy the irregularity Q1*<b1. In this case compare the cost C(Q1*) with
C(b1)&C(b2) both to determine the optimum Purchase quantity.
Problem-1:
Find the optimum order quantity for a product for which the price breaks are as follows.
Solution:
Q3* =
√ 2 × R × Co
C ×C 3
=
√
2 ×200 × 20
8 × 0.25
=
8000
2 √
= √ 4000 = 63.24
Q3* = 63 units
But Q3*< b2 i.e 63<100 the condition Q3*≥b2 is not satisfied C3=8 so Q3* is not correct optimum lot
size.
Q2* =
√ 2 × R × Co
C ×C 3
=
√
2 ×20 × 200
9 × 0.25
=
8000
225 √
= √ 3555.55 = 59.62
Q2*=60
Thus the condition is satisfied we have to compare the total cost of 60 and 100 to find the lot size.
TC (Q2*) = (R/Q2*)Co+(Q2*/2)(Cc×C2)+R(C2)
T.C(b0) = ( 200
60 ) ×20+
60 × 0.25× 9
2
+ ( 200 ×9 )
4000 135
= + + 1800 = 1934.17
60 2
Probnlem-2: A sub contractor has been found who can supply machines to a power plant
manufacturer who require 83 machines per day in his assembly operations. No shortages are to be
allowed procurement cost will be Rs.90 per chase order. The cost per unit is a function of the purchase
quantity as following.
Purchase quality 1-199 200-499 500 or more
The holding cost is R.s 0.45 per bushing per day. Calculate the least purchase quantity for
Purchasing from the sub-contractor.
Q3* =
√ 2 × R × Co
C× P
=
√
2 × 83× 90
0.45
=
14940
0.45√= √ 32200 = 182.00
So find the optimum lot size we have to calculate total costs fro 199,499,500, and 182 i.e
TC(182),Tc(199)TC(499)Tc(500).
TC (Q3*) = (R/Q3*)Co+(Q3*/2)(Cc×C2)+R(C2)
Problem-3: Annual demand for an item is 6000 units, ordering cost is Rs. 600 per order. Inventory
carrying cost is 18% of the purchase price/unit/year. The price break-ups are as shown below.
0≤Q1<2000 20
2000≤Q2<4000 15
4000≤Q3 9
b1 = 2000 b2 = 4000 C1 = 20 C2 = 15 C3 = 9
¿
Step-1: Calculate Q3
⟹Q3 = 2108.18
¿
Q3 =
√ 2 × R × Co
C ×C 3
=
√
2 ×6000 × 600
0.18 X 9
=
1.62√
7200000
= √ 4444444.44 = 2108.18
¿
⟹Q3 = 1633
¿
Q2 =
√ 2 × R × Co
C×C2
=
√
2 ×6000 × 600
0.18 X 15
=
2.7 √
7200000
= √ 2666666.67 = 1632.99
¿
¿
Since Q2 < b1 i.e. 1633< 2000 then go to step-3
¿
Step-3: Calculate Q1
¿
Since Q1 < b1 i.e. 1414< 2000
Then find the following costs and select the order size with respect to the least cost as the optimum
order size
¿
T.C. (Q1), T.C.( b1 ), T.C.( b2 ) i.e. T.C.(1414), T.C.(2000), T.C. (4000)
¿ ¿ ¿
TC (Q1) = (R/Q1) Co+ (Q1/2) (Cc×C1) +R (C1)
O < q1 <b1 C1
b1 ≤ q2 <b2 C2
. .
. .
bn-1 ≤ qn Cn
ALGORITHM:
The procedure to compute the optimum order size for this situation is given in the following steps
STEP -1:
Qn =
¿
√ 2 × R × Co
C ×C n
¿
or Qn =
√ 2 × R × Co
CC
¿ ¿
Case - i) If Qn ≥ bn-1 then the optimum order size Q¿ is equal to Qn
¿
Case - ii) If Qn < bn-1 Otherwise go to step -2
STEP -2: Find the EOQ for the (n-1) price break
Q¿(n −1 ) =
√ 2 × R × Co
C ×C (n−1)
¿
or Q(n −1 ) =
√ 2 × R × Co
CC
¿
Case - i) If Q(n −1 ) ≥ bn-2
Then compute the following total costs and select the lest cost purchase quantity as the optimum
order size
¿ ¿
i) Total cost for Q(n −1 ) i.e. T.C. (Q(n −1 ))
STEP -3: Find the EOQ for the (n-2) price break
¿
Q(n −2 ) =
√ 2 × R × Co
C ×C(n−2)
¿
or Q(n −2 ) =
√ 2 × R × Co
CC
¿
Case - i) If Q(n −2 ) ≥ b (n-3)
Then compute the following total costs and select the lest cost purchase quantity as the optimum
order size
¿ ¿
i) Total cost for Q(n −2 ) i.e. T.C. (Q(n −2 ))
¿
Case - ii) If Q(n −2 ) < b (n-3) then go step – 4
¿
STEP -4: continue in this manner until Q(n −i ) ≥ b (n-i-1)
¿
Then compute the total costs T.C. (Q(n −i ) ), T.C. (b (n-i)), T.C. (b )... T.C. (bn-1) corresponding to
(n-i-1)
¿
purchasing quantities (Q(n −i ) ), (b (n-i)), (b (n-i-1))... (b n-1) respectively.
Finally, select the purchase quantity with respect to the minimum total cost as the optimum order
size.
Problem-1: Annual demand for an item is 550 units; the cost of shortage per unit per year is 10% of the
unit cost. The ordering cost is Rs. 150 for each order. The unit cost depends on the amount ordered. The
range amount ordered and the unit cost price are as follows.
0 ≤Q1<550 25
550 ≤ Q2<1600 24
3000 ≤ Q4 23
Find the optimal order size
¿
Step-1: This is 3 price break problem. First calculate Q4
Since Q4 < b3 i.e. 274< 3000 thus the condition Q4 > b3 is not satisfied. Then go to step-2.
¿ ¿
¿
Step-2: Calculate Q3
⟹Q3 = 268
¿
Q3 =
√ 2 × R × Co
C ×C 3
=
√
2 ×550 × 6150
0.10 X 23
=
165000
2.3 √
= √ 71739.13 = 267.84
¿
¿
Since Q3 < b2 i.e. 268< 1600then go to step-3
¿
Step-3: Calculate Q2
¿
Since Q2 < b1 i.e. 262< 550 then go to step-4
¿
Step-4: Calculate Q1 and calculate the total cost and the least cost of purchase quality as the optimum
order size
¿
T.C. (Q1), T.C.( b1), T.C.( b2).
¿ ¿ ¿
TC (Q1) = (R/Q1) Co+ (Q1/2) (Cc×C1) +R (C1)
Since T.C. (b2) > TC (Q1) > TC (b1) ⟹ TC (b1) < TC (Q1) < T.C. (b2)
¿ ¿
For the deterministic inventory models, it was assumed that ‘demand’ and the ‘lead time’ are
known and constant.
However if the values of the demand and the lead time are not known exactly, then we use
probability distributions (discrete & continuous) to find the values. Then the models are called
“probabilistic Inventory” models. That means the demand can be known with certain probability.
In this case we cannot minimize actual cost. But the optimum quantity of inventory is determined
on minimising the “Total Expected Cost” (T.E.C.) instead minimising the actual cost.
TYPES OF MODELS:
1) MODEL – I: Discrete Demand, Discrete stock level, set up cost zero, Lead time zero.
2) MODEL – II: Discrete Demand, Continuous stock level, No set up cost, Lead time zero.
3) MODEL – III: Continuous Demand, Discrete stock level, set up cost zero, Lead time zero.
4) MODEL – IV: Continuous Demand, Continuous stock level, No set up cost, Lead time zero.
1) MODEL –I : DISCRETE DEMAND, DISCRETE STOCK LEVEL, SET UP COST
ZERO, LEAD TIME ZERO
The objective of this model is to find an “optimum stock level” rather than to find the “optimum order
quantity (EOQ). The advantage of this model is to achieve the long term expected profit from selling
a unit with the potential loss of having to scrap it.
Q = Order size
D<Q
Q D
D-Q
Over Stock
Time
D Q
D-Q
Time
Shortage Stock (or)
Under Stock
t
FORMULA:
¿
The optimum inventory level ( Q ) is determined when the value of Cumulative Probability
PROBLEM -1:
Monthly sales 0 1 2 3 4 5 6
Probability 0.01 0.06 0.25 0.35 0.20 0.03 0.10
The cost of carrying inventory is Rs. 30 per unit per month and the cost of unit shortage Rs. 70 per
month. Determine the optimum stock level that minimizes the total expected cost.
SOLUTION: Given that CC = Holding cost or Carrying cost / unit / month = Rs. 30 / unit / month
The optimum solution is obtained by developing the cumulative probability distribution of monthly sales
as follows.
Monthly 0 1 2 3 4 5 6
sales
Probability 0.01 0.06 0.25 0.35 0.20 0.03 0.10
Cumulative 0.01 0.07 0.32 0.67 0.87 0.90 1.00
probability
¿
P[D≤ (Q )]
¿
This suggests that Q = 0.70 lies between 0.67 & 0.87
⟹0.67 ≤ 0.70 ≤ 0.87 ⟹P [D≤ (4-1)] ≤ 0.70 ≤ P (D≤4) ⟹ P [D≤ (3)] ≤ 0.70 ≤ P (D≤4)
¿
Thus the condition for optimality suggests that Q = 4
This model is similar to Model –I except that the stock level is continuous.
If f (D) = Probability density function of the demand (D) of an item.
Q = Order size
FORMULA:
The optimum order quantity (Q¿) is determined when the cumulative probability distribution is equal to
0
CC +C S
PROBLEM -1:
A baking company sells cake by its weight in kilograms. It makes a profit of Rs. 5.00 on
every kilogram sold on the day it is baked. It disposes of all cakes not sold on the date they are baked, at a
loss of Rs. 1.20 per kg. If the demand is known to be rectangular distribution lies between 2,000 and
3,000 kgs. Determine the optimum daily amount baked.
The demand is a rectangular distribution lies between 2,000 and 3,000 kgs. We know that p.d.f. of
rectangular distribution is given by
1 1 1
f (D) = = = ; 2000 ≤ D ≤ 3000 →1
b−a 3000−2000 1000
[ ] [ ]
Q Q Q
1 1 D Q−2000
P [D ≤ Q] = P [2000 ≤ D ≤ Q] = ∫ 1000
f ( D ) dD =
1000 ∫ f ( D ) dD =
1000
=
1000
→3
2000 2000 2000
The optimum value of inventory level is obtained by equating C.p.d.f. to the ratio ( CS
CC +C S)i.e.
This model is similar to Model –I except the cost equation is continunous and discrete stock
level will be different
D = Demand
Q = Order size
FORMULA:
¿
The optimum order level (Q ) is determined when the value of Cumulative Probability Distribution
[ ∑ P ( D )+(Q− 12 ) ∑ ](
CC
) [ ∑ P ( D )+(Q+ 12 ) ∑ ]
Q−1 ∞ Q ∞
P(D) P( D)
≤ ≤
D =0 D=Q D CC +C S D =0 D =Q +1 D
PROBLEM -1:
Monthly 0 1 2 3 4 5 6
sales (D)
Probability 0.02 0.05 0.30 0.27 0.20 0.10 0.06
The cost of carrying inventory is Rs. 10 per unit per month. The current policy is to maintain a stock
of 4 items at the beginning of each month. Assuming that the cost of shortage is proportional to both
time and quantity, Obtain the inputted cost of shortage.
Now applying the optimum order (Q¿) formula to find the shortage cost.
P [L≤ (Q -1)] ≤
¿
( CC
CC +C S ) ¿
≤ P [L≤ (Q )]
[ ( )∑ ]( CS
) [ ( )∑ ]
Q+ 1 ∞ Q ∞
P(D) P( D)
∑ P ( D )+ Q− 12 D
≤
CC +C S
≤ ∑ P ( D )+ Q+ 12 D
D =0 D=Q D =0 D =Q +1
[∑ ( )∑ ]( CS
) [ D ]
( ) ∑ P(D)
3 6 4 6
1 P(D)
P ( D )+ 4−
2 D
≤
CC +C S
≤ ∑ P ( D )+ 4+ 12
D =0 D=4 D =0 D =5
[ ∑ P ( D )+( 72 ) ∑ ]
3 6
P(D)
=
D =0 D =4 D
= [ P ( 0 ) + P ( 1 )+ P ( 2 )+ P ( 3 ) ] + ( 72 ) {[ P (4)
4 ] +[
P(5)
5 ] +[
6 ]}
P (6)
⟹ CS = ( 0.08 ) ⟹ C S = 115 →1
9.2
( ) ⟹ ( ) ⟹ C S = 0.975 (10+C S)
CS CS
Since = 0.975 = 0.975
CC +C S 10+C S
⟹ C S (1-0.92) = 9.75
⟹ CS = ( 0.025 ) ⟹ C S = 390 →2
9.75