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

Professional strategies to increase personal networking, Cham Stores is one...

Cham Stores is one of the biggest private sector employer in the Syria. The company has more than 2000 employees in Syria, Emirates and London. In Syria, Cham Stores range from sma

Management decision - making case problem, Louise Nance had working on the ...

Louise Nance had working on the assembly line of the Jackson Manufacturing Company for about six months. During recent weeks, her supervisor, Ben Miller, noticed that her productio

Global environment, what are the issues in a global environment

what are the issues in a global environment

Explain different aspects of term organisation culture, Question 1: (i)...

Question 1: (i) Explain the different aspects of the term ‘Organisation Culture'? (ii) Examine critically and discuss the importance of Organisational Culture in the imple

Discuss the main categories of the matrix, Question: (a) ‘Many organi...

Question: (a) ‘Many organisations are using the internet a tool for survival. Digital firms require new organisational designs and management processes'. Explain how the Por

Strategic plan, do all organisations need strategic plan/ and what are the ...

do all organisations need strategic plan/ and what are the characteristics of good strategic plan

What does process of crafting and executing strategy entail, What Does Proc...

What Does Process of Crafting & Executing Strategy Entail? 1.   Crafting & executing a company's strategy is a five-stage managerial process: (a). Developing a strategic vi

Explain porter''s five forces analysis of the beer industry, Question 1: ...

Question 1: Mauritian sugar companies decide to go and invest in sugar cane farming and sugar production in an African country. What sort of study must they carry out on the co

Explain the function of the group, a.     Explain the function of the group...

a.     Explain the function of the group. b.     For each group, describe the following: 1)     How it came into being. 2)     How long it has existed (and is expected to

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