Use Problem 6-15 and Excel to solve Problem 6-32 please. Thank you :)

20. 6-32 Consider the staffing situation faced by the Gaubert Marketing Company in Problem 6-15. Ignore the salary and part-time information given in part (b) of that problem. Develop a schedule that meets the daily employee requirements and satisfices the following three weighted goals: Goal 1: Use at most 27 total employees weight = 50 Goal 2: Minimize the excess employees scheduled on Saturday weight = 30 Goal 3: Minimize the excess employees scheduled on Sunday weight = 20 3. 6-15 The Gaubert Marketing Company needs the following number of telemarketers on the phones during the upcoming week: Monday 23, Tuesday 16, Wednesday 21, Thursday 17, Friday 20, Saturday 12, and Sunday 15. Each employee works five consecutive days followed by 2 days off per week. How many telemarketers should be scheduled each day of the week to begin their five-day work week? The objective is to minimize the total number of employees needed to fulfill the daily requirements. a. Solve as an IP model. b. Additional information is now available for Gaubert. Daily pay from Monday through Friday is $90, pay for Saturday is $110, and Sunday workers earn $125. In addition, up to four people can be hired who will work Friday, Saturday, and Sunday. Their pay for this three-day week is $250. The new objective is to minimize total weekly labor costs. Revise the IP model and solve it