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

A Strategic Vision is Differ from a Mission Statement: Whereas the chief concern of a strategic vision is with "where we are going & why", a company's mission statement usua


Particularly complex for weakly positioned companies

Q. Evaluate the Dividend yield? Creating shareholder value  Dividend yield Dividend yield     = (Dividend per share / Market share price) x 100% The dividend yiel

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

I need a five year plan with cost estimates and a time line also net present values at 10% discount rate

Four perspectives of the balanced scorecard Customer perspective e.g. what should we do right for our customers and what do they value? Internal perspective e.g. what

Q. Examples of external failure cost The customer perspective can control performance by the assessment of external quality failure.  Costs incurred after the customer has rec

Select an existing business that has recently launched a new product. You may also use your own company. Consider how the organization's marketing strategy has benefited the new pr