Question: PLEASE ANSWER BOTH QUESTIONS FULLY AND CORRECTLY!! THANK YOU!! Question 1 A project is made of 6 activities: Activity ABCDEF Duration (in days 14 9/2012

PLEASE ANSWER BOTH QUESTIONS FULLY AND CORRECTLY!! THANK YOU!!
Question 1 A project is made of 6 activities: Activity ABCDEF Duration (in days 14 9/2012 65 Predecessors --AABCDD Use Solver to find the project duration. Question 2 Bob is a manager for a company that is considering several projects for possible adoption. Bob has estimated the cost per year for each project and the value of each project using a project score; these cost estimates and scores are presented in the table below. Bob wants to select a project portfolio that maximizes the total score (the sum of project scores of all selected projects), subject to the budget constraints. Project Year Year Year Year Year Project score 1 2 3 45 Project A $ 40 $ 10 $ 20 $20 0.741 Project B $65 $ 36 $ 35 $ 25 $ 30 0.845 Project 18 $ 1 Project D $ 20 $ 10 $ 20 $ 20 0.507 Project $ 10 $ 25 $ 25 $ 25 0.775 Project F $ 50 $ 25 $ 25$ 25 - 0.755 Project G S5 10 $ 10 $ 10 0.258 Available funds S120 $ 60 $ 50 $ 55 $ 60 a. Given the above constraints, using Solver, which projects should Bob recommend for funding? b. Assume that Bob has the choice of delaying some of the projects as long as all selected projects would be completed within the five year timeframe. For example, the company can decide to start Project A in Year 2 (instead of Year 1) so it would end in Year 5 (instead of Year 4). Also, once a project starts, it cannot be further delayed *midstream' (for example, if Project C is delayed to start in Year 2, it will be finished in Year 4). Which projects should be selected now and should Bob recommend that any project(s) be delayed; and if so, which one(s)? You must use (only) one Solver run to find the answer. Hint: add more variables to represent the projects that are delayed. Remember that you cannot cxccute any of the projects more than once. That is, the company cannot, for example, choose "Project A starting in Year 1" and also "Project A starting in Year 2". It can only select one of those two options, if it chooses Project A at allStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
