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
Q. Show the behavioural aspects when implementing budgets? The following behavioural aspects could arise when implementing budgets -  Budgets seen as a 'penny pinching' e

Q. What is Transfer Pricing? A transfer price is a price charged for goods or services provided internally between divisions or departments in the same group or company.   Tran

In portfolio analysis, the business views its product lines and business units as separate investments, each responsible for producing a positive return. These separate investments

Critically analyse and review the leadership capabilities of an actual leader-either someone you know or an historical or current leader and clearly identify and link those attribu

Consider a community dining style restaurant such as Benihana of Tokyo. Assumptions are as follows: When you admit a customer to the bar, the customer is assured a seat in th

Q. What do you mean by Controllable costs? Controllable costs Divisional variable (marginal) cost. Divisional 'specific' fixed cost e.g. Specifically incurred by

Q. Managing value based management? Strategic selection of projects that create high shareholder wealth. Resource allocation and funding should have a recognised oppor

1. Unions quite frequently oppose the time study because the accuracy of time study is overly dependent upon the skill and judgment of the time study man. The time

a) Use appropriate tools to examine the  affects of present business plans. b) Review the position of an organization in its present market. c) Measure the competitive strengths

Payback period = total cost of investment / estimated annual revenue