- #1
AcousticBruce
- 37
- 0
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... ___$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?
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?