JEFF wrote...
....
Net Sales 200,000 (or whatever)
Cost of Sales will always be 30% of Sales
Gross Margin = Sales - Cost of Sales
Operating Expenses fixed in this scenario
Income Before Taxes = Gross Margin - Operating Expenses

** Need to determine level of sales to realize an Income Before Tax of, say,
5%... Obviously, I could use Goal Seek, but really need it as a formula.

OK, the 5% means the ratio of income before taxes to net sales. So net
sales means total proceeds from sales less sales or excise taxes?

Anyway,

IBT = GM - OE

GM = NS - CoS

CoS = 0.3 * NS

so

GM = 0.7 * NS

IBT = 0.7 * NS - OE

Then

5% = 0.05 = IBT / NS = 0.7 - OE / NS

which rearranges to

NS = OE / 0.65

in this particular case. More generally, the formulas work out to

IBT = NS - CoS - OE

and profit margin is

IBT / NS = 1 - (CoS + OE) / NS

This may be solved for a target profit margin, TPM.

TPM = 1 - (CoS + OE) / NS

which rearranges to

NS = (CoS + OE) / (1 - TPM)