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

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

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

Beyond budgeting approach, The beyond budgeting approach may include the fo...

The beyond budgeting approach may include the following: Use of rolling budgets concentrating on cash forecasts and not cost control. Budgets revised more frequently

Coherent strategy should have four important elements, QUESTION (a) Any ...

QUESTION (a) Any coherent strategy should have four important elements (Saloner al). Write short notes on each of the four elements (b) Modes of Strategic Management are the

Technical reference model, Describe the structure and role of the Tech...

Describe the structure and role of the Technical Reference Model (TRM) in the The Open Group Architecture Framework (TOGAF).  What is the purpose of this component?

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

Marketing strategy, Select an existing business that has recently launched ...

Select an existing business that has recently launched a new product. You may also use your own company. Consider how the organization's marketing strategy has benefited the new pr

Explain about residual income, Q. Explain about Residual income? Residu...

Q. Explain about Residual income? Residual income is profit earned by a division less a "notional interest charge" for investment of finance within it.

Mensa, Develop a five-year strategic plan with cost estimates and a time li...

Develop a five-year strategic plan with cost estimates and a time line. It should be 5-7 double-spaced, typed (12 point) pages plus exhibits. Your plan should include/address the f

Costco''s case, what makes costco''s a distnghished and well reputed retai...

what makes costco''s a distnghished and well reputed retail brand?

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