DO NOT COPY OTHERS ON CHEGG. READ QUESTION CAREFULLY. TABLE & #S DIFFERENT FROM OTHER CHEGGS

Fox Enterprises is considering six projects for possible construction over the next four years. The expected (present value) returns and cash outlays for the projects are given in the following table. Note that construction of Project 4 is conditional upon construction of Project 5. Also, at most four of the projects must be built. Cash outlay ($1000) Project Year 1 Year 2 Year 3 Year 4 Return ($1000) 1 10.5 14.4 2.2 3.4 322 2 8.3 12.6 9.5 2.1 359 3 10.2 14.2 5.6 4.1 179 4 7.2 9.1 7.5 5.1 145 01 12.3 10.1 8.3 6.2 187 6 9.2 8.8 6.7 5.2 126 60 70 35 20 Available funds ($1000) Formulate an integer programming model for this problem and determine the optimal project mix that maximizes the total return using Excel. In your report, please: Define decision variables clearly. Define objective function clearly and write its mathematical formula completely. Define constraints clearly and write their mathematical formula completely. Report the optimal values of decision variables and objective function value