Given the following all-integer linear program: (COMPLETE YOUR SOLUTION IN EXCEL USING SOLVER AND UPLOAD YOUR...

Transcribed Image Text:

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) 6 J + 11 M MAX s.t. 9 J+3 M 27 7 J + 6 M 42 4J+8M < 30 J, MO and integer a. Solve the problem (using SOLVER) as an LP, ignoring the integer constraints. What are the values of J, M, 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 J, M, 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 J,M, 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 J, M, and the objective function? 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) 6 J + 11 M MAX s.t. 9 J+3 M 27 7 J + 6 M 42 4J+8M < 30 J, MO and integer a. Solve the problem (using SOLVER) as an LP, ignoring the integer constraints. What are the values of J, M, 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 J, M, 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 J,M, 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 J, M, and the objective function?