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

How might a company sustain and win a price war, ? A) By including a lower ...

? A) By including a lower cost structure ? B) By cross-subsidizing one business from another ? C) By including "deeper pockets" to fund short to medium term losses

How market has influenced the forms and content of the media, 1. The develo...

1. The development of the mass media has been shaped in fundamental ways by the fact that they have often been profit-driven. The commercial or capitalist context of media is evide

Leadership resources, Imagine you have been asked to contribute to planning...

Imagine you have been asked to contribute to planning a session on leadership,collaboration and teamwork in a cultural diverse workplace for your organization. The leaders of this

How to solve complex econometric question, I have problem in subject econom...

I have problem in subject econometrics, how i get solved questions in econometrics.

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

What are the characteristics of an effective control system, QUESTION S...

QUESTION Strategic decisions are the essence of strategic management. According to Pears & Robinson, typically, strategic issues have certain dimensions. Write short notes on e

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

Management decision - making case problem, Louise Nance had working on the ...

Louise Nance had working on the assembly line of the Jackson Manufacturing Company for about six months. During recent weeks, her supervisor, Ben Miller, noticed that her productio

Illustrations of internal failure cost, Illustrations of internal failure c...

Illustrations of internal failure cost The internal perspective may control performance by assessment of internal quality failure.  Costs incurred before customer has received

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

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