A hospital is evaluating the feasibility of offerings among three technologies, on the basis of what would make the most profit. These new technologies are:
1. Closed - chest cardiac bypass surgery with "daVinci Surgical Robot "
2. Gamma knife
3. Positron emission tomography (PET) scanner
Table EX 10.4gives the information on profit, the amount of common resources used by each of the three technologies per case, and their available resources per month:
a. Formulate this as a linear programming problem.
b. Solve the problem using Excel solver.
c. Based on optimal solution, which product(s) should be offered, and how many procedures can be offered in a month?
d. What is the expected contribution of new technology to the hospital's monthly profits?