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

Strategic analysis, conduct a strategic analysis, and write a report on a r...

conduct a strategic analysis, and write a report on a real-life business (MYER) . This report will focus on business-level strategy.

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

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

Which of the following are recognized implementation methods, Trail and dis...

Trail and dissemination Parallel conversion Direct conversion Phased conversion

Management and Strategy, #quesWhat features of Johnson & Johnson''s "Our Cr...

#quesWhat features of Johnson & Johnson''s "Our Credo" made it so effective in guiding J&J''s response to the Tylenol tampering crisis? Where was J&J''s "Our Credo" in the run-up t

Discuss the pillars of total productive maintenance, Question : (a) Wh...

Question : (a) When equipment or a part thereof suddenly stops working, the operating costs in that environment start increasing due to production losses, capacity losses and

Dimensions of common national cultures, Hofstede's dimensions of common nat...

Hofstede's dimensions of common national cultures Power distance. Extent to that people accept inequality of power. Uncertainty avoidance. Tolerance for uncertainty o

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