Acct33004 Flowchart Assignment

First review all the flowchart videos on Blackboard and download the Excel flowchart symbols worksheet.Working individually using Excel please creat flowchart from Cathy Apple's interview on the payroll process at Black Squirrel Bikes, a manufacturer of high performance bicycles and bike accessories. Ms. Nightly doesn't mention it, but Black Squirrel Bikes uses SAP as its ERP system.We will learn more about SAP later in the class.

Cathy Apple, from internal audit, interviews Irene Patricia "I.P." Nightly - Payroll Supervisor

CA:Mrs. Nightly, I'm Cathy Apple from internal audit.Thanks for meeting with me.

IP:Cathy, please call me "I. P."What can I do for you?

CA:I need to document the payroll process.I know we produce checks weekly but I am a little unclear on the details.

IP:I think I can help you.First time data are recorded in each department online into the payroll time cards transaction file for office staff and using clocks with badge readers in the warehouse. It is annoying at night when people forget to clock out and we have to record time by hand.We end our payroll week on Sunday and on Monday each department supervisor must review the time card data and approve it by noon.Betsy, the payroll clerk, then prints off a detail time report and reviews all the payroll transaction data submitted to be sure it is complete.She tracks down missing data and enters any corrections.She also gets the file of employee information update transactions from the Human Resources department.Things like change of address, deductions, new pay rate, etc.

CA:Is the file from human resources on paper?

IP:No it is on the computer in Excel.

First, Betsy applies the human resources transactions to update the employee master file by running the master file update process in the payroll system.Then she runs the payroll calculation process using the payroll time cards transaction file and the updated employee master file to generate employees' paychecks. Actually we generate pay stubs to give to the employees; we pay via direct deposit. The money is transfer from our payroll account into the employees' checking account based upon the payroll deposit file generated during the payroll calculation process. We send this file to the bank. Several reports are produced for management.In addition, federal and state withholding reports are produced for tax purposes.

I think that wraps it up.Any questions?

CA:I think I have got it. We have three files, the payroll time cards transaction file, the human resources transactions file and the employee master file.

IP:That is correct.Plus the payroll deposit file we send to the bank. Cathy, what is your favorite sports team?

CA:The Cleveland Indians.How about you I.P.?

IP:The Kent State golden flashes.I love going to the games and cheering them on ... "Get Hot Flashes! Get Hot Flashes!"

CA:Sounds like fun.

Standard_Flowchart_Symbols Q Search Sheet Home Insert Draw Page Layout Formulas Data Review View Share Comments Calibri (Body) 11 A ab Wrap Text General V v Merge & Center v 00 30 Conditional Format Cell Insert Delete Format Sort & Paste A Find & B Formatting as Table Styles X v Filter Select E101 X V fx B G H M N 0 P Q R U V W X Z AA Standard Flow Chart Symbols for 33004; 43014; 53014 W N excel Insert=> Shapes => Flowchart Start / End Terminator vendor [begin or end] connectors off page 2 16 17 on page A 20 21 Input / Output 22 Keying [entry] inventory adj. Report [s] Check P.O. 32 35 6 Process / Decission 37 38 Update Schedule Computer Process 40 41 42 43 Sheet1 Sheet2 Sheet3 + + 100%Standard_Flowchart_Symbols Q Search Sheet Share Comments Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 A ab Wrap Text General V v Merge & Center v 00 -30 Conditional Format Cell Insert Delete Format Sort & Find & Paste BI UV A Formatting as Table Styles X v Filter Select E101 X V fx AA B C D E F G H K M N P Q R U V W X Z 43 44 Review 45 Manual Operation and File 46 47 48 49 50 51 Decision 52 > 5? no yes 59 60 61 62 Disk [data storage] 64 Employee 65 file 66 67 68 Manual File sequence: A- alpha or N - numeric tape [backup] back 81 82 83 84 Connections / Data Flow 85 Sheet1 Sheet2 Sheet3 + - + 100%Standard_Flowchart_Symbols Q Search Sheet Share Comments Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 A ab Wrap Text General V v Delete Sort & Find & Paste BIUV A = Merge & Center v 00 -30 Conditional Format Cell Insert Format Formatting as Table Styles X v Filter Select E101 X V fx E F G H M N P Q R U V W X Z AA A B C D 81 82 83 84 Connections / Data Flow 85 86 87 lines 8 8 low one-way 89 bidirectional S nmunication link 123 124 Sheet1 Sheet2 Sheet3 + + 100%