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

Stakeholders in an organization, a) develop a schedule for executing a stra...

a) develop a schedule for executing a strategy plan in an organization. b) Make appropriate dissemination process to gain commitment from stakeholders in an organization. c) Desi

Who are burns and stalker, Q. Who are burns and stalker? Burns and Stal...

Q. Who are burns and stalker? Burns and Stalker in their 1961 book 'The Management of Innovation'explained two organisational types signifying a spectrum which organisations co

Evaluating published research, Choose an academic article and produce an ac...

Choose an academic article and produce an academic review in which you analyse, criticise, and reflect on the paper, of no more than 1200 words. The summary should include some def

External buying decisions, The group consolidated financial results would n...

The group consolidated financial results would normally be effected, if an internal buyer uses their autonomy and makes a decision to buy outside the group, rather than buy interna

Solve this question as soon as posibble, Tangy spices Ltd, the countries’ ...

Tangy spices Ltd, the countries’ biggest spices marketer has decided to launch a hostile bid for Italy’s major spice marketer Chilliano. This is a rare case of an Indian company ma

Dimensions of common national cultures, Hofstede's dimensions of common nat...

Hofstede's dimensions of common national cultures Power distance. Extent to that people accept inequality of power. Uncertainty avoidance. Tolerance for uncertainty o

What is the eva for this division, Division Y has annual operating profit o...

Division Y has annual operating profit of £40 million after charging £6 million for the development cost of a new product which has been launched and is expected to last this year

Evaluate total shareholder return, Q. Evaluate Total shareholder return? ...

Q. Evaluate Total shareholder return? Total shareholder return (TSR) TSR = {(Dividend per share + Growth in share price) / (Market share price at the start of the period)

Macroeconomic effects of crisis, Central banks had been supplying short-ter...

Central banks had been supplying short-term funding to smooth needed adjustments in the banking sector, but that alone could not stem bank losses. So what had been addressed as a l

Transport planning, Assume the population of Darwin in 50 yrs will be 2mill...

Assume the population of Darwin in 50 yrs will be 2million. There will be gas related industries in the surrounding areas of Darwin. Mining activities in the Northern Territory wil

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