Help in Calculating Percentage based on $$$

[AudriGib11]

I have the following:

Discount = 0.4
Actual Cost = $24.96
List Price - $70.53
Price w/ Discount - 28.21
Sell % after discount - 12%

OK - what I need to know is how much do I need to increase my List Price to make sure that my Selling % after discount is 20%

Dont know if this is possible and I have about 500 that I need to figure out! PLEASE HELP!!!!

 

[Scott R]

Try this:

Book2
	A	B	C	D
1	BEFORE
2	Discount	0.4
3	ActualCost	$24.96
4	ListPrice	$70.53
5	Pricew/Discount	$28.21
6	Sell%afterDiscount	12%
7
8	TargetSell%	20%
9	NewListPrice	$78.00
10
11	AFTER
12	Discount	0.4
13	ActualCost	$24.96
14	ListPrice	$78.00
15	Pricew/Discount	$31.20
16	Sell%afterDiscount	20%
Sheet1

List Price = Cost / ((1-target sell %)*Discount)

 

[ken2step]

Multiply all your actual costs by 3.125 and you'll get 20% net if you discount that price by 40%

 

[Ron Morris]

Hi Audri,

Take your cost and divide by .8 (or 20% margin).

That will get you your new discounted sell price. Take this discounted price and divide by .4 to get your new list price.

Ron

 

[AudriGib11]

SCOTT R - YOU ARE A TRUE TRUE TRUE HERO!!!!! You must give me your address so that I can send you a THANK YOU!!!!!!!!

This worked and saved me life!!!!!!! I spent 4 hours trying to figure this out and you did it in 2 min - AWESOME!!!!!!!!!