Hi everyone,
I have small gift article business and all selling price are marked manually for that I have created sheet1 cost price range between in column A And B and selling Price in column C.
Every time when I receive invoice I look the cost of article and check the price range in column A And B to mark the corresponding selling price. Which is in the column C.
Sheet1
*
A
B
C
1
Cost Price in Between
Sale Price
2
0,00
0,30
0,60
3
0,31
0,60
1,10
4
0,61
0,90
1,70
5
0,91
1,20
2,20
6
1,21
1,50
2,70
7
1,51
1,80
3,30
8
1,81
2,10
3,80
9
2,11
2,40
4,40
10
2,41
2,70
4,90
11
2,71
3,00
5,40
12
3,01
3,30
6,00
To avoid looking each article cost price range in column A and C and finding selling price manually.
Can it is possible to work out selling price creating Sheet2 as shown below just inserting cost price in column A and finding corresponding selling price (from sheet1) in the column B.
Sheet2
*
A
B
1
Cost Price
Sale Price
2
0,99
2,20
3
1,29
2,70
4
1,82
3,80
5
0,95
?
6
2,90
?
7
3,20
?
8
0,69
?
9
2,35
?
10
2,99
?
11
0,89
?
12
1,49
?
Please help
Thanks And Regards,
Moti
Is there an excel formula that can calculate a proposed selling price by entering a desired profit margin percentage and knowing the cost of goods sold?
I know that gross profit is calcualted by subtracting the cost of goods sold from the selling price and that the gross profit margin is calculated by dividing gross profit by the selling price..but not coming up with a way to back out a selling price by just knowing the cost of goods sold and entering a desire gross profit margin?
I am hoping that someone can help me solve this problem. I am trying to determine that average selling price (ASP) by month when I have the following known:
1) Average Selling Price for the year (e.g. $5 for 2008 and $4.73 for 2009)
2) Total Revenue for the year (e.g. $20,000 for 2008 and $35,000 for 2009)
3) Total Units for the year (e.g. 4,000 for 2008 and 7,399 for 2009)
4) Monthly Units for each year
The assumption is that the ASP would decrease from $5 to $x (variable by month) to have an average selling price of $4.73 for the 2009 year.
Any assistance on how to calculate would be greatly appreciated.
I would like to calculate selling prices in different ways, based on a choice made by the user.
Choices would be as follows:
1. Fixed Profit Amount - eg.15
2. Cost Plus eg.10%
3. To give a fixed % profit based on selling price - eg.10%
The complication is that part of the cost of the sale is variable based on the selling price - eg. a sales commission.
I've attached a worksheet.
Would really appreciate any help with this conundrum!
I would like to be able to key in a total price which includes a 5% tax and a 15% gratuity, and shows the actual amounts for the tax, grat and the selling price
For instance
If the total sale including selling price, 5%tax and 15%grat = $1
5%tax would be $.05
15%Grat would be $.15
and actual sell price would be $.80
I tried to make a spreadsheet that I can type in an all-inclusive price and the calculations would break down the actual sell price amount, tax amount and grat. amount, but the numbers are not working properly for the 5%tax and 15%grat.
Could someone please have a look and tell me where I have gone wrong please?
Appreciate it!
Jim
To calculate ebay fees it is:
Up to $50 is 8%, $50 to $1000 its 8% on the first $50, 5% on the rest, over $1,000 is 8% on first $50, 5% on next $950, and 2% for the rest.
Then I get 5% off of that, and i calculate the paypal fees which is 1.9% and $0.30
That is my net cost. So I got that calculation down and created it in a userform to calculate for me I put in my price and it gives me what I net. I want to do the oposite now. I want to put in what I want to NET, I want it to reverse that calculation to tell me what price I need to put it up at.
This calculation exists, this website has the reverse feature http://www.rolbe.com/ebay.htm and there are many other sites and programs that can reverse calculate it. But I am writing my own custom userform that does it for me and I can't figure out the logic to do it backwards. Can anyone help me figure this out???
HI
I have a price list I use at work, and I always need to know the mark up for billing purposes. Is there a more accurate way of calculating this? I have to use a -1 to display the % correctly. I would have enclosed a snap shot of my screen I had at work today so show you the formula, but I can't find an icon to do that! Any advice is appreciated!
dar
Hi all,
I have a dilemma that I hope someone will be able to help me with.
I need to work out the % profit margin from two prices: a cost price and selling price. The other threads I found have just confused me.
I.e. 16.87 selling price (Ex VAT) and cost price 12.9, expressesed as a % profit. I have three colums:
Selling price ex VAT'
Cost price
Profit Margin (%)
Please can someone help?
Many thanks for any assistance.
Andy
Hello,
I am trying to figure out the formula for calculating retail price if I have the cost and margin (%)/
Example:
cost is $10.00 (known figure)
Markup is : 40% (known figure)
Retail should be: 16.66
Thanks JR
