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
Strength: Arpanaa is the only vegetarian restaurant that offers good ambience and holistic experience for the people who visit the city. There is a free trip to the temples in

1 - Analyse the business factors that underpin the requirement for an e-strategy in an organisation. 2 - Talk about the benefits of e-commerce to an organisation.

Tasks: With your chosen scenario: o   Briefly describe the initial structure - set baseline o   Create a strategic project plan with: A strategic project analysis

Cham Stores is one of the biggest private sector employer in the Syria. The company has more than 2000 employees in Syria, Emirates and London. In Syria, Cham Stores range from sma

how might the principles of hyper competitive strategy b apllied to a fashion retailing industry


Q. International aspects to transfer pricing? The following issues can influence international transfer pricing decisions. Exchange rates e.g. fluctuations in global cur

Identify FIVE potential difficulties that might arise for an organisation following the introduction of a new system if support and training are inadequate. Inefficient operat

compensation strategy template

Times it consists concerned with the determination of the amount of time required to perform a unit of work. It consists of process of observing and recording the tim