Preliminary Work
Using Excel’s Solver
Design variable-C2 Objective function - E2
Pull down TOOL menu select Solver
Target Cell=objective function (E2) By Changing (design variables)C2 Choose Solve to start Solver
Solution: optimal velocity occurs when q = 79.3o choose ok