Adriatic Plumbing Supply Corp has a warehouse and a small administrative officeAlexei and his wife Sonia are the owners. They deal with customers and vendors. The one operating department, a warehouse, has 9 hourly personnel, and is managed by Stefan [not a family member]. The following narrative describes the procedures for processing the warehouse payroll every week.

Narrative

Stefan is responsible for initiating the weekly payroll activity for hourly employees. He collects the time cards and totals the hoursfor each employee. Then, he enters each employee's name and hours worked on a payroll spreadsheet. Stefan then forwards copy 1 of the spreadsheet to Sonia.He files copy 2 of the spreadsheet in a file by week, with the time cards, which are arranged alphabetically by employee name.

Sonia reconciles the spreadsheet to the paychecks and then prepares and signs each paycheck. She enters the checks in the check register, files the spreadsheet and the copies of the checks, by date. She delivers the checks to Stefan.

Stefan distributes the checks to the appropriate employees.

Note:This is not a complete description of a payroll system, Several required steps have been omitted for simplicity.

Prepare a flowchart of the following procedures in Excel.

Background