ome File Edit View History Bookmarks People Tab Window Help 100% 27 Fri 6:23 PM Q Assignments: $2305-MBA-85 X Question 16 - Proctoring Enablex + C getproctorio.com/secured#lockdown * # K Paused M Gmail YouTube Maps Proctoring Enabled: Final Exam i Saved Help Save & Exit Submit 16 Note: This problem requires the use of a linear programming application such as Solver or Analytic Solver. A firm has prepared the following binary integer program to evaluate a number of potential locations for new warehouses. The firm's goal is to maximize the net present value of their decision while not spending more than their currently available capital. Max 20x1 + 30x2 + 10x3 + 15x4 02:05:53 s.t. 5x1 + 7*2 + 12x3 + 11x4 $ 21 {Constraint 1) *1 + x2 + x3 + x4 > 2 {Constraint 2} eBook *1 + x2 = 1 {Constraint 3] *1 + x3 2 1 {Constraint 4) 100% References x2 = x4 {Constraint 5] x ; = 1, if location j is selected 0, otherwise Set up the problem in Excel and find the optimal solution. What is the expected net present value of the optimal solution? Multiple Choice O 20 MacBook Pro 388 @ N 3 5 R U O P Q W E H K S D F G X C V N M Z B