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

Multidimensional performance measurement, Q. Multidimensional performance m...

Q. Multidimensional performance measurement? Multidimensional performance  indicators recognise that the constant drive to increase profitability can ultimately be self-defeati

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

Macroeconomic effects of crisis, Central banks had been supplying short-ter...

Central banks had been supplying short-term funding to smooth needed adjustments in the banking sector, but that alone could not stem bank losses. So what had been addressed as a l

Write memo or email to develop telecommunication, Your assignment is to wri...

Your assignment is to write a memo or email based on the case below.Dropthe completed and final assignment in the assignment dropbox on Slate and bring a hard copy to next week's c

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

Assignment, TicketID: EM201729KAT59SM where is my assignment,. I would lik...

TicketID: EM201729KAT59SM where is my assignment,. I would like to track process.

Mensa, I need a five year plan with cost estimates and a time line also net...

I need a five year plan with cost estimates and a time line also net present values at 10% discount rate

Decision making process, In management strategic decision making involves g...

In management strategic decision making involves great complexity, uncertainty and risk.  Describe the strategic decision making process and consider the effects of bounded rationa

The strategic management process, what is the greatest takeaway from this c...

what is the greatest takeaway from this case in terms of strategic management

Strategic Management Analysis Paper, Need to write a trend analysis paper f...

Need to write a trend analysis paper for a class. I have done first few parts of the project just need to write the last alaysis paper.

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