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
Whether an organization has the resources and competences to deliver a plan


During early 1981 People Express (PX) became one of the ?rst new entries into the deregulated interstate airline industry. PX's entry strategy was to offer a uniform low-price, no

1. What are the strengths and weaknesses of the mission statement? Which of these statements are effective guides to decision-making within an organization? Which, if any, of th

apply a five forces analysis how would you describe Genentech competitive position

TFX is a multinational company which manufactures and retails branded designer clothing with business units in a number of different countries globally. Up unless now, each of the

Question 1: a) What is Strategic Management? b) What are the three stages of Strategic Management? c) Why strategy implementation often is considered the most difficult

i want to know the BCG matrix of MCB bank pakistan?


Describe the structure and role of the Technical Reference Model (TRM) in the The Open Group Architecture Framework (TOGAF).  What is the purpose of this component?