Figure 1: 3 Number to Make OBJ. FN. VALUE Unit profit $4 S3 Used Available 40 12
ID: 357755 • Letter: F
Question
Figure 1: 3 Number to Make OBJ. FN. VALUE Unit profit $4 S3 Used Available 40 120 15 Constraints 12 10 0 10 Figure 1 demonstrates an Excel spreadsheet that is used to model the following linear programming problem: Max: 4X1+3X2 Subject to 12 X1 10 X2s x)2 15 X1, X220 120 Note: Cells B3 and C3 are the designated cells for the optimal values of X1 and X2, respectively, while cell E4 is the designated cell for the objective function value. Cells D8:D10 designate the left-hand side of the constraints.Explanation / Answer
According to the image that is provided, the changing cells are B3:C3. These cells are the variable cells which can take different values for X1 and X2. These values will be subjected to the constraints and the combination of values that provide the maximum value to the optimal function while staying within the constraints will be the final answer.
Hence option b is the correct answer.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.