Smart Multi-Branch Stationery Shop ERP with Demand Forecasting and Stock Reorder Planning
Raja Sundaram R S
Department of Computer Science Engineering SRM Institute of Science and Technology Chennai, India rajasundaramtraining@gmail.com
Manav R
Department of Computer Science Engineering SRM Institute of Science and Technology Chennai, India
mg3001328@gmail.com
Jack Samson D S
Department of Computer Science Engineering SRM Institute of Science and Technology Chennai, India jacksamson282@gmail.com
J Juslin Sega
Department of Computer Science Engineering SRM Institute of Science and Technology Chennai, India
juslinsj@srmist.edu.in
Abstract—A wide range of problems related to inventory coordination, sales monitoring, vendor management, and stock replenishment arise in the case of running multiple branch stationery companies. The use of manual bookkeeping, spread- sheets, and separate billing systems by many enterprises re- sults in lack of stocks, excesses, late replenishment decisions, and unsynchronized branch work. In order to eliminate the mentioned problems, the purpose of this paper is to propose an innovative Smart Multi-Branch Stationery Shop ERP with Demand Forecasting and Stock Reorder Planning. The offered ERP includes the following modules: branch management, role- based user control, products and categories administration, vendors administration, billing, inventory management, stock transfers, and reporting tools. Besides, there is implemented a forecast and reorder feature, based on the analysis of the recent sales trends to estimate the future demand and place appropriate orders. The development process used Next.js, React, TypeScript, Prisma ORM, and SQLite technologies. The developed ERP has multiple types of users with different roles: super administrator, branch manager, biller, and inventory worker. With help of the forecasting and reorder function, the risk of out-of-stock situations can be minimized, since this will make inventory more available, as well as inter-branch transfers will help to avoid redundant purchases.
Index Terms—ERP, multi-branch inventory, stationery shop, demand forecasting, reorder planning, stock transfer, billing system, retail management.
