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

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

Strategic Planning and Organizational Development fo, Question 1: Read the ...

Question 1: Read the article in the assigned Reading, “Management: A Journey in Progress.” Which do you think are the most enduring management principles and management responsibil

Discuss the pertinence and relevance of the ansoff matrix, Question 1: ...

Question 1: (i) Why should stategic issues involve all stakeholders for a product or/and service? (ii) What are the objectives of strategic formulation and implementation

Difference between symmetric and asymmetric encryption, (a) Illustrate the ...

(a) Illustrate the difference between symmetric and asymmetric encryption, listing an advantages and a disadvantage of each. (b) What functions should be given by a public key

Global environment, what are the issues in a global environment

what are the issues in a global environment

Future organisation strategy, The company is now aggressively working towar...

The company is now aggressively working towards being the largest retail chain in the country and also being first in profitability.  At the same time the company is exploring maki

Strategic managerial communications, The objective of the term project is t...

The objective of the term project is to demonstrate your understanding and ability to apply the body of knowledge covered in this course. The goal will be on identifying communicat

Show the budgetary planning, Q. Show the Budgetary planning ? A budget ...

Q. Show the Budgetary planning ? A budget is a forecast and quantified plan of action. Budgetary planning creates a budget like a part of the planning process for the organisat

strategic intent, Pick a firm, discuss the effectiveness of current strate...

Pick a firm, discuss the effectiveness of current strategy and make a recommendations regarding a more viable strategy and rational for that Choice. Background to the firm It''s cu

Investment planning, Using examples, explain the differences between the pr...

Using examples, explain the differences between the primary and secondary markets for securities. Question Discuss systemic risk and any effects that it might have on investo

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