The Smart Forecaster

Pursuing best practices in demand planning,

forecasting and inventory optimization

A readable, well-organized textbook could be invaluable to “help corporate forecasters-in-training understand the basics of time series forecasting,” as Tom Willemain notes in the conclusion to this review, originally published in Foresight: The International Journal of Applied Forecasting. Principally written for an academic audience, the review also serves inexperienced demand planning professionals by pointing them to an in-depth resource.

This neat little book aims to “introduce the reader to quantitative forecasting of time series in a practical, hands-on fashion.” For a certain kind of reader, it will doubtless succeed, and do so in a stylish way.

The author, Dr. Galit Shmueli, is the SRITNE Chaired Professor of Data Analytics and Associate Professor of Statistics and Information Systems at the Indian School of Business, Hyderabad. She has authored or coauthored several other books on applied statistics and business analytics.

The book is meant to be a text for a “mini-semester” course for graduate or upper-level undergraduate students. I think it would be a stretch to believe there is enough technical material here to serve as the basis for a graduate course, but I could see it working well for undergraduates in industrial engineering or management who have had a prior statistics course (and therefore will indeed be able to “recall that a 95% prediction interval for normally distributed errors is…”).

There are end-of-chapter exercises of appropriate size and even setups for three real-world semester projects, so instructors could use the book as envisioned by the author. The book illustrates its points using XLMiner, an Excel add-in, and students can use the free demo version for almost all the exercises. Text datasets are available from the book’s web site, which also provides a free time series analysis “dashboard” application. The author notes that other software can be used in place of XLMiner and mentions Minitab, JMP, and Rob Hyndman’s forecast library in R.

While reading this book, I was delighted by its clarity. Having spent time recently correcting the technical prose of two otherwise good graduate students, I found the writing in this book to be a refreshing contrast, making technical concepts understandable.

Another virtue of this book is its selection of topics. The technical ones are reasonably standard (smoothing methods, regression using polynomial trends, and dummy variables) but also range a bit toward the more exotic (logistic regression, neural nets, a bit of ARIMA). More impressive is the inclusion of what might be called “meta-topics” relevant to forecasting: performance assessment, an overview of alternative technical approaches, and one on the forecasting process, from definition of goals to ways to gear reports differently for managerial and technical audiences. This is the kind of forecasting wisdom we find in Chris Chatfield’s book (2004), though presented rather less tartly and with less mathematical exposition. I typically recommend Chatfield’s introductory book for more technical readers interested in getting into time series; I would recommend Shmueli’s book for a more general audience.

No review is complete without quibbles. Here are a few—too few to undo my very positive view of this impressive little book:

• The text makes a good case for “well formatted and easily readable” charts (p. 179). But I found many of the screen shots to be poorly printed and difficult to see. The book is otherwise so visually pleasing that these defects seem very out of character. It uses luxurious amounts of white space and whimsical marginal art to great effect, producing a very “light” feel that must surely help comprehension.

• The author claims (p. 115) that smoothing methods (e.g., moving averages, exponential smoothing) cannot be fully automated because “the user must specify smoothing constants.” Of course, this is not so, since there are several software packages that do this, and the text later contradicts itself on this point on page 127.

• The otherwise good discussion of autocorrelation misleads when it claims (p. 88) that negative lag-1 autocorrelation means that “high values are immediately followed by low values and vice versa.” Well, usually, but not always.

When I finished reading this book, I realized immediately that there is another target audience outside the classroom. My company often conducts training sessions on the use of our software, and these include some general background on forecasting methods and processes. If we could excise the material on XLMiner, and even if we couldn’t, this text would make a wonderful “leave behind” to help corporate forecasters-in-training understand the basics of time series forecasting. The book is so well written, well organized and well designed that it might even be read. We can certainly use it to help our new programmers understand the applications they are developing. And this book might even serve as guilty reading for a graduate student who wants to really “get” what’s going on in Box, Jenkins and Reinsel (2008).

Thomas Willemain, PhD, co-founded Smart Software and currently serves as Senior Vice President for Research. Dr. Willemain also serves as Professor Emeritus of Industrial and Systems Engineering at Rensselaer Polytechnic Institute and as a member of the research staff at the Center for Computing Sciences, Institute for Defense Analyses.

Leave a Comment

Related Posts

Looking for Trouble in Your Inventory Data

Looking for Trouble in Your Inventory Data

In this video blog, the spotlight is on a critical aspect of inventory management: the analysis and interpretation of inventory data. The focus is specifically on a dataset from a public transit agency detailing spare parts for buses.

Can Randomness be an Ally in the Forecasting Battle?

Can Randomness be an Ally in the Forecasting Battle?

