Inventory Management in Supply Chains
Inventory Management in Supply Chains
upply
S
me nt
a ge
Man
Inventory Management
Hussan Peavey
Assistant Professor of Professional Practice
Department of Supply Chain Management
Rutgers Business School
100 Rockafeller Road, Piscataway, NJ 08854
Tel: 848-445-9473 | Email: hussan@[Link]
Website: [Link]
Introduction
A key decision in any product-based supply chain is how much
inventory to keep on hand.
Inventory is usually one of the company’s largest assets, so
careful management of that asset is an essential business
requirement.
Maintaining adequate _________________________ allows a
company to fill customer orders immediately
Maintaining adequate _________________allows a company to
support manufacturing operations and the production plan
while avoiding delays.
Failing to manage inventory adequately can lead to significant
issues and inefficiencies throughout the supply chain, including
dissatisfied customers, lost sales and revenue, and higher costs.
2
What is Inventory?
Inventory is the __________________________________
___________________________.
Includes all of the materials used to support production, all of the
finished products needed to provide customer service, and all of the
other supplies needed to run a business.
Inventory is one of the most
important assets of an organization.
Holding some inventory may be
necessary to maintain operations and
ensure that products are available
when customers demand them.
Work in
Raw Materials Finished Goods
Process
Raw Work in
Finished Goods
Material Process
• Some MRO items are consumed during the process of converting raw
materials into finished goods, e.g., oil for the manufacturing equipment.
• Other MRO items are used to facilitate the manufacturing operation, e.g.,
cleaning supplies, spare parts, etc.
• While still other MRO items may be used to facilitate the company’s
administrative activities, e.g., office supplies, coffee for the break room, etc.
Raw Work in
Finished Goods
Material Process
• Restaurants can inventory the food, tableware, and other elements of the dining
operation as these are facilitating goods necessary to provide the service.
• Restaurants can even prepare some of their meal options in advance, such as salads
or deserts. They can inventory these facilitating products so they are ready to go
when the customers arrive for the dining service.
10
Functions of Inventory - Why hold inventory?
1. To Meet Customer Demand (cycle stock):
Immediately fill customer orders
Deploy the product / material near where it will be used
2. To Buffer Against Uncertainty in Demand and/or Supply (safety stock):
Uncertainty in demand: sales or usage above expectations
or both
Uncertainty in supply: shortages, delays, disruptions
3. To Decouple Supply from Demand (strategic stock):
Supply pattern is different from demand pattern:
– Achieve economies of scale in purchasing; take advantage of volume price breaks/discounts
– Speculative buying in anticipation of a price increase e
e parat
– Economical order size, lot size, production output s
u p le =
o
Dec
– Seasonal products/demand
4. To Decouple Dependencies in the Supply Chain (strategic stock):
Separating operations in a process
Smoothing production and reducing peak period capacity needs
11
Inventory Management
The function of planning and controlling inventories.
The goal of inventory management is to help a company be more profitable
by ___________________________and/or by _______________.
In an effort to achieve this stated goal, effective inventory management
balances two competing considerations:
— Reducing the amount of inventory held in stock, while . . .
— Ensuring there is enough inventory to satisfy customer demand.
External Inventory 14
Safety Stock
Safety stock, also known as Internal Inventory
“buffer stock,” is inventory that Obsolete Inventory
Stock that is expired, out-of-date, or no longer needed.
is above and beyond what is
actually needed to meet
anticipated demand. Strategic Stock
Reported
A quantity of stock planned to Stock
be in inventory to protect Safety Stock level
against ___________________
__________.
Cycle Stock
Companies operating in a
make-to-stock environment will
generally maintain some
amount of safety stock whether
Pipeline Inventory
Inventory in transit.
based on a management Inventory held / owned by suppliers, or by
wholesalers, distributors, retailers, and customers.
decision, or based on a safety
stock determination formula.
External Inventory 15
Practical use of Safety Stock (Example: Pharmaceuticals)
Active
Ingredients NO Safety Stock Maintained:
× Due to long term stability concerns
Safety Stock
(Centrally Located) × Due to expiry concerns
Package
To respond rapidly to increases
Raw
Materials Components in customer demand
Safety Stock Safety Stock Geographically dispersed close
(by exception only) (by exception only)
to the end customer
Active
Ingredients Dosage
Forms Finished
Goods
Raw
Materials Package
Components
Cumulative Lead Time with Safety Stock to De-Couple AI and FG Lead Times
Chemical Operations Pharmaceutical Operations Distribution 2
12 months 2 Months 1 Month Months
Active
Ingredients Dosage
Safety Stock Forms Finished
(Centrally Located) Goods
Safety Stock
(Geographically Dispersed)
Raw
Materials
Package
Safety Stock Components
(by exception only)
Safety Stock
(by exception only) 17
Strategic Stock
Additional inventory beyond Internal Inventory
cycle and safety stock, generally Obsolete Inventory
used for a __________________ Stock that is expired, out-of-date, or no longer needed.
External Inventory 18
Pipeline Inventory
Internal Inventory
Inventory in the transportation Obsolete Inventory
network and the distribution Stock that is expired, out-of-date, or no longer needed.
Excess Inventory
Target
Inventory Demand Period Demand Period Demand Period Demand Period Demand Period
Level
Month #1 Month #2 Month #3 Month #4 Month #5
Inventory
Replenishment
Point
Cycle Inventory
Internal Inventory
Replenishment
Stock Quantity
Total Inventory
Time
External Inventory
Pipeline
Inventory
“Channel Stock”
Retail Inventory Stockout
Underlying problems being hidden rather than being exposed and solved,
including quality problems not being immediately identified.
No incentive for process improvements .
Inventory Turnover
The number of times that an
inventory cycles, or “turns over,”
during the year.
The more turns, the better !!
25
Inventory Policy – Set Target Inventory Levels
To set target inventory levels for all products and
materials, you need to address these three
fundamental questions:
27
Continuous Review System
As the name implies, inventory levels are ____________________.
As soon as inventory falls below a pre-determined level (i.e., a reorder point),
a replenishment order automatically is triggered.
Advantages:
Allows for real-time updates of inventory, which can make it easier to know
when to replenish.
Facilitates accurate accounting, since the inventory system can generate real-
time costs of goods sold.
Potentially requires less safety stock because inventory is constantly
monitored, and replenishment actions are taken more quickly.
Disadvantage:
Cost of implementation. Generally requires an automated system. The
hardware and software necessary to run the system can be expensive to
purchase, install, and maintain.
28
2. When to Order Inventory?
The lowest inventory level at which a new order must be placed to avoid a stockout
is known as the ________________
The ROP is set at a level that provides enough inventory so demand is covered during
the lead time (L) needed to replenish inventory.
ROP = Demand during Lead Time (dL)
150 Units
ROP = 50 Units
150 Units
ROP = 75 Units
25 Units
Safety Stock = 25 Units
0 Units
A. _______________________:
— Inventory is checked in fixed time periods against a target inventory level.
— If the inventory is less than target, a quantity necessary to bring inventory
back up to the target level is ordered.
— The amount of inventory ordered will potentially vary from period to
period based on the remaining inventory at each time interval checked.
B. _______________________:
— A continuous inventory review system in which the same order quantity is
used from order to order.
— When the inventory position drops to a predetermined reorder point, a
predetermined fixed order quantity is placed
— The time between orders (i.e., order period) varies from order to order.
32
A. Fixed-Time Period System
The order quantity is the difference between the ______________ on
the review day, and the pre-determined ____________________.
Q = R – IP
where: Q = order quantity
R = target inventory level
IP = inventory position
The order quantity in this system will differ from one order to another
depending on the on-hand quantity on the day of the review.
A target inventory level (R) is established
Inventory levels are checked/reviewed in fixed time periods (T)
If (IP) < (R) then (Q) is ordered and (R) is restored when each new
order is received.
33
B. Fixed-Order Quantity System
If the review determines that an order should be placed, then the
order for a ___________________for that item is placed.
Two main variables to calculate:
– Reorder Point (ROP)
– Order Quantity (Q)
Assumptions:
• A constant demand (d) rate, i.e., not erratic, seasonal, etc.
• Inventory position (IP) is reduced (i.e., consumed/used) by a rate of (d).
• Replenishment order placed when reorder point (ROP) is reached.
• When inventory is received, (IP) increases by the order quantity (Q).
• (Q) computed using the economic order quantity (EOQ) model.
• Lead time (L), i.e., the time between placing an order and receiving delivery
of the order, is known and constant.
• Inventory position (IP) is reviewed on continual basis.
34
The Economic Order Quantity (EOQ) Model
35
Inventory Order Costs & Carrying Costs
Order Costs - incurred each time __________________
Order preparation costs
Order transportation costs
Order receipt processing costs
Material handling costs
Costs ($)
$500
$250 X
carrying
2 x 25 x 5,000 250,000
EOQ = 0.20 x 5.00 = 1
= 250,000 = 500
Proof:
Annual Order Cost = (5,000/500 x $25.00) = 10 x $25 = $250
Annual Carrying Cost = [500/2 x (5 x 0.20)] = 250 x 1 = $250
38
Assumptions of the EOQ Model EOQ =
2 x Order Cost x Annual Volume
Carrying Cost % x Unit Cost
_____________: The model may generate an order quantity which the company
does not have sufficient storage capacity to handle at one time.
____________: The item being ordered and transported may require specialized
or dedicated transportation, impacting the quantity per order.
____________: The model may generate an order quantity which would create
spoilage or obsolescence.
________: The supplier may require the company to order an item in full pack,
case, or pallet configurations.
Because of these constraints and assumptions, the EOQ is
generally only used as a baseline. Supply chain managers
make adjustments to the EOQ based on their judgement
41
Other Types of Inventory Systems
Other types of inventory systems
which are essentially variations on
the basic continuous and periodic
review methods are:
ABC System
Bin System
42
ABC System
An ABC system classifies inventory based the __________
____________:
1. Determine annual usage or sales for each item.
2. Determine % of total usage or sales that each item represents.
3. Rank items from highest to lowest %.
4. Classify items into groups:
A: Highest Value
B: Moderate Value
C: Least Valuable
43
ABC System (continued)
A method to determine which inventories should be counted and
managed more closely than others
Groups inventory as A, B, or C based on a set criterion
A items are given the highest priority. “80/20 rule”
Generally, A items account for approximately 20% of the total
number of items, but about 80% of the total inventory cost.
B & C items account for the other 80% of the total number of
items, but only 20% of total inventory cost.
– B items require closer management since they are
relatively more expensive (per unit), require more effort to
purchase / make, & may be more prone to obsolescence.
– C items have the lowest value, and hence the lowest
priority
44
Bin System
Inventory system that uses either one or two bins to hold a quantity
of the item being inventoried.
It is mainly used for small or low value items.
When the inventory in the first bin has been depleted, an order is placed to
refill or replace the inventory.
The second bin is set up to hold enough inventory to cover demand during the
replenishment lead time so as to last until the replacement order arrives.
1 Demand
Bin #2 Bin #1
Replenish
2 Inventory Demand
Bin #2 Bin #1 45
Base Stock Level System
– A form of just-in-time.
46
Single-Period Model
47
Inventory Control Tools
Many inventory control tools exist in today’s market. Those
that incorporate barcode tracking or RFID tagging generally
offer the most flexibility and ease of use.
Linear Barcode
2D Barcode
48
Barcodes
Barcode systems help businesses track products and stock levels for
inventory management.
_______(1D) Bar Codes are “a series of alternating bars and spaces printed or
stamped on parts, containers, labels, or other media, representing encoded
information that can be read by electronic readers.
— Linear bar codes do have some limitations: they are one-dimensional, can
only be read horizontally, and can only hold a maximum of 85 characters.
___ Bar Codes are a graphical image that stores information both horizontally
and vertically.
— 2D Barcodes can store over 7,000 characters, allowing transmission of
almost two paragraphs of information.
A barcode reader (or barcode scanner) is an electronic device that can read
barcodes and transmit the data to a computer. These might be handheld
cordless devices, corded devices that attach directly to a PC’s USB port, or
computers with integrated laser scanners
49
Radio Frequency Identification (RFID)
Item
50
Radio Frequency Identification (RFID)
52
Measuring Inventory Performance
54