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
What are Woo''s challenges in February 2011?

SWOT ANLAYSIS : The swot analysis of hotel arpanaa reveals interesting information about the features and services that are offered by the hotel along with the upcoming opport

Employee behavioural controls  'Influencing the process of how staff work and behave'. Reward e.g. based on attitude or behaviour Dress code e.g. to ensure staff u

Product and experience analysis: The product under research is Hotel Arpanaa, a holistic hotel located at Tiruvanamalai, India. It is a holitel that offers holistic experience

a) Use appropriate tools to examine the  affects of present business plans. b) Review the position of an organization in its present market. c) Measure the competitive strengths

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

What Does Process of Crafting & Executing Strategy Entail? 1.   Crafting & executing a company's strategy is a five-stage managerial process: (a). Developing a strategic vi

Question 1: Read the article in the assigned Reading, “Management: A Journey in Progress.” Which do you think are the most enduring management principles and management responsibil

Do a complete budget for the company you explained in the Business Plan. You will have to display the profit and loss account, Balance Sheet along with discussions on the budget as

A supplier of components to an electronic industry makes a sophisticated product which sometimes fails immediately it is used. He controls his manufacturing process so that the pro