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

Relative value of growth, does this concept fit in under the evaluation of ...

does this concept fit in under the evaluation of strategic options

How to get assignment service, Will you please mention me assignment help s...

Will you please mention me assignment help service about to?

GE Healthcare, 1. Determine two (2) specific ethical issues that General El...

1. Determine two (2) specific ethical issues that General Electric (GE) Healthcare faced when implementing its strategy to introduce low cost diagnostic equipment to developing cou

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

Evolution and revolution in Hi-Fi sector, 1. Identify and discuss strategic...

1. Identify and discuss strategic capabilities (resources and competences) of the chosen company using appropriate strategy tools and identify strengths and weaknesses for the firm

Free cash flows, Free cash flows can be arrived at by using the following c...

Free cash flows can be arrived at by using the following calculation Operating profit before interest and tax (PBIT) +                                              Depreciati

Process to implement balanced scorecard, Q. Process to implement balanced s...

Q. Process to implement balanced scorecard? 1. A clear vision of introduction of a BSC communicated and demonstration which senior management are committed to the idea. 2. E

Effect of support on negative affect, There is wide support from government...

There is wide support from government agencies for people to exercise and indeed take part in sport. For many sportspeople, however, injury plays a part in their day-to-day sportin

Show the activity based budgeting, Q. Show the Activity based budgeting? ...

Q. Show the Activity based budgeting? Activity based budgeting (ABB) uses cost  'drivers'  for  different  support  resources consumed e.g. machining, quality control or admini

Disadvantages of divisional structures, Q. Disadvantages of divisional stru...

Q. Disadvantages of divisional structures? - As the complexity and diversity of products and markets within the group increase, central coordination by a head office or holding

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