menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

James Judson is the financial manager in charge of the company pension fund at Armco Incorporated. James knows that the fund must be sufficient to make the payments listed in Table 4.4. Each payment must be made on the first day of each year. James is going to finance these payments by purchasing bonds. It is currently January 1 of year 1, and three bonds are available for immediate purchase. The prices and coupons for the bonds are as follows. (We assume that all coupon payments are received on January 1 and arrive in time to meet cash demands for all the year on which they arrive.) Bond 1 costs $980 and yields a $60 coupon in the years 2 through 5 and a $1060 payment on maturity in the year 6. Bond 2 costs $970 and yields a $65 coupon in the years 2 through 11 and a $1065 payment on maturity in the year 12. Bond 3 costs $1050 and yields a $75 coupon in the years 2 through 14 and a $1075 James must decide how much cash to allocate (from company coffers) to meet the initial $11,000 payment and buy enough bonds to make future payments. He knows that any excess cash on hand can earn an annual rate of 4% in a fixed-rate account. How should he proceed? In the pension fund model, suppose there is an upper limit of 60 on the number of bonds of any particular type that can be purchased. Modify the model to incorporate this extra constraint and then reoptimize. How much more money does James need to allocate initially?

BuyFindarrow_forward

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

Solutions

Chapter
Section
BuyFindarrow_forward

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659
Chapter 4.7, Problem 34P
Textbook Problem
23 views

James Judson is the financial manager in charge of the company pension fund at Armco Incorporated. James knows that the fund must be sufficient to make the payments listed in Table 4.4. Each payment must be made on the first day of each year. James is going to finance these payments by purchasing bonds. It is currently January 1 of year 1, and three bonds are available for immediate purchase. The prices and coupons for the bonds are as follows. (We assume that all coupon payments are received on January 1 and arrive in time to meet cash demands for all the year on which they arrive.)

  • Bond 1 costs $980 and yields a $60 coupon in the years 2 through 5 and a $1060 payment on maturity in the year 6.
  • Bond 2 costs $970 and yields a $65 coupon in the years 2 through 11 and a $1065 payment on maturity in the year 12.

Bond 3 costs $1050 and yields a $75 coupon in the years 2 through 14 and a $1075

James must decide how much cash to allocate (from company coffers) to meet the initial $11,000 payment and buy enough bonds to make future payments. He knows that any excess cash on hand can earn an annual rate of 4% in a fixed-rate account. How should he proceed?

Chapter 4.7, Problem 34P, James Judson is the financial manager in charge of the company pension fund at Armco Incorporated.

In the pension fund model, suppose there is an upper limit of 60 on the number of bonds of any particular type that can be purchased. Modify the model to incorporate this extra constraint and then reoptimize. How much more money does James need to allocate initially?

Summary Introduction

To modify: The given model to include the extra constraint and to find the optimal solution and also determine the extra money Person J needs to allocate in the initial stages.

Linear programming:

It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.

Explanation of Solution

Excel model:

Solver input:

The solver input is selected from under the “Data” tab in Excel and the input is given as shown below:

Formula:

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 4 Solutions

