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.