SurveyCompletion& Cost Mapping
We handle the allocation and data entry so you don't have to.
Learn More
Service Benefits
Optimal Resource Use
Populating detailed survey forms requires significant analyst time. Outsourcing the allocation process allows your finance staff to focus on internal priorities while ensuring timely survey completion.
Methodological Consistency
Most health plans have unique internal classification systems. As the authors of the benchmarks, we ensure your data is mapped precisely to standard definitions, facilitating true peer-group comparability.
Ease of Future Use
We deliver a mapped template tailored to your chart of accounts, so future-year participation is faster and easier. Your team can reuse our structure and focus on updates rather than rebuilding the mapping each cycle.
The Mapping Process
Sherlock Company analyzes cost center descriptions and staffing logs to allocate expenses to the appropriate functional areas. We adjust for shared resources and carve out overhead (such as facilities or IT support) to align with the benchmark methodology.
Example: Allocation of a "Center of Excellence" Cost Center
| Cost center or functional area | Description | Amount |
|---|---|---|
| Client data (general ledger/trial balance and staffing logs) | ||
| Cost Center 555 | Enterprise-wide Business Process Improvement1 | $9,450,000 |
| is allocated to | ||
| Mapped allocation (Sherlock Benchmark definitions) | ||
| Corp. Exec. & Governance | Process Improvement | $8,000,000 |
| Provider Network Mgmt. | Provider Education (2 FTEs) | $1,450,000 |
| Total allocated | $9,450,000 | |
1 Includes 2 FTEs focused on Provider Education.
Engagement Timeline
Typical project duration is approximately 2.5 months from receipt of complete data.
Initiation
Week 0
Data Request Sent
Data Receipt
Week 2
GL & Staffing Received
Mapping
Weeks 2–8
Classification & Populating Forms
Validation
Week 10
Review with Health Plan
Final Report
Week 12
Submission Complete
Data Requirements
To facilitate the mapping process, we request the following standard data extracts:
- Member months or members by product
- Premium revenues & health care costs by product
- Cost center GL data & activity descriptions
- Audited Financial Statements
- FTE counts & descriptions
- Fully-loaded staffing costs by function
Ready to Get Started?
For detailed information regarding service fees, licensing options, or participation in the upcoming study, please contact us directly.
Contact UsSubscribe and receive insights into the metrics and trends shaping health plan performance.