I need an Excel expert

I need to use optimisation processes to minimise costs. I have my excel spreadsheet that I can send over with the table already set up and question attached with all information. I cannot use the Solver correctly and am struggling to get the correct results.