Schedule
Not what you're looking for?
There are 12 employees total.
Each of them clock in and clock out daily. There are not supposed to be more than three employees working at any given time, not even for one minute!! Create a visual that will show and calculate an overlap for two weeks.
Create a visual diagram using excel that shows a danger (red color) when 4 employees or more overlap their times. I also want to calculate the total time that is overlapped throughout the day.
Employee Start Stop
A 13:40 16:02
B 15:39 17:15
C 9:15 12:25
D 14:45 18:36
E 8:33 12:44
F 9:00 15:04
G 8:19 15:00
H 8:30 14:50
I 8:39 12:27
J 12:47 18:04
K 9:24 12:48
L 14:08 14:30.
Purchase this Solution
Solution Summary
The solution goes into a great amount of detail about the question being asked. The concepts are very well explained and easy to understand. The solution can be followed very easily by anyone who has some understanding of the concepts beforehand. Overall, an excellent response to the question. The attachment is also very well explained and illustrated.
Solution Preview
See the attached file.
As you can see in the the attachment, I have divided the time ...
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.