A B D E G H Problem #2 10 Points The Firm below has 10 NPV positive projects to choose from, but has a capital constraint of $2,500,000. Utilizing the solver function report the optimal combination of projects to accept. The Optimal Capital Budget Under Capital Rationing Project Cost NPV Include A $425,369 $84,334 B $257,892 $26,881 $96,879 $23,162 D $465,258 $82,598 E $32,698 $20,590 F $789,258 $90,404 $795,664 $18,163 $562,332 $97,682 11 $480,321 $52,063 $626,589 $53,911 3 Total 4 Constraint $2,500,000 25 Note: The Solver, using the default options, will not correctly solve this problem. This is due to the defaults that ignore integer constraints and the too high tolerance setting of 5%. To correct the problem, click the Options button in the Solver dialog box and uncheck the Ignore Integer Constraints box and set Integer Optimality (%) to 0. The latter is the convergence tolerance setting