The reconciliation problem this solves: NYCID buys training slots in bulk (e.g., 20 OSHA-40 slots at once) but consumes them one at a time as interns get certified. Without slot-level tracking, staff lose track of which pool is paying for which intern, leading to double-purchasing, wrong-bucket charges, and slots expiring unused. This dashboard makes every slot accountable.
Total slots purchased YTD
156
across 9 active pools · $84,820 spent
Slots assigned
127
81% utilized · 96 completed · 31 in progress
Available now
29
across all pools · ready to assign
At risk of expiring
8
unused, expire within 90 days
⚠️ Slot Reconciliation Alerts
Possible double-pay caught
Felix Harris has both an OSHA-40 slot from the Olympus Q3 pool AND a separate purchase logged Mar 8 — looks duplicate. Investigate before paying.
Review →
Slots expiring unused
5 Food Handlers slots from Sep 2025 vendor pool expire Jun 30. Assign them or lose the spend.
Assign now →
Wrong bucket?
3 Olympus interns consumed slots from the Concord Q4 OSHA-30 pool. May need re-attribution to clean up funder reports.
Re-attribute →
Time to reorder?
OSHA-40 LTW pool down to 2 slots remaining · 4 interns in queue requesting it. Consider buying the next batch.
Plan purchase →
📦 Training Slot Pools
OSHA-30
NY Safety Training Inc · purchased Aug 2025
3
/ 15 slots remaining
Shared LTW
$1,800 total · $1,440 consumed
OSHA-40 (with +10 hr)
NY Safety Training Inc · purchased Sep 2025
2
/ 20 slots remaining
Shared LTW
$4,900 total · $4,410 consumed
Security Guard (8-hr)
SecureNYC Academy · purchased Oct 2025
7
/ 25 slots remaining
Shared LTW
$2,375 total · $1,710 consumed
Food Handlers
NYC Health Dept · purchased Sep 2025
5
/ 30 slots remaining
YABC primary
$840 total · $700 consumed
Direct Support Professional (DSP)
NY Alliance for IDD · purchased Nov 2025
8
/ 12 slots remaining
DSP grant
$8,220 total · $2,740 consumed
Barber Apprenticeship
Empire Beauty School · purchased Aug 2025
4
/ 8 slots remaining
DYCD specialty
$17,200 total · $8,600 consumed
CPR / First Aid
Red Cross NY · purchased Jul 2025
0
/ 15 slots
Shared LTW
$675 total · $675 consumed
Peer Mediation Certification
NYC Conflict Center · purchased Sep 2025
10
/ 20 slots remaining
Concord primary
$3,300 total · $1,650 consumed
Fire Guard (F-01)
FDNY-Approved Training NY · purchased Feb 2026
8
/ 10 slots remaining
Olympus primary
$1,100 total · $220 consumed
Slot consumption rate by month
When interns actually go through training · helps predict when to reorder
Spend by training type — YTD
Where the training dollars are landing
🧾 Slot Assignment Ledger
Reconciled. All 127 assigned slots in this period link to a specific pool purchase. The OTPS purchase log, the intern's credential record, and the slot pool all balance to the penny. $68,640 in training spend is fully accounted for.
Assignment ledger — March 2026
Every slot assignment shows the intern, the pool it came from, and which OTPS purchase originally funded the pool. This is the column the Excel doesn't have — and the column finance always asks about.
| Date | Intern | Program | Training | Pool | Cost/slot | Status |
|---|---|---|---|---|---|---|
| Mar 28 | Combs, Tajzhane | Concord | OSHA-40 +10hr | OSHA-40 LTW · #18/20 | $245.00 | Completed |
| Mar 25 | Robinson, Tanee | Concord | Peer Mediation | Peer Med Concord · #10/20 | $165.00 | Completed |
| Mar 22 | Cabrera Guzman, Kenny | YABC | Food Handlers | Food Handlers YABC · #25/30 | $28.00 | Completed |
| Mar 20 | Green-Lind, Quentin | Olympus | Fire Guard (F-01) | Fire Guard Olympus · #1/10 | $110.00 | In progress |
| Mar 18 | Charles, Sean | Olympus | Security Guard | Security Guard LTW · #18/25 | $95.00 | Completed |
| Mar 14 | Goodbridge, Jaraiya | YABC | OSHA-40 +10hr | OSHA-40 LTW · #17/20 | $245.00 | Completed |
| Mar 11 | Harris, Felix | Concord | DSP Certification | DSP grant · #4/12 | $685.00 | In progress |
| Mar 6 | Orridge, India | Olympus | Barber Apprenticeship | Barber DYCD · #4/8 | $2,150.00 | In progress |
| Mar 4 | Avi, Jayden | Concord | OSHA-30 | OSHA-30 LTW · #12/15 | $120.00 | Completed |
| Mar 1 | Melendez, Demi | Olympus | CPR / First Aid | CPR LTW · #15/15 (last) | $45.00 | Completed |