# Solver or not Solver

M

#### Marilyn

Hello
I use "solver " to calculate a formula. I need to send the woorkshet to
different people and they will have to use solver. Here are some of the
problems. Some of the users do not have the solver add in- ,some have excel
2000, some excel 2002 and others excel 2003. Is there a formula that I can

C

#### Chip Pearson

It depends entirely on what you are using Solver to solve. It may
well be possible to write the workbook such that Solver is not
required, but that depends on what is being calculated and what that
calculation depends on.

Much more detail is required.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

L

#### Luke M

Probably, but you would need to provide an example of what you're trying to
solve for us to give you a formula.

M

#### Marilyn

Great thanks
Here is a sample - below is the orginal
price Qty discount Selling price
1,000.00 1,000.00
250 1 2% 245.00
450 1 2% 441.00
75 2 2% 147.00
600 1 2% 588.00
200 1 5% 190.00
700 1 10% 630.00
650 2 40% 784.08
4,025.08
after using solver this is my answer

3,925.00 3500
price Qty discount Selling price
1,000.00 1,000.00
250 1 7% 233.56
450 1 10% 403.92
75 2 5% 142.88
600 1 13% 522.08
200 1 9% 182.68
700 1 23% 540.27
650 2 63% 474.62
3,500.00
Explanation
3,925 is the price of the component
3500 is what the customer is willing to pay.
first item for 1,000 cannot be discounted
so I want to apply a discount that would equal the total amount the
customer wants to spend

D

#### Dana DeLouis

Hi. From what I see, there are no constraints on the discounts, so
there are an infinite number of ways to allocate your discounts.
How about a constant discount rate?

1000 + 2925*d = 3500

or stated maybe as (1-0.85470085) = 0.14529915