Statement of Work — Orcha × Rodic

Orcha × Rodic

AI-Powered Financial Intelligence & Analytics

April 2026

Statement of Work

Overarching Principles

1

Module 1 - AI Chat Agent for Financial Intelligence

Core Setup

  • Secure, read-only connection from the AI agent to Rodic's finance database
  • Schema mapping - agent understands table structures, relationships, and business meaning of each field
  • Conversational chat interface: ask questions in plain English, get answers with data, tables, and charts - designed so non-financial team members can access financial insights without SQL or BI tool knowledge
  • Context-aware - the agent remembers your company structure (projects, business lines, divisions, regions) and applies it automatically
  • Module 1 scope covers exactly the queries listed in the Appendix (A1–L5)

How It Works

User asks question → AI interprets intent → Generates & runs query → Analyzes results → Returns answer + insight

The agent doesn't just return raw numbers - it interprets results, highlights what matters, and suggests follow-up questions.

Analysis Domains

Revenue & Cost Analysis

Actuals vs. budget, variance breakdowns, salary and expense tracking at any level (project, BL, division, company)

Margins & Profitability

Site margins, EBITDA, PBT, PAT - absolute and percentage, with budget comparison and trend analysis

Forecasting & Prediction

Revenue and cost forecasts based on actuals, year-end projections, scenario and what-if analysis

Overhead & Allocations

BL, regional, and corporate overhead allocation tracking as absolute values and percentage of project salary cost

Rankings & Benchmarking

Top/bottom projects by revenue, profitability, and margin - across clients, business lines, and divisions

AI-Generated Insights

Performance summaries, early warning signals, underperformance alerts, and recommended actions - not just data, but narrative

See the Appendix for the full list of supported queries.

2

Module 2 - Dashboards, Scheduled Reports & Automation

Once the chat agent is live and we see which questions the team asks most, we build automated dashboards and scheduled reports as a natural next step.

How It Works

  • The AI agent runs your most frequent analyses on a configurable schedule (daily, weekly, monthly)
  • Optimized for speed and cost - scheduled runs use pre-computed queries, reducing token usage vs. ad-hoc requests
  • Results are always current, generated directly from the same database the on-demand agent uses
  • Reports produced proactively and delivered automatically - no need to ask every time
  • New analyses promoted from ad-hoc queries once a pattern emerges

Product Discovery

Before building dashboards, we run a focused product discovery session with your team to identify which analyses matter most, validate priorities, and define the exact scope - ensuring we build what you actually need and avoid scope creep.

Standard Analyses

  • Performance vs. Budget - revenue, costs, EBITDA, PBT, PAT with variance at project, BL, division, and company level
  • Profitability breakdown - project-wise, BL-wise, division-wise with contribution percentages
  • Margin tracking - site margin and company margin trends, flagging areas below budget thresholds
  • Forecast summary - projected year-end revenue, costs, and profitability based on rolling actuals
  • Rankings - top and bottom projects/clients by revenue, profitability, and margin
  • Early warning alerts - projects at risk of revenue shortfall, expense overruns, or margin erosion
  • Additional analyses added iteratively based on team usage

Executive Briefing

  • AI-generated executive summary produced on schedule - ready for leadership review
  • Structured format: current performance, forecast, key risks, commendations, and recommended actions
  • Conservative and optimistic scenario variants available for board-level reporting
3

Ongoing Support & Iteration

Included in Monthly Fee

  • Monitor which questions the team asks most - promote recurring queries into scheduled analyses
  • Refine AI agent accuracy based on real usage patterns
  • Ongoing tuning, minor adjustments, and support

Expansions beyond the monthly fee (new data sources, proactive insights, major integrations) are scoped and quoted separately - see Commercial Terms.

Commercial Terms

Cost Coverage Fee

Completion

Ongoing Support

Expansions - Scoped Separately

Project Timeline

Project Start
Kick-off, database access, schema mapping
€4,000 cost coverage fee
Module 1 - AI Chat Agent
AI chat agent setup, query engine, database connection
Check-ins & iteration
Module 2 - Dashboards & Scheduled Reports
Product discovery, automated analyses, dashboards, and scheduled reports based on real usage patterns
Check-ins & iteration
Completion
All modules delivered and verified, production deployment, team onboarding
€10,000 completion fee
Hyper Care - 1 Month
Instant customer support, rapid issue resolution, priority response times
Ongoing Support
Iteration, expansion, continuous tuning, and support
€800/month support + token costs

