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
The functions of a performance measurement system; - Publicise direction for 'everyone to follow' e.g. partners, managers, directors, team members and other stakeholders. -

Strategy development processes Vision and mission statements There was no announcement about Aldi's mission statement, but it's vision relates to offer its customers in

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

Perform external and internal audits Follow the strategic development content then Aldi can perform external and internal audits. In external audit is considered an important

Model-Building Strategies Various strategies have been used when implementing whole body PBPK models. As discussed below, it is important to distinguish between model building

Q. Explain about Value based management? Value based management (VBM) is an approach which focuses on strategies and actions to create more value for shareholders.  Value being

Q. Aim of a transfer pricing system? Aim of a transfer pricing system could be tax avoidance Different countries have varying tax rates.  A multi-national company can set up su

what is describe as strength and weakness in strategic planning

Discuss the following quotation and please provide examples. "Enterprise Architecture frameworks such as the Zachman Framework are essentially conceptual skeletons tha

Bert's Bonsai sells Bonsai plants, tools and materials to cultivate them, and literature in book and magazine form. An early adopter of electronic records, they are still happily u