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 organisation

Financial perspective for not-for-profit organisations, Q. Financial perspe...

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

Industrial accident, An industrial accident may be defined as "an occurrenc...

An industrial accident may be defined as "an occurrence. Which interrupts or interferes with the orderly progress or work in an industrial establishment." According to the Facto

Divisional structures – product organisation, Q. Divisional structures – pr...

Q. Divisional structures – product organisation? The functional structure is normally adopted by an entrepreneurial structure e.g. small business, because the organisation grow

Strategic Planning and Organizational Development fo, Question 1: Read the ...

Question 1: Read the article in the assigned Reading, “Management: A Journey in Progress.” Which do you think are the most enduring management principles and management responsibil

Explain two-part tariff system, Q. Explain Two-part tariff system? With...

Q. Explain Two-part tariff system? With a two-part tariff system the buyer is charged: A transfer price equal to the seller's variable (marginal) cost for each unit sold

Balanced scorecard, Present five arguments to justify why Chemical’s retail...

Present five arguments to justify why Chemical’s retail bank, a financial institution with the bulk of its inputs and outputs denominated in financial terms, needs measures other t

Definition of shareholder wealth, Alfred Rappaport's definition of sharehol...

Alfred Rappaport's definition of shareholder wealth (value)  Shareholder value = corporate (business) value - Debt The corporate value represents the perpetuity of cash

Designing stakeholders evaluation policies, 1. What stakeholders would you ...

1. What stakeholders would you have in the designing of the teacher evaluation policies? 2. What would be inclusive in a teacher evaluation process? (be very specific) 3. When

Limitations of using balanced scorecard, Q. Limitations of using balanced s...

Q. Limitations of using balanced scorecard? - Historical performance analysis is no guide to the future. - Manipulation or 'massaging' of performance measures by management,

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