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

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

What is the average contribution and selling price per unit, Division X has...

Division X has a target return on investment (ROI) of 12%.  It has fixed costs of £400,000 and a variable cost per unit of £5.  The net assets of the division forecast for the next

Show the quick ratio or acid test, Q. Show the Quick ratio or acid test? ...

Q. Show the Quick ratio or acid test? Quick ratio or acid test   Quick ratio = Current assets less inventories / Current liabilities               (times) This ratio meas

Improve the maintenance strategy in industries, Question: (a) Define ...

Question: (a) Define the term ‘Maintenance'. How does it differ from strategic maintenance? Explain, briefly, the meaning of Maintenance Mix and state how it can be develope

Calculate capacity of the system, Cookie company is open for all day and ni...

Cookie company is open for all day and night, 24 hrs. Enough demand exists to keepthe cookie company busy 24 hrs. Assume you have: (i) One oven which can accommodate one tray

Develop a performance measurement system, Recommended process to develop a ...

Recommended process to develop a performance measurement system  1. Senior management need to determine a clear vision of the change that will be required and demonstrate comm

Animal processing, what is HACCP and benefits in food industry

what is HACCP and benefits in food industry

Strategic management process, Have you ever been involved in an effort to i...

Have you ever been involved in an effort to introduce a new product, service or technology in an organization? If so, share your experiences with the class. Provide the class wi

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

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