When we try to understand the complex world of logistics, randomness plays a pivotal role. This introduces an interesting paradox: In a reality where precision and certainty are prized, could the unpredictable nature of supply and demand actually serve as a strategic ally?
The quest for accurate forecasts is not just an academic exercise; it’s a critical component of operational success across numerous industries. For demand planners who must anticipate product demand, the ramifications of getting it right—or wrong—are critical. Hence, recognizing and harnessing the power of randomness isn’t merely a theoretical exercise; it’s a necessity for resilience and adaptability in an ever-changing environment.

The Objectives in Forecasting

The Objectives in Forecasting

A forecast is a prediction about the value of a time series variable at some time in the future. For instance, one might want to estimate next month’s sales or demand for a product item. A time series is a sequence of numbers recorded at equally spaced time intervals; for example, unit sales recorded every month. The objectives you pursue when you forecast depend on the nature of your job and your business. Every forecast is uncertain; in fact, there is a range of possible values for any variable you forecast. Values near the middle of this range have a higher likelihood of actually occurring, while values at the extremes of the range are less likely to occur.

Recent Posts

  • Looking for Trouble in Your Inventory DataLooking for Trouble in Your Inventory Data
    In this video blog, the spotlight is on a critical aspect of inventory management: the analysis and interpretation of inventory data. The focus is specifically on a dataset from a public transit agency detailing spare parts for buses. […]
  • Smart Software Launches GrowSmart Extension in Collaboration with GrowSmart Software Launches GrowSmart Extension in Collaboration with Grow
    Smart Software, a leader in enterprise demand planning, consensus forecasting, and inventory optimization solutions, announces the release of the GrowSmart extension in Collaboration with Grow, an Epicor solution. […]
  • BAF Case Study SIOP planning Distribution CenterBig Ass Fans Turns to Smart Software as Demand Heats Up
    Big Ass Fans is the best-selling big fan manufacturer in the world, delivering comfort to spaces where comfort seems impossible. BAF had a problem: how to reliably plan production to meet demand. BAF was experiencing a gap between bookings forecasts vs. shipments, and this was impacting revenue and customer satisfaction BAF turned to Smart Software for help. […]
  • The Cost of Doing nothing with your inventory Planning SystemsThe Cost of Spreadsheet Planning
    Companies that depend on spreadsheets for demand planning, forecasting, and inventory management are often constrained by the spreadsheet’s inherent limitations. This post examines the drawbacks of traditional inventory management approaches caused by spreadsheets and their associated costs, contrasting these with the significant benefits gained from embracing state-of-the-art planning technologies. […]
  • Randomness can be an Ally in the Forecasting BattleCan Randomness be an Ally in the Forecasting Battle?
    When we try to understand the complex world of logistics, randomness plays a pivotal role. This introduces an interesting paradox: In a reality where precision and certainty are prized, could the unpredictable nature of supply and demand actually serve as a strategic ally? The quest for accurate forecasts is not just an academic exercise; it's a critical component of operational success across numerous industries. For demand planners who must anticipate product demand, the ramifications of getting it right—or wrong—are critical. Hence, recognizing and harnessing the power of randomness isn't merely a theoretical exercise; it’s a necessity for resilience and adaptability in an ever-changing environment. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareWhy MRO Businesses Need Add-on Service Parts Planning & Inventory Software
      MRO organizations exist in a wide range of industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
    • Spare-parts-demand-forecasting-a-different-perspective-for-planning-service-partsThe Forecast Matters, but Maybe Not the Way You Think
      True or false: The forecast doesn't matter to spare parts inventory management. At first glance, this statement seems obviously false. After all, forecasts are crucial for planning stock levels, right? It depends on what you mean by a “forecast”. If you mean an old-school single-number forecast (“demand for item CX218b will be 3 units next week and 6 units the week after”), then no. If you broaden the meaning of forecast to include a probability distribution taking account of uncertainties in both demand and supply, then yes. […]
    • Whyt MRO Businesses Should Care about Excess InventoryWhy MRO Businesses Should Care About Excess Inventory
      Do MRO companies genuinely prioritize reducing excess spare parts inventory? From an organizational standpoint, our experience suggests not necessarily. Boardroom discussions typically revolve around expanding fleets, acquiring new customers, meeting service level agreements (SLAs), modernizing infrastructure, and maximizing uptime. In industries where assets supported by spare parts cost hundreds of millions or generate significant revenue (e.g., mining or oil & gas), the value of the inventory just doesn’t raise any eyebrows, and organizations tend to overlook massive amounts of excessive inventory. […]
    • Top Differences between Inventory Planning for Finished Goods and for MRO and Spare PartsTop Differences Between Inventory Planning for Finished Goods and for MRO and Spare Parts
      In today’s competitive business landscape, companies are constantly seeking ways to improve their operational efficiency and drive increased revenue. Optimizing service parts management is an often-overlooked aspect that can have a significant financial impact. Companies can improve overall efficiency and generate significant financial returns by effectively managing spare parts inventory. This article will explore the economic implications of optimized service parts management and how investing in Inventory Optimization and Demand Planning Software can provide a competitive advantage. […]