A yearly headcount and salary budget
The manpower plan says 20 hires. Finance says 8. Excel has a separate column called 'discussion'.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Make a department-level plan
Opening headcount, planned hires and exits, their budget month numbers and approved average monthly cost. Use department totals only.
Confirm timing and cost basis
Use month 1 to 12 of your budget year. Confirm whether hires and exits affect costs from the start of that month.
Privacy Use department-level aggregate headcounts and average costs only. Remove individual salary, employee names, codes and payroll records.
I'm attaching a department staffing plan for [Budget year]. Timing: [Timing rule]. Cost basis: [Cost basis]. A. Validate each row: nonnegative headcount and movement, valid month 1–12 for positive movements, cost present, no exit count above staff available at its month (include hires if already effective). Exclude invalid rows from totals and flag why. For valid rows show closing HC = opening + hires minus exits; employee-months = opening × 12 + hires × (13 minus hire month) minus exits × (13 minus exit month), with zero movement contributing zero even if month blank. B. Annual budget = employee-months × average monthly cost; show workings by department, total valid employee-months, closing headcount and annual budget. Label total partial if any rows excluded. C. List invalid rows, assumptions and questions for management. No automatic hiring, layoff or pay decisions. Don't invent salary increases or statutory costs. Use only supplied numbers. HR and finance approve the plan. Do not repeat personal identifiers from the data (personal names, phone numbers, email or postal addresses, bank account numbers, UPI IDs, PAN, Aadhaar, GSTIN or other registration numbers) unless the output genuinely needs one; use the code, ref or row instead, and copy any needed identifier exactly. Keep masked values masked; never guess, complete or unmask them.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep the actual plan in Excel and ask for formulas only.
Excel A:G = department, opening HC, hires, hire month, exits, exit month, avg monthly cost. Timing [Timing rule]; cost basis [Cost basis]. Write formulas for H validity (including valid movement months and exits not above available at exit month), I closing HC, J employee-months, K annual budget. Zero movement with blank month contributes zero; blank I:K if invalid. Show valid-only totals. Tell me where to paste.
Fill down, resolve invalid rows, check the budget with finance and obtain management approval.
- Production45 exits, 44 available. Invalid plan; check movement numbers.
- ServiceCost missing. Do not assume zero salary cost.
- ₹1,92,52,000Exact valid budget. 657 employee-months across four valid departments.
Then send this: Recalculate employee-months and closing HC for each valid row, multiply by monthly cost and reconcile the totals. Confirm excluded rows and label the budget partial.
It assumes everyone works all year
Reply: "Use employee-months and movement months."
It treats missing cost as zero
Reply: "Exclude and flag; total is partial."
It adds increments
Reply: "Use constant approved cost only."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
If your whole team does this, we'll set it up for all of them in one session.