Details

Profit From Your Forecasting Software


Profit From Your Forecasting Software

A Best Practice Guide for Sales Forecasters
Wiley and SAS Business Series 1. Aufl.

von: Paul Goodwin

32,99 €

Verlag: Wiley
Format: PDF
Veröffentl.: 13.03.2018
ISBN/EAN: 9781119415985
Sprache: englisch
Anzahl Seiten: 240

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

<p><b>Go beyond technique to master the difficult judgement calls of forecasting</b></p> <p>A variety of software can be used effectively to achieve accurate forecasting, but no software can replace the essential human component. You may be new to forecasting, or you may have mastered the statistical theory behind the software’s predictions, and even more advanced “power user” techniques for the software itself—but your forecasts will never reach peak accuracy unless you master the complex judgement calls that the software cannot make. <i>Profit From Your Forecasting Software</i> addresses the issues that arise regularly, and shows you how to make the correct decisions to get the most out of your software.</p> <p>Taking a non-mathematical approach to the various forecasting models, the discussion covers common everyday decisions such as model choice, forecast adjustment, product hierarchies, safety stock levels, model fit, testing, and much more. Clear explanations help you better understand seasonal indices, smoothing coefficients, mean absolute percentage error, and r-squared, and an exploration of psychological biases provides insight into the decision to override the software’s forecast. With a focus on choice, interpretation, and judgement, this book goes beyond the technical manuals to help you truly grasp the more intangible skills that lead to better accuracy.</p> <ul> <li>Explore the advantages and disadvantages of alternative forecasting methods in different situations</li> <li>Master the interpretation and evaluation of your software’s output</li> <li>Learn the subconscious biases that could affect your judgement toward intervention</li> </ul> <ul> <li>Find expert guidance on testing, planning, and configuration to help you get the most out of your software</li> </ul> <p>Relevant to sales forecasters, demand planners, and analysts across industries, <i>Profit From Your Forecasting Software</i> is the much sought-after “missing piece” in forecasting reference.</p>
<p>Acknowledgments xv</p> <p>Prologue xvii</p> <p><b>Chapter 1 Profit from Accurate Forecasting 1</b></p> <p>1.1 The Importance of Demand Forecasting 2</p> <p>1.2 When Is a Forecast Not a Forecast? 2</p> <p>1.3 Ways of Presenting Forecasts 3</p> <p>1.3.1 Forecasts as Probability Distributions 3</p> <p>1.3.2 Point Forecasts 4</p> <p>1.3.3 Prediction Intervals 6</p> <p>1.4 The Advantages of Using Dedicated Demand Forecasting Software 7</p> <p>1.5 Getting Your Data Ready for Forecasting 8</p> <p>1.6 Trading-Day Adjustments 10</p> <p>1.7 Overview of the Rest of the Book 11</p> <p>1.8 Summary of Key Terms 12</p> <p>1.9 References 13</p> <p><b>Chapter 2 How Your Software Finds Patterns in Past Demand Data 15</b></p> <p>2.1 Introduction 16</p> <p>2.2 Key Features of Sales Histories 16</p> <p>2.2.1 An Underlying Trend 16</p> <p>2.2.2 A Seasonal Pattern 17</p> <p>2.2.3 Noise 22</p> <p>2.3 Autocorrelation 23</p> <p>2.4 Intermittent Demand 25</p> <p>2.5 Outliers and Special Events 25</p> <p>2.6 Correlation 27</p> <p>2.7 Missing Values 30</p> <p>2.8 Wrap-Up 31</p> <p>2.9 Summary of Key Terms 31</p> <p><b>Chapter 3 Understanding Your Software’s Bias and Accuracy Measures 33</b></p> <p>3.1 Introduction 34</p> <p>3.2 Fitting and Forecasting 34</p> <p>3.2.1 Fixed-Origin Evaluations 36</p> <p>3.2.2 Rolling-Origin Evaluations 36</p> <p>3.3 Forecast Errors and Bias Measures 38</p> <p>3.3.1 The Mean Error (ME) 39</p> <p>3.3.2 The Mean Percentage Error (MPE) 40</p> <p>3.4 Direct Accuracy Measures 40</p> <p>3.4.1 The Mean Absolute Error (MAE) 40</p> <p>3.4.2 The Mean Squared Error (MSE) 41</p> <p>3.5 Percentage Accuracy Measures 42</p> <p>3.5.1 The Mean Absolute Percentage Error (MAPE) 42</p> <p>3.5.2 The Median Absolute Percentage Error (MDAPE) 44</p> <p>3.5.3 The Symmetric Mean Absolute Percentage Error (SMAPE) 44</p> <p>3.5.4 The MAD/MEAN Ratio 45</p> <p>3.5.5 Percentage Error Measures When There Is a Trend or Seasonal Pattern 46</p> <p>3.6 Relative Accuracy Measures 46</p> <p>3.6.1 Geometric Mean Relative Absolute Error (GMRAE) 47</p> <p>3.6.2 The Mean Absolute Scaled Error (MASE) 48</p> <p>3.6.3 Bayesian Information Criterion (BIC) 49</p> <p>3.7 Comparing the Different Accuracy Measures 50</p> <p>3.8 Exception Reporting 52</p> <p>3.9 Forecast Value-Added Analysis (FVA) 52</p> <p>3.10 Wrap-Up 55</p> <p>3.11 Summary of Key Terms 56</p> <p>3.12 References 57</p> <p><b>Chapter 4 Curve Fitting and Exponential Smoothing 59</b></p> <p>4.1 Introduction 60</p> <p>4.2 Curve Fitting 60</p> <p>4.2.1 Common Types of Curve 60</p> <p>4.2.2 Assessing How Well the Curve Fits the Sales History 63</p> <p>4.2.3 Strengths and Limitations of Forecasts Based on Curve Fitting 64</p> <p>4.3 Exponential Smoothing Methods 65</p> <p>4.3.1 Simple (or Single) Exponential Smoothing 65</p> <p>4.3.2 Exponential Smoothing When There Is a Trend: Holt’s Method 68</p> <p>4.3.3 The Damped Holt’s Method 70</p> <p>4.3.4 Holt’s Method with an Exponential Trend 72</p> <p>4.3.5 Exponential Smoothing Where There Is a Trend and Seasonal Pattern: The Holt-Winters Method 73</p> <p>4.3.6 Overview of Exponential Smoothing Methods 74</p> <p>4.4 Forecasting Intermittent Demand 74</p> <p>4.5 Wrap-Up 77</p> <p>4.6 Summary of Key Terms 78</p> <p><b>Chapter 5 Box-Jenkins ARIMA Models 81</b></p> <p>5.1 Introduction 82</p> <p>5.2 Stationarity 82</p> <p>5.3 Models of Stationary Time Series: Autoregressive Models 85</p> <p>5.4 Models of Stationary Time Series: Moving Average Models 87</p> <p>5.5 Models of Stationary Time Series: Mixed Models 88</p> <p>5.6 Fitting a Model to a Stationary Time Series 89</p> <p>5.7 Diagnostic Checks 91</p> <p>5.7.1 Check 1: Are the Coefficients of the Model Statistically Significant? 91</p> <p>5.7.2 Check 2: Overfitting—Should We Be Using a More Complex Model? 92</p> <p>5.7.3 Check 3: Are the Residuals of the Model White Noise? 92</p> <p>5.7.4 Check 4: Are the Residuals Normally Distributed? 93</p> <p>5.8 Models of Nonstationary Time Series: Differencing 94</p> <p>5.9 Should You Include a Constant in Your Model of a Nonstationary Time Series? 96</p> <p>5.10 What If a Series Is Nonstationary in the Variance? 97</p> <p>5.11 ARIMA Notation 97</p> <p>5.12 Seasonal ARIMA Models 98</p> <p>5.13 Example of Fitting a Seasonal ARIMA Model 101</p> <p>5.14 Wrap-Up 104</p> <p>5.15 Summary of Key Terms 105</p> <p><b>Chapter 6 Regression Models 109</b></p> <p>6.1 Introduction 110</p> <p>6.2 Bivariate Regression 110</p> <p>6.2.1 Should You Drop the Constant? 113</p> <p>6.2.2 Spurious Regression 114</p> <p>6.3 Multiple Regression 115</p> <p>6.3.1 Interpreting Computer Output for Multiple Regression 115</p> <p>6.3.2 Refitting the Model 119</p> <p>6.3.3 Multicollinearity 119</p> <p>6.3.4 Using Dummy Predictor Variables in Your Regression Model 123</p> <p>6.3.5 Outliers and Influential Observations 127</p> <p>6.4 Regression Versus Univariate Methods 129</p> <p>6.5 Dynamic Regression 131</p> <p>6.6 Wrap-Up 132</p> <p>6.7 Summary of Key Terms 132</p> <p>6.8 Appendix: Assumptions of Regression Analysis 134</p> <p>6.9 Reference 136</p> <p><b>Chapter 7 Inventory Control, Aggregation, and Hierarchies 137</b></p> <p>7.1 Introduction 138</p> <p>7.2 Identifying Reorder Levels and Safety Stocks 139</p> <p>7.3 Estimating the Probability Distribution of Demand 142</p> <p>7.3.1 Using Prediction Intervals to Determine Safety Stocks 144</p> <p>7.4 What If the Probability Distribution of Demand Is Not Normal? 146</p> <p>7.4.1 The Log-Normal Distribution 146</p> <p>7.4.2 Using the Poisson and Negative Binomial Distributions 148</p> <p>7.5 Temporal Aggregation 151</p> <p>7.6 Dealing with Product Hierarchies and Reconciling Forecasts 154</p> <p>7.6.1 Bottom-Up Forecasting 154</p> <p>7.6.2 Top-Down Forecasting 155</p> <p>7.6.3 Middle-Out Forecasting 157</p> <p>7.6.4 Hybrid Methods 157</p> <p>7.6.5 Issues and Future Developments 158</p> <p>7.7 Wrap-Up 159</p> <p>7.8 Summary of Key Terms 160</p> <p>7.9 References 161</p> <p><b>Chapter 8 Automation and Choice 163</b></p> <p>8.1 Introduction 164</p> <p>8.2 How Much Past Data Do You Need to Apply Different Forecasting Methods? 165</p> <p>8.3 Are More Complex Forecasting Methods Likely to Be More Accurate? 168</p> <p>8.4 When It’s Best to Automate Forecasts 169</p> <p>8.5 The Downside of Automation 173</p> <p>8.6 Wrap-Up 174</p> <p>8.7 References 175</p> <p><b>Chapter 9 Judgmental Interventions: When Are They Appropriate? 177</b></p> <p>9.1 Introduction 178</p> <p>9.2 Psychological Biases That Might Catch You Out 179</p> <p>9.2.1 Seeing Patterns in Randomness 179</p> <p>9.2.2 Recency Bias 180</p> <p>9.2.3 Hindsight Bias 181</p> <p>9.2.4 Optimism Bias 181</p> <p>9.3 Restrict Your Interventions 183</p> <p>9.3.1 Large Adjustments Perform Better 183</p> <p>9.3.2 Focus Your Efforts Where They’ll Count 184</p> <p>9.4 Making Effective Interventions 185</p> <p>9.4.1 Divide and Conquer 185</p> <p>9.4.2 Using Analogies 186</p> <p>9.4.3 Counteracting Optimism Bias 187</p> <p>9.4.4 Harnessing the Power of Groups of Managers 189</p> <p>9.4.5 Record Your Rationale 192</p> <p>9.5 Combining Judgment and Statistical Forecasts 192</p> <p>9.6 Wrap-Up 194</p> <p>9.7 Reference 194</p> <p><b>Chapter 10 New Product Forecasting 195</b></p> <p>10.1 Introduction 196</p> <p>10.2 Dangers of Using Unstructured Judgment in New Product Forecasting 197</p> <p>10.3 Forecasting by Analogy 198</p> <p>10.3.1 Structured Analogies 198</p> <p>10.3.2 Applying Structured Analogies 199</p> <p>10.4 The Bass Diffusion Model 203</p> <p>10.4.1 Innovators and Imitators 203</p> <p>10.4.2 Estimating a Bass Model 204</p> <p>10.4.3 Limitations of the Basic Bass Model 206</p> <p>10.5 Wrap-Up 207</p> <p>10.6 Summary of Key Terms 208</p> <p>10.7 References 209</p> <p><b>Chapter 11 Summary: A Best Practice Blueprint for Using Your Software 211</b></p> <p>11.1 Introduction 212</p> <p>11.2 Desirable Characteristics of Forecasting Software 212</p> <p>11.2.1 Data Preparation 212</p> <p>11.2.2 Graphical Displays 212</p> <p>11.2.3 Method Selection 214</p> <p>11.2.4 Implementing Methods 215</p> <p>11.2.5 Hierarchies 215</p> <p>11.2.6 Forecasting with Probabilities 215</p> <p>11.2.7 Support for Judgment 216</p> <p>11.2.8 Presentation of Forecasts 216</p> <p>11.3 A Blueprint for Best Practice 217</p> <p>11.4 References 218</p> <p>Index 219</p>
<p><b>PAUL GOODWIN, P<small>H</small>D,</b> is Professor Emeritus at University of Bath, Bath, UK, where he teaches courses on Management Science, business forecasting, and decision analysis. He regularly conducts workshops at forecasting events around the world. A Fellow of the International Institute of Forecasters, he is a well-known keynote speaker at SAS.
<p><b>SUPPLIES THE MISSING PIECE IN YOUR FORECASTING PROCESS</b> <p>No matter how sophisticated the forecasting software you use, your forecasts will not achieve peak accuracy until you master the complex judgment calls that only a human can make. The first book of its kind, <i>Profit from Your Forecasting Software</i> shows you how to make the correct decisions to get the most out of your software. <p>Taking a non-mathematical approach, it explores common decisions such as choosing the most appropriate model, adjusting forecasts, product hierarchies, safety stock levels, model fit, testing, and more. It also provides plain-English explanations of crucial concepts such as seasonal indices, smoothing coefficients, mean absolute percentage error, and r-squared. And it helps you: <ul> <li>Choose the best forecasting methods for a range of different purposes and situations</li> <li>Master the interpretation and evaluation of your software's output</li> <li>Gain insight into the psychological biases that can influence forecasters' judgment calls</li> <li>Know when and if to override your software's predictions</li> <li>Learn to test, plan, and configure your software for optimal accuracy</li> </ul> <p>Whether you're a forecasting ace, a reluctant newcomer, or anything in-between, <i>Profit from Your Forecasting Software</i> is one professional resource you can't afford to be without.

Diese Produkte könnten Sie auch interessieren:

Modeling Uncertainty
Modeling Uncertainty
von: Moshe Dror, Pierre L'Ecuyer, Ferenc Szidarovszky
PDF ebook
236,81 €
Level Crossing Methods in Stochastic Models
Level Crossing Methods in Stochastic Models
von: Percy H. Brill
PDF ebook
203,29 €
Continuous Bivariate Distributions
Continuous Bivariate Distributions
von: N. Balakrishnan, Chin Diew Lai
PDF ebook
128,39 €