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

Prepare a short notes on normal distribution, Problem 1: a. Prepare a s...

Problem 1: a. Prepare a short notes on Normal distribution. b. The probability that an employee getting occupational disease is 20%. In a firm having five employees, what is th

Lukas manufacturing , Lukas Manufacturing is presently producing a tape hol...

Lukas Manufacturing is presently producing a tape holder that has a variable cost of $0.75 per unit and a selling price of $2.00 per unit.  Fixed costs are $20,000 a year.  Present

Briefly explain the it merger process, Question: (a) Company mergers a...

Question: (a) Company mergers are major change projects. Briefly explain the IT merger process involved. (b) A study showed that successful steering committees introduce a

Technical infrastructure , 1 -  Develop a plan for an e-strategy that  make...

1 -  Develop a plan for an e-strategy that  make sure  an organisation retains its competitive  benefit in a global market. 2 - Specify the technical infrastructure needed in an

Differences of eva and ri, Differences of EVA and RI EVA uses the r...

Differences of EVA and RI EVA uses the replacement not historical accounting cost of assets. Profit calculated under both methods are different e.g. with EVA the repla

Compensation, compensation strategy template

compensation strategy template

Influences on consumer behavior, Using online research and the resources on...

Using online research and the resources on the Student Portal: 1. Identify aspects of culture which may have an impact on the international marketing of your selected marketing

Global environment, what are the issues in a global environment

what are the issues in a global environment

Case study, Akash Engineering Ltd. (AEL) had achieved sales of Rs. 3440 lak...

Akash Engineering Ltd. (AEL) had achieved sales of Rs. 3440 lakhs during the year 2004-05 against sales of Rs. 1209 lakhs previous year. The sales this year were highest ever achie

A strategic vision is differ from a mission statement, A Strategic Vision i...

A Strategic Vision is Differ from a Mission Statement: Whereas the chief concern of a strategic vision is with "where we are going & why", a company's mission statement usua

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