Using Excel and upload the work (screenshot)! Thanks!

Portfolio Selection

As a manager of the Information Technology organization, you need to select the best projects from the following eight project proposals.Your budget for new projects is only $2.2M and you have available 10 System Architects and 12 Software Engineers in your team. Please show your work to receive credit.

Success Initial System Software Project Revenue Rate Investment Architect Engineer A $1,500,000 80% $700,000 2 2 B $2,350,000 20% $350,000 2 2 C $1,250,000 40% $250,000 3 1 D $750,000 90% $500,000 1 2 m $800,000 70% $400,000 4 3 $550,000 80% $250,000 2 1 G $700,000 50% $225,000 2 H $450,000 90% $300,000 1 3