Question

In: Math

Problem 9-07 (Algorithmic) As part of the settlement for a class action lawsuit, Hoxworth Corporation must...

Problem 9-07 (Algorithmic) As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year 1 2 3 4 5 6 Payment 195 220 270 320 350 470 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 3.5% annually) and government securities, at prices and rates currently quoted in The Wall Street Journal. Hoxworth wants to develop a plan for making the annual payments by investing in the following securities (par value = $1000). Funds not invested in these securities will be placed in savings. Security Current Price Rate (%) Years to Maturity 1 $1045 6.85 3 2 $1000 5.525 4 Assume that interest is paid annually. The plan will be submitted to the judge and, if approved, Hoxworth will be required to pay a trustee the amount that will be required to fund the plan. Use linear programming to find the minimum cash settlement necessary to fund the annual payments. Let F = total funds required to meet the six years of payments G1 = units of government security 1 G2 = units of government security 2 Si = investment in savings at the beginning of year i Note: All decision variables are expressed in thousands of dollars. If required, round your answers to five decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Min F s.t. F + G1 + G2 + S1 = G1 + G2 + S1 + S2 = G1 + G2 + S2 + S3 = G1 + G2 + S3 + S4 = G2 + S4 + S5 = S5 + S6 = Round your answer to the nearest dollar. If an amount is zero, enter "0". Current investment required $ Investment in government security 1 $ Investment in government security 2 $ Investment in savings for year 1 $ Investment in savings for year 2 $ Investment in savings for year 3 $ Investment in savings for year 4 $ Investment in savings for year 5 $ Investment in savings for year 6 $ Use the dual value to determine how much more Hoxworth should be willing to pay now to reduce the payment at the beginning of year 6 to $400,000. Round your answer to the nearest dollar. $ Use the dual value to determine how much more Hoxworth should be willing to pay to reduce the year 1 payment to $150,000. Round your answer to the nearest dollar. Hoxworth should be willing to pay anything less than $ . Suppose that the annual payments are to be made at the end of each year. Reformulate the model to accommodate this change. Note: All decision variables are expressed in thousands of dollars. If required, round your answers to five decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Min F s.t. 1) F + G1 + G2 + S1 = 2) G1 + G2 + S1 + S2 = 3) G1 + G2 + S2 + S3 = 4) G1 + G2 + S3 + S4 = 5) G2 + S4 + S5 = 6) S5 + S6 = 7) S6 + S7 = How much would Hoxworth save if this change could be negotiated? Round your answer to the nearest dollar. $ PreviousNext

Solutions

Expert Solution

1) LP model and solution is as follows

2) Sensitivity report is as follows

Shadow price of year 6 payment is 0.77618. Therefore to reduce the year 6 payment from 470 to 400 (1000s), Hoxworth should be willing to pay additional = (470000-400000)*0.77618 = $ 54333

3) Shadow price of year 1 payment is 1. Therefore to reduce year 1 payment from 195000 to 150000, Hoxworth should be willing to pay now = (195000 - 150000)*1 = 45000

4) revised LP model is following

Saving = 1579578 - 1506164 = $ 73414


Related Solutions

As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash...
As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year 1 2 3 4 5 6 Payment 195 220 270 320 350 470 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at...
Problem 16-07 (Algorithmic) Baseball's World Series is a maximum of seven games, with the winner being...
Problem 16-07 (Algorithmic) Baseball's World Series is a maximum of seven games, with the winner being the first team to win four games. Assume that the Atlanta Braves are playing the Minnesota Twins in the World Series and that the first two games are to be played in Atlanta, the next three games at the Twins' ballpark, and the last two games, if necessary, back in Atlanta. Taking into account the projected starting pitchers for each game and the home...
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week...
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 18 2 21 3 18 4 24 5 18 6 15 7 21 8 19 9 22 10 21 11 15 12 23 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 18 2 21 3 18 4 24 5 18 6...
Problem 6-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week...
Problem 6-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 17 2 22 3 19 4 22 5 19 6 16 7 22 8 17 9 23 10 21 11 14 12 22 Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. Week Sales 4 Period Moving Average 5 Period Moving Average 1 17 2 22 3 19 4...
In order for a class action to be certified by the court it must satisfy the...
In order for a class action to be certified by the court it must satisfy the court that it posses five key elements or criteria. Identify and briefly discuss each of these elements. What is the purpose of workers' compensation legislation and how does this legislation modify tort law? Explain how the same set of facts can give rise to liability in tort and in contract. Does negligence require perfect conduct by the defendant to excuse liability? Explain. Describe the...
Problem 10-07 (Algorithmic) Aggie Power Generation supplies electrical power to residential customers for many U.S. cities....
Problem 10-07 (Algorithmic) Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its main power generation plants are located in Los Angeles, Tulsa, and Seattle. The following table shows Aggie Power Generation's major residential markets, the annual demand in each market (in megawatts or MWs), and the cost to supply electricity to each market from each power generation plant (prices are in $/MW). Distribution Costs City Los Angeles Tulsa Seattle Demand (MWs) Seattle $364.25 $601.75 $67.38...
Problem 10-07 (Algorithmic) Aggie Power Generation supplies electrical power to residential customers for many U.S. cities....
Problem 10-07 (Algorithmic) Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its main power generation plants are located in Los Angeles, Tulsa, and Seattle. The following table shows Aggie Power Generation's major residential markets, the annual demand in each market (in megawatts or MWs), and the cost to supply electricity to each market from each power generation plant (prices are in $/MW). Distribution Costs City Los Angeles Tulsa Seattle Demand (MWs) Seattle $351.25 $588.75 $54.38...
Congratulations! You just won your lawsuit against a major corporation for unethical business practices. As part...
Congratulations! You just won your lawsuit against a major corporation for unethical business practices. As part of the settlement, you have been given two options to receive your money.  The first option is receiving $2,000,000 at the beginning of each year for the next 5 years. The second option is that you can receive a lump sum payment today of $8.5 million. If the discount rate that you use to value the annuity is 6%, which option will provide you with...
Problem 12-09 (Algorithmic) A project has four activities (A, B, C, and D) that must be...
Problem 12-09 (Algorithmic) A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for the time required to complete each of the activities are as follows: Activity Activity Time (weeks) Probability A 3 0.29 4 0.38 5 0.29 6 0.04 B 7 0.22 9 0.53 11 0.25 C 9 0.05 11 0.24 13 0.36 15 0.19 17 0.16 D 10 0.59 12 0.41 Provide the base-case, worst-case, and best-case calculations for the...
Problem 16-01 (Algorithmic) The management of Brinkley Corporation is interested in using simulation to estimate the...
Problem 16-01 (Algorithmic) The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: Procurement Cost ($) Probability Labor Cost ($) Probability Transportation Cost ($) Probability 10 0.35 20 0.2 3 0.72 11 0.25 23 0.25 5 0.28 13 0.4 24 0.35 26...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT