As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 185 225 290 310 360 450 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 4.25% 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. $1035 6.75 3 2 $1000 5.425 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. a. Use linear programming to find the minimum cash settlement necessary to fund the annual payments. Do not round your answers. If required, only round your decision variables to a whole dollar amount. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) 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. Min F s.t. 1) 1 VF + X G1 + G2 + -1 V s1 = 185 V -1 2) .0675 V G1 + X G2 + X s1 + -1 v s2= 225 V 3) .0675 V G1+ X G2 + X s2 + V S3 = -1 290 v 4) 1.0675 V G1+ X G2 + X s3 - -1 V S4 310 v 5) X G2 + X S4 + -1 S5 = 360 V 6) X S5+ -1 V S6 = 450 V >xx xxx + + + Current investment required $ Investment in government security 1$ Investment in government security 2 $ Investment in savings for year 1 $4 Investment in savings for year 2 $4 Investment in savings for year 3 $ Investment in savings for year 4 $ Investment in savings for year 5 $ Investment in savings for year 6 %$4 b. Use the shadow price 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. c. Use the shadow price to determine how much more Hoxworth should be willing to pay to reduce the year 1 payment to $150,000. Hoxworth should be willing to pay anything less than $ d. Suppose that the annual payments are to be made at the end of each year. Reformulate the model to accommodate this change. Do not round your answers. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Note: All decision variables are expressed in thousands of dollars. Min s.t. 1) F G1|- G2 + s1 2) G1 S1 S2 3) G1 G2 S3 4) G2 S3 + S4 5) G2+ S5 = 6) S5 + S6 = 7) S6|+ S7 = How much would Hoxworth save if this change could be negotiated? If required, round your answer to a whole dollar amount. ++ + + + + 8||8|8|あ|8|& ++ + + + + + + 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 185 225 290 310 360 450 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 4.25% 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. $1035 6.75 3 2 $1000 5.425 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. a. Use linear programming to find the minimum cash settlement necessary to fund the annual payments. Do not round your answers. If required, only round your decision variables to a whole dollar amount. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) 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. Min F s.t. 1) 1 VF + X G1 + G2 + -1 V s1 = 185 V -1 2) .0675 V G1 + X G2 + X s1 + -1 v s2= 225 V 3) .0675 V G1+ X G2 + X s2 + V S3 = -1 290 v 4) 1.0675 V G1+ X G2 + X s3 - -1 V S4 310 v 5) X G2 + X S4 + -1 S5 = 360 V 6) X S5+ -1 V S6 = 450 V >xx xxx + + + Current investment required $ Investment in government security 1$ Investment in government security 2 $ Investment in savings for year 1 $4 Investment in savings for year 2 $4 Investment in savings for year 3 $ Investment in savings for year 4 $ Investment in savings for year 5 $ Investment in savings for year 6 %$4 b. Use the shadow price 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. c. Use the shadow price to determine how much more Hoxworth should be willing to pay to reduce the year 1 payment to $150,000. Hoxworth should be willing to pay anything less than $ d. Suppose that the annual payments are to be made at the end of each year. Reformulate the model to accommodate this change. Do not round your answers. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Note: All decision variables are expressed in thousands of dollars. Min s.t. 1) F G1|- G2 + s1 2) G1 S1 S2 3) G1 G2 S3 4) G2 S3 + S4 5) G2+ S5 = 6) S5 + S6 = 7) S6|+ S7 = How much would Hoxworth save if this change could be negotiated? If required, round your answer to a whole dollar amount. ++ + + + + 8||8|8|あ|8|& ++ + + + + + +
Expert Answer:
Answer rating: 100% (QA)
a First we are going to setup the constraints and linear programming problem in Excel Carefully put the values from matching column name into the answer box provided for this part For example there is ... View the full answer
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these mathematics questions
-
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): The annual payments must be...
-
In 2009, several freelance writers filed a class action lawsuit against publishers, claiming that the publishers had, without permission, reproduced certain works. In other words, the publishers had...
-
In mid-2009, a class action lawsuit was launched against Babies R Us, a division of Toys R Us, as well as five manufacturers from whom Babies R Us purchased baby products for resale in its stores....
-
According to the 2020 Global Study on Occupational Fraud and Abuse, a tip is the most common way to report fraud. What should be the ethical considerations for employees before deciding whether to...
-
The Pickett Marketing Firm is developing a new Web-based media campaign for a client. The following table describes the relationships between the activities that need to be completed. (a) Develop a...
-
You are given that P(A) = 0.15 and P(B) = 0.40. Do you have enough information to find P(A or B)? Explain.
-
For the following, determine if the given point is a removable singularity, an essential singularity, or a pole (indicate its order). a. \(\frac{1-\cos z}{z^{2}}, \quad z=0\). b. \(\frac{\sin...
-
Following are descriptions of three businesses. For each, assume that you are the CEO. Identify the most critical information you would need to manage the strategic decisions of that business. a....
-
5. 5: The Cost of Capital: Cost of New Common Stock If a firm plans to issue new stock, flotation costs (investment bankers' fees) should not be ignored. There are two approaches to use to account...
-
In this exercise, you create an application that allows the user to enter the gender (either F or M) and GPA for any number of students. The application should calculate the average GPA for all...
-
Accounts Receivable Aging Analysis for Superstore as of December 31, 2020 Days Outstanding 0 - 30 31 - 60 61 - 90 91+ Necessary Allowance Percentage 0.50% 2% 10% 35% T...
-
In this question you will consider the performance of a modified jet-propulsion cycle, for a turbojet engine with a normal-shock inlet, such as equipped on the Commonwealth Aircraft Corporation F86...
-
During the current month, Carla Vista Corporation completed Job 310 and Job 312. Job 310 cost $67,200 and Job 312 cost $48,000. Job 312 was sold on account for $86,400. Journalize the entries for the...
-
McWherter Instruments sold $600 million of 6% bonds, dated January 1, on January 1, 2024. The bonds mature on December 31, 2043 (20 years). For bonds of similar risk and maturity, the market yield...
-
The spot Dollar-GBP sterling exchange rate is $1.80 per pound. The U.S. and U.K. 1-year simple interest rates are 4% and 2% respectively. The futures price for delivery in one year is $1.86 per...
-
Briefly describe the forensic psychology career field Explain what drew you to this field (forensic psychology) Examine the impact of past, current, and developing technology in your field (forensic...
-
ACC1100. Exercise 3-8 (Algo) Compare investment alternatives LO 2 A friend has $1,000 that he has saved from his part-time job. He will need his money, plus any interest earned on it, in six months...
-
A company has the following incomplete production budget data for the first quarter: In the previous December, ending inventory was 200 units, which was the minimum required, at 10% of projected...
-
The manager of the Fore and Aft Marina in Problem 16 wants to investigate the possibility of enlarging the docking facility so that two boats can stop for gas and servicing simultaneously. Assume...
-
EL Computer produces its multimedia notebook computer on a production line that has an annual capacity of 16,000 units. EL Computer estimates the annual demand for this model at 6000 units. The cost...
-
For the Pittsburgh Development Corporation problem in Section 4.3, the decision alternative to build the large condominium complex was found to be optimal using the expected value approach. In...
-
\(7 \sqrt{5}+6 \sqrt{14}\) Perform the arithmetic operations without a calculator, if possible. If it is not possible, state why.
-
\(7.3 \sqrt{45}-6.8 \sqrt{20}\) Perform the arithmetic operations without a calculator, if possible. If it is not possible, state why.
-
\(19.8 \sqrt{12}-6.1 \sqrt{3}\) Perform the arithmetic operations without a calculator, if possible. If it is not possible, state why.
Study smarter with the SolutionInn App