Exhibit 6.1 The Following Questions Pertain to the Problem, Formulation, and Spreadsheet

Essay

Exhibit 6.1
The following questions pertain to the problem, formulation, and spreadsheet implementation below.
A research director must pick a subset of research projects to fund over the next five years. He has five candidate projects, not all of which cover the entire five-year period. Although the director has limited funds in each of the next five years, he can carry over unspent research funds into the next year. Additionally, up to $30K can be carried out of the five-year planning period. The following table summarizes the projects and budget available to the research director. The following is the ILP formulation and a spreadsheet model for the problem.
-Refer to Exhibit 6.1. What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet?
​
Objective Cell:
​
Variables Cells:
​
Constraints Cells: