Module – II

Selective Inventory Control: Economic Order Quantity –Importance-

Uses- Safety Stocks – Inventory Management Systems – Forecasting
Techniques – Material Requirement Planning and Execution – Ratio
Analysis on Inventory – Profit Margin.

SELECTIVE INVENTORY CONTROL

Selective Inventory Control
 Selective Inventory Control is a technique where inventory items are
categorized based on their importance, value, or impact on business
operations. This helps businesses focus more on managing the most
important or valuable items and allocate resources effectively.
 The idea is to prioritize certain inventory items that are more valuable or
critical than others, instead of treating all inventory the same.
Types of Selective Inventory Control Methods:
1. ABC Analysis:
o Definition: ABC analysis categorizes inventory items into three
classes based on their value and importance.
 A-items: High-value items with low quantity. These items
make up a small portion of total inventory but contribute a
large portion of sales or profit.
 B-items: Moderate value and moderate quantity. These
items fall between A and C items.
 C-items: Low-value items with high quantity. These make
up the majority of the inventory but contribute the least to
overall sales.
o Explanation:
 A-items require strict control, frequent reviews, and accurate
records because they are expensive and critical for business
success.
 B-items need moderate control, but not as much attention as
A-items.
  C-items can be managed with less controls since they are
less expensive and not as critical to profitability.
o Importance: ABC analysis helps businesses focus more on high-
value items (A-items), which have the most significant financial
impact.
2. VED Analysis:
o Definition: VED stands for Vital, Essential, and Desirable and is
commonly used in managing spare parts inventory.
 Vital items: These are crucial for the operation of the
business. A stockout of these items can halt production or
critical services.
 Essential items: Important but not as critical as vital items.
A stockout can cause inconvenience but not immediate
stoppage.
 Desirable items: These are the least important items, and
their stockouts cause little to no disruption.
o Importance: VED analysis helps in managing spare parts or
materials where some items are absolutely necessary for smooth
operations, while others are less critical.
3. FSN Analysis:
o Definition: FSN stands for Fast-moving, Slow-moving, and Non-
moving items.
 Fast-moving items: Items that are consumed or sold
quickly.
 Slow-moving items: Items that are used less frequently but
are still necessary.
 Non-moving items: Items that haven't been used or sold for
a long time.
o Explanation:
 Fast-moving items require frequent replenishment and close
monitoring.
 Slow-moving items should be stocked in smaller quantities.
  Non-moving items may need to be cleared out or eliminated
from inventory to free up storage space.
o Importance: FSN analysis helps in deciding which items need
regular attention and which may require inventory reduction
strategies.
4. HML Analysis:
o Definition: HML stands for High, Medium, and Low and is used
to classify inventory based on unit price.
 High-value items: Expensive items that need careful
management.
 Medium-value items: Moderately priced items.
 Low-value items: Inexpensive items that require less
control.
o Importance: This method helps businesses focus on managing
high-cost items more carefully to reduce the impact of financial
losses from mismanagement.
Selective Inventory Control Importance
1. Focus on Critical Inventory:
o Allows businesses to focus more resources and attention on high-
value or critical items, reducing the risk of stockouts or
overstocking for those key items.
2. Efficient Use of Resources:
o Helps companies allocate time, effort, and money efficiently by not
treating all inventory equally. High-priority items get more
attention, while less important items get fewer resources.
3. Cost Reduction:
o Prevents businesses from tying up too much money in low-value or
slow-moving items, reducing holding costs and freeing up cash for
more important inventory.
4. Improved Decision-Making:
 o Enables better decision-making by identifying which inventory
items contribute the most to the company’s profits and need to be
managed closely.
Economic Order Quantity (EOQ)
What is EOQ?
 Economic Order Quantity (EOQ) is a formula used by businesses to
determine the optimal order quantity that minimizes the total costs
associated with ordering and holding inventory.
 The goal of EOQ is to find the right balance between ordering too often
(which increases ordering costs) and ordering too much (which
increases holding costs).
Key Concepts in EOQ:
 Ordering Costs: These are the costs associated with placing an order for
inventory, such as administrative costs, transportation, and labor. Every
time you order, you incur these costs.
 Holding Costs: These are the costs of storing and maintaining inventory,
