Plan adherence calculation

[Karthik12]

Hello Team,

I have Production plan sheet (datewise) and Actual production sheet. I would like to know what is my plan adherence days and percentage. 

i,e 21-12-2022 my plan is Product A-52 nos and actual production is product B-55 nos.

     22-12-2022 my plan is Product A - 80 nos and actual production is product A - 70 nos.

So, my plan adherece for product type is 50% and plan adherece for qty is 83.3 from selected date of 21-12-2022 to 22-12-2022.

Like this can we do for the below data?

Actual production sheet

https://vontier-my.sharepoint.com/:x:/g/personal/karthikeyan_palanisamy_gilbarco_com/EbEer7y1YBVCuyN...

Plan sheet 

https://vontier-my.sharepoint.com/:x:/g/personal/karthikeyan_palanisamy_gilbarco_com/EcpHKtaSl_NOtAF...

Thanks in advance !