Note: This Problem Requires Excel

question 3

Multiple Choice

Note: This problem requires Excel.
The marketing department has determined that the relationship between marketing expenditures (x) and sales can be modelled by the equation Sales = 100x − x2 + 20. Use a Nonlinear Solver tool to determine the level of marketing expenditure that will maximize sales.

• A) 40
• B) 50
• C) 60
• D) 70
• E) 80

---

Definitions:

Creative Problem Solving

A method involving imagination and innovation to find solutions to complex issues.

Conflict Resolution

Conflict resolution involves strategies and processes aimed at resolving disputes and disagreements between parties.

Cooperativeness

The willingness to work together with others towards a common goal or interest.

Assertiveness

The trait of possessing confidence and self-assurance while avoiding aggressiveness.