{"id":353,"date":"2016-08-26T10:44:46","date_gmt":"2016-08-26T14:44:46","guid":{"rendered":"http:\/\/lanhamassoc.com\/blog\/?p=353"},"modified":"2019-01-10T10:35:49","modified_gmt":"2019-01-10T15:35:49","slug":"ben-franklins-approach-to-getting-sales-history-right-for-forecasting","status":"publish","type":"post","link":"https:\/\/www.lanhamassoc.com\/blog\/ben-franklins-approach-to-getting-sales-history-right-for-forecasting\/","title":{"rendered":"Ben Franklin&#8217;s Approach to Getting Sales History Right for Forecasting"},"content":{"rendered":"<p><em><strong>By John Kimball, Senior Consultant, Lanham Associates<\/strong><\/em><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-361 aligncenter\" src=\"https:\/\/www.lanhamassoc.com\/blog\/wp-content\/uploads\/2016\/08\/franklin-with-kite-e1472219838555.jpg\" alt=\"\" width=\"200\" height=\"192\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>We have all heard the saying, &#8220;garbage in &#8211; garbage out&#8221;. So when we gather sales histories everyone tries to &#8220;scrub&#8221;the history to make sure it is representative of future expected sales. But that takes time and we might miss something! Is there a better way? One very effective way is to decide, as the history occurs, whether it will be useful or not for future forecasting. Or as Benjamin Franklin said, &#8220;An ounce of prevention is worth a pound of cure.&#8221; Here&#8217;s what I mean:<\/p>\n<p><a href=\"http:\/\/lanhamassoc.com\/blog\/wp-content\/uploads\/2016\/08\/Getting-Sales-History-Right-for-Forecasting.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-354 aligncenter\" src=\"http:\/\/lanhamassoc.com\/blog\/wp-content\/uploads\/2016\/08\/Getting-Sales-History-Right-for-Forecasting.jpg\" alt=\"Getting Sales History Right for Forecasting\" width=\"694\" height=\"367\" srcset=\"https:\/\/www.lanhamassoc.com\/blog\/wp-content\/uploads\/2016\/08\/Getting-Sales-History-Right-for-Forecasting.jpg 694w, https:\/\/www.lanhamassoc.com\/blog\/wp-content\/uploads\/2016\/08\/Getting-Sales-History-Right-for-Forecasting-300x159.jpg 300w\" sizes=\"auto, (max-width: 694px) 100vw, 694px\" \/><\/a><\/p>\n<p>After you have put these management practices in place, review the sales histories for those items with the longest lead times because these are the items where forecast errors can cause the greatest pain.<\/p>\n<p>If you&#8217;d like to learn more about our software solutions for inventory management, including our <a href=\"http:\/\/www.lanhamassoc.com\/afp.htm\">Demand Planning<\/a>\u00a0solution, or have some best practices that have helped you get better sales usage histories for input to your forecasting, let us know. You can reach us at <a href=\"mailto:education@lanhamassoc.com\">education@lanhamassoc.com<\/a>. We would love to hear from you.<\/p>\n<p>And, be sure to register for the <a href=\"https:\/\/www.regonline.com\/registration\/Checkin.aspx?EventID=2079613&amp;_cldee=a2F0ZUBsYW5oYW1hc3NvYy5jb20%3d&amp;recipientid=contact-c84f545d58d2e41180eec4346bac3acc-62035898e3674070b015361482a3efc3&amp;esid=b96cb062-07d9-e711-8125-e0071b6a6121\">2018 Forecasting &amp; Replenishment Forum,<\/a> May 8-10 in Scottsdale, AZ.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>By John Kimball, Senior Consultant, Lanham Associates &nbsp; &nbsp; We have all heard the saying, &#8220;garbage in &#8211; garbage out&#8221;. So when we gather sales histories everyone tries to &#8220;scrub&#8221;the history to make sure it is representative of future expected sales. But that takes time and we might miss something! Is there a better way? [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":2,"featured_media":361,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[45,101,102,103,100],"class_list":["post-353","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-forecasting-replenishment","tag-forecasting","tag-historical-usage","tag-inventory-management","tag-inventory-software-solutions","tag-sales-history"],"aioseo_notices":[],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/posts\/353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/comments?post=353"}],"version-history":[{"count":10,"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/posts\/353\/revisions"}],"predecessor-version":[{"id":1087,"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/posts\/353\/revisions\/1087"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/media\/361"}],"wp:attachment":[{"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/media?parent=353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/categories?post=353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lanhamassoc.com\/blog\/wp-json\/wp\/v2\/tags?post=353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}