Para.9.9. Airbus A340-500/600 unit delivery projections – some initial inputs/reminders(A) Reminder from para 4 re extract from Mr Dekker’s oral evidence in April 2008
His May 2009 document input “At a glance the assessment that would have been carried out by the auditors in order to satisfy themselves that the accounting on this matter was appropriate.” (B) As you can read in the extract from the PwC forensic accountants at PwC para 8.78 on A340-500/600 quantities in the EAC which formed the part of the basis of their derived conclusions?? “PwC Observation: Based on third party information presented above (BL:solely the FI April 2007 report) and on management information obtained, the delivery of a combination of production units and spare units totalling at least of 1,285 units over the life of the programme ending FY2021 is not unreasonable.” (C ) Mr Neill’s oral evidence in cross-examination in July 2009
(D) We also have Mr Bobbi’s evidence and the thrust of Mr Lynch’s questioning, presumably on instruction on doc 3597 on 8 June 2009
9.9.1In addition to the basic logic and mathematics quantity errors set out in Para 9.2 it is inconceivable that a 7 month “Independent forensic investigation” - to ensure the accuracy and reliability of the MAC Balance Sheet etc and which states at PwC para 2.40 that Financial Control in MAC is poor whilst stating at (d) Poor control over individual projects from an accounting perspective. Project sales volumes, revenues and costs are not reviewed with sufficient frequency or rigour.” - would then proceed to make NO reconciliation /commentary within the tasking and C$3m+ report by PwC – that is between Airbus projections numbers, that of any of the other six + external forecasters and the MAC documented “representations” set out below:
This PwC Exhibit 8.3 document schedule (1831/1831A) is the representation made by MAC to E&Y in the Q4.FY2006 Estimate at Completion (EAC). As per the PwC report para 8.61 “The Q4 FY2006 EAC was also used by EY for year-end audit testing purposes.” The Estimate at Completion (EAC) process/documents are the MAC management “most reasoned view and most likely outcome” – oral evidence :Dekker” and showed in this Q4.2006 EAC submission to the auditors E&Y and PwC an improvement over Q2.2006 gross losses exceeding C$5.2m to a miniscule $0.1m gross profit on $250m program revenues
It is noted that Mr Neill and Mr Furbay later wrote on 22 March 2007, in response to PwC Q2 (3598A), and apparently after the 1 March 2007 email/schedule (3605B-G) at D) sent below, (“Of the units which remain to be delivered – what is the split between production and spares / repair units ?” MAC Answer “1,155 production units and 190 spares/repairs as provided to you on our initial projection dated 2/16/2007.” This is vitally important as they also recorded in response to Q3 on 22 March 2007 from PwC (3598A) “Management’s judgment does not differ from the estimate used at 31 December 2006. Please see Answer 1 above. Any alternative projections produced were at the request of PwC or E&Y and were provided for reference purposes. New information that has become available has not changed our well established and consistent estimate and is therefore not pertinent.” This volume information was then extracted from document c) above “Best information as at 31 December 2006 - doc dated 16 Feb 2007 (3605) = 18 + 172 = 190 spares/repairs. Although sent to both PwC & E&Y this information or Exhibit or its consequential implications also does not appear in the PwC report. Furthermore, PinsentMasons, on behalf of Mr Dekker, the MAC Chief Financial Officer described some of this information in this document (C ) schedule for production and spares on 5 May 2009 as “At a glance the assessment that would have been carried out by the auditors in order to satisfy themselves that the accounting on this matter was appropriate.”
This was equivalent to a continuing production rate of 20+ aircraft per year , when the A340 – 500/600 rate was thoroughly briefed to have halved (c- 50% ) to an approx 10 per year in Aug 2006 – see MAC 12 September staff meeting (2179) and (2117) as (a) and the MAC FY2007 budget. Mr Butyniec confirmed his knowledge of that production rate of 10 aircraft per year as making sense in the UK court (see para 5.2). In the same schedule MAC then proceeded to INCREASE the total production build program on 1 March 2007 from 278 a/c to 291 aircraft/1164 units – see Mr Neill’s oral evidence to the UK court on 14 November 2007 below and this document 3605B-G. Unbelievably for anyone, and certainly for those within the aerospace industry, the MAC Production Plan for 2010 = 29 aircraft or 116 engine exhaust systems) sets out an actual increase in A340 production rate which was higher than ever scheduled by Airbus since the inception of A340-500/600 high rate production from 2003-2006 (averaging 20-23 a/c per year) and would not have even have been possible based on known assembly line tooling limitations. e.g A340 wing production at Broughton and certain assembly stations in Toulouse. Furthermore there were NO active airline sales campaigns by 31 January 2007 and a dwindling Airbus order book (as per para 9.8) to support such production forecasts. Mr Neill fundamentally knew this himself, as he told the equity analysts in the Q2.2006 Earnings webcast call on 15 Aug.2006 “In Boeing’s case -- different story. The story of the quarter was the strength of the order book for the Boeing 787 that built through that period but also for the Boeing 777 as well. Boeing won the bulk of the orders for twin-aisle airplanes and had, for the first time, some success that they could boast about. We saw that at the Farnborough Airshow.” > Also revealing is the former President and CEO Mr R Neill (now Vice Chairman) - oral evidence on 14 November 2007
MAC had represented in these 1 March 2007 production volumes for 2007 – 2009 (doc 3605B-G) that were DOUBLE those planned and published by Airbus more than six months earlier (doc 3600). Those MAC 16 Feb 2007 (doc 3605) and 1 March 2007 forecasts to PwC and E&Y (3605B/G) that Airbus would both sell 29 + A340 aircraft in 2007/early 2008 and then plan and be able to increase build to TREBLE the production rate from 2009 to FY2010 (127 or 116 exhausts respectively) was “consciously misleading and deceitful”.
When PwC brought the FI April 2007 forecast of lower production volumes (now FI a/c build of 213 a/c ending in FY2016) to Mr Neill’s attention he then created a “new” Spares and Repairs volumes perspective which had never been documented or heard of before, nor was any of this written in the commercial or engineering documentation with or within Aircelle or the airlines. See his email 3597-3598A-C in which he refers to his instruction to Mr Furbay to recalculate the Spares – which would now read 800+ units (Documents not in PwC Report) . The Spares and Repairs line was then reforecast upwards from the 190 units which had been used for years within MAC (e.g. those on 16 Feb.2007 and 1 March 2007 above) - on Mr Neill’s instruction. This was initially based on Mr Neill’s instructions and then Dr Thamburaj’s email of 12 March 2007 (3618/3621) and a useful “Exhaust life of 40,000 hours” / 5000 flying hours per year. In fact only in July 2009 did we learn that PwC requested a scenario from MAC which was similar to this concensus forecast 135 a/c (and what I had told them) and then Magellan “covered” this by Mr Neill (CEO) then suggesting in his email doc 3597/3598 just hours before the FY2006 financial statements were released to the TSE that replacement spares would be required “as the useful life of the exhaust system was approx 35,000 hours {To provide a margin of safety John Furbay’s analysis used 40000 hrs as the useful life}. This analysis shows that the likely spares requirement in the period 2007 to 2021 was in excess of 800 units (doc 3605H – 886+ units). These documents were not disclosed by PwC who instead independently calculated the “1572” units above at paragraph 9.2. And then we have that document disclosed on 27 August 2009 headed Aeronca Aircelle A340 program – Actual/Estimated Quantities (Engine Sets) dated 14 March 2007 . This document 3605H is critical as it (1) opens up the subject of replacement spares needs at an “assumed” 40,000 flying hours creating in excess of 400 -700 units to enable MAC to continue to use 1285 units in the amortization for the Q4/2006 EAC /FY 2006 in its submission to PwC and E&Y and (2) shows a production volume equal to a Total aircraft build of 135 A/C at Outcome 1 with series production deliveries to Aircelle completing in FY2009. Please now look at this document. (MAC projections of a likely minimum of 886 “spares” (replacement parts) - based on 40,000 flying hours exhaust useful life, which was to provide a margin of safety in those estimates by Mr Neill , the current Vice Chairman- through to FY2021: of which the MAC Spares Plan for 2010 = further 81 engine exhaust systems. As you can read in Outcome 1 : Production volumes plan– a plan based on Airbus’s actual production plan for 2007-2009 to build 32 aircraft (that is (a) 3600 above) with production completing at a total aircraft build of 135 aircraft (542 + 20 development units). This of course was what I suggested (circa 150 a/c my assessment pre termination –see docs 1437/ 2605 and then circa 135 aircraft in my W/S 226.3 by Feb/March 2007) and crucially also the market consensus – 135 aircraft - of 6 out of 7 of the other professional forecasters in 2006/early 2007 as per paragraphs 9.4 and 9.6. The Spares and Repairs line was then reforecast on Mr Neill’s instruction to a resultant Spares total calculated of “886” Spares and Repairs (uplifted from all the prior MAC/Aeronca forecasts. Outcome 2 : Airbus website – total aircraft sales orders – 153 aircraft (3602) and then termination. The production demand forecast of a further 228 units by PwC/MAC failed to review the six airline customer outstanding orders - for multiple aircraft - status. I dealt with this earlier for three of the four major outstanding orders –“effectively cancelled” in paragraph 9.8. The only other significant order had been recently placed in December 2006, by the largest A340 600 aircraft operator Lufthansa, for seven A340-600 – another airline which is audited by PwC. I knew from my own sources within Airbus Toulouse and UK that this campaign had been active for most of 2006 and Airbus were hoping to secure an order for 18+ A340 600 aircraft (& A380 option conversions) whilst strategically seeking to undermine the launch of the new Boeing 747 Intercontinental aircraft. They officially lost that sales battle on 6 December 2006 with the public announcement that Lufthansa was to be the launch customer of the Boeing 747 Intercontinental with an order for 20 aircraft and 20 options. The next day Airbus announced the final order of only 7 A340-600 aircraft with some near term delivery slots in early 2008 taking over the “suspended” A340 600 partially built aircraft. As a matter of record Lufthansa are also audited by PwC. This decision was what made me now conclude that the A340-500/600 total build prospects were now likely to fall from circa 150 – 155 A340-500/600 aircraft to 135 – 140 a/c in the first quarter of FY2007 and certainly by the time of any submissions to E&Y and PwC. My assessment, therefore, was and remains, that the Outcome 1 production forecast (a) used by MAC on 14 March 2007 was almost exactly what I said to PwC, whilst the Spares and Repairs is grossly inflated using “Spares replacements” and ignoring the Factory Repairs (at MAC or elsewhere), when only units that are returned by the airlines and judged Beyond Economic Repair (BER) should be counted – a “norm” of 13%-15% - for Spares. Even on MAC’s “incorrect” assumption of complete replacement at 40000 flying hours the calculation has two business errors. The first, as Mr Neill agreed in his evidence, is that it should have been based on airline aircraft in service dates (not historic delivery dates from Aeronca to Aircelle). Secondly the average annual hours are 4400 flying hours per year. That is a nine year replacement cycle – 40,000/4,400 (not eight years). The production termination at 135 aircraft now meant that the shortfall to the 1285 units required in the Q4 EAC was 705 units with a MAC-assumption-based on full replacement “spares” demand of 613 units by FY2021. PwC had doc.3605H from 14 March 2007 via Mr Furbay. For the avoidance of doubt this “613” number is only the necessary “corrections” as the industry (including Aircelle, the airlines directly, PwC and Mr Neill in his July 2009 oral evidence) do NOT expect to replace every exhaust in service every 8 years.) This is vitally important as PwC also stated, in direct contradiction to Mr Lynch QC cross-examination instructions, in their Question 5 in March 2007 “The engineering report prepared by Dr Thamburaj makes reference to repairs being required (not necessarily spares). What is management’s view on the distinction between spares and repairs and the implications for future revenues / costs? …. etc. See further extracts of oral evidence below and in my Final A340 report. PwC failed to question or properly consider the implications of all the glaringly conflicting data at (a) , (b) , (c) and (d) at their disposal. NONE of these documents or information is disclosed or included as Exhibits in the PwC report – instead PwC decide to do their own assessment with the single Forecast International April 2007 numerical forecast at its core for production supplemented by a fundamentally flawed logic and mathematical calculation for “Replacement Spares and Repairs demand”. All that before industry experience. PwC consciously elected to use as the SOLITARY basis for their Report (see para 8.78.p.63) the FI March/April 2007 market forecast for 2007–2009/2015, which, not only did it not reflect the “market consensus -135” amongst the professional providers and the contemporaneous publications stories, but also, unprecedentedly for the industry, and improbably, FI had also positioned its “High Confidence” forecast by almost 30% above the definitive production plans of 32 aircraft for the next three years of the manufacturer, Airbus, itself. I have never in thirty years witnessed this before in any external market forecasts in the aerospace industry, nor have any of the many others with whom I have spoken in the last three years. Additionally and centrally PwC, as recorded at PwC para 8.3, were aware from my briefings/documents and filed Grounds of Complaint within the UK court process (PD23) that the Airbus internal sales/program scenarios of a further 60 (total build 155 aircraft) and 100 aircraft (total build 195 a/c) - which naturally tend to be higher/optimistic, as they are the manufacturers - exceeded by some 15 – 50% the remaining total aircraft build forecast of 117 made by Forecast International in March 2007. and for Spares Aerospace Industry /Aircelle and expert insights and views - Mark Bobbi - Engine Nacelles August 2007 report (UK document 3015-3025) - Jan - March 2009 report (UK doc 3890 - 3890XX) “In August 2007, I performed a study of the A340-500/600 for Mr. Brian Little. The results of that study are found in the referenced document 3015-3025. The essence of that report was that the A340-500/600 was a market failure, generating far less orders than anticipated in the 1990s by its maker, Airbus. In fact, total orders and options for the A340-500/600 were unlikely to exceed 130-135 which, as I am now aware, is approximately 150 /175 less than MAC’ amortization figure for the A340 NRC……. ……Therefore, I find it impossible to believe MAC’ spares/repairs forecast is based on any rational market assessment and runs completely counter to my and others career-long experience together with the detailed communications I undertook with the maintenance people in the airlines flying the -600 aircraft” MARK BOBBI - WITNESS STATEMENT (W/S) TO UK COURT - EVIDENCE GIVEN ON 8 JUNE 2009 We also have Mr Mark Bobbi’s evidence and the thrust of Mr Lynch’s questioning ,presumably on instruction, on 8 June 2009
Given the intensity of Mr Lynch’s cross-examination on Spares replacements please now access 4184 / 4183 : MARK BOBBI EMAIL AND REPLY (24 JUNE 2009 FROM AIRCELLE - MAC'S CUSTOMER - RE A340/T500 EXHAUST LIFE "40,000 hour or less replacement requirement ...WE BELIEVE THE WHOLE THING IS A HOAX....." Mr Neill’s oral evidence in July 2009
and in Mr Neill’s oral evidence on 27 July 2009
Equally an experienced industry person from PwC Aerospace and Defense Global Centre of Excellence in London carrying out the same relatively simple searches would have seen what Mr Bobbi and I had already seen and confirmed in the Aircelle Component Maintenance Manual for T500 Exhaust nozzle and plug – sample 3625S – refers, and had always done so, to “FACTORY REPAIRS” by the manufacturer – Aircelle in the operating airlines. A further example from Etihad who are one of the largest A340-500/600 operators – please read 4185 / 4186 and 4186A: Email from Aircelle (23 June 2009) to Etihad Airways regarding A340/T500 exhaust system life / certification "...There is no specific life limitation for the T500 exhaust system…….” Magellan and their own advisors (PwC) recognise that “due to the unpredictability of repair work” Factory Repairs (for On Condition Maintenance components) should not be included when recovering NRC assets. They are also subject to contractual MTBUR and Guaranteed Direct Maintenance Cost (DMC) values of much less than a $1 per flying hour with Aircelle/Airbus (doc 3525). Q9.9A: PwC criticised MAC in para 2.40 (d) for “Poor control over individual projects from an accounting perspective. Project sales volumes, revenues and costs are not reviewed with sufficient frequency or rigour.” PwC then proceeded to set to one side all the various MAC representation documents (other than the Q4.2006 EAC) and failed to refer or Exhibit them at all. They chose instead to unilaterally extend the commercial contract period for the A340-500/600 with Aircelle from FY2012 to FY2021 for the EAC and fundamentally failed to question and integrate all the glaringly conflicting data at their disposal. That is the foundation of any reasonable audit checking and integration testing. Is it really credible that PwC’s forensic accountants failed to find most or all of this, and document this properly in their Findings of Fact? (OR did they believe it would undermine their “Findings of Fact”). Instead their report demonstrates that PwC took it upon themselves to produce a “Program EAC” from a mixture of Units and pricing information. Is is it not extraordinary that they would independently chose to do so, and end up with answer which would apparently support Mr Dimma and MAC’s needs for a program break-even - as per the “MAC presented” Q4.2006 EAC at the outset??. <BL Observation example : This comes in to sharp focus when one looks at the information contained in these various plans for next year (FY2010). Based on these crucial March 2007 documents therefore the manufacturing volumes projected for 2010 in Magellan’s plant Aeronca Inc was now for some 116 production (reduced from 127 as at 31 Dec.2006/page 3) and 81 spares (was 8)= 197 engine units (or almost 50 aircraft sets). As the contracted pricing was identical for production and spare engine exhaust systems the A340 program revenue projections for 2010 would be for some C$47m–C$50m with the attendant NRC and cash recoveries in the MAC strategic planning and financial budgeting/reporting processes. I believe it was predictable then, and will actually be now, some 90%+ lower i.e less than C$4m. I included this point specifically in my 27 November 2009 letter to the MAC Directors, before their December 2009 MAC Board meeting, inviting each Director to look at these very carefully for the FY2009 financial audit by E&Y and when reviewing the FY2010 MAC budgets for approval at that December Board meeting – you will see this in part of my letter when I said: “Part of my team role, as both a MAC Senior Officer and with functional responsibility for coordinating the MAC strategy, was to identify these major matters and have them addressed by us all within management. Mr Dekker’s comment to the Judge that I had simply a different point of view about the A340 -500.600 in August 2006/September 2006 is very far removed from the truth. This week you will be approving the MAC budgets for 2010. Look specifically at what those MAC budgets include for the A340 production units and spares. As you know from my MAC Board May 2006 presentation, there is a typical three year lead time from aircraft wide body sales campaign to delivery. MAC represented in March 2007 to PwC and E&Y that in 2010 some 116 units/28 production aircraft (1 March 2007: doc 3605B/D to E&Y and 3605E/G to PwC) would be built and projected a Spares build of 81 units (14 March 2007: doc 3605H/red Tab page 68) – a total manufacturing requirement in Aeronca of some 200 x A340 units in FY2010. My view, by February 2007, was that we would be more likely to be facing the production case shown by MAC at document 3605H dated 14 March 2007 /Page 68 (total production build of 135 aircraft) whilst back in Aug /September 2006 MAC would be lucky to still be building at a rate of 10 aircraft per year by 2010 with the termination of meaningful series production of the A340-500/600 very probably imminent. Even now Mr Neill would, it would appear; based on his July 2009 evidence to the court does not admit that. I believe instead you will read in those submitted MAC budgets for 2010 A340 production = 0 and Spares (rotables and replacements) of 8 – 10 units. This was predictable and indeed predicted by six external market forecasters, and almost everyone else with experience in the industry from mid 2006/early 2007, except those MAC Senior Officers on this the largest cash recovery/asset in the MAC Balance Sheet/Strategic Plan. I understand that the Program EAC is not just about volumes, prices and costs matter too, and those were and have been carefully considered then and now by me. See my A340.On the Record.Final.Report.” and then again in the Actual Outcomes to date - ADDED 7 August 2010 I have also recently learned that Mr John Furbay (the Magellan/Aeronca CFO, including the A340-500/600 EAC accounting role) was dismissed by Mr Dekker and escorted off the Aeronca site by the General Manager at the end of June 2010/Q2.2010. AND spares units. This 121 also compares with Magellan submissions to E&Y and to PwC of 366+ production/spares and the use of 439 units in the CFO/Finance Program EAC used by E&Y for their Q4.2006 audit testing for the same 42-month period from January 2007. The latest Airbus delivery projections schedule (30 June 2010) from Airbus shows that, at present, do not plan any further Assembly of A340-500/600 aircraft. This now leaves the two A340-500 (ex cancelled Kingfisher aircraft MSN886 /MSN894 at TLS - assembled in early 2008) which Airbus are continuing their endeavours to resell – my latest information is to Sonair. I expect there may be an occasional A340-500 VIP aircraft sold in the next period (largely out of exhausts inventory already within Airbus/Aircelle ) but fundamentally the mid-2006/early2007 estimate of approximately 135 A340-500/600 production deliveries and series production cessation in 2010 has come to pass. For completeness I had not foreseen the A340-500 April 2006 order cancellation in early 2008 by Kingfisher Airlines of India in August/September 2006. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||