Cost & gross profit analysis using excel solver

How to maximize gross profit and minimize product costs using the excel solver. The template can be downloaded for free from http://www.agatebooksllc.com/index_files/Page556.htm