Works with the AI Agents you already use
long horizon workforce capacity scenario modeler
Staffing shortages and credential mismatches often go unnoticed until a seasonal peak hits.
$2.99
long horizon workforce capacity scenario modeler
Example session with this skill installed
Test our baseline capacity for 2024-06 to 2024-08. We have 20 RNs (40h/wk) and demand is 3200h/mo. Max overtime is 10h/wk. RNs can substitute for LPNs. Run a scenario with 2 extra RN hires in July.
- Read your context and instructions
- Compiled the long horizon workforce
Analysis of workforce capacity for the period 2024-06 to 2024-08 is complete. The model compared the baseline staffing against a hiring scenario for July.
Workforce Capacity Scenarios — General Hospital, 2024-05-20
1. Scope, sources and assumptions
- Sources: E1 (User Prompt).
- Months: 2024-06 to 2024-08.
- Weekly Limit: 50h (40h contract + 10h OT) [E1].
- Assumptions: RNs can substitute for LPN demand [E1].
2. Scenario comparison
| Scenario | Total Shortfall | Change vs Baseline | Shortfall after OT | Peak Month | Coverage Ratio | Contract Cost |
|---|---|---|---|---|---|---|
| Baseline | 450h | 0h | 120h | 2024-07 | 0.92 | $480,000 |
| +2 RN Hires | 110h | -340h | 0h | 2024-08 | 0.98 | $515,000 |
3. Monthly coverage by scenario
Scenario: +2 RN Hires
| Month | Demand h | Usable supply h | Covered h | Shortfall h | Coverage | Flags |
|---|---|---|---|---|---|---|
| 2024-06 | 3200 | 3466 | 3200 | 0 | 1.00 | |
| 2024-07 | 3200 | 3812 | 3200 | 0 | 1.00 | |
| 2024-08 | 3200 | 3812 | 3200 | 0 | 1.00 |
4. Overtime, rest and fatigue checks
Baseline scenario shows a 120h shortfall in July that exceeds the 50h weekly limit. The +2 RN scenario eliminates this shortfall. Overtime headroom is a legal maximum, not a forecast.
5. Proposed changes and approval record
- Draft: Hire 2x RN (Credential: RN), Effective 2024-07-01.
Rosters, hiring and publication are Management decision required and need supervisor approval.
6. Evidence status and information gaps
- Validated records: 1 (RN cohort).
- Estimates: 0.
- Gaps: None identified.
7. Warnings and items for human review
- W04: Substitution rule applied for RN -> LPN.
- Shortfall in baseline exceeds overtime ceiling in July.
- Cost increase of $35k in hire scenario is within projected budget.
This analysis supports, and does not replace, professional judgment and management's decision.
Next steps
- Review the $35,000 cost variance for the July hiring scenario.
- Confirm RN-to-LPN substitution rules comply with local facility policy.
- Obtain supervisor signature for the July recruitment draft.
Connects securely to your tools. The creator never sees your data.
About this skill
Staffing shortages and credential mismatches often go unnoticed until a seasonal peak hits. This skill tests workforce size and credential mixes against monthly demand and leave patterns to identify shortfalls before they happen.
What it does
- Capacity modeling tests headcount against seasonal demand and leave over long horizons.
- Scenario comparison evaluates what-if changes like new hires, demand growth, or attrition.
- Credential mapping applies specific substitution rules to ensure correct task coverage.
- Cost estimation calculates contract costs and overtime requirements based on supplied rates.
- Gap analysis flags months where demand exceeds supply even after accounting for overtime limits.
How it works
- Data ingestion reads your headcount, demand hours, and leave patterns, assigning source references for transparency.
- Request generation builds a
request.jsonfile ensuring all credential and cohort data matches the required schema. - Execution runs the deterministic
run.pyscript to calculate exact coverage fractions and maximum-flow distribution. - Validation checks the output status for warnings or fatigue flags and prepares a descriptive report.
Frameworks & tools
The skill utilizes a Python-based calculation engine (run.py) and JSON schemas for structured workforce data.
Why this beats prompting it yourself
Standard LLM prompting struggles with exact fractional arithmetic and complex substitution logic across multiple months. This skill uses a deterministic script to ensure math is precise and prevents "hallucinated" staffing solutions.
Use cases
- Auditing whether current staff can cover a high-demand holiday season.
- Modeling the impact of a 10% increase in sick leave across specific credentials.
- Calculating the cost and coverage benefit of hiring three junior vs. two senior roles.
- Testing if overtime limits are sufficient to bridge a temporary staffing gap.
Known limitations
Does not perform demand forecasting or roster optimization. Calculations are only as accurate as the user-supplied weekly hour limits and leave patterns.
Does not forecast demand or build individual rosters. Requires user-supplied weekly hour limits. All hiring changes remain as drafts requiring supervisor approval.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 2 days ago