Reference no: EM132296459

[Business Analytics/ Operational Management] Report to Management Format

Professional traders can find investment opportunities from day-to-day financial markets. Very often an investment strategy is required that determines how the investment should be planned across different days so that it can eventually lead to some profits. After months of study on the daily stock market, the traders of the international firm QuantTradeX have identified which stocks they should invest so that they can receive almost-predictable returns. In particular, by investing in these stocks they have the following proprietary trading strategy. At the start of every day of the week (Monday through Friday), they can decide how much to invest on that day, say, X dollars. If in the next day they are able to match that initial investment (the X dollars) with another investment of half of that amount, i.e. X/2 dollars, then they can expect to receive a total return on the third day that doubles the initial amount of the investment, i.e. a total return of 2X dollars. For example, if the trader invests X dollars on Monday and another X/2 dollars on Tuesday, which in total is 1.5X dollars, they can expect to receive 2X dollars on Wednesday, which gives them a gain of 0.5X dollars in two days. However, any initial investment that is not matched on the subsequent day will lose its whole value. Thus, considering any investment without a subsequent fund to match might not be meaningful.

Besides the stock market, Foreign Exchange (FX) market is another popular financial market that daily traders actively participate. Although the firm QuantTradeX used to invest mostly in the stock market, they cannot let go any good investment opportunity even if it is in the FX market. The firm has recently noticed that whenever the number of travelers increases during the weekend, the FX rate tends to increase also in the following few days and go back to normal by the end of the week. They believe that in this case if they are able to invest Y dollars in the FX market on the Monday that follows right after the weekend, they can receive its doubled amount, i.e. 2Y dollars next day (Tuesday). If the investment is made on Tuesday, they can receive 1.5Y dollars next day (Wednesday). However, if the investment is made on Wednesday, they only receive 1.2Y dollars in two days, i.e. Friday. No investment in FX markets will be considered for the days after Wednesday. On any given day of a week, the traders of the firm can re-invest any return they receive from the previous investments made in the same week. If there is any amount in the firm's account that is not invested in any of the financial markets, that amount can accrue 1% of daily interest through money markets Every Sunday night, the traders of the firm need to determine an investment plan for the following weekdays, i.e. how money in their account should be invested in each day. The plan is considered successful if it maximizes the amount of money they can have in their account by the end of the coming Saturday. It is assumed that on Saturday they can still receive returns from earlier investments in the same week. Today is another Sunday that the firm needs to make the investment plan, and it has been just confirmed that the number of travelers has increased significantly this weekend. The firm currently has 1 million in their account.

Task:

You are hired fairly recently and assigned to help the traders determine a successful investment plan for the coming week. Report how you solve this problem by formulating a Linear Programming (LP) model. Besides following the "report to management" format, you should provide all the details, which includes but are not limited to the LP model, i.e. decision variables, constraints, and objective function, with detailed explanations, the Excel sheets including your LP model, and answer and sensitivity reports.

Moreover, your manager has the following questions for you, and you should provide your answers based on the Excel sensitivity report.

a) If the firm can borrow some more money today (so that more cash for the following week's investment), and for each dollar they borrow they have to return by the coming Saturday its doubled amount, i.e. return 2Z dollars for Z dollars borrowed, would you recommend the firm to borrow the money or not?

b) The firm suspects that the daily interest rate may rise around the end of Friday (so that any dollar carried over from Friday to Saturday will accrue a higher interest). Should they plan to save some more money throughout the week so that they can have more saving in their account by the end of Friday? Provide detailed answers and analysis for any possible rise of the interest rate.

c) The manager foresees that there is some possibility the firm may need to transfer out some money from the account for some non-investment purposes on Wednesday. He wonders how would this impact the performance of the investment plan. Provide detailed answers and analysis based on the sensitivity report for any possible amount of transfer.