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

Question

Quizplus · Accepted Answer

The Answer of 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

Note: This Problem Requires Excel