Executive-Level Excel Scenario Modelling Specialist Needed

Job Title:

Excel Expert Required – Build Workforce Planning Scenario Model (Executive-Level Presentation, Due Monday 27th, 6am AWST)

Project Overview:

I need an advanced Excel specialist to format and build the base structure of a workforce planning and scenario modelling spreadsheet. This will form the foundation for a multi-department workforce planning model, but for this first phase, only one department needs to be fully built and functional (I will scale from there once validated).

The finished product must be professional, visually clear, and executive-ready, suitable for a large board presentation. Layout, design consistency, and readability are as important as technical accuracy.

Scope of Work:
• Build a dynamic, user-friendly Excel model that allows scenario planning and forecasting.
• Structure to accommodate multiple departments and employment types (only one department required for this version).
• Incorporate five prescribed award-based calculation methods (details provided).
• Build formulas to calculate FTE based on various multipliers, including: Excess leave, Turnover, Absenteeism etc (list will be provided)
• Have a costing model to produce financial outputs
• Display current operational factors with space to model changes and allow the projected figure to pivot. Factors such as Number of staff, Floor space, patient numbers, presentation volumes and space to add others
• Present data using clear dashboards, logical flow, and executive-level formatting (consistent typography, headings, conditional formatting, etc.).
• Ensure all formulas are transparent, auditable, and editable (no hidden macros unless documented).
• Must be ready for me to input live data on Monday 27th October, 6am AWST.
• Accuracy, presentation quality, and timeliness are critical — payment is contingent on functional, on-time delivery.

Deliverables:
• Fully functional Excel model with one department configured.
• Clearly labelled Inputs / Calculations / Outputs sections.
• Scenario planning functionality with adjustable assumptions.
• Executive-ready design and layout for presentation or reporting.

Requirements:
• Proven expertise in advanced Excel modelling (dynamic arrays, complex formulas, scenario tools).
• Demonstrated experience producing senior executive or board-level dashboards or workforce models.
• Strong visual formatting and data storytelling skills — must be able to present insights clearly.
• Experience in workforce planning, HR analytics, or financial modelling preferred.
• Reliable, detail-focused, and able to meet tight deadlines.

Deadline:

6:00 AM AWST, Monday 27th October (no extensions).

Budget:

Fixed price. Please include examples or screenshots of similar executive-level Excel work and a brief outline of how you’ll approach the build.

Keywords:

Excel, Workforce Planning, Scenario Modelling, Executive Dashboard, HR Analytics, Forecasting, Power Query, Financial Modelling, Data Presentation, Leadership Reporting