like warehouse rent, insurance, and spoilage. The more inventory you
have, the higher your holding costs.
 Demand: The rate at which your business sells or uses inventory.
 Lead Time: The time between placing an order and receiving it.
D – Demand
S – Ordering Cost
H - Holding Cost

Importance of EOQ:
1. Minimizes Total Inventory Costs:
o EOQ helps businesses reduce both ordering costs and holding
costs, striking the perfect balance. Ordering too frequently
increases ordering costs, and holding too much inventory increases
holding costs. EOQ ensures these are minimized together.
2. Avoids Overstocking and Stockouts:
o By calculating the ideal order quantity, EOQ prevents businesses
from over-ordering (which can lead to excess stock) or under-
ordering (which can cause stockouts and lost sales).
3. Improves Cash Flow:
o EOQ ensures that businesses are not tying up too much capital in
inventory. When inventory levels are optimized, cash can be used
for other important operations or investments.
4. Efficient Inventory Management:
o Helps streamline the inventory process, ensuring that orders are
placed at the right time and in the right quantity, which leads to
smoother operations.
Uses of EOQ:
1. Determining Optimal Order Size:
o EOQ is used by businesses to determine the most cost-effective
order size, considering their ordering and holding costs.
2. Inventory Planning and Forecasting:
o EOQ helps in inventory planning by informing managers how
much inventory they should order, how often, and when, based on
demand and cost factors.
3. Cost Management:
 o EOQ is particularly useful for cost management, as it keeps
ordering and holding costs balanced, preventing unnecessary
expenditure.
4. Helps with Supplier Negotiations:
o When businesses know their optimal order quantities, they can
negotiate better deals with suppliers, potentially obtaining
discounts for bulk purchasing while still maintaining efficient
inventory levels.
Safety Stock
What is Safety Stock?
 Safety Stock is extra inventory that a company keeps to prevent
stockouts (running out of products) due to unexpected demand or
supply delays.
 It acts as a buffer to ensure a business can continue to meet customer
demand even when there's a disruption in the supply chain.
Why is Safety Stock Important?
1. Prevents Stockouts:
o Stockouts can lead to lost sales, unhappy customers, and missed
opportunities. Safety stock helps avoid these situations.
2. Handles Uncertainty:
o It helps protect against uncertainty in demand (when demand is
higher than expected) and supply delays (when suppliers can't
deliver on time).
3. Improves Customer Satisfaction:
o Ensuring products are always available builds customer trust and
keeps them happy.
How Safety Stock Works:
 Companies calculate how much extra stock they need to hold based on
factors like:
o Demand variability: How much customer demand fluctuates.
o Lead time variability: The time it takes for suppliers to deliver
products.
 o Service level: The percentage of time a company wants to be able
to meet customer demand without running out of stock.
How to Calculate Safety Stock:
 A simple formula for safety stock is:
Safety Stock = Z × σ × √L
Where:
o Z = Service level factor (based on desired service level, typically
given in a standard table).
o σ = Standard deviation of demand (measures how much demand
fluctuates).
o L = Lead time (how long it takes for new stock to arrive).
Advantages of Safety Stock:
1. Prevents Production Delays: For manufacturers, safety stock ensures
there are no production stoppages due to lack of raw materials.
2. Increases Customer Satisfaction: Keeps customers happy by ensuring
that products are always available for purchase.
3. Cushions Against Supply Chain Disruptions: Protects the business
from delays or issues in the supply chain.
Disadvantages of Safety Stock:
1. Increased Holding Costs: Holding extra inventory means higher storage
costs, insurance, and risk of product obsolescence.
2. Tied-Up Capital: Money invested in excess stock could have been used
elsewhere in the business.
3. Risk of Overstocking: Holding too much safety stock can lead to excess
inventory, which can become obsolete or expire, especially in industries
like food or technology.
Inventory Management Systems
What is an Inventory Management System?
 Inventory Management System (IMS) is software or a process used by
businesses to track, manage, and control inventory (goods and
materials).
  It helps businesses know what stock they have, where it is located, and
when they need to restock.
 The system helps optimize stock levels, avoid stockouts or overstocking,
