I have a Linear Prodction system consisting of 4 Sub-Systems. There is
an input, I and an Output O. Each subsystem attenuates/depreciates the
input to the subsystem by a certain percentage. A better explanation
is contained in the PDF document below.

www.123SupportU.com/BreakEven_Design.pdf

Requirements:
1. The final output should be an Excel spreadsheet that I can save as
an Excel template.
2. If I change 1 of the variables, the others should automatically be
calculates. I typically know the output revenue/unit and thus the BE
cost/unit).
3. I need to know which subsystem will change the output the most. In
other worders, if I focus on optimizing 1 subsytem, which one will
give me the best and most significant results (Sensitivity
analysis???).

---

Request for Question Clarification by tox-ga on 27 Jun 2006 03:02 PDT

Hi there,

I think if you provide a bit more detail, it would give us a better
understanding of what you need.  The current information seems either
incomplete or misleading since for the system to be linear, you cannot
multiply variables with each other which means that of the 6 variables
(I,O,E,F,G,H) five must be given (constant).  This basically reduces
the problem down to an elementary algebra equation with nothing to
analyze.

Cheers,
Tox-ga