Exhibit 61
the Following Questions Pertain to the Problem,formulation,and Spreadsheet Implementation

question 1

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.
Project Funds Required in $000s)Benefit
$\begin{array}{ccccccc}\text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\\hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\\hline\end{array}$
Budget $225K $60K $60K $50K $50K 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:

---

Definitions:

Genital Stimulation

The act of touching or applying pressure to the genital organs for sexual pleasure or arousal.

Phenotypically Normal

An individual whose physical appearance and characteristics match the typical range of variability for their species and gender.

Physical Maturity

The state at which an individual's physical body has reached full development, typically signaled by reproductive capability.

Sadomasochism

A sexual practice involving the receiving or inflicting of pain and humiliation.