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

question 59

Short Answer

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 formula should go in cell D15 of the above Excel spreadsheet?

---

Definitions:

Bromination

A chemical reaction involving the addition or substitution of bromine to an organic compound, often used in synthesis.

Mononitration

The chemical process of introducing one nitro group (-NO2) to a molecule, commonly used in the synthesis of explosives and various organic compounds.

Major Organic Product

The main product produced in the greatest amount when organic compounds undergo a chemical reaction.

Major Organic Product

The primary product formed in greater yield during an organic chemical reaction.