Question 2 The company would like to open up three managerial positions to handle customer service for the products. Each manager will be responsible for one product, and each product will be handled by one manager. There are four candidates for the three positions. Past records indicate the candidates' customer satisfaction rate when they handled inquiries about each of the three products: Customer satisfaction rate (%) Sofa Table Chair Candidate A 80 85 95 Candidate B 80 85 90 Candidate C 75 85 90 Candidate D 85 80 95 For example, if candidate A becomes the sofa manager, then 80% of customers will be satisfied when they have questions about the sofa. The company wants to maximize the total customer satisfaction rates over the three products. Use a binary integer programming to determine which candidates should become the managers of the products. a) Write a programming model that determines which candidate will be promoted to each of the three positions. b) Solve it on a spreadsheet for this problem.