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
Q. Explain about Financial analysis? The objective of financial statements is to provide information to all users of accounts to help them for decision-making.  Note that most

Q. Describe the Maximum transfer price? Normally the maximum transfer price a buyer would pay would be the market price it could obtain the raw material, component, service, pr

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

# 14 Strategy formulation presupposes a set of goals and objectives. Why aren''t goals and objectives obvious? What characteristics of people and organizations can make setting goa

Q. Show the example on residual income? Division A makes and sells a single product and is assessed by the residual income it earns, the head office of the group uses a 10% cos

Protecting and strengthening the organization's position in its present markets by its current products

Harriet's Fruit and Chocolate Company was established in 1935 in the Pacific Northwest of the United States to ship gift baskets of locally grown peaches and pears to customers in

Commence the knowledge audit by identifying the knowledge gaps and blockages in the organisation, as follows: a)  Consider each of the ten checklist issues listed, and assess fr