Open Access Open Access  Restricted Access Subscription Access

Predictive Workforce Overtime Forecasting in Government: A Machine Learning Architecture for Job-Classification Seasonal Modeling, Leave-Backfill Prediction, and ERP Budget Alert Integration

Gopichand Mannava

Abstract


Overtime expenditure is a persistent and volatile component of government personnel budgets, driven by seasonal demand, unplanned leave, and staffing shortfalls that are difficult to anticipate with traditional budgeting methods. This paper presents a machine learning architecture for predictive workforce overtime forecasting in government, combining job-classification-specific seasonal modeling, leave-backfill prediction, and integration with enterprise resource planning (ERP) budget alerts. The architecture decomposes overtime into seasonal, trend, and leave-driven components, trains classification-aware models, and feeds forecasts into ERP systems that raise budget alerts when projected overtime threatens to breach appropriations. We formalize the forecasting model and evaluation metrics, compare candidate algorithms, and illustrate seasonal overtime patterns by job classification alongside actual-versus-predicted performance. Gradient-boosted and recurrent models achieved the lowest forecast error, and the integrated alerting closed the loop between prediction and budgetary control. The architecture equips government workforce and finance managers to anticipate overtime, plan backfill staffing, and prevent budget overruns before they occur.

Full Text:

PDF

References


Box G.E.P., Jenkins G.M., Reinsel G.C. Time Series Analysis: Forecasting and Control. 5th ed. Hoboken, NJ: Wiley, 2015.

Hyndman R.J., Athanasopoulos G. Forecasting: Principles and Practice. 3rd ed. Melbourne: OTexts, 2021.

Chen T., Guestrin C. XGBoost: A Scalable Tree Boosting System. Proc. ACM SIGKDD. 2016, 785–794p.

Hochreiter S., Schmidhuber J. Long Short-Term Memory. Neural Computation. 1997, 9(8), 1735–1780p.

Breiman L. Random Forests. Machine Learning. 2001, 45(1), 5–32p.

Taylor S.J., Letham B. Forecasting at Scale. The American Statistician. 2018, 72(1), 37–45p.

Makridakis S., Spiliotis E., Assimakopoulos V. The M4 Competition. International Journal of Forecasting. 2020, 36(1), 54–74p.

Cleveland R.B. et al. STL: A Seasonal-Trend Decomposition Procedure. Journal of Official Statistics. 1990, 6(1), 3–73p.

Cascetta E. Transportation Systems Analysis. 2nd ed. New York: Springer, 2009.

Ozdemir M., Kizilaslan R. Workforce Analytics for Public Sector Overtime Management. Public Personnel Management. 2019, 48(3), 345–367p.


Refbacks

  • There are currently no refbacks.