Find the optimal solution, Strategic Management

- Middle-East Incorporated (MEINC) Oil blends gasoline from the following components: Domestic Blend, Foreign Blend Source 1, Foreign Blend Source 2, and an Octane Additive used only in premium gasoline.

- The Foreign Blend Source 1 and Source 2 are transported in the 8,000,000-gallon storage of a large tanker. The tanker has a complex system of small storage compartments allowing any division between source 1 and source 2 of the total capacity.

1. Make a "logical model"

2. Make an "algebraic model"

3. Make a "spreadsheet model"(1page=attached sensitivity report also!!!(2007version please!!!) 

A. Clearly define and label all of the variables

B. Do not hard wire parameter values into formulas. Store them in separate cells to facilitate documentation and analysis.

C. Use formatting options of excel to highlight and indent headings and all labels to improve the appearance of the model.

4. Use the excel solver to find the optimal solution

Posted Date: 3/13/2013 2:08:00 AM | Location : United States







Related Discussions:- Find the optimal solution, Assignment Help, Ask Question on Find the optimal solution, Get Answer, Expert's Help, Find the optimal solution Discussions

Write discussion on Find the optimal solution
Your posts are moderated
Related Questions
Finding trends and connections in data to inform competitive strategy

Ask question #Minimum 100 words accepted What is the value of studying the humanities in a business or technical curriculum? How might a topic such as ancient art enhance contempor

advantages and disadvantages of strategic planning

Q. Feed-forward control - prevention rather than cure? Feed-forward control would be a system that in a pre-emptive way, reacts to changes in its environment, normally to maint

Banking Systems Fraud and Technology Approach It is my intention to use the Banking Systems in Nigeria for this case study. I have observed that the process of banking operat

For your first assignment you described the recent macro and micro scale developments of the sector you are or would like to be in.  Now select a prominent company (it can be eithe

Question 1: a. List out Dr. Edward Deming's contribution to Quality. b. Show the eight dimensions of Quality. Dr. Edward Deming's contribution to Quality. Eight dimen

Have you ever been involved in an effort to introduce a new product, service or technology in an organization? If so, share your experiences with the class. Provide the class wi

(a) Illustrate the difference between symmetric and asymmetric encryption, listing an advantages and a disadvantage of each. (b) What functions should be given by a public key

A customer has engaged your software development company to develop a new order-processing system. However, the time frames are very tight and inflexible for delivery of at least t