PLEASE USE EXCEL. MAKE SURE TO INCLUDE WHAT IS ACTUALLY INSIDE THE CELL (THE EXPRESSION, NOT JUST NUMBER). PLEASE INCLUDE SOLVER SCREENSHOT WITH CONSTRAINTS, OBJECTIVE FUNCTION CELL TO BE MAX/MIN, AND VARIABLES TO BE CHANGED TO ENSURE LIKE, THANKS

Problem #5 (20 points) 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. Your task is to develop a schedule that meets the daily employee requirements and satisfices the following three weighted goals: Goal 1 (weight = 50): use at most 27 total employees Goal 2 (weight = 30): minimize the excess employees scheduled on Saturday Goal 3 (weight = 20): minimize the excess employees scheduled on Sunday Formulate the given decision problem as an integer linear goal program, determining how many telemarketers should be scheduled each day of the week to begin their five-day work week. Use a non-preemptive (i.e., weights for the goals) goal programming approach in your mathematical formulation's objective function. Setup/solve the problem using Microsoft Excel with Analytic Solver (or Open Solver) OR Gurobi Python (or Pyomo). For the mathematical formulation