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

Genentech after the acquisition by Roche, apply a five forces analysis how ...

apply a five forces analysis how would you describe Genentech competitive position

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

Preliminary investigation - knowledge management technique, Tatra is the wo...

Tatra is the world's third oldest car company, and produced a number of rather advanced streamlined cars during the course of its production run. Because spare parts and manuals ar

What are the six steps in strategic planning, Question: (a) Explain, w...

Question: (a) Explain, with an example of your choice, why providing more resources on a project does not always lead to completion of the work earlier than scheduled or getti

Zachman framework, Discuss the following quotation and please provide ...

Discuss the following quotation and please provide examples. "Enterprise Architecture frameworks such as the Zachman Framework are essentially conceptual skeletons tha

Describes a business model , Product flows,  information flows, service flo...

Product flows,  information flows, service flows participants' roles

Business strategy and operation strategy, what is the relationship between ...

what is the relationship between business strategy and operation strategy?

Quantitative analysis, how has quantitative analysis changed the current sc...

how has quantitative analysis changed the current scenario in the management world today?

Threat in swot analysis , Threat: Arpanaa has very few competitors who are...

Threat: Arpanaa has very few competitors who are sprouting slowly and hence it is very important to keep the services updated based on the latest technology according to the needs

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