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