and ensure smooth operations
Why is Inventory Management Important?
1. Prevents Stockouts:
o Helps businesses keep the right amount of inventory to avoid
running out of products, ensuring they meet customer demand.
2. Reduces Overstocking:
o Prevents businesses from buying too much inventory, which could
lead to higher storage costs or product obsolescence.
3. Improves Efficiency:
o By knowing exactly what’s in stock, businesses can streamline
ordering and reduce manual tasks, making operations more
efficient.
Key Features of Inventory Management Systems:
1. Real-Time Tracking:
o An IMS allows businesses to see real-time inventory levels. This
means they can track products from the moment they arrive to the
time they are sold or shipped.
2. Automatic Reordering:
o Many systems have features to automatically reorder products
when stock levels fall below a certain threshold, ensuring the
business never runs out of important items.
3. Barcode/QR Code Scanning:
o Most IMS systems use barcode or QR code scanning to track items
accurately, making it easy to update inventory levels when
products are added or removed from stock.
4. Inventory Reports and Analytics:
o Provides detailed reports on stock levels, sales trends, and
inventory turnover, helping businesses make informed decisions
about purchasing and stocking.
 5. Multi-Location Tracking:
o Businesses with multiple stores or warehouses can use IMS to
track inventory across all locations, ensuring they know what’s
available in each place.
Types of Inventory Management Systems:
1. Manual Systems:
o Small businesses might use manual methods such as spreadsheets
to manage inventory. This is usually less efficient and prone to
errors.
2. Barcode/QR Code Systems:
o Most modern systems use barcodes or QR codes to track
inventory movement. Scanners are used to update the system when
items are sold, moved, or restocked.
3. Cloud-Based Inventory Systems:
o These systems are hosted in the cloud, meaning businesses can
access inventory data from anywhere, on any device.
o Example: Zoho Inventory, QuickBooks, or TradeGecko are
cloud-based solutions used by many businesses.
Advantages of Using an Inventory Management System:
1. Accuracy:
o Reduces human errors that often happen in manual tracking
systems.
2. Efficiency:
o Automates many processes, like reordering and updating stock
levels, saving time and reducing labor costs.
3. Improved Decision-Making:
o Provides detailed analytics and reports that help businesses make
better decisions about inventory purchasing and stocking.
4. Cost Savings:
o Helps prevent overstocking and understocking, reducing storage
costs and ensuring you don't lose sales due to stockouts.
 5. Customer Satisfaction:
o By ensuring products are always available when needed,
businesses can meet customer demand promptly, improving
satisfaction and loyalty.
Disadvantages of Inventory Management Systems:
1. Initial Cost:
o Setting up an advanced IMS, especially for small businesses, can
be expensive. This includes software, hardware (like barcode
scanners), and training.
2. Complexity:
o Some systems can be complicated to use and may require proper
training for staff.
3. Dependence on Technology:
o If the system crashes or there’s a technical issue, it could disrupt
business operations, especially if all inventory data is managed
digitally.
Examples of Popular Inventory Management Systems:
1. Shopify Inventory:
o Used by online retailers to manage product listings, track sales, and
monitor inventory levels in real-time.
2. Oracle NetSuite:
o A cloud-based solution used by large businesses for advanced
inventory management across multiple warehouses or stores.
3. Fishbowl Inventory:
o Used by small to mid-sized businesses to manage inventory, orders,
and warehouse processes.

Inventory Forecasting Techniques:

What is Inventory Forecasting?
 Inventory forecasting is the process of predicting future demand for
products to ensure the right amount of stock is available at the right time.
  It helps businesses plan their inventory levels, avoiding both stockouts
