This workbook was developed to assist the Data Management Center (DMC) in gaining better insights behind the cost of operations. In order to better understand costs, the following steps were taken to develop this spreadsheet model:
1. Identify all of the resources available to DMC and the associated costs of the resources (personnel, equipment, etc.)
2. Identify all of the major activities of DMC such as setting up IP addresses, installing network equipment, etc.
3. Map a relationship between the resources and activities — referred to as «Resource Drivers» (allocates costs to key activities)
4. Map a relationship between the activities and cost objects — referred to as «Activity Drivers» (allocates activity cost to your services)
5. Determine the costs of each service, product or what-ever you consider your cost object within the model.