Loading
Home › Finance Help › Develop a linear programming model to minimize the total ...
Status: Completed
 View Work
Develop a linear programming model to minimize the total dollars needed to be invested now to meet the expansion cash needs in the next 8 years. Hint: this is the objective function. Use Excel Solver, solving method: Simplex LP. How many units of each security 1, 2, and 3 should the corporation purchase? What is the investment amount in each security 1, 2, and 3 in year 1? How much should the corporation place in the savings account in each of the 8 years? Assuming the corporation currently has $1.8 Million available cash to invest and given the cash needs for the expansion, is the investment plan that you developed feasible? Explain your answer and provide reasoning.
Date Posted: 13/05/2021
Category: Finance
Due Date: 14/05/2021
Instruction
Develop a linear programming model to minimize the total dollars needed to be invested now to meet the expansion cash needs in the next 8 years. Hint: this is the objective function. Use Excel Solver, solving method: Simplex LP. How many units of each security 1, 2, and 3 should the corporation purchase? What is the investment amount in each security 1, 2, and 3 in year 1? How much should the corporation place in the savings account in each of the 8 years? Assuming the corporation currently has $1.8 Million available cash to invest and given the cash needs for the expansion, is the investment plan that you developed feasible? Explain your answer and provide reasoning.
Attached
Download File 1 (docx)
Tutor Uploads
Download File 1 (xlsx)
Download File 2 (docx)
Bidders
Robert_d_308 4 years, 12 months ago
Rated 9.37 earned 62524.46 around 2184 assignments.
Hello! I can work on this task asap. I can also help you with your whole summer class at a discount!
$50.00
  • Hello, what eta could you complete?
    User_37275 | May 13, 2021, 16:20 PM
  • Hey. It's too soon.
    Robert_d_308 | May 13, 2021, 16:21 PM
  • What does that mean? Can you complete?
    User_37275 | May 13, 2021, 16:23 PM
  • Nop
    Robert_d_308 | May 13, 2021, 16:24 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
mutungamatee1 4 years, 12 months ago
Rated 9.85 earned 38939.98 around 1291 assignments.
Hi, I am an expert in this particular field and I’m available and happy to work on the assignment. Kindly, hire me for the best results!
$80.00
  • How soon do you need it completed?
    mutungamatee1 | May 13, 2021, 16:19 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
wekeh 4 years, 12 months ago
Rated 9.46 earned 34428.30 around 900 assignments.
Hello, I have read the paper's instructions and requirements and they are pretty clear and manageable. I am an expert in this field with a vast experience and I promise to deliver excellent work. Kindly hire me for an exceptional non plagiarized paper within the stipulated time.
$45.00
  • When can you complete
    User_37275 | May 13, 2021, 16:24 PM
  • will be done before due time friend
    wekeh | May 13, 2021, 16:26 PM
  • Hello, With this assignment, I will need a snippet copy of the excel for this assignment
    User_37275 | May 13, 2021, 16:30 PM
  • okay friend. let me get down to work
    wekeh | May 13, 2021, 16:36 PM
  • Hello I just wanted to get an update on the assignment
    User_37275 | May 14, 2021, 20:46 PM
  • hello , i am almost done, hope we are not late
    wekeh | May 14, 2021, 20:47 PM
  • Nope we are not
    User_37275 | May 14, 2021, 21:07 PM
  • Hello Friend I have completed the assignment confirm and let me know if there's a query. Please leave a good feedback and rate me with 11 stars. They mean a lot to me. Thank you
    wekeh | May 15, 2021, 00:34 AM
  • Thank you so much! I will give you all the stars for sure!
    User_37275 | May 16, 2021, 04:38 AM
  • Thank you so much friend. Please help me rate my work with an 11 star and leave a positive feedback which will be of great help to me. It has been a pleasure working with you, kindly do not hesitate to ask me for help in future. Success in your work, regards.
    wekeh | May 16, 2021, 06:19 AM
  • Hello, I have another assignment for this same class that I am looking for help with. You did such a good job with my first assignment that I would like to use you again.
    User_37275 | May 17, 2021, 03:15 AM
  • Hello friend.I am available for the same. When will it be ?
    wekeh | May 17, 2021, 03:38 AM
  • I can submit the request right now and it is not due until Friday
    User_37275 | May 17, 2021, 03:41 AM
  • Okay friend. I'm ready. Please consider some bonus on this.you know my work is always the best.
    wekeh | May 17, 2021, 03:43 AM
  • Yes I will for sure
    User_37275 | May 17, 2021, 03:44 AM
  • Thank you friend.post it right now.I am ready to start
    wekeh | May 17, 2021, 03:49 AM
  • I posted it
    User_37275 | May 17, 2021, 03:53 AM
  • helllo friend, i hope you are doing well, is there any work that i can help in currently, please feel free to consult me if any need arise, i am very willing to help, thank you in advance
    wekeh | Jun 02, 2021, 17:24 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
ExpertProfessor 4 years, 12 months ago
Rated 9.75 earned 913.97 around 27 assignments.
I am a quality-driven professor in academics, who is ready to deliver topnotch, well researched, grammatical and plagiarism free assignments. As a writer proficient in several disciplines of academic writing like NURSING, PSYCHOLOGY, PHILOSOPHY,HUMAN RESOURCE MANAGEMENT, BUSINESS STUDIES, HISTORY, SOCIOLOGY, ETHICS,GOVERNANCE, MANAGEMENT,FINANCE, POLITICAL SCIENCE, CRIMINAL JUSTICE, LAW, ENGLISH LITERATURE, ETHICS, COMMUNICATIONS, HEALTHCARE.GEOLOGY, my priority is to deliver quality and timely work. Be assured that I will always follow the laid down instructions. NO PLAGIARISM OR GRAMMATICAL ERRORS. You can trust me to deliver well researched and scholarly assignments. I am your savior in meeting those tight deadlines.
$15.00
  • Hello friend, let me help you with this assignment. I assure you of high quality assignment. I'm ready to start working in it right now. Your assignment is in the safest hands. I'm a professional tutor who takes nothing less than good grade. I follow all the instructions of the student to ensure i provide high quality work.
    ExpertProfessor | May 13, 2021, 16:22 PM
  • Hello, thanks for the job invite. I bring forth excellent mastery of content and expertise critical to articulate and work on this assignment appropriately. Kindly hire me for grade A task, Zero plagiarism and timely response. Thank you.
    ExpertProfessor | May 13, 2021, 16:27 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
financeville 4 years, 12 months ago
Rated 9.22 earned 28485.23 around 697 assignments.
Hello friend, I have gone through the paper instructions and requirements and they are pretty clear and manageable. I am an expert in this field with a vast experience and I promise to deliver excellent work. Kindly hire me for an exceptional non plagiarized paper within the stipulated time.
$50.00
  • When can you complete
    User_37275 | May 13, 2021, 16:24 PM
  • In less than 10 hours friend. I'll manage in 8 hour or so
    financeville | May 13, 2021, 16:27 PM
  • Kindly assign so that I can start working on it right away
    financeville | May 13, 2021, 16:29 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}
 
 
smunga 4 years, 12 months ago
Rated 9.79 earned 56286.74 around 1391 assignments.
Hello friend, I'm a quality-driven writer with special technical skills and vast experience in the field. A plagiarism-free paper and impeccable quality content is what I deliver. Timely delivery and originality are guaranteed. Kindly allow me to do this paper for you and I guarantee you a quality paper and good grades.
$40.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[5] $}

{$ showNewChatSuccessMsg[5] $}
Unable to send Message: {$ showChatProcessErrorMsg[5] $}