Application Controls, a Case Study

Topics: Table, Computer program, Data validation Pages: 4 (513 words) Published: December 16, 2012
A.
1. Main Inputs and Data to the system are:

* Clock CardsPayroll number
Department
Week Number
Name
Hours worked
Salary

* TimesheetsPayroll Number
Department
Week Number
Name
Holiday Hours
Overtime Hours
Hours Worked
Rate per hour
Salary

* Variance ReturnsDepartment
Period (Month/Week number)
Budgeted Salary to be paid (weekly/monthly)
Actual Salary Paid (weekly/monthly)
Variance

* Commission RatesPayroll Number
Department
Name
Sales
Rate (%)
Commission Pay

* Batch Header RecordsBatch Number
Batch Type
Batch Date
Batch Description
Batch Count
Batch Amount

* Productivity ReportDepartment
Period
Budget Cost/Forecasted Sales
Actual Cost/Sales
Efficiency Rate

2. Batching of data input and batch fields

* Clock CardsBatch <50
Batch Header showing
Job Code
Input Type Code
Week Number
Total Number of Records
Total Hours worked

* TimesheetsBatch<50
Batch Header showing
Job Code
Input Type Code
Job Description
Week number
Total Number of Records
Total Number of Hours worked
Total Amount Paid

* Commission RatesBatch <50
Batch Header showing
Job code
Input Type Code
Job Description
Period Number
Total Number of Records
Total Sales
Total Commission Pay

3. Validation of data at the data preparation stage
* Clock cardsPayroll number check digit
Week number range (1-53)
Hours worked range checked
Record format check
Record completeness check

* TimesheetsPayroll number check
Week number range (1-55)
Hours worked check (including OT and Holiday)
Record format check
Record completeness check
Hourly rate update check

* Commission RatesPayroll number check
Sales for the period check
Commission rate update check
Record format check
Record completeness check

* Batch Posting/inputBatch Total record check
Batch Total amount...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • case study on principles, application and tools Research Paper
  • Case Study Essay
  • case study Essay
  • case study Essay
  • Case study Essay
  • Essay about Management Control System Case Study
  • Essay on Case Study on Inventory Control
  • Internal Control Case Study Essay

Become a StudyMode Member

Sign Up - It's Free