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

The key stages in maintenance program in an organization, Question: (a)...

Question: (a) Many organizations consider the maintenance function as a critical operational and decision making area that can guarantee plant availability and reliability. A

Explain about value based management, Q. Explain about Value based manageme...

Q. Explain about Value based management? Value based management (VBM) is an approach which focuses on strategies and actions to create more value for shareholders.  Value being

Essence of management, Do a complete budget for the company you explained i...

Do a complete budget for the company you explained in the Business Plan. You will have to display the profit and loss account, Balance Sheet along with discussions on the budget as

Evolution and revolution in Hi-Fi sector, 1. Identify and discuss strategic...

1. Identify and discuss strategic capabilities (resources and competences) of the chosen company using appropriate strategy tools and identify strengths and weaknesses for the firm

Stakeholders, Ask What advantages are there to employees as stakeholders ar...

Ask What advantages are there to employees as stakeholders are available in Germany that are not provided to employees in US companies? In the United States, how do employees let

In a cost/benefit analysis, Payback period = total cost of investment / est...

Payback period = total cost of investment / estimated annual revenue

Groups and teams, groups and or teams will solve effectiveness and efficien...

groups and or teams will solve effectiveness and efficiency in 21st organisations.discuss

Benefits of implementing an ebusiness strategy, Question: (a). What...

Question: (a). What are the benefits of implementing an eBusiness Strategy at Delta Airlines? (b). Identify the different virtual market places in the case study. (c

Three ways of sustaining competitive , Three ways of sustaining competitive...

Three ways of sustaining competitive benefit are? Ans) differentiation, Price-based strategies and lock-in

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

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