IRVINS RGM P&L Portal
v7.2

2024 → YTD 2026 Overview

Multi-year P&L: budgets vs actuals

Monthly Revenue Trend
Actual vs Budget
Revenue: Budget vs Actuals
All scenarios ($M)
Gross Profit & Margin %
GP incl. COGS adj
Cost Structure (% of Revenue)
COGS, O&D, S&M, G&A
Profit Waterfall
Revenue to net profit
P&L Comparison Table
All line items ($M)

Monthly P&L — 2025 vs 2024

12-month actuals with year-on-year comparison

Monthly Revenue Trend
2025 vs 2024 ($K)
Monthly GP Margin %
2025 vs 2024
Monthly Cost Breakdown (2025)
Stacked ($K)
Monthly Profit After HQ OHD
2025 vs 2024 ($K)

P&L by Business Unit

BU P&L

Revenue by BU
Jan 2026 vs Dec 2025 ($K)
Gross Margin % by BU
Profitability ranking
Cost Structure by BU
Stacked ($K)
Profit After HQ OHD by BU
Jan 2026 vs Dec 2025 ($K)
Expense-to-Revenue Ratio (%)
Monthly OPEX / Revenue
Top 20 GL Expense Items
As % of total expenses
BU P&L Summary

P&L by Channel

Channel P&L

Top 20 Channels by Revenue
Jan 2026 ($K)
Top 20 Channels — Profit Before HQ OHD
Jan 2026 ($K)
Revenue: Jan 2026 vs Dec 2025
MoM comparison — top 20 ($K)
Channel GP Margin % vs Revenue
Bubble size = revenue
Revenue by BU Head Group
Channel grouping — Jan 2026
BU 2025 Monthly Trend
BU Head monthly sales ($K)
Channel Cost Structure — Top 10
COGS, O&D, S&M, G&A as % of revenue
Channel Profit After HQ OHD
Net bottom line per channel ($K)
Full Channel P&L Table
All 28 channels — revenue, costs, GP%, profit, MoM, RAG

Sales Deep Dive

Channel-level revenue by BU Head

Seasonal Revenue Heatmap (Quarterly)
Quarterly revenue by BU
Sales Channel Health — Actuals vs Budget
Budget attainment by channel
Delivery Cost to Revenue Ratio %
Top 10 BU names by delivery-to-revenue
Cost-to-Serve Analysis
Revenue vs (O&D + S&M) / Rev %
Service Mix — GL Expenses
Treemap of operational GL items

Products Performance

SKU-level analysis with year & month filters

Monthly Revenue Trend
By year ($M)
Top 15 SKUs by Revenue
Filtered ($K)
Top 15 SKUs by Qty Sold
Units
SKU Revenue Contribution
Top 10 share
Channel Revenue & Qty
Rev bars + Qty line
Top 30 SKU Table
Ranked by revenue
Controllable Expenses by BU
A&P+Sampling+Dist
Expense-to-Revenue Ratio
OPEX/Rev
S&M vs Revenue — Monthly Trend
S&M Spend by BU (A&P)
Marketing ROI by BU (Rev / A&P)
S&M by Channel Top 10 (A&P)
O&D by Channel Top 10
Store Profitability Top 15 — Rev vs Cost

Brand Marketing

Brand Mktg S&M Monthly Trend
GL04 from D.mXX vs Marketing BU actuals
Brand Marketing Cost Breakdown
S&M vs O&D vs G&A
Mktg Cost by GL
Cost breakdown
Mktg OPEX Efficiency
OPEX as % Rev
Price Ladder — Top 20 SKU
Avg $/unit ascending
Revenue vs Volume Share
Top 15 SKUs
Avg $/Unit by Channel
Filtered
Channel Revenue by BU
K$
Product Price Mix Elasticity
Vol vs ASP
SKU Price Bands
Revenue by tier
What-If Price Simulator
SKU Detail

Raw Data Explorer

P&L Raw Data

AI Recommendations

Automated insights

Green
0
On track
Amber
0
Monitor
Red
0
Action needed
AI Chat
Try: "Which channels have lowest GP margin?"

Import Data

Refresh from local Excel or Google Sheets

Local File
Google Sheets
Upload Excel
"P&L Raw Data" + "Products Raw Data"

Drop Excel or browse

.xlsx format

Expected Structure
Two sheets

Sheet 1: "P&L Raw Data" — Scenario · Sub Pillar · Period · GL level 1 · GL Name · BU name · company name · Find Inter-co · Pillar · BU Head · Month End date · Country name · SGD

Sheet 2: "Products Raw Data" — Year · Month · Pillar · Country · BU name · Item No. · Description · Qty · SGD

Import Log
System ready.