Need a formula to calculate sales with only GP$ & GP%

[mf1]

Hello,

I require a formula to calculate sales with only GP$ and GP% as known inputs.

Sales = ?
COGS = ?
GP$ = $15,644
GP% = 49.4%

Your help would be appreciated.

Thanks,

mf1

 

[Eloise T]

You need the formula in Excel or you need a formula (period)?

 

[mf1]

Ideally in Excel Eloise, as I need to calculate a set of data with no sales or COGs, however have the GP$ & GP%.

 

[Eloise T]

I am not an accountant, but does this make sense up to this point?

Sales = GP$ / GP% ?

If so, Excel formula: =SUM(15644 / .494)

Sales = $31,668.02.

 

[mf1]

Your a legend Eloise, works perfect. I owe you a drink

 

[Eloise T]

Glad it was that simple. Maybe someday ...for a drink.
So where does COGS fit in?

 

[mf1]

COGS (cost of goods sold) is used to calculate stockturn & sales to stock ratio.

Once I have sales I can calculate COGS (Retail - COGS = GP$) or if I had COGS and GP$, I could calculate sales.

So your answer was perfect, as I had a tight deadline and was thinking why didn't I try that!

If ever you are in Melbourne, message me

Thanks again Eloise.

 

[Eloise T]

Melbourne, Sydney, and New Zealand are on my bucket list...and closer to home, Hawaii and Alaska.

Oh, and glad you made your deadline. BTW, how did you happen to find Chandoo.org? You've been a member for a long time.