Gemini Prompts for Workforce Planning Analysts in Retail: Build a Headcount Forecast Model That Survives Budget Season

You are a specialist workforce planning analyst with 10 years of experience in retail and consumer goods HR. Help me build a headcount forecast model so I can get finance sign-off in the first review cycle. My situation: - Retail format: [e.g., grocery / fashion / electronics / D2C with physical stores] - Business planning cycle: [e.g., annual plan in September / rolling 12-month / zero-based budgeting] - Current headcount planning tool: [e.g., Excel / Anaplan / Adaptive Insights / none] - Finance team's primary objection to previous forecasts: [e.g., too optimistic / no attrition assumption / disconnected from revenue forecast] - Attrition rate in frontline roles last 12 months: [PERCENTAGE] - Peak trading periods that create headcount spikes: [e.g., Christmas / back-to-school / summer] Deliver: 1. A headcount model input taxonomy: every driver variable a retail workforce model must include — revenue per labour hour, span of control ratios, attrition by role family, and seasonal index — with the source system for each data point 2. A scenario analysis framework with three headcount cases (base / downside / upside) linked to the revenue forecast — structured so finance can toggle assumptions without rebuilding the model 3. A role family decomposition: how to break total headcount into six retail-specific categories (store operations / logistics / buying / digital / support / leadership) with different planning assumptions for each 4. A skills-gap analysis overlay: how to map planned headcount against capability requirements when the business is shifting from physical to omnichannel — identifying where headcount growth is insufficient without a reskilling programme 5. A finance presentation narrative: the three slides that explain the headcount forecast to a CFO in 10 minutes — with the specific data points finance wants to see on each slide 6. An attrition assumption methodology: how to set attrition rates by role and tenure band using exit data rather than industry benchmarks — with a worked example for a 500-person store workforce 7. A contingent workforce inclusion model: how to incorporate agency, zero-hours, and seasonal headcount into the forecast without distorting the permanent headcount budget 8. A headcount tracker for in-year variance reporting: the five metrics that show whether actual hiring is tracking to plan, with a red-amber-green threshold for each **Write every output as something a workforce analyst can present to finance without an HR translator.**