Spitex Zurich FTE and Billable Hours Planning Template
This specialized Spitex resource planning template is designed for home care organizations in the Canton of Zurich to manage complex staffing requirements. It provides a clear framework for tracking a total workforce—such as a 17.5 FTE team—while strictly separating administrative roles from billable care services. The template features dedicated sections for personnel data, FTE percentage calculations, and a summary dashboard that highlights the ratio of non-billable administrative hours to direct patient care.
By using this tool, Spitex managers can ensure that their administrative allocation is utilized efficiently without overlapping into billable service time. This clarity helps in financial reporting and operational planning, ensuring that the organization meets local regulatory standards while maintaining high-quality care. It simplifies the process of monitoring staff availability and helps prevent burnout by visualizing the workload distribution across the entire team. Whether you are managing a small local branch or a larger regional service, this tool provides the transparency needed for effective personnel management.
How to use this template:
- Enter your staff list in the Personnel sheet, specifying the FTE percentage (e.g., 0.8 or 1.0) for each individual.
- Use the dropdown menus to categorize each position as either Administrative (non-billable) or Care-related (billable).
- Review the summary dashboard to see the real-time breakdown of your 17.5 FTE total and ensure the 5 FTE admin limit is maintained.
- Adjust individual allocations as needed to balance the workload and meet your operational targets.
Expected benefits: Significant time saved on manual calculations and improved transparency in staff resource allocation.
