(50pts) Dell's call center is developing a staffing plan. The table below lists the minimum number of representatives required during each of the four periods in a day. Representatives can work 12 hour shifts or 18 hour shifts. Pay is $24 / hour for the first 12 hours of work, and $36 /hour for any additional hours. a) Formulate a Linear Program that can be used to develop a staffing plan that minimizes the cost while meeting requirements. Clearly specify the decision variables, objective function, and constraints. b) Create a spreadsheet model for this problem and solve it using Solver. c) What is the optimal solution? (50pts) Dell's call center is developing a staffing plan. The table below lists the minimum number of representatives required during each of the four periods in a day. Representatives can work 12 hour shifts or 18 hour shifts. Pay is $24 / hour for the first 12 hours of work, and $36 /hour for any additional hours. a) Formulate a Linear Program that can be used to develop a staffing plan that minimizes the cost while meeting requirements. Clearly specify the decision variables, objective function, and constraints. b) Create a spreadsheet model for this problem and solve it using Solver. c) What is the optimal solution