Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.image text in transcribed

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 PM

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

IATF 16949 2016 Plus ISO 9001 2015 Audit Guide And Checklist With ISO 9001 Customer Specific Core Tools And CQI Requirments

Authors: Patrick Ambrose, Systemsthinking .works

2nd Edition

154703355X, 978-1547033553

More Books

Students also viewed these Accounting questions

Question

why don't you have to calculate terminal value?

Answered: 1 week ago

Question

What is management growth? What are its factors

Answered: 1 week ago