Capstone: A Multi-Site Contract Dashboard
This lesson is part of the course
In this lesson
You summarise eight posts into a per-site dashboard of posts, FTE, price, cost and margin, find the weakest site with a formula and chart price against cost for every post.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Post Hours: From Opening Times to Weekly and Annual Cover Locked
- Net Hours per Officer: Contract Hours Minus Leave, Training & Absence Locked
- The Relief Factor: How Many Officers One Post Really Needs Locked
- Shift Patterns: Repeating Rotas, Coverage, Gaps & Double Cover Locked
- Overtime or Extra Staff? Costing the Gap Hours Locked
- Building the Hourly Bill Rate: Pay, On-Costs, Paid Time Off Post, Overhead & Margin Locked
- Contract Margin per Post: Monthly Price, Overtime and Staff Turnover Locked
- Capstone: A Multi-Site Contract Dashboard Locked