• Nasima Akter

Small businesses account for ~46% of U.S. private employment and face recurring inventory and workforce challenges. Industry estimates place global retail inventory distortion at about $1.77 trillion (2023); U.S. retailers lost roughly $82 billion to stockouts in 2021. In July 2025 the retail trade quits rate was 2.5%, which exacerbates staffing shortages. The article proposed Smart Supply and Workforce Analytics toolkit that can be configured by a small business within weeks using the standard BI software. The toolkit is a combination of three items that are complementary: 1) ABC-XYZ inventory segmentation to concentrate on high value, stable-demand SKU; 2) a light forecasting step to flatten demand expectations; and 3) a basic workforce alignment perspective to align staff to the demand curve hour and day by day. I model the methodology using public sources of data and a sample dataset of retail transactions. I want to ensure that this can be replicated: all figures, tables, as well as KPIs are constructed in such a way that they can be reassembled by another analyst in a short period of time. The actual meaning of this is that an owner or analyst is provided with a short list of SKUs to guard, definite rules about when to order again, and a plan on staffing the business, which is expected to operate during high periods rather than respond to them. It is practically useful and easy-to-implement policy: how to decrease stockouts, idle workers and enhance service at a scale that matters in communities where small companies continue to be the keystone to local job creation

workforce analytics; retail SMEs; Power BI; inventory distortion; staffing alignment. ABC–XYZ; reorder point (ROP);

"Smart Supply & Workforce Analytics: A Business Intelligence Toolkit for Small Enterprise Resilience ", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.12, Issue 9, page no.f434-f446, September-2025, Available :http://www.jetir.org/papers/JETIR2509556.pdf

"Smart Supply & Workforce Analytics: A Business Intelligence Toolkit for Small Enterprise Resilience ", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.12, Issue 9, page no. ppf434-f446, September-2025, Available at : http://www.jetir.org/papers/JETIR2509556.pdf