KONSPEC.Confidential — Board & Leadership

Masterbatch · Monthly Operating Review

May 2026 review —
a live operating cockpit

Sales, RMC, debtors, inventory and the working-capital cycle — every chart drills, sorts, streams or recomputes on the spot. Press Esc for the slide grid, F for fullscreen.

Finance & Operations · Period 01–31 May 2026 · ₹ Crore / MTPrepared 14 Jun 2026
Agenda · 14 working slidesKONSPEC.

What we'll cover — and what each slide can do

01
Executive cockpit · live ERP-sync KPIs
08
RMC sensitivity heatmap · TiO₂ × price grid
02
Sales by grade · click to drill
09
Margin driver tornado · what moves EBITDA
03
Revenue flow · grade → market Sankey
10
EBITDA bridge · plan → actual waterfall
04
Market mix · drill-down treemap
11
P&L scenario planner · live statement model
05
Customer concentration · interactive Pareto
12
Plant throughput · real-time feed + gauge
06
RMC live model · cost sliders
13
Debtors & inventory · sort, filter, drill
07
Contribution by grade · margin walk
14
Cash conversion cycle · live WC model
KONSPEC monthly operating review · May 2026Confidential
Executive cockpit · 01KONSPEC.

Live cockpit — synced from the ERP, not a screenshot

Hit “Sync now”
Live · last synced 08:42:05

Revenue MTD

₹48.6 Cr

EBITDA margin

15.4

Net cash

₹22.4 Cr

Order book

₹214 Cr

Volume MTD

3180 MT

▲ +9%

DSO

58 days

▲ −7 d

RMC % sales

67.9%

▲ +1.3 pt

Plant utilisation

82%

▲ +4 pt
Source: ERP MIS feed (simulated) · placeholder data — “Sync” perturbs values to demo a live connection01 / 14
Sales · 02KONSPEC.

White and Color grades drove a record ₹48.6 Cr month

Click a grade
Sales value · ₹ Cr · May 2026

White MB

₹16.9 Cr

Realisation

₹184/kg

Volume

920 MT

Share

35%

MoM

+11.9%

Source: Sales MIS · 3,180 MT · blended realisation ₹152.8/kg · placeholder data02 / 14
Revenue flow · 03KONSPEC.

How ₹48.6 Cr flowed from grade to market

Hover a flow
Source: Sales MIS by grade × destination · Domestic 60% / Export 40% · placeholder data03 / 14
Market mix · 04KONSPEC.

Domestic west carries the book — drill to the account

Click to zoom in
Source: Sales MIS · region → account hierarchy · click a tile to drill, breadcrumb to return · placeholder data04 / 14
Customer concentration · 05KONSPEC.

The top 6 accounts make up 60% of revenue

Hover for cumulative

Concentration is a credit and pricing risk. Losing one top-3 account removes ~11% of revenue overnight.

60%

Revenue from top 6 of 240

₹6.8 Cr

Largest single account

Source: Sales MIS · accounts ranked by May revenue · 80% line marked · placeholder data05 / 14
Raw material cost · 06KONSPEC.

TiO₂ is the swing factor — model the pass-through live

Drag the sliders

RM basket · % of ₹33.0 Cr RMC

TiO₂ price+0%
Carbon black+0%
Carrier resin+0%
Selling price+0%

Contribution margin

32.1%

RMC 67.9% of sales
RMC/kg ₹103.8
Contribution ₹15.6 Cr
20%Target 33%40%
Illustrative model · pigment basket on ₹48.6 Cr sales · placeholder assumptions, not guidance06 / 14
Sensitivity · 07KONSPEC.

How much price increase defends margin against TiO₂

Click a cell

Contribution margin % · rows = TiO₂ price move · columns = selling-price increase

< 30% 30–32% 32–34% > 34% target

Selected scenario

TiO₂ +0% · price +0%

32.1%

contribution margin

At baseline costs the May margin holds at 32.1%, just below the 33% target.

Illustrative · each cell recomputed from the RMC model · placeholder assumptions07 / 14
Driver sensitivity · 08KONSPEC.

Selling price and volume move EBITDA most

Hover a bar

Each bar is the EBITDA swing from a realistic ± move in one driver, holding the rest at plan.

Read top-down: the levers worth managing first sit at the top. A ±5% price move alone is worth ±₹2.4 Cr of EBITDA — more than any single input cost.

Base EBITDA ₹7.5 Cr · ± moves shown per driver · placeholder assumptions08 / 14
EBITDA bridge · 09KONSPEC.

Volume gains were nearly erased by material and freight

Plan EBITDA of ₹7.4 Cr was lifted ₹1.1 Cr by volume, then given back by material (−₹1.0 Cr) and freight (−₹0.3 Cr) — landing at ₹7.1 Cr.

Source: management accounts · plan-to-actual bridge · placeholder data09 / 14
Scenario planner · 10KONSPEC.

Re-forecast the whole P&L in real time

Drag any driver
Volume growth+0%
Selling price+0%
RM cost+0%
Operating cost+0%

Modelled EBITDA

₹7.5 Cr

vs base

₹0.0 Cr

₹ CroreBaseScenarioΔ
Illustrative monthly model · base = May 2026 actual · placeholder assumptions, not guidance10 / 14
Plant throughput · 11KONSPEC.

Live extrusion throughput — streaming, not static

Watch it tick · or pause
Streaming · 1 Hz feed

Line throughput · MT / hour · rolling 30s

Throughput now

18.0 MT/h

OEE

86%

Source: line PLC feed (simulated 1 Hz) · placeholder data — a PDF freezes this; the deck does not11 / 14
Debtors · 12KONSPEC.

₹18.5 Cr sits beyond 60 days — concentrated in seven accounts

Click a bucket · sort the ledger

Total receivables

₹92.4 Cr

DSO

58 d

All buckets

₹92.4

100%

0–30 days

₹50.8

55%

31–60 days

₹23.1

25%

61–90 days

₹11.1

12%

90+ days · watch

₹7.4 Cr

8% · provision risk

Top accounts · all buckets · ₹ Cr

CustomerTotal0–3031–6061–9090+Overdue %
Source: AR ledger, 31 May 2026 · top 7 of 240 accounts · placeholder data12 / 14
Inventory · 13KONSPEC.

Inventory days held at 47 — but ₹4.1 Cr is ageing past 90 days

Click a segment

Composition · ₹54.8 Cr

Raw material · ₹24.6 Cr

Inventory days (DIO)

Stock cover

47 d

▲ −3 d

Ageing > 90 days

₹4.1 Cr

7.5%
of stock
Source: stores & WIP ledger, 31 May 2026 · placeholder data13 / 14
Working capital · 14KONSPEC.

The cash cycle is 67 days — every day is worth ₹1.6 Cr

Drag to free up cash
Inventory days (DIO)47
47 d
+ Receivable days (DSO)58
58 d
− Payable days (DPO)38
38 d
= Cash conversion cycle67
67 days
Inventory days47
Receivable days58
Payable days38

Cash released vs today

₹0.0 Cr

CCC now 67 days · ₹1.6 Cr per day

Illustrative · cash/day ≈ annualised revenue ÷ 365 · placeholder data14 / 14
KONSPEC.Confidential

Record sales. Now pass through TiO₂,
clear the 90+ ledger, shorten the cash cycle.

Asks — approve a 4% price revision on White grades · escalate ₹7.4 Cr 90+ debtors · target a 5-day cut to the cash cycle (≈₹8 Cr released).

Next review 12 Jul 2026 · June closefinance@konspec.com