In: Operations Management
In this assignment, you will create a schedule for the month of December of this year for your team members—John, Sally, Pedro, and Eunice. While creating the schedule, keep in mind the following conditions:
Every employee in the company needs to work for 45 hours per week.
John works from Saturdays to Wednesdays in the 6:00 a.m. to 4:00 p.m. shift, with a 1-hour lunch break.
Sally works from Mondays to Thursdays in the 3:00 p.m. to 3:00 a.m. shift, with two 1-hour breaks. To complete 45 hours of work, she can be either scheduled on Fridays or on Saturdays in a block of 5 hours, with no break.
Pedro can work on any day except Wednesdays from 12:00 noon to 5:00 p.m. His work schedule should be made available to him by 12:00 noon on Wednesday of the previous week.
Every week, Eunice works with both John and Sally—20 hours with John and 25 hours with Sally.
Your office is closed on December 24 and 25.
Eunice is on leave in the week after December 25.
John is on leave December 2 and 3.
Perform the following tasks:
Create a project schedule that incorporates all the conditions. Discuss the technique you used to implement the schedule.
Which software tool did you use to create the schedule?
Explain how helpful you found the tool.
Submit a 4- to 5-page report
You need a resource scheduler to solve this query on a regular basis.
Multiple resource planner applications are available in the market as on today. Some of them include Float, hub planner, Resource guru etc. There are also open source platforms which help you in scheduling the team.
However since the team size is smaller, you can also try using Google sheets and share the resource plan real time with your team and help them in planning efficiently.
I am doing the resource allocation manually. So here is my resource plan
Considering the month of Dec'18
Sat -
Day | Dates | User name | Working hours | Breaks |
Sat | 1,8,15,22,29 | John , Eunice | 6:00 AM to 4:00 PM | 1 hr |
Sun | 9,16,23,30 | John, Eunice | 6:00 AM to 4:00 PM | 1 hr |
Mon | 3,10,17,31 | Sally | 3:00 PM to 3:00 AM | 2 hrs |
Tue | 4,11,18 | Sally | 3:00 PM to 3:00 AM | 2 hrs |
Mon | 10,17,31 | John | 6:00 AM to 4;00 PM | 1 hrs |
Tue | 4.11.18 | John | 6:00 AM to 4:00 PM | 1 hr |
Mon | 3, 10,17 | Eunice | 2;00 PM to 2:00 AM | 2 hrs |
Tue | 4,11,18 | Eunice | 2:00 PM to 2:00 AM | 2 hrs |
Wed | 5.12.19,26 | John | 6:00 AM to 4:00 PM | 2 hrs |
Wed | 5,12,19,26 | Eunice | 3:00 pm TO 3:00 AM | 2 hrs |
Thu | 6,13,20,27 | Sally | 3:00 PM to 3;00 AM | 2 hrs |
Fri | 7,14,21,28 | Sally | 3;00 PM to 8:00 PM | 0 |
Sat | 1,8,15,22,29 | Pedro | 12:00 PM to 5:00 PM | 0 |
Sun | 2,9,16,23,30 | Pedro | 12:00 PM to 5;00 PM | 0 |
Mon | 3,10,17,31 | Pedro | 12;00 PM to 5;00 PM | 0 |
Tue | 4,11,18 | Pedro | 12:00 PM to 5;00 PM | 0 |
Thu | 6,13,20,27 | Pedro | 12:00 PM to 5:00 PM | 0 |
Fri | 7,14,21,28 | Pedro | 12;00 PM to 5; |
However the requested scheduler cant be made,as pedro is only working for 36 hrs instead of the target 45 hrs