BUSI 1916 (Fall 2017) Linear Programming Using Excel Solver Bonus Question (2% bonus mark) Instructions: Solve the following linear programming problem using Excel Solver. You must clearly state all of the components of the problem, answer the question and provide a screenshot of Excel Solver showing the formulas to receive the full marks for the solution. The solution must be submitted through Blackboard (Assignment Submission section) in one file by Sunday, Oct 8 at 23:59. Question: The Durham Region Police has the following minimum daily requirements for police officers on duty: 00:00-4:00 25 4:00-8:00 20 8:00-12:00 65 12:00-16:00 75 16:00-20:00 45 20:00-24:00 60 Each police officer comes on duty at 0:00, 4:00, 8:00, 12:00, 16:00 or 20:00 and works for eight consecutive hours. Formulate the problem of finding the duty schedule that minimizes the total number of police officers required. Assume that the same schedule is repeated day after day. Solve the problem using Excel Solver