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

Prepare a short notes on normal distribution, Problem 1: a. Prepare a s...

Problem 1: a. Prepare a short notes on Normal distribution. b. The probability that an employee getting occupational disease is 20%. In a firm having five employees, what is th

Ray''s satellite emporium, Ray's Satellite Emporium wishes to verify the be...

Ray's Satellite Emporium wishes to verify the best order size of their best selling satellite dish (model TS111).  Ray has estimated the yearly demand for this model at 1,000 units

Show the relationship between equity and debt, Q. Show the relationship bet...

Q. Show the relationship between equity and debt? Gearing is the relationship between equity and debt.  Debt is generally long term liabilities that the organisation has.  Equi

Strategy plan that includes resource implications, a) Way a suitable struct...

a) Way a suitable structure for a strategy plan that make sures appropriate participation from all stakeholders of an organization. b) Make criteria for reviewing potential option

Technological effects of globalization in an organization, Methodology T...

Methodology The purpose of this research is to gather statistical information and data on how technological affects globalization, and how the trend of globalization is affectin

Impact on the organizational and personal levels, Question Sarah and ...

Question Sarah and John are both working for a software development company. The manager of the new product division was originally the leader of the project team for whi

Advantages and disadvantages of the formal/rational approach, RF and JT are...

RF and JT are both former international rugby players who, when they retired, formed their own business, WFH Trading Company.  The company that they established at first manufactur

Explain about opportunity cost pricing, Q. Explain about Opportunity cost p...

Q. Explain about Opportunity cost pricing? Opportunity cost pricing is considered most mathematically correct way of viewing transfer pricing. Reason is that it looks at transf

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

Management strategic planning, You are an asset manager for a large public ...

You are an asset manager for a large public utility organisation. The organisation has a range of assets, ranging from major distributors to minor assets directly serving users (fo

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