- #1

- 37

- 0

## Main Question or Discussion Point

I made this excel file that is basically a calculator. It needs to create a Total price after fees, profit and supplier cost. Most profit margin calculators have you add a percentage for profit... this is not what I want. I have a hard dollar amount.

You must know that the entire transaction includes supplier cost, profit and fee. The fee is charged from the total of the Transaction. I do not want to brute force until I find a total price that equals 5 bucks in profit.

For instance...

Supplier Cost : $50

Profit I want to make : $5

10% Transaction Fee : ?

Total to charge : Some unknown without brute force.

Currently you put the Supplier cost and a GUESS of the Total price. And keep adjusting while watching your profit until it gets to $5 bucks.

So here is an example....

Enter Supplier cost..... ___

Enter Profit to make.... ___

With this info I need it to spit out the total to charge so that the money left in the account is enough to

*pay supplier

*Pay transaction fee

*And exact profit of $5 is what is left.

In this case...

*Fee is: $6.11

*Total price is $61.11

Customer is charged 61.11 and we pay a transaction fee and a profit. It should zero out.

Does this make sense?

You must know that the entire transaction includes supplier cost, profit and fee. The fee is charged from the total of the Transaction. I do not want to brute force until I find a total price that equals 5 bucks in profit.

For instance...

Supplier Cost : $50

Profit I want to make : $5

10% Transaction Fee : ?

Total to charge : Some unknown without brute force.

Currently you put the Supplier cost and a GUESS of the Total price. And keep adjusting while watching your profit until it gets to $5 bucks.

So here is an example....

Enter Supplier cost..... ___

__$50_____Enter Profit to make.... ___

__$5______With this info I need it to spit out the total to charge so that the money left in the account is enough to

*pay supplier

*Pay transaction fee

*And exact profit of $5 is what is left.

In this case...

*Fee is: $6.11

*Total price is $61.11

Customer is charged 61.11 and we pay a transaction fee and a profit. It should zero out.

Does this make sense?