Use the Table Below to Answer the Following Questions) by Invoking
Question 15
Question 15
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 amount of cash used for Project 2?
A) $ 105,000 B) $ 25,000 C) $ 115,000 D) $ 70,000
Correct Answer:
Verified
Unlock this answer now Get Access to more Verified Answers free of charge