Excel Coursework - Engineering Hours Accounting System.
Member rating: No Rating | Words: | Submitted: Fri Apr 02 2004
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Excel Coursework - Engineering Hours Accounting System Analysis 2 Introduction 2 The Current System 2 Objectives of The New System 2 Performance Indicators 2 Design 3 Choice of Software 3 Systems Overview 3 Detailed Design 3 Workbook and Sheet Discussion 10 Data entry and Validation 11 User Aids to Operation 12 Protection 12 Macros 13 Data Flow Diagram 14 Analysis Introduction Avitronics is a medium sized engineering company that produces components for the aerospace industry. Employees keep track of the hours they work on different projects and at the end of the week turn in a timecard with this information on it. The company can take up to roughly 12 contracts a year; each of these contracts is assigned a 'Job-Code'. The Current System At present each employee keeps track of their hours using their own system. This could be as informal as a rough tally on a scrap of paper. At the end of the week, the employees fill their hours into a formal timecard, which is handed in and tallied by a clerk. Objectives of The New System Mr. Salomon (the chief accountant)...


