{"id":4197,"date":"2024-12-02T09:00:14","date_gmt":"2024-12-02T08:00:14","guid":{"rendered":"https:\/\/data4success.de\/?p=4197"},"modified":"2024-12-02T15:33:31","modified_gmt":"2024-12-02T14:33:31","slug":"analysis-of-margins-and-prices-for-articles-and-customer-groups","status":"publish","type":"post","link":"https:\/\/data4success.de\/en\/analysis-of-margins-and-prices-for-articles-and-customer-groups\/","title":{"rendered":"Analysis of margins and prices for articles and customer groups"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"4197\" class=\"elementor elementor-4197\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6e45c8f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e45c8f\" data-element_type=\"section\" data-e-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-f29e04a\" data-id=\"f29e04a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6685d70 elementor-widget elementor-widget-text-editor\" data-id=\"6685d70\" data-element_type=\"widget\" data-e-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\t\t<p><strong>Do you know the margins of your articles?<\/strong><\/p><p>Many companies know which customer generates which turnover or which articles are the most successful. But what about the margins? These are crucial, as they depend directly on purchase prices and sales prices. And only if you know these can you manage your prices optimally.<\/p><p>In this blog article, we would like to show you how you can analyze margins in detail and derive recommendations for action - supported by our <a href=\"https:\/\/data4success.de\/en\/price-analysis-with-powerbi\/\"><strong>Pricing Report<\/strong><\/a>which you can also try out on our website.<\/p>\t\t\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cd8d531 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cd8d531\" data-element_type=\"section\" data-e-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-db52e55\" data-id=\"db52e55\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f652a37 elementor-widget elementor-widget-html\" data-id=\"f652a37\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div style=\"position: relative; padding-bottom: 62.5%; height: 0;\"><iframe src=\"https:\/\/www.loom.com\/embed\/3a9856a1fdac46d4b7751841ca6849e5?sid=686b91da-daf9-47fe-a199-dcbcb98bc21c\" frameborder=\"0\" webkitallowfullscreen mozallowfullscreen allowfullscreen style=\"position: absolute; top: 0; left: 0; width: 100%; height: 100%;\"><\/iframe><\/div>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6e369ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e369ea\" data-element_type=\"section\" data-e-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-bb7fc04\" data-id=\"bb7fc04\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a3094e2 elementor-widget elementor-widget-text-editor\" data-id=\"a3094e2\" data-element_type=\"widget\" data-e-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\t\t<h3>\u00a0<\/h3><h3><strong>A look at the pricing report: analysis of margin development<\/strong><\/h3><p>The pricing report provides you with a detailed overview of your articles and their margin development:<\/p><ul><li><strong>Margin overview per article<\/strong>You can see how the margins of an item have developed compared to the previous year. For example, the \"Black Classic\" bookcase lost a margin of 72.8 % in the previous year to 72 % in the current year - a decrease of 0.8 %.<\/li><li><strong>Root cause analysis<\/strong>The margin is made up of the ratio of purchase price (PP) to sales price (SR). In this case, the purchase price has risen from \u20ac13.40 to \u20ac13.70, while the sales price has increased from \u20ac47.10 to \u20ac47.90. Nevertheless, the margin fell because the percentage increase in the purchase price was greater than the price adjustment.<\/li><\/ul>\t\t\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cdd99a9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cdd99a9\" data-element_type=\"section\" data-e-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-1d06725\" data-id=\"1d06725\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a79484f elementor-widget elementor-widget-text-editor\" data-id=\"a79484f\" data-element_type=\"widget\" data-e-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\t\t<h3><strong>Recommendations for action at the touch of a button<\/strong><\/h3><p>The pricing report goes beyond analysis and provides clear recommendations for action:<\/p><ul><li>In order to achieve the original margin of 72.8 %, for example, it is recommended that the average shelf price be raised to \u20ac49.40 - an increase of \u20ac1.50.<\/li><li>This recommendation is based on real transactions, which are broken down in the report at customer group level.<\/li><\/ul>\t\t\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-943c58c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"943c58c\" data-element_type=\"section\" data-e-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-67c3d2f\" data-id=\"67c3d2f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4d3a1c9 elementor-widget elementor-widget-text-editor\" data-id=\"4d3a1c9\" data-element_type=\"widget\" data-e-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\t\t<h3><strong>Detailed insights per customer group<\/strong><\/h3><p>A particularly valuable feature of the pricing report is the analysis per customer group. This makes it clear that average values often do not reflect reality. One example:<\/p><ul><li>While the overall margin of an item is 72 %, the \"Comfortable sleeping environments\" customer group only achieved 54.8 % - a decrease compared to 56.5 % in the previous year.<\/li><li>The reason: this customer receives the item for \u20ac29.70, far below the average retail price of \u20ac47.90. Such deviations may be due to price lists or special conditions that may be out of date.<\/li><\/ul>\t\t\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-539ea5a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"539ea5a\" data-element_type=\"section\" data-e-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-54c2c04\" data-id=\"54c2c04\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-20a7aa0 elementor-widget elementor-widget-text-editor\" data-id=\"20a7aa0\" data-element_type=\"widget\" data-e-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\t\t<h3><strong>Practical example: Detecting price corpses in the system<\/strong><\/h3><p>You can go straight into the details with the pricing report:<\/p><ul><li>Filter the affected article numbers in the ERP system and check the stored price lists and special conditions.<\/li><li>The cause often lies in so-called \"price corpses\" - old, never checked special prices that have remained unchanged for years.<\/li><li>Such conditions can be identified and adjusted to avoid unprofitable margins.<\/li><\/ul>\t\t\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6982d26 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6982d26\" data-element_type=\"section\" data-e-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-49749b3\" data-id=\"49749b3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-51c7fcb elementor-widget elementor-widget-text-editor\" data-id=\"51c7fcb\" data-element_type=\"widget\" data-e-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\t\t<h3><strong>Actionable Insights: Optimize margins and increase profits<\/strong><\/h3><p>The Pricing Report is more than just an analysis tool - it leads you directly to actionable measures. You can:<\/p><ul><li>Identify outliers at customer and item level.<\/li><li>Adjust prices individually to bring margins back to a profitable level.<\/li><li>Increase your margins sustainably by recognizing bottlenecks and shortages.<\/li><\/ul>\t\t\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cfcf81a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cfcf81a\" data-element_type=\"section\" data-e-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-ddca6d1\" data-id=\"ddca6d1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4cf95d6 elementor-widget elementor-widget-text-editor\" data-id=\"4cf95d6\" data-element_type=\"widget\" data-e-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\t\t<h3><strong>Do you already have such a report in use?<\/strong><\/h3><p>If not, we cordially invite you to try out our pricing report without obligation. It is compatible with almost all ERP systems - from Microsoft Dynamics to other solutions.<\/p><p><a href=\"https:\/\/data4success.de\/en\/contact\/\"><strong>Get in touch with us<\/strong><\/a> and find out how you can optimize your margins with precise analyses and clear recommendations.<\/p><p>We look forward to introducing you to the possibilities of our tool!<\/p>\t\t\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>","protected":false},"excerpt":{"rendered":"<p>Kennen Sie die Margen Ihrer Artikel? Viele Unternehmen wissen, welcher Kunde welchen Umsatz generiert oder welche Artikel am erfolgreichsten sind. Doch wie steht es um die Margen? Diese sind entscheidend, da sie direkt von Einkaufspreisen und Verkaufspreisen abh\u00e4ngen. Und nur wenn Sie diese kennen, k\u00f6nnen Sie Ihre Preise optimal steuern. In diesem Blogartikel m\u00f6chten wir [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":3542,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4197","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/comments?post=4197"}],"version-history":[{"count":4,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4197\/revisions"}],"predecessor-version":[{"id":4203,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4197\/revisions\/4203"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media\/3542"}],"wp:attachment":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media?parent=4197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/categories?post=4197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/tags?post=4197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}