NP-SP-14 · Competition & Capacity Benchmarking

📊

Process Flow Diagram (BPMN)

📋

L4 Process Steps

Step	Step Name	Role / Swim Lane	System	Input	Output	KPI	Dec?	Exc?
Phase 1 1.1	Extract competitor schedule data from OAG feed	Network Intelligence Analyst	OAG Schedule Analyser	Weekly OAG data subscription refresh (SSIM-format schedule file)	Structured competitor schedule dataset by route, frequency, and aircraft type	Data currency: schedule feed ≤7 days old; coverage ≥95% of target markets	N	N
1.2	Ingest DOT Form 41 traffic and capacity statistics	Network Intelligence Analyst	AWS S3 / Redshift	US DOT BTS Form 41 quarterly release (T-100 domestic segment data)	Market-level ASM, RPM, and enplanement records loaded to Redshift	Ingestion completeness ≥99% of published BTS records; pipeline SLA <4 hrs post-BTS release	N	N
1.3	Pull GDS booking and availability data for share estimation	Network Intelligence Analyst	Sabre GDS	Sabre MarketIntelligence booking data extract; Amadeus GDS availability snapshot	Point-of-sale booking share estimates by O&D market and carrier	Market coverage: GDS data represents ≥70% of bookable seats on target routes	N	N
1.4	Validate data completeness and trigger re-pull if gaps detected	Network Intelligence Analyst	AWS S3 / Redshift	Automated data quality report from Redshift completeness checks	Data validation sign-off or re-pull request to upstream pipeline	Data quality gate pass rate ≥98% before advancing to analysis phase	Y	Y
Phase 2 2.1	Map competitor frequency and timing by route	Schedule Planning Analyst	OAG Schedule Analyser	Validated competitor schedule dataset from Step 1.4	Frequency matrix by competitor, route, and departure time bank	Frequency gap identified on ≥80% of monitored routes within 5 business days of OAG refresh	N	N
2.2	Assess competitor fleet gauge and seat capacity per route	Schedule Planning Analyst	OAG Schedule Analyser	SSIM aircraft type codes from OAG feed; Amadeus SkyWORKS fleet reference table	Seat capacity report per competitor flight by route and equipment type	Seat capacity variance vs prior period flagged within ±5% accuracy against T-100 actuals	N	N
2.3	Identify competitive schedule gaps and overlap windows	Schedule Planning Analyst	Amadeus SkySYM	Frequency matrix and seat capacity report from Steps 2.1–2.2	Route priority list ranked by competitive exposure score; whitespace opportunity map	≥5 whitespace route opportunities or ≥3 overlap-reduction candidates identified per quarterly cycle	N	N
2.4	Determine whether material competitive threat warrants escalation	Director of Network Planning	Amadeus SkySYM	Competitive exposure score and whitespace map from Step 2.3	Decision: escalate to capacity modelling (Y) or archive for quarterly review (N)	Escalation decision issued within 5 business days of schedule gap analysis completion	Y	N
Phase 3 3.1	Compute ASM and RPM trends versus industry peers	Revenue Planning Analyst	AWS S3 / Redshift	T-100 records and OAG capacity data from Redshift; peer carrier selection list	Rolling 12-month ASM/RPM trend report vs peer group (e.g. Delta, United, Southwest)	ASM CAGR benchmarked against top-5 network carriers; report produced within 3 days of T-100 release	N	N
3.2	Benchmark CASK and RASK against published Form 41 data	Revenue Planning Analyst	AWS S3 / Redshift	DOT Form 41 P-12 financial schedules; internal cost allocation data from SAP S/4HANA Finance	CASK/RASK variance report with carrier ranking and gap-to-best-in-class analysis	RASK within ±3% of peer median; CASK gap-to-best flagged if >10% adverse variance	N	N
3.3	Evaluate whether own metrics fall below benchmark thresholds	Director of Network Planning	Tableau / Power BI	CASK/RASK variance report and ASM/RPM trend analysis	Benchmark status flag: within tolerance / below threshold / critical gap	Benchmark review cycle completed quarterly; critical gaps escalated to VP Network within 48 hrs	Y	N
Phase 4 4.1	Run O&D traffic share analysis by market	Revenue Management Analyst	Amadeus SkyCAST	GDS booking share data; T-100 O&D traffic estimates; SkyCAST demand model	Market share report by O&D pair: own share vs top-3 competitors, trend over 8 quarters	Market share tracking coverage ≥90% of top-50 O&D markets by revenue; report cycle ≤10 business days	N	N
4.2	Model revenue impact of competitor capacity changes	Revenue Management Analyst	Amadeus SkySYM	Market share report; competitor capacity delta from Phase 2; SkySYM demand elasticity curves	Revenue impact model: projected incremental revenue gain/loss under each competitive scenario	Revenue impact model completed within 5 business days; scenario accuracy validated against last 4 actuals within ±8%	N	N
4.3	Assess whether schedule response is justified by revenue model	Director of Network Planning	Amadeus SkySYM	Revenue impact model from Step 4.2; available fleet and crew headroom data	Go/no-go decision on capacity response; disposition for each flagged route	Decision issued within 3 business days of revenue model delivery; routes with projected NPV >$500K fast-tracked to schedule change workflow	Y	Y
Phase 5 5.1	Draft capacity response and schedule recommendations	Schedule Planning Manager	Amadeus SkyWORKS	Approved route disposition list from Step 4.3; current season schedule in SkyWORKS	Draft schedule change request: frequency additions, gauge upgrades, or withdrawals with effective dates	Draft recommendations delivered within 5 business days of go-decision; SSIM-formatted change files ready for slot filing	N	N
5.2	Cross-validate recommendations with Amadeus NRM inventory	Revenue Management Analyst	Amadeus Revenue Management (NRM / AltéaRM)	Draft schedule change request; NRM current fare class inventory and booking pace	NRM alignment sign-off or revised recommendation with RM-adjusted timing/frequency	NRM review completed within 3 business days; <10% of recommendations require material revision due to inventory conflict	Y	N
5.3	Submit approved schedule changes to planning queue	Schedule Planning Manager	Amadeus SkyWORKS	NRM-approved schedule change request; IATA slot filing deadlines	Confirmed schedule change submitted to SkyWORKS production queue; IATA CRS slot filing initiated where required	100% of approved changes submitted within IATA CRS filing window; zero capacity responses missed due to deadline breach	N	N

