Question: Please I need a solution using Matlab and Mathematical formulation with explanation. Thanks. I need them so much, please. Task 3 Supermarket Staff Scheduling A
Please I need a solution using Matlab and Mathematical formulation with explanation. Thanks. I need them so much, please.
Task 3 Supermarket Staff Scheduling A busy supermarket is open 24 hours daily. It has a set of 20 checkout counters, though the actual number of checkouts needed ranges from 2 to 20, depending on the time of day. The number of staff needed to provide a satisfactory service varies at different hours as summarized in the following Table: Number of counters/staff needed 12 10 16 Time Periods 9:00 am - 10:00 am 10:00 am - 1:00 pm 1:00 pm - 3:00 pm 3:00 pm - 6:00 pm 6:00 pm - 9:00 pm 9:00 pm - 3:00 am 3:00 am - 9:00 am 14 20 5 4 The supermarket employs 10 full-time staff and a large number of part-time staff. Part-time staff typically can work a 6-hour shift every day and can start on the hour between 9:00 am to 1:00 pm, or at 3:00 pm, 6:00 pm, 9:00 pm or 3:00 am. Full-time staff work at most 40 hours per week between 9:00 am to 5:00 pm with a daily wage of 90 for 8 hours per day, while part-time workers are paid at a standard rate of 8 per hour (i.e., 48 per day for 6 hours). The company policy only permits that up to 80% of the total working hours of any day to be part-time hours. The main task is to schedule the staff so that the total staff costs are minimized on a daily basis. Formulate the scheduling problem in terms of a linear programming problem with a correct objective and all appropriate constraints. Explain in detail why your mathematical formulation is appropriate, including any assumptions that you may have used. Solve your staff scheduling problem using either Excel Solver or Matlab (intlinprog) / Octave (glpk). Summarize your solution procedure (including screenshots if appropriate) and present the main results with a brief discussion. Check if all the required numbers of counters are met. Task 3 Supermarket Staff Scheduling A busy supermarket is open 24 hours daily. It has a set of 20 checkout counters, though the actual number of checkouts needed ranges from 2 to 20, depending on the time of day. The number of staff needed to provide a satisfactory service varies at different hours as summarized in the following Table: Number of counters/staff needed 12 10 16 Time Periods 9:00 am - 10:00 am 10:00 am - 1:00 pm 1:00 pm - 3:00 pm 3:00 pm - 6:00 pm 6:00 pm - 9:00 pm 9:00 pm - 3:00 am 3:00 am - 9:00 am 14 20 5 4 The supermarket employs 10 full-time staff and a large number of part-time staff. Part-time staff typically can work a 6-hour shift every day and can start on the hour between 9:00 am to 1:00 pm, or at 3:00 pm, 6:00 pm, 9:00 pm or 3:00 am. Full-time staff work at most 40 hours per week between 9:00 am to 5:00 pm with a daily wage of 90 for 8 hours per day, while part-time workers are paid at a standard rate of 8 per hour (i.e., 48 per day for 6 hours). The company policy only permits that up to 80% of the total working hours of any day to be part-time hours. The main task is to schedule the staff so that the total staff costs are minimized on a daily basis. Formulate the scheduling problem in terms of a linear programming problem with a correct objective and all appropriate constraints. Explain in detail why your mathematical formulation is appropriate, including any assumptions that you may have used. Solve your staff scheduling problem using either Excel Solver or Matlab (intlinprog) / Octave (glpk). Summarize your solution procedure (including screenshots if appropriate) and present the main results with a brief discussion. Check if all the required numbers of counters are met