Smart Multi-Branch Stationery Shop ERP with Demand Forecasting and Stock Reorder Planning

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.