Manufacturing FP&A Dashboard | Variance, OTIF & Capex Prototype

Revenue YTD

$104M

vs $108M budget (-$4M)

Gross Margin

38.2%

Budget: 41.4% (-3.2pp)

EBITDA Margin

22.4%

Budget: 24.1% (-1.7pp)

OTIF

81.4%

Target: 92% — improving

Raw Mat. Cost/Unit

$48.2

Budget: $44.0 (+9.5%)

Active Capex

$38M

2 Green, 2 Amber, 1 Red

Budget vs. Actuals vs. Rolling Forecast — Monthly

Revenue ($M) · 12-month view with forward forecast

-$4M YTD miss

Variance Analysis — Apr 2026

Budget vs. Actuals by cost line

-$2.8M EBITDA gap

Line Item	Budget	Actual	Variance
Revenue	$36.0M	$34.7M	-$1.3M
Raw Materials	$14.8M	$16.6M	-$1.8M ⚠
Labour	$5.2M	$5.1M	+$0.1M
Energy / Utilities	$2.1M	$2.4M	-$0.3M
Freight Outbound	$1.4M	$1.6M	-$0.2M
Plant Overhead	$3.8M	$3.7M	+$0.1M
SG&A	$2.8M	$2.9M	-$0.1M
EBITDA	$8.7M	$5.9M	-$2.8M

Root Cause: Raw Material Cost Spike

Carbon black +22% (supplier contract expired Feb 2026). Rubber compound +8% (Malaysia supply disruption). Mitigation: 3-month forward contract signed Apr 18 — Q2 impact contained.

OTIF Performance — 12 Months

On-Time In-Full delivery · Target: 92%

81.4% current

Revenue at Risk (OTIF miss)

$1.4M/yr

Customer penalties + late recognition

Working Capital Extended

+18 days

Avg cash conversion cycle vs. target

Capex Portfolio — IRR vs WACC (5.5%)

$38M active across 5 projects

Margin Bridge — Q1 2025 → Q1 2026

What drove the 3.2pp EBITDA margin decline

Real-time manufacturing FP&A — budget, variance, OTIF, capex, all in one model.

Automate Your Finance builds connected FP&A platforms for manufacturers. Anaplan · Power BI · Alteryx. Ex-Deloitte. CA + FRM.

Book a Discovery Call →

Built by automateyourfinance.cloud · Illustrative data