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.
Solution contains Sensitivity analysis and Interpretation of Linear programming solution