1. 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     Payment 1               190 2              215 3             240 4            285 5            315 6           460 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% 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                        $1055                      6.750                         3 2                       $1000                      5.125                         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.  b. 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.  c. Use the dual value to determine how much more Hoxworth should be willing to pay to reduce the year 1 payment to $150,000.  d. Suppose that the annual payments are to be made at the end of each year. Reformulate the model to accommodate this change. How much would Hoxworth save if this change could be negotiated

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 25P
icon
Related questions
Question

I need help with everything, please.

hint: you will need to define one variable for total funds needed; one variable for each for 2 securities. 

and five variables for investment in savings at the beginning of each year. The 6th year will be 1.04 times the 

                     5th-year saving variable. Formulate the problem and submit the formulation - no need to solve 

1. 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     Payment

1               190

2              215

3             240

4            285

5            315

6           460

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% 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                        $1055                      6.750                         3

2                       $1000                      5.125                         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. 

b. 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. 

c. Use the dual value to determine how much more Hoxworth should be willing to pay to reduce the year 1 payment to $150,000. 

d. Suppose that the annual payments are to be made at the end of each year. Reformulate the model to accommodate this change. How much would Hoxworth save if this change could be negotiated

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 8 images

Blurred answer
Knowledge Booster
Financial management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,