Question: Can someone please explain what Im inputting incorrectly to get these answers on Excel. I know my Max NPV should be 17500. Please use solver



Can someone please explain what Im inputting incorrectly to get these answers on Excel. I know my Max NPV should be 17500. Please use solver and show how and which formulas were inputted on Excel.
a. Develop and solve an integer programming model for maximizing the net present value. b. Assume that only one of the warehouse expansion projects can be implemented. Modify your model from part a. c. Suppose that if test marketing of the new product is carried out, the advertising campaign also must be conducted. Modify your formulation from part b to reflect this new situation. H3 Afx= SUMPRODUCT(\$\$\$\$9:\$G\$9,B6:G6) By Changing Variable Cells: Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP Options Simplex engine for linear Solver Problems, sory engine for Solver problems that are non- \{onalysis Tools Data Analysis Capital Funds Available Solver found a solution. All constraints and optimality Return to Solver Parameters Dialog \begin{tabular}{|l|} \hline Save Scenario... \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
