To be done on Excel

2. (32 pts) A bank is attempting to determine where its assets should be invested during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans, and personal loans. The annual rates of return on each type of investment are known to be the following: bonds, 10%; home loans, 16%; auto loans, 13%; and personal loans; 21%. To ensure that the bank's portfolio is not too risky, the bank's investment manager has placed the following three restrictions on the bank's portfolio: - The amount invested in personal loans cannot exceed the amount invested in bonds. - The amount invested in home loans cannot exceed the amount invested in auto loans. - No more than 35% of the total amount invested can be in personal loans. Help the bank maximize the annual return on its investment portfolio. 3. (36 pts) Mexico City Bank of Commerce and Industry is a busy bank that has requirements for between 10 and 18 tellers depending on the time of day. Lunchtime, from noon to 2:00pm, is usually heaviest. The table below indicates the workers need at various hours that the bank is open. The bank now employs 12 full-time tellers, but many people are on its roster of available parttime employees. A part-time employee must put in exactly 4 hours per day but can start anytime between 9:00am and 1:00pm. Part-timers are a fairly inexpensive labor pool because no retirement or lunch benefits are provided for them. Full-timers, on the other hand, work from 9:00am - 5:00pm, but are allowed 1 hour for lunch. Half of the full-timers eat at 11:00am, the other half at noon. By corporate policy, the bank limits part-time hours to a maximum of 50% of the day's total hourly requirement. Part-timers earn $6 per hour (or $24 per day) on average, whereas fulltimers earn $70 per day in salary and benefits on average. The bank would like to set a schedule, using linear programming that would minimize its total man-power costs. It will lay off 1 or more of its full-time workers if it is profitable to do so