Linear programming

This is a problem related to linear programming and sensitivity analysis.
Please solve this and explain how you arrived at the solution.
Please do this in Excel by using "Solver" or management science software...which ever is convinient for you.
The problem is attached.
Thank you.