(running out of stock) and overstocking (having too much stock).
Why is Inventory Forecasting Important?
1. Prevents Stockouts: Ensures that products are available when customers
need them, avoiding lost sales.
2. Reduces Overstocking: Prevents buying too much inventory, which can
lead to high holding costs and waste.
3. Optimizes Cash Flow: Helps businesses invest in the right amount of
inventory, freeing up cash for other operations.
4. Improves Customer Satisfaction: Ensures that popular products are
always in stock, keeping customers happy.
Inventory Forecasting Techniques:
1. Quantitative Forecasting
Quantitative forecasting involves using historical data to predict future
inventory levels. This method relies on numerical data, such as sales histories,
to create projections. The more historical data available, the more accurate the
predictions can be.
Example: If a toy store sells an average of 100 toys per month, historical sales
data can be analyzed to predict future needs. If historical data shows a seasonal
increase in sales during the holiday period, adjustments can be made for
anticipated demand.
2. Qualitative Forecasting
Qualitative forecasting focuses on non-measurable information and subjective
judgment. This method considers social, economic, and political factors that
might impact demand, and it is often used when historical data is unavailable,
such as with new products.
Example: A company launching a new tech gadget may use market research to
gauge consumer interest and preferences instead of relying solely on past sales
data.
3. Trend Forecasting
Trend forecasting analyzes past sales patterns to predict future trends. By
understanding the timing of sales fluctuations, businesses can better manage
their inventory during peak and off-peak seasons.
Example: A clothing retailer analyzes sales data and finds that sales peak
around back-to-school season. Based on this trend, the retailer can increase
inventory levels ahead of this period to ensure they meet demand.
4. Graphical Forecasting
Graphical forecasting utilizes visual charts to represent data, making it easier
to analyze trends and patterns. This method helps in identifying inventory needs
across different time periods visually.
Example: A beverage company creates line graphs of sales data over multiple
months to visualize which products sell best during summer versus winter,
enabling better stock management.
5. Lead Time Demand Calculation
Lead time demand refers to the amount of stock needed during the lead time—
this is the period between placing an order and receiving it. This calculation is
critical to avoid stockouts during the replenishment period.
6. Reorder Point (ROP) Calculation
The reorder point is the inventory level at which a new order should be placed
to replenish stock. It can be calculated based on average daily sales and lead
time, ensuring stock availability.
7. Safety Stock Calculation
Safety stock acts as a buffer against demand fluctuations, helping to avoid
stockouts. By maintaining extra inventory, businesses can better manage
unexpected spikes in demand.

Material Requirement Planning (MRP) and Execution in Inventory

Management:
What is Material Requirement Planning (MRP)
 Material Requirement Planning (MRP) is a system used by manufacturers
to plan and manage raw materials, components, and inventory required
for production.
 The goal is to ensure that the right materials are available at the right time
to meet production schedules, while minimizing inventory costs.
How Does MRP Work?
MRP works by breaking down the production plan for finished products and
calculating the raw materials and components needed to make those products. It
uses three key inputs:
1. Master Production Schedule (MPS):
o The MPS outlines what finished products need to be produced,
when they need to be produced, and in what quantity.
2. Bill of Materials (BOM):
o The BOM is a list of all the raw materials, components, and parts
required to manufacture a product. It’s like a recipe for making the
product.
3. Inventory Data:
o This includes information about the current levels of inventory
(both raw materials and finished goods) and any outstanding
orders.
Steps in MRP:
1. Demand Forecasting:
o The system looks at the demand for finished products based on the
production schedule (MPS) and customer orders.
2. Inventory Check:
o It checks current inventory levels to see what raw materials and
components are already available.
3. Calculating Requirements:
o MRP calculates how much additional material is needed by
looking at the BOM and considering the production schedule.
4. Placing Orders:
o Based on the calculations, MRP suggests or automatically
generates purchase orders for raw materials that are low, ensuring
materials arrive in time for production.
5. Execution and Scheduling:
o Once materials arrive, MRP helps schedule production by
ensuring the necessary components are in place when needed.
Advantages of MRP:
1. Reduces Stockouts:
o MRP ensures materials are available when needed, preventing
production delays due to missing parts.
2. Optimizes Inventory Levels:
o By calculating exact material requirements, MRP helps avoid
overstocking, reducing inventory holding costs.
3. Improves Production Efficiency:
o MRP schedules production activities effectively, ensuring the
smooth flow of materials and minimizing downtime.
4. Better Planning and Decision-Making:
o It provides detailed reports and insights into material needs,
helping managers make better decisions about purchasing and
production.
Disadvantages of MRP:
1. Data Dependency:
o MRP relies heavily on accurate data (inventory levels, lead times,
demand forecasts). Inaccurate data can lead to poor planning.
2. Complexity:
o Implementing and managing an MRP system can be complex,
especially for small businesses.
3. Costs:
o MRP systems can be expensive to implement and maintain,
particularly in terms of software, hardware, and training costs.
Material Requirement Planning (MRP) Execution:
MRP Execution refers to the steps taken to ensure that the materials are
ordered, delivered, and used effectively during production. Here's how it works:
1. Generating Purchase Orders:
o After calculating material needs, MRP generates purchase orders
for raw materials that must be sourced from suppliers.
 2. Scheduling Deliveries:
