CENTRALIZATION OF TIME AND ATTENDANCE RECORDS THROUGH ELECTRONIC TRANSFER
Prepared for: Frank Smith, Controller
Acme Partners, L.L.P.
Prepared by: John Doe, Analyst
Information Technology Department
Acme Partners, L.L.P.
December 9, 2004
In order for the General Managers and Theme Managers to perform labor analysis, the Office Administrators must run reports from Time Helper (TMH) and then spend many hours a week formulating summary reports in Microsoft Excel and then fax them between the restaurants within their Theme, only to have that same information re-keyed in order to produce Theme level reports. By the time this information reaches its final destination, it is often stale by a week. This report describes a project to automate and expedite the delivery of time and attendance records and the production of timely analysis reports.
Keywords: Time Helper, TMH, Labor, Windows Management Interface, WMI, Microsoft Report Services, Crystal Reports
INFORMATIVE ABSTRACT
In order for the General Managers and Theme Managers to perform labor analysis, the Office Administrators must run reports from Time Helper (TMH) and then spend many hours a week formulating summary reports in Microsoft Excel and then fax them between the restaurants within their Theme, only to have that same information re-keyed in order to produce Theme level reports. By the time this information reaches its final destination, it is often stale by as much as a week.
A next day polling routine, initiated at the corporate office level, and automated report generation would reduce the production hours and speed the flow of data. The restaurants would populate a centralized Microsoft SQL Server database and standardized ...