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

Analyse link between corporate strategy and bottom line, Question 1: "S...

Question 1: "Strategic Corporate Social Responsibility executed well is effective Corporate Social Responsibility". What are the essential elements to take into account in o

Quantitative analysis, how has quantitative analysis changed the current sc...

how has quantitative analysis changed the current scenario in the management world today?

Multiple choice help, If in a given year a company spends $2 million on new...

If in a given year a company spends $2 million on new product development, design, and engineering for its entry-level camera line; $4 million on new product development, design, a

Explain operating profit margin - performance ratios, Q. Explain Operating ...

Q. Explain Operating profit margin - performance ratios? Operating profit mar =              (PBIT / Turnover) x 100% This is the ratio of operating profit to sales or turno

Marketing strategy for services, Marketing Strategy for Services ...

Marketing Strategy for Services This activity is part of your marketing plan.  Prepare a 4-5 page report, addressing the following : o   Describe the target

Why are crafting & executing strategy important, Why are Crafting & Executi...

Why are Crafting & Executing Strategy Important? 1.   Crafting & executing strategy are the top managerial tasks for two very large motives:- (a). Here, compelling requirem

Prepare a successful quality based strategy, Question: (a) To prepare ...

Question: (a) To prepare a successful quality based strategy requires an effective leadership. Explain briefly the requirements of effective leadership in this context.

UPD manufacturing, Would you recommend changing to the optimal order interv...

Would you recommend changing to the optimal order interval?

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