Use the “Solver” spreadsheet in your exam template as the nu…
Use the “Solver” spreadsheet in your exam template as the numbers below are already hardcoded in template. Your company is trying to choose the best combination of projects to undertake this year. The five possibilities are as follows: Investment Square Feet Employee Hours NPV Apple $ 42.00 8,000 1,090 $ 12.38 Bacardi $ 450.00 24,000 8,750 $ 88.94 Chicago $ 152.00 12,250 1,850 $ 23.82 Dannon $ 680.00 38,000 11,000 $ 129.50 Evanston $ 155.00 22,500 3,850 $ 43.25 You know that you are limited to the amount of capital, manufacturing space, and employee hours you have. Constraints Capital ($) $ 1,000.00 Square Feet 60,000 Employee Hours 16,000 Use Solver to find the optimal choice of projects. What is the NPV of the optimal choice of projects? (Format as $XXX.XX, example $28.58.) If solver does not work or you cannot set it up, manually try to choose optimal mix.