BlumShapiro Consulting - Product Profitability Assessment

Gaining a true understanding of where your business is generating profit can be a challenge due to the lack of available or quality data within your firm, especially during these tough times. Our team can partner with your organization to complete a cost and profitability assessment to look at these issues head-on. This assessment will unlock what your business’ strategy should focus on including the industry, customer, products or services, and/or geography where the profitable growth is coming from. During the COVID-19 pandemic the areas that are usually profitable for your business may have changed and now is a great opportunity to see where your organization’s profitability is truly coming from.

Contact partner Watch video
In this showcase the client is a golf equipment manufacturer with the goal of more accurately assigning manufacturing overhead costs.  Our team allocated overhead to a SKU level margin, breaking down costs by labor and product production stage ratios.  The client provided a product list, customer list and five-year income statement.

The reports provides the client with the ability to analyze revenue and cost components for each customer, product line and product.  All analysis pages of the report include dynamic income statement measures and a revenue by year breakdown chart with forecasts and drill down capabilities.

The reports allows the client to:

  • Drill down Revenue by Year chart to view monthly sales numbers.
  • View income statement break downs by customer, product line and product to understand drivers of cost and profit.
  • Compare top three revenue producing customers with all others.
  • Compare gross profit by customer location using interactive map.
  • Filter using dynamic slicers
  • View income statement measures per unit for each product and product line

Want to become a Power BI Partner?

Certified partners are an important part of the team! Find new business opportunities, make connections, and share your company’s talents and experience with Power BI users around the world.

Sign up

Learn why you should become a partner