Operations Management: Little's Formula and Inventory Turns
Operations Management: Little's Formula and Inventory Turns
Introduction to Little's Law
Little's Law is a fundamental principle in operations management that describes the relationship between three key process measures. It is applicable when a process is demand-constrained, meaning the demand rate is less than or equal to the process capacity ( \text{demand rate} \le \text{capacity} ).
Three Key Measures
WIP (Work-in-Process):
Represents the average number of flow units currently within the process at any given time.
Units: Flow units (e.g., customers, claims, cars).
Flow Time (FT):
Represents the average amount of time a single flow unit spends from entering to exiting the process.
Units: Time units (e.g., hours, weeks, minutes, years).
Flow Rate (FR):
Represents the average rate at which flow units move through the process, i.e., the number of units exiting (or entering) the process per unit of time.
Units: Flow units per unit of time (e.g., customers/hour, claims/week, cars/hour).
Little's Formula
The relationship between these three measures is given by:
\text{WIP} = \text{FT} \times \text{FR}
This formula can be rearranged to solve for any of the three variables if the other two are known:
\text{FT} = \frac{\text{WIP}}{\text{FR}}
\text{FR} = \frac{\text{WIP}}{\text{FT}}
Applications of Little's Law: Examples
Little's Law can be applied to various scenarios to understand and manage process efficiency.
Example 1: Burger King
Scenario: 200 customers arrive over a 2-hour period. At a given moment, 45 customers are inside the Burger King.
Objective: Determine the average time a customer spends in Burger King.
Identification of Measures:
WIP (customers inside) = 45 customers.
FR (demand rate) = \frac{200 \text{ customers}}{2 \text{ hours}} = 100 \text{ customers/hour}.
Calculation of Flow Time (FT):
\text{FT} = \frac{\text{WIP}}{\text{FR}} = \frac{45 \text{ customers}}{100 \text{ customers/hour}} = 0.45 \text{ hours}Conversion: 0.45 \text{ hours} \times 60 \text{ minutes/hour} = 27 \text{ minutes} .
Example 2: Insurance Claims
Scenario: An insurance company processes 6000 claims per year (assuming a 50-week work year). The average processing time for a claim is 2 weeks.
Objective: Determine the average number of claims currently in the process.
Identification of Measures:
FR (claim processing rate) = \frac{6000 \text{ claims}}{50 \text{ weeks}} = 120 \text{ claims/week}.
FT (processing time) = 2 \text{ weeks}.
Calculation of Work-in-Process (WIP):
\text{WIP} = \text{FR} \times \text{FT} = 120 \text{ claims/week} \times 2 \text{ weeks} = 240 \text{ claims} .
Example 3: Purdue University Student Spending
Scenario: Purdue University has an average enrollment (class size) of 6373 students. The average graduation time is 4 years. Each student, on average, spends 5000 annually at local businesses.
Objective: Calculate Purdue students' total annual spending at local businesses.
Explanation: In this context, the average enrollment represents the Work-in-Process (WIP) for student flow. The question asks for the total annual spending by these students.
Identification of Measures/Values:
WIP (average number of students) = 6373 students.
Annual spending per student = \$5,000.
Calculation: The total annual spending by the currently enrolled students is simply the product of the number of students and their average annual spending.
\text{Total Annual Spending} = \text{Number of students} \times \text{Annual Spending Per Student}
\text{Total Annual Spending} = 6373 \text{ students} \times \$5000/\text{student/year} = \$31,865,000 \text{ per year} .
(Note: While graduation time is given, it's not directly used for this specific question but would be relevant if calculating the flow rate of graduates.)
Example 4: Highway Traffic (A Tricky Application)
Scenario: You are driving home at an average speed of 60 miles per hour. A radio traffic report indicates an average of 24 cars in your direction on a one-quarter mile (0.25 miles) stretch of highway.
Objective: Determine how many cars enter the highway (going in your direction) per hour (Flow Rate).
Identification of Measures (Units Matching is Critical!):
WIP (Inventory of cars) = 24 cars (in the 0.25-mile segment).
Flow Time (FT): The time it takes for a single car to travel through the 0.25-mile segment at 60 mph.
\text{FT} = \frac{\text{Distance}}{\text{Speed}} = \frac{0.25 \text{ miles}}{60 \text{ miles/hour}} = \frac{1}{240} \text{ hours}FR (Cars entering per hour) = \text{Unknown}.
Calculation of Flow Rate (FR):
\text{FR} = \frac{\text{WIP}}{\text{FT}} = \frac{24 \text{ cars}}{(\frac{1}{240} \text{ hours})} = 24 \times 240 \text{ cars/hour} = 5760 \text{ cars/hour} .
Inventory Turns
Definition and Significance
Inventory turns (or inventory turnover) is an accounting measure that quantifies how many times a company's inventory is sold and replaced over a given period, typically a year. Frequent inventory turns are generally desirable as they indicate that inventory is held for a short duration before being delivered to customers, minimizing holding costs and risks of obsolescence.
Relationship with Flow Time
Inventory turns are inversely related to the average time a product is kept in inventory (which is analogous to Flow Time, FT):
\text{Inventory turns} = \frac{1}{\text{Average time to sell inventory}}
\text{Inventory turns} = \frac{1}{\text{FT}}
Industry Examples
HP: Turns inventory approximately 13 times a year, meaning inventory is held for about 28 days on average (365 \text{ days} / 13 \approx 28 \text{ days}).
Dell: Turns inventory approximately 32 times a year, meaning inventory is held for about 11 days on average (365 \text{ days} / 32 \approx 11 \text{ days}). This indicates Dell's superior inventory management efficiency compared to HP.
Calculating Inventory Turns from Financial Statements
Little's Law can be adapted to calculate inventory turns using data from a company's financial statements.
Key Financial Concepts:
Cost of Goods Sold (COGS): Found on the income statement, this represents the direct costs attributable to the production of the goods sold by a company. It is not revenue or sales. In the context of Little's Law, COGS can be seen as the Flow Rate (FR) of goods in monetary value.
Average Inventory: Found on the balance sheet, this represents the average value of inventory held by the company. In the context of Little's Law, Average Inventory is analogous to Work-in-Process (WIP).
Relationship (based on Little's Law):
Recall: \text{WIP} = \text{FR} \times \text{FT}
Substituting financial terms: \text{Average inventory} = \text{Cost of goods sold} \times \text{Average time to sell inventory}
Formula for Inventory Turns:
\text{Inventory turns} = \frac{\text{Cost of goods sold}}{\text{Average inventory}}
This effectively calculates \frac{\text{FR}}{\text{WIP}} , which is equivalent to \frac{1}{\text{FT}} .Numerical Examples (HP vs. Dell, all values in millions of USD per year):
Company
Cost of Goods Sold (FR)
Average Inventory (WIP)
Inventory Turns (\frac{1}{FT})
HP
84,562
6,415
\frac{84,562}{6,415} \approx 13
Dell
44,754
1,382
\frac{44,754}{1,382} \approx 32
Per Unit Inventory Holding Cost
Definition
Inventory holding cost refers to the expenses associated with storing inventory over a period. This can include warehousing costs, insurance, taxes, obsolescence, damage, and capital tied up in inventory. It's often expressed as a percentage of the product's cost.
Calculation
The per unit inventory holding cost can be calculated by dividing the annual inventory holding cost rate (as a percentage of product cost) by the number of inventory turns.
\text{Inventory holding cost per unit} = \frac{\text{Annual inventory holding cost rate}}{\text{Inventory turns}}Numerical Examples (Dell vs. HP)
Assume both Dell and HP have an annual inventory holding cost rate equal to 30\% of the cost of goods sold.
Dell:
Inventory turns = 32
Inventory holding cost per unit = \frac{30\%}{32} \approx 0.9375\% \approx 0.9\%
This means 0.9\% of the cost for each unit Dell sells is due to inventory holding.
HP:
Inventory turns = 13
Inventory holding cost per unit = \frac{30\%}{13} \approx 2.307\% \approx 2.3\%
This means 2.3\% of the cost for each unit HP sells is due to inventory holding.
Implication: Dell's significantly higher inventory turnover leads to a much lower per-unit inventory holding cost (0.9\% compared to HP's 2.3\%), highlighting the financial benefits of efficient inventory management.
In-Class Exercise: Walmart (2014 Approximate Figures)
Given:
Cost of Goods Sold (COGS) = \$360,000 million
Total Inventory = \$45,000 million
Annual Inventory Holding Cost Rate = 20\%
Tasks:
Walmart's inventory turnover?
\text{Inventory Turns} = \frac{\text{COGS}}{\text{Total Inventory}} = \frac{\$360,000 \text{ million}}{\$45,000 \text{ million}} = 8 \text{ turns/year}On average, how long is a product kept in inventory before it is sold? (Flow Time)
\text{Average time to sell inventory (FT)} = \frac{1}{\text{Inventory Turns}} = \frac{1}{8 \text{ turns/year}} = 0.125 \text{ years}
0.125 \text{ years} \times 365 \text{ days/year} \approx 45.625 \text{ days}
0.125 \text{ years} \times 12 \text{ months/year} = 1.5 \text{ months}What is the inventory holding cost per unit?
\text{Inventory holding cost per unit} = \frac{\text{Annual inventory holding cost rate}}{\text{Inventory turns}} = \frac{20\%}{8} = 0.025 = 2.5\%
Practice Problems
Bookstore Inventory: A local bookstore turns over its inventory once every three months. The bookstore's annual cost of holding inventory is 36\%$. What is the inventory holding cost (in ) for a book that the bookstore purchases for 10 and sells for 18?
Solution Approach: Calculate annual inventory turns (12 / 3 = 4 \text{ turns/year}). Use the holding cost rate formula to find the percentage holding cost per unit (36\% / 4 = 9\%). Apply this percentage to the purchase price of the book (9\% \times \$10 = \$0.90). The selling price is irrelevant for calculating holding cost on the purchased item.
Bicycle Manufacturer Seats: A bicycle manufacturer purchases bicycle seats from an outside supplier for 22 each. The manufacturer's inventory of seats turns over 1.2 times per month, and the manufacturer has an annual inventory holding cost of 32\%$. What is the inventory holding cost (in ) for a bicycle seat?
Solution Approach: Calculate annual inventory turns (1.2 \text{ turns/month} \times 12 \text{ months/year} = 14.4 \text{ turns/year}). Use the holding cost rate formula to find the percentage holding cost per unit (32\% / 14.4 \approx 2.22\%). Apply this percentage to the purchase price of the seat (2.22\% \times \$22 \approx \$0.49).
Summary of Key Formulas
Little's Law (Demand-constrained processes):
\text{WIP} = \text{FT} \times \text{FR}Inventory Turns:
Conceptually: The reciprocal of average time to sell inventory (Flow Time).
\text{Inventory turns} = \frac{1}{\text{Average time to sell inventory}} = \frac{1}{\text{FT}}Calculated from financial statements:
\text{Inventory turns} = \frac{\text{Cost of goods sold}}{\text{Average inventory}}
Inventory Holding Cost per Unit:
\text{Inventory holding cost per unit} = \frac{\text{Annual inventory holding cost rate}}{\text{Inventory turns}}
Operations Management: Little's Formula and Inventory Turns
Introduction to Little's Law
Little's Law is a fundamental principle in operations management applicable to demand-constrained processes ( \text{demand rate} \le \text{capacity} ). It establishes a relationship between three key measures:
WIP (Work-in-Process): Average number of flow units within the process.
Flow Time (FT): Average time a flow unit spends in the process.
Flow Rate (FR): Average rate at which flow units move through the process.
Little's Formula
\text{WIP} = \text{FT} \times \text{FR}
This formula can be rearranged to find any variable: \text{FT} = \frac{\text{WIP}}{\text{FR}} or \text{FR} = \frac{\text{WIP}}{\text{FT}} .
Applications of Little's Law
Little's Law helps manage process efficiency across various scenarios. For instance, if 45 customers are in a Burger King (WIP) with a demand rate of 100 customers/hour (FR), the average flow time (FT) is 0.45 hours or 27 minutes ( \text{FT} = \frac{45}{100} ).
Inventory Turns
Inventory turns (or inventory turnover) quantifies how many times a company's inventory is sold and replaced over a period, typically a year. High inventory turns minimize holding costs and obsolescence. It is inversely related to the average time a product is held in inventory:
\text{Inventory turns} = \frac{1}{\text{Average time to sell inventory}} = \frac{1}{\text{FT}}
Calculating Inventory Turns from Financial Statements
Using financial data:
Cost of Goods Sold (COGS): Acts as the Flow Rate (FR) in monetary value.
Average Inventory: Analogous to Work-in-Process (WIP).
Formula:
\text{Inventory turns} = \frac{\text{Cost of goods sold}}{\text{Average inventory}}
For example, if Walmart's COGS is \$360,000 million and its Average Inventory is \$45,000 million, its inventory turns are 8 times/year ( \frac{\$360,000}{\$45,000} ). This means a product is held for about 45.6 days (365 / 8).
Inventory Holding Cost
Inventory holding cost includes expenses like warehousing, insurance, and obsolescence. It's often expressed as a percentage of product cost.
\text{Inventory holding cost per unit} = \frac{\text{Annual inventory holding cost rate}}{\text{Inventory turns}}
If Dell has 32 inventory turns/year and an annual holding cost rate of 30\% , its per-unit holding cost is approx. 0.9\% (30\% / 32), demonstrating the financial benefits of high turnover.
Summary of Key Formulas
Little's Law: \text{WIP} = \text{FT} \times \text{FR}
Inventory Turns: \frac{1}{\text{FT}} = \frac{\text{Cost of goods sold}}{\text{Average inventory}}
Inventory Holding Cost per Unit: \frac{\text{Annual inventory holding cost rate}}{\text{Inventory turns}}