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

Blue ocean starategy, Ask quest''Blue Ocean Strategy’ a. What is it? b. Wh...

Ask quest''Blue Ocean Strategy’ a. What is it? b. What are its characteristics? c. If you were to develop a Blue Ocean Strategy for a firm of your choice (any industry, any size,

Competitive benefit based on differentiation derives from, Offering product...

Offering products or services which offer dissimilar advantages from competitors' and which are valued by purchasers.

Limitations of using balanced scorecard, Q. Limitations of using balanced s...

Q. Limitations of using balanced scorecard? - Historical performance analysis is no guide to the future. - Manipulation or 'massaging' of performance measures by management,

Strategic issues for global market-maximize sales ratio, (1.) Infosys follo...

(1.) Infosys follows a global delivery model that enables the company to maintain standards. The vertical differentiation strategy did help the company to gain control over the ope

Discuss whittington''s four generic approaches to strategy, Question 1: ...

Question 1: What is strategy? Discuss Whittington's four generic approaches to strategy. Which approach would be most suitable to Toyota? Question 2: Research has shown

Assignment, how much assignment cost if maximum 3000 world

how much assignment cost if maximum 3000 world

Describe chargeback, A process in the industry where a wholesaler requests ...

A process in the industry where a wholesaler requests an amount that is the difference among the manufacturer's price to the wholesaler and the contract price to the resale custome

Effect of support on negative affect, There is wide support from government...

There is wide support from government agencies for people to exercise and indeed take part in sport. For many sportspeople, however, injury plays a part in their day-to-day sportin

Aim of a transfer pricing system, Q. Aim of a transfer pricing system? ...

Q. Aim of a transfer pricing system? Aim of a transfer pricing system could be tax avoidance Different countries have varying tax rates.  A multi-national company can set up su

Why a gis implementation might fail, What are the three important reasons w...

What are the three important reasons why a GIS implementation might fail, according to Eason (1994)?   Ans) Organizational mismatch Non-usability User acceptability

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