Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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-

  

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. :

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Management Science A Modeling And Cases Studies Approach With Spreadsheets

Authors: Frederick S. Hillier, Mark S. Hillier

5th Edition

978-0077825560, 78024064, 9780077498948, 007782556X, 77498941, 978-0078024061

More Books

Students also viewed these Mathematics questions

Question

Describe contributions of Melanie Klein.

Answered: 1 week ago