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
Benefits of using balanced scorecard (BSC) - BSC encourages a long-term view of improving performance through time. - BSC considers both non-financial as well as financial m

QUESTION 1 Individuals at all levels are prone to resisting change. What are the five main reasons why individuals resist change? QUESTION 2 Research has identified six

A transport company must collect and deliver loads from and to various locations along a straight road (call it the x -axis). The truck must start and end each day at the origin (t

Trail and dissemination Parallel conversion Direct conversion Phased conversion


advantages and disadvantages of strategic planning

how to write an assignment on market segmentaion

Q. Evaluating the performance of divisions? The controllability principle is concerned with assessing performance based upon measures that can be controlled only by a manager a

Fixing the Knowledge Gap: Planning  Now commence the 'Fixing knowledge gap' phase by identifying the broad nature of the solution required, as follows:  a)  Wherever you h

Q. Explain about Dividend yield ? Dividend yield     = (Dividend per share/Market share price) x 100% The dividend yield is the cash return on the share (not the whole retur