please show all work/process in excel. will upvote once both a&b are solved. thank you in advance!

QEaton Medical Services is evaluating 10 independent indivisible projects, all with positive NPV. The company's capital budgeting for the year is limited to a maximum of $5,000,000 Use solver to find the optimum combination of projects the company should accept, under the assumption that A and B are mutually exclusive and one of them has to be selected (b)lgnore the constraint from previous part, assume that project "T" has to be accepted. Use solver to find optimum combination of projects the company should accept now + Project A B C D E A Cost NPV 1,061,191 122,737 561,758 58,102 1,647,849 280,660 1,026,020 89,365 191,870 17,568 1,333,625 76,960 3,102,642 123,240 275,568 79,367 2,044,070 60,506 1,017,567 56,690 F G H I J