Decision Tree and Linear Programming

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

QUESTION
 
Decision Tree and Linear Programming. Please follow the instructions. In your Decision Tree, you must show the network or the decision tree of the problem. Your answers to the Linear Programming problem should be in an Excel Sheet showing the Answer Report, Sensitivity Report, and Limits Report.
Decision Tree and Linear programming
Chemicals, Inc. is a petroleum manufacturing plant located in the Middle East. It has been in existence over the past 15 years. They are currently working on their strategic plans for the year 2021 to 2026. The growth of export petroleum sales over the past couple of years has been good, but the sales could grow even more, if the planned high-tech oil refinery is built near the city where Chemicals, Inc. is located. Chemicals, Inc, is considering three strategies. First is to increase its current production operations, the second is to move closer to the proposed new oil refinery and the third is to do nothing. Strong growth as a result of the presence of the new oil refinery has a 55 percent probability and moving closer to it, would give annual returns of $390,000 per year. Weak growth however, would mean annual returns of $230,000. If nothing was done in the first year of 2021, and strong growth occurred, the strategy to increase its current production would be reconsidered. Strong growth with an increased production would give annual returns of $380,000 per year. Weak growth however would mean annual returns of $200,000. With no changes, there would be returns of $340,000 per year if there is strong growth and $210,000 per year if growth is weak. Increasing production will cost $ 174,000 and moving to a location closer to the refinery will cost $ 420,000. If growth is strong and the production is increased during the second year, the cost would also be $174,000. The cost to operate are the same for all strategies.
1. Decision Tree
You have been hired as a consultant by Chemicals. Inc. Construct a decision tree and advise Chemicals. Inc. on their best strategy to maximize their revenue.
2. Linear Programming
Following your recommended strategy. Chemicals, Inc. wanted to develop an improved aviation fuel to be used by commercial jets at minimal cost. The fuel is a mixture of two fuels (Avgas A and Avgas B). There are 4,000 gallons of Avgas A and 8,000 gallons of Avgas B available. It needs no fewer than 6,000 gallons to fuel a jet to its farthest destination which has a maximum fuel storage capacity of 8,000 gallons. The mixed fuel must have an octane rating of no less than 80. The octane rating is the weighted average of the individual octanes, weighted in proportion to the respective volumes. During mixture, the amount of Avgas obtained equals to the sum of the amounts put in. Avgas A has an octane of 90. and costs $2.40 per gallon. Avgas B has an octane of 75 and costs $1.80 per gallon. In presenting your findings to Chemicals, Inc., they would like to see:
A. The LINEAR PROGRAMMING equations with the constraints expressing this information.
B. Solutions to the Linear Program using Excel Solver and showing the:
a) Answer Report
b) Sensitivity Report
c) Limits Report
 

Sample Solutions
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.

Get sample solution
Order Now

Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.

Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.
Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.
Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services