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

EFE Matrix, Prepare an EFE Matrix for our university Islamic international ...

Prepare an EFE Matrix for our university Islamic international Islamabad by identifying and evaluating external opportunities and threats facing higher education in your state ,the

Mensa Inc., Describe the situation facing Mensa at time of the case. This ...

Describe the situation facing Mensa at time of the case. This should include major issues facing the company and the decisions that need to be made.

A strategic vision is differ from a mission statement, A Strategic Vision i...

A Strategic Vision is Differ from a Mission Statement: Whereas the chief concern of a strategic vision is with "where we are going & why", a company's mission statement usua

Explain about value based management, Q. Explain about Value based manageme...

Q. Explain about Value based management? Value based management (VBM) is an approach which focuses on strategies and actions to create more value for shareholders.  Value being

Show the activity based budgeting, Q. Show the Activity based budgeting? ...

Q. Show the Activity based budgeting? Activity based budgeting (ABB) uses cost  'drivers'  for  different  support  resources consumed e.g. machining, quality control or admini

What do you mean by trade payable days, Q. What do you mean by Trade payabl...

Q. What do you mean by Trade payable days? Trade payable days (turnover)   {Yearend trade payables / Credit purchases (or cost of sales)} x   365 days This is the length

Determine the level of rents of social housing, Explain what is meant by 'n...

Explain what is meant by 'non-market housing' and by what means it is delivered in either the UK or a country of your choice. What problems arise in its delivery? Outl

Limitations of using balanced scorecard, Q. Limitations of using balanced s...

Q. Limitations of using balanced scorecard? - Historical performance analysis is no guide to the future. - Manipulation or 'massaging' of performance measures by management,

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