Lead time vs Request date vs POD date

[nuguns]

Hi,

Our lead time is 6 weeks from Booking Date but some Customers put a Requested Date of further out, eg. 8 weeks from Booking Date.
If I run a simple LT calculation, we will always fail to meet KPI because the we are delivering 8 weeks not 6 weeks.
Is there a formula or calculation that can factor in Customers requesting beyond the LT?

Eg.
Here there is an 8 week RD so if I use 6 week LT, it is a failure...
How then to also calculate if there the product is within LT but still fails?

[TABLE="width: 1013"]
<tbody>[TR]
[TD]PN#[/TD]
[TD]Booking Date[/TD]
[TD]Request Date[/TD]
[TD]Proof of Delivery Date[/TD]
[TD]Lead Time Failure?[/TD]
[TD]Requested Date vs POD Failure[/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]01-January-2018[/TD]
[TD]01-March-2018[/TD]
[TD]01-March-2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]01-January-2018[/TD]
[TD]01-March-2018[/TD]
[TD]01-April-2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Product C[/TD]
[TD]01-January-2018[/TD]
[TD]01-February-2018[/TD]
[TD]01-February-2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Product D[/TD]
[TD]01-January-2018[/TD]
[TD]01-February-2018[/TD]
[TD]01-March-2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hope this makes sense.
Thanks!

 

[steve the fish]

Im not sure what lead time failure means but maybe this for the other header:

=D2>MAX(B2+42,C2)

 

[nuguns]

Thanks Steve, that works for RD vs POD Failure. Max is a new one for me

Lead time failure is where POD is greater than 6 weeks, but this is also relative to when the request date is.
Maybe I am over thinking things.
Thanks anyway for your help.