I do not need the actual answers to be filled out but woula step by step by step explantion on how to do the calculations that this is asking for.

An aircraft in your portfolio has not shown signs of increased engine deterioration; however, the operator has removed the engine for accomplishment of a performance restoration and LLP replacement of the Low Pressure Turbine $($LPT$)$ module in accordance with manufacturer's guidelines. As required by the lease, the operator has notified you that they intend to send the engine to a shop and that the work scope being undertaken will entitle them to claim from the maintenance reserve fund. On behalf of the lessor, you advise the operator that this may not qualify for reimbursement as per the lease agreement and request to keep you notified on the progress of the shop visit. Despite timely emails to the operator requesting an update, you do not hear any news for $6$months.

Following $6$ months, the operator submits an invoice for maintenance contribution to the value of $$1,600,620$ including VAT and handing costs. The operator also provides verification that this is the actual cost of the shop visit as billed by the engine shop.

i$.$ Based upon the "Given Information" and "Lease Extracts$,$ carry out an initial assessment of the actual amounts owed by the Lessor $($the $$Lessor Maintenance Contribution$),$ if any, and provide your supporting calculations in excel format. Note that you may not have all the required information to make a final determination. Following this, summarize your findings to the lessee in response to their claim outlining the actual amount you determine to be owed by the lessor, any concerns, and questions you may have in order to finalize the assessment.

ii$.$ Following a review of the lease redelivery conditions, you discover a requirement for the operator to perform an Engine Performance Restoration event on the core modules immediately prior to the lease expiry date. You review the current utilization and forecast that the engine will operate a total of $27,000$ flight hours during the entire lease term. Based on these findings, compose a short report summarizing the reasons why the work scope performed at current shop visit was$/$or was not the most cost efficient. If the minimum contractual Engine Performance Restoration release life had increased from $5,000$ Flight Cycles to $6,000$ Flight Cycles, would it have had an impact on the work scope performed?

Given Information

Assumptions

$1.$ Airworthiness Directives cost sharing is not applicable.

$2.$ The engine removal is not a result of maintenance mishandling or foreign object damage and is not covered by the operator$$s insurance.

$3.$ Handling fees and VAT is included in the total cost and amounts to $3\%$ of the total ESV cost.

$4.$ The LPT life limited parts have been replaced with new. The remaining life limited parts have not been replaced.

$5.$ All engine modules have been overhauled.

$6.$ Module split applies to the total ESV cost.

$7.$ Annual escalation of the MRA rates is not applicable.

$8.$ The total cost of a new stack of LLPs at the time of the event was $$3\mathrm{.}3$million.

Time Since New $27,000$

Cycles Since New $18,000$

EPR Maintenance Rent Rate $$130$

LLP Replacement Maintenance Rent Rate $$145$

Time Since Last Overhaul

$-$ Fan & Booster $27,000$

$-$ Core $0$

$-$ LPT $27,000$

Cycles Since Last Overhaul

$-$ Fan & Booster $18,000$

$-$ Core $0$

$-$ LPT $18,000$

Time Since New $37,500$

EPR Maintenance Rent Balance $$1,365,000$

Cycles Since New $25,000$

LLP Replacement Maintenance Balance $$1,015,000$

Fan and Booster EPR $(14\%)$ and LLP $(20\%)$ with an LLP Life Limit of $30,000$

Core EPR $(68\%)$ and LLP $(52\%)$ with an LLP Life limit of $20,000$

LPT EPR $(18\%)$ and LLP $(28\%)$ with an LLP Life limit of $25,000$

Lease Extracts

Clause $1$Maintenance Rent

$1\mathrm{.}1$

Lessee shall pay to Lessor Maintenance Rent with respect to each calendar month $($including without limitation the last calendar month, or part thereof, of the Lease Term$)$ on the fifteenth $(15$th$)$ day following such calendar month. Maintenance Rent shall be payable with respect to each of the following maintenance activities, each a "Maintenance Rent Activity" or "MRA":

i$)$

each Engine with respect to accomplishment of an Engine Performance Restoration.

$1\mathrm{.}2$

Provided no Defaultor Event of Default has occurred and is continuing, Lessor shall pay to Lessee, by way of contribution to the direct cost of any Maintenance Rent Activity, the amounts set forth in this section $1\mathrm{.}2.$ Payment of such amounts shall be made out of the applicable MRA Maintenance Rent Balance only after the work has been completed and supporting documentation has been provided by a Maintenance Performer and Lessee.

Engine Maintenance Claim

Lease Extracts

Clause $1$Maintenance Rent

Payment of such amounts shall further be conditioned upon submission by Lessee to Lessor, within six $(6)$ months from the induction date and no later than six $(6)$ months from the Expiry Date, of

$($i$)$an invoice with proper supporting documentation $($e$.$g$.,$ full shop visit report, EASA Form$-1,$FAA$-81303$ or similar documentation evidencing serviceability, as described below$)$ satisfactor