ACC306 Chapter 2 Part 2Study Notes on Data Processing Cycle and ERP Systems

Data Processing Cycle

Definition of Data Processing

  • The third step in the data processing cycle is data processing.
  • It encompasses various activities that transform raw data into meaningful information.

Types of Data Processing (CRUD)

  • The acronym CRUD helps to remember the four types of data processing:
    • Create:
    • Involves adding new records to a database.
    • Examples include:
      • Adding a customer to the database.
      • Adding an employee to the payroll file.
      • Adding a new item to the inventory.
    • Read:
    • Involves viewing existing data.
    • Examples include:
      • Viewing customer records.
      • Updating previous records or data.
    • Update:
    • Aligns with activities that modify existing records.
    • For example:
      • Updating the inventory with new stock counts.
      • Updating financial data.
    • Delete:
    • Involves removing records that are no longer needed.
    • Examples may include:
      • Deleting a vendor from the vendor master file if no longer in business with them.
      • Deleting customers that the company has stopped doing business with.
      • Removing employees who have left the company.

Data Processing Methods

  • Data can be processed in two main ways:
    • Batch Processing:
    • Involves collecting and processing data at specified intervals.
    • Examples include:
      • Updating general ledger accounts once at the end of the month.
      • Gathering checks and depositing them all at the end of the day.
    • Real Time Processing:
    • Data is processed immediately as it is inputted.
    • Examples include:
      • Purchasing airline tickets, where seats must be updated instantly.
      • Registering for classes, ensuring enrollment reflects current availability.
  • Tasks: Analyze problem 2.6 to classify scenarios between batch or real-time processing.

Information Output

  • The last step of the data processing cycle is to produce information output.
  • Defines the resultant useful information generated from processed data:
    • Formats for output:
    • Online output: soft copy available digitally.
    • Printed output: hard copy documents.
    • Types of documents:
      • Operational documents: different from source documents; e.g., sales invoices.
      • Reports: examples include monthly sales reports, managerial reports, financial statements.
    • A query: asking the database a question to retrieve specific data, leading to answers that qualify as output.
    • Financial statements for external users include:
    • Balance sheet
    • Income statement
    • Statement of owners' equity
    • Statement of cash flows
  • Budgeting by managers also constitutes an important informational output for strategic planning.

Enterprise Resource Planning (ERP)

Definition and Importance of ERP

  • Enterprise Resource Planning (ERP) is introduced in this segment.
  • An ERP is more than an accounting information system; it integrates all functions within an organization into a single system.

Key Features of ERP

  • Support integration across various activities of a company, including:
    • Financial data
    • Non-financial data:
    • Customer relations, production, project management.
  • Benefits include:
    • Data is captured and stored once, which can be accessed by all employees and managers.
    • Enhanced data protection due to centralized data storage.
    • Standardized procedures lead to easier data retrieval and improved customer service.
    • Increased organizational productivity through better operational efficiency.

Drawbacks of ERP

  • Despite the advantages, ERP systems come with significant drawbacks:
    • Cost: Implementing an ERP is often expensive, making it difficult for smaller or less profitable companies to justify.
    • Time and effort: Implementation demands significant resources from both the organization and its employees.
    • Standardization challenges: Some companies may have unique procedures tailored to various departments, and enforcing standardization may not always be beneficial.
    • Complexity: Resistance from employees may arise due to the complexity of learning new systems and processes.

Conclusion

  • ERP systems are valuable for integrating all departments of a firm, providing both benefits and challenges.
  • Emphasis on the importance of careful consideration before implementation due to potential resistance and costs.