Are you Conscious of the Potential of Your Information Experience in Driving Enterprise Profitability? | by Samir Saci | Oct, 2024

A mirrored image of a provide chain knowledge scientist who randomly found the facility of knowledge analytics to assist small and enormous companies

Photograph by Fabian Clean on Unsplash

The most important problem I confronted in analytics tasks was estimating the return on funding (ROI) of an answer.

What’s the ROI of a forecasting engine for gross sales prediction?

That is typically the primary query a decision-maker asks whenever you suggest designing a instrument to unravel their operational or enterprise downside.

As an answer design supervisor in logistics, my job was to cost warehousing and transportation operations for retail and trend firms.

Due to this, estimating the ROI of my options was barely extra manageable, but it surely was nonetheless troublesome to persuade decision-makers.

For instance, I might clarify, “This algorithm will enhance choosing productiveness by 25%, which can end in a 12% discount in variable prices.”

These successes impressed me to share the options protecting 60+ operational case research printed on this Medium weblog.

Whereas my focus was on enhancing logistics operations, one thing sudden occurred alongside the way in which:

What if I shifted my focus to enterprise profitability?

In a single undertaking, I utilized these instruments to a enterprise case examine: maximizing the profitability of a bakery.

The suggestions I acquired helped me understand that each small and enormous companies have to optimize their margins and automate data-driven choices.

By talking the language of enterprise, I might promote my analytics options extra successfully.

On this article, I wish to share the insights I’ve gained from discovering the facility of knowledge to assist companies — and why I imagine it’s best to take into account this path, too.

Abstract

I. Introduction
Exploring the problem of proving ROI in analytics tasks
II. How Did I Develop My Enterprise Acumen?
Sharing my early profession expertise as a Answer Design Supervisor
III. My journey discovering knowledge analytics for enterprise optimization
Optimization strategies to assist a bakery enterprise enhance profitability.
VI. Use your Analytics Expertise to Resolve Enterprise Issues
How knowledge analytics can reply the wants of choice makers.
V. The way to Adapt your Analytics Strategy to Enterprise Issues?
The significance of translating enterprise issues into easy analytics options
VI. Conclusion
Understanding processes is a vital ability to reply enterprise issues

How did I develop my enterprise acumen?

For the primary 4 years of my profession, I designed warehousing and transportation options for main worldwide firms throughout Asia.

What does a Provide Chain Answer Design Supervisor do?

For instance, think about a retailer like Costco desires to arrange a distribution centre in Shanghai.

  1. They supply knowledge on volumes and course of necessities in an RFP.
  2. My job is to design the answer (format, staffing, tools) and develop the pricing based mostly on a price mannequin with over 100 parameters.
  3. We current the answer to the client with an in depth pricing grid.

Our major concern? Gross margin!

To win the undertaking, I had to make sure aggressive pricing whereas sustaining a minimal margin with out pricing beneath our prices.

“Donut chart displaying the breakdown of handling price (€1.25 per box for picking) in a logistics operation. The largest portion, workforce costs (€0.57), is shown in pink. Equipment and consumables (€0.37) are represented in blue, fixed warehouse costs (€0.20) in green, and gross margin (€0.11) in peach. The chart visually emphasizes the distribution of costs and gross margin for the pricing model.
Pricing Construction — (Picture by Writer)

For instance, if I quoted €1.25 per field for choosing, I knew precisely how the prices and margin have been damaged down

  • €0.57 for workforce prices
  • €0.37 for tools and consumables
  • €0.20 for fastened warehouse prices
  • €0.11 for our gross margin (an 8.8% margin on gross sales)

What’s subsequent? You win the enterprise and signal a three-year contract for a 5M€ funds.

However what occurs if the client desires to decrease the worth to €1.10 per field?

This typically occurs in low-margin firms like conventional retailers, automotive after-sales distributors or client items.

You will need to discover methods to cut back prices whereas maintaining your 8.8% margin intact.

Due to this fact, I’ve been utilizing knowledge analytics to

Enhanced donut chart showing the breakdown of handling price (€1.25 per box for picking) with additional diagrams on both sides. The largest section, workforce costs (€0.57), is highlighted in pink with an arrow pointing left to a picking path diagram. Fixed warehouse costs (€0.20) in green points right to an image of warehouse storage layout. Equipment and consumables (€0.37) is shown in blue. The gross margin (€0.11) is displayed in peach. The visuals emphasize key operational costs and workf.
Steady Enchancment Initiatives — (Picture by Writer)

