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

Show the demerits of using return on investment, Q. Show the Demerits of us...

Q. Show the Demerits of using return on investment? The following disadvantages maybe experienced when choosing to use ROI as a primary performance measure. -  An accounting

Networks vary from joint ventures in that network, Are arrangements whereby...

Are arrangements whereby two or more companies work in collaboration without formal relationships, where there is mutual benefit in doing so

Technical reference model, Describe the structure and role of the Tech...

Describe the structure and role of the Technical Reference Model (TRM) in the The Open Group Architecture Framework (TOGAF).  What is the purpose of this component?

Market based approaches, Q. Market based approaches? Cost based approac...

Q. Market based approaches? Cost based approaches to transfer pricing can ignore what external competition would charge, therefore 'open (external) market price' could be used

Show the limitations of ratio analysis, Q. Show the Limitations of ratio an...

Q. Show the Limitations of ratio analysis ? A ratio on its own is meaningless, accounting ratios must always be interpreted in relation to other information.  Ratios based on h

Decision making process, In management strategic decision making involves g...

In management strategic decision making involves great complexity, uncertainty and risk.  Describe the strategic decision making process and consider the effects of bounded rationa

Monitor the performance of a team , 1. Monitor the performance of a team ag...

1. Monitor the performance of a team against given objectives 2. Recommend how to better performance against given objectives.

Evaluate the dividend yield, Q. Evaluate the Dividend yield? Creating ...

Q. Evaluate the Dividend yield? Creating shareholder value  Dividend yield Dividend yield     = (Dividend per share / Market share price) x 100% The dividend yiel

Explain operating profit margin - performance ratios, Q. Explain Operating ...

Q. Explain Operating profit margin - performance ratios? Operating profit mar =              (PBIT / Turnover) x 100% This is the ratio of operating profit to sales or turno

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