CT Global designed a cost allocation model in SAS Cost & Profitability Management providing consistent, comprehensible, and transparent service rates.
The Challenge. The Information Technology (IT) agency for a state government struggled with setting annual rates for services provided to its customers: other state agencies and outside private-sector organizations. The key challenges were a lack of a structured environment for estimating annual expenditures and service consumption data, and a manually intensive rate calculation process that relied on myriad Excel spreadsheets providing little data governance and auditability. The result was a lack of transparency and inconsistent reporting of service rates and their components
The Solution. CT Global designed a cost allocation model in SAS Cost & Profitability Management providing consistent, comprehensible, and transparent service rates. We created ETL routines for automated data aggregation and import processing for structured data, and implemented a web-based portal for users to enter estimates in a governed and auditable environment. These greatly reduced the reliance on Excel.
While finance and service owners were unable to access the rate model directly, they had unlimited access to the SAS visualization tool that allowed them to view and explore reports. If business users required their own copy of a report, the report was shared via Excel, PowerPoint, or as a PDF file.