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

Estimate the cost of making the threaded studs, Estimate the manufacturing ...

Estimate the manufacturing cost for a bearing housing following the Formula Student Costing Scheme.   Dimensions and materials of the bearing housing will depend on your student

Real Option, I have one real option problem I need help with

I have one real option problem I need help with

International aspects to transfer pricing, Q. International aspects to tran...

Q. International aspects to transfer pricing? The following issues can influence international transfer pricing decisions. Exchange rates e.g. fluctuations in global cur

Feasibility concerns, Whether an organization has the resources and compete...

Whether an organization has the resources and competences to deliver a plan

What are the four types of strategic control, QUESTION 1 The most impor...

QUESTION 1 The most important purpose of strategic control is to help Top Management achieve organizational goals through monitoring and evaluating the strategic management pro

Characteristics of organic verses mechanistic organisations, Characteristic...

Characteristics of 'organic' verses 'mechanistic' organisations   Organic Mechanistic Management Style Partici

Future organisation strategy, The company is now aggressively working towar...

The company is now aggressively working towards being the largest retail chain in the country and also being first in profitability.  At the same time the company is exploring maki

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

Importance of external factors affecting the organization, Choose a real li...

Choose a real life company.  This could be an organization from any industry.  No two students should select the similar company.  It could be the organization you are working in o

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