Question
2. At the beginning of month 1, a company has $80,000 in cash. At the beginning of months 1 through 6, this company receives some
2. At the beginning of month 1, a company has $80,000 in cash. At the beginning of months 1 through 6, this company receives some revenues, after which it pays its bills. The expected revenue and expenses for each month are recorded in the file GS 3.xlsx. Any cash that is left over after the bills are paid can be invested for 1 month at an interest rate of 0.2% per month; for 2 months at 0.6% per month; for 3 months at 1.0%; for 4 months at 1.4%; for 5 months at 1.8%; or for 6 months at 2.2%. Starting with the shell provided in GS 3.xlsx, formulate and then solve an LP model that will determine an investment strategy that maximizes the available cash for this company at the beginning of month 7.
1 Problem 2 3 Expected revenues and bills 4 Month 5 Revenues $60,000 $70,000 $80,000 $60.00 $160,000 S100.000 6 Bills $100,000 $70,000 $120,000 $50,000 $100,000 $110,000 8 Interest rates per month Rate 9 M invested onths 0.20% 10 0.60% 1.00% 12 1.40% 13 1.80% 14 2.20% 17 initial cash $80.000 18 19 Investment strategy 1 2 3 4 5 6 7 20 Month 21 Cash at beginning of month 22 Cash after revenue 23 cash after bills are paid 24 invested for one month 25 Invested nth two mo 26 Invested for three months 27 Invested for four months 28 Invested for five months 29 Invested 30 Total invested 31 cash to invest 32 33 35 Prob 1 Prob 2 Sheet2 Sheet3 Sheet 4 Sheet5 Sheet6 Sheet7 Sheets sheetg a Ask me anything .09 PMStep 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