I attached the homework problem, a template to put the answers, a pdf files that are used to answer the problem question. The question asks to use Excel which mean you have to use Evolutionary solver to solve the problem. I attached the excel file that applies Solver.