Purchase Solution

Schedule

Not what you're looking for?

Ask Custom Question

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.