Find the optimal solution, Strategic Management

- 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

Posted Date: 3/13/2013 2:08:00 AM | Location : United States







Related Discussions:- Find the optimal solution, Assignment Help, Ask Question on Find the optimal solution, Get Answer, Expert's Help, Find the optimal solution Discussions

Write discussion on Find the optimal solution
Your posts are moderated
Related Questions
Question: (a) Company mergers are major change projects. Briefly explain the IT merger process involved. (b) A study showed that successful steering committees introduce a

Q. Show the Budgetary planning ? A budget is a forecast and quantified plan of action. Budgetary planning creates a budget like a part of the planning process for the organisat

Question: (a) The Bath-Tub curve is an important tool for understanding the reliability of engineering components in many different applications. It is viewed as a hazard funct

1. Describe the brand you will establish across as many dimensions as you think are relevant 2. What will your brand association be?  i.e.  what is the one thing, above al

Goold and Campbell identified three 'styles of strategic management', looking at ways in which control can be divided between senior management and individual business units.

Q. International aspects to transfer pricing? The following issues can influence international transfer pricing decisions. Exchange rates e.g. fluctuations in global cur

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

Q. Managing value based management? Strategic selection of projects that create high shareholder wealth. Resource allocation and funding should have a recognised oppor

Question: (a) Briefly discuss the following Maintenance practices and list some of the techniques used to implement these practices in the work environment (i) Predictive

what is HACCP and benefits in food industry