An Internship Report on MIS-Based Inventory and Sales Management System of NNT Company

Abstract

The Function In the internship, we have to focus on NNT (এন এন টি) which is a Bangladesh-based bags & accessories brand with an online presence and physical store in Dhaka, contributed to how they can facilitate their Inventory and Sales Information Management (ISIM) with benchmarked MIS practices done using Excel. The evaluation is based on genuine public data of NNT and real internship work in preparing reports for the update of product, sale, stock and raw material. Purpose & Scope. In the spirit of MIS, we attempted to: (1) updat e master product data; (2) record daily sales and stock movement transactions; (3) track raw-material in/out as appropriate for production or finishing; and (4) convert this information into actionable KPIs (e.g., turns on stock, sell-through, margin/see by SKU), so managers could make time ly decisions on replenishment pricing, and promotions. (Structure converges to your report guideline and internship activity set). Method. I created a set of 4 interconnected Excel Jems: Product Master, Sales Register, Stock Ledger and Raw-Material Ledger. Stock data was recorded from daily sales/order extracts and internal intake forms; validation rules (lists, types, ranges) were employed to minimize data entry errors. The ledgers reconciled opening + receipts − issues/sales to give closing stock and valuation, the sales register drove pivots and charts by SKU, category, channel and promo flag. The firm internship provided an directly usable (auditable) ISIM toolkit to NNT: facts based masters, reconciled ledgers, and decision-oriented summaries. These assets enhance data quality, expose slow-/fast-movers, protect margins in promotional periods and reduce out-of-stocks—thus benefiting NNT’s retail-side operations, found both online and in-store.