Instructions: Give a comprehensive quantitative analysis on the given situation. You must include graphs and tables for your presentation. Lastly, you must give a clear and concise recommendation to the manager of the firm based on the presented data analytics.
1. The SAMAHAN asked advice from the Accounting Department of Ateneo de Davao University on how to invest their collective savings amounting Php 200,000. The group has stipulated that the money must be put into either a stock fund or a money market fund and the annual return should be at least Php 14,000. The risk measure for each peso in the stock and money market fund were, 12 and 5 respectively. The rate of return for stock fund and market fund is 10% and 5%, respectively. Lastly, at least Php 40,000 must be in money market fund. The SAMAHAN would like to minimize the risk in investing in the stock and money market fund. In addition, the dean of the School of Business and Governance ask the SAMAHAN to give recommendation on the assignment of professors for the next semester. The group was able to gather the rating for each professor per subject. Find the best assignment of professors to courses to maximize the overall teaching rating. Professor Statistics Applied Mgt. Finance Macroeconomic S Dr. Andy Dr. Michelle Dr. Abby Dr. Mike 90 70 85 55 65 60 40 80 95 80 80 65 40 75 60 55 Write a thorough recommendation on the investment and professor assignment. Page 1 1 1 + 1. The SAMAHAN asked advice from the Accounting Department of Ateneo de Davao University on how to invest their collective savings amounting Php 200,000. The group has stipulated that the money must be put into either a stock fund or a money market fund and the annual return should be at least Php 14,000. The risk measure for each peso in the stock and money market fund were, 12 and 5 respectively. The rate of return for stock fund and market fund is 10% and 5%, respectively. Lastly, at least Php 40,000 must be in money market fund. The SAMAHAN would like to minimize the risk in investing in the stock and money market fund. In addition, the dean of the School of Business and Governance ask the SAMAHAN to give recommendation on the assignment of professors for the next semester. The group was able to gather the rating for each professor per subject. Find the best assignment of professors to courses to maximize the overall teaching rating. Professor Statistics Applied Mgt. Finance Macroeconomic S Dr. Andy Dr. Michelle Dr. Abby Dr. Mike 90 70 85 55 65 60 40 80 95 80 80 65 40 75 60 55 Write a thorough recommendation on the investment and professor assignment. Page 1 1 1 +
