Hi Akbar,

See the attached file where I have provided few formulas to achieve the results

Further to this, you can use vlookup to obtain budgets for apple, oranges if you wish

Trial Copy 1.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>