Together with many different operational enhancements supported by knowledge analytics, that are shared on this Medium weblog.

Can I apply related methodologies outdoors of logistics?

My journey discovering knowledge analytics for enterprise optimization

It started whereas consulting for a small logistics firm that delivered merchandise to bakeries in Paris.

With my naive perspective as an answer designer, I spoke with a bakery chain proprietor to know their enterprise mannequin:

  • What’s the revenue margin (%) on a baguette offered for €1.50?
  • How a lot does the workforce value (€) per croissant offered?
  • What proportion (%) of your prices are fastened?
  • What’s the most worthwhile merchandise in your store?

To my shock, they couldn’t reply any of those questions.

I noticed there was one other strategy to doing enterprise, the place costs have been set with out specific information of the underlying prices, and operational visibility was virtually zero.

This was an enormous alternative — what if we supplied these enterprise house owners with the visibility and insights they desperately wanted?

So, I took on the problem of modelling a bakery.

I utilized the identical methodology I used for steady enchancment tasks in logistics:

  1. Perceive their present operations: fastened and variable prices, bottlenecks and income sources.
  2. Accumulate and course of knowledge, making mandatory assumptions (e.g., manufacturing prices and sale costs for every merchandise).
  3. Construct a Python mannequin to copy their present setup and simulate totally different situations.

The result’s the answer offered within the article: Maximize Enterprise Profitability with Python.

Flowchart illustrating the steps for optimizing business profitability. The first step, ‘Understand Operations,’ is represented by icons for gears, storage, a bakery, and a production line. The second step, ‘Collect Data,’ includes icons for financial charts, documents, a clock, and an oven. The final step, ‘Build a Model,’ is shown with the Python logo, indicating the use of Python for modeling and simulation. This visual guides the process from operations to data modeling for profitability.
Methodology Utilized for the Bakery Profitability Case — (Picture by Writer)

What’s the most worthwhile mixture of merchandise to promote?

Contemplating the restricted assets to provide and retailer merchandise, this mannequin can present the precise mixture of merchandise to promote.

The affect on the consumer exceeded my expectations.

“That is the primary time I can estimate the affect of my enterprise methods on general profitability,” the proprietor mentioned.

Bar chart illustrating resource usage in a bakery production process. The chart shows four categories: oven capacity, storage space, and two worker categories (one male and one female baker). Each category is represented by an icon on the left, with green bars indicating the usage level for each resource. The oven and worker categories have the longest bars, indicating higher utilization, while storage space shows a shorter bar.
Addition Indicators: Gear and Workforce utilization ratio — (Picture by Writer)

After a number of iterations, we improved the algorithm to supply attention-grabbing insights.

Samir: “The bottlenecks of your manufacturing are the human assets and your oven capability.”

For such a easy algorithm, coded in lower than an hour, the perceived enterprise worth was far better than what I experimented with previously.

This marked a turning level in my strategy to utilizing knowledge analytics for enterprise affect.

How are you going to help companies together with your analytics abilities?

Use your Analytics Expertise to Resolve Enterprise Issues

Since beginning my consultancy and growing my sustainable provide chain SaaS, I exchanged with dozens of entrepreneurs throughout a number of industries.

This is a chance to evaluate my capabilities of fixing their issues with knowledge and enterprise acumen.

What do they want? Let’s discover an instance!

A good friend of mine, who runs a small enterprise within the F&B business, used my mannequin to help decision-making and maximize income.

Illustration showing the supply chain flow from supplier to customer, including stages such as freight transport, warehouse storage, and delivery. The icons represent each stage: supplier, freight via air and sea, warehouse, delivery by truck, and customer, visually emphasizing the key elements in inventory and distribution management for small businesses.

Enterprise mannequin of my good friend — (Picture by Writer)

They supply renewable cups from China and ship them by way of air or sea freight to a neighborhood warehouse.

From the warehouse, the cups are delivered to espresso retailers and distributors.

What issues can knowledge analytics clear up on this case?

Amongst his greatest challenges have been stock administration and money movement.

“We’ve needed to flip down orders as a result of we don’t have sufficient money to pay suppliers for restocking,” he defined.

The core problem was clear: they wanted visibility on their monetary flows.

Illustration of a small business supply chain model showing key elements like supplier costs per unit, freight costs per unit, warehouse storage costs per unit per week, and delivery costs per unit. The image also includes service level agreements (SLA), inventory management processes, sales channel strategy, and customer pricing per unit, visually representing the cost and revenue flows for inventory and cash flow management.

Worth chain of the espresso cups — (Picture by Writer)

