No paperwork. Use excel Lp solver and model step by step to understand everything.

9 Part A. (10 points) O'Clancy's Casino (OCC), in Buckins, Newfoundland, is open 24 hours a day, seven days a week. Along with all the other attractions and diversions, O'Clancy's operates a variety of gaming tables. Dealers at these tables are interchangeable. The OCC has the following daily requirements for dealers: Minimum of dealers 7 Tims 0100 - 0500 0500-0900 0900 - 1300 1300 - 1700 1700 - 2100 2100-0100 9 12 IS 17 A dealer may start work at the beginning of any one of the six shifts and, having begun, works.sight.consecutive hours Required: Solve this LP model by using Excel and computer Find the employee schedule that minimizes the total number of dealers required, meeting the minimum level of each shift's requirements. 9.Part B (10 points) Suppose in problem 9A, O'Clancy's Casino (OC) pays a wage differential depending on the hours worked. In particular, between midnight and 0700, it pays dealers $16 per hour, between 0700 and 1900 SIO per hour, and between 1900 and midnight S12 per hour. Required: Solve this LP model by using Excel and computer, Modify your formulation to problem 9A and determine the minimum cost shift schedule for Clancy's