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

Explain the different types of personalisation systems, Question: (a). ...

Question: (a). With the help of appropriate examples of your choice explain the different types of personalisation systems? (b). Distinguish between the micropayments and

Prepare a short notes on normal distribution, Problem 1: a. Prepare a s...

Problem 1: a. Prepare a short notes on Normal distribution. b. The probability that an employee getting occupational disease is 20%. In a firm having five employees, what is th

Sushilicious, What are Woo''s challenges in February 2011?

What are Woo''s challenges in February 2011?

What is strategy & why strategy is important?, What Is Strategy & Why Strat...

What Is Strategy & Why Strategy Is Important? Managers at all companies facade three innermost questions in view strategically concerning their companies' current circumstances

Explain performance ratios - return on capital employed, Q. Explain Perform...

Q. Explain Performance ratios - Return on capital employed? Return on capital employed (ROCE)    = (Profit before interest and tax (PBIT) / Capital employed) x 100%     The

Estimate the cost of making the threaded studs, Estimate the manufacturing ...

Estimate the manufacturing cost for a bearing housing following the Formula Student Costing Scheme.   Dimensions and materials of the bearing housing will depend on your student

Make a list of business goals, Harriet's Fruit and Chocolate Company was es...

Harriet's Fruit and Chocolate Company was established in 1935 in the Pacific Northwest of the United States to ship gift baskets of locally grown peaches and pears to customers in

Contrasting strategic planning to strategic control, Contrasting strategic ...

Contrasting strategic planning to strategic control Strategic planning is a more centralised planning approach, senior management tend to focus less on implementing specific c

Principles of total quality, There are three principles of total quality: c...

There are three principles of total quality: customer focus, continuous improvement, and teamwork. Using the South University online library, find three articles that describe curr

How value chain framework important to managers, Question: The steps in...

Question: The steps in value chain analysis are to examine the company's primary activities and support activities. (a) Elucidate the primary and support activities. (b)

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