📋

Process Attributes

Identification

Process IDNP-SP-14

L1 DomainNetwork Planning & Scheduling

L2 ProcessSchedule Planning

L3 NameCompetition & Capacity Benchmarking

L4 Steps17 across 5 phases

Decision Gates5 (all with iteration loops)

Exceptions2 documented

Swim Lanes (Roles)

Network Intelligence Analyst

Schedule Planning Analyst

Director of Network Planning

Revenue Planning Analyst

Revenue Management Analyst

Schedule Planning Manager

Systems & Tools

OAG Schedule AnalyserAWS S3 / RedshiftSabre GDSAmadeus SkySYMTableau / Power BIAmadeus SkyCASTAmadeus SkyWORKSAmadeus Revenue Management (NRM / AltéaRM)

Key Performance Indicators

Extract competitor schedule data from OAG feedData currency: schedule feed ≤7 days old; coverage ≥95% of target markets

Ingest DOT Form 41 traffic and capacity statisticsIngestion completeness ≥99% of published BTS records; pipeline SLA <4 hrs post-BTS release

Pull GDS booking and availability data for share estimationMarket coverage: GDS data represents ≥70% of bookable seats on target routes

Validate data completeness and trigger re-pull if gaps detectedData quality gate pass rate ≥98% before advancing to analysis phase

Map competitor frequency and timing by routeFrequency gap identified on ≥80% of monitored routes within 5 business days of OAG refresh

Assess competitor fleet gauge and seat capacity per routeSeat capacity variance vs prior period flagged within ±5% accuracy against T-100 actuals

Identify competitive schedule gaps and overlap windows≥5 whitespace route opportunities or ≥3 overlap-reduction candidates identified per quarterly cycle

Determine whether material competitive threat warrants escalationEscalation decision issued within 5 business days of schedule gap analysis completion

Airline-Specific Risks & Pain Points

OAG schedule data lags actual GDS availability by 24–72 hrs; codeshare operating vs marketing carrier misclassification inflates competitor frequency counts

T-100 data is released with a 60-day lag; ultra-LCC capacity additions are visible in OAG weeks before T-100 confirms actual operation

NDC channel bookings bypass GDS; LCC direct-channel share is structurally underrepresented, causing systematic underestimation of competitor capture rate

Partial OAG refreshes due to airline filing delays leave gaps for low-frequency international routes; manual gap-filling introduces analyst subjectivity

Ultra-LCC seasonal schedule volatility (Spirit, Frontier) makes frequency comparisons unstable; weekly snapshots miss intra-week capacity dumping tactics

SSIM equipment codes are often filed as generic family codes (e.g. 32A for any A320-family) making true gauge differentiation between A319/A320/A321neo unreliable

Inputs / Outputs

Primary InputWeekly OAG data subscription refresh (SSIM-format schedule file)

Primary OutputConfirmed schedule change submitted to SkyWORKS production queue; IATA CRS slot filing initiated where required

←PreviousNP-SP-13 · Charter & Ad-Hoc Flight Planning NextNP-SP-15 · Strategic Network Planning→