Project Selection Matrix Project Attributes and Weights 10 5 Customer Relations New Products Supplier Relations Positive ROI Weighted Score 8 R2 2-1B Project Name DTS GNK Deliverables: 1. Use the attached Excel Spreadsheet to complete. 2. Once the spreadsheet is complete write a one page executive summary detailing which project/s you have selected to complete 3. Upload your Excel spreadsheet and one page executive summary to Canvas to receive credit Project 1.1 Industrial Automation of Corellia is intested in developing a new line of droids. However, with the Imperial Senate in disarray, IAC has to make decisions as to which droid best suits its needs. They have asked you, as a newly minted project manager, to make the decision for them. You only have $100 billion to invest in these projects, so choose wisely. Below are the selection criteria for each project along with the scores for each criterion and the costs of each project. R2-Series Astromech-This droid is an all-purpose unit that can be programmed to fill a variety of roles. They are approximately 3 feet high and weigh just under 1,500 pounds. Cost of development: $80 billion Potential ROI: 185% Customer Relations: 7 New Products: 5 Supplier Relations: 3 Positive ROI: 4 Project Selection Matrix Project Attributes and Weights 10 5 Customer Relations New Products Supplier Relations Positive ROI Weighted Score 8 R2 2-1B Project Name DTS GNK Deliverables: 1. Use the attached Excel Spreadsheet to complete. 2. Once the spreadsheet is complete write a one page executive summary detailing which project/s you have selected to complete 3. Upload your Excel spreadsheet and one page executive summary to Canvas to receive credit Project 1.1 Industrial Automation of Corellia is intested in developing a new line of droids. However, with the Imperial Senate in disarray, IAC has to make decisions as to which droid best suits its needs. They have asked you, as a newly minted project manager, to make the decision for them. You only have $100 billion to invest in these projects, so choose wisely. Below are the selection criteria for each project along with the scores for each criterion and the costs of each project. R2-Series Astromech-This droid is an all-purpose unit that can be programmed to fill a variety of roles. They are approximately 3 feet high and weigh just under 1,500 pounds. Cost of development: $80 billion Potential ROI: 185% Customer Relations: 7 New Products: 5 Supplier Relations: 3 Positive ROI: 4