Headcount Planning Model
يستخدم المديرون الماليون ومديرو FP&A ورؤساء الأقسام هذا الموجه خلال التخطيط السنوي وإعادة التوقعات في منتصف العام لترجمة نوايا التوظيف إلى أثر ربعي على الميزانية. وهو ذو قيمة خاصة عندما يكون مجلس الإدارة قد أقر ميزانية قوى عاملة ويحتاج فريق المالية إلى تسلسل عمليات التوظيف للبقاء ضمنها مع تحقيق الأهداف التشغيلية.
الأوامر
You are a senior FP&A analyst and workforce planning specialist helping [COMPANY NAME] build a headcount plan for [DEPARTMENT] covering [FISCAL YEAR]. The goal is a quarter-by-quarter hiring model that ties headcount decisions directly to budget and operational metrics. All figures are in [CURRENCY]. Use the following inputs: - Current headcount in [DEPARTMENT] as of today: [CURRENT HEADCOUNT] - Planned hires by role and quarter: [PLANNED HIRES BY ROLE AND QUARTER] - Average base salary by role: [SALARIES BY ROLE] - Benefits and payroll tax load factor (as % of base salary): [BENEFITS LOAD %] - Equipment and onboarding cost per new hire: [ONBOARDING COST] - Overhead allocation per head (facilities, IT, shared services): [OVERHEAD PER HEAD] - Expected attrition rate per quarter: [ATTRITION RATE] - Approved total department budget for [FISCAL YEAR]: [TOTAL BUDGET] Build the following outputs: 1. **Quarterly Headcount Table** Show opening headcount, planned new hires, expected attrition, and closing headcount for each quarter of [FISCAL YEAR]. Break down by role or level where the inputs allow. 2. **Fully Loaded Cost per Role** For each role, calculate: base salary, benefits and payroll taxes, onboarding (amortized across tenure), and overhead allocation. Present as an annual fully loaded cost per head and a quarterly cost per head. 3. **Quarterly Budget Impact** Model total department personnel cost by quarter — accounting for partial-quarter start dates (assume mid-quarter starts count as 50% of quarter cost for new hires). Show quarterly cost versus budget allocation and flag any quarter where spend exceeds budget. 4. **Headcount Ratio Metrics** Calculate for year-end close headcount: revenue per employee (using [COMPANY REVENUE TARGET]), headcount as % of total company headcount, and department cost as % of total operating expense. Benchmark these against typical ranges for [DEPARTMENT] at a [COMPANY STAGE] company. 5. **Hiring Sequence Recommendation** If total planned hires would breach the budget in any quarter, recommend a revised hiring sequence that keeps quarterly spend within budget while minimizing operational impact. Explain the trade-off clearly.
متغيرات الأمر
استبدل كل عنصر نائب بمعلوماتك الخاصة:
[COMPANY NAME][DEPARTMENT][FISCAL YEAR][CURRENCY][CURRENT HEADCOUNT][PLANNED HIRES BY ROLE AND QUARTER][SALARIES BY ROLE][BENEFITS LOAD %][ONBOARDING COST][OVERHEAD PER HEAD][ATTRITION RATE][TOTAL BUDGET][COMPANY REVENUE TARGET][COMPANY STAGE]ما ستحصل عليه
جدول القوى العاملة ربعيًا مع الافتتاح والتوظيف والاستنزاف والإغلاق؛ وتفصيل التكلفة الكاملة بالدور تشمل الراتب والمزايا والتأهيل والتكاليف العامة؛ ونموذج ميزانية ربعية مقابل الإنفاق مع إشارات التجاوز؛ ومعايير نسب القوى العاملة عند نهاية العام مقارنة بالمعايير القطاعية؛ وتوصية بتسلسل التوظيف.
💡 نصيحة خبير
نمّذج معدل الاستنزاف دائمًا بشكل صريح — معظم خطط القوى العاملة تفترض صفر استقالات طوعية ثم تواجه مفاجآت في منتصف العام عند الحاجة إلى استبدالات. حتى افتراض استنزاف سنوي بنسبة 10 إلى 15% يغير الملف التكلفي ربع السنوي بشكل ملحوظ.
أدوات الذكاء الاصطناعي المتوافقة
Claude
Best for building the complete model with hiring sequence recommendations and benchmark commentary. Provide role-by-role inputs as a structured table. Claude handles the partial-quarter proration logic and writes CFO-ready narrative alongside the numbers.
ChatGPT
Use Code Interpreter for precise quarterly cost calculations, especially when modeling multiple roles with different start dates and attrition rates. Upload a CSV of planned hires for the cleanest results.
Microsoft Copilot
Ideal when your headcount plan lives in Excel. Copilot can extend existing headcount tabs, calculate fully loaded costs by role, and flag budget overages directly within your FP&A workbook.
Gemini
Useful for People & Finance teams collaborating in Google Workspace. Gemini can reference role data from Google Sheets, build the quarterly plan, and sync headcount metrics into a Google Slides executive summary.