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

Knowledge audit, Commence the knowledge audit by identifying the knowledge ...

Commence the knowledge audit by identifying the knowledge gaps and blockages in the organisation, as follows: a)  Consider each of the ten checklist issues listed, and assess fr

Beyond budgeting, A philosophy that believes traditional or conventional bu...

A philosophy that believes traditional or conventional budgeting methods are of little use to management, however beyond budgeting does not believe that budgeting within organisati

Ray''s satellite emporium, Ray's Satellite Emporium wishes to verify the be...

Ray's Satellite Emporium wishes to verify the best order size of their best selling satellite dish (model TS111).  Ray has estimated the yearly demand for this model at 1,000 units

Strategic managerial communications, The objective of the term project is t...

The objective of the term project is to demonstrate your understanding and ability to apply the body of knowledge covered in this course. The goal will be on identifying communicat

Strategy and organization analysis, 1. Describe and analyze the environment...

1. Describe and analyze the environment, strategy, and structure of your organization of choice. It is critical to provide evidence for your analysis. 2. Assess the challenges and

Good y and good x, a) What can you say about GOOD Y and GOOD X (a good can ...

a) What can you say about GOOD Y and GOOD X (a good can be an item, a commodity, etc.).  Name a pair of good X and good y that can show this kind of relationship. b) Is the relati

Calculate the price earnings ratio, Q. Calculate the Price earnings ratio? ...

Q. Calculate the Price earnings ratio? Price earnings (PE) ratio PE   = (Market share price/EPS)                     (no. of times) The PE ratio is most widely quoted inv

Describe the key characteristics of a role culture, S Company has for many ...

S Company has for many years been a long standing household name, designing and manufacturing electrical appliances for use in the kitchen. It has developed a strong culture over t

Find the optimal solution, - Middle-East Incorporated (MEINC) Oil blends ga...

- 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 on

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