Find the optimal solution, Strategic Management

Assignment Help:

- 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


Related Discussions:- Find the optimal solution

Determine best strategy, The number of households in a certain community is...

The number of households in a certain community is given by h(t) = 1:26t 2 +7800 households t years after 2001. The proportion (expressed as a decimal) of the households in this s

Strategic position analysis, The assignment for the module is an individual...

The assignment for the module is an individual report which contributes 25% of the module total mark. You should conduct a Strategic Position Analysis (Situation Analysis) on an or

Impact of environmental factors, Political Factors Political stability o...

Political Factors Political stability of parties and their actions like granting etc might also influence the business expansion plans of Bread Talk up to lesser extent in Singa

Which of the following are recognized implementation methods, Trail and dis...

Trail and dissemination Parallel conversion Direct conversion Phased conversion

Business and corporate level strategy, Business-Level Strategy From the...

Business-Level Strategy From the outset, you were required to focus on the strategic business unit (SBU) to ensure that Business-level strategies could be applied. The challeng

Compensation, compensation strategy template

compensation strategy template

Sm0492 - strategy and change in the global environment, 1. Using Macro & M...

1. Using Macro & Micro frameworks analyse and evaluate the external environment of your organisation from the perspective of the external context within which it operates. Summar

Marketing plan, The market plan should be made based on a Hot Dog Vending C...

The market plan should be made based on a Hot Dog Vending Cart which is actually a hypothetical company I have created that operates in the US. Besides selling hot dogs, I would be

Divisional structures – product organisation, Q. Divisional structures – pr...

Q. Divisional structures – product organisation? The functional structure is normally adopted by an entrepreneurial structure e.g. small business, because the organisation grow

Importance of costs in the pricing strategy, Explain the importance of cost...

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

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd