Question: Given the following all-integer linear program: (COMPLETE YOUR SOLUTION IN EXCEL USING SOLVER AND UPLOAD YOUR FILE. BE SURE THAT EACH WORKSHEET IN THE EXCEL
Given the following all-integer linear program: (COMPLETE YOUR SOLUTION IN EXCEL USING SOLVER AND UPLOAD YOUR FILE. BE SURE THAT EACH WORKSHEET IN THE EXCEL FILE CORRESPONDS TO EACH QUESTION BELOW ) MAX 6X + 11Y s.t. 9X + 3Y < 27 7X + 6Y < 42 4X + 8Y < 30 X, Y 0 and integer a. Solve the problem (using SOLVER) as an LP, ignoring the integer constraints. What are the values of X, Y, and the objective function? b. What solution is obtained by rounding all fractional decision variables (round fractions >= 0.5 UP and <0.5 DOWN)? What are the values of X, Y, and the objective function? Is this solution feasible? Is it the optimal integer solution? c. What solution is obtained by rounding the decision variables DOWN? What are the values of X, Y, and the objective function? Is this solution feasible? Is it the optimal integer solution? d. Resolve original problem using SOLVER with the Integer requirements included. What are the values of X, Y, and the objective function
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
