Supply Chain Analytics for the CPA BAR Exam

Supply Chain Management Overview

Supply chain management encompasses the planning, execution, and control of all activities involved in sourcing, procurement, production, and delivery of products to customers. Supply chain analytics applies quantitative methods to optimize these activities, reducing costs while improving service levels. On the CPA BAR exam, you should understand key inventory management models, performance metrics, and analytical techniques used to manage supply chains effectively.

Inventory Management Models

Economic Order Quantity (EOQ)

The economic order quantity model determines the optimal order size that minimizes total inventory costs. Total inventory costs consist of ordering costs (costs of placing and receiving orders, including purchase requisitions, receiving and inspection, and accounts payable processing) and carrying costs (costs of holding inventory, including storage, insurance, obsolescence, and the opportunity cost of capital tied up in inventory).

The EOQ formula is: EOQ = √(2DS / H), where D is annual demand in units, S is the cost per order, and H is the annual carrying cost per unit. At the EOQ, total ordering costs equal total carrying costs. The model assumes constant and known demand, constant lead time, instantaneous replenishment, and no quantity discounts.

The reorder point is the inventory level at which a new order should be placed: Reorder Point = Daily Demand × Lead Time in Days. When demand or lead time is uncertain, safety stock is added to protect against stockouts: Reorder Point = (Daily Demand × Lead Time) + Safety Stock.

Just-in-Time (JIT) Inventory

JIT is a production and inventory philosophy that aims to produce and deliver products just in time for sale or use, minimizing inventory levels. Key principles include demand-pull production (producing only what is needed, when it is needed), small lot sizes and frequent deliveries, close supplier relationships, high-quality inputs (defects cannot be tolerated when there is no buffer stock), and continuous improvement.

JIT reduces carrying costs, warehouse space requirements, and waste from obsolescence and spoilage. However, it increases vulnerability to supply chain disruptions because there is little buffer inventory. JIT requires reliable suppliers, predictable demand, and high-quality production processes.

ABC Inventory Classification

ABC analysis classifies inventory items based on their importance, typically measured by annual dollar usage. A items (roughly 20% of items representing 80% of dollar usage) receive the tightest controls and most frequent review. B items (roughly 30% of items, 15% of dollar usage) receive moderate controls. C items (roughly 50% of items, 5% of dollar usage) receive the least control. This approach allocates management attention proportionally to the financial significance of each inventory category.

Supply Chain Performance Metrics

Inventory Turnover

Inventory turnover measures how quickly inventory is sold and replaced. It is calculated as Cost of Goods Sold / Average Inventory. Higher turnover generally indicates more efficient inventory management, though very high turnover might signal inadequate stock levels and potential stockouts. Days of inventory on hand (365 / Inventory Turnover) translates turnover into the average number of days inventory is held before being sold.

Order Fulfillment Metrics

Key fulfillment metrics include the order fill rate (percentage of orders filled completely from stock), the on-time delivery rate (percentage of orders delivered by the promised date), the perfect order rate (percentage of orders delivered on time, complete, undamaged, and with accurate documentation), and order cycle time (the elapsed time from order placement to delivery).

Supply Chain Cost Metrics

Total supply chain cost includes procurement costs, manufacturing costs, transportation costs, warehousing costs, and inventory carrying costs. Cost-to-serve analysis determines the total cost of serving each customer or channel, helping identify profitable and unprofitable customer segments. Supply chain cost as a percentage of revenue benchmarks overall supply chain efficiency.

Demand Forecasting

Accurate demand forecasting is the foundation of effective supply chain management. Qualitative methods (expert opinion, market research, Delphi technique) are used when historical data is limited or when anticipating changes not reflected in past data. Quantitative methods (moving averages, exponential smoothing, regression analysis, time series decomposition) use historical data to project future demand patterns.

Forecast accuracy is measured using metrics such as mean absolute deviation (MAD), mean absolute percentage error (MAPE), and tracking signals. Monitoring forecast accuracy helps organizations refine their forecasting methods and adjust safety stock levels appropriately.

Exam Preparation Tips

• Know the EOQ formula and be able to calculate the optimal order quantity.
• Understand the components of the reorder point calculation, including safety stock.
• Know the key principles of JIT inventory and its advantages and risks.
• Be familiar with common supply chain performance metrics and what they measure.
• Understand ABC inventory classification and how it guides management attention.