I'm the VP of Learning & Development at an aerospace manufacturer with about 24,000 people in the US, the UK and France. My analyst built the roll-up slide below from three regional decks. I'm presenting it to our executive leadership team on December 3, and they want one answer: is the workforce certified and ready for a production rate increase on March 1? Before I put my name on this slide, I need you to check it.
Please give me:
1. Claim check: a table with each claim on the slide, what the regional decks actually support, and which deck and slide shows it.
2. What the slide leaves out that the leadership team should see.
3. A rewritten slide: a headline, up to four bullets, and one line on anything that can't be compared.
Be skeptical. Read every slide, including the appendices. Check that numbers measure the same thing before you combine or compare them, check what each trend is compared against, and check dates and lead times against the deadline. If something is missing, say it's missing. Don't add facts that aren't in the inputs.
[A] Email from Martin Hale, Chief HR Officer
Subject: ELT Dec 3 — certification readiness
Claire, you have 10 minutes on Dec 3. The ELT wants one answer: is the workforce certified and ready for the March 1 rate increase? One slide please. Operations is counting on 600 additional certified structures assemblers by March 1.
[B] Roll-up slide, drafted by Ravi Menon, L&D analyst
Title: Certified workforce: 91%, on track for the March rate increase
- 21,730 of 24,000 employees certified = 91% across all regions
- Up 7 points since Q1 (84%)
- US 95% · UK 84% · France 89%
- 380 new assemblers start January 12 to support the rate increase
- No major risks
Chart: Q1 84% → Q3 91%
Notes from Ravi: "Built from the three regional decks. France total = 89% x 5,000."
[C] US regional deck (Q3), summary of slides
Slide 2: Headcount 12,000. Certified 11,400 = 95%.
Slide 3: Definition: certified = all required courses for the role completed in the LMS.
Slide 4: Trend: Q1 86% · Q2 94% · Q3 95%.
Slide 5–8: Course completion by site.
Slide 9 (appendix): NDT inspection. Level 2 inspectors certified: 11 of 19 required. Four of the eleven expire in January. External Level 3 examiner for recertification: none booked yet.
[D] UK regional deck (Q3), summary of slides
Slide 1: Headcount 7,000. Certified 5,880 = 84%.
Slide 2: Definition: certified = signed off on the job by a qualified skills assessor (authorised stamp holder).
Slide 3: Trend: Q1 80% · Q2 86% · Q3 84%.
Slide 4: Note: 2 of our 5 skills assessors on long-term leave since August. Sign-off backlog: 410 people trained and waiting for assessment.
[E] France regional deck (Q3), summary of slides
Slide 1: Headcount 5,000 across three sites.
Slide 2: Definition: certified (habilitation) = training complete + medical fitness + written authorisation from the supervisor.
Slide 3: Toulouse and Méaulte: 3,204 of 3,600 certified = 89%.
Slide 4: Saint-Nazaire (1,400 people): data not yet received.
Slide 5: Trend (two reporting sites): Q1 85% · Q2 88% · Q3 89%.
[F] Note from Operations planning
Rate increase March 1 needs 600 additional certified structures assemblers. Hiring: 380 new assemblers start January 12 (US 240, UK 140). The structures assembly certification programme takes 10 weeks from start date. Remaining 220 to come from cross-training existing staff (plan not yet finalised).