AOP Vs Actuals and Variance analysis

[Nandagopal]

Hi All, Hope you all well. I need prepare AOP VS actuals and variance analysis with creating charts. I have attached the AOP Vs Actuals file as sample file.

Kindly provide your inputs.

Thanks,
Nanda

 

[AVK]

Refer attach file.
In "Monthly Expenses" sheet in "G" column calculate achievement percentage.
Look at summary sheet in this sheet we summarizes Data with using formula index match.

 

[Nandagopal]

Refer attach file.
In "Monthly Expenses" sheet in "G" column calculate achievement percentage.
Look at summary sheet in this sheet we summarizes Data with using formula index match.

Thank you and that was really excellent!
Also, can you please help in preparing the same in chart. So that management will have quick look to take a decision.

Many thanks!