How to maximize profits or minimize bench by Excel Solver

[rush2rajen]

I am having IT/ITES company that is involved in projects and process outsourcing of four different divisionsof IT, ITES, BPO and Analytics.File attached for reference



Thanks
Raj

 

[r2c2]

You can set up a linear model to solve this. The structure of your data is cumbersome. So I rearranged it and set up the solver model.

See attached.

 

[rush2rajen]

Thanks a lot