This report shows the list of awarded contracts by the clients. It contains the following sheets:
1. Client Summary = contains the summary of total contracts per client on a given period.
2. Client Detail = contains the details of awarded contracts per client on a given period.
For those companies engaged in commercial production. The following reports are added on a given period.
4. Agency Summary = contains the summary of total contracts per Agency on a given period.
5. Producer Detail = contains the details of awarded contracts per Producer on a given period.
6. Producer Summary = contains the summary of total contracts per Producer on a given period.
7. Director Detail = contains the details of awarded contracts per Director on a given period.
8. Director Summary = contains the summary of total contracts per Director on a given period.
9. Raw Data = a pivot table that you can use to create other reports such us, top clients, quarterly awarded contracts, etc.
Follwing is a sample of Project Contracts Monitoring Report generated from the system and directly exported to excel file. Some columns are changed or blurred due to data privacy act.
Contracts per Client
![](images/topics/images/pcm_contractmonitoring1.jpg)
![](images/topics/images/pcm_contractmonitoring2.jpg)
Contracts per Agency
![](images/topics/images/pcm_contractmonitoring3.jpg)
![](images/topics/images/pcm_contractmonitoring4.jpg)
Contracts per Producer
![](images/topics/images/pcm_contractmonitoring5.jpg)
![](images/topics/images/pcm_contractmonitoring6.jpg)
Contracts per Director
![](images/topics/images/pcm_contractmonitoring7.jpg)
![](images/topics/images/pcm_contractmonitoring8.jpg)
The above report can be generated from this app:
![](images/topics/images/pcm_contractmonitoring0.jpg)
|