Old MathJax webview

Old MathJax webview

please please solve this perfectly and urgently. please highlight the given answers. I will give positive rating if solve correctly and solve all parts perfectly

.

Homework: Assignment 7 Save Score: 0 of 17 pts 5 of 6 (1 complete) HW Score: 7.65%, 7 65 of 100 pts 15.3.29 Question Help 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 PE! Click the icon to view the project information and the model 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 S S Third Highest Return Second Highest Return Highest Return $ S che lo Engineering Project Data and Model Available Resources ans A B. D E Project 1 Project 2 Project 3 Project 4 Project 5 Expected Return (NPV) $180,000 220.000 $150,000 $140,000 $200,000 3 Cash Requirements $55,000 $83,000 $24,000 $49.000 $61,000 4 Personnel Requirements 5 3 2 5 3 5 6 Project Selection Decisions 0 0 0 0 0 7 Return 8 Cash Used 9 Personnel Used Note that the values in B6: F6 are binary variables, where each value will be 1 if the corresponding project is selected, =SUMPRODUCT(B2:F2.86:F6) =SUMPRODUCT(B3:F3,B6:F6) =SUMPRODUCT(B4:F4,B6:F6) es est nes Rel Print Done Homework: Assignment 7 Save Score: 0 of 17 pts 5 of 6 (1 complete) HW Score: 7.65%, 7 65 of 100 pts 15.3.29 Question Help 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 PE! Click the icon to view the project information and the model 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 S S Third Highest Return Second Highest Return Highest Return $ S che lo Engineering Project Data and Model Available Resources ans A B. D E Project 1 Project 2 Project 3 Project 4 Project 5 Expected Return (NPV) $180,000 220.000 $150,000 $140,000 $200,000 3 Cash Requirements $55,000 $83,000 $24,000 $49.000 $61,000 4 Personnel Requirements 5 3 2 5 3 5 6 Project Selection Decisions 0 0 0 0 0 7 Return 8 Cash Used 9 Personnel Used Note that the values in B6: F6 are binary variables, where each value will be 1 if the corresponding project is selected, =SUMPRODUCT(B2:F2.86:F6) =SUMPRODUCT(B3:F3,B6:F6) =SUMPRODUCT(B4:F4,B6:F6) es est nes Rel Print Done