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

What techniques would you use, Question 1: "Sometimes conflicts escalat...

Question 1: "Sometimes conflicts escalate, the atmosphere becomes charged with anger, frustration, resentment, mistrust, hostility, and a sense of futility....in such a confli

Managing value based management, Q. Managing value based management? ...

Q. Managing value based management? Strategic selection of projects that create high shareholder wealth. Resource allocation and funding should have a recognised oppor

Analyze and diagnose a current and significant organization, Option A. ...

Option A. Identify, analyze, and diagnose a current and significant organization problem or objective that directly involves any one or more of the following organizational be

Strategic cost management, Strategic Cost Management It is a managemen...

Strategic Cost Management It is a management philosophy pioneered by John Shank, in that decisions concerning specific cost drivers are made within the context of a company bu

GE matrix, Characteristics of each component of GE matrix

Characteristics of each component of GE matrix

Long-term strategic management, After reading through the articles provided...

After reading through the articles provided in your Assigned Reading and Research, Review one of the articles using the following format with the headings indicated in bold below:

Benefits of using balanced scorecard, Benefits of using balanced scorecard ...

Benefits of using balanced scorecard (BSC) - BSC encourages a long-term view of improving performance through time. - BSC considers both non-financial as well as financial m

Explain key principles of total productive maintenance, Question: (a) E...

Question: (a) Explain clearly how businesses may adopt key principles of Total Productive Maintenance in order to create a safe and productive environment. (b) Describe in d

Strategies and actions for objectives, Strategies and actions for objective...

Strategies and actions for objectives The list of strategies and actions for business objectives are as follows: The company will open the new fitness centre in Perth which

Activities in strategic management process, a) identify and explain the key...

a) identify and explain the key activities in the strategic management process. b) why do businesses need to go international .?

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