Note: This Problem Requires Excel

Multiple Choice

Note: This problem requires Excel.
You have noticed that paying higher wages attracts more productive employees. However, you are concerned that there may be a limit to this relationship. Some experimentation has convinced you that the relationship between daily wages paid (x) and profits can be modelled by the equation Profit = 50x − 0.5x2 + .001x3 + 200. The range of wages you are willing to consider is from $0 to $500 per day. Use the Evolutionary Solver tool to determine the level of wages that will maximize profits.

A) 200
B) 300
C) 400
D) 500
E) Cannot be determined