Figuring out Gross sales with only net sales and percentage of discounts

jmorrell317

New member
Joined
Jan 17, 2018
Messages
1
1st post in a forum ever....my apologies if I make a noob error...

I'm trying to forecast business sales for the coming weeks. I'm restricted to forecasting NET sales, but my allowed labor is based off of GROSS sales.
Only knowing my NET sales values and my avg Discount percentage, how do I find my GROSS sales?

I've been using the following basic formulas but Im missing something.

Gross Sales - Discounts = Net Sales
Gross = Net + Disc
and
Disc/Gross = Percentage
so
D/G = P
D=PG
D=P(N+D)
D=PN+PD

I feel like I just keep moving variables around with no solution.
Is there a way to solve this?
If I do $15,000 in net sales and I have a 12% discount rate, what are my GROSS sales? 15000 x 1.12 is not correct
 
Gross Sales - Discounts = Net Sales
Disc/Gross = Percentage
If I do $15,000 in net sales and I have a 12% discount rate, what are my GROSS sales?

Based on the above:

N = G - D = G - G*P = G * (1-P)

G = N/(1-P)
 
Top