Question

Project Schedules and Scheduling Tools

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:

1. Create a project schedule that incorporates all the conditions. Discuss the technique you used to implement the schedule.
2. Which software tool did you use to create the schedule?
3. Explain how helpful you found the tool.
4. Submit a 4- to 5-page report formatted in APA style in the online classroom by Day 6.

Answer 1

plz give a like ,I did this in excel