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) Explain clearly how businesses may adopt key principles of Total Productive Maintenance in order to create a safe and productive environment. (b) Describe in d

#quesSome of its important characteristics are given below: Statistics are aggregates of facts. Statistics are numerically expressed. Statistics are affected to a marked extent by

Option A. Identify, analyze, and diagnose a current and significant organization problem or objective that directly involves any one or more of the following organizational be

QUESTION 1 The most important purpose of strategic control is to help Top Management achieve organizational goals through monitoring and evaluating the strategic management pro


Q. What is Uncontrollable costs ? Uncontrollable costs General apportioned fixed overhead e.g. group overhead allocated or apportioned to divisions, which would not b

Division X has a target return on investment (ROI) of 12%.  It has fixed costs of £400,000 and a variable cost per unit of £5.  The net assets of the division forecast for the next

Craft a mission statement for agro based organization which makes it eligible for expansion

Q. Illustrate about Value for money framework? The value for money (VFM) framework (the 3Es)  Economy (Cheap) e.g. is the organisation procuring resources at the lowe

The following details are available for company Z  · Share price at the beginning of the year £3.87 Share price at the end of the year £4.23 Dividend proposed and pa