Find the optimal solution, Strategic Management

- 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

Posted Date: 3/13/2013 2:08:00 AM | Location : United States







Related Discussions:- Find the optimal solution, Assignment Help, Ask Question on Find the optimal solution, Get Answer, Expert's Help, Find the optimal solution Discussions

Write discussion on Find the optimal solution
Your posts are moderated
Related Questions
Yanni and Joanna need some investment advice. Joanna has sold $660,000 worth of WOW shares that she inherited late last financial year. She has $616,000 remaining after paying capi

Question: (a). What are the benefits of implementing an eBusiness Strategy at Delta Airlines? (b). Identify the different virtual market places in the case study. (c

Q. Financial perspective for not-for-profit organisations? The primary objective is profit for most organisations, but for an NPO they are non-profit making. Value for money (V

1. The development of the mass media has been shaped in fundamental ways by the fact that they have often been profit-driven. The commercial or capitalist context of media is evide

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

Question: (a) Explain, with an example of your choice, why providing more resources on a project does not always lead to completion of the work earlier than scheduled or getti

Strategy used to gain as much sales volume as possible as fast as possible by undercutting competitors' prices.

1.Tannen analyzes gender differences in communication within organizations. Does her analysis resonate in your experience? Have gender-specific differences in communication become

Louise Nance had working on the assembly line of the Jackson Manufacturing Company for about six months. During recent weeks, her supervisor, Ben Miller, noticed that her productio

Based on your findings in Task 1, investigate the problem described in Appendix 1 and propose a solution, in terms of material choice and manufacturing process. Prepare a report