In the problem on excel :1.What are the decision variables 2.What is the objective functions 3. What are the constraints and explain Congratulations. You have just won $750,000 and, since you have taken ADMN2607-Management Science with Professor Brandon Mackinnon, you have decided to use yourknowledge from all of these topics to develop a list of possible investment(s) that you will investall of the $750,000 that you have won.The expected return of each of the 6 possible investments that you are considering investing in,and their Expected Rate of Return over the next year are in the table below.InvestmentAmazon Inc (USA Shares)Royal Bank of Canada (Canadian Shares)Nike Inc (USA Shares)Telus Corporation (Canadian Shares)Snap Inc (USA Shares)Nestle SA (Switzerland Shares)Expected Rateof Return13.5%7.4%10.0%6.1%3.0%4.8%You remember from Finance class, that it is important to have a diversified portfolio, andtherefore have come up with the following guidelines on how to invest your money:• The total invested in USA Shares should be at least 10% but no more then 45% of thetotal amount invested.Not more then $275,000 invested in Nestle SA• At least $220,000 invested in a combination of the 2 Canadian Stocks.There must be a minimum of $50,000 invested in each non-USA company.• The amount invested in Snap Inc must equal the amount invested in Amazon Inc.The amount in RBC is not to be more then four times greater then the amount invested inAmazon.Together, the amount invested in all USA shares, must not be more then the amountinvested in Nestle.The amount invested in Nestle SA must be exactly double plus $5,000 more then TelusCorporation.Subject to these constraints, your goal is to maximize projected returns on your investmentportfolio. Formulate this problem on Excel and solve for the amount of money that should beinvested in each of the 5 different investments while making as high of a return as possible.

Answered: Image /qna-images/answer/ce624686-3a31-417d-9f01-d25c0e42a371.jpg

Answered: n the problem on excel : 1.What are the…

