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

Vender cost , Items purchased from a vender cost $20 every, and the forecas...

Items purchased from a vender cost $20 every, and the forecast for the next year's require is 1,000 units.  The cost of placing an order is estimated to be $5 each time an order is

Explain the importance of strategy development, Question 1: Custom Wine...

Question 1: Custom Wine Colorado Glasses of Leadville, Colorado, has just collected data from 75 defects from the day's production. a) As quality expert, you decide to con

Steps for setting up a maintenance strategy, Question: (a) Briefly elab...

Question: (a) Briefly elaborate on the steps for setting up a maintenance strategy. (b) Failures can be grouped in the following three categories namely Induced, Intermitten

Explain about opportunity cost pricing, Q. Explain about Opportunity cost p...

Q. Explain about Opportunity cost pricing? Opportunity cost pricing is considered most mathematically correct way of viewing transfer pricing. Reason is that it looks at transf

Briefly discuss the predictive maintenance strategy, Question: (a) The ...

Question: (a) The Bath-Tub curve is an important tool for understanding the reliability of engineering components in many different applications. It is viewed as a hazard funct

Groups and teams, groups and or teams will solve all the effectiveness and ...

groups and or teams will solve all the effectiveness and efficiency challenges facing the 21st century organisations.discuss

Discuss the pertinence and relevance of the ansoff matrix, Question 1: ...

Question 1: (i) Why should stategic issues involve all stakeholders for a product or/and service? (ii) What are the objectives of strategic formulation and implementation

Disadvantages of divisional structures, Q. Disadvantages of divisional stru...

Q. Disadvantages of divisional structures? - As the complexity and diversity of products and markets within the group increase, central coordination by a head office or holding

Industry Profitability, How do the five competitive forces in Porter''s mod...

How do the five competitive forces in Porter''s model affect the profitability of the overall industry? For example, in what way might weak forces increase industry profits, and in

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