Practical Management Science
Show all chapter solutions
add
Ch. 4.3 - A small business requires different numbers of...Ch. 4.3 - A small business requires different numbers of...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.6 - Repco produces three drugs, A, B, and C, and can...Ch. 4.6 - Repco produces three drugs, A, B, and C, and can...Ch. 4.6 - Repco produces three drugs, A, B, and C, and can...Ch. 4.6 - Repco produces three drugs, A, B, and C, and can...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.8 - Pine Valley Bank has three branches. You have been...Ch. 4.8 - The Salem Board of Education wants to evaluate the...Ch. 4.8 - You have been asked to evaluate the efficiency of...Ch. 4.8 - You have been commissioned by Indiana University...Ch. 4 - A bus company believes that it will need the...Ch. 4 - During each four-hour period, the Smalltown police...Ch. 4 - Shoemakers of America forecasts the following...Ch. 4 - NewAge Pharmaceuticals produces the drug NasaMist...Ch. 4 - You have decided to enter the candy business. You...Ch. 4 - Sunblessed Juice Company sells bags of oranges and...Ch. 4 - A bank is attempting to determine where its assets...Ch. 4 - Young MBA Erica Cudahy can invest up to 20,000 in...Ch. 4 - A fertilizer company blends silicon and nitrogen...Ch. 4 - A chemical manufacturer uses chemicals 1 and 2 to...Ch. 4 - Hilands Appliances stocks laptops, TVs,...Ch. 4 - Many Wall Street firms use LP models to select a...Ch. 4 - A coal company produces coal at three mines and...Ch. 4 - A furniture company manufactures tables and...Ch. 4 - A chemical company produces three products, A, B,...Ch. 4 - Abotte Products produces three products, A, B, and...Ch. 4 - An investor has 100,000 to invest right now (the...Ch. 4 - At the beginning of year 1, you have 100,000....Ch. 4 - You now have 10,000, and the following investment...Ch. 4 - An oil company processes oil into aviation fuel...Ch. 4 - All steel manufactured by Allied Steel must meet...Ch. 4 - United Steel manufactures two types of steel at...Ch. 4 - Based on Heady and Egbert (1964). Walnut Orchard...Ch. 4 - Candy Kane Cosmetics (CKC) produces Leslie...Ch. 4 - Federated Oil has refineries in Los Angeles and...Ch. 4 - A feed company produces two types of cattle feed,...Ch. 4 - Carrington Oil produces gas 1 and gas 2 from two...Ch. 4 - Based on Thomas (1971). A toy company produces...Ch. 4 - A company produces two products: A and B. Product...Ch. 4 - A bank needs exactly two employees working each...Ch. 4 - Based on Gaballa and Pearce (1979). Northwest...Ch. 4 - A rock company uses five types of rocks to fill...Ch. 4 - An automobile manufacturer needs to plan its...Ch. 4 - An oil company produces gasoline from five inputs....Ch. 4 - The HiTech company produces Blu-Ray disc players....Ch. 4 - During the next two months an automobile...Ch. 4 - You want to take out a 450,000 loan on a 20-year...Ch. 4 - A graduated payment mortgage (GPM) enables the...Ch. 4 - Suppose you are planning for retirement. At the...Ch. 4 - Based on Brams and Taylor (2000). Suppose that Eli...Ch. 4 - AdminaStar processes Medicare claims. At the...Ch. 4 - All steel manufactured by Allied Steel must meet...Ch. 4 - During the next four quarters, Dorian Auto must...Ch. 4 - The Internal Revenue Service (IRS) has determined...Ch. 4 - You own a wheat warehouse with a capacity of...Ch. 4 - You can calculate the risk index of an investment...Ch. 4 - Based on Magoulas and Marinos-Kouris (1988). An...Ch. 4 - Capsule Drugs manufactures two drugs. The drugs...Ch. 4 - Molecular Products produces three chemicals: B, C,...Ch. 4 - Bexter Labs produces three products: A, B, and C....Ch. 4 - Mondo Motorcycles is determining its production...Ch. 4 - An automobile manufacturing company has a 500,000...Ch. 4 - Broker Sonya Wong is currently trying to maximize...Ch. 4 - Budget Auto produces inexpensive cars. Each car is...Ch. 4 - The ZapCon Company is considering investing in...Ch. 4 - You are a CFA (chartered financial analyst). An...Ch. 4 - Aluminaca produces 100-foot-long, 200-foot-long,...Ch. 4 - Each day, Eastinghouse produces capacitors during...Ch. 4 - During the next three months, a heating and...Ch. 4 - Gotham City National Bank is open Monday through...Ch. 4 - Based on Rothstein (1973). The Springfield City...Ch. 4 - Based on Charnes and Cooper (1955). Alex Cornby...Ch. 4 - City 1 produces 500 tons of waste per day, and...Ch. 4 - Based on Smith (1965). Silicon Valley Corporation...Ch. 4 - The Fresh Turkey Company produces two types of...Ch. 4 - The production line employees at Grummins Engine...Ch. 4 - Based on Lanzenauer et al. (1987). To process...Ch. 4 - Based on Robichek et al. (1965). The Korvair...Ch. 4 - Mackk Engine produces diesel trucks. New...Ch. 4 - Each hour from 10 A.M. to 7 P.M., Bank One...Ch. 4 - Owens-Wheat uses two production lines to produce...Ch. 4 - Rylon Corporation manufactures Brute cologne and...Ch. 4 - Sunco Oil has three different processes that can...Ch. 4 - Flexco produces six products in the following...Ch. 4 - Each week, Chemco can purchase unlimited...Ch. 4 - Bexter Labs produces three products: A, B, and C....Ch. 4 - Based on Franklin and Koenigsberg (1973). The city...Ch. 4 - Based on Carino and Lenoir (1988). Brady...Ch. 4 - Based on Dobson and Kalish (1988). Chandler...Ch. 4 - Based on Robichek et al. (1965). At the beginning...Ch. 4 - During each six-hour period of the day, the...Ch. 4 - Based on Glassey and Gupta (1978). A paper...Ch. 4 - Three bonds, as listed in the file P04_127.xlsx,...Ch. 4 - You have been assigned to develop a model that can...Ch. 4 - You have been assigned to develop a model that can...Ch. 4 - Keefer Paper produces recycled paper from paper...Ch. 4 - In this chapter, we give you the cost of producing...Ch. 4 - Discuss how the aggregate planning model could be...Ch. 4 - A large CPA firm currently has 100 junior staff...Ch. 4 - The employee scheduling model in this chapter was...Ch. 4 - Explain why it is problematic to include a...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions add
Describe how to account for organization costs.

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

Discuss the differences between centralized and decentralized decision making.

Managerial Accounting: The Cornerstone of Business Decision-Making

Discuss the traditional reasons for carrying inventory.

Cornerstones of Cost Management (Cornerstones Series)

Integrated Case NEW WORLD CHEMICALS INC. 16-16 FINANCIAL FORECASTING Sue Wilson, the new financial manager of N...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)