Answered step by step
Verified Expert Solution
Question
1 Approved Answer
After Susan Wong graduated from State University with a degree in management science, she went to work for a computer systems development firm in the
After Susan Wong graduated from State University with a degree in management science, she went to work for a computer systems development firm in the Washington, DC area. As a student at State, Susan paid her normal monthly living expenses for apartment rent, food, and entertainment out of a bank account set up by her parents. Each month they would deposit a specific amount of cash into Susans account. Her parents also paid her gas, tele phone, and bank credit card bills, which were sent directly to them. Susan never had to worry about things like health, car, homeowners and life insurance; utilities; drivers and car licenses; magazine subscriptions; and so on Thus, while she was used to spending within a specific monthly budget in college, she was unprepared for the irregular monthly liabilities she encountered once she got a job and was on her own. In some months Susans bills would be modest and she would spend accordingly, only to be confronted the next month with a large insurance premium, or a bill for property taxes on her condominium, or a large credit card bill, or a bill for a magazine subscription, and so on the next month. Such unexpected expenditures would result in months when she could not balance her checking account; she would have to pay her bills with her bank credit card and then pay off her accumulated debt in installments while incurring high interest charges. By the end of her first year out of school, she had hoped to have some money saved to begin an investment program, but instead she found herself in debt. Frustrated by her predicament, Susan decided to get her financial situation in order. First, she sold the condominium that her parents had helped her purchase and moved into a cheaper apartment. This gave her enough cash to clear her outstanding debts, with $ left over to start the new year with. Susan then decided to use some of the management science she had learned in college to help develop a budget. Specifically, she decided to develop a linear programming model to help her decide how much she should put aside each month in shortterm investments to meet the demands of irregular monthly liabilities and save some money. First, Susan went through all her financial records for the year and computed her expected monthly liabilities for the coming year,as shown in the following table: Susans aftertaxesandbenefits salary is $ per year, which she receives in equal monthly paychecks that are deposited directly into her bank account. Susan has decided that she will invest any money she doesnt use to meet her liabilities each month in either month,month,or month shortterm investment vehicles rather than just leaving the money in an interestbearing checking account. The yield on month investments is per year nominal; on month investments, the yield is per year nominal; and on a month investment, the yield is per year nominal. As part of her investment strategy, any time one of the shortterm investments comes due, she uses the principal as part of her budget, but she transfers any interest earned to another longterm investment which she doesnt consider in her budgeting process For example, if she has $ left over in January that she invests for months, in April, when the investment matures, she uses the $ she originally invested in her budget, but any interest on the $ is invested elsewhere. Thus the interest is not compounded over the course of the year. Susan wants to develop a linear programming model to maximize her investment return during the year so she can take that money and reinvest it at the end of the year in a longerterm investment program. However, she wants all her shortterm investments to mature by the end of the year; in other words, she cannot continue to put money toward the end of the year in investments that wont mature until the following year. Her budgeting process will continue to the next year, so she can take out any surplus left over after December and reinvest it in a longterm program if she wants to A Help Susan develop a model for the year that will meet her irregular monthly financial obligations while achieving her investment objectives and solve the model. B How much money will be available for Susan at the end of the year to invest in her alternative longerterm investments.
After Susan Wong graduated from State University with a degree in management science, she went to work for a computer systems development firm in the Washington, DC area. As a student at State, Susan paid her normal monthly living expenses for apartment rent, food, and entertainment out of a bank account set up by her parents. Each month they would deposit a specific amount of cash into Susans account. Her parents also paid her gas, tele phone, and bank credit card bills, which were sent directly to them. Susan never had to worry about things like health, car, homeowners and life insurance; utilities; drivers and car licenses; magazine subscriptions; and so on Thus, while she was used to spending within a specific monthly budget in college, she was unprepared for the irregular monthly liabilities she encountered once she got a job and was on her own. In some months Susans bills would be modest and she would spend accordingly, only to be confronted the next month with a large insurance premium, or a bill for property taxes on her condominium, or a large credit card bill, or a bill for a magazine subscription, and so on the next month. Such unexpected expenditures would result in months when she could not balance her checking account; she would have to pay her bills with her bank credit card and then pay off her accumulated debt in installments while incurring high interest charges. By the end of her first year out of school, she had hoped to have some money saved to begin an investment program, but instead she found herself in debt. Frustrated by her predicament, Susan decided to get her financial situation in order. First, she sold the condominium that her parents had helped her purchase and moved into a cheaper apartment. This gave her enough cash to clear her outstanding debts, with $ left over to start the new year with. Susan then decided to use some of the management science she had learned in college to help develop a budget. Specifically, she decided to develop a linear programming model to help her decide how much she should put aside each month in shortterm investments to meet the demands of irregular monthly liabilities and save some money. First, Susan went through all her financial records for the year and computed her expected monthly liabilities for the coming year,as shown in the following table: Susans aftertaxesandbenefits salary is $ per year, which she receives in equal monthly paychecks that are deposited directly into her bank account. Susan has decided that she will invest any money she doesnt use to meet her liabilities each month in either month,month,or month shortterm investment vehicles rather than just leaving the money in an interestbearing checking account. The yield on month investments is per year nominal; on month investments, the yield is per year nominal; and on a month investment, the yield is per year nominal. As part of her investment strategy, any time one of the shortterm investments comes due, she uses the principal as part of her budget, but she transfers any interest earned to another longterm investment which she doesnt consider in her budgeting process For example, if she has $ left over in January that she invests for months, in April, when the investment matures, she uses the $ she originally invested in her budget, but any interest on the $ is invested elsewhere. Thus the interest is not compounded over the course of the year. Susan wants to develop a linear programming model to maximize her investment return during the year so she can take that money and reinvest it at the end of the year in a longerterm investment program. However, she wants all her shortterm investments to mature by the end of the year; in other words, she cannot continue to put money toward the end of the year in investments that wont mature until the following year. Her budgeting process will continue to the next year, so she can take out any surplus left over after December and reinvest it in a longterm program if she wants to A Help Susan develop a model for the year that will meet her irregular monthly financial obligations while achieving her investment objectives and solve the model. B How much money will be available for Susan at the end of the year to invest in her alternative longerterm investments.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started