III. (13 pts.) The Strategic Planning Department (SPD) of GCMFI is planning to present to the Vice President for Finance on how to finance the proposed seven investment opportunities for GCMFI. The SPD was able to identify the possible sources of financing Table 1 shows the level of financing required for each investment opportunity (in PhP), the interest rate to be charged by cach financial institution, and the total line of credit (in PhP) cach of the financial institution is willing to lend GCMFI. Table 1 - Investment Opportunities and Financial Institutions Financial Interest Rates (per Investment Opportunity) (in %) Max Inst. B D E F G Credit Limit 1 16 18 18 19 15 17 16 150,000 15 14 17 18 15 18 20 100,000 3 17 15 16 15 16 18 18 120,000 4 18 16 19 20 18 16 19 330.000 5 20 19 15 16 17 19 17 170,000 Amount 100,000 120.000 80,000 90,000 110,000 140,000 70,000 Required 2 Since Financial Investment 4 has a credit limit of PhP330,000, the head of the SPD was able to convince the manager of the said financial institution to finance at most two investment opportunities. This consideration was approved provided that the second investment opportunity that may be financed by Financial Institution 4 should be limited to 1/3 of the total maximum credit limit and the interest rates for this second investments are 1 percentage point higher than what is shown in Table 1. Determine how each investment opportunity be financed that minimizes the total interest to be paid by GCMFI if the Financial Investment 4 is the only institution that may finance more than one investment opportunity. Identify the investment opportunity that should not be pursued. III. (13 pts.) The Strategic Planning Department (SPD) of GCMFI is planning to present to the Vice President for Finance on how to finance the proposed seven investment opportunities for GCMFI. The SPD was able to identify the possible sources of financing Table 1 shows the level of financing required for each investment opportunity (in PhP), the interest rate to be charged by cach financial institution, and the total line of credit (in PhP) cach of the financial institution is willing to lend GCMFI. Table 1 - Investment Opportunities and Financial Institutions Financial Interest Rates (per Investment Opportunity) (in %) Max Inst. B D E F G Credit Limit 1 16 18 18 19 15 17 16 150,000 15 14 17 18 15 18 20 100,000 3 17 15 16 15 16 18 18 120,000 4 18 16 19 20 18 16 19 330.000 5 20 19 15 16 17 19 17 170,000 Amount 100,000 120.000 80,000 90,000 110,000 140,000 70,000 Required 2 Since Financial Investment 4 has a credit limit of PhP330,000, the head of the SPD was able to convince the manager of the said financial institution to finance at most two investment opportunities. This consideration was approved provided that the second investment opportunity that may be financed by Financial Institution 4 should be limited to 1/3 of the total maximum credit limit and the interest rates for this second investments are 1 percentage point higher than what is shown in Table 1. Determine how each investment opportunity be financed that minimizes the total interest to be paid by GCMFI if the Financial Investment 4 is the only institution that may finance more than one investment opportunity. Identify the investment opportunity that should not be pursued