View Question
Q: Excel Solver for a Production system ( No Answer,   0 Comments )
 Question
 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. 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```