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

Contrasting strategic planning to strategic control, Contrasting strategic ...

Contrasting strategic planning to strategic control Strategic planning is a more centralised planning approach, senior management tend to focus less on implementing specific c

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

Benefits of implementing an ebusiness strategy, Question: (a). What...

Question: (a). What are the benefits of implementing an eBusiness Strategy at Delta Airlines? (b). Identify the different virtual market places in the case study. (c

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

Fixing the knowledge gap, Fixing the Knowledge Gap: Planning  Now com...

Fixing the Knowledge Gap: Planning  Now commence the 'Fixing knowledge gap' phase by identifying the broad nature of the solution required, as follows:  a)  Wherever you h

Show the dimensions of culture, Q. Show the dimensions of culture ? Di...

Q. Show the dimensions of culture ? Dimensions of culture can help management determine  Leadership style e.g. if 'high power distance' then autocratic management exp

Effect of globalization in management of an organization, The following ess...

The following essay will discuss how the popular trend of globalization is affecting the communication style and management of an organization. There will be explanations provided

Make a list of business goals, Harriet's Fruit and Chocolate Company was es...

Harriet's Fruit and Chocolate Company was established in 1935 in the Pacific Northwest of the United States to ship gift baskets of locally grown peaches and pears to customers in

Execution schedule for an organisation''s e-strategy, 1 - Assess the resour...

1 - Assess the resource needs for executing an e-strategy in an organisation. 2 - Develop an execution schedule for an organisation's e-strategy. 3 - Assess how existing busi

Strategic analysis, conduct a strategic analysis, and write a report on a r...

conduct a strategic analysis, and write a report on a real-life business (MYER) . This report will focus on business-level strategy.

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