Alert!Alert: Information about the 36 Pit Fire near Estacada or call 503-630-7712.
Services Departments Government

Technology Services Allocation

Pie Chart

Clackamas County Technology Services (TS) manages a large array of technologies and services for many diverse departments and agencies. Technology Services also has a variety of funding sources and models ranging from “General Funding”, direct bill for services, indirect billing, grants and a large allocated component. This allocation is spread across the utilization of services based on several factors. For the most part, this allocation covers the overall enterprise infrastructure and support services such as network, servers, operations, call center, technicians, licensing, storage and equipment (PC, printers, etc.) utilized by the County. As with any technical support organization with an allocated cost recovery methodology, this process can be confusing, hard to manage, difficult to track, expensive to maintain, contentious in tough budget times, hard to align with technology utilization and goals, and difficult overall for departments to effectively budget for or even control their own utilization. Regardless of the system implemented, it was a management challenge to maintain a balance between simple but inequitable and fair but complex — especially when other factors such as grant restrictions, dedicated funding and politics are factored in. Clackamas County recently initiated a goal to both streamline the overall allocation system and to ensure the process was transparent to both internal departments and external scrutiny.

Previous allocation methodologies used by TS where antiquated, inflexible, unable to equitably correlate technical service utilization to cost recovery metrics, difficult to explain and worst of all did not give the user departments any ability to accurately track utilization for budget analysis or forecasting. To solve these problems TS decided to redesign the whole allocation methodology and process. Some of the concerns and tenants considered in the design of the new allocation methodology included:

We formed an allocation committee with TS, Finance and departmental staff to develop the new model based on the above requirements. From this, TS designed and developed a new methodology for the tracking, calculation and reporting of allocations. This required 3 components: a new system of flexible metrics, a new calculation process and new reporting capability. During the process of design and development, we kept the County Auditor involved to ensure the process was fiscally correct.

Allocation Metrics

To meet the tenant of balanced metrics that are fair, flexible and measurable — while not being too complex, expensive or confusing — TS reviewed numerous models and examples before settling on what Clackamas County believes is a practical list of metrics. During analysis, it became evident that even a fair mix of allocation metrics didn’t realistically reflect utilization. For example, a printer could be networked or directly connected to a PC – both are printers but require a much different level of support. Therefore, along with a new array of metrics, TS also designed a tier approach for each metric to better match the utilization. These tiers allowed the metrics to be efficiently tracked, and based on specific utilization; tiers would be a percentage of the costs for the base tier. Therefore if a department had ten printers — five are networked Tier 1 (100% rate) and five are direct connect Tier 2 (50% rate) — the allocation value would be 7.5 printers of the full rate for printers. The current metrics and tiers utilized are:

Allocation Process/Database
To load, store and process the metrics a new database was developed. The metrics are loaded from the various source systems into the database on a quarterly, instead of annual, basis. This allows for seasonal fluctuations to be accounted for as well as prevent departmentsfrom using the annual sampling as a way to “hide” equipment based on procurement dates. The allocation loads are done first as a draft for departments to run reports to confirm accuracy, then two weeks later as the final. This process allows departments and TS to maintain an accurate count metric that is easily accessible by departments and allows TS to plan technology support around utilization that can be accurately projected based on historical trending. After a year of quarterly samples, an annual average can be calculated that is then used to generate the actual annual allocation. To generate this annual allocation, a sophisticated spreadsheet is utilized that has all TS expenses, allocated metric annual counts from the database and all other required information such as capital expenses, staffing, grant information, revenue calculations and allocation rate calculations (that utilize the metric counts to determine rates) to build an overall technology budget. This spreadsheet is dynamically created so all data is linked together for accurate up to date results. Once the data is loaded, the spreadsheet generates a final allocation that is then sent to the budget department for processing into the annual County budget. Departments are able to view their final allocation and utilize this information in budget preparation. This final allocation should also match departmental estimates based on the quarterly reports available from the allocation database thus confirming their technology utilization calculations. This provides a year long, open and manageable allocation system for budget and technology utilization monitoring.

Allocation Reporting
To allow departments the ability to efficiently track and manage their technology utilization, as well as project their allocations, they needed an easy reporting system. In conjunction with the allocation database, a web accessible reporting system was developed that allows departments to monitor their utilization, check for accuracy and extract the information as required. The report menu allows for detailed reports for each metric, historical information related to the rates of the metrics (for trending analysis), quarterly summary reports (for budget tracking) and overall annual allocation estimates. This reporting system has been a major success for the departments as there are no longer any allocation “surprises” and departments now have the ability to make business decisions around the use of the technology.

Next Steps

Even with the success of the new Technology Allocation System, there is always room to improve. TS formed an Allocation Committee to keep a high level of communications related to technology expenses, coordinate training and provide a forum for improvement. Next steps include a review of additional metrics such as AV equipment and email accounts and new tier levels for on-demand mobile utilization, etc. The flexibility of the allocation system allows for additional metrics without major re-development. TS is also working with the Finance Department on the addition of more reporting to assist departments in budgeting for things such as A-87 grant reporting. TS is also looking into adapting the system for other internal service departments to apply to their allocation methodologies.

Services & Benefits

The new TS Allocation has been a great success, both for TS and the County departments. Some of the benefits so far are:

Technology

The technology utilized for the new allocation system is very simple and easy to maintain:

Additional Information

Share this page

Contact Us

Technology Services
121 Library Court
Oregon City, OR 97045
map

(503) 655-8322

Monday through Thursday 7:00 am to 6:00 pm