View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Bundy John Bundy is offline
external usenet poster
 
Posts: 125
Default Breakeven/ Math Question....

There are a lot of variables that go into profitability by percent of sales,
the main being profit margin, you would need to A. have only one item B. do
an average or C. Do a calculation for each sale, but this can all be done,
just need to know how you calculate

-John

"JEFF" wrote:

I know how to determine breakeven, and I know how to solve for a targeted
profit level. What I can't get my head around is how I solve for a targeted
profitability in terms of a percentage of sales........... I can provide an
example, but in the meantime, I thought maybe someone else has been down this
road.

TIA!