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

Characteristics of organic verses mechanistic organisations, Characteristic...

Characteristics of 'organic' verses 'mechanistic' organisations   Organic Mechanistic Management Style Partici

How is strategy to be implemented, QUESTION (a) What is strategy implem...

QUESTION (a) What is strategy implementation, and what problems may arise in implementing a strategic change? (b) Who implements strategy in the organisation and how can the

Heterogeneous catalysis simulator, 1. Run the Heterogeneous Catalysis simul...

1. Run the Heterogeneous Catalysis simulator for different initial conditions (initial partial pressures of species A, B, C, and D) to get the reaction rates; 2. Study the influ

Describe the administration controls, Administration controls are performan...

Administration controls are performance measurement systems e.g. Management accounting 'exceptionreporting' systems which compare actual performance to a predetermined target, goal

Strategic management of bread talk, This report discusses is based on the s...

This report discusses is based on the strategic management of Bread Talk. Bread Talk is, a Singapore based fFood cCompany . It is identified that under strategic management, The co

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

Find the optimal solution, - Middle-East Incorporated (MEINC) Oil blends ga...

- 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 on

Illustration of extrinsic reward, Q. Illustration of extrinsic reward? ...

Q. Illustration of extrinsic reward? Monetary reward is an illustration of extrinsic reward and considered as the most important of all 'hygiene factors' according to Frederick

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