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

Illustrate about value for money framework, Q. Illustrate about Value for m...

Q. Illustrate about Value for money framework? The value for money (VFM) framework (the 3Es)  Economy (Cheap) e.g. is the organisation procuring resources at the lowe

Illustration of brand orientated divisional structure, Q. Illustration of b...

Q. Illustration of brand orientated divisional structure? The Whitbread Group Plc, have several independent divisions or SBUs managing its popular brands of   hotels, restauran

Beyond budgeting, A philosophy that believes traditional or conventional bu...

A philosophy that believes traditional or conventional budgeting methods are of little use to management, however beyond budgeting does not believe that budgeting within organisati

Evaluating published research, Choose an academic article and produce an ac...

Choose an academic article and produce an academic review in which you analyse, criticise, and reflect on the paper, of no more than 1200 words. The summary should include some def

Caselet, caselet in strategic management :National Competitive Advantage of...

caselet in strategic management :National Competitive Advantage of IKEA Group, a Swedish company founded in 1943 with its headquarters in Denmark, is a multinational operator of a

What do you understand by the term cultural web, Question 1: (a) What d...

Question 1: (a) What do you understand by the term "cultural web" as referred to organisations? (b) Apply the cultural web concept to Toyota. Discuss whether the cultural we

Explain different levels of strategy, J plc manufactures a range of cars. T...

J plc manufactures a range of cars. The company is structured on a divisional basis with each division having responsibility for a segment of the market. One of the divisions manuf

Technology can drive substitution of products or services by, A) Producing ...

A) Producing new and better products or services B) Substitution of require by a related product or service C) Displacing consumer spending into latest unrelated products and

Ideal mission statement of a business organisation, Question: a) (i) H...

Question: a) (i) How many components are there in an ideal mission statement of a business organisation? (ii) Name these components? b) Using the above named component

Establish long-term objectives with strategy process, Establish long-term o...

Establish long-term objectives Live Business News investigated that ‘The market researchers AC Nielsen expect that Aldi will expand its branch network in the few urban centers

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