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

Show the demerits of using return on investment, Q. Show the Demerits of us...

Q. Show the Demerits of using return on investment? The following disadvantages maybe experienced when choosing to use ROI as a primary performance measure. -  An accounting

Briefly discuss the predictive maintenance strategy, Question: (a) The ...

Question: (a) The Bath-Tub curve is an important tool for understanding the reliability of engineering components in many different applications. It is viewed as a hazard funct

Describe the system development strategies, A customer has engaged your sof...

A customer has engaged your software development company to develop a new order-processing system. However, the time frames are very tight and inflexible for delivery of at least t

Dynamic performance management process, Q. Dynamic performance management p...

Q. Dynamic performance management process? The beyond budgeting approach should lead to  A more dynamic performance management process that will enable organisations

verify the manufacturer''s claim, A supplier of components to an electroni...

A supplier of components to an electronic industry makes a sophisticated product which sometimes fails immediately it is used. He controls his manufacturing process so that the pro

What are multinational corporations and enterprises, Question 1: (a) ...

Question 1: (a) What is "Globalisation"? Discuss its implications, positive or negative, with regards to our home island, Mauritius. (b) What are Multinational Corporat

Explain the portfolio approach to strategic analysis, Question 1 Explai...

Question 1 Explain the Portfolio Approach to Strategic Analysis and discuss its limitations. Question 2 Write short notes on each of the following (questions carry equa

Consolidation is concerned with, Protecting and strengthening the organizat...

Protecting and strengthening the organization's position in its present markets by its current products

How market has influenced the forms and content of the media, 1. The develo...

1. The development of the mass media has been shaped in fundamental ways by the fact that they have often been profit-driven. The commercial or capitalist context of media is evide

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

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