o The system coordinates with suppliers to ensure that materials are
delivered just in time for production, preventing overstocking.
3. Tracking Production Progress:
o MRP tracks the production process to make sure that materials are
being used as planned and that the production schedule is on track.
4. Adjusting to Changes:
o If there’s a delay in material delivery or a change in customer
demand, MRP can adjust the production schedule and material
orders accordingly.
Ratio Analysis on Inventory
What is Ratio Analysis?
 Ratio analysis is a method of analyzing financial data using specific
ratios that provide insights into the efficiency and performance of a
business, particularly in inventory management.
 These ratios help assess how effectively a company manages its
inventory, which is crucial for balancing stock levels, sales, and
profitability.
Inventory Ratios:
1. Inventory Turnover Ratio:
o Measures how many times a company's inventory is sold and
replaced over a period.
o Formula:
 o A high inventory turnover indicates that a company sells inventory
quickly, which means they are efficiently managing their stock. A
low turnover might indicate slow-moving stock or overstocking.
2. Days Sales of Inventory (DSI):
o What it is: Measures the average number of days it takes for a
company to sell its entire inventory.
o Formula:

A lower DSI means faster inventory turnover and better efficiency.

A higher DSI suggests that inventory sits longer before being sold,
which could mean excess stock or slow sales.
3. Gross Margin Return on Investment (GMROI):
o What it is: Measures how much gross profit a company makes for
every dollar invested in inventory.
o Formula:
 o A GMROI greater than 1 indicates that a company is making more
profit than the cost of the inventory. A lower GMROI might mean
that inventory is not generating enough profit.
4. Inventory to Sales Ratio:
o What it is: Compares the amount of inventory a company holds to
its sales. It shows whether a company is holding too much
inventory relative to its sales.
o Formula:
o Inventory to Sales Ratio= Average Inventory / Net Sales
A higher ratio could indicate that the company is holding more inventory than
needed, while a lower ratio suggests efficient inventory management.
Profit Margin in Inventory Management:
What is Profit Margin?
 Profit margin measures how much profit a company makes for each
dollar of sales after accounting for costs, including the cost of inventory.
 It helps businesses understand how efficiently they are turning inventory
into profit.
Types of Profit Margins:
1. Gross Profit Margin:
o Measures the profit a company makes after subtracting the Cost of
Goods Sold (COGS), which includes the cost of inventory.
o Formula:

Explan
ation: This margin shows how efficiently a company is producing
and selling goods. A higher margin indicates better control over
inventory costs.
2. Operating Profit Margin:
 o Measures the profit after subtracting operating expenses (like rent,
utilities, and wages) from gross profit, which includes the cost of
inventory.
o Formula:

Explanation: This margin shows how efficiently the company

manages both inventory and operating costs.
3. Net Profit Margin:
o Measures the overall profit after all expenses (including taxes and
interest) are subtracted from revenue. It shows the final profit left
after all costs, including inventory.
o Formula:

o Explanation: This margin indicates the overall profitability of the

business. A low net profit margin may suggest high costs, including
inventory costs, relative to sales.
Advantages of Tracking Profit Margin in Inventory Management:
1. Better Financial Health:
 o Tracking profit margins helps businesses assess their financial
health and make adjustments to improve profitability.
2. Informed Pricing Decisions:
o Knowing the profit margin enables businesses to price products
correctly, ensuring they cover inventory costs while remaining
competitive.
3. Improved Cost Control:
o Regularly analyzing profit margins helps identify rising inventory
costs and take corrective actions (e.g., changing suppliers or
reducing waste).