Hello,
I need a formula where I can say to Excel in a cell I want a profit of $2 for example and it'll calculate the item price I need to set to the product.
Thank you all in advance!
Dan.
Hello,
I need a formula where I can say to Excel in a cell I want a profit of $2 for example and it'll calculate the item price I need to set to the product.
Thank you all in advance!
Dan.
So, you have a buy price in A1 and you want to make a profit of $2 when on-selling.
The formula will be your buy price plus the $2 profit.
=A1+2
cheers
Just add cost price to profit for selling price.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
If you'd like to use percentages instead try these formulas:
Mark up formula:
Selling Price=Cost+(Cost multiplied by Percent of Profit)Please Login or Register to view this content.
Example;
Cost-----% of profit-----Selling Price
$800.00----10.00%-------$880.00
Or
A mark up which gives profit on the sale price formula:
Selling price=Cost divided by (100% minus Percent of profit)Please Login or Register to view this content.
Example:
Cost------% of profit-----Selling Price
$800.00-----10.00%------$888.89
Last edited by spreadcore; 06-06-2010 at 01:14 PM.
Excellent, I thought it'll be much complicated than this. But I forget to tell you that my selling price is based on a fee calculated by a percentage of the selling price, I sell on Ebay, so now it's giving me a circular reference warning. So the selling price needs to be my buy cost + shipping cost + eBay fee + $2 profit for example. Any idea?
Thanks!!!
Just have a column for each component, then in E
SUM(A1:D1)
Yes, the thing is that one of the columns, where the fee is, is calculated on the item price. So I need it's to insert item cost + shipping cost and margin for example $2, then the excel should calculate the item price based on item cost + shipping cost + margin + fee. Do I'm clear?
Last edited by teylyn; 06-16-2010 at 05:50 AM. Reason: removed spurious quote
You haven't provided enough information for anyone to help. What's the fee schedule?
Entia non sunt multiplicanda sine necessitate
Sorry. The fee is the eBay fees, I already have them calculated, this is ok. The fee is based on the item price. Let's say the price it's $100, the fee is for example 10%. I have a column that calculate it based on the price. What I need it's just to add the profit I want and it'll give me the price. What I do now it's to enter manually the price. Thanks a lot.
Last edited by teylyn; 06-16-2010 at 05:50 AM. Reason: removed spurious quote
The fee is based on the price, the price is based on the fee. No one can help you compute the PRICE without knowing the fee SCHEDULE.
This is one of the formulas, it's depend on the category you sell.
=ROUND(E2*2%+MIN(E2,1000)*(5%-2%)+MIN(E2,50)*(8%-5%),2)
E2 it's the price.
Last edited by teylyn; 06-16-2010 at 05:50 AM. Reason: removed spurious quote
If P is the profit percentage (e.g., 0.2, or 20%), then the formula for sell price is
=Cost / (1-P) / (1- SUMPRODUCT( (Cost / (1-P)>{0,50,1000}) * (Cost / (1-P)-{0,50,1000} ) * {8,-3,-3}/100) / Cost * (1-P) )
For example,
It's inexact because of the sliding scale.Please Login or Register to view this content.
Last edited by shg; 06-11-2010 at 07:07 PM.
Many thanks. I'm not sure if I insert right the formula but I'm getting a negative number for the sell price. What I'm doing wrong? I attached the excel. Thanks a lot!
Last edited by teylyn; 06-16-2010 at 05:51 AM. Reason: removed spurious quote
dandi, please stop quoting whole posts. It's just clutter.
Sorry, now I just saw the reply icon, I'm new on forums..
Profit is a percentage of revenue, which means it ranges from 0 to 0.999... Try setting it to 20%If P is the profit percentage (e.g., 0.2, or 20%), then the formula for sell price is ...
Done, thanks. Working with a percentage it's fine. How can I set a profit of $2?. Can I?
Enter the profit amount someplace, compute the percentage profit, and then use the percentage in the formula:
p% = 2 / (10 + 2) = 16.7%
Thanks. I'm getting better but is not showing me the correct amount, I assume I'm doing something wrong...This is what I did:
=A2 / (1-C2) / (1- SUMPRODUCT( (A2 / (1-C2)>{0,50,1000}) * (A2 / (1-C2)-{0,50,1000} ) * {8,-3,-3}/100) / A2 * (1-C2) )
A2= cost.
C2= profit percentage I want.
I need to add an additional to the original formula and I try to add it to yours without success. The final formula I have it's the following:
=ROUND(E8*2%+MIN(E8,1000)*(5%-2%)+MIN(E8,50)*(8%-5%),2)+(E8*3.4%)+0.3+0.05+(E8*0.9%)
E8 it's the sale price. In other words. I need to add to the fee (3.4% +0.3 + 0.05) + (0.9%).
Thanks a lot! I much appreciate your help.
Help please .
Hi All!
I need your help regarding this issue. I uploaded a file I did, it's working fine, but I'm missing the most important thing that will help me to make this more automatically when adding a lot of SKU's. I need to reverse profit. In the file you can see 2 spreadsheets, one for eBay and one for Amazon. In every category I sell I pay different fees. I have inserted comments on every sell to indicate what is. For every category the fees are correct, I just want to insert in the "profit I want" cell the amount I want have after all the fees.
Many thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks