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

Methods for evaluating the performance of divisions, Q. Methods for evaluat...

Q. Methods for evaluating the performance of divisions? Profit based methods for evaluating the performance of divisions Operating profit (net profit) margin  =

Strategic management, explain strategy as an organisational process

explain strategy as an organisational process

Strategic position analysis, The assignment for the module is an individual...

The assignment for the module is an individual report which contributes 25% of the module total mark. You should conduct a Strategic Position Analysis (Situation Analysis) on an or

Determine best strategy, The number of households in a certain community is...

The number of households in a certain community is given by h(t) = 1:26t 2 +7800 households t years after 2001. The proportion (expressed as a decimal) of the households in this s

ReStrategic, Process design strategy define with example

Process design strategy define with example

Difference between symmetric and asymmetric encryption, (a) Illustrate the ...

(a) Illustrate the difference between symmetric and asymmetric encryption, listing an advantages and a disadvantage of each. (b) What functions should be given by a public key

What is organizational design, 1.Middle managers are often at the center of...

1.Middle managers are often at the center of efforts to develop tactical plans to implement established strategies. How are tactical plans typically established? What challenges co

Principles of total quality, There are three principles of total quality: c...

There are three principles of total quality: customer focus, continuous improvement, and teamwork. Using the South University online library, find three articles that describe curr

Assignment, Present a real life case study of the concept that you chose in...

Present a real life case study of the concept that you chose in Part One ‘in action’. You can use your own organisation or an organisation of your choice – we recommend you use an

Networks vary from joint ventures in that network, Are arrangements whereby...

Are arrangements whereby two or more companies work in collaboration without formal relationships, where there is mutual benefit in doing so

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