Use the Table Below to Answer the Following Questions) by Invoking
Question 30
Question 30
Multiple Choice
Use the table below to answer the following questions) by invoking the binary constraints on the variables using the standard Solver. Below is the spreadsheet for a project selection model: 1234567891011121314 A Project Selection Model Data Expected Return NPV) Cash requirements Personnel requirements Model Project selection decisions Cash Used Personnel Used Return B Project 1 $160,000$45,0007C Project 2 $200,000$70,0004D Project 3 $125,000$28,0002E Project 4 $150,000$52,0006F Project 5 $225,000$65,0004G Available Resources $175,00010 -What is the total amount of personnel used for all five projects?
A) 23 B) 17 C) 10 D) 4
Correct Answer:
Verified
Unlock this answer now Get Access to more Verified Answers free of charge