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

What are the four types of strategic control, QUESTION 1 The most impor...

QUESTION 1 The most important purpose of strategic control is to help Top Management achieve organizational goals through monitoring and evaluating the strategic management pro

Evaluate the organisation''s strategic planning processes, Undertake the fo...

Undertake the following tasks : 1. Develop a position paper for enhancing the organisation's strategic capability by influencing the strategy in action. 2. Evaluate the organ

Business strategy and operation strategy, what is the relationship between ...

what is the relationship between business strategy and operation strategy?

Distinguishes between deliberate and emergent strategies, 1 .Characterize t...

1 .Characterize the culture of the organization in which you work. How does this culture affect the work of middle managers? Have you experienced deliberate interventions by senior

Problems of pursuing only profit objectives, Q. Problems of pursuing only p...

Q. Problems of pursuing only profit objectives? - Conflict with other stakeholder goals for example customers will want a better service and not want to pay anymore, a better s

Show the merits of using return on investment, Q. Show the Merits of using ...

Q. Show the Merits of using return on investment? Merits of using return on investment (ROI) -  Relative (percentage) measure so performance can be compared 'relatively' f

Strategic planning, advantages and disadvantages of strategic planning

advantages and disadvantages of strategic planning

Ray''s satellite emporium, Ray's Satellite Emporium wishes to verify the be...

Ray's Satellite Emporium wishes to verify the best order size of their best selling satellite dish (model TS111).  Ray has estimated the yearly demand for this model at 1,000 units

Competitive strengths, a) Use appropriate tools to examine the  affects of ...

a) Use appropriate tools to examine the  affects of present business plans. b) Review the position of an organization in its present market. c) Measure the competitive strengths

Strategy and organization analysis, AThis assignment provides you the oppor...

AThis assignment provides you the opportunity to integrate the course concepts in a meaningful way to develop a set of recommendations for your organization of choice to become mor

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