Use the following spreadsheet to complete this project Project 1.1 - Project Selection Criteria.xlsx 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 interested 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. Project Attributes and Weights 10 8 5 Customer Relations New Products Supplier Relations Positive ROI Weighted Score 5 R2 2-1B ct e DTS GNK GNK-Series Power Droid-Also known as Gonks, these droids are essentially walking batteries. Programmed in simple Binary, they are cheap and easy to repair, making them popular with everyone from moisture farmers on Tatooine to Tie Mechanics on space stations. Cost of development: $15 billion Potential ROI: 205% Customer Relations: 6 New Products: 1 Supplier Relations: 10 Positive ROI: 10 DTS-Series Dismantler Droid-Just as the name suggests, these droids can take apart just about anything. They are cheap and easy to assemble, so they can be built in great quantities. Additionally, they can be programmed to attack incoming vessels, so are useful in battle. Cost of development: $30 billion Potential ROI: 25% Customer Relations: 2 New Products: 5 Supplier Relations: 3 Positive ROI: 2 2-1B Surgical Droid-Humanoid in appearance, all 2-1B series droids were equipped with encyclopedic memory banks. Their memory banks and modular limbs helped ensure that the droids gave the best course of medical treatment in any given medical situation. Cost of development: $95 billion Potential ROI: 85% Customer Relations: 6 New Products: 10 Supplier Relations: 5 Positive ROI: 3 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 Use the following spreadsheet to complete this project Project 1.1 - Project Selection Criteria.xlsx 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 interested 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. Project Attributes and Weights 10 8 5 Customer Relations New Products Supplier Relations Positive ROI Weighted Score 5 R2 2-1B ct e DTS GNK GNK-Series Power Droid-Also known as Gonks, these droids are essentially walking batteries. Programmed in simple Binary, they are cheap and easy to repair, making them popular with everyone from moisture farmers on Tatooine to Tie Mechanics on space stations. Cost of development: $15 billion Potential ROI: 205% Customer Relations: 6 New Products: 1 Supplier Relations: 10 Positive ROI: 10 DTS-Series Dismantler Droid-Just as the name suggests, these droids can take apart just about anything. They are cheap and easy to assemble, so they can be built in great quantities. Additionally, they can be programmed to attack incoming vessels, so are useful in battle. Cost of development: $30 billion Potential ROI: 25% Customer Relations: 2 New Products: 5 Supplier Relations: 3 Positive ROI: 2 2-1B Surgical Droid-Humanoid in appearance, all 2-1B series droids were equipped with encyclopedic memory banks. Their memory banks and modular limbs helped ensure that the droids gave the best course of medical treatment in any given medical situation. Cost of development: $95 billion Potential ROI: 85% Customer Relations: 6 New Products: 10 Supplier Relations: 5 Positive ROI: 3 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