Financial Analyst / Unit Economics Specialist (E-commerce)

Budget: 2500 UAH Deadline: 1 day

Good day!

I have experience in building financial models in Google Sheets, automating calculations, and analyzing unit economics. The task is clear — it is necessary not just to calculate the margin, but to find the optimal pricing model, where an increase in order volume will also increase the company's net profit.

What I can do:

* build a financial model with auto-calculation of P&L for each price threshold;
* analyze the cost structure and identify points where large volumes become unprofitable;
* evaluate the current commission model and propose a more effective option;
* optimize the Smart Price grid considering COGS, logistics, and all variable costs;
* prepare recommendations and deliver the finished model in Google Sheets.

After reviewing the initial tables, I will be able to assess the timelines, propose a fixed cost, and immediately start working. Expand

Budget: 13500 UAH Deadline: 2 days

Good day.
I have experience in building financial models and optimizing business commercial models. In your case, the problem probably lies not only in the level of discounts but also in the architecture of variable costs and the margin distribution model.
I would analyze the structure of COGS, logistics, the commission system, and the current Smart Price grid. After that, I would determine whether the problem really lies in the commission model, logistics, price thresholds, or their combination.
I can prepare a financial model with automatic calculations, identify points of profitability loss. I will also provide practical recommendations for optimizing pricing, logistics, and the commission system.

Budget: 3800 UAH Deadline: 5 days

I see the task like this: the Smart Price grid lowers the price faster than variable costs per unit decrease, so for 10-50 units, profit in monetary terms hardly grows. This is exacerbated by the fact that commissions are calculated from net profit, not from margin, and hybrid logistics load each threshold differently.

I will create a P&L per unit in Google Sheets for thresholds from 1-2 to 100+, find break-even points, and restructure the pricing grid and logistics so that Net Profit increases with each block. Separately, I will propose a commission model based on margin.

Deadline: approximately 5 days after receiving the tables with COGS and rates.

Budget: 3400 UAH Deadline: 4 days

I will calculate the P&L per unit for each threshold (1-2 to 100+), and find where the discount "eats" into the margin.

I will convert the commissions from % of profit to % of margin, and restructure the Smart Price grid. I will build the model in Google Sheets with auto formulas.

The estimated timeframe is about 4 days.