Excel WFM Capacity Planning Analysis

₹600-1500 INR

Open

Posted 6 days ago

•

Ends in 1 day

₹600-1500 INR

Paid on delivery

I have an urgent assessment to finish and need a specialist who truly understands Workforce Management logic inside Excel. You will receive one raw workbook that already holds the time-stamped data and all supporting assessment figures. Your main job is to turn that sheet into a clear-cut capacity-planning model, then walk me through the reasoning so I can present it with confidence. Here is what I am looking for: the model must calculate staffing requirements, shrinkage, occupancy, service-level projections and any other standard metrics you normally include for solid capacity planning. Forecasting and scheduling elements sit right behind this priority, so design the file in a way that lets me easily extend it to those areas. Accuracy is essential, but speed matters even more; I need first results fast and will iterate with you in real time. Please be ready to: • Clean and structure the raw data, using formulas, Power Query, or VBA—whatever gets the job done quickly. • Build the capacity plan with transparent assumptions and clearly labelled inputs/outputs. • Run at least two demand scenarios and highlight the impact on staffing. • Provide a concise hand-over (screen-share, notes, or short video) so I can transfer the logic to my team. If you have previous WFM capacity models you can reference, let me know. I will move forward as soon as I see someone who can jump in, apply best-practice Erlang-C or similar logic, and explain their work clearly.

Project ID: 40375692

About the project

4 proposals

Open for bidding

Remote project

Active 6 days ago

Place your bid

Bid amount

₹

INR

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

4 freelancers are bidding on average ₹2,125 INR for this job

@Danzy262

Hi, I’ll turn your raw workbook into a clear, accurate WFM capacity-planning model with fast results and easy-to-explain logic. What you’ll get: * Cleaned and structured dataset (Power Query/formulas) * Full capacity model (staffing, shrinkage, occupancy, service level) * Erlang-C or equivalent logic for accurate staffing calculations * Clearly labeled inputs, assumptions, and outputs * Two demand scenarios with staffing impact comparison * Extendable structure for forecasting and scheduling * Quick handover (notes + walkthrough) for presentation clarity My approach: * Build transparent calculation layers (no black-box formulas) * Optimize for speed and accuracy under time pressure * Focus on explainable outputs for your assessment I have strong experience with Excel modeling and analytical frameworks. Timeline: First results within a few hours, full model same day Budget: ₹1,200 total Ready to start immediately!

₹1,200 INR in 2 days

5.0

(1 review)

0.5

@mfilipovacfl

Hi, I’ve built similar Excel-based workforce planning models for support teams and BPO-style operations where we used Erlang-C style logic, shrinkage assumptions, and scenario-based staffing projections. Most of the work was cleaning messy time-series data in Power Query, then building transparent models so non-technical stakeholders could adjust inputs and immediately see staffing impact. For your file, I’d approach it like this: * First, structure and validate the raw time-stamped data (Power Query + clean tables) * Then define clear input blocks: AHT, SL, occupancy target, shrinkage, interval volume * Build staffing requirement logic using Erlang-C or simplified queueing approximation depending on granularity needed * Add scenario toggles so you can compare at least two demand cases instantly * Finish with a clean output dashboard: required FTE, occupancy, SLA impact, and gaps I’d also keep everything auditable so you can explain every number during your assessment without guessing. If you want, I can start immediately, but I need one thing clarified first: is your data interval-based (15/30 min), or daily aggregated? Best regards, Mihailo

₹1,050 INR in 7 days

0.0

(0 reviews)

0.0

@ericphan28

Hi, The core challenge in WFM capacity planning is getting the Erlang-C service level calculation right — most Excel models I've seen either hardcode it or use simplified approximations that break at high occupancy rates. I'll implement the full iterative Erlang-C formula natively in Excel. Deliverables: • Demand forecasting sheet with interval-level (15/30min) volume inputs and multiple scenario toggles (baseline/peak/growth) • Erlang-C engine: calculates required agents from target service level, AHT, and arrival rate — with occupancy and shrinkage factors built in • Staffing output: FTE requirements by interval, day, week with visual heatmap • Dashboard with key WFM KPIs: service level, ASA, occupancy, shrinkage impact • Clean structure — all formulas, no hidden macros, easy to hand over I can start immediately. Do you have historical call/contact volume data, or should I build the model with sample data first? Best regards, Eric

₹1,200 INR in 3 days