A.I. Tools

Business Planning with Python — Revenue Optimization | by Samir Saci | Jun, 2024

After 24 months of activity, my friend found a business partner with 25 years of experience in the Food and Beverage industry.

My friend: “She brings investment and market expertise with the aim of boosting growth.”

She estimated the growth they can reach if they follow specific commercial strategies.

Growth potential per sale channel — (Image by Author)

After analyzing the business model, she proposed to change the pricing mechanism to increase the average basket size.

My friend: “She wants to offer tiered pricing discounts to incentivize bulk purchases.”

Example of pricing strategies — (Image by Author)

However, the risk is to impact profitability and cause a liquidity crash as we reduce the turnover per box sold.

My friend: “If we implement strategy X, can you tell me how much growth we need to keep the same profitability?

For each strategy, we can use the model to estimate the minimal growth needed to improve profitability compared to the baseline.

Baseline & Profitability Indicators

For this analysis, we defined the baseline using the 2023 historical sales with updated terms and inventory management rules.

Turnover per Sales Channels — (Image by Author)

More than 70% of the turnover comes from direct sales to coffee shops, and the remaining is from distributors with four-week payment terms.

Cash Flow with the baseline— (Image by Author)

We don’t have liquidity issues thanks to favourable payment terms with our suppliers and the coffee shops.

Baseline Indicators — (Image by Author)

Considering fixed and variable costs, we can reach $3,910 in profit per pallet sold for this scenario.

This profitability is influenced by the green indicators that cover fixed and variable costs.

Five growth scenarios for each pricing strategy

My friend’s business partner based the pricing strategy on the market practice and her industry knowledge.

The simulation aims to trigger data-based discussions to support business decision-making.

Simulation Scenarios — (Image by Author)

My friend: “If you want to apply Pricing 1, can we ensure that we have at least +50%? If not, we loose profitability.”

Let us start with the first pricing strategy.

Scenario 1: Low-risk pricing 1

This strategy incentivises customers to order at least a full pallet by providing a 2.5% reduction if the volume exceeds 50 boxes.

How much growth we need to maintain the same profitability?

As we can see in the rebate scenario, implementing the new pricing results in a profit loss of 171 ($/Pallet).

Simulation Pricing Strategy 1 — (Image by Author)

However, as sales growth mechanically decreases unit costs, this loss is compensated when we reach +50% growth.

Variable costs are also reduced thanks to inbound flow optimizations.Storage cost per pallet increases due to the higher safety stock required.

They must bring at least 1.5 times the current turnover if she wants to implement this strategy.

Simulation Conclusion — (Image by Author)

Business Partner: “We’ll never get more than 50% growth without an additional rebate. ”

Scenario 2: Middle-risk Pricing 2

Indeed, the first pricing strategy does not incentivize ordering more than 1 pallet (50 boxes).

Simulation Pricing Strategy 2— (Image by Author)

Therefore, they would like to add a 5% rebate if customers order over 150 boxes (3 pallets).

If we keep the same volumes, implementing this additional rebate induces a 315 ($/Unit) profitability loss.

Do we lose profitability if we only reach +50% growth?

Yes, we only get 3,751 ($/Unit) of profit with +50% growth vs 3,910 ($/Unit) for the baseline.

Therefore, we need at least +200% sales growth to recover the profitability level of the baseline scenario.

Unlike the first pricing strategy, the turnover per pallet sold decreases until reaching a plateau after 100% growth.Costs of goods sold (COGS) are lower than the first pricing strategy because the 30% sales commissions for the sales representatives are based on the invoiced amount.

We lose 171 ($/Pallet) of profit compared to the first pricing strategy if we reach +200% sales growth.

Conclusion of Simulation of the Pricing Strategy 2 — (Image by Author)

However, according to the business partner, this strategy is more likely to help us reach these targets.

My friend: “What if we implement another 10% for large orders?”

Scenario 3: High-risk Pricing 3

Even if this does not seem like a good idea, they want to estimate the profit loss with an additional 10% rebate for orders larger than 500 boxes.

Samir: “This brings interesting insights about your business.”

Simulation Pricing Strategy 3— (Image by Author)

The slight reduction of profitability with the rebate scenario (from 3,595 $/pallet with strategy 2 to 3,588 $/pallet with strategy 3) shows that they currently have nearly no orders with a quantity higher than 500 boxes.

However, they will have the bad experience of seeing their profitability decrease when they reach +50% growth.

Samir: You’ll never be able to reach the profitability level of the initial scenario.

The model provides data-driven insights on assessing the business partner’s suggestions.

Conclusion of Simulation of the Pricing Strategy 3 — (Image by Author)

Translating business ideas based on experience and intuition to actual figures is important to save the margin and avoid bankruptcy.


Source link

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button
Translate »