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 1: a. List out Dr. Edward Deming's contribution to Quality. b. Show the eight dimensions of Quality. Dr. Edward Deming's contribution to Quality. Eight dimen

Assume a city of 1 million people, 75% of who are willing to pay $1 maximum (each) to clean up pollution. The rest of the population is willing to pay $100 each to clean up polluti

do all organisations need strategic plans

compensation strategy template

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

Material Facts: The defendant's son held an "open invitation" party at  his  parent's home.  Guests, to include minors, were  encouraged  to  "bring their own  bottle." The p

Q. Explain Dimensional performance matrix? The 6-dimensional performance matrix Similar to the balanced scorecard, Fitzgerald (1991) created a 6 dimensional performance m


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

Q. What do you mean by Dividend cover? Dividend cover  Dividend cover   =   Profit available to ordinary shareholders (PAT) / Annual dividend (no. of times) Or = EPS/Divi