n the problem on excel : 1.What are the decision variables 2.What is the objective functions 3. What are the constraints and explain

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Using the data in the following table, calculate the return for investing in Boeing stock (BA) from January 2, 2008, to January 2, 2009, and also from January 3, 2011, to January 3, 2012, assuming all dividends are reinvested in the stock immediately. Historical Stock and Dividend Data for Boeing Date Price Dividend Date Price Dividend 1/2/2008 86.62 1/3/2011 66.40 2/6/2008 79.91 0.40 2/9/2011 72.63 0.42 5/7/2008 84.55 0.40 5/11/2011 79.08 0.42 8/6/2008 65.40 0.40 8/10/2011 57.41 0.42 11/5/2008 49.55 0.40 11/8/2011 66.65 0.42 1/2/2009 45.25 1/3/2012 74.22 Return from January 2, 2008, to January 2, 2009 is how much? (Round to two decimal places.)
You have recently won the super jackpot in the WashingtonState Lottery. On reading the fine print, you discover that you have the following twooptions:a. You will receive 31 annual payments of $250,000, with the first payment beingdelivered today. The income will be taxed at a rate of 28 percent. Taxes will bewithheld when the checks are issued.b. You will receive $530,000 now, and you will not have to pay taxes on this amount.In addition, beginning one year from today, you will receive $200,000 each yearfor 30 years. The cash flows from this annuity will be taxed at 28 percent.Using a discount rate of 7 percent, which option should you select?
Assume that you decide to go into real estate investment. However, you need a property manager to represent you and work with tenants. Consider the various risks that you face as an investor. How can your property manager help you mitigate those risks? Keeping this in mind, write a classified ad for your new property manager. Be sure to include minimum and preferred qualifications, key responsibilities, and specific information about the property/properties you need managed.
You work in finance and your company is considering buying another company for $10.6 million. Your company does not have $10.6 million in cash and has asked you to evaluate different types of short-term and long-term financing opportunities. For this assignment, you will have to conduct research to see what options are available for short-term and long-term financing opportunities. Explain why you chose the option you selected and what the short-term and long-term effects of that option will be. Please be specific.
Why might a manager intentionally classify a trading security as an available-for-sale security? Select one: O A. The manager may wish to prevent an increase in value from being reported in shareholders' equity. B. The manager may wish to prevent a decline in value from being reported in shareholders' equity. C. The manager may wish to prevent a decline in value from being reported on the income statement. D. The manager may wish to prevent an increase in value from being reported on the income statement.
Based on the foregoing and the result of your audit, answer the following: (Ignore income tax implications.) The unappropriated retained earnings on December 31, 2020, is B. P224,965 A. P181,765 C. P232,165 D. P289,765
Comerstone Solutions, LLC. is deciding between developing an advanced thought-activated software, or a basic voice-activated software. Since the thought-activated software is complicated, it only has a 30% chance of actually going through to a successful launch, but would generate revenues of $50million if launched. The voice-activated software is simple and hence has a 80% chance of being launched but only generates a revenue of $10million. Assume that an unsuccessful product launch will generate no revenue. The complicated technology costs 10million, whereas the simple technology costs 2million. (However...) Suppose Cornerstone Solutions, LLC. learns that the complicated technology can be made more stable with a few tweaks increasing the price to 15.5 million and increasing the probability of a launch to 50%. Given the new costs and probabilities of launch for the complicated software, which technology would the firm rather invest in now? O The simple voice-activated software O The…
The CEO of a company is considering submitting a bid to purchase property that will be sold by sealed bid. His initial judgment is to submit a bid of $5 million. Based on his experience, he estimates that a bid of $5 million will have a 0.2 of being the highest bid and securing the property for the company. The current date is June 1. Sealed bids must be submitted by August 15. The winning bid will be announced on September 1. If the company submits the highest bid and obtain the property, it plans to build and sell a complex of luxury condominiums. However, a complicating factor is that the property is currently zoned for single-family residences only. The CEO believes that a referendum could be placed on the voting ballot in time for the November elections. Passage of the referendum would change the zoning property and permit construction of luxury condominiums. The sealed bid procedure requires the bid to be submitted with a certiﬁed check for 10% of the amount bid. If the bid is…
You are managing a construction project. During your risk identificationinterviews you learn that there has been a string of construction site theftsover the past few months in the area where your will be building your project.The team agrees that it’s unlikely that people will be able to steal from yoursite. Even if thieves could get around your security, it’s even more unlikelythat your project will lose a significant amount of material if a theft doesoccur. You decide to monitor the risk from time to time to be sure that itcontinues to have a low probability and impact. Where do you record the riskso that you don’t lose track of it?A. In a triggerB. In the Probability and Impact MatrixC. In the Monte Carlo analysis reportD. On a watch list Which of the following is NOT a characteristic of the Project ManagementPlan?A. Collection of subsidiary plansB. Formal, written communicationC. A bar chart that shows the order of tasks and their resource assignmentsD. Must be approved by project…
What is the main reason lenders pay borrowers' property taxes through a pre-paid escrow account? It prevents a tax lien from being applied to the home. The tax lien would be senior to the mortgage lien. It prevents the borrower from refinancing with another lender because they would lose all of their escrow funds. It allows the lender to earn interest on the pre- paid tax money as itsits in the account. It allows the lender to take advantage of corporate tax deductions.
Answer on these two senarios: Senario 1: You have decided to form a new start-up company developing applications for the iPhone. Give examples of the three distinct types of financial decisions you will need to make. Senario 2: You are the CEO of a company and you are considering entering into an agreement to have your company buy another company. You think the price might be too high, but you will be the CEO of the combined, much larger, company. You know that when the company gets bigger, your pay and prestige will increase. What is the nature of the agency conflict here and how is it related to ethical considerations?
Perform the task below. Suppose you have savings in the bank that you want to invest in stocks and bonds instead of setting up in a new business. Write one to two paragraphs discussing what method you can use to make the investment and explain the reasons for your decision.