{"id":10826,"date":"2022-11-17T14:02:02","date_gmt":"2022-11-17T14:02:02","guid":{"rendered":"https:\/\/koivusolutions.com\/?p=10826"},"modified":"2023-02-22T11:25:37","modified_gmt":"2023-02-22T11:25:37","slug":"how-hako-ground-garden-renewed-their-pricing","status":"publish","type":"post","link":"https:\/\/koivusolutions.com\/index.php\/2022\/11\/17\/how-hako-ground-garden-renewed-their-pricing\/","title":{"rendered":"How Hako Ground & Garden renewed their pricing"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Hako Ground & Garden is the Nordic leader on the market for machines for the maintenance of indoor and outdoor surfaces. Let\u2019s hear their story about how we renewed their pricing tools.\u00a0<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\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<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

End of the road
<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Almost every pricing team uses Microsoft Excel in some part of the product pricing process. Over the years, these spreadsheets have become more like applications and central tools for price management. As a result, someone is responsible for maintaining the pricing rules and other internal parts of the spreadsheet, while others \u2018enjoy\u2019 using it or seeing the results. This model is quite efficient in the short term, but in the long term, it lacks continuity, and continuous improvements to the pricing process are impossible. Hako wanted to avoid the risks of this process, and to rethink their approach, they contracted Koivu to help them to take the next step after Excel.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\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<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Supplier information<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Excel is the world\u2019s most used data exchange \u2018protocol\u2019 between companies, and Hako also receives all their supplier data and prices as spreadsheets and CSV files. In practice, this means thousands of rows of pure data together with visually formatted supplier price book pages. From these sources, it\u2019s difficult to see the actual net change of information compared to the last round of updates. Additionally, inflation is peaking, and supplier price changes come at an increasing pace.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\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<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Pricing dimensions<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Hako\u2019s price book is a massive spreadsheet with over 200 pages. They\u2019ve built it manually using an Excel-only approach. In addition to normal supplier products, it also includes configurable products, some spare parts, and special management for new and EOL products. The pricing sequence contains multiple levels and produces dealer and end-customer prices with margin information.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\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<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Goals for pricing process improvements for Hako were<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
  • Time efficiency to enable frequent changes<\/li>
  • Eliminate the risk of human errors to provide psychological safety<\/li>
  • Free up time for more strategic work to enable the next phase: what the price really should be?<\/li>
  • Price book (PDF) to be more dealer and sales friendly, professional look for key customers, and easy to understand<\/li><\/ul>\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<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    <\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    Still Excel but no Excel files<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    <\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t

    The new solution enabled the team to keep using the familiar Excel interface. This is an important factor because, from the dozens of different suppliers, most still deliver their data as spreadsheets. The team can simply import this data using copy-paste or Excel functions that match the rows. Everything else happens in the cloud – there are no more Excel files to be managed, and data is contained in the database instead.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    <\/div>\n\t\t<\/div>\n\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<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    Automation<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    <\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t

    Moving into the new system required setting up the base data, but from then on, many things became automated. For example, generating a new price book is now automated, and you can create a new price book version easily by taking the previous version as a baseline. Centrally managed price modifiers ensure that no pricing errors go unnoticed. Additionally, you can easily compare prices, margins, and costs to make sure that the pricing is aligned.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    <\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\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
    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    <\/div>\n\t\t<\/div>\n\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<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    Summary<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    <\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t

    Advancing from the Excel-only pricing approach to the cloud-based pricing system helps Hako to produce more competitive prices. The frequency of price changes has been increased without extra resources, and the pricing can be better optimized to meet new market conditions, such as rising inflation. Accurate pricing also benefits customers.<\/p>\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<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

    Hako Ground & Garden is the Nordic leader on the market for machines for the maintenance of indoor and outdoor surfaces. Let\u2019s hear their story about how we renewed their pricing tools.\u00a0 End of the road Almost every pricing team uses Microsoft Excel in some part of the product pricing process. Over the years, these…<\/p>\n","protected":false},"author":1,"featured_media":10835,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[16,64],"tags":[],"class_list":["post-10826","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-company-news","category-customer-case-studies"],"_links":{"self":[{"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/posts\/10826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/comments?post=10826"}],"version-history":[{"count":9,"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/posts\/10826\/revisions"}],"predecessor-version":[{"id":10840,"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/posts\/10826\/revisions\/10840"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/media\/10835"}],"wp:attachment":[{"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/media?parent=10826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/categories?post=10826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/koivusolutions.com\/index.php\/wp-json\/wp\/v2\/tags?post=10826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}