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

question 25

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 formulas should go in cells D8:H8 and D11:H11 of the above Excel spreadsheet?

---

Definitions:

Mood Disorders

A category of mental disorders involving persistent disturbances in mood or emotional state, such as depression or bipolar disorder.

Genetic Basis

The role that genes play in determining physical and behavioral traits that are inherited from one generation to the next.

Major Depressive Disorder

A mental health disorder characterized by persistently depressed mood or loss of interest in activities, causing significant impairment in daily life.

Attention Deficit

A developmental disorder characterized by difficulties focusing, hyperactivity, and impulsive behavior, often referred to as Attention Deficit Hyperactivity Disorder (ADHD).