An engineering firm would like to increase its return on five potential new engineering and development projects, as shown in the accompanying project information and model, but the project manager knows that this will require more cash and/or personnel. Conduct a what-if analysis of the optimal solution as the cash limitation varies from $150,000 to $230,000 in increments of $20,000, and the personnel limitation varies from 12 to 16. Summarize the returns for these solutions in the form of a heat map. Identify the solutions that represent the lowest amount of resources required to achieve each distinct return value. Write a short memo to the project manager explaining the best options and trade-offs that must be made to increase the returns. Click the icon to view the project information and the model. .... Choose the heat map that correctly summarizes the returns for each solution. Click here to view heat map a. Click here to view heat map c. Click here to view heat map d. Click here to view heat map b. 0 Identify the solutions that represent the lowest amount of resources required to achieve each distinct return value. Complete the table below. Personnel Cash Requirement Lowest Return $ Second Lowest Return $ Third Highest Return DDDDD $ Second Highest Return $ Highest Return $ Which of the following best describes the best options and trade-offs that must be made to increase the returns? O A. In order to achieve a greater return, it is sometimes necessary to increase the cash requirement. However, to achieve the greatest returns, it is also necessary to increase the personnel requirement. O B. In order to achieve a greater return, it is sometimes necessary to increase the personnel requirement. However, to achieve the greatest return, only the cash requirement needs to be increased. C. In order to achieve a greater return, it is always necessary to increase the personnel requirement. However, to achieve the greatest returns, it is also necessary to increase the cash requirement. OD. In order to achieve a greater return, it is sometimes necessary to increase the cash requirement. However, to achieve the greatest return, only the personnel requirement needs to be increased. Heat map c $150,000 $170,000 $190,000 $210,000 $230,000 12 13 14 15 16 Print Done Engineering Project Data and Model A B C D E F G 1 Project 1 Project 2 Project 3 Project 4 Project 5 Available Resources 2 Expected Return (NPV) $180,000 220,000 $150,000 $140,000 $200,000 3 Cash Requirements $50,000 $78,000 $19,000 $44,000 $56,000 4 Personnel Requirements 5 3 2 5 3 5 6 Project Selection 0 0 0 0 0 Decisions 7 Return =SUMPRODUCT(B2:F2,B6:F6) 8 Cash Used =SUMPRODUCT(B3:F3,B6:F6) 9 Personnel Used =SUMPRODUCT(B4:F4,B6:F6) Note that the values in B6:F6 are binary variables, where each value will be 1 if the corresponding project is selected.