PROMPT BRO
HR desk

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

By hand2–3 days
With AIHalf day
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Make a department-level plan

Opening headcount, planned hires and exits, their budget month numbers and approved average monthly cost. Use department totals only.

First time? Try it on fake data first:

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.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
manpower-plan.xlsx

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.

What you'll get back (example, from the practice files)
₹1.93 Crpartial budget
54valid closing HC
2rows excluded
  • 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.
Before you trust it

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.

If it goes wrong
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?