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...
-
Given the below data, calculate the future value in each case. (Using the formula and also a financialcalculator) Years | Present Value S570 $8,922 $61,133 S219,850 Interest Future RateValue 10% 18%...
-
At your discount brokerage firm, it costs $7.95 per stock trade. How much money do you need to buy 200 shares of Pfizer, Inc. (PFE), which trades at $31.40?
-
Vision Equipment reported the following items on February 28, 2010 (amounts in thousands, with last years amounts also given as needed): Accounts Payable.. $ 449 Accounts Receivable, Net: Cash. 215...
-
Kasik Co. budgeted the following cash receipts and cash disbursements for the first three months of next year. According to a credit agreement with the companys bank, Kasik promises to have a minimum...
-
Use x1=1, x2 = 8, x3 = 1, x4 = 1, x5= 6, x6 = 2, x7 = 8, x8 = 5 to answer the following questions. Company X and Y have been offered the following quarterly compounded rates per annum on a 10-year...
-
Remove the CUSTOMERREP role from the account created in Assignment 1.
-
The microwave spectrum of the CN radical shows a series of lines spaced at intervals of 3.798 cm^-1. what is the bond length of CN & Griven: At mass C = 12.00 amu, N = 14.00307 amu.
-
1 points Save Antwer Bernard co. has 10% coupon bonds on the market that have 18 years left to maturity. The bonds will make annual payments. If the YTM on these bonds is 10%, what is the current...
-
ACME has a capital structure consisting of 35% debt and 65% equity. ACME's debt currently has a 8% yield to maturity. Using the CAPM, ACME estimates that its cost of equity is currently 13% using a...
-
Southerland Corporation, a U.S. video games manufacturer, had several foreign exchange transactions during 2023 and 2024. 2023 10/01/23 11/01/23 12/31/23 2024 01/31/24 Required: Southlerland sold...
-
What is the purpose of adjusted entries? How is this an example of an adjusted entry: A company received $5,000 as advancement in cash. When the cash is received, how would the entry be input?
-
When during an entry can an attendant leave their post outside a permit required confined space?
-
Deferred leasing costs may be overlooked by investors because: Multiple choice question. investors typically measure profitability according to EPS investors typically measure profitability according...
-
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
-
What is the IQR? What does the IQR represent? The population parameters below describe the full-time equivalent number of students (FTES) each year at Lake Tahoe Community College from 19761977...
-
How many standard deviations away from the mean is the median? The population FTES for 20052006 through 20102011 was given in an updated report. The data are reported here. The population parameters...
-
A class of 20 students has a mean grade of 80 on a test. Nineteen of the students has a mean grade between 79 and 82, inclusive. a. What is the lowest possible grade of the other student? b. What is...
Study smarter with the SolutionInn App