flevyblog

Flevy Blog is an online business magazine covering Business Strategies, Business Theories, & Business Stories.
MANAGEMENT & LEADERSHIP STRATEGY, MARKETING, SALES OPERATIONS & SUPPLY CHAIN ORGANIZATION & CHANGE IT/MIS Other

Inventory Variances: Does the Net Tell the Truth?

Editor's Note: Take a look at our featured best practice, Daily Cycle Counting for Inventory Records Accuracy (15-slide PowerPoint presentation). What good is Inventory Management if the inventory is not 98-100% accurate daily, everyday? No good! Cycle Counting is important to every department in your company. Inaccurate inventory leads to loss of sales, poor customer experience, and may indicate a more drastic issue of retail theft. [read more]

* * * *

Across our six locations, our physical inventory variance was zero and we’re proud of it.

This tells you exactly nothing.

A Tale of Jack and the Pride of It All…

Modern_warehouse_with_pallet_rack_storage_systemJack is the owner of an industrial products supplier with five sales/inventory warehouses including one large distribution center. Jack called me and asked if I could spend a few days with him and review the overall business. I could tell he had something on his mind.

I arrived, we talked, and I suggested a tour of the company. Met a lot of nice and hardworking people—and I mean working so hard that I could feel the stress. It doesn’t take long to see that something’s not quite right. There was a chaotic feeling about the organization; a sense of nervousness.

Jack turned to me with that deer in the headlights look and said, “We lost near $300,000 last year.”

I said, “Jack, you have my attention.”  I asked for more details and that he keep the conversation at a macro level.

He said he couldn’t give me much other than that at the end of the year, the company’s sales looked good and inventory looked better than ever. I said, “Let’s focus on the inventory. What portion of that $300,000 loss was related to inventory?”

He said, “The company was up 10% in sales volume, so we guess it was from the operations side of the business.”

I said, “So your sales were up and your operating expense increased by no more than 2%, right?”

He said, “No—actually, operating expense increased much more than that.” Jack’s team looks at Sales, Operating Expense, Inventory.

I’ve been at this long enough to know what’s going on. I asked, “So what was your physical inventory variance?”

Grinning ear-to-ear and proud as a peacock, he said, “We don’t even have to look at that, as it was almost zero. That’s why we’re sure it came from the operating expense side.”

“Jack, what were your pickup and shrink percentages?”

He then said that it doesn’t matter.  (Well, my family will tell you that when I’m curious, I just don’t stop.)

I said, “It does matter, Jack; it matters a great deal. Case in point: If you had an inventory shrink (loss) of $200,000 and a pickup (increase) of $200,000, that would be a net variance of…?”

Jack said zero. I said sure enough and that would look pretty good—so good that it would make a business owner happier than a fish in water. Jack smiled.

I posed this question: “If the $200,000 shrink related to 1,000 part numbers, and the $200,000 pickup related to 10 part numbers, would that be cause for alarm?”

He said, “Nope. It’s still a zero variance.”

I posed this thought: “I’m afraid I can’t agree on that one, Jack. If I had errors for twelve months on 1,000 of my part numbers, I would suspect that a whole lot of bad is going on and that for sure the operating costs were very high. Errors on 1,000 items clearly trumps errors on 10 items—that is, if you place your focus on what inventory is really about—quantity. In fact, the human resource and financial outlay to manage that type of discrepancy would scare the dickens out of a guy.

“Your challenge is that you are focused on the dollars and not the quantity. The net variance of quantity is an alarming number where the variance of dollars is not. You’re hearing what you want to hear.”

I then said: “When dealing with inventory, focus on the pieces—not the dollars. You do not sell dollars. You do not order dollars. You do not warehouse dollars. You manage quantities of consumable assets.”

“If you focus on the quantities, the dollars will follow along.”

When is the last time one of your sales staff walked into the warehouse and asked, “Hey Charlie, did my $10,000 of nail guns come in yet?” Instead, it would be much more likely that the salesperson asked if her order of 10 Ramset nail guns has arrived. When is the last time your customer called and said, “I’d like to order $10 of utility knives”? My guess is that they said, “I’d like to order 10 utility knives—what’s your price?” or “I’d like to order 10 utility knives at $10 apiece.”

Jack said, “Dan, I get it and agree. We just never looked at things that way. Heck, even everyone in my peer group places focus on the dollars.”

Then Jack said, “Do you have some time to talk about my operating expense?”

The moral of the story is that you need to:

Look past what you want to see for what you need to see… which is the truth and not the average.

Remove your blinders of desired bliss.

Excel workbook
Inventory Management Template Introducing our powerful and user-friendly inventory template! Our template is designed to help you efficiently manage your inventory and stay on top of your stock levels. With features such as automatic updates, interactive reports, and easy-to-use input fields, [read more]

Do You Want to Implement Business Best Practices?

You can download in-depth presentations on Inventory Management and 100s of management topics from the FlevyPro Library. FlevyPro is trusted and utilized by 1000s of management consultants and corporate executives.

For even more best practices available on Flevy, have a look at our top 100 lists:

These best practices are of the same as those leveraged by top-tier management consulting firms, like McKinsey, BCG, Bain, and Accenture. Improve the growth and efficiency of your organization by utilizing these best practice frameworks, templates, and tools. Most were developed by seasoned executives and consultants with over 20+ years of experience.

Readers of This Article Are Interested in These Resources


