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.