Appendix - Supported Query Categories

The AI agent is designed to handle all of the following query types from day one. This list represents the initial scope - any question that can be answered from the database is supported, including queries not listed here.

A Revenue

  • A1 What is the total revenue for [Project / BL / Division / Company]?
  • A2 What is the revenue variation (Actual vs Budget)?
  • A3 What is the revenue forecast for the next [3 / 6 / 12 months]?
  • A4 Based on current trends, what is the expected year-end revenue for [Project / BL / Division / Company]?
  • A5 Show the top 10 projects with highest revenue vs. budget.
  • A6 Show the top 10 projects with maximum revenue loss.

B Costs

  • B1 What is the actual salary cost for [Project / BL / Division / Company]?
  • B2 What is the budgeted salary cost?
  • B3 What is the variance (Actual vs Budget)?
  • B4 What is the forecasted salary cost for the next [3 / 6 / 12 months]?
  • B5 What are the actual other expenses?
  • B6 What are the forecasted other expenses for the next [3 / 6 / 12 months]?

C Margins

  • C1 What is the margin at site (absolute)?
  • C2 What is the margin at site (%)?
  • C3 How does the margin compare with budget?
  • C4 What is the forecasted margin for year-end based on current run rate?

D Overhead Allocations

  • D1 Show BL, Regional, and Corporate overhead allocation (absolute).
  • D2 Show each as % of Project Salary Cost.
  • D3 Forecast overhead allocations for next 6 months.

E Profitability

  • E1 What is the actual EBITDA, PBT, PAT (absolute)?
  • E2 What are EBITDA%, PBT%, PAT%?
  • E3 How do they compare with budget?
  • E4 Forecast EBITDA, PBT, PAT for next [quarter / year].
  • E5 What is the likely year-end profitability?

F Profitability Analysis

  • F1 Project-wise profitability (Actual, Budget, Forecast).
  • F2 BL-wise profitability analysis.
  • F3 Division-wise profitability analysis.
  • F4 Company consolidated profitability.
  • F5 Trend analysis (last 6 months vs next 6 months).
  • F6 Contribution % by Project, BL, Division to company profit.
  • F7 Predictive analysis - which projects/clients are likely to underperform or overperform?

G Budget vs Actual

  • G1 Revenue vs Budget (Variance % and absolute).
  • G2 Salary cost vs Budget.
  • G3 Other expenses vs Budget.
  • G4 EBITDA, PBT, PAT vs Budget.
  • G5 Projected year-end Actual vs Budget.

H Forecast & Predictive Analytics

  • H1 Based on last 6 months actuals, what is the forecast for next 6 months?
  • H2 What is the projected year-end Revenue, Costs, and Profitability?
  • H3 Which projects are at risk of revenue shortfall?
  • H4 Which projects are expected to exceed revenue or profitability targets?
  • H5 Provide scenario analysis (e.g., +5% revenue growth, -10% cost reduction).
  • H6 Provide what-if analysis (if new project/client is added, impact on revenue/profitability).

I AI-Generated Insights & Recommendations

  • I1 Give a summary briefing of current performance vs budget and forecast.
  • I2 Highlight key drivers of performance (projects, clients, regions).
  • I3 Identify underperforming areas and possible remedial measures (revenue growth, cost control, margin improvement).
  • I4 Provide early warning signals (projects likely to miss targets).
  • I5 Highlight projects/BL/divisions with excellent results.
  • I6 Suggest action plan to improve overall performance.

J Client & Project Rankings

  • J1 Top 10 revenue-generating projects (Actual & Forecast).
  • J2 Top 10 projects with maximum revenue loss (Actual & Forecast).
  • J3 Top 10 clients by revenue (Actual & Forecast).
  • J4 Top 10 client groups by revenue.

K Report Views

  • K1 Project-wise view.
  • K2 BL-wise view.
  • K3 Division-wise view.
  • K4 Region-wise view.
  • K5 Company-level consolidated view.
  • K6 Project coordinator-wise view.

L Output Preferences

  • L1 Show results as tables.
  • L2 Show results as charts/graphs.
  • L3 Export as PDF/Word summary.
  • L4 Export as Excel/CSV data.
  • L5 Provide AI-generated Executive Briefing Note (bullet summary + recommended actions).

Orcha × Rodic - Statement of Work - April 2026

Confidential

Comments

No comments yet. Select text to add one.