Find the optimal solution, Strategic Management

Assignment Help:

- 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


Related Discussions:- Find the optimal solution

Show the 4c''s in performance measurement, Q. Neely's 4Cs in performance me...

Q. Neely's 4Cs in performance measurement 1.  Check position e.g. where are we now? 2.  Communicate position e.g. to internal and external stakeholders. 3.  Confirm pri

Evaluating published research, Choose an academic article and produce an ac...

Choose an academic article and produce an academic review in which you analyse, criticise, and reflect on the paper, of no more than 1200 words. The summary should include some def

To adapt to or deal with the impact of change forces, QUESTION (a) Orga...

QUESTION (a) Organisations are systems that exist in the context of an external environment, an interdependent relationship, interact with it in order to survive and grow. Any

Problems of profit based measures, Problems of profit based measures -...

Problems of profit based measures -  Absolute profit measures ignore the amount of investment in the division e.g. does not look at profit relative to capital employed. -

Establish long-term objectives with strategy process, Establish long-term o...

Establish long-term objectives Live Business News investigated that ‘The market researchers AC Nielsen expect that Aldi will expand its branch network in the few urban centers

Explain about financial analysis, Q. Explain about Financial analysis? ...

Q. Explain about Financial analysis? The objective of financial statements is to provide information to all users of accounts to help them for decision-making.  Note that most

Diffusion is, The amount and pace of market adoption.

The amount and pace of market adoption.

The strategies of the functional areas of an organisation, Discuss the ways...

Discuss the ways in which the strategies of the functional areas of an organisation should support the other levels of strategy. In describing how the functional strategies sup

Preliminary investigation - knowledge management technique, Tatra is the wo...

Tatra is the world's third oldest car company, and produced a number of rather advanced streamlined cars during the course of its production run. Because spare parts and manuals ar

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd