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

expectation of stakeholders , 1.1 Describe the importance of external fact...

1.1 Describe the importance of external factors affecting an organization. 1.2 Examine the requires and expectation of stakeholders of an organization. 1.3 Examine the main chang

Essence of management, Do a complete budget for the company you explained i...

Do a complete budget for the company you explained in the Business Plan. You will have to display the profit and loss account, Balance Sheet along with discussions on the budget as

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

Situation Analysis, Is someone in this field able to consult with me on a S...

Is someone in this field able to consult with me on a Situation Analysis I am currently working on?

What is competitor myopia, Instant competition blinds a company to latent c...

Instant competition blinds a company to latent competitors who can demolish the old ways of doing business.

Potential difficulties that might arise for an organisation, Identify FIVE ...

Identify FIVE potential difficulties that might arise for an organisation following the introduction of a new system if support and training are inadequate. Inefficient operat

Define relationship b/w company''s strategy & business model, Relationship ...

Relationship Between A Company's Strategy & Its Business Model 1.   Closely associated to the idea of strategy is the model of a company's business model . CORE CONCEPT:

Supplementary activities, To be effective in hazard control programme it...

To be effective in hazard control programme it must be planned and should be logical. Programme objectives and safety policies need to be established. Responsibility to th

Statistics, #quesSome of its important characteristics are given below: St...

#quesSome of its important characteristics are given below: Statistics are aggregates of facts. Statistics are numerically expressed. Statistics are affected to a marked extent by

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

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