Answer the following question

These data are in the file MarkerStates. Formulate her investment problem as a linear program and solve it using Excel Solver. How much should she invest in cach security? Note: It is possible to purchase fractional shares. 24. A financial manager is managing a cash fund. H arious certificates of deposit, also known as CDs, as listed in the following table: is investment alternatives available are Investment 1-month CD 3-month CD 6-month CD Yield 0.5% 1.75% 2.3% Availability Beginning of each month Beginning of Months 1, 2, 3, 4 Beginning of Month 1 However, he also must ensure that sufficient funds are available to pay company expen ditures over the next six months. The following table lists the net expenditures sands of dollars) that the manager is obligated to cover (cash amounts in parent indicate a net inflow of cash rather than outflow). DATA hesis CashManagement Month Net Expenditures ($1,000s) $45 ($11) $25 ($22) $43 $15) The cash on hand to invest at the start of month 1 is $200,000 and the minimum cash required to be available at the end of month 6 is $100,000. Develop and solve a linear program that will recommend how to invest to maximize the amount of interest income accrued over the next six months while satisfying all financial commitments. Chapter 12 Linear Optimization Models (Hint: Investment time starts at the beginning of the month and returns at the end of the month. For example, money invested in a 1-month CD in month 1 will be invested at the beginning of month 1 and returned with interest at the end of month 1. Likewi se, money invested in a 3-month CD at the start of month 1 will be returned with interest at the end of month 3.) 25. A produce company supplies organically grown apples to four regional specialty stores. After the apples are collected at the company's orchard, they are transported to any of three preparation centers where they are prepared for retail (by undergoing extensive cleaning and then packaging). After the apples are prepared, they are shipped to the specialty stores. Due to the fragility of the product, the cost of transporting this nrranI fruit is rather high These data are in the file MarkerStates. Formulate her investment problem as a linear program and solve it using Excel Solver. How much should she invest in cach security? Note: It is possible to purchase fractional shares. 24. A financial manager is managing a cash fund. H arious certificates of deposit, also known as CDs, as listed in the following table: is investment alternatives available are Investment 1-month CD 3-month CD 6-month CD Yield 0.5% 1.75% 2.3% Availability Beginning of each month Beginning of Months 1, 2, 3, 4 Beginning of Month 1 However, he also must ensure that sufficient funds are available to pay company expen ditures over the next six months. The following table lists the net expenditures sands of dollars) that the manager is obligated to cover (cash amounts in parent indicate a net inflow of cash rather than outflow). DATA hesis CashManagement Month Net Expenditures ($1,000s) $45 ($11) $25 ($22) $43 $15) The cash on hand to invest at the start of month 1 is $200,000 and the minimum cash required to be available at the end of month 6 is $100,000. Develop and solve a linear program that will recommend how to invest to maximize the amount of interest income accrued over the next six months while satisfying all financial commitments. Chapter 12 Linear Optimization Models (Hint: Investment time starts at the beginning of the month and returns at the end of the month. For example, money invested in a 1-month CD in month 1 will be invested at the beginning of month 1 and returned with interest at the end of month 1. Likewi se, money invested in a 3-month CD at the start of month 1 will be returned with interest at the end of month 3.) 25. A produce company supplies organically grown apples to four regional specialty stores. After the apples are collected at the company's orchard, they are transported to any of three preparation centers where they are prepared for retail (by undergoing extensive cleaning and then packaging). After the apples are prepared, they are shipped to the specialty stores. Due to the fragility of the product, the cost of transporting this nrranI fruit is rather high