Abstract:
Management Information System (MIS) facilitates the sales administration functions at Akij Venture, Ltd. (AVL) by converting routine field activities into verifiable transactions, manageable claims, and actionable management information for informed decision-making. The study also demonstrates that Management Information Systems (MIS) provide efficient and direct ways of performing jobs in the real world that require the sales information chain by facilitating direct job execution — such as the creation of TA/DAs (Travel Allowance/Dearness Allowance) or in-depth incentive calculations — monitoring ERP and spreadsheet workflows, and reviewing the internal dashboards and templates to help companies tee up sales strategies and get into their right buyer audiences. Managers can look for problems and identify possible shortfalls and MIS allows their data to be customized with input-role and output-role separating MIS functions within and between functional areas that deal with specific segments of data: logistics planning, for example, handling sales, or accounts management, for example, dealing with logistics, inventory or performance planning and sales or with accounts – to provide best insight across a business unit or the company. The internship identified a variety of challenges, including an ongoing dependence on spreadsheets for temporary calculations, inconsistency in master data management (e.g., customer, SKU, and route codes), and access restrictions for new users, which can extend cycles or require reconciliation at month-end. It has recommended the implementation of workflow-based TA/DA and incentive calculators within the ERP. To mitigate Formula Drift, improve Master Data Governance and Audit Trails, integrate exception alerts into self-service dashboards and guarantee consistent provision of Role-based Access and refresher SOP training across all domains. The aim of this consolidation is to optimize rework, accelerate approval and settlement processes, and build trust into Sales Admin's data so that AVL is able to make swifter tactical decisions and plan ahead with improved certainty across all product categories and regions.
