please solve this in excel and answer thanks

Q5. (10 points) Manpreet Chowdry, a BBA graduate of Algoma University in 2017 is now the operations manager of Lake Superior Department Store. He has four employees available to assign to three departments in the store: lamps, sporting goods, and linen/clothing. Manpreet wants each of these departments to have at least one sales employee but not more than two. Theretore, two departments will be assigned one employee, and one department will be assigned two. Each sales employee has ditterent areas of product expertise which are reflected in the following average dally sales record for each sales employee from previous experience in each department. The operations manager wishes to know which sales employee(s) to assign to each department to maximize expected sales revenue. Continued on page 3 Q5. continued Sales per emplovee per department: Required: Construct and solve a LP model for this problem in Excel