Assignment: Data Conversion for ERP System

NOTE: This is a simplified version of a process for the purpose of illustrating flowcharting techniques.

NARRATIVE

The Consultant sends a Proposal to the CEO. The CEO returns an Approved Proposal back to the Consultant. The Consultant prepares a Project Plan using the Microsoft Project Program which adds a new record to the Project Master file. The Database Administrator creates a project data environment using the ERP Program which retrieves data from the Database Master files and Database Transaction files.

The Programmer downloads data from the current ERP system using the ERP Program, the Database Master files, and the Database Transaction files. The Programmer then massages the data to conform to the new ERP system using the Data Utilities Program which updates the Database Master files and the Database Transaction files. The Programmer prints two copies of the Data Exception Report using the ERP Program and Data Exception Transaction file. Copy 2 of the Data Exception Report is sent to the Consultant.

After reviewing the Data Exception Report, the Consultant corrects the data errors using the ERP Program which updates the Database Transaction and Data Exception Transaction files. The Consultant then prints fours copies of the Data Status Report using the ERP Program and Database Transaction files. Copy 2 of the Data Status Report is sent to the CFO, Copy 3 is sent to the Database Administrator, and Copy 4 is sent to the Programmer.

The Programmer files the Data Status Report and Data Exception Report in the Projects Completed file cabinet by client name then by date. The Database Administrator moves the project data to the production environment using the ERP Program which adds new records to the Database Master and Database Transaction files. The Database Administrator prints three copies of the Project Status Report using the ERP Program, Database Master, and Database Transaction files. Copy 2 of the Project Status Report is sent to the CFO and Copy 3 is sent to the CIO. Finally, the Database Administrator files the Data Status Report and Project Status Report in the Data Projects file cabinet by project number.

After approving the Project Status Report, the CFO makes two photocopies of the approved report. The first Photocopied Project Status Report is sent to the CIO, and the second copy is sent to the Consultant. Finally, the CFO files the Data Status Report and Project Status Report in the Projects Approved file by date. The Consultant files the Approved Proposal, Project Plan, Data Exception Report, Data Status, and Project Status documents in the Completed Projects file cabinet by client name then by date.

INSTRUCTIONS:

Create one file in Excel with two worksheets (use a new, blank file).

Include your first and last name in the file name.

Name the first worksheet "Table" and create a Table of Entities and Activities.

Name the second worksheet "Flowchart" and create a Document Flowchart.

ACADEMIC INTEGRITY: This is not a group project. Do not showyour SysDoc files to any other student. Students who turn in another student's fileor a portion of another student's file,and students who share their file with any other student, may receive a zero on the assignment. Additional penalties for turning in another student's work as though it was your own, or for sharing your work with others,may include a grade of "F" in the course that cannot be removed by any forgiveness policy or by dropping the course, a notation on the student's transcript stating that the student violated the Code of Academic Integrity, and expulsion from the University or the School of Accounting. See the Academic Integrity sections of the syllabus for more information on this process.