Reverse Gross Margin

nightster

New Member
Joined
Mar 30, 2017
Messages
29
Hello,

I would LOVE some help with this one if anyone can please...I would be most grateful!

So...

I have a product and it has two costs: the cost of the physical goods themselves and then the cost of advertising, which is a cost-per-acquisition, or CPA.

I also know that I want to make a 25% Gross Margin.

So, how can I work out what the maximum CPA is in order to get the 25% GM?

As an example...

I have a widget which costs me £10 to buy
I then need to advertise that widget to sell it, which is the cost-per-acquisition. < this is the unknown value
I want to make a 25% Gross Margin on this sale.

How would I would out what the maximum CPA needs to be in order to get a gross margin of 25%?

THANK YOU in advance!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
You haven't supplied enough information to solve the probelm. I believe that Gross margin = (Revenue -Costs)/Revenue
You haven't told us what price you are selling your widgets for or what percentage markup on the physical cost you are using.
 
Last edited:
Upvote 0
You haven't supplied enough information to solve the probelm. I believe that Gross margin = (Revenue -Costs)/Revenue
You haven't told us what price you are selling your widgets for or what percentage markup on the physical cost you are using.

Apologies!

In this example, let's say I am selling the widget for £100.

The percentage markup isn't required I don't think?

So....

Cost of goods = £10
Selling price = £100
Gross margin required is 25%

How do I work out how much I have available for advertising/acquiring the sale?

THANKS!
 
Upvote 0
Starting from:Gross margin = (Revenue -Costs)/Revenue
Gross Margin= (Price - (Cost+CPA))/Price
Gross Margin * Price= Price - (Cost + CPA)
(Gross Margin * Price)- Price= - (Cost + CPa)
Price - (Gross Margin*Price =Cost + CpA
( 1 - Gross Margin ) * Price= Cost + CPa
((1 - Gross Margin)* Price)-Cost=CPA
So using this formula with the number you have given
((1 - 0.25)*100 - 10 = CPA =65
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top