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

What makes a strategy a winner, What Makes a Strategy a Winner? 1.   T...

What Makes a Strategy a Winner? 1.   Three questions are used to examine the merits of one strategy versus other & distinguish a winning strategy from a losing or mediocre str

Potential difficulties that might arise for an organisation, Identify FIVE ...

Identify FIVE potential difficulties that might arise for an organisation following the introduction of a new system if support and training are inadequate. Inefficient operat

SWOT, #quIf a SWOT analysis reveals that an objective is unattainable, apar...

#quIf a SWOT analysis reveals that an objective is unattainable, apart from changing the objective, what other changes might make the goal attainable? • Discuss the limitations of

Develop a strategy for an organisation, Design a comprehensive Change Manag...

Design a comprehensive Change Management Strategy for your organisation/division/unit and with that (strategy) make sure that organisational diagnosis/analysis are addressed and cr

Critically examine importance of organisational culture, Question 1: Di...

Question 1: Discuss the following business strategies giving examples, and elaborate under what circumstances these business strategies are applied. i) Forward integration

Discuss the organizational structure of a restaurant, Question 1: (i) ...

Question 1: (i) In food production, the success of the operation depends on the Executive Chef and his various heads of sections in the main kitchen. What are these sections

Portfolio analysis, In portfolio analysis, the business views its product l...

In portfolio analysis, the business views its product lines and business units as separate investments, each responsible for producing a positive return. These separate investments

Calculate the economic order quantity, (a) XUZ Company produces readymade ...

(a) XUZ Company produces readymade garments for men. The purchasing officer collects the following information:-               Annual demand for Jeans                      40,0

Briefly discuss the predictive maintenance strategy, Question: (a) The ...

Question: (a) The Bath-Tub curve is an important tool for understanding the reliability of engineering components in many different applications. It is viewed as a hazard funct

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