I wanted to map out all of the parameters concerned to handle this problem and mannequin the worth chain.

  • Fee phrases and lead instances from suppliers.
  • Service degree agreements and fee phrases with prospects, segmented by gross sales channels (direct prospects vs. distributors).
  • Mounted operational prices and money movement administration.

Diagram illustrating the components of a simulation tool used to estimate profitability and liquidity needs for a business. It includes customer data inputs like demand and turnover, operational costs, and an inventory rule that triggers replenishment orders to suppliers. The cash flow module tracks profit and loss, while the costs module manages fixed and variable costs. The flow of information through the system provides insights into the business’s financial health.

Simulation Engine of the enterprise — (Picture by Writer)

The result’s a simulation engine written in Python (with an affordable granularity) that replicates my good friend’s enterprise.

What’s subsequent? We will reply all my good friend’s questions!

My good friend’s greatest frustration was the dearth of visibility and the lack to check hypotheses.

  • What if we cut back inventory protection from 8 weeks to six weeks?
  • Wouldn’t it be more cost effective to make use of air freight for deliveries?
  • Ought to we shift our gross sales technique to focus solely on distributors?

As a result of complexity of the parameters concerned, he couldn’t get clear solutions earlier than.

Table comparing different inventory management scenarios: Initial, 6 weeks, Air Freight, Distributors, and Optimal. Metrics include initial cash on hand, cost of goods sold (COGS) per pallet, logistic costs, and profitability per pallet. The table shows the percentage changes in these metrics across the scenarios, with the Optimal scenario showing a potential 33% increase in profitability, driven by switching to distributors and six weeks of coverage.

Abstract of all of the situations — (Picture by Writer)

Simulating these hypotheses is a matter of seconds with the mannequin.

This strategy saved hundreds of euros by confirming they may safely cut back inventory protection with out risking disruptions to buyer provide.

It turned out to be an extremely highly effective instrument for managing his enterprise, constructed with easy analytics by

  • Understanding the parameters influencing the worth chain
  • Simulate “what if” situations to evaluate enterprise methods
  • Discover the optimum set-up to attenuate prices and maximize profitability

Does this sound like a difficulty your enterprise is dealing with? For extra particulars, take a look at this text

The insights from the mannequin helped my good friend cut back the money wanted to run the enterprise and cut back the Value of Items Bought (COGS).

Later, we went past value reductions by tackling income maximization.

He got here again with one other request associated to pricing technique.

A comparison of three pricing mechanisms to encourage bulk purchases. Pricing Mechanism 1 offers a 2.5% discount for orders over 50 boxes. Pricing Mechanism 2 adds two tiers: a 2.5% discount for orders of 50–150 boxes and 5% for over 150. Pricing Mechanism 3 introduces three tiers: a 2.5% discount for 50–150 boxes, 5% for 150–500 boxes, and 10% for orders above 500.

Instance of pricing methods — (Picture by Writer)

With their new enterprise companion, an knowledgeable in F&B that brings capital and market experience, they have been drafting methods to spice up turnover.

She proposed a number of pricing methods, offered above, to extend the amount ordered by prospects.

My good friend: “How can I assess these methods and their affect on profitability?”.

You simply need to adapt the mannequin by including a pricing module and estimate the affect on profitability.

We will estimate the profitability and different enterprise indicators for every pricing technique with a number of quantity situations.

A table analyzing the impact of Pricing Strategy 2 on profitability, with several growth scenarios. The table compares baseline figures with rebate and growth projections for +25%, +50%, +100%, +150%, and +200%. Key metrics include COGS, logistic cost, storage cost, average profit, and unit fixed and variable costs. The red arrows highlight recovering profitability at the +200% growth mark.

Simulation Pricing Technique 2 [Article: Link] — (Picture by Writer)

Within the desk above, we simulate the affect of pricing technique two, assuming seven turnover situations.

Samir: “You have to get +200% development to recuperate the profitability of your baseline situation with this technique.”

We will assess every technique proposed with a number of clicks.

The insights generated by the mannequin helped resolve heated discussions between the co-founders.

The method allowed them to achieve frequent floor on the pricing technique backed by exact profitability projections.

It sounds nice, proper?

However what does it take to achieve this type of undertaking?

The way to Adapt Analytics Strategy to Enterprise Issues?

As I discussed a number of instances, the analytics options designed for these tasks are normally “technically primary.”

I might say that 80% of the efforts are in translating the enterprise downside into analytics options.

Be curious! Present curiosity within the enterprise mannequin.

It’s an energetic strategy of asking the precise questions to know which indicators are vital for enterprise house owners and the best way to mannequin processes.

Diagram showing the full value chain for a business selling renewable coffee cups. It includes supplier pricing, freight lead times, warehouse storage, delivery costs, and sales channel strategies. The model uses an inventory management rule to determine stock levels, and it accounts for customer payment terms and commissions, integrating the full range of operational and sales elements to optimize revenue.

Worth Chain of the Espresso Cups — (Picture by Writer)

Earlier than reaching this degree of modelization, I wanted a number of iterations with my good friend to make sure that my mannequin precisely mirrored the truth of his enterprise.

Due to this fact, it’s essential to make your mannequin’s insights accessible to a non-technical viewers to allow them to aid you assess the accuracy of the outcomes.

Is there a requirement for this type of resolution?

There’s a marketplace for that.

Since I began working full-time as a guide, I’ve acquired extra requests for this type of undertaking than for my core provide chain engineer abilities.

As you straight affect profitability and supply visibility to enterprise decision-makers, getting CAPEX and involvement for the undertaking is simpler.

What did we study from these two examples?

  • Enterprise house owners lack visibility on their processes and monetary flows.
  • Understanding enterprise fashions and processes is important to design the precise simulation mannequin.
  • Resolution makers worth data-driven insights to help strategic tasks.

This strategy is adaptable to a variety of enterprise instances throughout totally different industries and firm sizes.

I by no means anticipated to embark on a journey from an answer design supervisor optimizing logistics operations to a guide serving to companies enhance their profitability.

It is because I found that superior analytics instruments may be very efficient in enterprise optimization.

You don’t have to concentrate on the complexity of the analytics options (ML, optimization or GenAI) however on understanding the enterprise.

Have you ever heard about sustainability?

I’m at the moment studying about Europe’s Company Sustainability Reporting Directive (CSRD).

This can form how firms should report on their sustainability efforts

The concept is to introduce stricter necessities for transparency in environmental, social and governance (ESG) metrics.

A visual representation of the three pillars of ESG. Each pillar is displayed in a separate colored house-shaped section. The “Environmental” pillar covers carbon footprint reduction, climate change strategy, waste reduction, and energy efficiency. The “Social” pillar emphasizes fair living wages, equal job opportunities, health and safety, responsible suppliers, and respecting labor laws. The “Governance” pillar focuses on corporate governance, risk management, compliance, ethical business.

ESG Pillars Presentation [Article: Link] — (Picture by Writer)

Our strategy to enterprise profitability offered on this article can be utilized to sustainability challenges.

Resolution marker: “We have to cut back the scope 3 emissions of the distribution community by 30%.”

For instance, on this article about Inexperienced Stock Administration, I shared a case examine on lowering carbon emissions from retailer deliveries.

The concept is to search out the optimum supply frequency to attenuate the CO2 emissions.

Comparison of two delivery frequencies and their impacts on fill rate and carton usage. The left side shows two deliveries per week with a 50% fill rate, resulting in 35% additional cartons. The right side shows one delivery per week with a 100% fill rate and only 15% additional cartons, demonstrating the impact of delivery frequency on transportation efficiency and packing material usage.

Inexperienced Stock Administration [Article: Link] — (Picture by Writer)

The strategy to answering this operational downside offered within the article is comparable.

  1. Perceive the operations
    Put together and ship orders for trend retail shops
  2. Construct a simulation mannequin with Python to estimate the emissions.
    Inputs: Gross sales Information and Supply Frequency / Outputs: CO2 emissions
  3. Take a look at a number of situations with a number of supply frequencies and calculate the discount of emissions.

In case you are curious about discovering options to cut back emissions,

An identical strategy for various issues.

For any case examine, it’s essential to be curious, ask the precise questions and interact with decision-makers to actually perceive their ache factors.

By doing so, you possibly can create fashions that present actionable insights to technical and non-technical audiences.

In my expertise, these insights can considerably enhance profitability and help decision-making for operational transformations.

For those who haven’t but thought-about making use of your experience to enterprise challenges, now could be the time!

You would possibly uncover a brand new option to create affect — simply as I did.

Let’s join on Linkedin and Twitter. I’m a Provide Chain Engineer utilizing knowledge analytics to enhance logistics operations and cut back prices.

For consulting or recommendation on enterprise analytics and sustainable provide chain transformation, be at liberty to contact me by Logigreen Consulting.

In case you are curious about knowledge analytics and provide chain, please go to my web site.