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

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

Miss, how much for a dissertation 15,000 words due in June with the topic i...

how much for a dissertation 15,000 words due in June with the topic is Strategic management? thanks

Diffusion is, The amount and pace of market adoption.

The amount and pace of market adoption.

Marketing strategy, Select an existing business that has recently launched ...

Select an existing business that has recently launched a new product. You may also use your own company. Consider how the organization's marketing strategy has benefited the new pr

Prepare the table showing net profit and residual income, Question: A l...

Question: A large conglomerate with diverse business activities is currently considering whether it should commence Project X and has gathered the following data: Project X

Dynamic performance management process, Q. Dynamic performance management p...

Q. Dynamic performance management process? The beyond budgeting approach should lead to  A more dynamic performance management process that will enable organisations

Arguments for the controllability principle, Q. Arguments for the controlla...

Q. Arguments for the controllability principle?  - It would be considered fairer by a manager if they were not assessed on costs which are not within their own control. This is

Models of strategic management, your own company. Consider how this organiz...

your own company. Consider how this organization has developed their strategic management. Then write an original article addressing how this organization selected a model of strat

Coca-Cola vs Pepsi, How would you respond to Coca-Cola’s change in sales po...

How would you respond to Coca-Cola’s change in sales policy? How would you ensure Pepsi’s board that this response will allow you to remain competitive and profitable?

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