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

How is strategy to be implemented, QUESTION (a) What is strategy implem...

QUESTION (a) What is strategy implementation, and what problems may arise in implementing a strategic change? (b) Who implements strategy in the organisation and how can the

Animal processing, what is HACCP and benefits in food industry

what is HACCP and benefits in food industry

Statistics, #quesSome of its important characteristics are given below: St...

#quesSome of its important characteristics are given below: Statistics are aggregates of facts. Statistics are numerically expressed. Statistics are affected to a marked extent by

What is uncontrollable costs, Q. What is Uncontrollable costs ? Uncont...

Q. What is Uncontrollable costs ? Uncontrollable costs General apportioned fixed overhead e.g. group overhead allocated or apportioned to divisions, which would not b

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

What is competitor myopia, Instant competition blinds a company to latent c...

Instant competition blinds a company to latent competitors who can demolish the old ways of doing business.

Tools to influence social control, Tools to influence social control ...

Tools to influence social control Mission statements for example purpose and goals promoted. Reward for example linking remuneration with performance. Punishment

Dominant strategy combination, Janet decides to play a game with her childr...

Janet decides to play a game with her children, Jay and Jill (who are fraternal twins) and Mo. Each child is in their own room and cannot communicate with each other. Suppose Jill

Team development, 1.Describe the stages of team development 2 Justify how ...

1.Describe the stages of team development 2 Justify how to motivate team members to achieve given aim.

Cadbury dairy milk, Value proposition and product customer connect of cadbu...

Value proposition and product customer connect of cadbury dairy milk

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