A consulting company has a lunch room, 12 conference rooms, 6 LCD projectors, 3 portable PCs, etc. They need to be able to schedule each of these resources for a given day and time period and avoid conflicting use of resources. Also, management would like reporting on resource utilization per week, month, year. They are also considering renting out resources to other companies if resource utilization is low. Queries might include:
When is the next day resource X is free between 1:00 and 5:00.
How many hours per week on average is conference room X occupied.
-
GroupProject1.ppt