Wendor assortment lab

Product Mix Planner

Model category split and see projected revenue contribution and weighted margin quality.

Category allocation (%)

Mix outcome

Weighted margin
0%
Total allocation:
0%
Revenue at risk (spoilage)
Rs. 0
High-velocity category
-
Recommendation
-

Decision Benchmarks

Use benchmark bands before approval

  • Target monthly net margin

    18%+

    Below this level, revisit site quality and product mix.

  • Payback comfort band

    18-36 months

    Longer payback may constrain healthy scale velocity.

  • COGS control band

    40%-50%

    Monitor sourcing and shrinkage to protect margins.

  • Opex share of revenue

    < 22%

    Keep fixed monthly costs proportionate to demand.

Risk Controls

Common failure points and mitigations

  • Modeled profit not matching live results

    Re-run the calculator with real demand and cost data every 30 days.

  • Overconfidence from upside scenario

    Use conservative scenario for budget approval and upside for planning only.

  • Hidden field cost eroding net margin

    Track refill labor, transport, and service effort as explicit monthly inputs.

Execution Cadence

Suggested rollout rhythm after planning

  1. Week 1

    Model conservative and balanced scenarios

  2. Week 2

    Validate key assumptions on-ground

  3. Week 3

    Launch pilot with tracked inputs

  4. Week 4

    Update model using live performance

  5. Month 2

    Approve scale decision based on net trend