Retail analytics
Nexinc Tools — Executive ROI Simulator

Loyalty Engine Simulator

Stress-test a loyalty investment with simple inputs: uplift, costs, payback, and “healthy margin” checks. Outputs are formatted for a CIO/CFO one-pager and an execution plan.

Open Simulator

Inputs & Assumptions

Start with “Baseline” (today), then apply the “Loyalty Scenario” uplift + costs.

Currency

Payback & ROI are shown for this window.

We normalize outputs “per 1,000,000 units”.

Health Thresholds (editable)
Your “1% is good” rule is encoded here.

Baseline (Today)

Current State

If you prefer, you can derive revenue from Orders × AOV.

Used to estimate gross profit impact.

Excludes COGS. Include staff, rent, IT run, marketing, etc.

Finance, one-offs, depreciation, etc (simplified).

Volume Drivers (for “units”)

Used to compute orders/customer per-million normalization.

Used to allocate uplift and reward cost to member-driven sales.

Loyalty Scenario

Proposed Change

More member orders due to engagement.

Basket size increases for members.

“pp” = percentage points (simplified benefit).

Converts churn improvement into revenue uplift. Keep small.

Costs
Tech + rewards + marketing + operations.
Annual costs, unless stated.

Program ops, partners, analytics, etc.

Platforms, integrations, data, apps, vendors.

Campaigns, CRM pushes, personalization content.

Points/redemptions, discounts, perks.

If horizon is >1 year, this is not repeated.

Actions

Save or export assumptions for the Nexinc report pack.

Executive Dashboard

Baseline vs Scenario. Health checks are based on your thresholds.

Incremental Revenue
Annual (based on uplift)
Incremental Net Profit
After all costs
ROI (Horizon)
Over 1 year(s)
Payback
Months (approx.)
Baseline Snapshot
Revenue, costs, and margin health.
Revenue
Gross Profit
OpEx
Net Profit
Net Margin
OpEx Ratio
Scenario Snapshot
Baseline + loyalty uplift + costs.
Revenue
Gross Profit
OpEx
Net Profit
Net Margin
OpEx Ratio

Per 1,000,000 Units Normalized View

Useful when we don’t have full “units” disclosure. Choose unit type on the left.

Per 1M Orders
Revenue / 1M
Cost / 1M
Net Profit / 1M
Interpretation
  • If Net Profit / 1M is negative, the loyalty model is currently too expensive for the uplift.
  • If ROI is strong but margin health is weak, we adjust the reward rate, targeting, or reduce tech/run costs.

Execution Plan Template (auto-filled)

This becomes the “what / how / when / by whom” section in the Nexinc report.

What
    How
      When
        By Whom
          Governance

          Notes & Limits

          This simulator is intentionally simple. It’s designed to get to a decision-ready first pass, then we validate with real MAF figures (member cohorts, redemption curves, churn, CAC, channel margins, etc.).

          Next step (when you want): we plug in retail disclosure numbers from the uploaded reports and generate the full Nexinc “Current State → Opportunity → Operating Model → Roadmap” pack.