Hello, I am doing this Introduction to systems and technologies course and the assignment was on using "Solver in Excel" I have been trying this question for literally hours and I am so lost. I was wondering if you could please give me a detailed explanation in steps ( through screenshots on your end) of how to use it along with answering the question then I will try it on my own using your steps. My Professor gave us how it should be solved but it was not making sense, so I ask if you could try it and screenshots the steps you take.

Also, I am reposting this again as I want to make it clear that the top one (screenshot) is how my professor did it, could you try it on your own and screenshot the answers to me in I suppose different steps so I could follow along?

Fairways Woods Company Shipping Analysis After using Solver to get the solution, these cells (C6:G8) will contain numbers which would be different (in amount and cell location) from that shown. Also, Total (b6:b8) and Shipping (b19:g19) would also change because of the formulas in them. Fairways Woods Company Shipping Analysis