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 Strategic Management is currently the core of business policy discipline everywhere (a) Define Strategic Management (b) Write short notes on the four important

You are Pam, Vice President of Marketing for Superior Products, Inc. You joined the company two months ago, replacing an individual who hadbeen the VP of Marketing for the comp

EIGHT STAGE PROCESS

Ansoff Growth Matrix The Ansoff Growth matrix is a framework that helps firms to decide their product and market growth strategy . Market penetration In market penetration

Explain the importance of costs in the pricing strategy of your chosen organisation. Importance of Cost Cost is more important than ever before, especially in the current e

targeting strtegics with live examples

1. Unions quite frequently oppose the time study because the accuracy of time study is overly dependent upon the skill and judgment of the time study man. The time

Question: (a). With the help of appropriate examples of your choice explain the different types of personalisation systems? (b). Distinguish between the micropayments and

Discuss the following quotation and please provide examples. Enterprise Architecture is an organising logic for managing change within an Information Systems environ

Question: (a) Firms are always looking to outperform each other; three generic strategies have been identified to allow them not only to attain advantages over competitors b