NIGMI UZ I want Pl. remember you are bound by the University Policy on Academic Integrity. Violation will lead to severe penalty You have 2 hrs to complete both Part A & Part B and uplaod it on Canvas Answer Q1 & 02. Q1. ( 20 points) Indicated below are the Labor Hours required to produce Product 1 & 2 in departments A, B & C. (both products ahave to go through allt The total hours avaiable asl also the profict contribution of each prodcut is also shown. (i) Type out the objective function and constraints. This will enable me to give you partial credit if Solver does not execute. (ii) Set up the problem in excel and solve it using Solver. The Answer Report must be downloaded. The solver dialog box should be popul Department Product 1 A Labor Hours required per unit Product 2 Hours Available 1 0.35 100 0.3 0.2 36 0.2 0.5 50 B Profit Contribution $30 $15 NIGMI UZ I want Pl. remember you are bound by the University Policy on Academic Integrity. Violation will lead to severe penalty You have 2 hrs to complete both Part A & Part B and uplaod it on Canvas Answer Q1 & 02. Q1. ( 20 points) Indicated below are the Labor Hours required to produce Product 1 & 2 in departments A, B & C. (both products ahave to go through allt The total hours avaiable asl also the profict contribution of each prodcut is also shown. (i) Type out the objective function and constraints. This will enable me to give you partial credit if Solver does not execute. (ii) Set up the problem in excel and solve it using Solver. The Answer Report must be downloaded. The solver dialog box should be popul Department Product 1 A Labor Hours required per unit Product 2 Hours Available 1 0.35 100 0.3 0.2 36 0.2 0.5 50 B Profit Contribution $30 $15