PLEASE HELP ME ASAP AND SHOW HOW YOU GOT STEPS AND COMPLETE QUESTIONS THANK YOU

estions 1. Develop and solve a Binary Integer Programming model for maximizing the net present value. [30] 2. What is the net present value at the optimal solution? [5] 3. Parameters, Decision Variables, Objective function should be neatly positioned and colored in the excel model. Constraints should be appropriately specified in the excel model. [10] 4. Create a new sheet and label it as "Question 4" and then copy the above model into the new sheet. Assume that Fleet Expansion and Equipment Upgrade must be undertaken. Modify your model to incorporate this condition. What is the modified net present value at the optimal solution? [5] pany is considering investing in several projects that have varying capital the most profitable projects that it can afford. The estimated net present value for each project, the capital requirements, and the available capital over the four-year period are shown in the in the table below. Capital Requirements (\$)