Hide Notes 

Slide 1: Implemented by February 14, 2009
Slide 2: MIS Concept MIS with 1Key MIS data capturing in Tally vis-à-vis 1Key p g y y ◦ Purchase & Sales ◦ Income, Expenses & cost center ◦I Inventory & others h Financial Consolidation MONDIAL’s Offering g ◦ Challenges in Tally ◦ Generating Schedule VI Balance Sheet Implemented by
Slide 3: IT Consultancy •Software Advisory Service •Evaluation Evaluation •Project management • IT Implementation • Process Consulting Cons lting • Interface Development HR Consultancy • Permanent & Temp Staffing • HR Process Implementation • HR Policy & Manual Finance Consultancy • Risk Planning • Retirement Planning • Children Education Plan • Children Marriage Plan • Wealth Creation Planning g Outsourcing • Payroll • Recruitment Implemented by
Slide 4: Strengths Some of the clients ◦ Rich experience p ◦ Vertical expertise ◦ Qualified consultants Implemented by
Slide 5: Definition ◦ Provides periodical standard set of reports to management for decision making g g ◦ Collects information from multiple data sources to generate management reports ◦G Generates exceptional reports for decision making l fd k rather than statutory requirements Implemented by
Slide 6: Definition Data to Decision Other Names Executive Information Systems Decision Support Systems Implemented by
Slide 7: On Time As required yet dynamic Crisp yet detailed Accurate Consistent Comprehensive Implemented by
Slide 8: Business Transactions • Manufacturing • Purchase • Sales • Customer service Business Aid Transactions • Human Resource • Marketing department • Finance department d Other External data • Market Survey • Current information • Data in manual files Implemented by
Slide 9: Employees Corporate databases of internal data Databases of external data Corporate intranet Decision support systems Executive support pp systems Business transactions Transaction p processing g systems Databases of valid transactions Management information systems Application databases Operational databases Drill-down reports Exception reports Demand reports Key-indicator Key indicator reports Expert systems Input and error list Scheduled reports Implemented by
Slide 10: Formats ◦ Graphical p ◦ Comparative ◦ Descriptive Implemented by
Slide 11: Implemented by
Slide 12: Daily Sales - Key Indicator Report Sales - K I di t R Sl Key Indicator Report t Period Total Orders Month to Date Forecasted Sales for the Month This Month 1,808 2,406 2 406 Last Month 1,694 2,224 2 224 Last Year 1,014 2,608 2 608 Implemented by
Slide 13: Formats Analytical y ◦ Graphical p ◦ Comparative ◦ Descriptive ◦ Drill down ◦ Slice & Dice ◦ Ad-hoc queries Implemented by
Slide 14: Implemented by
Slide 15: Implemented by
Slide 16: Formats Analytical y ◦ Graphical p ◦ Comparative ◦ Descriptive ◦ Drill down ◦ Slice & Dice ◦ Ad-hoc queries Exceptional Time scale ◦ Scheduled ◦ Need based Implemented by
Slide 17: Daily Sales Exception Report – ORDERS OVER 10,000 Prepared: 08/10/xx // Order # P12453 P12453 P12453 … … Customer ID C89321 C89321 C03214 … … Sales Rep ID p CAR CAR GWA … … Ship Date 08/12/06 08/12/06 08/13/06 … … Q Quantity y 144 288 12 … … Item # P1234 P3214 P4902 … … Amount 13,214 15,660 11,224 … … Implemented by
Slide 18: Daily Sales Detail Report Prepared: 08/10/xx Order # P12453 P12453 P12453 P124 3 P12455 P12456 Customer ID C89321 C89321 C03214 C52313 C34123 Sales Rep ID CAR CAR GWA SAK JMW Ship Date 08/05/06 08/06/06 08/07/06 08/0 /06 08/08/06 08/09/06 Quantity 144 288 12 24 144 Item # P1234 P3214 P4902 P4012 P3214 Amount 3,214 5,660 1,224 1 224 2,448 720 Implemented by
Slide 19: Positive impact on the bottom line ◦ Increased revenue ◦ Reduced cost Better control Timely business decisions Increased productivity Better strategies g Leverage on investment including in IT High brand equity Implemented by
Slide 20: MIS is a set of integrated collection of functional information systems, each supporting particular functional area Implemented by
Slide 21: Internet An Organization’s Organization s MIS Financial MIS Business transactions Transaction processing systems Databases of valid transactions Accounting MIS Drill down reports Exception reports Demand reports Marketing MIS Key-indicator reports Scheduled reports Business transactions Databases of external data Human Resources MIS Etc. Extranet Implemented by
Slide 22: Provides financial information to all financial mangers in the organization g Implemented by
Slide 23: Strategic plans & corporate policies Transaction Processing Systems (TPS) ◦ Contains major financial objectives and often project financial needs j ◦ Financial budgets at various levels ◦ Financial information from various functional applications viz. payroll, inventory, accounts receivable, accounts payable, general l d i bl t bl l ledger ◦ External sources ◦ Annual reports and financial statements of the competitors & other news items Implemented by
Slide 24: Databases of internal data Databases of external data Financial DSS Business Bi transactions Transaction processing systems Databases of valid transactions for each TPS Financial MIS Financial applications databases Business transactions Operational databases Financial statements Uses and management of funds Financial statistics for control Financial ES Internet or Extranet Business t ti transactions Customers, Suppliers Implemented by
Slide 25: Provides information related to raw material, finished goods, production b h d i batches, productivity, d ii cost sheet cost-sheet etc… to operational and management teams Implemented by
Slide 26: Strategic plans and corporate policies Various TPS: ◦ ◦ ◦ ◦ ◦ Order processing Inventory data p Production process Production benchmarks Various cost components External Sources Implemented by
Slide 27: Databases of internal d t it l data Databases of external data Manufacturing DSS Business transactions Transaction processing systems t Databases of valid transactions t ti for each TPS Manufacturing MIS Manufacturing applications databases Business Bi transactions Operational p databases Quality control reports Process control reports Internet or Extranet Business transactions JIT reports t MRP reports Production schedule CAD output Manufacturing ES Customers, Suppliers Implemented by
Slide 28: Design & engineering Master production scheduling Inventory control Manufacturing resource p a a u actu g esou ce planning g Just-in-time inventory & manufacturing Computer integrated manufacturing (CIM) Quality control and testing Implemented by
Slide 29: Supports managerial activities in product development, distribution, pricing d decision and promotional d l activities Implemented by
Slide 30: Strategic l St t i plan and corporate policies d t li i TPS: TPS ◦ Lead management ◦ Customer Relation ◦ Sales order processing ◦ Competitors data ◦ Market surveys y External Sources Implemented by
Slide 31: Databases of internal d t it l data Databases of external data Marketing DSS Business transactions Transaction processing systems t Databases of valid transactions t ti for each TPS Marketing MIS Marketing applications databases Sales by customer Sales by salesperson Operational O ti l databases Sales by S l b product dt Pricing report Total service calls Customer satisfaction Marketing ES Implemented by
Slide 32: Marketing Research Product development Promotion and advertising Product pricing Implemented by
Slide 33: Need of a powerful application Requirements of the application ◦ ◦ ◦ ◦ ◦ ◦ Provides reports with fixed & standard format Uses existing data in the application y gp User friendly – defining report User based access to data Enables ad-hoc querying on data Enables generating exception reports for better control and decision making ◦A Accessible t as many users as applicable ibl to li bl Implemented by
Slide 34: Implemented by
Slide 35: View Cube Chart Scheduler Single CPU Server for 5 MIS Users across 3 Group Companies Implemented by
Slide 36: 1Key Demo post break Demo…post Implemented by