formula help

M

MarkT

I need help with a formula, I am hoping that someone else has done this, I
just can't seem to get it to work out for me.

I would like to calulate a selling price for an item with a cost of x, plus
two constant amounts, plus a minimum net profit on the item of 2% or .02x.

Is this possible to calculate?

Thanks,

Mark
 
G

Gary''s Student

Let's say the price is in A1, the first constant amount is in A2, the second
constant amount is in A3. Then

=1.02*A1+A2+A3 is what you would use for 2% profit on price and
=1.02*(A1+A2+A3) is what you would use for 2% profit on price plus constants
 
M

MarkT

Hi Gary,

The price is my unknown, that is what I would like the formula to find for
me, based on what I do have, which is the cost of the item, plus percentages
of the price. e.g.

Cost = X
Constant = C
Profit = .02X
O/h = .27X


the formula (in theory) would be X + C + .02X + .27X
 
T

TC

=SUM(((A1+A2)+(A1*A3)+(A1*A4))) See if this what you are looking for. A1 is
Cost, A2 is Constant, A3 is %, A4 is %.
 
M

MarkT

In your formula TC, you have the % based off of the cost of the item. What I
am looking for is % of the selling price, which is the unknown.

I don't think this can be done??
 
Top