ISE 5970 Project Management Methods Homework 1 You have been asked to analyze your organizations project portfolio opportunities, which are shown in Table 1. There are data for the next three years, with the value of each project and the cost. Projects can only be run in the year indicated. For example, Project 5 can only be undertaken in Year 2. All projects require investment in the same year that they pay off, so you dont have to include the time effects of money. (Discounting would affect the value of the portfolio but would not affect which projects are optimal in each year. For this problem, ignore the time value of money effects for totals across years.) Each of the three years your organization has a budget of $12,000 (in then current dollars in each year no discounting should be applied). You have been asked to identify which projects should be selected in each of the three years to maximize the portfolio value while staying within the annual budgets. The Excel file PMM HW 1.xlsx has the data shown in Table 1. Table 1. Project Data. You should turn in an Excel file that uses these data to determine the best selection of projects. You should add text to your Excel file, so your answers are quickly communicated. In other words, dont just solve the problem, but make clear to anyone who opens the file what your answers are. If you use Solver, and I would, leave the Solver parameters in your file so I can see what you did. There is a brief discussion of Solver in Lecture 5.6 in case you are not familiar with it. An example of one way to summarize you answer is shown in Table 2. Table 2. Example of one way to communicate results. Project ID Project Value Project Cost Year 1 Project x 12 4 Project y 17 8 Year 1 Totals 29 12 Etc. ... ... ... Grand Total 84 32

ISE 5970 Project Management Methods Homework 1 You have been asked to analyze your organization's project portfolio opportunities, which are shown in Table 1. There are data for the next three years, with the value of each project and the cost. Projects can only be run in the year indicated. For example, Project 5 can only be undertaken in Year 2. All projects require investment in the same year that they pay off, so you don't have to include the time effects of money. (Discounting would affect the value of the portfolio but would not affect which projects are optimal in each year. For this problem, ignore the time value of money effects for totals across years.) Each of the three years your organization has a budget of $12,000 (in then current dollars in each year no discounting should be applied). You have been asked to identify which projects should be selected in each of the three years to maximize the portfolio value while staying within the annual budgets. The Excel file PMM HW 1.xlsx has the data shown in Table 1. You should turn in an Excel file that uses these data to determine the best selection of projects. You should add text to your Excel file, so your answers are quickly communicated. In other words, don't just solve the problem, but make clear to anyone who opens the file what your answers are. If you use Solver, and I would, leave the Solver parameters in your file so I can see what you did. There is a brief discussion of Solver in Lecture 5.6 in case you are not familiar with it. An example of one way to summarize you answer is shown in Table 2