The following is the Excel Solver output of Linear Programming Problem. Objective Allowable Reduced Cost Coefficient...

  

Transcribed Image Text:

The following is the Excel Solver output of Linear Programming Problem. Objective Allowable Reduced Cost Coefficient Increase 1800000 120000 1600000 1280000 Name Variable-S Variable- M Constraints: Name Year-1 Year-2 Year-3 Maximum of S Maximum of M Final Value Rs.: 0.608695652 0 0.869565217 0 Final Value 800000 669565.2174 500000 Constraint R.H. Side 2.782608696 800000 700000 500000 Shadow Price 0 0.52173913 0.608695652 0 0.869565217 0 1 1 Allowable Increase 22950.81967 1E+30 25000 1E+30 1E+30 Allowable Decrease 800000 100000 Allowable Decrease 60000 30434.78261 38888.88889 0.391304348 0.130434783 All questions are independent. a) The objective function value at the optimal solution is Rs. : b) The tight constrain are if any: c) If the Year-1 constrain is reduced from 800000 to 790000 the objective function value will be d) If Year-2 constrain are increased from 700000 to 710000, the net change in the objective function will be Rs.: e) If Year-3 constrain are increased from 500000 to 520000, the net change in the objective function will be Rs.: f) If the objective function coefficient for variable Variable-S is increased from Rs. 1800000 to Rs. 1900000, the objective function value will be Rs. : The following is the Excel Solver output of Linear Programming Problem. Objective Allowable Reduced Cost Coefficient Increase 1800000 120000 1600000 1280000 Name Variable-S Variable- M Constraints: Name Year-1 Year-2 Year-3 Maximum of S Maximum of M Final Value Rs.: 0.608695652 0 0.869565217 0 Final Value 800000 669565.2174 500000 Constraint R.H. Side 2.782608696 800000 700000 500000 Shadow Price 0 0.52173913 0.608695652 0 0.869565217 0 1 1 Allowable Increase 22950.81967 1E+30 25000 1E+30 1E+30 Allowable Decrease 800000 100000 Allowable Decrease 60000 30434.78261 38888.88889 0.391304348 0.130434783 All questions are independent. a) The objective function value at the optimal solution is Rs. : b) The tight constrain are if any: c) If the Year-1 constrain is reduced from 800000 to 790000 the objective function value will be d) If Year-2 constrain are increased from 700000 to 710000, the net change in the objective function will be Rs.: e) If Year-3 constrain are increased from 500000 to 520000, the net change in the objective function will be Rs.: f) If the objective function coefficient for variable Variable-S is increased from Rs. 1800000 to Rs. 1900000, the objective function value will be Rs. :

Answer rating: 100% (QA)

The image seems to be the output of an Excel Solver for a Linear Programming problem Heres the solution to each independent question based on the data given a The objective function value at the optim... View the full answer