Garuda Indonesia · Revenue Planning & Performance Control

Driving 34% YoY Yield Growth
Through Unit-Cost & Predictive Route Forecasting.

Bridging 11 years of historical data into dynamic pricing and flight-level space allocation models with >90% accuracy.

Revenue Planning & Performance Control Manager · Unit-Cost Engineering · Predictive Demand Modeling · Dynamic Yield Optimization
Yield & CLF Expansion
+34%
Sustained Year-over-Year
Forecast Accuracy
>90%
Projected 3 weeks in advance
Cost Granularity
1 kg / Block Hr
Calculated across every route

Replaced outdated blanket tariffs and static space allocation with a rigorous unit-cost economic model and a predictive demand forecasting engine. Calculating the exact cost of transporting 1 kg per block hour across every domestic and international flight, while projecting forward demand three weeks out with over 90% accuracy, unlocked dynamic tactical pricing that drove a 34% YoY surge in Yield and Cargo Load Factor (CLF).

01 / The Challenge

Pricing blind: high corporate targets with zero unit-cost visibility.

Airlines operate on razor-thin margins where block-hour operational costs fluctuate dynamically based on fuel burn, aircraft type, crew rotations, and navigational fees.

Yet, commercial cargo pricing had historically relied on blunt, static rate sheets. Space allocation was managed on static historical rules-of-thumb: route managers reserved cargo allotments based on gut feel rather than forward commercial demand signals.

This disconnect created severe operational and financial friction:

  • 1. Commercial teams had no mathematical visibility into the exact cost floor of flying freight on specific aircraft types (e.g., widebody B777 vs. narrowbody B737).
  • 2. Flights frequently flew with empty belly capacity on high-demand days due to unreleased protective blocks, or conversely, took low-yield cargo that displaced high-value emergency shipments.
  • 3. Corporate leadership handed down aggressive revenue and yield growth mandates that were mathematically impossible to achieve using static tariff matrices.
The Commercial Dilemma

Discounting prices to fill empty planes eroded yield; raising prices without demand forecasting drove cargo agents to competitors, causing Cargo Load Factors (CLF) to crater. Without granular forecasting and unit economics, every pricing decision was a gamble.

02 / The Strategic Foundation

Unlocking 11 years of normalized operational intelligence.

The breakthrough became possible because of the newly constructed Garuda Cargo Data Center, which I had previously engineered.

For the first time in corporate history, the Revenue Planning & Performance Control unit had centralized access to eleven years of clean, granular, time-series data: flight-by-flight fuel burn, block hours, belly payload limits, historical bookings, volumetric weight ratios, seasonal demand swings, and revenue yield realization.

Instead of relying on guesswork, we had the empirical data foundation required to build institutional-grade predictive econometrics.

03 / Mathematical & Econometric Modeling

Unit-cost per block hour combined with weighted predictive forecasting.

I engineered a two-tier economic framework: an exact Unit-Cost Model and a Predictive Route Demand Model.

1. The Unit-Cost Model (1 kg / Block Hour): We deconstructed aircraft direct operating costs (DOC, including fuel consumption, maintenance reserves, navigation fees, and ground handling), calculating the exact marginal cost of flying one kilogram of freight across every scheduled route per block hour. This gave commercial sales teams an unshakeable mathematical baseline for minimum profitable yields.

2. The Predictive Demand Model: Utilizing weighted moving average (WMA) algorithms calibrated against day-of-week seasonality, export/import trade balance, commodity density shifts, and macro market indices, we built automated forecasting pipelines projecting route demand up to three weeks before flight departure:

3-Week Forward Window

Anticipated booking velocity curves up to 21 days out, enabling proactive capacity release rather than last-minute panic sales.

>90% Forecast Accuracy

Weighted moving averages continuously tuned against historical seasonal fluctuations achieved unmatched predictive precision.

Dynamic Tactical Pricing

Empowered sales desk officers to raise spot rates dynamically on supply-constrained flights while discounting soft flights above cost floor.

Flight-Level Space Allocation

Replaced rigid departmental allotments with dynamic capacity allocations that prioritized high-contribution cargo categories.

Before: Guesswork & Flat Rates Stagnant Yield
  • Flat commercial tariffs unchanged regardless of route flight economics
  • Zero awareness of marginal cost per block hour across fleet types
  • Static space allocations led to artificial belly spillage and empty space
  • Sales teams traded volume for margin, eroding corporate profitability
  • Commercial reporting looked backwards instead of anticipating demand
After: Algorithmic Revenue Management +34% YoY Growth
  • Exact cost baseline calculated for 1 kg per block hour across all flights
  • Demand projected 3 weeks out with >90% algorithmic accuracy
  • Dynamic tactical pricing capturing maximum willingness-to-pay
  • Simultaneous expansion in both Cargo Load Factor and Yield
  • Institutionalized data-driven culture across revenue planning
04 / Role, Scope & Leadership

Steering commercial revenue policy across international networks.

As Revenue Planning & Performance Control Manager, I led the strategic implementation across all commercial units:

Mathematical Modeling & Tooling: Designed the forecasting algorithms, built the econometric spreadsheet simulators, and integrated the output directly into commercial booking portals.

Commercial Team Enablement: Trained regional sales managers across domestic branches (Surabaya, Denpasar, Medan, Makassar) and international outstations (Singapore, Tokyo, Sydney, Amsterdam) on dynamic pricing elasticity and capacity management.

Executive Governance: Presented bi-weekly revenue optimization reviews to the Cargo Director and C-level board members, defending yield strategy against passenger network shifts.

05 / Business Impact

Sustained 34% YoY growth in both Yield and Load Factor.

Simultaneous Margin & Volume Expansion

In standard airline revenue management, raising Yield (revenue per available ton-kilometer) usually depresses Load Factor, while filling planes depresses Yield. Our predictive forecasting broke this trade-off:

• +34% YoY Growth: Generated sustained 34% Year-over-Year expansion in blended Yield while simultaneously lifting Cargo Load Factor (CLF).

• Over 90% Forecast Accuracy: Branch managers could rely on three-week projections to negotiate high-value contract commitments without fearing oversale or spoilage.

• Corporate Margin Resilience: Cargo became a primary cash-generating pillar for the entire airline group, outperforming annual corporate targets.

06 / Core Principle

Pricing power begins with granular cost visibility.

You cannot optimize yield on macro averages. True commercial pricing power is unlocked when you understand the exact marginal cost of a single unit of capacity and can predict customer demand before they place the order.

Ikhwanul Hakim · Revenue Planning & Performance Control Manager

Revenue optimization is not an art of intuition; it is the science of information advantage. By uniting 11 years of historical truth with forward-looking statistical algorithms, we gave commercial teams the confidence to price dynamically and capture maximum enterprise value.