1-Inventory and Supply - Discussion F20
1-Inventory and Supply - Discussion F20
1-Inventory and Supply - Discussion F20
1. Supply network
2. Costs
Order (setup cost): occurs per order and independent of the order quantity
Communication costs, equipment setup, transportation
Purchase, production costs: depends on the ordered quantity
Material, labor, energy
Inventory costs: more inventory → larger costs
Opportunity costs (lot-size the opp. to make money by investment)
Insurance costs, storage cost
WIP costs: major inventory
Backorder cost: Customer will wait
Stockout cost: customer will not wait → lot-size profit in addition
3. Order policy: when and how much to order → to minimize the costs need to be determined
Page 1 of 29
Trade off
# 𝑺𝒊𝒛𝒆
𝑭𝒓𝒆𝒒𝒖𝒆𝒏𝒕 𝑶𝒓𝒅𝒆𝒓 𝒘𝒊𝒕𝒉 𝒔𝒎𝒂𝒍𝒍 𝒔𝒊𝒛𝒆 ↑ ↓
𝑳𝒆𝒔𝒔 𝒇𝒓𝒆𝒒𝒖𝒆𝒏𝒕 𝒐𝒓𝒅𝒆𝒓 𝒘𝒊𝒕𝒉 𝒍𝒂𝒓𝒈𝒆 𝒔𝒊𝒛𝒆 ↓ ↑
Time
Note: If demand is deterministic and dynamic → dynamic lot-size
Changes over time
q
Page 2 of 29
5. A production (purchase) run incurs a fixed setup cost. Regardless of the size of the lot or the status
of the factory, the setup cost is the same.
Order 200 → $ 10 Usually, variable setup costs.
Order 500 → $ 10 (Setup costs = f(order size))
c = unit production (purchase) cost, not counting setup or inventory costs (in dollars per unit)
This represents the value of a product, material, labor, energy + time, space + environment
Ordering cost
(Cost to keep a unit for a year)
A = fixed setup cost to produce (purchase) a lot [$]
h = inventory holding cost (in dollars per unit per year); if the holding cost consists entirely of interest
on money tied up in inventory, then h=ic, where i is the annual interest rate,
Time depended. Opportunity, insurance and storage, the money tied up with inventory could
be used to make money by another investment
Page 3 of 29
Irregular
order
quantity
Regular (average costs)
T A A A A time
Setup = A
In this pattern we want to find order quality Q*
ℎ𝑄 𝐴𝐷
𝑌(𝑄) = + + 𝑐𝐷
2 𝑄
≡ Q/2
T = Q/D
Costs per each interval = Setup + Production + Inventory holding+ WIP + Backorder
Costs / year Y (Q)
𝐐 𝑸 𝑸𝟐
= 𝐀 + 𝐂𝐐 + 𝐱 𝒉 = 𝑨 + 𝑪𝑸 + 𝒉
𝟐 𝑫 𝟐𝑫
Page 4 of 29
𝑸𝟐
𝐘(𝐐) = (𝐀 + 𝐂𝐐 + 𝒉) 𝐱 ⋕ 𝐨𝐟 𝐨𝐫𝐝𝐞𝐫𝐬/𝐲𝐞𝐚𝐫
𝟐𝑫
𝑸𝟐 𝐃
𝐘(𝐐) = (𝐀 + 𝐂𝐐 + 𝒉) 𝐱
𝟐𝑫 𝐐
𝐀𝐃 𝐐
𝐘(𝐐) = + 𝐂𝐃 + 𝐡
𝐐 𝟐
Now, Find Q* that minimizes Y (Q)
𝟐𝐀𝐃
𝐐∗ = √ Independent of c → we fulfill all demand, annual production cost is constant
𝐡
𝟐𝐀𝐃
𝐡√ 𝐀𝐃
𝐡
𝐘(𝐐∗ ) = + + 𝐜𝐃 = √𝟐𝐀𝐃𝐡 + 𝐜𝐃 Optimal cost
𝟐 𝟐𝐀𝐃
√
𝐡
This square root formula is the well-known economic order quantity (EOQ), also referred to as the
economic lot size. And, optimal order interval is
2𝐴
𝑇∗ = √
ℎ𝐷
𝐐∗ √𝟐𝐀𝐃 𝟐𝐀
𝐡
𝐓∗ = = =√
𝐃 𝐃 𝐡𝐃
𝟐𝐀𝐃
𝐐∗ = √
𝐡
𝟐𝐀
Optimal inventory behavior: 𝐓 ∗ = √𝐡𝐃
Page 5 of 29
𝐘(𝐐∗ ) = √𝟐𝐀𝐃𝐡 + 𝐜𝐃
Optimal policy: Order Q* at every T* interval
Example. Consider a shop that produces metal racks. The demand for metal racks is fairly steady and
predictable at D=1,000 units per year. The unit cost of the racks is c=$250, but the metalworking shop
also charges a fixed cost of A=$500 per order, to cover the cost of shutting down the shop to set up.
The shop estimates its opportunity cost for money at 10 percent per year. It also estimates that the
floor space required to store a rack costs roughly $10 per year in annualized costs.
1.1.3 Sensitivity
𝑸∗ → 𝑸′ 𝒀(𝑸′ )
↓ ↓ ⇒ 𝑆𝑒𝑛𝑠𝑖𝑡𝑖𝑣𝑖𝑡𝑦
𝒀(𝑸∗ )
𝒀(𝑸∗ ) 𝒀(𝑸′ )
Page 6 of 29
If the rate is much less than the expected, we can say that the cost is insensitive to lot size.
The sum of holding and setup costs is fairly insensitive to lot size. To examine the sensitivity of the cost to
lot size, we formulate optimal total cost per year Y* (but omitting the c term, since this is not affected by
lot size).
(Y constant) make the analysis by analyzing production cost.
ℎ𝑄 ∗ 𝐴𝐷
𝑌 ∗ = 𝑌(𝑄 ∗ ) = + ∗ = √2𝐴𝐷ℎ
2 𝑄
𝒉𝑸 𝑨𝑫
𝒀(𝑸) = + + 𝒄𝑫
𝟐 𝑸
𝟐𝐀𝐃
𝐐∗ = √
𝐡
𝟐𝐀𝐃
𝒉√ 𝑨𝑫 √𝟐𝐀𝐃𝐡 √𝟐𝐀𝐃𝐡
𝐡
𝒀(𝑸∗ ) = + = + = √𝟐𝐀𝐃𝐡
𝟐 𝟐𝐀𝐃 𝟐 𝟐
√
𝐡
Optimal policy cost with Q* w/o production cost (it is not the total annual cost!)
Now, suppose that instead of using Q*, we use some other arbitrary lot size Q’, which might be larger or
smaller than Q*.
ℎ𝑄 ′ 𝐴𝐷
𝑌(𝑄′) = + ′
2 𝑄
Then,
𝑌(𝑄′) 1 𝑄 ′ 𝑄 ∗
= ( + )
𝑌(𝑄 ∗ ) 2 𝑄 ∗ 𝑄 ′
𝒉𝑸′ 𝑨𝑫
𝟐 + 𝑸′ 𝒉𝑸′ 𝑨𝑫 √𝒉𝑸′ √𝑨𝑫 𝟏 𝒉 𝟐𝑨𝑫 𝟏
= + = + = (√ 𝑸′ + √ )
√𝟐𝐀𝐃𝐡 𝟐√𝟐𝐀𝐃𝐡 𝑸′√𝟐𝐀𝐃𝐡 𝟐√𝟐𝐀𝐃 𝑸′√𝟐𝒉 𝟐 𝟐𝑨𝑫 𝒉 𝑸′
∗
𝟏 𝑸′ 𝑸
= ( + )
𝟐 𝑸∗ 𝑸′
To appreciate that, suppose Q’=2Q*, which implies that we use a lot size twice as large as optimal. Then,
the ratio of the resulting holding plus setup cost to the optimum is 1/2(2+1/2) = 1.25. That is, a 100 percent
error in lot size results in a 25% error in cost. Notice that if Q’=Q*/2, we also get an error of 25 percent in
the cost function.
Page 7 of 29
→ →
𝒀(𝑸′) 𝟏 𝟐𝑸∗ 𝑸∗ 𝟏 𝟏
∗
= ( ∗
+ ∗
) = (𝟐 + ) = 𝟏. 𝟐𝟓
𝒀(𝑸 ) 𝟐 𝑸 𝟐𝑸 𝟐 𝟐
Take double lot size →25% error (increase) in cost →cost is “insensitive” to lot size
Half in lots-size
𝟏 ∗
′
𝟏 ∗ 𝟏 𝟐𝑸 𝑸∗ 𝟏 𝟏
𝑸 = 𝑸 = ( ∗ + ) = ( + 𝟐) = 𝟏. 𝟐𝟓
𝟐 𝟐 𝑸 𝟏 ∗ 𝟐 𝟐
𝑸
𝟐
We can get further sensitivity insights from the EOQ model with respect to order interval. Similar to the
previous case, the ratio of the cost resulting from an arbitrary order interval T’ and the optimal cost:
T*→Y(T*) Q
T’→Y(T’)
𝒀(𝑻′ )
𝒀(𝑻∗)
≥𝟏 Q’
∗
𝑸
𝑻∗ =
𝑫
𝑸
𝑻 = 𝑫 → 𝑸 = 𝑻𝑫 → 𝑻 ↔ 𝑸
T’ T
𝒀(𝑻∗ ) = √𝟐𝑨𝑫𝒉
𝒉𝑸′ 𝑨𝑫
𝒀(𝑻′ ) = 𝟐
+ 𝑸′
where Q’ = T’ D
𝒉𝑻′𝑫 𝑨𝑫 𝒉𝑻′𝑫 𝑨
𝒀(𝑻′ ) = + = +
𝟐 𝑻′𝑫 𝟐 𝑻′
𝒉𝑻′𝑫 𝑨
𝒀(𝑻′ ) 𝟐 + 𝑻′ 𝑻′√𝒉𝑫 √𝑨 𝟏
√
𝒉𝑫 ′
√
𝟐𝑨 𝟏 𝟏 𝑻′ 𝑻∗
= = + = ( 𝑻 + )= ( ∗+ )
𝒀(𝑻∗ ) √𝟐𝑨𝑫𝒉 𝟐√𝟐𝑨 𝑻′√𝟐𝒉𝑫 𝟐 𝟐𝑨 𝒉𝑫 𝑻∗ 𝟐 𝑻 𝑻′
Ex: T’ = 2 T*
Page 8 of 29
T’= ½ T*
Only 25% increase in cost
𝟏 𝟏
(𝟐 + ) = 𝟏. 𝟐𝟓
𝟐 𝟐
Now, suppose that the optimal order interval T* is represented in weeks, and lies between 2m and 2m+1 for
some integer m. We choose 2m if T* lies in the interval [2m, 2m√2] and 2m+1 otherwise. Then, the error is
guaranteed to be no more than 6%.
2m ≤ T* ≤ 2m+1 m is an integer
T* = 5 weeks
22 ≤ T* ≤ 23 →m=2
If 2m ≤ T* ≤ √𝟐 2m → T’ = 2m choose T’ as order interval
If √𝟐2m ≤ T* ≤ 2m+1 → T’ = 2m+1 → 4….5.66………8 → T’ = 4
Then the question is how much the cost change is, if we apply this ordering rule.
Case 1
2m ≤ T* ≤ √𝟐 2m → T’ = 2m
𝒀(𝑻′ ) 𝟏 𝟐𝒎 𝑻∗ Cost
𝒀(𝑻∗)
= 𝟐 ( 𝑻∗ + 𝟐𝒎 )
(T*)2 = (2m)2
T* = 2m
𝟏 𝟐𝒎 𝟐𝒎 T*
If T* = 2m → ( 𝒎 + 𝒎) = 𝟏 T
𝟐 𝟐 𝟐
𝒎
𝟏 𝟐 √𝟐𝟐𝒎 𝟏 𝟏
If T* = √𝟐2m → 𝟐 (√𝟐𝟐𝒎 + 𝟐𝒎 ) = (√𝟐 +
𝟐 √𝟐
) = 𝟏. 𝟎𝟔
2m 2m+1
𝒀(𝑻′ )
𝒀(𝑻∗)
≤ 𝟏. 𝟎𝟔 → error is less than 6%
Case 2
√𝟐2m ≤ T* ≤ 2m+1 → T’ = 2m+1
𝒀(𝑻′ ) 𝟏 𝟐𝒎+𝟏 𝑻∗
= ( + )
𝒀(𝑻∗ ) 𝟐 𝑻∗ 𝟐𝒎+𝟏
T* = 2m+1
𝟏
If T* = 2m+1 → 𝟐 (𝟏 + 𝟏) = 𝟏
𝟏 𝟏
If T* = √𝟐2m → 𝟐 (√𝟐 + ) = 𝟏. 𝟎𝟔
√𝟐
′
𝒀(𝑻 )
< 1. 𝟎𝟔
𝒀(𝑻∗ )
Page 9 of 29
𝒀(𝑻′ )
≤ 𝟏. 𝟎𝟔
𝒀(𝑻∗ )
(6% maximal increase in cost (Under this policy, an order is released every 2m
weeks with some integer m)
This approach is called optimal power-of-2 policy. This result is useful in multiproduct settings, where it is
desirable to order such that different products are frequently replenished at the same time (e.g. to facilitate
sharing of delivery trucks). That is, make the order interval 1 week, 2 weeks, 4 weeks, 8 weeks, and so
forth. The result is that items ordered at 2n-week intervals will be placed at the same time as orders for items
with 2k intervals for all k smaller than n. This will facilitate sharing of trucks, consolidation of ordering
efforts, simplification of shipping schedules. If the increases in holding and order costs of all the items (no
more than 6%) are offset by the reduction of such costs, the power-of-2 order schedule is worthwhile.
1. Consider that we have multiple products and we follow this policy, for example considerer 3
products.
Product 1 → T’ = 2
Product 2 → T’ = 4
Product 3 → T’ = 8
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
A product ordered every 2n weeks is ordered at the same time as those with 2k intervals when
k≤n
23 → 22 2’
22 → 2’
So, we are getting many benefits at the expense of 6% cost income in the worst case.
T’ = 23 order internal
T’ = 8 weeks = 8/52 years = 0.15 x years
𝒀(𝑻′ ) 𝟏 𝑻′ 𝑻∗ 𝟏 𝟖. 𝟕𝟖 𝟖
= ( + ) = ( + ) = 𝟏. 𝟎𝟎𝟒 ≪ 𝟏. 𝟎𝟔
𝒀(𝑻∗ ) 𝟐 𝑻∗ 𝑻′ 𝟐 𝟖 𝟖. 𝟕𝟖
Page 10 of 29
(0.4% error in cost)
Discussions:
𝒀(𝑻′) 𝟏 𝟏
∗
≤ (√𝒏 + )
𝒀(𝒀 ) 𝟐 √𝒏
𝟐𝑨′𝑫
𝑸′ = √
𝒉
That this is optimal
𝒀∗ = √𝟐𝑨𝑫𝒉
𝟐𝑨′𝑫
𝒉√ 𝑨𝑫
𝒉
𝒀′ = + →Actual reactor cost
𝟐 𝟐𝑨′𝑫
√
𝒉
𝟐𝑨′𝑫
𝒉√
𝒉 + 𝑨𝑫
𝟐
𝒀′ √𝟐𝑨′𝑫 𝟏 𝑨′ 𝑨
𝒉 √ +√ )
= = (
𝒀∗ √𝟐𝑨𝑫𝒉 𝟐 𝑨 𝑨′
𝟏 𝟏
𝑨′ = 𝟐𝑨 = (√𝟐 + ) = 𝟏. 𝟎𝟔
𝟐 √𝟐
𝟏 𝟏 𝟏
𝑨′ = 𝑨 = (√𝟐 + ) = 𝟏. 𝟎𝟔
𝟐 𝟐 √𝟐
One extension of EOQ model is to the case in which replenishment is not instantaneous; instead, there is a
finite, but constant and deterministic, production rate. This model is sometimes called the economic
production lot (EPL) model. If we let P represent the production rate (and assume that P > D so that the
system has capacity to keep up with demand), then the EPL model results in the following lot size to
minimize the sum of setup and holding costs:
(P < D cannot fulfill demand) (P
=D continually produces)
Page 11 of 29
2𝐴𝐷
𝑄∗ = √
ℎ(1 − 𝐷/𝑃)
Note that if P=∞, then the product is instantaneity; this formula reduces to the regular EOQ. Otherwise, it
results in a larger lot size to cover for the fact that replenishment items take time to produce. Other variants
of the basic EOQ include backorders (i.e., orders that are not filled immediately, but have to wait until stock
is available), major and minor setups, and quantity discounts among other.
An optimal pattern:
consumption
(P-D) x t1
Q is demanded with rate D
P-D D T x D = Q fact 1
𝑸
𝑻=
𝑫
T
t1 t2
Here Q is demanded with rate P
Q = t1 x P fact 2
𝑸
𝒕𝟏 =
𝑷
𝑸 𝑸
𝒕𝟐 = 𝑻 − 𝒕 𝟏 = −
𝑫 𝑷
Inventory level
𝑸
𝒕𝟏 𝒙(𝑷 − 𝑫) = (𝑷 − 𝑫)
𝑷
𝟏𝑸 𝑸 𝑫 𝑨𝑫 𝑸(𝑷 − 𝑫)
𝒀(𝑸) = [𝑨 + 𝒄𝑸 + (𝑷 − 𝑫) 𝒉] = + 𝒄𝑫 + 𝒉
𝟐𝑷 𝑫 𝑸 𝑸 𝟐𝑷
𝝏𝒀(𝑸) 𝑨𝑫 (𝑷 − 𝑫)
=− 𝟐 + 𝒉=𝟎
𝝏𝑸 𝑸 𝟐𝑷
𝑨𝑫 𝑷 − 𝑫
= 𝒉 → (𝑷 − 𝑫)𝒉𝑸𝟐 = 𝟐𝑷𝑨𝑫
𝑸𝟐 𝟐𝑷
Page 12 of 29
𝟐𝑷𝑨𝑫 𝟐𝑨𝑫
𝑸∗ = √ =√
(𝑷 − 𝑫)𝒉 𝒉(𝟏 − 𝑫/𝑷)
2 EPL + Backorder
Order
3 EOQ + Stockout
Q
Variations Models can be formed and analyzed
q
Lost sales
4 EPL + Stockout
Page 13 of 29
Seasonal demands. E.g., umbrella, (Demand is constant)
1.2 Dynamic Lot Sizing refrigerator, fan
When demand varies over time, a continuous time model, like the EOQ model, is awkward to specify. So,
instead, we will clump demand into discrete time periods, which could correspond to days, weeks, or
months, depending on the system. A daily production schedule might make sense for a high-volume system
with rapidly changing demand, while a monthly changing schedule may be adequate for a low-volume
system with demand that changes more slowly.
1 Forecast demands for future periods (days, weeks and month) using some forecasting
technique
planning horizon
In this context we discuss the optimal problem. Determine optimal order schedule over a planning
horizon.
Notations:
t = a time period (we will assume weeks, but any interval could be used); the range of time periods is
t = 1, …, T, where T represents the planning horizon
Dt = demand in week t (in units)
ct = unit production cost (in dollars per unit), not counting setup or inventory cost in week t
At = setup cost to produce (purchase) a lot in week t (in dollars)
ht = inventory holding cost to carry a unit of inventory from week t to week t+1 (in dollars per unit per
week);
(Per period, in week t)
It = inventory (in units) leftover at the end of week t
Page 14 of 29
Qt = lot size (in units) in week t; there are T such decision variables, one for each week
(but we are using I1 for simplification of formulas)
I0 I1 I2 It IT
Q1 Q2 Q3 Qt QT
! 2 3 t … T
D1 D2 D3 Dt DT
C1 C2 C3 Ct CT
A1 A2 A3 At AT
h1 h2 h3 ht hT
I t 1 Qt Dt I t t 1,2,.., T
Qt period t
It-1 Dt It
Qt (no lead time)
I balance equations
t=1 I0 + Q1 - D1 = I1
t=2 I1 + Q2 – D2 = I2
t=t It-1 + Qt – Dt = It
…
t=T IT-1 + QT – DT = IT
D1, D2, parameters, not variables
Lot-for-lot rule: the simplest lot-sizing procedure one might think of is to produce exactly what is
required in each week.
Page 15 of 29
t 1 2 3 4 5 6 7 8 9 10 Total
Dt 20 50 10 50 50 10 20 40 20 30 300
Qt 20 50 10 50 50 10 20 40 20 30 300
It 0 0 0 0 0 0 0 0 0 0 0
Setup cost 100 100 100 100 100 100 100 100 100 100 1000
Holding cost 0 0 0 0 0 0 0 0 0 0 0
Total cost 100 100 100 100 100 100 100 100 100 100 1000
At=$100 for all t, ht =$1 for all t, ct=constant for all t, I0 = 0
No inventory cost
Setup in every period → too much setup cost
Fixed order quantity rule: Another plausible policy is to produce a fixed amount each time we perform a
setup.
t 1 2 3 4 5 6 7 8 9 10 Total
Dt 20 50 10 50 50 10 20 40 20 30 300
Qt 100 0 0 100 0 0 100 0 0 0 300
It 80 30 20 70 20 10 90 50 30 0 0
Setup cost 100 0 0 100 0 0 100 0 0 0 300
Holding cost 80 30 20 70 20 10 90 50 30 0 400
Total cost 180 30 20 170 20 10 190 50 30 0 700
At=$100 for all t, ht =$1 for all t, ct=constant for all t, I0 = 0
IP formulation:
∑[𝑨𝒕 𝒚𝒕 + 𝒄𝒕 𝑸𝒕 + 𝒉𝒕 𝑰𝒕 ]
𝒕=𝟏
yt = 0 if Qt = 0
yt = 1 if Qt > 0
s.t.
1. Qt ≤ Myt t = 1,2,…,T
M is a large number
If Qt = 0 yt → 0 or 1 →minimize problem, so yt will be 0
Page 16 of 29
If Qt > 0 yt = 1
2. It-1 + Qt – Dt = It t = 1, …, T
4. yt = 0 or 1 t = 1, …, T
Just in case
M ≥ Σ Dt Think about this
Why?
Then you do not limit your solution space
You are considering all possible/ feasible solutions
Consider the case when you order all at t = 1
We used ΣhtIt for inventory cost. Let’s examine this.
Assume that demand is constant in each period.
Inventory behavior:
I0
Q1
I1
1 2 T
𝑰𝟎 + 𝑸𝟏 + 𝑰𝟏 𝑰𝟏 + 𝑸𝟐 + 𝑰𝟐 𝑰𝑻−𝟏 + 𝑸𝑻 + 𝑰𝑻
= 𝒉𝟏 + 𝒉𝟐 + ⋯ + 𝒉𝑻
𝟐 𝟐 𝟐
𝒉𝟏 𝑰𝟎 (𝒉𝟏 + 𝒉𝟐 )𝑰𝟏 (𝒉𝟐 + 𝒉𝟑 )𝑰𝟐 (𝒉𝑻−𝟏 + 𝒉𝑻 )𝑰𝑻−𝟏 𝒉𝑻 𝑰𝑻 𝒉𝟏 𝑸𝟏 + 𝒉𝟐 𝑸𝟐 + ⋯ + 𝒉𝑻 𝑸𝑻
= + + + ⋯+ + +
𝟐 𝟐 𝟐 𝟐 𝟐 𝟐
Suppose, ht = h for all t
𝒉𝑰𝟎 𝒉𝑰𝑻 𝒉 ∑ 𝑸𝒕
= + 𝒉𝑰𝟏 + 𝒉𝑰𝟐 + ⋯ + 𝒉𝑰𝑻−𝟏 + +
𝟐 𝟐 𝟐
Page 17 of 29
A key observation for solving the dynamic lot-sizing problem is that if we produce items in week t (and
incur a set up cost) for use to satisfy demand in week t+1, then it cannot possibly be economical to produce
in week t+1 (and incur another setup cost). Either it is cheaper to produce all of week t+1’s demand in week
t, or all of it in t+1; it is never cheaper to produce some in each. (Notice that we violated this property in
the fixed order quantity rule). In more general terms, we can state this result as follows:
It-1 = 0
Dt = 50 Dt+1 = 100 Qt = 70 Qt+1 = 80
It = 20 It+1 = 0
t t+1
Wagner-Whitin Property: Under an optimal lot-sizing policy either the inventory carried to week t+1 from
a previous week will be zero or the production quantity in week t+1 will be zero.
t t+1
The Wagner-Whitin property greatly facilitates computation of optimal production quantities. It implies
that either Qt=0 or Qt will be exactly enough to satisfy demand in the current week plus some integer number
of future weeks. We could compute the minimum-cost production schedule by enumerating all possible
combinations of weeks in which production occurs. However, since we can either produce or not produce
in each week, the number of such combinations is 2T-1, which can be quite large if many weeks are
considered. To be more efficient, Wagner and Whitin (1958) suggested an algorithm that is well suited to
computer implementation.
→ satisfy WW property
Page 18 of 29
Qt > 0 It > 0
It-1 = 0 Qt+1 = 0
Z1 Z2 Zt* ZT*
1 period 2 periods t periods So, we are solving T Zt*
Problem problem problem problems
Alt t → produce Dt in 1
Step 1: We begin the algorithm by looking at the 1-week problem. The optimal policy for this problem is
trivial; we produce 20 units to satisfy demand in week 1, and we are done. Since there is no inventory
carried from one week to another, and we are neglecting production cost, the minimum cost in the 1-
week problem, which we denote by Z1*, is
Page 19 of 29
Z1* = A1 = 100
The last week of production in the 1-week problem, which we denote by j1*, is
j1* = 1
At = $100 ht = $1 1
Only one choice → produce 20 D1 = 20
Z1* = A1 = 100
jt* : last week of production in t – week problem.
jt* = 1
Step 2: In the next step of the algorithm we increase the time horizon and consider the 2-week problem.
Now we have two options for the production in week 2; we can cover demand in week 2 with
production either week 1 or in week 2. If we produce if in week 1, we will incur a holding cost
associated with carrying inventory from week 1 to week 2. If we produce it in week 2, we will incur
an extra setup cost in week 2. Notice also that if we produce in week 2, then the cost of satisfying
previous demand is given by Z1*. Since we are trying to minimize cost, the optimal policy is to choose
the week with the lower total cost, that is,
The optimal decision is to produce for both weeks 1 and 2 in week 1. Therefore, the last week in
which production takes place in an optimal 2-week policy is
j2* = 1 1 2
20 50
Case 1
I1 = 0
Z1* + A2 + 0 = 100 + 100 = 200
Independent problem 1 week problem + optimal cost of 1-week Z1*
Case 2
50
A1 + I1h1 = 100 + 50 = 150
Page 20 of 29
Step 3: Now, we proceed to the 3-week problem. Ordinarily four possible production schedules would need
to be considered: produce in week 1 only, produce in weeks 1 and 2, produce in weeks 1 and 3, or
produce in weeks 1, 2, and 3. However, we need to consider only three of these: one only, one and
two, and one and three. This is because we need to consider only when we are going to produce the
demand for week 3. We have already solved the 2- and 1-week problems. If we decide to produce in
week 3, then we know from our solution to the 2-week problem that it will be optimal to produce for
weeks 1 and 2 in week 1. The savings in computation from this observation grow sharply as the
number of weeks grows.
j3* = 1 1 2 3
20 50 10
Z3* = min → optimal cost when producing D3 in week 3 (case 1)
→ optimal cost when producing D3 in week 2 (case 2)
→ optimal cost when producing D3 in week 1 (case 3)
Case 1
Z2*
I2 = 0
Z2* + A3 + 0 = 150 + 100 = 250
Case 2
Z1*
I2 = 10 because I1 = 0
Case 3
Z1*
I1 = 60 I2 = 10
Step 4: The situation changes when we move to the next step, the 4-week problem. Now, there are four
options for the timing of production for week 4, namely weeks 1 to 4:
Page 21 of 29
This time, it turns out to be optimal not to produce in week 1, but rather to meet week 4’s demand
with production in week 4. Hence,
j4* = 4 1 2 3 4
20 50 10 50
Z4* = min
Z3* + A4 = 170 + 100 = 270
Z2* + A3 + I3h3 = 150 + 100 + 50 = 300
Z1* + A2 + I2h2 + I3h3 = 100 + 100 + 60 + 50 = 310
A1 + I1h1 + I2h2 + I3h3 = 100 + 110 + 60 + 50 =320
If our planning horizon were only 4 weeks, we would be done at this point. We would translate our results
to a lot-sizing policy by reading the jt* values backward in time. The fact that j4* = 4 means that we would
produce D4 = 50 units in week 4. This would leave us with a 3-week problem. Since, j3*=1, it would be
optimal to produce D1+D2+D3 = 80 units in week 1.
80 independent 50 I3 = 0
Optimal schedule →Z4* = 270
Step 5: But, our planning horizon is not 4 weeks; it is 10 weeks. Hence, we must continue the algorithm.
However, before doing this, we will make an observation that will further reduce the computations
we must make.
We can reduce the computations by a property
Planning horizon property: If jt* = l, then, the last week in which production occurs in an optimal t+1 week
policy must be in the set l, l+1, …, t+1.
t t+1
jt* = l produce Dt+1
we only have to consider l~t+1
t+1
t t+1 alternatives → still we can find optimal schedule
t-1 optimal exist along these
l
…* don’t have to consider
jt+1* cannot be here, keys to find optimal schedule
Page 22 of 29
Using this property, the calculation required to compute minimum cost for the 5-week problems is
J5*=4
1 2 3 4 5
20 50 10 50 50
Z5* = min produce in 5 Z4* + A5 = 210 + 100 = 310
Produce in 4 Z3* + A4 + I4h4 = 170 + 100 + 50 = 320
X in 3
X in 2
X in 1
j5*=4
We solve the remaining 5 weeks, using the same approach. The results are in the table below.
Planning horizon t
1 2 3 4 5 6 7 8 9 10
1 100 150 170 320
2 200 210 310
3 250 300
4 270 320 340 400 560
5 370 380 420 540
6 420 440 520
7 440 480 520 610
8 500 520 580
9 580 610
10 620
Zt* 100 150 170 270 320 340 400 480 520 580
jt* 1 1 1 4 4 4 4 7 7 or 8 8
Either one is
fine, so, it is better to
choose 8 for less
computation
We are solving 10-week problem
It is optimal to produce week 8
J10* = 8
7 week problem
Week 1 = 80
Week 4 = 130
Week 8 = 90
Page 23 of 29
Discussion:
1. Safety Stocks
We assumed deterministic demand, there can be uncertainly
Dt 99% target
Dt + S
It
It-1 + Qt ≥ Dt + S
≡ It-1 + Qt - Dt ≥ S
≡ It ≥ S
So, when we consider safety stock.
same formulation but
It ≥ 0 replace this with It ≥ S
2. Lead time L = 3
1 2 3 4 5 T
I0 I1 I2 I3 I4 I5 …. IT
Q-1 Q0 Q1 QT-1
Qt-L = constant
if t-L ≤ 0 ordered before but not received yet.
I0, I1, I2, …., Il all constants
Page 24 of 29
3. Capacity constraints
Order capacity Qt ≤ a due to production limits, transportation limits
Inventory capacity It ≤ b storage limits
Lot-sizing in a supply network, which is planning material flow through procurement, production,
and distribution to fulfill external demands, is a major driver of the costs and customer service.
Because of its practical importance, the lot-sizing is among the most widely researched areas in
operational supply network management.
When external demand pattern is dynamic, rolling horizon updating is a standard operational means
of incorporating new information available over time. The dynamic lot-sizing problem over a
planning horizon makes a plan that minimizes order and inventory costs, while satisfying forecasted
external demands.
Since the stochastic nature of a supply network can be incorporated through the use of safety buffers
and rolling horizon updating, deterministic dynamic lot-sizing problem is a general framework for
the supply network planning.
Though some problem models can be solved in polynomial time, in general, the dynamic lot-sizing
problem is hard.
Page 25 of 29
1.3.1 Background
Handled by ERP information systems, combining internal models of dynamic lot sizing.
Usually, solved independently by each supply network party.
Page 26 of 29
1.4 Closed-loop Supply Networks -- Dynamic Lot-sizing
Now, consider a closed-loop supply network as shown in the figure below. This system includes
remanufacturing, differently from the forward supply network we have discussed so far.
Forward
Nature Manufacturing
Customers
Remanufacturing
Serviceable
Inventory Used
products
Returns
Inventory
Backward
A simple model: Forward Closed loop
Page 27 of 29
Page 28 of 29
Optional Reference: Factory Physics, Hopp and Spearman, 2011) Chapters 2 & 3
Further Reading (OPTIONAL) – Sample of Recent and Current Research Issues in this topic
area
Page 29 of 29