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

Describe chargeback, A process in the industry where a wholesaler requests ...

A process in the industry where a wholesaler requests an amount that is the difference among the manufacturer's price to the wholesaler and the contract price to the resale custome

What is the average contribution and selling price per unit, Division X has...

Division X has a target return on investment (ROI) of 12%.  It has fixed costs of £400,000 and a variable cost per unit of £5.  The net assets of the division forecast for the next

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

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

Strategic management process, Have you ever been involved in an effort to i...

Have you ever been involved in an effort to introduce a new product, service or technology in an organization? If so, share your experiences with the class. Provide the class wi

Development of an asset management plan, Write a submission to your chief e...

Write a submission to your chief executive officer of your organisation describing a strategy to improve the organisation's assets, their management, and the standard of service wh

Opportunities in swot analysis , Opportunities: The hotel has now 20 spaci...

Opportunities: The hotel has now 20 spacious rooms that can offer excellent comfort and luxury to the upper middle class people who visit the place. The rooms are completely booke

Briefly discuss the predictive maintenance strategy, Question: (a) The ...

Question: (a) The Bath-Tub curve is an important tool for understanding the reliability of engineering components in many different applications. It is viewed as a hazard funct

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