Solver Slowdown

[glantern3601]

Hi,
I'm new to Solver and VBA, but so far I've been able to get everything working. However, some of the formulas I'm using cause a significant delay when I use Solver (macro'd to an ActiveX button) and I'm wondering if there's a better solution than what I'm using. Some of this will be vague, to protect company data...
I'm using Solver to calculate my highest acquisition price while still hitting a given annual return. I have a list of vendors with different fees, some of which have minimums: Vendor A charges 3% of the acquisition price, while Vendor B charges 2% or $2000, whichever is higher. The latter example is causing performance delays. For these, I've been using MAX(Price*.02, 2000) although I tried IF(Price*.02>2000, Price*.02, 2000) with no time gained. I select vendors from a dropdown, fees are added and I have the total purchase price in a separate cell, run that through a number of calculations, and I get my estimated return. So the setup is:

Purchase Price: D9

Total Purchase Price (w/fees): D8

Est Return: I18

The Solver constraints:

Purchase Price must be greater than Zero - somewhat extraneous

Purchase Price must be less than Resell Price - somewhat extraneous

Total Profit must exceed a given value

I'm happy to provide anything else needed, if anyone can think of a way to speed up the solutions for the variable-fee formulas. Thanks!

[Alf]

I would suggest you upload a file one could "play around with" to see if speed of solving time could be reduced.

Alf