{"id":15852,"date":"2015-09-07T15:24:31","date_gmt":"2015-09-07T13:24:31","guid":{"rendered":"https:\/\/akite.net\/la-previsione-di-vendita-per-un-magazzino-meglio-fornito-e-meno-costoso\/"},"modified":"2023-07-18T11:10:54","modified_gmt":"2023-07-18T09:10:54","slug":"la-previsiosales-forecast-for-a-better-stocked-and-less-expensive-warehousene-di-vendita-per-un-magazzino-meglio-fornito-e-meno-costoso","status":"publish","type":"post","link":"https:\/\/akite.net\/en\/la-previsiosales-forecast-for-a-better-stocked-and-less-expensive-warehousene-di-vendita-per-un-magazzino-meglio-fornito-e-meno-costoso\/","title":{"rendered":"Sales forecast for a better stocked and less expensive warehouse"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"15852\" class=\"elementor elementor-15852\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-49036492 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"49036492\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-780f1387\" data-id=\"780f1387\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-762b2fbc elementor-widget elementor-widget-text-editor\" data-id=\"762b2fbc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.16.0 - 20-09-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<!-- wp:paragraph -->\n<p style=\"text-align: justify;\">The merchandise is often the biggest investment for a Retail business and, on the other hand, the assortment width and depth, plus the absence of stock-outs are fundamental factors in service quality perceived by the customer.<\/p>\n<p style=\"text-align: justify;\">The classic approach for computer assisted replenishment is based on a Minimum Stock (or Reorder Point) for each product, in some cases updated in batch mode with criteria linked to sales past history.<\/p>\n<p style=\"text-align: justify;\">The problems of such an approach, apart from the manual activity required to refresh the Reorder points and the quantity to be ordered, are:<\/p>\n<ul>\n<li>\n<p style=\"text-align: justify;\">Fluctuations in demand due to manufactures&rsquo; advertising campaigns or local promotions on the product itself or on replacement products, as well as abnormal meteorological conditions or the entry of new competitors in the local market (new stores) or global (new products)<\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p style=\"text-align: justify;\">Seasonality<\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p style=\"text-align: justify;\">Product life-cycle (introduction, maturity or decline phase)<\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>Service Level<\/h3>\n<p style=\"text-align: justify;\">To optimize the investment in merchandise and floor space, the basic idea is to order as late as possible and the lowest quantity (but in economical lots, considering both transport and physical management costs) while avoiding, as much as possible, any stock-out. This is clearly a probabilistic problem because the certainty would have an exaggerated cost. On the other hand a 90% Service Level, that means having stock-out for no more than 10% of the products and no more than 10% of the time, can be consistent with a Store \/ Chain price and image level. In other cases a higher Service Level is required, for example of 95 or 98%, associated with greater investment in stock and floor space.<\/p>\n<p>&nbsp;<\/p>\n<h3>Availability Days<\/h3>\n<p style=\"text-align: justify;\">The main concept for these considerations is Availability Days, the number of days for which a product stock will remain available for sale:<\/p>\n<!-- \/wp:paragraph -->\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8bc479f elementor-widget elementor-widget-image\" data-id=\"8bc479f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.16.0 - 20-09-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"328\" height=\"83\" src=\"https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/formulaeng1.png\" class=\"attachment-medium_large size-medium_large wp-image-15858\" alt=\"\" srcset=\"https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/formulaeng1.png 328w, https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/formulaeng1-300x76.png 300w\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6276c1 elementor-widget elementor-widget-text-editor\" data-id=\"b6276c1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p style=\"text-align: justify;\">The Availability (Stock + Pending Purchase Orders &ndash; Pending Reservations from customers) is easy to calculate, while the forecast is more complex. The mathematical algorithm used by aKite is called &ldquo;exponential smoothing&rdquo;, well suited for short-term forecasts. It shows a first estimate after the second sale and takes in account non-sale days during stock-out. The algorithm also detects if the trend is increasing or decreasing and if the change is moderate or strong, or if it is relatively stable and the fluctuations are large or limited. It also signals if the trend is extremely unstable. These factors influence the stock required to obtain a pre-defined Service Level. The greater is the forecast uncertainty and the higher the security level K necessary to ensure a high Service Level.<\/p>\n<p style=\"text-align: justify;\">Let&rsquo;s consider two simple examples:<\/p>\n<p style=\"text-align: justify;\">Product <strong>A)<\/strong> Stock = 10 Pcs &#8211; Forecast = 1 unit \/ day<\/p>\n<p style=\"text-align: justify;\">Product <strong>B)<\/strong> Stock = 50 Pcs &#8211; Forecast = 10 Pcs \/ day<\/p>\n<p style=\"text-align: justify;\">Which of the two is expected to run out first?<\/p>\n<p style=\"text-align: justify;\">The Availability Days forecasted for<strong> A<\/strong> are 10\/1 =<strong> 10<\/strong> while for <strong>B<\/strong> are 50\/10 = <strong>5<\/strong>. Then B, despite having a significantly higher stock, will likely run out before A.<\/p>\n<p>&nbsp;<\/p>\n<h3>Delivery time<\/h3>\n<p style=\"text-align: justify;\">The other important parameter is the Delivery Time. If Product A supplier had a delivery time of 20 days, then it is already too late to order (forecasted availability is for 10 days), but if delivery time is 5 days, it is possible to wait for a further stock reduction.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-65b8002 elementor-widget elementor-widget-image\" data-id=\"65b8002\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"531\" height=\"336\" src=\"https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/Diag_ENG.png\" class=\"attachment-medium_large size-medium_large wp-image-15856\" alt=\"\" srcset=\"https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/Diag_ENG.png 531w, https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/Diag_ENG-300x190.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-71680c4 elementor-widget elementor-widget-text-editor\" data-id=\"71680c4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p style=\"text-align: justify;\">The diagram show the K factor that reduces the risk of &#8220;out of stock&#8221; with an actual delivery time longer than expected or a sudden increase in the sales pace. The problem is that increasing excessively and indiscriminately in the K-factor, increases the Service Level but also the stock, with excessive investment. <strong>aKite<\/strong> automatically sizes the factor K as a function of various parameters.<\/p>\n<p>&nbsp;<\/p>\n<h3>Best Delivery Conditions<\/h3>\n<p style=\"text-align: justify;\">Often 80% of a store merchandise range is made up of &ldquo;slow moving&rdquo; items, but nonetheless essential for a good customer service level. For these items, the critical factor is usually not the delivery time, but the minimum purchase, often linked to the package contents, which can be 6, 12, 24, .. or 10, 20, 100, &#8230; pieces.<\/p>\n<p style=\"text-align: justify;\">For example, with a minimum order of 12 pieces and sales forecast of 1 unit per month, an quantity that will be sold in about one year, it becomes less important if the hypothetical manufacturer ACME delivers in 5 or 20 days. An alternative supplier that would provide the same product in individual pieces, although with a slightly longer delivery time, would be more convenient. The convenience would reverse if the minimum purchase of 12 pieces would cover the sales for just one week and not for one year.<\/p>\n<p style=\"text-align: justify;\">When there are alternative suppliers for the same product, the choice of the one with the best delivery conditions therefore depends on the Minimum order, the Delivery time, but especially on the sale pace of the product. aKite is able to make dynamically this choice, in addition to privilege the Preferred supplier and \/ or the one with the Minimum price.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4284ff1 elementor-widget elementor-widget-image\" data-id=\"4284ff1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"635\" height=\"455\" src=\"https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/shop_ENG.png\" class=\"attachment-medium_large size-medium_large wp-image-15860\" alt=\"\" srcset=\"https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/shop_ENG.png 635w, https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/shop_ENG-300x215.png 300w, https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/shop_ENG-560x400.png 560w, https:\/\/akite.net\/wp-content\/uploads\/2015\/09\/shop_ENG-110x80.png 110w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cbbe571 elementor-widget elementor-widget-text-editor\" data-id=\"cbbe571\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>An approach for creating optimum automatic replenishment proposals is to set Reordering points low, compatible with low sales pace or minimum display, and consider ALSO Sales Forecast and Delivery Time criteria for not running out of goods in high sales times, but at the same time minimizing the stock investment in relation to the target Service Level.<\/p>\n<p>&nbsp;<\/p>\n<h3>Conclusions<\/h3>\n<p style=\"text-align: justify;\">The IT problem has never been the quantity, but the relevance of the data provided for human decision support. With the Cloud near-infinite resources, the frontier moves to automation that reflect market dynamics on the daily execution as, for example, optimal purchase orders or issuing coupons highly significant for the customer.<\/p>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>The merchandise is often the biggest investment for a Retail business and, on the other hand, the assortment width and depth, plus the absence of stock-outs are fundamental factors in service quality perceived by the customer. The classic approach for computer assisted replenishment is based on a Minimum Stock (or Reorder Point) for each product, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[80],"tags":[],"class_list":["post-15852","post","type-post","status-publish","format-standard","hentry","category-commerciali-en","no-post-thumbnail"],"aioseo_notices":[],"acf":[],"_links":{"self":[{"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/posts\/15852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/comments?post=15852"}],"version-history":[{"count":4,"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/posts\/15852\/revisions"}],"predecessor-version":[{"id":15866,"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/posts\/15852\/revisions\/15866"}],"wp:attachment":[{"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/media?parent=15852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/categories?post=15852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/akite.net\/en\/wp-json\/wp\/v2\/tags?post=15852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}