Reference no: EM131127653

A financial services company processes applications for home mortgages and commercial loans for its clients. Both types of applications are first reviewed by the screening department. It takes this department 30 minutes to review each home mortgage application and 120 minutes to review each commercial loan application. After the screening, a credit check is performed, which takes 2 hours for each type of application. Finally, the applications are sent to a loan officer for a final evaluation. It takes a loan officer 1.5 hours to review a mortgage application and 2.5 hours to review a commercial loan application. The company also wants to ensure that it processes at least 100 loans and 150 mortgages each week. The company currently employs 15 staff members in the screening department, 25 staff members in the credit check department, and 25 loan officers. Each employee receives the same salary and works 40 hours per week. The company receives $350 for processing each home mortgage application and $450 for processing each commercial loan application. In order for the process to be effective, the company restricts the maximum number of applications (mortgage and loan applications together) to no more than 450 per week.

Based on the information provided and assuming unlimited demand, set up and solve a profit-maximizing linear programming formulation using Excel.