Recall the model developed in the class for the Refinery Blending Problem Minimize 0.1 R1 +...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Recall the model developed in the class for the Refinery Blending Problem Minimize 0.1 R1 + 0.15 R2 +0.1 H1 +0.15 H2 Subject to (DEM_REG) 800000 (DEM_HO) = 500000 (REG_COMP) >= 320000 (HO_COMP) <= 250000 1 R1 + 1 R2 0.2 R1 + 0.5 R2 All variables are >= 0 1 H1 + 1 H2 0.6 H1 +0.3 H2 (a) Use SOLVER to obtain the solution. What is the optimum solution and the cost? (b) If the refinery just realized that it has only 500,000 gallons of crude oil 1. Can you still use the refinery plan found in (a)? If not, modify your model to incorporate this constraint and re-solve using SOLVER The Mathematical model for this problem is: Let: B1 = Amount (S) invested in Bond-1 B2 = Amount ($) invested in Bond-2 B3 Amount (S) invested in Bond-3 B4 = Amount (S) invested in Bond-4 Objective: Maximize Expected total return for the first year Maximize 0.13B1 +0.08B2+0.12B3 +0.14B4 Constraints: 1. Budget: Total investment should be $1000000 B1 + B2+B3+ B4 = 1000000 2. Worst Case Return should exceed 0.08 Simplifying this constraint, we get: 0.0681+0.0882+0.108300984 1000000 3. Average duration should not exceed 6 381 482 783-984 1000000 -56 simplifying this constraint, we get: 1000000 0.0681+0.0882+0.1083 +0.098420.08*1000000 B1 4. Diversity constraint: Investment in each bond cannot exceed 40% of Total Investment. Bond-1: B1 £ 400000 381+482+783+9846*1000000 Likewise: Bond-2: B2 £ 400000 Bond-3: B3 £ 400000 Bond-4: B4 £ 400000 5. Logical Constraints: B1, B2, B3, B4³0 Putting everything together, the model is: Maximize 0.13B1+0.08B2+0.12B3 +0.14B4 Constraints: 0.08 + B2 +B3 +B4= 0.0681+0,0882+0.1083+0.09840.08 1000000 Recall the model developed in the class for the Refinery Blending Problem Minimize 0.1 R1 + 0.15 R2 +0.1 H1 +0.15 H2 Subject to (DEM_REG) 800000 (DEM_HO) = 500000 (REG_COMP) >= 320000 (HO_COMP) <= 250000 1 R1 + 1 R2 0.2 R1 + 0.5 R2 All variables are >= 0 1 H1 + 1 H2 0.6 H1 +0.3 H2 (a) Use SOLVER to obtain the solution. What is the optimum solution and the cost? (b) If the refinery just realized that it has only 500,000 gallons of crude oil 1. Can you still use the refinery plan found in (a)? If not, modify your model to incorporate this constraint and re-solve using SOLVER The Mathematical model for this problem is: Let: B1 = Amount (S) invested in Bond-1 B2 = Amount ($) invested in Bond-2 B3 Amount (S) invested in Bond-3 B4 = Amount (S) invested in Bond-4 Objective: Maximize Expected total return for the first year Maximize 0.13B1 +0.08B2+0.12B3 +0.14B4 Constraints: 1. Budget: Total investment should be $1000000 B1 + B2+B3+ B4 = 1000000 2. Worst Case Return should exceed 0.08 Simplifying this constraint, we get: 0.0681+0.0882+0.108300984 1000000 3. Average duration should not exceed 6 381 482 783-984 1000000 -56 simplifying this constraint, we get: 1000000 0.0681+0.0882+0.1083 +0.098420.08*1000000 B1 4. Diversity constraint: Investment in each bond cannot exceed 40% of Total Investment. Bond-1: B1 £ 400000 381+482+783+9846*1000000 Likewise: Bond-2: B2 £ 400000 Bond-3: B3 £ 400000 Bond-4: B4 £ 400000 5. Logical Constraints: B1, B2, B3, B4³0 Putting everything together, the model is: Maximize 0.13B1+0.08B2+0.12B3 +0.14B4 Constraints: 0.08 + B2 +B3 +B4= 0.0681+0,0882+0.1083+0.09840.08 1000000
Expert Answer:
Answer rating: 100% (QA)
a The optimal solution is R1 500000 R2 300000 H1 200000 H2 100000 The cost is 01 500000 015 30... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
If you operate a refinery and need to buy crude oil (and havent made a prior arrangement that locked in a lower price), the spot price for crude oil determines what you can expect to pay per barrel...
-
For problems 1 to 3 Let T: R2 R2 be the linear transformation given by T( ) = A, where 1. verify that and explain why this means that the x-axis is mapped onto itself. 2. Verify that and explain why...
-
For a set A, let R1 and R2 be symmetric relations on A. If R1 o R2 R2 o R1, prove that R1 o R2 = R2 o R1.
-
Discuss types of media used in the design of a network given different situations. Namely: What would you do for a college campus with hundreds of staff users and students? How would they connect...
-
William E. Story agreed orally with his nephew that if he would refrain from drinking liquor, using tobacco, swearing, and playing cards or billiards for money until he became twenty-one years old,...
-
Security isnt simply a technology issue, its a business issue. Discuss.
-
For the coordinate transformation (12.1) and (12.2), develop the second-order finite difference approximations of \(u_{y}, u_{x x}\), and \(u_{x y}\) at \(\left(\xi_{i}, \eta_{j} ight)\). Apply...
-
The Cutting Department of Hong Manufacturing has the following production and cost data for July. Instructions(a) Determine the equivalent units of production for (1) Materials and (2) Conversion...
-
Showing the steps on how this is solved would be helpful to understand the problem.. 11.6 Assume that Harkers Healthcare, a for-profit corporation, also experiences the situation reported in problem...
-
You are working on a free-form Packet Tracer challenge activity as seen in Figure 1, you have been given the London Railways network.' The purpose of this EMA question is to build upon each of the...
-
. Consider a three step Binomial pricing model with S = 80, u = 2, d = 0.5, r = p = random variables defined as follows: T: T(HHH) = 0,t(HHT) = ,t(HTH) = 2,t(HTT) = 2,t(TTT) = 1,t(TTH) = 1,t(THT) =...
-
Prepare an income statement for Rex Manufacturing for the year ended December 31 using the following Information. Hint Not all Information given is needed for the solution. Finished goods inventory,...
-
Korvanis Corporation operates a Medical Services Department for its employees. Charges to the company's operating departments fo the variable costs of the Medical Services Department are based on the...
-
Apex Company prepared the statement of cash flows for the current year that is shown below: Apex Company Statement of Cash Flows-Indirect Method Operating activities: Net income Adjustments to...
-
During measurement in a sedimentation experiment, explain if: a ) particles fall rapidly as a result of gravity. b ) what is perceived depends on the size of the particle. c ) what is perceived...
-
A small sphere of radius ro = 1.2 cm rolls without slipping on the track shown in the figure whose radius is Ro=26.0 cm. The sphere starts rolling at a height Ro above the bottom of the track....
-
Northwestern Memorial Hospital: Smooting material flow through the receiving area Suggest concrete ways to modify the receiving value stream map to move it toward single piece flow. Consider changes...
-
4. Jobe dy -Y 2 et by
-
The following table shows the frequencies that the Green Bay Packers of the NFL called a running play or a passing play for various down and distance situations for the first five games of a recent...
-
In spite an unemployment rate of 26% and an economy in crisis, 70% of Spaniards responded that they were in favor of keeping the euro rather than returning to the peseta and the national currency in...
-
Consider a Poisson probability distribution with l = 4.7. Determine the following probabilities. a. exactly five occurrences b. more than six occurrences c. three or fewer occurrences
-
Imagine that you have \($10,000\) to invest. Use a newspaper, the Internet, or other source to select a mutual fund. Use the same source to fi nd out how much gold you could buy for \($10,000\)....
-
Animation art, hand-painted images from which cartoons used to be made, is a popular collectible.
-
The PBS television program, Antiques Roadshow, has generated enormous interest among viewers to find out the value of the furniture, art, jewelry, and collectibles they own.
Study smarter with the SolutionInn App