Human Resource Calendar

Can you please just help me get started here? Thanks!

Develop a calendar (schedule) for human resources for the month of December 2007, taking into consideration the following information:

a. You have four people you can schedule, John, Sally, Pedro, and Eunice.

b. The typical workweek for your company is 45 hours. Depending on the individual, schedules may include Saturdays and Sundays and can include graveyard or swing shifts.

c. John’s schedule is 6:00 am to 4:00 pm with 1-hour lunches, Saturday through Wednesday.

d. Sally works 3:00 pm to 3:00 am, with two 1-hour breaks, Monday through Thursday. The remaining hours to get to 45 hours per week can be scheduled on Friday or Saturday in one block with no break for lunch.

e. Pedro can be scheduled at any time except from 12:00 noon to 5:00 pm on Wednesdays. He must know his schedule by 12:00 noon on Wednesday the prior week.

f. Eunice works 20 hours per week with John, and 25 hours per week with Sally.

g. Your company has declared December 24 and 25 as holidays.

h. Eunice has scheduled her vacation for the week of Christmas.

i. John has scheduled some personal time off for December 1 and 2.