Problem 8-25 | Accounting homework help

Please Help I am having a difficult time understanding how to complete this in excel solver and have asked for a tutor but do not have one yet but still need to pass this homework assignment it is due tomorrow by midnight I am stuck.

I have attached screenshots of the problem