Database Answers Job Costing from the Principles of Accounting (Click for Web Site)

Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Job Costing and_profitability
Back to the Data Model
The Draft Business Rules have been defined and are listed below.
The Area being Modelled is Job Costing and Profitability:-
A. This is a Statement of the Requirements.

The requirement To track the material and labour costs of a Job so profit can be calculated from this. To track who did what in the course of getting that Job done. Conceptually A Job is requested by a Client. Each Job is completed after a series of Subjobs are done. Each Subjob is done by a Worker. Each Subjob has an associated Material cost. Each Worker has an associated Labour rate cost. Practically Each Job is registered to a Client for a Job Type and given a Job number. The Payment amount for the Job is also recorded. The Worker registers the Subjob for that particular Job putting in details of who did it, what type of subjob was done, when it was started and when it was finished. Problems with reporting history There are two derived data values in what is required of this system: Subjob labour cost: subjob hours times worker's labour rate cost Profit: Job payment minus total Job cost (material plus labour cost). Since material and labour costs will change with time, I believe there would be problems with historically comparing Subjob labour cost and Profit from one year to another with the current schema since there is only a single field to record the values from which the data in question is derived? That being the case, is this where the the "date from" field comes in as shown in your Tutorial ? Thanks! Kevin
B. The Things of Interest, ('THINGS'), include :- B.1 Clients B.2 Jobs B.3 Sub Jobs B.4 Workers B.5 Others to be determined. C. These THINGS are Related as follows :- C.1 To be determined. D. Other Characteristics of these THINGS include :- D.1 To be determined. E. Sample Data includes :- E.1 To be determined. F. Typical Enquiries include :- F.1
Barry Williams
January 29th. 2010
Principal Consultant
Database Answers
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map