Question: Return to the Direct Marketing 2 worksheet. Load the Solver add - in if it is not already loaded. Launch Solver and set the objective

Return to the Direct Marketing 2 worksheet. Load the Solver add-in if it is not already loaded.
Launch Solver and set the objective to calculate a net profit of $20,000.
Use Number of Ac's and Click Rate (B4:B5) as changing variable cells.
Set a constraint to ensure Number of Ads purchased is less than or equal to 40,000.
Set a constraint to ensure Click Rate is less than or equal to 7%.(Mac users should enter the value in decimal form. Example .07)
Solve the problem. Generate the Answer Report.
 Return to the Direct Marketing 2 worksheet. Load the Solver add-in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!