Hi Harlan - O/H in question is just one of a number of subset O/Hs that make up
COGS, though I didn't have the issue you highlighted with y. Happy to take it
offline so you can see what's going on if you were interested, but I can't
really post any more on this in here for obvious reasons. I do have a formulaic
method of achieving the desired output that one of our mathematicians came up
with, but the model is a historical one from before my time with a s%$t load of
sheets and dependencies across multiple years and escalation rates etc, that to
be perfectly honest, given that an iterative approach works, I just never really
had the incentive to try and fix the damn thing properly. Was just always
easier to set iterations on and use the circ :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Harlan Grove" wrote in message
...
"Ken Wright" wrote...
Yep. We have the same issue at work, where one of our overheads on a certain
type of contract is a % of the Sell Price, hence a circular reference when
dealing with spreadsheet versions of that particular pricing model. . . .

If Overhead is x% of SellPrice, is the problem that SellPrice is a function of
cost of goods and services sold + overhead + profit, so that Overhead and
SellPrice appear to be functions of each other? If so, and if profit is y% of
SellPrice (just to add another complication), then

SellPrice = COG&SS / [100% - x% -y%]

Overhead = x% * COG&SS / [100% - x% -y%]

Profit = y% * COG&SS / [100% - x% -y%]

--
To top-post is human, to bottom-post and snip is sublime.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 04/03/2004