View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default sales needed to cover costs that increase as sales do

Hi,

did you try go seak?

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"donna-LexusWebs" escreveu:

Hello,
I'm trying to write a funcction that will calculate the amount of
incremental sales I would need to cover my costs if I were start paying a
sales commission.
Example:
If my original sales were 100,000
and I wanted to pay 3% commission, that would cost me:
75% of the sales (that is my cost of sale) PLUS the 3%. The problem is that
if I need to increase sales to cover the 3% commission, I have to pay the
cost of sales (75%) plus the commission on those sales and so on- and so-on.
It seems like a never ending loop. I can do a "solver" but I need a formula
to put into a spreadsheet to give to my sales team. It's more than breakeven
because of the incremental sales and costs associated with those additional
sales.

Any clues?!?! ANY input would be so appreciated!!