Excel workbook
This tool is designed to compute optimum inventory level in a manufacturing environment based on customer service level, sales forecast, capacity utilization, and distribution channel. It can be used to estimate optimum level of pre-build stock, safety stock, in-transit stock and cycle stock by SKU [read more]


 
69-slide PowerPoint presentation
 
 
Excel workbook

About Dan Belanger

Dan Belanger is the President of the Belanger Technology and Consulting Group. His background includes thirty years of solution based action in multiple business models including Distribution, Manufacturing, Warehousing, Facilities Management, Service, Retail, and Information Systems. He is well-versed in all aspects of business ownership, operations and management. Dan can be reached at 702-785-7331 or dan@danbelanger.com. You can also connect with Dan on LinkedIn here.

,



Complimentary Business Training Guides


Many companies develop robust strategies, but struggle with operationalizing their strategies into implementable steps. This presentation from flevy introduces 12 powerful business frameworks spanning both Strategy Development and Strategy Execution. [Learn more]

  This 48-page whitepaper, authored by consultancy Envisioning, provides the frameworks, tools, and insights needed to manage serious Change—under the backdrop of the business lifecycle. These lifecycle stages are each marked by distinct attributes, challenges, and behaviors. [Learn more]

We've developed a very comprehensive collection of Strategy & Transformation PowerPoint templates for you to use in your own business presentations, spanning topics from Growth Strategy to Brand Development to Innovation to Customer Experience to Strategic Management. [Learn more]

  We have compiled a collection of 10 Lean Six Sigma templates (Excel) and Operational Excellence guides (PowerPoint) by a multitude of LSS experts. These tools cover topics including 8 Disciplines (8D), 5 Why's, 7 Wastes, Value Stream Mapping (VSM), and DMAIC. [Learn more]
Recent Articles by Corporate Function

  

  

  

  

  

The Flevy Business Blog (https://flevy.com/blog) is a leading source of information on business strategies, business theories, and business stories. Most of our articles are authored by management consultants and industry executives with over 20 years of experience.

Flevy (https://flevy.com) is the marketplace for business best practices, such as management frameworks, presentation templates, and financial models. Our best practice documents are of the same caliber as those produced by top-tier consulting firms (like McKinsey, Bain, Accenture, BCG, and Deloitte) and used by Fortune 100 organizations. Learn more about Flevy here.
  


OUR CORE OFFERINGS
Flevy Marketplace: Top 100
· Strategy & Transformation
· Digital Transformation
· Operational Excellence
· Organization & Change
· Financial Models
· Consulting Frameworks
· PowerPoint Templates
FlevyPro (Subscription Service)
KPI Library
Streams (Functional Bundles)
Flevy Executive Learning (FEL)
PowerPoint Services

FREE Resources

About Flevy
Management Topics
Marcus (AI-Powered Consultant)
Partner Program
LinkedIn Influencer Marketing
FAQ / Terms / Privacy / Blog
Contact Us: support@flevy.com



CONNECT WITH US!
       
TOP 100 TRENDING TOPICS
Acquisition Strategy
Agile
Analytics
Artificial Intelligence
Balanced Scorecard
Best Practices
Big Data
Breakout Strategy
Business Continuity Planning
Business Plan Financial Model
Business Transformation
CMMI
COBIT
Change Management
Cloud
Communications Strategy
Company Financial Model
Competitive Advantage
Competitive Analysis
Consulting Frameworks
Continuous Improvement
Core Competencies
Corporate Culture
Cost Reduction Assessment
Customer Experience

BROWSE BY FUNCTION
Strategy, Transformation, & Innovation
Digital Transformation
Operational Excellence and LSS
Organization, Change, & HR
Management Consulting

Customer Journey
Customer Service
Cyber Security
Data Privacy
Decision Making
Digital Marketing Strategy
Digital Transformation
Digital Transformation Strategy
Due Diligence
ESG
Employee Engagement
Employee Training
Enterprise Architecture
Growth Strategy
HR Strategy
Hiring
Hoshin Kanri
ISO 27001
ITIL
Information Technology
Innovation Management
Integrated Financial Model
Kaizen
Kanban
Key Performance Indicators

ADDITIONAL RESOURCES
Business Strategy Frameworks
Case Studies
Consulting Training Guides
COVID-19 Trend Data
Digital Transformation
Financial Advising Services (FAS)

Knowledge Management
Leadership
Lean
Lean Manufacturing
Logistics
M&A (Mergers & Acquisitions)
Manufacturing
Market Research
Marketing Plan Development
Maturity Model
McKinsey PowerPoint
McKinsey Templates
Operational Excellence
Organizational Change
Organizational Design
Performance Management
Post-merger Integration
Pricing Strategy
Process Improvement
Process Maps
Procurement Strategy
Product Launch Strategy
Product Strategy
Project Management
Quality Management


Free Resources
KPI Library
Lean Management
Lean Six Sigma Training Guides
Marcus Insights
Operational Excellence

Real Estate
Remote Work
Restructuring
Risk Management
Robotic Process Automation
SWOT
SaaS
Sales
Scrum
Service Design
Six Sigma Project
Social Media Strategy
Strategic Planning
Strategic Thinking
Strategy Development
Supply Chain Analysis
Sustainability
Target Operating Model
Team Management
Total Productive Maintenance
Value Chain Analysis
Value Creation
Value Stream Mapping
Visual Workplace
Workplace Safety


Product Strategy
Small Business Owner
Startup Resources
Strategic Planning
Strategic Planning Process
Value Innovation Strategy


© 2012-2024 Copyright. Flevy LLC. All Rights Reserved.