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

Sanlam, write an essay of approximately 1500 words in which you critically ...

write an essay of approximately 1500 words in which you critically analyse and evaluate the value innovation strategy that sanlam opted for in their 2009 blue star financial advise

IP Phase V, How much does it cost to get someone to write phase V Individua...

How much does it cost to get someone to write phase V Individual project Strategic Human Capital Management

How cost-leadership make use of ict, Question 1: (a) Explain a framewor...

Question 1: (a) Explain a framework for a company to manage its application portfolio. (b) Apply the application portfolio concept to show the different applications for a

Dynamic performance management process, Q. Dynamic performance management p...

Q. Dynamic performance management process? The beyond budgeting approach should lead to  A more dynamic performance management process that will enable organisations

Effect of globalization in management of an organization, The following ess...

The following essay will discuss how the popular trend of globalization is affecting the communication style and management of an organization. There will be explanations provided

Managing strategy and change, Taking into account the industry dynamics and...

Taking into account the industry dynamics and characteristics of the automotive industry, discuss the rationale (reasons for)the collaborative partnership between Renault, Nissan a

Methods for evaluating the performance of divisions, Q. Methods for evaluat...

Q. Methods for evaluating the performance of divisions? Profit based methods for evaluating the performance of divisions Operating profit (net profit) margin  =

Prepare a complete training plan, The M.V Star of the orient is a 14,000 to...

The M.V Star of the orient is a 14,000 ton-cruise ship that was built in 1977. The ship is Greek-registered and Hong-Kong owned. The ship spent the ten years prior to 1989 cruising

Describe porters five forces model, Question 1: a. Define strategic man...

Question 1: a. Define strategic management and how it can be applied in an organisation. b. When a company needs to adapt to change, what are the key strategic management qu

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

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