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

Weakness in swot analysis , Weakness: Though Arpanaa has the best amenitie...

Weakness: Though Arpanaa has the best amenities in tow which are not offered by the hotels that are located in and around the town, it runs short of few features such as non veget

Decision-making information systems, An organisation is reviewing its decis...

An organisation is reviewing its decision-making information systems and has asked you to recognize suitable assessment criteria for this review. Value for money. Value for m

Mission statements for an organization, a) Examine core organizational valu...

a) Examine core organizational values (ethical, cultural, environmental, social and business) with the present business objectives of an organization. b) Make appropriate vision a

Discuss the digital strategies, Question : ‘The financial crunch has ur...

Question : ‘The financial crunch has urged companies involved in tourism to reshape their business model' As a tourism business consultant and in the light of the above stat

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

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.

Develop a strategy for an organisation, Design a comprehensive Change Manag...

Design a comprehensive Change Management Strategy for your organisation/division/unit and with that (strategy) make sure that organisational diagnosis/analysis are addressed and cr

General electric model, what are the advantages of using tha general nine e...

what are the advantages of using tha general nine electric model

What is organizational design, 1.Middle managers are often at the center of...

1.Middle managers are often at the center of efforts to develop tactical plans to implement established strategies. How are tactical plans typically established? What challenges co

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