Sales Channel Margin Simulator (differentiates GDO, markets, agritourism, e-commerce)
This application allows you to analyze the net profit margin for various sales channels of agri-food products (such as tomato bottles, preserves, juices, jams, wine, or oil).
It is designed for farms, agritourisms, local producers, and micro-enterprises that wish to compare the profitability of distribution channels immediately.
Simulated Channels
- GDO (Large-Scale Retail): lowest margin, high commissions (~35%).
- Local markets and fairs: moderate expenses (~15%), average margin.
- Agritourism and direct sales: minimal costs (~10%), high margin.
- E-commerce: platform and logistics costs (~20%), average margin.
How It Works
- Enter the unit production cost of your product (e.g., €1.20).
- Enter the retail price (e.g., €3.50).
- Click on “Calculate Margins.”
- The app displays for each channel:
- Percentage of expenses or commission.
- Net margin in euros.
- Percentage margin on the selling price.
The results are color-coded based on profitability:
- Green: margin > 25% → excellent performance.
- Yellow: margin 10–25% → acceptable.
- Red: margin < 10% → risk of low sustainability.
Example
Production cost: €1.20
Selling price: €3.50
| Channel | Expenses | Net Margin | Margin % |
|---|---|---|---|
| GDO | 35% | €1.08 | 31% |
| Market | 15% | €1.78 | 51% |
| Agritourism | 10% | €1.95 | 56% |
| E-commerce | 20% | €1.60 | 45% |
Utility
- Plan the most profitable sales strategy.
- Estimate the impact of distribution and logistics costs.
- Simulate margins on different price lists or product formats.
- Evaluate the economic feasibility of each channel.
FAQ – Frequently Asked Questions
1. Can I modify the expense percentages for each channel?
Yes. You can change the values in the PHP code in the $canali section to adapt them to the real conditions of your business.
2. Does the app work for products other than tomatoes?
Sure. It can be used for any agri-food product, such as honey, wine, oil, cheese, or vegetable preserves.
3. Can I compare multiple products at the same time?
In this version no, but you can duplicate the app or expand the code to simulate multiple items on the same page.
4. Does the app consider VAT or taxes?
No. The calculations exclude VAT and taxes for a technical assessment of industrial or commercial margins.
5. Is it compatible with smartphones and tablets?
Yes. The entire interface is responsive and usable on mobile devices as well.
6. Are the results saved?
No. The app processes data only in a temporary session, but you can quickly copy them using the “Copy Results” button.