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
Tasks: With your chosen scenario: o   Briefly describe the initial structure - set baseline o   Create a strategic project plan with: A strategic project analysis

Items purchased from a vender cost $20 every, and the forecast for the next year's require is 1,000 units.  The cost of placing an order is estimated to be $5 each time an order is

Q. Explain Performance ratios - Return on capital employed? Return on capital employed (ROCE)    = (Profit before interest and tax (PBIT) / Capital employed) x 100%     The

A fence enclosure consists of a rectangle of length L and width 2 R , and a semicircle of radius R , as shown in Figure 1. The enclosure is to be built to have an area of 1600 m

targeting strtegics with live examples

Alfred Rappaport's definition of shareholder wealth (value)  Shareholder value = corporate (business) value - Debt The corporate value represents the perpetuity of cash

how has quantitative analysis changed the current scenario in the management world today?

Question 1: (a) What is "Globalisation"? Discuss its implications, positive or negative, with regards to our home island, Mauritius. (b) What are Multinational Corporat

What can middle managers do to moderate the distortions introduced by such biases?

Janet decides to play a game with her children, Jay and Jill (who are fraternal twins) and Mo. Each child is in their own room and cannot communicate with each other. Suppose Jill