@ Ravi Sankar Iyer,
Good Evening......!!!!!!
Please find attached Revised Sheet for 5.0 & 3.5 Lacs Package as required.
Suggestions :
1) In your 5 Lacs salary structure You will be paying 39160.42 + 2835 + 2500 = 44495.83 X 12 (months) = 533940 CTC, So its showing wrong CTC higher 33940 yearly. You can change the same in 3.5 CTC structure as well.
2) In your 3.5 Lacs salary structure You have calculated Employer's PF (13.61%) on HRA which is wrong. It has to be on Basic.
3) As per latest amendments in PF laws the PF Ceiling Limit has increase from 6500 to 15000. & in 5 Lacs salary structure the Basic is above 15000, so you may exclude if PF is not required by Employee. While in 3.5 CTC PF becomes compulsory as the Basic is 14584.
4) Even as per ceiling limit you may decide the PF max limit up to 1800 (15000*12% OR 15000*13.61% = 2042) if your company policy allows. This will low down you manpower cost without violating govt. laws.
Revert in case you required any more information.
All the best