Find the minimum cash settlement necessary to fund

Assignment Help Operation Management

Reference no: EM132091836

As part of the settlement for a class action lawsuit, Hoxworth corporation must provide sufficient cash to make the following annual payments (thousands of dollars): Year 1 2 3 4 5 6 Payment 190 215 240 285 315 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 (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 securites (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. 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? SHOW EXCEL SCREENSHOTS AND SOLVER STEPS.

Reference no: EM132091836

Questions Cloud

Defines bullying in organization context : what code of ethics clearly defines bullying in organization’s context?

Define benefits of outsourcing human resources functions : What are the benefits of outsourcing Human Resources functions? How does strategic leadership help managers to increase their company's performance?

Conducting a financial analysis for a strategic plan : Select one that you learned about and post a brief description of it. Include your analysis of why it would be helpful in conducting a financial analysis.

How the final quality dimension can be possibly measured : Define what quality means to its customers and how the final quality dimension(s) can be possibly measured (judged).

Find the minimum cash settlement necessary to fund : Use linear programming to find the minimum cash settlement necessary to fund the annual payments.

About the operational behavior class : What are the challenges in managing a diverse age group of employees? How might diversity impact individual attitudes and behavior?

Discuss the duties and responsibilities of project manager : Discuss the duties and responsibilities of the project manager. How critical is the project manager to the success of the project?

Discuss about the tuition reimbursement plan in detail : If you had been advising Starbucks, would you have recommended that it introduce the tuition reimbursement plan or instead use the same budget to raise hourly.

Small delicatessen located near major university : Kilgore’s Deli is a small delicatessen located near a major university. Kilgore’s does a large walk-in carry-out lunch business.

User Account

All Pages