order quantities when demand is approximately level
DESCRIPTION
Order Quantities when Demand is Approximately Level. Chapter 5 Inventory Management Dr. Ron Tibben-Lembke. Inventory Costs. Costs associated with inventory: Cost of the products Cost of ordering Cost of hanging onto it Cost of having too much / disposal - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/1.jpg)
Order Quantities when Demand is
Approximately Level
Order Quantities when Demand is
Approximately LevelChapter 5
Inventory Management
Dr. Ron Tibben-Lembke
![Page 2: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/2.jpg)
Inventory CostsInventory Costs
Costs associated with inventory: Cost of the products Cost of ordering Cost of hanging onto it Cost of having too much / disposal Cost of not having enough (shortage)
![Page 3: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/3.jpg)
Shrinkage CostsShrinkage Costs
How much is stolen? 2% for discount, dept. stores, hardware,
convenience, sporting goods 3% for toys & hobbies 1.5% for all else
Where does the missing stuff go? Employees: 44.5% Shoplifters: 32.7% Administrative / paperwork error: 17.5% Vendor fraud: 5.1%
![Page 4: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/4.jpg)
Inventory Holding Costs
Inventory Holding Costs
Category % of Value
Housing (building) cost 6%
Material handling 3%
Labor cost 3%
Opportunity/investment 11%
Pilferage/scrap/obsolescence 3%
Total Holding Cost 26%
![Page 5: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/5.jpg)
ABC Analysis
Divides on-hand inventory into 3 classes A class, B class, C class
Basis is usually annual $ volume $ volume = Annual demand x Unit cost
Policies based on ABC analysis Develop class A suppliers more Give tighter physical control of A items Forecast A items more carefully
![Page 6: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/6.jpg)
Classifying Items as ABC
0
20
40
60
80
100
0 50 100 150
0
20
40
60
80
100
0 50 100 150
% of Inventory Items% of Inventory Items
% Annual $ Usage% Annual $ Usage
AA
BB CC
![Page 7: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/7.jpg)
ABC Classification Solution
Stock # Vol. Cost $ Vol. % ABC
206 26,000 $ 36 $936,000
105 200 600 120,000
019 2,000 55 110,000
144 20,000 4 80,000
207 7,000 10 70,000
Total 1,316,000
![Page 8: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/8.jpg)
ABC Classification Solution
Stock # Vol. Cost $ Vol. % ABC
206 26,000 $ 36 $936,000 71.1 A
105 200 600 120,000 9.1 A
019 2,000 55 110,000 8.4 B
144 20,000 4 80,000 6.1 B
207 7,000 10 70,000 5.3 C
Total 1,316,000 100.0
![Page 9: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/9.jpg)
Economic Order Quantity
Economic Order Quantity
Assumptions Demand rate is known and constant No order lead time Shortages are not allowed Costs:
A - setup cost per order v - unit cost r - holding cost per unit time
![Page 10: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/10.jpg)
EOQEOQ
Time
Inventory Level
Q*OptimalOrderQuantity
Decrease Due toConstant Demand
![Page 11: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/11.jpg)
EOQEOQ
Time
Inventory Level
Q*OptimalOrderQuantity
InstantaneousReceipt of OptimalOrder Quantity
![Page 12: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/12.jpg)
EOQEOQ
Time
Inventory Level
Q*
Lead Time
ReorderPoint(ROP)
![Page 13: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/13.jpg)
EOQEOQ
Time
Inventory Level
Q*
Lead Time
ReorderPoint(ROP)
Average Inventory Q/2
![Page 14: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/14.jpg)
Total CostsTotal Costs
Average Inventory = Q/2 Annual Holding costs = rv * Q/2 # Orders per year = D / Q Annual Ordering Costs = A * D/Q Annual Total Costs = Holding + Ordering
Q
DA
QvrQTC *
2*)(
![Page 15: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/15.jpg)
How Much to Order?How Much to Order?
Annual Cost
Order Quantity
Holding Cost= H * Q/2
![Page 16: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/16.jpg)
How Much to Order?How Much to Order?
Annual Cost
Order Quantity
Holding Cost= H * Q/2
Ordering Cost= A * D/Q
![Page 17: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/17.jpg)
How Much to Order?How Much to Order?
Annual Cost
Order Quantity
Total Cost= Holding + Ordering
![Page 18: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/18.jpg)
How Much to Order?How Much to Order?
Annual Cost
Order Quantity
Total Cost= Holding + Ordering
Optimal Q
![Page 19: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/19.jpg)
Optimal QuantityOptimal Quantity
Q
DA
Qvr *
2* Total Costs =
![Page 20: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/20.jpg)
Optimal QuantityOptimal Quantity
Q
DA
Qvr *
2* Total Costs =
2*
2 Q
DA
vr
Take derivative with respect to Q =
![Page 21: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/21.jpg)
Optimal QuantityOptimal Quantity
Q
DA
Qvr *
2* Total Costs =
2*
2 Q
DA
vr
Take derivative with respect to Q =
Set equal to zero0
![Page 22: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/22.jpg)
Optimal QuantityOptimal Quantity
Q
DA
Qvr *
2* Total Costs =
2*
2 Q
DA
vr
Take derivative with respect to Q =
Solve for Q:
22 Q
DAvr
Set equal to zero0
![Page 23: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/23.jpg)
Optimal QuantityOptimal Quantity
Q
DA
Qvr *
2* Total Costs =
2*
2 Q
DA
vr
Take derivative with respect to Q =
Solve for Q:
22 Q
DAvr
Set equal to zero0
vr
ASQ
22
![Page 24: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/24.jpg)
Optimal QuantityOptimal Quantity
Q
DA
Qvr *
2* Total Costs =
2*
2 Q
DA
vr
Take derivative with respect to Q =
Solve for Q:
22 Q
DAvr
Set equal to zero0
vr
ASQ
22 vr
ASQ
2
![Page 25: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/25.jpg)
SensitivitySensitivity
Suppose we do not order optimal EOQ, but order Q instead, and Q is p percent larger
Q = (1+p) * EOQ Percentage Cost Penalty given by:
EOQ = 100, Q = 150, so p = 0.5
50*(0.25/1.5) = 8.33 a 8.33% cost increase
p
p
150PCP
2
![Page 26: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/26.jpg)
Figure 5.3 SensitivityFigure 5.3 Sensitivity
Percentage Cost Penalty using Q different from the EOQ
-5
0
5
10
15
20
25
30
-0.6 -0.4 -0.2 0 0.2 0.4 0.6
p
PC
P
![Page 27: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/27.jpg)
A Question:A Question:
If the EOQ is based on so many horrible assumptions that are never really true, why is it the most commonly used ordering policy?
![Page 28: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/28.jpg)
Benefits of EOQ Benefits of EOQ
Profit function is very shallow Even if conditions don’t hold
perfectly, profits are close to optimal Estimated parameters will not throw
you off very far
![Page 29: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/29.jpg)
Tabular Aid 5.1Tabular Aid 5.1
For A = $3.20 and r = 0.24% Calculate Dv =total $ usage (or sales) Find where Dv fits in the table Use that number of months of supply D = 200, v = $16, Dv=$3,200 From table, buy 1 month’s worth Q = D/12 = 200/12 = 16.7 = 17
![Page 30: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/30.jpg)
How do you get a table?
How do you get a table?
Decide which T values you want to consider: 1 month, etc.
Use same v and r values for whole table For each neighboring set of T’s, put them
into
rTT
ADv
21
288
![Page 31: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/31.jpg)
How do you get a table?
How do you get a table?
For example, A = $3.20, r = 0.24 To find the breakpoint between 0.25 and 0.5 Dv = 288 * 3.2 / (0.25 * 0.5 * 0.24) = 921.6 / 0.03 = 30,720 So if Dv is less than this, use 0.25, more
than that, use 0.5 Find 0.5 and 0.75 breakpoint: Dv = 288 * 3.2/(0.5 * 0.75 * 0.24) = 10,2240
![Page 32: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/32.jpg)
Why care about a table?
Why care about a table?
Some simple calculations to get set up No thinking to figure out lot sizes Every product with the same ordering cost
and holding cost rate can use it Real benefit - simplified ordering
Every product ordered every 1 or 2 weeks, or every 1, 2, 3, 4, 6, 12 months
Order multiple products on same schedule: Get volume discounts from suppliers Save on shipping costs Savings outweigh small increase from non-EOQ orders
![Page 33: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/33.jpg)
Uncoordinated OrdersUncoordinated Orders
Time
![Page 34: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/34.jpg)
Simultaneous OrdersSimultaneous Orders
TimeSame T = number months supply allows firm to order atsame time, saving freight and ordering expensesAdjusted some T’s, changed order times
![Page 35: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/35.jpg)
Offset OrdersOffset Orders
Same T = number months supply allows firm to control maximum inventory level by coordinating replenishmentsWith different T, no consistency
![Page 36: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/36.jpg)
Quantity DiscountsQuantity Discounts
How does this all change if price changes depending on order size?
Explicitly consider price:
vr
ADQ
2
![Page 37: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/37.jpg)
Discount ExampleDiscount Example
D = 10,000 A = $20 r = 20%
Price Quantity EOQv = 5.00 Q < 500 633
4.50 501-999 6663.90 Q >= 1000 716
![Page 38: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/38.jpg)
Discount PricingDiscount Pricing
Total Cost
Order Size500 1,000
Price 1 Price 2 Price 3
X 633
X 666
X 716
![Page 39: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/39.jpg)
Discount PricingDiscount Pricing
Total Cost
Order Size500 1,000
Price 1 Price 2 Price 3
X 633
X 666
X 716
![Page 40: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/40.jpg)
Discount ExampleDiscount Example
Order 666 at a time:Hold 666/2 * 4.50 * 0.2= $299.70Order 10,000/666 * 20 = $300.00Mat’l 10,000*4.50 = $45,000.00 45,599.70
Order 1,000 at a time:Hold 1,000/2 * 3.90 * 0.2=$390.00Order 10,000/1,000 * 20 = $200.00Mat’l 10,000*3.90 = $39,000.00 39,590.00
![Page 41: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/41.jpg)
Discount Model Discount Model
1.Compute EOQ for each price
2.Is EOQ ‘realizeable’? (is Q in range?)
If EOQ is too large, use lowest possible value. If too small, ignore.
3.Compute total cost for this quantity
4.Select quantity/price with lowest total cost.
![Page 42: Order Quantities when Demand is Approximately Level](https://reader036.vdocuments.us/reader036/viewer/2022081506/5681574c550346895dc4ed90/html5/thumbnails/42.jpg)
Adding Lead TimeAdding Lead Time
Use same order size
Order before inventory depleted R = DL where:
D = annual demand rate L = lead time in years
vr
DAQ
2