Google Answers Logo
View Question
Q: Excel Solver for a Production system ( No Answer,   0 Comments )
Subject: Excel Solver for a Production system
Category: Computers > Algorithms
Asked by: gotquestion-ga
List Price: $75.00
Posted: 26 Jun 2006 11:13 PDT
Expires: 28 Jun 2006 08:54 PDT
Question ID: 741158
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.

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
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

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

There is no answer at this time.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy