Chap 6
Chap 6
1 2
• Probabilistic Models and Safety Stock • Amazon.com started as a “virtual” retailer – no inventory,
no warehouses, no overhead – just computers taking
• Single-Period Model
orders to be filled by others
• Fixed-Period (P) Systems
• Growth has forced Amazon.com to become a world
leader in warehousing and inventory management
3 4
1
10/26/2023
1. Each order is assigned by computer to the closest 5. Crates arrive at central point where items are boxed and
distribution center that has the product(s) labeled with new bar code
2. A “flow meister” at each distribution center assigns work 6. Gift wrapping is done by hand at 30 packages per hour
crews
7. Completed boxes are packed, taped, weighed and
3. Technology helps workers pick the correct items from labeled before leaving warehouse in a truck
the shelves with almost no errors
8. Order arrives at customer within 1 - 2 days
4. Items are placed in crates on a conveyor, bar code
scanners scan each item 15 times to virtually eliminate
errors
5 6
7 8
2
10/26/2023
The objective of inventory management is to strike a • One of the most expensive assets of many companies
balance between inventory investment and customer representing as much as 50% of total invested capital
service
• Less inventory lowers costs but increases chances of
running out
• More inventory raises costs but always keeps customers
happy
9 10
11 12
3
10/26/2023
13 14
• Divides inventory into three classes based on annual Figure 12.2 Graphic Representation of ABC Analysis
dollar volume
– Class A - high annual dollar volume
– Class B - medium annual dollar volume
– Class C - low annual dollar volume
• Used to establish policies that focus on the few critical
parts and not the many trivial ones
15 16
4
10/26/2023
ABC Calculation • Other criteria than annual dollar volume may be used
– High shortage or holding cost
– Anticipated engineering changes
– Delivery problems
– Quality problems
17 18
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
19 20
5
10/26/2023
• Incoming and outgoing record keeping must be accurate • Items are counted and records updated on a periodic
basis
• Stockrooms should be secure
• Often used with ABC analysis
• Necessary to make precise decisions about ordering,
scheduling, and shipping • Has several advantages
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
21 22
5,000 items in inventory, 500 A items, 1,750 B items, 2,750 • Can be a critical component of profitability
C items
• Losses may come from shrinkage or pilferage
Policy is to count A items every month (20 working days), B
• Applicable techniques include
items every quarter (60 days), and C items every six
months (120 days) 1. Good personnel selection, training, and discipline
Cycle Counting Number Of Items Counted 2. Tight control of incoming shipments
Item Class Quantity Policy Per Day
A 500 Each month 500 twentieths = 25 a day
3. Effective control of all goods leaving facility
500 20 = 25 day
B 1,750 Each quarter 1,750
1,750sixtieths
60 = 29= day
29 a day.
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
23 24
6
10/26/2023
• Independent demand - the demand for item is • Holding costs - the costs of holding or “carrying”
independent of the demand for any other item in inventory over time
inventory
• Ordering cost - the costs of placing an order and
• Dependent demand - the demand for item is dependent receiving goods
upon the demand for some other item in the inventory
• Setup cost - cost to prepare a machine or process for
manufacturing an order
– May be highly correlated with setup time
25 26
27 28
7
10/26/2023
29 30
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
31 32
8
10/26/2023
• By minimizing the sum of setup (or ordering) and holding Q = Number of units per order
costs, total costs are minimized Q* = Optimal number of units per order (EOQ)
• Optimal order size Q* will minimize total cost D = Annual demand in units for the inventory item
• A reduction in either cost reduces the total cost S = Setup or ordering cost for each order
• Optimal order quantity occurs when holding cost and H = Holding or carrying cost per unit per year
setup cost are equal Annual setup cost = (Number of orders placed per year) ×
(Setup or order cost per order)
Annual demand Setup or order
=
Number of units in each order cost per order
D
= S
Q
33 34
35 36
9
10/26/2023
Optimal order quantity is found when annual setup cost Determine optimal number of needles to order
equals annual holding cost
D = 1,000 units
Solving for Q* 2DS = Q 2H S = $10 per order
2DS
Q =2 H = $.50 per unit per year
H
D Q Q* =
2DS 2 DS
S = H Q* =
Q 2 H H
2(1,000)(10)
Q* = = 40,000 = 200 units
0.50
37 38
I = $.50 per unit per year I = $.50 per unit per year
Q* =200 units
Q* =200 units
N = 5 orders/year
Demand D
Expected number of = N = =
Order quantity Q Expected time between orders = T =
Number of working days per year
orders Expected number of orders
1,000
N= = 5 orders per year 250
200 T= = 50 days between orders
5
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
39 40
10
10/26/2023
41 42
• It works even if all parameters and assumptions are D = 1,000 units Q1,000 = 200 units
not met S = $10 per order T = 50 days
• The total cost curve is relatively flat in the area of the H = $.50 per unit per year Q1,500 = 244.9 units
EOQ N = 5 orders/year
43 44
11
10/26/2023
Only 2% less than the total cost of $125 when the order • EOQ answers the “how much” question
quantity was 200
• The reorder point (ROP) tells “when” to order
• Lead time (L) is the time between placing and receiving
an order
Demand Lead time for a new
ROP =
per day order in days
ROP = d x L
D
d=
Number of working days in a year
45 46
D
d=
Number of working days in a year
= 8,000 / 250 = 32 units
ROP = d x L
= 32 units per day × 3 days = 96 units
= 32 units per day × 4 days = 128 units
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
47 48
12
10/26/2023
1. Used when inventory builds up over a period of time Q = Number of units per order p = Daily production
after an order is placed H = Holding cost per unit per year d = Daily demand/usage rate
2. Used when units are produced and sold simultaneously t = Length of the production run in
days
( Annual
holding cost ) (perHolding
unit per year )
Figure 12.6 Change in Inventory Levels over Time for the
Production Model
inventory = ( Average inventory level ) cost
( Annuallevel
inventory
) = (Maximum inventory level ) / 2
( Maximum
inventory level
) (
= Total produced during
the production run
) (− Total used during
the production run
)
= pt − dt
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
49 50
( Maximum
)(= Total produced during
) ( − Total used during
) Setup cost = ( D / Q )S
( )
inventory level the production run the production run 1
HQ 1 −
d
= pt − dt Holding cost =
2 p
However, Q = total produced = pt ; thus t = Q/p
D 1 d
Maximum Q Q d
S =
p
HQ 1 −
inventory level = p p − d p = Q 1 − p Q 2
2 DS 2 DS
d
2
Maximum inventory level Q Q = Q *p =
d d
Holding cost = (H ) =
1 − p H
2
H 1−
p H 1−
2 p
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
51 52
13
10/26/2023
=
20,000
=
Annual demand rate
80,000 H 1 −
0.50(1 2)
Annual production rate
= 282.8 hubcaps, or 283 hubcaps
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
53 54
• Reduced prices are often available when larger quantities Total annual cost = Setup cost + Holding cost + Product cost
are purchased D Q
TC = S+ IP + PD
• Trade-off is between reduced product cost and increased Q 2
holding cost
where Q = Quantity ordered P = Price per unit
Table 12.2 A Quantity Discount Schedule D = Annual demand in units I = Holding cost per unit per
S = Ordering or setup cost per year expressed as a
order percent of price P
Price Range Quantity Ordered Price Per Unit P
Initial price 0 to 119 $100 2DS
Q* =
Discount price 1 200 to 1,499 $ 98 IP
Discount price 2 1,500 and over $ 96 Because unit price varies, holding cost is expressed as a percent (I) of
unit price (P)
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
55 56
14
10/26/2023
Steps in analyzing a quantity discount Figure 12.7 EOQs and Possible Best Order Quantities for the Quantity
Discount Problem with Three Prices in Table 12.2 (see slide 55)
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
57 58
Calculate Q* for every discount Table 12.3 Total Cost Computations for Chris Beehner Electronics
2DS
starting with the lowest price Q* =
IP
2(5,200)($200) Annual Annual Annual
Q$96 * = = 278 drones / order Order Unit Ordering Holding Product Total Annual
(.28)($96) Quantity Price Cost Cost Cost Cost
275 $98 $3,782 $3,773 $509,600 $517,155
Infeasible – calculate Q* for next-higher price 1,500 $96 $693 $20,160 $499,200 $520,053
2(5,200)($200)
Q$98 * = = 275 drones / order Choose the price and quantity that gives the lowest total cost
(.28)($98) Buy 275 drones at $98 per unit
Feasible
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
59 60
15
10/26/2023
• All-units discount is the most popular form • Used when demand is not constant or certain
• Incremental quantity discounts apply only to those • Use safety stock to achieve a desired service level and
units purchased beyond the price break quantity avoid stockouts
• Fixed fees may encourage larger purchases
ROP = d × L + ss
• Aggregation over items or time
• Truckload discounts, buy-one-get-one-free offers,
Annual stockout costs = The sum of the units short for each
one-time-only sales
demand level × The probability of that demand level × The
stockout cost/unit × The number of orders per year
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
61 62
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
63 64
16
10/26/2023
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
65 66
Using Appendix I, for an area under the curve of 95%, the Z = 1.645
67 68
17
10/26/2023
• When data on demand during lead time is not available, Demand is variable and lead time is constant
there are other models available
ROP = (Average daily demand × Lead
1. When demand is variable and lead time is constant time in days) + Z dLT
2. When lead time is variable and demand is constant
3. When both demand and lead time are variable
where dLT = d Lead time
d = Standard deviation of demand per day
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
69 70
71 72
18
10/26/2023
Daily demand (constant) = 10 Both demand and lead time are variable
Average lead time = 6 days ROP = (Average daily demand
× Average lead time) + Z dLT
Standard deviation of lead time = LT = 1
Service level = 98%, so Z (from Appendix I) = 2.055 where d = Standard deviation of demand per day
ROP = (10 units × 6 days) + 2.055(10 units)(1) LT = Standard deviation of lead time in days
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
73 74
75 76
19
10/26/2023
77 78
• Fixed-quantity models require continuous monitoring • Inventory counted only at end of period
using perpetual inventory systems
• Order brings inventory up to target level
• In fixed-period systems orders placed at the end of a – Only relevant costs are ordering and holding
fixed period – Lead times are known and constant
• Periodic review, P system – Items are independent of one another
79 80
20
10/26/2023
Copyright © 2017, 2014, 2011 Pearson Education, Inc. All Rights Reserved
81 82
21