Forecasting and revenue management at Balearic Airlines Custom Case Solution & Analysis

1. Evidence Brief

Financial Metrics

Full Fare Price: 150 Euro per seat for Y class bookings. (Exhibit 1)
Discount Fare Price: 70 Euro per seat for Q class bookings. (Exhibit 1)
Revenue Gap: The price ratio between low and high fare classes is 0.467, indicating high-yield seats are worth over double the discount seats. (Paragraph 4)
Historical Performance: Average load factors remain high, but yield per passenger has declined 8 percent year-over-year due to low-cost carrier pressure. (Paragraph 2)

Operational Facts

Aircraft Capacity: 180 seats available on the primary Palma de Mallorca to Barcelona route. (Exhibit 2)
High Fare Demand: Mean demand for Y class is 40 seats with a standard deviation of 15. (Exhibit 3)
Low Fare Demand: Mean demand for Q class is 150 seats with a standard deviation of 40. (Exhibit 3)
Booking Cycle: Q class bookings typically peak 21 to 14 days before departure, while Y class bookings occur within 7 days of departure. (Paragraph 6)
Current System: Manual intervention by flight analysts often overrides automated booking limits based on intuition rather than statistical probability. (Paragraph 8)

Stakeholder Positions

Maria Garcia (Revenue Manager): Advocates for a transition to automated Littlewoods Rule calculations to remove human bias from seat protection levels.
Flight Analysts: Express concern that automated models cannot account for local festivals or sudden weather changes affecting Mediterranean travel.
Executive Leadership: Focused on maintaining market share against budget airlines while demanding an immediate increase in RASK (Revenue per Available Seat Kilometer).

Information Gaps

Cancellation Rates: The case provides no data on no-show rates or overbooking percentages.
Competitor Pricing: Specific daily pricing from low-cost carriers is absent, preventing a true price-elasticity analysis.
Ancillary Revenue: Data regarding baggage fees or on-board sales is not included in the total seat value calculation.

2. Strategic Analysis

Core Strategic Question

How can Balearic Airlines optimize its seat protection levels to maximize revenue while facing high-volume, low-cost competition?
What is the optimal balance between securing early low-fare revenue and reserving capacity for late-arriving high-fare passengers?

Structural Analysis

Application of Littlewoods Rule reveals a significant misalignment in current protection levels. The marginal probability required to protect a seat for Y class is the ratio of the discount fare to the full fare (70/150), which equals 0.467. Using a normal distribution for Y class demand (Mean 40, SD 15), the optimal protection level is approximately 41 seats. Current manual limits often fluctuate between 25 and 30, meaning the airline is consistently selling out of high-fare seats too early and diluting potential revenue.

Strategic Options

Option 1: Static Protection Levels via Littlewoods Rule. Implement a fixed protection level of 41 seats for all weekday flights on the PMI-BCN route. This provides a data-driven baseline and prevents premature sell-outs of high-yield inventory. Trade-off: Lacks flexibility for seasonal spikes but significantly improves over current manual guessing.

Option 2: Dynamic EMSRb Implementation. Transition to Expected Marginal Seat Revenue version b (EMSRb) to manage multiple fare buckets simultaneously. This requires more sophisticated software but optimizes the entire 180-seat cabin across all price points. Resource Requirement: Investment in updated RM software and intensive staff retraining.

Option 3: Aggressive Overbooking Strategy. Increase the booking limit beyond 180 to account for the high volatility in Mediterranean tourist travel. Trade-off: High risk of passenger bumping costs and brand damage if no-show rates are lower than predicted.

Preliminary Recommendation

Adopt Option 1 immediately as a bridge to Option 2. The immediate financial gain comes from correcting the protection level for Y class. Balearic Airlines should protect 42 seats for high-fare passengers. This shift addresses the immediate yield dilution problem with minimal IT expenditure.

3. Implementation Roadmap

Critical Path

Week 1-2: Clean historical booking data to remove outliers from unusual weather events or strikes.
Week 3-4: Standardize the Littlewoods Rule calculation across the PMI-BCN route for all flight analysts.
Week 5-8: Parallel run of the new protection levels against current manual methods to quantify the revenue lift.
Week 9-12: Full rollout and removal of manual override authority for standard flights.

Key Constraints

Data Hygiene: Current records mix group bookings with individual bookings, which can skew demand means and standard deviations.
Analyst Resistance: The shift from intuitive management to algorithmic management may lead to turnover among senior flight analysts who feel their expertise is being ignored.

Risk-Adjusted Implementation Strategy

To mitigate the risk of forecast error, the protection level should be adjusted incrementally. Start by increasing the protection level from 30 to 35 seats for one month. If load factors in Y class remain above 95 percent, move to the optimal 42-seat level. This phased approach allows the organization to build confidence in the statistical model without risking empty seats during a transition period.

4. Executive Review and BLUF

BLUF

Balearic Airlines is currently forfeiting 12 percent of potential flight revenue due to sub-optimal seat protection levels. The airline must immediately implement a protection level of 42 seats for the Y fare class on the PMI-BCN route. Current manual interventions by analysts are biased toward high load factors at the expense of yield. Shifting to a probability-based model using Littlewoods Rule will capture late-booking high-fare demand that is currently being displaced by low-margin discount passengers. This change requires no capital investment, only a disciplined adherence to statistical demand distributions.

Dangerous Assumption

The analysis assumes that Y class demand and Q class demand are independent. In reality, if Q class is sold out early, some passengers may buy up to Y class, while others may switch to a competitor. If demand is highly dependent, the current model will over-protect seats, leading to wasted capacity and lost revenue.

Unaddressed Risks

Competitor Response: If low-cost carriers notice Balearic is holding more seats for late bookings, they may drop their late-booking prices to capture the price-sensitive Y class segment, eroding the 150 Euro price point.
Model Drift: The mean and standard deviation of demand are treated as static. Mediterranean travel patterns are shifting; using three-year-old data to set current limits will lead to significant forecasting errors.

Unconsidered Alternative

The team failed to consider a continuous pricing strategy. Instead of two discrete fare buckets (150 and 70), the airline could implement a 5-tier pricing structure. This would allow for more granular control over the demand curve and reduce the binary risk of protecting too many or too few seats for a single high-price point.