In this design project an automated workforce platform is designed to optimize workforce scheduling under uncertain demand conditions. Multiple industries face labor shortages, overstaffing, and increased operational costs due to inefficient scheduling of workforce. The focus is on optimizing staffing levels for different branches of online grocery store. The project involves a multi-step approach, beginning with demand forecasting using time series analysis and regression techniques. MAPE (Mean Absolute Percentage Error) is used to assess the accuracy of the forecasts. A mathematical model is developed in Excel to simulate the staffing needs, taking into account key variables such as 24-hour demand variations, order picking time, PFD (Personal, Fatigue, and Delay) allowances, and order volume per picker. The proposed solution computes the optimal workforce size needed at different times and categorizes staffing conditions as overstaffed, understaffed, or optimal using a decision-support column.
Track: Senior Design Project Competition
Published in: 6th South American Conference on Industrial Engineering and Operations Management, Sorocaba, Sao Paulo, Brazil
Publisher: IEOM Society International
Date of Conference: May 12
-15
, 2025
ISBN: 979-8-3507-4445-3
ISSN/E-ISSN: 2169-8767