TTSH GM Manpower Simulator

Scenario Inputs

Coverage Demand

Year Teams needing daily consultant coverage Public holidays per year (stored SG calendar for 2026/2027) Weekend days per year (stored SG calendar for 2026/2027)

Consultant Supply

Full-time GM consultants Ong Chin Ee active months in Apr-May (comma-separated month numbers 4-5) Suresh Sahadevan active months in Jul-Dec (comma-separated month numbers 7-12) Jennifer Ting availability (% of year) Koh Nien Yue GM coverage (working days/month) Additional consultants in intake 1 Intake 1 start month (1-12) Additional consultants in intake 2 Intake 2 start month (1-12)

Leave And Days Off

Consultants eligible for leave entitlement Annual leave max (working days/consultant) Conference leave max (working days/consultant) Medical leave max (working days/consultant) Annual leave utilization (%) Conference leave utilization (%) Medical leave utilization (%) Paternity planner (one consultant per line: duration|months) Maternity planner (one consultant per line: duration|months) Min consultants on leave at any one time Max consultants on leave at any one time Admin days per consultant (equal allocation) Consultants receiving admin days Consultants receiving FTE days (auto from FTE table)

Popup list not applied

Department FTE off-days pool (total) FTE pool dispensed (%) Admin proration mode for FTE recipients Manual admin-day proration (%) GM contribution base days Computed GM contribution scaling (%) Recallable standby available each day (for high-leave days)

Patient Load

Patients/day per consultant (base) Patients/day per consultant (stretch) Patients/day per consultant (peak)

Monthly Coverage And Buffer (Consultants Per Day)

Annual Demand

consultant-days required

Gross Supply

consultant-days before leave

Leave Days Off

annual + conference + medical + paternity + maternity (after concurrency cap)

Leave Days Off (No Cap)

annual + conference + medical + paternity + maternity (if concurrency cap removed)

Admin Days Off

effective admin days dispensed (after proration rules)

FTE Days Off

department FTE pool dispensed

Net Supply

consultant-days available

Annual Balance

surplus (+) / deficit (-)

Avg Consultants/Day

annual average available

Daily Gap

consultants vs required teams

Min Consultants At Once

after max leave assumption

Max Consultants At Once

after min leave assumption

Min Dispensed/Month

total admin + FTE off-days

Max Dispensed/Month

total admin + FTE off-days

Coverage Rate

midpoint average supply / demand

Working Days

year - weekends - public holidays

Average FTE

gross supply converted to FTE

FTE + Admin Days Allocation

Individual	Group			Total (FTE + Admin)

Monthly Consultant-Day Balance

Monthly Total Off-Days Dispensed (Admin + FTE)

Patient Capacity Scenarios

Monthly Breakdown

Month	Average available/day	Gap vs teams	Balance (consultant-days)	Total dispensed off-days (admin + FTE)	Base patient capacity/day

Manpower Formula (LaTeX)

Select a calculated variable to view its equation:

Calculated variable

TTSH General Medicine Manpower Simulator