Please help excel solver is giving me errors!

The College of Continuous Education has recently developed a six sigma green belt certificate program that has three courses. Each course is a 45-hour course delivered over the evenings in a semester. Course Total Hours Demanded for Professors to Teach SSGB101 Define a Six Sigma Project 45 SSGB 102 Measure and Analyze 45 SSGB103 Improve and Control 45 Note that it is possible for one course to be taught by a number of professors. For example, it is possible that SSGB101 is taught by Professors for 10 hours, then Professor B for 20 hours, and then Professor D for 15 hours; or it can be taught by Professor D for 40 hours and then by Professor B for 5 hours; or by Professor S alone; or any combination of professor hours. The hours listed above are the least amount of total hours required to deliver a course. Three business professors are qualified to teach any of the sections in any of the three courses. However, due to the workload limit placed by Human Resources, they each has a limited number of hours that can be used to teach College of Continuous Education courses in the semester. Professor Hours Available to Supply CCE Courses this Semester Dr. S Dr. B Dr. D Note that the effectiveness of each professors teaching the three different courses is different. The effectiveness scores are as follows. Effectiveness of Professors teaching SSGB 101 is 2 Effectiveness of Professor B teaching SSGB101 is 2 Effectiveness of Professor D teaching SSGB101 is o Effectiveness of Professor S teaching SSGB102 is 2 Effectiveness of Professor B teaching SSGB 102 is 2 Effectiveness of Professor teaching SSGB102 is 6 Effectiveness of Professor S teaching SSGB 103 is 7 Effectiveness of Professor Bienati teaching SSGB 103 is 0 Effectiveness of Professor Donde teaching SSGB103 is 9 Fill out the following table with the above information: Effectiveness Professors Professor B Professor D SSGB101 SSGB 102 SSGB103 What are the best allotments of the three professors' available hours to the three courses to MAXIMIZE total effectiveness? Submit an excel file as attachment. 1. In the file, first write in plain English) what are your Objective Function Constraints Decision Variables? 2. Build an Excel Solver model to solve the above problem. Keep your solver inputs in the excel file. What are the best allotments of the three professors' available hours to the three courses